Most cash flow statement samples online use a tidy made-up company with round numbers and no ad spend. That is not your store. You run real traffic, pay suppliers the moment an order drops, and wait days for Shopify to settle the cash.
This sample is built for that reality. It uses operating numbers, ties every line out, and shows you the one thing the generic templates always skip: why a profitable month can leave your checking account almost flat.
What a cash flow statement actually shows
A cash flow statement answers a different question than your profit and loss statement. The P&L asks "did I make money?" The cash flow statement asks "did money actually move, and where did it go?"
That difference matters because your Shopify payout is a net settlement, not your sales. It bundles sales minus fees minus refunds, and it lands on a rolling delay — so the cash from a sale shows up days after you booked the revenue. If you want the full picture of how the two statements fit together, start with the ecommerce P&L guide.
A proper statement splits cash into three buckets:
- Operating activities — cash from running the store day to day (sales settling in, suppliers and ads going out).
- Investing activities — cash spent on longer-lived assets (a new design tablet, equipment).
- Financing activities — cash from loans, and owner draws or contributions.
Cash flow statement sample for a small business
Here is a one-month sample for an operating print-on-demand store. Say you run 340 orders a month at a $31 average order value, with $2,800 in Meta ad spend. All figures are illustrative, but the structure is exactly what you build.
First, the month's profit (from the P&L) that feeds the top of the statement. Shopify Payments charges roughly 2.9% plus 30¢ per online transaction on lower-tier plans, per A2X's breakdown of Shopify fees — verify the rate for your own plan.
| P&L line | Amount |
|---|---|
| Gross sales (340 × $31) | $10,540 |
| Less: discounts | −$500 |
| Less: refunds (10 orders) | −$310 |
| Net sales | $9,730 |
| COGS — production (340 × $12) | −$4,080 |
| COGS — processing (~2.9% + 30¢ × 340) | −$408 |
| Gross profit | $5,242 |
| OpEx — Meta ad spend | −$2,800 |
| OpEx — Shopify plan + apps | −$180 |
| OpEx — email + design tools | −$90 |
| Net income (operating profit) | $2,172 |
Now the cash flow statement itself, built with the indirect method (start from net income, then adjust for cash that didn't move the same way).
| Cash flow statement | Amount |
|---|---|
| Operating activities | |
| Net income | $2,172 |
| Less: increase in payouts in transit (late-month sales not yet settled) | −$900 |
| Add: increase in sales tax collected, not yet remitted | +$350 |
| Net cash from operating activities | $1,622 |
| Investing activities | |
| Purchase of a design tablet | −$600 |
| Net cash from investing activities | −$600 |
| Financing activities | |
| Owner's draw | −$500 |
| Net cash from financing activities | −$500 |
| Net change in cash | +$522 |
| Beginning cash balance | $8,000 |
| Ending cash balance | $8,522 |
Read it top to bottom. The store earned $2,172 in profit, but cash only grew $522. The arithmetic: $1,622 − $600 − $500 = $522.
Operating activities — the line that bites
This is where the profit-to-cash gap lives. Two adjustments pull your cash away from your profit.
The payouts-in-transit line (−$900) is the cash from your last few days of sales that Shopify has not settled yet. You booked the revenue, but the money is still in flight — so it reduces cash this month even though it helped profit.
The sales tax line (+$350) runs the other way. You collected that cash at checkout, but you have not sent it to the state yet, so it is sitting in your account inflating your balance. It is not yours to keep — you owe it.
Investing activities — the occasional big buy
Most months this bucket is empty. When you buy something that lasts — a laptop, a camera, a design tablet — it lands here, not in operating expenses.
In the sample, the −$600 tablet is real cash out the door this month, even though an accountant would spread its cost over years on the P&L. That is another reason profit and cash diverge.
Financing activities — loans and owner pay
Owner draws are not a business expense, so they never touch your P&L. But they absolutely move cash, so they belong here.
The −$500 owner's draw is money you took out to pay yourself. A loan you took would show as a positive line; a loan repayment would show as a negative one.
Direct vs. indirect method
You will see two ways to build the operating section. The indirect method (used above) starts from net income and adjusts for non-cash and timing items — it is the standard for small stores because it reuses your P&L.
The direct method lists actual cash receipts and cash payments instead. It is more intuitive but more work, because you have to pull every cash movement separately rather than starting from a number you already have. For a small Shopify store, the indirect method is almost always the practical choice.
The float trap the templates skip
Here is the lesson a static sample can't show: scale this store and the cash gap gets worse, not better.
Your ad spend leaves daily — Meta and Google charge your card as you spend. Your supplier bills you at production, right after the order drops. But your payout arrives on a delay, commonly a couple of business days in the US, and payouts don't settle on weekends while ads never stop.
So the faster you push ad spend to grow, the more cash you front before the payouts catch up. You can be genuinely profitable on every order and still watch your bank balance shrink. That timing gap — the float — is why a monthly cash flow statement matters more than the generic guides admit, and it's worth pairing with a cash flow app for small business that updates as money actually moves.
Cash flow problems are not a rounding error, either. Mismanaged cash flow is cited as a factor in 82% of small business failures, according to a widely referenced U.S. Bank study summarized here. A profitable P&L is no defense if the cash timing sinks you.
How to build yours every month
Build this statement monthly, not once a year. The steps:
- Pull your net income from the month's P&L. If you want a clean P&L to start from, the profit and loss statement in Excel format walks the layout.
- Add back non-cash items and adjust for timing — payouts in transit, sales tax collected, supplier payables.
- List investing cash (asset purchases) and financing cash (loans, owner draws) separately.
- Sum the three buckets, add your beginning cash balance, and confirm the ending balance matches your actual bank balance. If it doesn't tie out, something is miscategorized.
This is general information, not tax advice. Rules change and vary by situation — consult a licensed CPA or tax professional before acting.
The slow part is step 2, because the raw data lives in different places — Shopify for sales and payouts, Meta and Google for ad spend, Printify or Printful for production costs. Stitching those together by hand every month is where most owners give up.
This is the work Victor, the AI employee from PodVector AI, does for you. Victor connects to Shopify, Meta Ads, Google Ads, Printify, Printful, Gelato, and Klaviyo, computes your true per-order profit from live data, and delivers the reports to your Google Drive. Every write action it takes is approval-gated, so nothing happens without your sign-off. When you're ready to stop stitching spreadsheets, start with PodVector AI.
For a tool built specifically to project and manage the float, compare options in our guide to cash flow software for small business.
FAQs
What is the difference between a cash flow statement and a P&L?
Your P&L shows profit — revenue earned minus costs incurred, booked on the sale date whether or not the cash has moved. The cash flow statement shows the cash that actually entered and left your account over the period. A store can be profitable on its P&L and still run short on cash, because sales get booked before the Shopify payout settles.
Should a small store use the direct or indirect method?
Use the indirect method. It starts from the net income on your P&L and adjusts for timing and non-cash items, so you reuse work you've already done. The direct method lists every cash receipt and payment separately, which is more precise but far more labor for a small store with no bookkeeper.
Why does my cash flow statement not match my Shopify payouts?
Because a payout is a net settlement, not your sales. It bundles sales, minus processing fees, minus refunds, plus or minus adjustments, and it covers a rolling prior window rather than the calendar month. Book gross sales at the top of your P&L and treat the net payout as the cash consequence — never as your revenue.
How often should I prepare a cash flow statement?
Monthly, at minimum. Ad-driven stores move cash fast, so a quarterly or annual statement hides the week-to-week float gaps that actually threaten you. A monthly statement that ties to your bank balance is the one that catches a cash squeeze before it catches you.
Can I be profitable and still run out of cash?
Yes, and it's common for growing stores. Profit is booked when the sale happens; cash arrives on the payout schedule, often days later. When you scale ad spend — which leaves your account daily — faster than payouts can refill it, you front the growth out of your own pocket and can go cash-negative while every order is still profitable.