If you run a store with orders coming in every day, you already have everything a profit and loss statement needs. The question is not whether you can build one — you can. It is whether the one you build tells you the truth about your business or quietly lies to you. Most DIY P&Ls lie, and this guide shows you how to build one that does not.
What a profit and loss statement actually is
A profit and loss statement (P&L, also called an income statement) answers one question: did the store make money over a period, and where did the money go? You build it for a window — almost always one month for a small store — and you read it top to bottom.
Every line sits in a fixed order. Revenue first. Then the direct cost of the products you sold. Then everything else it takes to run the business. The number at the bottom is your profit. Change the order and the statement stops meaning anything.
The generic guides online stop at "list revenue, subtract expenses, done." That is technically true and operationally useless. For an operating store the details are where the money hides.
The line-by-line skeleton
Here is the standard ecommerce layout. Build it in this exact order.
- Gross sales — the total value of orders placed in the month, booked when the sale happens, not when the cash lands.
- Less discounts — coupon codes and automatic sales.
- Less returns and refunds — the value of refunded orders. This reduces revenue; it is not an expense.
- = Net sales — gross sales minus discounts minus refunds. Your honest top line.
- Cost of goods sold (COGS) — the direct cost of the units you sold: the supplier's production charge plus shipping to the customer, and optionally payment processing.
- = Gross profit — net sales minus COGS. Divide by net sales for your gross margin, the measure of your product economics.
- Operating expenses (OpEx) — ad spend, your Shopify plan and apps, software, contractors, owner pay, everything else.
- = Operating profit — gross profit minus OpEx. This is the number that tells you if the business works, not just the product.
Our full ecommerce P&L guide walks through each line in more depth, and if you want a ready structure to type into, the profit and loss statement spreadsheet walkthrough gives you the columns.
A worked monthly example
Say you run a t-shirt store doing 340 orders a month at a $31 average order value, spending $2,800 a month on Meta ads. All figures below are illustrative — plug in your own.
Start with gross sales: 340 × $31 = $10,540.
Now subtract contra-revenue. Say an 8%-off code gave back $420, and 11 orders got refunded for $341. Net sales = $10,540 − $420 − $341 = $9,779.
Next, COGS. Your Printify production charge (blank plus printing plus shipping to the customer) runs about $13 a unit, so 340 units cost roughly $4,420. Payment processing on Shopify Payments is commonly quoted around 2.9% plus 30¢ per online transaction on lower-tier plans, according to Shopify's own fee documentation summarized by A2X — verify the exact rate for your plan. That is 2.9% of $10,540 (about $306) plus 30¢ × 340 (about $102), so roughly $408.
Gross profit = $9,779 − $4,420 − $408 = $4,951. Gross margin = $4,951 ÷ $9,779 = about 50.6%. The product is healthy.
Now OpEx: Meta ad spend $2,800, Shopify plan and apps $190, email and design tools $90, an owner draw of $600. That is $3,680 total.
Operating profit = $4,951 − $3,680 = $1,271. Operating margin = $1,271 ÷ $9,779 = about 13%.
Read it and the lesson jumps out: the product earns a 50% gross margin, but ad spend eats most of the gross profit. The store nets about $1,271 on $9,779 of net sales. If your ad costs climb 20% — another $560 — operating profit nearly halves. That is why ad spend has to sit visibly in OpEx, which brings us to the mistakes.
The three mistakes that make a DIY P&L lie
1. Booking your Shopify payout as revenue
The deposit that hits your bank from Shopify is a net settlement — sales minus processing fees minus refunds, plus or minus adjustments and chargebacks, on a delayed rolling schedule. It almost never equals your sales for the same window.
If you book that payout as "sales," you understate your real revenue and hide your fees entirely. Book gross sales at the top and record fees and refunds on their own lines. The payout is a cash consequence at the bottom, not a revenue figure.
2. Putting ad spend in COGS
Ad spend scales with revenue, so it feels like a cost of the sale. Put it in operating expenses anyway. Bury acquisition cost inside COGS and your gross margin looks inflated while your single biggest risk — rising customer acquisition cost — disappears from view. In the example above, moving the $2,800 into COGS would make gross margin look like a disaster and hide that the product itself is fine.
3. Confusing profit with cash
Your P&L can show $1,271 of profit while your bank account is tight. Profit is booked on the sale date; cash moves on the payout schedule. Ad spend leaves your card daily, supplier charges hit at production, but payouts arrive days later. The faster you grow, the wider that gap gets. A P&L measures profit — you need a cash flow view alongside it, which our cash flow software guide covers in detail.
How to build it: spreadsheet, template, or software
You have three real options.
A spreadsheet is the cheapest and most flexible. Set up the eight lines above as rows, one column per month, and pull your numbers from Shopify's finance and payout reports plus your ad and supplier dashboards. A self-employed P&L template in Excel gives you a starting layout.
A template is the same idea with the formulas pre-wired — faster to start, less flexible later.
Accounting software (QuickBooks, Xero) automates the pull but still needs you to categorize correctly; garbage in, garbage out. If the term "income statement" trips you up, note that it is the same document — see the other names for a profit and loss statement.
Whichever you pick, the bottleneck is reconciliation: proving your net payout equals gross sales minus fees, refunds, and adjustments. If it does not tie out, something is miscategorized, and the P&L you built cannot be trusted at tax time.
Where Victor fits
Building the statement by hand once a month is doable. Keeping it honest every month — matching supplier costs to the exact units sold, splitting each payout back into sales and fees, keeping ad spend out of COGS — is the grind that kills most DIY attempts by month three.
PodVector AI's Victor is an AI employee that connects your Shopify store, Meta Ads, Google Ads, and your Printify, Printful, or Gelato account. He sees every order, every ad dollar, and every supplier cost together, so he computes the true per-order profit instead of leaving you to reconcile a payout by hand. He delivers the reports straight to your Google Drive. And when the numbers point to an action — pausing a campaign that is dragging margin down, adjusting a budget — Victor can make that change inside your ad accounts, with your approval before anything executes.
Put Victor on your store's numbers and see your real per-order profit without rebuilding a spreadsheet every month.
FAQs
Can you legally make your own profit and loss statement?
Yes. There is no law requiring an accountant to produce a P&L for internal use. You can build and use your own freely. The only time formatting standards matter is when a lender, investor, or the IRS asks for one in a specific form — and even then, a clean, reconciled DIY statement is usually the starting point your accountant works from.
What is the difference between a P&L and my Shopify payout report?
A payout report shows cash that settled into your bank — a netted figure after fees and refunds, on a delay. A P&L shows the economics of the period: full gross sales, each cost on its own line, and profit. One is a cash record; the other is a performance record. Confusing the two is the single most common error in small-store books.
Do I need accrual accounting to do this?
For a clean P&L, book revenue when the sale happens, not when cash arrives — that is the accrual idea, and it is what keeps your monthly numbers comparable. Many very small stores run cash-basis for simplicity, which is fine for taxes, but it smears your months together because payouts lag sales. Pick one basis and stay consistent.
How often should I build one?
Monthly, for an operating store. A quarterly or annual P&L hides the trends that matter — a creeping rise in acquisition cost or a supplier price bump shows up month to month long before it shows up in an annual total.
Does a P&L tell me how much tax I owe?
Not directly, but it is the foundation. Your taxable profit comes off the bottom of a clean P&L, not off your 1099-K, which reports gross payment volume before fees and costs. The federal 1099-K reporting threshold reverted to more than twenty thousand dollars and more than two hundred transactions for recent tax years, per the IRS — but you owe income tax on your profit whether or not you receive the form.
This is general information, not tax advice. Rules change and vary by situation — consult a licensed CPA or tax professional before acting.