Understanding your QBO sales number is one of the most critical skills for any business owner or accounting professional using QuickBooks Online. Your sales number is more than just a figure on a report โ it represents the total revenue your business has generated within a specific period, and knowing how to accurately track, interpret, and act on this data can be the difference between growing a profitable operation and making decisions based on flawed information. Whether you are a sole proprietor just getting started or a ProAdvisor managing dozens of client files, mastering sales tracking in QBO is non-negotiable.
Understanding your QBO sales number is one of the most critical skills for any business owner or accounting professional using QuickBooks Online. Your sales number is more than just a figure on a report โ it represents the total revenue your business has generated within a specific period, and knowing how to accurately track, interpret, and act on this data can be the difference between growing a profitable operation and making decisions based on flawed information. Whether you are a sole proprietor just getting started or a ProAdvisor managing dozens of client files, mastering sales tracking in QBO is non-negotiable.
QuickBooks Online organizes sales data across multiple reports, dashboards, and transaction records, giving users several pathways to access their total sales figures at any given moment. The Sales Overview report, the Profit and Loss statement, and the individual Transaction List by Customer report all present sales numbers in slightly different formats and levels of detail. Knowing which report to pull for which purpose โ and understanding how each one calculates your total โ is a foundational skill that separates average QBO users from power users who can close books accurately and quickly.
One common area of confusion for new QBO users involves the difference between gross sales, net sales, and taxable sales. Gross sales represent the total value of all invoices and sales receipts before any deductions. Net sales subtract returns, allowances, and discounts from that gross figure. Taxable sales represent only the portion of revenue subject to sales tax collection, which varies by product type, customer location, and state law. Misreading these three figures โ or conflating them โ can lead to inaccurate financial reporting and even sales tax compliance problems.
For businesses that operate across multiple product lines, locations, or customer segments, QBO offers powerful filtering and class-tracking tools that allow you to break down your sales number by virtually any dimension. You can filter your sales data by customer, by product or service item, by location, by class, or by custom field. This granular view helps business owners identify which revenue streams are performing well, which products have declining sales velocity, and where to focus sales and marketing resources for maximum return on investment.
The QBO ProAdvisor certification exam tests candidates on their ability to navigate sales tracking features, customize sales reports, and troubleshoot common discrepancies between different sales figures. Students preparing for the exam frequently find that hands-on practice with real or sample company files is the most effective way to internalize how QBO computes and displays sales numbers. Practice quizzes and sample questions are equally valuable, as they expose candidates to the specific phrasing and scenario-based logic the exam uses to assess competency.
Sales number discrepancies are among the most frequently reported issues by QBO users, and they almost always stem from one of a handful of root causes: undeposited funds not yet applied, invoice payments recorded in the wrong account, sales tax incorrectly included in or excluded from revenue totals, or timing differences between accrual and cash-basis reporting. Learning to diagnose these discrepancies systematically โ rather than guessing โ is a skill the QBO ProAdvisor curriculum emphasizes heavily. Reviewing qbo sales number tracking alongside contractor payment reports can also reveal misclassified expenses that distort net income.
This guide covers everything you need to know about QBO sales numbers: where to find them, how to customize sales reports, how to reconcile discrepancies, and how to use sales data to drive better business decisions. Whether you are studying for the ProAdvisor exam or simply trying to get a better handle on your business financials, the sections below will give you a structured, comprehensive roadmap through one of QBO's most important feature sets.
Navigate to the Sales menu in the left sidebar and click Overview. This dashboard displays your total sales for the current month, outstanding invoices, and recent activity in a single glance. It is the fastest way to get a high-level sales number without running a formal report.
Go to Reports and search for Sales by Customer Summary. This report breaks down your total sales number by individual customer, helping you identify your highest-revenue accounts. You can filter by date range and compare periods to spot trends in customer spending over time.
The P&L report under Reports > Business Overview shows your total income at the top, which represents your net sales number after discounts and returns. This is the figure most accountants and lenders refer to when assessing business revenue and is the standard for tax preparation purposes.
For a transaction-level view, run the Transaction List by Date report filtered to show only invoices and sales receipts. This granular report lets you verify individual sales entries, spot duplicate transactions, and confirm that every sale recorded matches a real customer interaction or delivery.
Any QBO sales report can be exported to Excel or Google Sheets using the Export icon at the top of the report window. Once exported, you can build pivot tables, create custom charts, or compare your QBO sales number against external CRM data or POS system totals for a full reconciliation.
Customizing sales reports in QuickBooks Online is where QBO's real analytical power becomes apparent. The default report layouts give you a starting point, but virtually every report in QBO can be modified to show exactly the data you need, filtered by the dimensions that matter most to your business.
To customize any report, simply open it and click the Customize button in the upper right corner. From there, you can adjust the date range, accounting method, grouping, and which columns appear in the output. These customizations can be saved as named report templates so you never have to re-configure them from scratch.
One of the most useful customizations for sales tracking is switching between accrual and cash accounting methods. Under the accrual method, a sale is recorded when the invoice is issued, even if payment has not yet been received. Under the cash method, the sale only registers when the payment actually lands in your bank account. This distinction can create significant differences in your reported QBO sales number for any given period, particularly for businesses that carry large accounts receivable balances or deal with slow-paying customers. The ProAdvisor exam frequently tests this concept with scenario-based questions.
Grouping and subtotaling options within QBO reports allow you to restructure how sales data is presented without changing the underlying numbers. For example, you can group the Sales by Product/Service report by product category instead of by individual item, which gives management a high-level view of which product lines are driving revenue. You can also add columns for percentage of total, prior period comparison, and dollar variance โ all within the same report. These additions transform a basic sales summary into a management-ready dashboard in just a few clicks.
Filters are another powerful customization tool within QBO sales reports. You can filter by customer type, by location (if you use the Locations feature), by class (useful for multi-department businesses), or by any custom field you have set up in your QBO company file. For example, a construction company might filter sales by project type โ residential versus commercial โ to compare the profitability of each segment. A retail business might filter by product category to identify seasonal bestsellers and slow-moving inventory that needs markdown attention.
Saved customizations in QBO function as personal report templates that persist between sessions. Once you save a customized report, it appears under the Custom Reports section of the Reports menu, available to any user with sufficient permission levels. ProAdvisors managing multiple client files should note that saved reports are company-file specific โ a template saved in one client's file does not transfer automatically to another. However, you can replicate the settings manually or use QBO's export function to document your configuration for reference when setting up similar reports in other files.
Scheduled reports are a feature many QBO users overlook, but they are extremely valuable for businesses that need regular sales visibility without logging in to run manual reports. You can configure QBO to automatically email a sales report โ including your total sales number for the week, month, or quarter โ to any email address on a recurring schedule.
This feature is available in QBO Plus and Advanced plans and is particularly useful for business owners who want regular updates without having to log in to the platform themselves. The email delivery includes a PDF attachment of the report as of the scheduled run date.
When working with sales report customizations on behalf of clients, ProAdvisors should document each saved report template and its intended purpose in the client's engagement notes. Clients frequently change their QBO subscription tier or have team members modify reports inadvertently, which can cause saved customizations to behave differently or disappear entirely. Maintaining a documented record of which reports are configured, how they are filtered, and what business question each one answers ensures continuity of reporting quality even when personnel or subscription changes occur within the client organization.
Invoice-based sales tracking is the most common method for service businesses and B2B companies in QBO. When you create an invoice, QBO records the sale immediately under the accrual accounting method, increasing your accounts receivable and your total sales number at the same time. The invoice remains open until the customer pays, at which point QBO moves the amount from accounts receivable to your bank account without creating a duplicate income entry.
The advantage of invoice-based tracking is that it gives you a forward-looking view of expected revenue, which is critical for cash flow planning. Your QBO sales number under this method reflects what you have earned, not just what you have collected. This distinction matters enormously during periods of rapid growth when you may have significant outstanding receivables that do not yet appear as cash in the bank but do represent real, earned revenue that is owed to your business.
Sales receipts are used when a customer pays at the time of sale โ common in retail, food service, and any cash-on-delivery business model. In QBO, a sales receipt records both the income and the payment simultaneously, so there is no open receivable balance created. Your QBO sales number updates in real time as sales receipts are posted, making the cash-method and accrual-method totals identical for this transaction type since payment and sale occur at the same moment.
Many retail businesses integrate QBO with point-of-sale systems that automatically create sales receipts in QBO at the end of each business day. This integration means the QBO sales number is always current without requiring manual data entry from the bookkeeper. However, integration errors โ such as duplicate imports or mismatched item codes โ can artificially inflate your sales total and must be audited regularly to ensure the figures in QBO match the actual POS system records and daily deposit totals.
Estimates and sales orders in QBO do not directly impact your sales number โ they are non-posting transactions that represent potential or committed revenue, not earned revenue. An estimate becomes a sale only when it is converted to an invoice, and a sales order (available in QBO Advanced) only affects your sales number when fulfilled and invoiced. This distinction is important for businesses that receive large project commitments: the commitment itself is not revenue until goods or services are delivered and billed.
ProAdvisors frequently explain to clients that a high estimate or sales order backlog is a positive leading indicator but should not be confused with actual sales. QBO's open estimate report and open sales order report allow businesses to track committed pipeline separately from confirmed revenue, giving management a two-layer view of both current sales performance and near-term revenue expectations. Converting estimates to invoices accurately and promptly is a best practice that keeps the gap between pipeline and reported sales number manageable.
The single most common reason a QBO sales number does not match bank deposits is the Undeposited Funds account. When payments are received in QBO but not yet matched to a bank deposit, they accumulate in Undeposited Funds โ a holding account that inflates your accounts receivable or creates timing gaps in your cash flow report. Always check Undeposited Funds first when your sales total does not reconcile with your bank statement. Clearing this account regularly prevents compounding errors across reporting periods.
Advanced sales analysis in QuickBooks Online goes well beyond simply knowing your total revenue for the month. QBO offers a suite of tools that allow users to compare sales performance across time periods, product lines, customers, and geographic locations, providing the kind of multi-dimensional insight that was previously only available through expensive business intelligence software. For ProAdvisors, mastering these advanced tools positions you as a strategic advisor rather than just a bookkeeper, which dramatically increases the value you deliver to clients and the fees you can justify charging.
The Sales by Product/Service Detail report is one of the most powerful tools in QBO's analytical arsenal. This report shows every transaction for every product or service item within the selected date range, including the quantity sold, the unit price, and the total revenue generated. By sorting this report by total revenue, you can quickly identify your top-selling items and your underperformers. More importantly, you can compare the report across two periods โ for example, Q1 of this year versus Q1 of last year โ to identify growth trends and seasonal patterns that should inform purchasing, staffing, and marketing decisions.
Class tracking is a feature in QBO Plus and Advanced that adds a powerful additional dimension to your sales analysis. By assigning a class โ such as a department, product line, or business segment โ to each transaction, you can filter every sales report by class and see exactly how much revenue each segment is generating. A business with multiple service lines might use classes to compare the profitability of its consulting services versus its software licensing revenue, enabling management to make data-driven decisions about where to invest growth resources and which segments may need restructuring or sunsetting.
Location tracking, similarly available in QBO Plus and Advanced, allows multi-location businesses to segregate their QBO sales number by physical or logical location. A restaurant chain might use location tracking to compare sales performance across its three locations, while a regional distributor might use it to compare sales by territory. The Profit and Loss by Location report โ generated automatically when location tracking is active โ shows revenue, cost of goods sold, and gross profit broken out by location, giving operations teams a clear view of which units are meeting targets and which need attention.
Budget versus actual reports are another advanced analytical tool that transforms your QBO sales number from a historical record into a forward-looking management instrument. By setting up an annual or quarterly sales budget in QBO, you can run the Budgets vs. Actuals report at any time to see exactly how your actual sales are tracking against plan.
Variances are displayed in both dollar and percentage terms, making it immediately obvious whether you are ahead of or behind target. For ProAdvisors working with business-owner clients, presenting this report in monthly check-in meetings is one of the most concrete ways to demonstrate the strategic value of proper QBO configuration.
Customer profitability analysis is a sales-adjacent capability in QBO that many users do not fully exploit. By combining the Sales by Customer Summary report with expense data filtered by customer, you can estimate the profitability of each customer relationship โ not just the revenue it generates.
Some customers who appear to be high-revenue accounts turn out to be unprofitable once you account for the time spent on revisions, the cost of returns, or the sales discounts granted to retain their business. Identifying these customers early and either renegotiating terms or gracefully transitioning them out of the portfolio can significantly improve overall business profitability without requiring any new customer acquisition.
Forecasting future sales using historical QBO data is a skill increasingly expected of ProAdvisors as clients become more sophisticated in their financial management demands. While QBO does not have a built-in forecasting module, the export-to-Excel functionality combined with historical sales reports provides all the raw data needed to build simple trend-based forecasts.
By plotting monthly sales totals over 12 to 24 months and applying a linear or seasonal trend model, you can project revenue for the next quarter or year with reasonable accuracy โ and then use QBO's budgeting feature to load those projections back into the system for ongoing variance tracking.
Preparing for the QBO ProAdvisor certification exam requires a solid understanding of how QuickBooks Online computes, displays, and allows users to manipulate sales data. The certification exam is structured to test both conceptual knowledge and practical application, meaning you cannot pass simply by memorizing definitions โ you need to understand how the features actually work within the software and how different settings and configurations affect the numbers you see in reports.
The sales and income tracking section of the exam is consistently one of the areas where candidates lose the most points, making it a priority study topic for anyone serious about earning the credential.
The exam frequently presents scenario-based questions that describe a specific business situation and ask which report, feature, or configuration option best addresses the need. For example, a question might describe a client who wants to see their total sales broken down by product category for a specific quarter, compared to the same quarter in the prior year. The correct answer requires you to know that the Sales by Product/Service Summary report supports prior period comparison columns and can be grouped by category โ not just by individual item. This kind of nuanced knowledge comes from hands-on practice, not passive reading.
One of the best study strategies for the sales portion of the ProAdvisor exam is to work through QBO's sample company file โ Craigs Design and Landscaping Services โ and deliberately create sales scenarios that test your understanding of each report type. Create an invoice, receive partial payment, record a credit memo, and then run the Sales by Customer Summary and the Accounts Receivable Aging reports to see how each transaction affects the numbers. This hands-on practice builds the kind of intuitive understanding that helps you answer scenario questions quickly and accurately under exam conditions.
Understanding the relationship between your QBO sales number and your 1099 reporting obligations is another area where the ProAdvisor exam intersects practical accounting knowledge. Businesses that pay contractors must issue 1099-NEC forms for qualifying payments, and the underlying transaction data in QBO must be accurately categorized to support this reporting. Reviewing how qbo sales number data connects to contractor payment tracking helps you understand the full picture of how QBO manages both revenue and expense reporting from a tax compliance perspective.
Time management during the ProAdvisor exam is critical. The exam consists of multiple sections with recommended time allocations, and candidates who spend too much time on any single question risk running out of time for sections they could have answered quickly. For the sales tracking portion specifically, questions about report customization and accounting method differences tend to be more time-consuming because they require you to mentally simulate what QBO would show in a given scenario. Practice answering these types of questions under timed conditions so you develop a rhythm that keeps you moving through the exam at a sustainable pace.
Study resources for the QBO ProAdvisor certification include Intuit's own ProAdvisor training courses, which are available free through the QuickBooks Online Accountant platform. These courses cover the exam curriculum in detail and include hands-on exercises within sample company files. Supplementing these official resources with third-party practice quizzes โ particularly those focused on sales tracking, financial reporting, and bank reconciliation โ helps you identify weak areas before the actual exam and build the confidence that comes from repeated correct practice under realistic testing conditions.
After passing the exam, certified ProAdvisors are expected to maintain their certification annually by completing continuing education requirements and retaking the updated exam when Intuit releases new versions. Sales tracking features in QBO are updated regularly as Intuit adds new reports, modifies existing report layouts, and introduces new integrations with third-party e-commerce and point-of-sale platforms. Staying current with these changes through the ProAdvisor community, Intuit's release notes, and continuing education courses ensures your sales tracking knowledge remains accurate and actionable for the clients who depend on your expertise.
Practical tips for getting the most out of QBO's sales tracking features begin with a clean chart of accounts setup. Every income account in your QBO company file should correspond to a specific, meaningful revenue category for your business. Avoid using a single catch-all income account for all sales, because this makes it impossible to generate meaningful sales breakdowns by product type, service line, or customer segment.
A well-structured chart of accounts, designed at the outset with reporting in mind, pays dividends every time you need to pull a sales number for a specific purpose โ whether for a tax return, a loan application, or an internal performance review.
Reconciling your QBO sales number against third-party data sources is a best practice that catches errors before they compound. If you run an e-commerce business integrated with Shopify, Amazon, or another platform, you should reconcile the sales totals reported in your QBO company file against the sales reports generated by those platforms at least monthly. Differences can arise from timing of transaction imports, currency conversion rounding, fees netted against gross sales, or duplicate transaction imports caused by integration errors. Catching these discrepancies early prevents year-end reconciliation headaches and ensures your financial statements reflect reality.
Product and service item maintenance is another practical area that directly affects the accuracy of your QBO sales number. Items that are mapped to incorrect income accounts will cause revenue to be reported in the wrong category, which distorts your sales by product reports and can trigger questions from accountants and auditors.
Conduct a quarterly review of your items list to verify that each active item is mapped to the correct income account, that retired products are marked inactive so they no longer appear in transaction entry screens, and that new products added during the quarter are properly categorized before any sales are recorded against them.
Customer records in QBO also play a role in sales tracking accuracy. When customer names are entered inconsistently โ for example, the same customer appearing as both "ABC Corp" and "ABC Corporation" in different transactions โ your Sales by Customer report will show two separate entries that appear to be different customers. This splits the sales history and makes it impossible to get an accurate lifetime value calculation for that customer relationship. Periodically running the Merge function in QBO to consolidate duplicate customer records ensures your sales-by-customer data remains clean and actionable.
Setting up custom fields in QBO Advanced allows businesses to track sales attributes that the standard QBO data model does not capture natively. For example, a business might add a custom field for sales representative, lead source, or contract type. These custom fields can then be used as filters in sales reports, enabling management to analyze sales performance by rep, evaluate which lead sources generate the most revenue, or compare the average transaction size across different contract structures. This level of customization was previously only available in enterprise-grade ERP systems, making QBO Advanced a compelling platform for growing mid-market businesses.
Training your team to enter sales transactions correctly from the start is the single highest-leverage investment you can make in your QBO sales number accuracy. Even the best-configured QBO company file will produce inaccurate sales data if team members routinely select the wrong product item, wrong customer, wrong income account, or wrong tax code when entering transactions. Developing written standard operating procedures for common transaction types โ invoice creation, payment receipt, credit memo issuance โ and conducting brief training sessions when new team members join prevents the kind of data quality issues that take hours to untangle during month-end close.
Finally, leveraging QBO's automation features can significantly reduce the manual effort required to maintain accurate sales records. Recurring invoices for subscription-based or retainer clients ensure that billing happens on time and is consistently recorded in the correct accounts without relying on manual intervention.
Bank feed rules that automatically categorize incoming payments to the correct customer accounts reduce the time spent on cash application. And automated payment reminders sent to customers with overdue invoices improve collections velocity, which keeps your accounts receivable balance current and ensures the cash representation of your QBO sales number is as close to the accrual total as possible.