Most "how to make a profit and loss statement" guides stop at the formula: revenue minus expenses equals profit. That is fine for a service business with one checking account. It falls apart the moment you run a store with payout batches, processor fees, supplier charges, and daily ad spend. This guide shows you how to actually assemble a P&L from a live store's data — and the specific traps that make a quick export wrong.
What a profit and loss statement is answering
A profit and loss statement (also called an income statement or P&L) answers one question: over a set period, did the store make money, and where did it go? You build it by period — for an operating store, monthly is the right cadence, because that is the only resolution at which you can catch a rising ad cost before it eats a quarter.
The structure is always the same, top to bottom: gross sales, minus discounts and refunds, equals net sales; minus cost of goods sold equals gross profit; minus operating expenses equals operating profit. Our full ecommerce P&L guide walks the whole skeleton. Here we focus on the part the generic guides skip: getting the numbers out of your actual tools.
The four data sets you need to pull
Before you can build anything, gather these — and know exactly where each one lives:
- Gross sales. The total value of orders placed in the period, measured when the sale happens, not when cash lands in your bank. Pull this from your store's order/sales report, not from your bank deposits.
- Discounts and refunds. Coupon codes, automatic discounts, and the value of refunded orders. These are contra-revenue — they reduce the top line, they are not expenses.
- Cost of goods sold (COGS). For a print-on-demand store this is the supplier's production charge plus the supplier's shipping to the customer, pulled from your Printify, Printful, or Gelato order history for units actually sold in the period.
- Operating expenses. Ad spend from Meta and Google, your store plan and app subscriptions, software, and any contractor or owner pay.
The single most common mistake here is pulling "revenue" from your bank — the Shopify deposit. That number is already netted, and it will understate your sales and hide your fees entirely. More on that below.
Build it line by line: a worked example
Say you run a t-shirt store doing 340 orders a month at a $31 average order value, spending $2,800/month on Meta. Here is the month assembled as a P&L. (All figures are an illustrative example, not market data.)
| Line | Amount |
|---|---|
| Gross sales (340 × $31) | $10,540 |
| Less: discounts (a promo code) | −$420 |
| Less: refunds (10 orders) | −$310 |
| Net sales | $9,810 |
| COGS — supplier production (340 × $12.50) | −$4,250 |
| COGS — payment processing | −$408 |
| Gross profit | $5,152 |
| Gross margin % | 52.5% |
| OpEx — Meta ad spend | −$2,800 |
| OpEx — store plan + apps | −$180 |
| OpEx — email + design tools | −$90 |
| OpEx — owner draw | −$500 |
| Operating profit | $1,582 |
| Operating margin % | 16.1% |
Read it top to bottom and the story jumps out. The product is healthy — a gross margin above fifty percent — but ad spend swallows more than half of the gross profit. The store nets about $1,582 on $9,810 of net sales. If your Meta cost rises twenty percent next month (another $560), operating profit drops by roughly a third, even though nothing about the product changed.
That is the whole point of a real P&L: it should scream where your risk is. This one screams customer acquisition cost. If you want to pressure-test the top of this stack, our Shopify profit margin calculator breaks the per-order math down further.
A note on where fees go
Payment processing on Shopify Payments is commonly quoted around 2.9% plus a fixed per-transaction fee for online card payments on lower-tier plans, according to A2X's breakdown of Shopify fees — the exact rate falls as you move up plans, so verify yours. In the example above, the processing line is roughly 2.9% of gross sales plus thirty cents across 340 transactions, which lands near $408.
Whether you put processing in COGS or operating expenses is a judgment call. The only rule that matters: be consistent month to month, or your margin trend becomes meaningless.
The trap that makes an exported P&L wrong
Here is the number-one reason small-store books are broken: treating the Shopify payout as revenue. The deposit that hits your bank is a net settlement. It bundles sales, minus processing fees, minus refunds issued, plus or minus adjustments and chargebacks — and it arrives on a rolling delay, so a payout almost never matches your sales total for the same window.
Book gross sales at the top of the P&L. Record fees, refunds, and adjustments on their own lines. The net payout belongs at the bottom as the cash consequence — it is not a revenue figure. Booking the net deposit as "sales" understates revenue, hides your fees, and produces a statement you cannot reconcile at tax time.
One more gotcha worth building in: when you refund a customer, the original processing fee is generally not returned to you. A refunded $31 order still costs you roughly a dollar in fees you already paid. Track the refund as contra-revenue and leave the fee where it sits. Disputes add a chargeback fee on top — A2X notes Shopify Payments charges fifteen dollars per dispute in the US, refunded only if you win.
Three ways to actually get the statement
Do it by hand. Export your store's finance and payout reports, your supplier order history, and your ad platform spend into a spreadsheet, then stack the lines. For a very small store this works, and our guide to creating a profit and loss statement in Excel walks the template. The downside: you redo it every month, and it is easy to grab the wrong "revenue" number.
Use accounting software. QuickBooks, Xero, and connectors like A2X split each payout into its component accounts automatically, so the P&L builds itself once you map the categories. This is the right move once you cross a few thousand orders a month. It is bookkeeping-grade, which also means it lags — you are reading last month's close, and it does not pull your ad spend or compute profit per order.
Have an AI employee assemble and deliver it. This is where PodVector AI's Victor fits. Victor connects to your Shopify store, Meta Ads, Google Ads, Printify, Printful, Gelato, and Klaviyo, computes true per-order profit from that live data, and delivers reports straight to your Google Drive. Victor is not a dashboard you log into to go hunting — it does the assembly and hands you the finished number, and every write action it takes is approval-gated, so nothing happens without your sign-off.
Make it reconcile every month
A P&L you cannot reconcile is a guess. Each month, prove that your net payout equals gross sales minus refunds, discounts, and all fees, plus or minus adjustments and shipping income. If it does not tie out, something is miscategorized — usually ad spend buried in COGS, or a payout booked as sales.
Remember that this statement shows profit, not cash. Your store can show a healthy operating profit and still be short this week, because ad spend leaves your account daily while payouts arrive on a delay. That timing gap is its own discipline — see our guide to cash flow software for small business for how to size the buffer that keeps a profitable store from running dry.
This is general information, not tax advice. Rules change and vary by situation — consult a licensed CPA or tax professional before acting.
Once your monthly P&L reconciles and you can see profit per order without a spreadsheet marathon, the next decisions — which products to scale, where to cut ad spend — get obvious. Let Victor assemble and deliver your profit statement from your live store data.
FAQs
Where do I get the numbers to build a profit and loss statement?
From four places: your store's order/sales report for gross sales, the same report (or your discount log) for refunds and discounts, your POD supplier's order history for COGS, and your ad platforms plus subscription invoices for operating expenses. Do not pull "revenue" from your bank deposits — those are netted payouts, not sales.
Can I just use my Shopify payout as my revenue?
No. The payout is a net settlement — sales minus fees minus refunds, on a delayed rolling schedule. It almost never equals your sales for the period. Book gross sales at the top and treat the payout as the cash result at the bottom, or your statement will not reconcile.
How often should I run a P&L for an operating store?
Monthly. It is the resolution where you can catch a rising ad cost or a margin slip early. Quarterly or annual statements tell you what happened after it is too late to act on it.
Does getting a P&L handle my taxes?
No. A P&L shows profit for the period; it is not a tax filing. You owe income tax on your profit whether or not any processor sends you a form — the IRS notes the federal 1099-K reporting threshold reverted to over twenty thousand dollars and more than two hundred transactions, but that governs reporting, not what you owe. Clean, reconciled books are what make the return defensible. This is general information, not tax advice — consult a CPA.
What is the difference between a P&L that shows profit and my bank balance?
Profit is booked on the sale date; cash moves on the payout schedule. A store can be profitable on paper and cash-short the same week because ad spend and supplier charges leave before payouts land. The P&L measures whether the business works; cash flow measures whether you can pay this week's bills.
Do I need accounting software, or can I build it myself?
For a very small store, a spreadsheet built from your export reports works. Once you are running hundreds of orders a month across suppliers and ad platforms, manual assembly gets error-prone and slow — that is when software, or an AI employee that pulls from your live data and delivers the report, earns its keep.