To create a profit and loss statement in QuickBooks, open Reports, choose Profit and Loss, set your date range to the month you want, and click Run report — you have a P&L in under a minute. The harder part, and the part that decides whether the number is trustworthy, is making sure your Shopify sales, fees, refunds, and ad spend land on the right lines first. A P&L built from raw bank deposits will overstate revenue, hide your processing fees, and bury your real cost of growth.

If you already run a store — real orders, real ad spend, a supplier billing you every day — you don't need a lecture on what a P&L is. You need one that reconciles, so the number at the bottom is your actual profit and not an accident of how the money moved. This guide walks the exact QuickBooks steps, then shows where the report goes wrong for a Shopify or print-on-demand seller and how to fix it.

The fast version: running the report in QuickBooks

The mechanics are quick. Intuit's own QuickBooks guide confirms the software assembles the statement from the transactions you've already categorized, so most of the real work is in the categorizing.

In QuickBooks Online

Click Reports in the left menu, open the Business overview group, and select Profit and Loss. You can also type "Profit and Loss" into the report search bar to pull up every P&L format.

Set the Report period to the month you're closing. Then click Customize to add subtotal columns — by month, by class, or by location — so you can compare periods side by side instead of reading one lump sum. Click Run report.

In QuickBooks Desktop

Open the Reports menu, choose Company & Financial, and pick the profit-and-loss format you want (Standard, Detail, or by Class). Set your dates and run it.

That's the whole "how." The rest of this article is why the output only tells the truth if the inputs are clean.

What a profit and loss statement actually shows

A profit and loss statement — also called an income statement — answers one question: did the store make money over a period, and where did the money go? Read it top to bottom.

  • Net sales: gross sales minus discounts and refunds. This is your honest top line, not the cash that hit your bank.
  • Cost of goods sold (COGS): the direct cost of the units you sold — for print on demand, the supplier's production charge plus their shipping to the customer.
  • Gross profit: net sales minus COGS. Divide by net sales for gross margin %, your measure of product economics.
  • Operating expenses (OpEx): everything else it takes to run — ad spend, your Shopify plan, apps, tools, contractor pay.
  • Operating profit: gross profit minus OpEx. This is the number that says whether the business works, not just the product.

Our ecommerce P&L guide walks the full line-by-line skeleton if you want the deeper structure. The single most important placement rule: ad spend belongs in OpEx, never COGS. Bury acquisition cost inside COGS and your gross margin looks great while your real risk — customer acquisition cost — vanishes from the page.

The mistake that makes your QuickBooks P&L lie

Here is where most operating stores go wrong. If your books are fed by a bank feed, QuickBooks sees the Shopify payout — the net deposit — and it's tempting to book that as "sales." Don't.

A Shopify payout is a net settlement. It bundles your sales, minus processing fees, minus refunds, plus or minus adjustments and chargebacks, on a rolling delay. According to A2X's breakdown of Shopify fees, Shopify Payments charges roughly 2.9% plus thirty cents per online card transaction on lower-tier plans, and a chargeback carries a fifteen-dollar dispute fee in the US. If you book only the net deposit, all of that disappears — you never see your fees, and your revenue reads low.

The fix: book gross sales at the top of the P&L, then record fees, refunds, and discounts on their own lines. The net payout is a cash consequence that belongs at the bottom, not a revenue figure. Tools like A2X or Link My Books split each payout into its component accounts and push clean entries into QuickBooks; a very small store can do it by hand from Shopify's payout reports. Either way it has to be done, or the P&L can't be reconciled and won't survive tax time.

A worked example: one POD month in QuickBooks

Say you run a t-shirt store doing 340 orders in the month at a $31 average order value, with $2,800 in Meta ad spend. Here's what a correctly built P&L looks like versus the payout trap. (Illustrative figures; the arithmetic is what matters.)

Gross sales: 340 × $31 = $10,540. Now the deductions:

  • Discounts (a 10%-off code on part of the volume): −$520
  • Refunds (11 orders): −$341
  • Net sales: $9,679
  • COGS — production (340 units × ~$12): −$4,080
  • COGS — payment processing (2.9% + 30¢ × 340 ≈): −$408
  • Gross profit: $5,191 → gross margin 53.6%
  • OpEx — Meta ad spend: −$2,800
  • OpEx — Shopify plan + apps: −$180
  • OpEx — email/design tools: −$90
  • Operating profit: $2,121 → operating margin 21.9%

