What we do
Tools
Industries
Department
How we workLet's talk →
Home/QuickBooks/How to Find Gross Sales in QuickBooks Online
QuickBooks Online

How to Find Gross Sales in QuickBooks When the P&L Has Already Taken Discounts Out

A form asks for gross sales, and the obvious place to look, Total Income on the Profit and Loss, is already net. QuickBooks books discounts to an income account called Discounts given and records refund receipts against the item's income account, so both are subtracted before you see the total. Gross is still there, it's just in the sales reports.

Where the number is

Gross by item: Sales by Product/Service Summary shows items at full price, with discounts on their own line. Add the item lines up, ignoring the discount line.

Reports Sales by Product/Service Summary

Gross by customer: Sales by Customer Summary gives each customer's sales for the period. Compare its grand total with the item report before you treat it as gross.

Reports Sales by Customer Summary

Gross for a sales tax return: the Sales Tax Liability report shows a gross total alongside taxable and nontaxable sales.

Reports Sales Tax Liability

Gross sales down to gross profit, line by line

Example month for a small retailer
Product sales at full price $48,200
Service income $6,800
Gross sales (The figure most forms mean) $55,000
Discounts given (Sits in the income section of the P&L) − $1,650
Refund receipts (Already netted into the item's income account) − $900
Net sales (Total Income on the P&L) $52,450
Cost of goods sold − $21,000
Gross profit $31,450

If your P&L shows $52,450 and a form asks for gross sales, the answer in this example is $55,000.

Pulling the gross figure for a period

  1. 1

    Run Sales by Product/Service Summary

    Reports Sales by Product/Service Summary

    Set the date range to the period the form asks about. Each item shows its sales at full price.

  2. 2

    Leave out the discount line

    Discounts appear as one combined line rather than inside each item. Gross sales is the total before that line comes off. For discounts by item, the Detail version of the report filtered to the discount item shows them.

  3. 3

    Add back refunds

    A refund receipt reduces the sales of the item it refunds, so the item lines are already net of refunds. Run Transaction List by Date filtered to refund receipts for the same period, and add that total back if your form wants sales before returns. Our refund guide shows how they're recorded.

    Watch for: refunds dated in this period for sales made last period. The form's own definition decides whether they count now or against the original sale.

  4. 4

    Split it by location or class if asked

    If you tag sales with classes or locations, run Profit and Loss by Class or by Location, or filter the sales report, to get gross sales per store or department.

Before you copy the number onto the form

  • Does the form want sales tax included?

    Sales tax you collect isn't income in QuickBooks, so it's not in these reports. Most forms want gross sales before tax, but a lease or royalty contract may say otherwise.

  • Are discounts and returns in or out of their definition?

    Gross generally means before both. Some leases and franchise agreements define gross sales their own way, so read the clause, and check with your accountant if it's unclear.

  • Is it accrual or cash basis?

    Accrual counts invoices when issued, cash counts them when paid. The report's basis setting changes the figure, so match whatever the form or your tax return uses.

  • Do some sales happen outside QuickBooks?

    A POS or online store that only posts daily totals, or doesn't post at all, means QuickBooks undercounts. Make sure those sales reach the books before you report from them.

Gross sales, gross profit, gross income and net sales

What is the difference between gross sales and gross profit in QuickBooks?

Gross sales is everything you sold before discounts and refunds. Gross profit is net sales minus cost of goods sold, and QuickBooks prints it as its own line on the Profit and Loss. Gross sales has no line of its own, which is why you build it from the sales reports.

How do I find gross income in QuickBooks?

It depends who's asking. On a business tax form, gross income usually means gross receipts less returns and cost of goods sold, which lines up with Gross Profit on the P&L. In conversation people sometimes mean gross sales. Ask which one they want, then use the matching line, and check with your accountant for tax purposes. Our income statement guide walks through every line of the P&L.

How do I find net sales in QuickBooks?

Total Income on the Profit and Loss is usually your net sales, because Discounts given and refund receipts have already come out of it. If you've put other income, such as interest, in the income section, subtract it. Discounts on invoices post to Discounts given by default, which is what makes this work.

Can QuickBooks produce the gross sales report a franchisor or landlord asks for?

It has the figures, as long as each sale is tagged with a location or class. It won't apply the exclusions an agreement lists, for example gift card sales or employee discounts, and it won't fill in the franchisor's form. Read the agreement's definition of gross sales first, since it can differ from both QuickBooks' and your tax return's. That definition is also what n-frames builds the monthly report around.

Let's talk

Tell us the one thing your team does manually that eats up time. We read every message and reply within a day.