Example P&L for an E-commerce Store
What a statement-built P&L looks like for a small online store: three months of platform payouts, a restock wire that turns May red, and the trailing average that is the store's real run rate.
- This example shows a Shopify-plus-Amazon store settling $27,320.80 to $30,906.92 a month to the bank, net of platform fees, which is why the revenue line reads lower than the sales dashboard.
- May shows a $1,978.52 loss because a $22,164.83 inventory month (dominated by one $21,500.00 supplier wire) landed in a single column. April netted $13,638.91 and June $15,891.47.
- The sawtooth is the trade's signature: restock months read deep red, sell-down months artificially fat. Neither is the run rate; the quarter's $27,551.86 of net income, roughly $9,180 a month, is.
- Advertising runs $19,947.43 for the quarter, 22.8 percent of settled revenue and the largest expense after inventory.
- One incoming PayPal transfer was the owner's own balance, not customer money, and is excluded rather than counted as revenue.
- The numbers are fictional, but the format, the timing quirks, and the judgment calls are exactly what a reconciled statement-based P&L delivers.
Below is a complete example profit and loss statement for a fictional online home-goods store, Lantern & Larch Home Goods LLC, covering April through June 2026. The store sells through Shopify and Amazon with a little PayPal on the side, and like every e-commerce operation it has more dashboards than documents. This page is what the bank account, the one place everything settles, says about the same three months, with every total computed from the lines so the document foots.
Use it two ways. If you are building your own P&L, this is the target format: one line per platform, inventory and advertising split out, fees visible where they debit separately, and owner activity below the statement. If a lender or a store buyer just asked for financials, the reading notes explain the negative month and the dashboard gap before they have to ask.
| INCOME | April | May | June | Total |
| Shopify payouts | $22,846.17 | $26,129.40 | $24,312.86 | $73,288.43 |
| Amazon disbursements | $3,612.48 | $4,028.12 | $3,884.50 | $11,525.10 |
| PayPal transfers | $862.15 | $749.40 | $913.60 | $2,525.15 |
| Total income | $27,320.80 | $30,906.92 | $29,110.96 | $87,338.68 |
| EXPENSES | April | May | June | Total |
| Inventory (COGS) | $4,125.00 | $22,164.83 | $2,984.16 | $29,273.99 |
| Advertising | $6,214.83 | $7,049.18 | $6,683.42 | $19,947.43 |
| Shipping & fulfillment | $2,183.46 | $2,461.12 | $2,315.84 | $6,960.42 |
| Software & subscriptions | $846.12 | $846.12 | $897.35 | $2,589.59 |
| Merchant fees (debited separately) | $312.48 | $364.19 | $338.72 | $1,015.39 |
| Total expenses | $13,681.89 | $32,885.44 | $13,219.49 | $59,786.82 |
| NET PROFIT | $13,638.91 | -$1,978.52 | $15,891.47 | $27,551.86 |
- Owner draws $15,000.00: The owner's pay comes out as draws, which are equity movement, not a cost of running the store.
- Old PayPal balance moved to checking $1,200.00: This $1,200.00 incoming transfer was the owner's own accumulated balance, not customer settlements. Counted as revenue it would overstate the store.
Line notes
- Shopify payouts: Weekly settlements, net of processing fees and refunds. The dashboard's gross sales number is higher; this is what settled.
- Amazon disbursements: Biweekly, net of Amazon's fees. Direction matters: Amazon paying you is not the same pattern as buying on Amazon.
- Inventory (COGS): May carries a $21,500.00 supplier wire for the fall restock plus a domestic top-up. A wire this size gets a confirming question, never a guess.
- Advertising: Meta and Google. The largest expense after inventory, and the one worth watching monthly against settled revenue.
- Merchant fees (debited separately): Fees that debit on their own instead of netting out of payouts get a visible line.
The sawtooth, in this example's numbers
April netted $13,638.91. May lost $1,978.52. June netted $15,891.47. The swing is almost entirely one line: inventory spending of $4,125.00 in April, $22,164.83 in May, and $2,984.16 in June. The May wire bought stock that will sell across the next two quarters, but cash accounting puts the whole cost in the month the money left. Read as single months, this store looks erratic; read as a quarter, it netted $27,551.86 on $87,338.68 of settled revenue, a 31.5 percent margin, or roughly $9,180 a month before owner draws.
That trailing figure is the number to run the store on, and the one a reader should be steered toward. The monthly columns are still worth showing because they prove nothing is smoothed or hidden: a buyer doing diligence would rather see an honest red May with a wire behind it than three suspiciously even columns.
The dashboard gap, quantified
Every payout line here is net of platform fees and refunds, so the $87,338.68 of quarterly revenue is smaller than what the Shopify and Amazon dashboards report as gross sales. That is not understatement; it is the settled-cash view, and it is the number a lender verifies against statements. The separately debited merchant fees ($1,015.39 for the quarter) get their own visible line precisely because they did not net out of a payout.
The settled view also changes how advertising reads. The $19,947.43 of quarterly ad spend is 22.8 percent of settled revenue; against gross dashboard sales the same spend would look meaningfully cheaper. Return on ad spend computed against cash that actually landed tells you whether campaigns funded themselves, which is the version of the question that pays the bills.
The judgment calls a statement cannot make alone
Two lines in this example needed a human answer. The $21,500.00 wire could have been inventory, equipment, or something else entirely; one flagged question settled it as a stock purchase, which put it in cost of goods where it belongs. And one incoming PayPal transfer of $1,200.00 looked like the others but was the owner's own accumulated balance being moved home; it sits below the statement as excluded, because customer settlements and your own money arriving are different things even when the statement line looks identical.
This is exactly what the review step of a statement-built report is for. Recurring platform payouts categorize themselves with confidence; the rare ambiguous line with real dollars behind it becomes a short question instead of a silent guess.
Use this format yourself
The free e-commerce business P&L template is this exact layout as a spreadsheet with the categories pre-loaded. For the full walk-through of categories, judgment calls, and what lenders ask a e-commerce business for, read the e-commerce business P&L guide. And to see a statement-built report with working charts and reconciliation detail, the full sample report is a complete delivered order for a different fictional business.
Common questions
Yes. The free e-commerce template below is this exact format as a spreadsheet with the categories pre-loaded. Or upload your statements and RapidPnL builds the reconciled version for you in minutes.
Payouts arrive net of processing fees and refunds, so settled cash is always below gross merchandise sales. Lenders verify claimed revenue against bank deposits, which is why the P&L is built from the deposits in the first place.
Not when the wire behind it is visible and the trailing period is profitable. Readers familiar with inventory businesses expect the sawtooth; what they distrust is smoothing they cannot trace to statements.
Upload the PDFs and get a management-use profit & loss in minutes, with every statement reconciled to the penny. $79 for a quarter, $249 for a full year in monthly columns. Full refund if we can't reconcile.
The free statement is read, categorized, and reconciled on screen before you pay anything. One per person; no card required.
Written by a licensed CPA. This guide is general information, not tax, legal, accounting, or financial advice, and does not create a professional relationship. Lender requirements and bank websites change; confirm specifics with your lender and financial institution.