Read it: the product is healthy at ~54% gross margin, but ad spend eats more than half your gross profit. Now imagine you'd booked the single net payout as "sales" instead. Revenue would have shown up around $8,900, your $408 in processing fees would be invisible, and your margins would be quietly wrong — impossible to compare month over month. That's the difference between a report and a guess.

How to read a profit and loss statement in QuickBooks

Once the report runs, read it in this order:

  1. Net sales trend across the month columns. Flat or falling with rising ad spend is an early warning.
  2. Gross margin %. If it moves, your product cost, discounting, or fee handling changed — drill into the line to find which.
  3. Ad spend as a share of gross profit. This is your real scaling risk. In the example above, a 20% rise in ad cost ($560) would erase roughly a quarter of operating profit.
  4. Operating profit, the bottom line that tells you if the business — not just the product — is viable.

In QuickBooks you can click any figure to drill into the underlying transactions, which is how you catch a miscategorized refund or an ad charge that slipped into COGS. For the accounting theory behind each line, our profit and loss account statement explainer covers the terms, and if you sell through Square as well, the Square profit and loss statement guide shows how to fold that channel in without double-counting.

Profit is not cash — and QuickBooks won't warn you

One more thing the P&L can't tell you: whether you'll have money in the bank next week. Profit is booked on the sale date; cash moves on Shopify's payout schedule, days later. Ad spend and supplier charges leave now, before those payouts land, so a profitable store can still run short on cash while it pre-funds growth.

That gap is why a P&L alone isn't enough to run an ad-driven store. Pair it with a real cash view — our guide to cash flow software for small business covers the timing side that QuickBooks reports leave out.

Where the P&L stops and per-order profit begins

A QuickBooks P&L is a monthly, whole-store summary. It won't tell you which product, campaign, or SKU actually made money once you subtract that product's supplier cost, its share of fees, and the ad spend that acquired the order. That's per-order economics, and it's the level most POD sellers make decisions at.

That's the gap PodVector AI is built for. Victor is an AI employee that connects to your live store data — Shopify, Meta Ads, Google Ads, Printify, Printful, Gelato, and Klaviyo — and computes true per-order profit, then delivers the reports to your Google Drive. Every write action Victor takes is approval-gated: he'll even draft customer-support emails and wait for your OK before sending. Victor is not a dashboard you have to go read; he does the work and brings you the answer.

Put Victor to work on your store's real numbers →

This is general information, not tax, legal, or accounting advice. Rules and rates change and vary by situation — consult a licensed CPA or tax professional before acting.

FAQs

How do I create a profit and loss statement in QuickBooks Online?

Click Reports in the left menu, open Business overview, and select Profit and Loss. Set the report period to the month you want, click Customize to add month or class columns if you need them, then click Run report. The statement is built from the transactions you've already categorized, so clean categorization is what makes it accurate.

Why doesn't my QuickBooks P&L match my Shopify sales?

Because a Shopify payout is a net settlement, not your sales total. It's your sales minus fees, refunds, and adjustments, deposited on a rolling delay. Book gross sales at the top of the P&L and record fees and refunds on their own lines; the net deposit belongs at the bottom as a cash figure, not as revenue.

Where should ad spend go on the profit and loss statement?

In operating expenses, below the gross-profit line — never in COGS. Ad spend is paid acquisition, not a direct product cost. Putting it in COGS inflates your gross margin and hides that customer acquisition cost is your real scaling risk.

How often should I run the report?

Monthly, once the period is reconciled. A P&L is only as good as the books behind it, so run it after you've confirmed your payouts split correctly into sales, fees, and refunds. Comparing month-over-month columns is where the report earns its keep.

Can QuickBooks show me profit per product or per order?

Not really — a standard P&L is a whole-store summary for a period. To see which SKU or campaign made money after its supplier cost, fees, and the ad spend that won the order, you need per-order profit, which is what PodVector AI's Victor computes from your live store data.