Your P&L can show a $40,000 profit while your bank account drops to zero in the same month. That gap is not an accounting error. It is the difference between profit and cash, and it is where ecommerce businesses die.
Picture a Shopify and Amazon seller doing $3M a year at a healthy 22% net margin. On paper, they cleared roughly $55,000 in profit in Q3. In October they couldn't make payroll.
Nothing was wrong with the P&L. The cash just wasn't there. They had wired $310,000 to a supplier for Q4 holiday inventory in September, Amazon was holding two weeks of disbursements in reserve, and a chunk of October revenue was sitting in TikTok Shop and Shopify Payments balances that had not settled yet. Profitable business. Empty bank account.
This is the single most expensive misunderstanding in ecommerce finance. Profit is an opinion calculated under accrual rules. Cash is a fact you can spend. They move on different timelines, and the gap between them is widest exactly when you are growing fastest.
Accrual accounting, the basis your P&L uses, records revenue when you earn it and expenses when you incur them. Cash accounting records money when it actually moves. Five mechanics drive the wedge between the two in an ecommerce business.
Inventory. When you buy $100,000 of stock, your cash drops by $100,000 immediately. Your P&L barely moves. That inventory sits on the balance sheet as an asset and only hits the income statement as cost of goods sold when each unit sells. A growing store is constantly converting cash into inventory faster than inventory converts back into cash.
Marketplace payout timing. Amazon disburses roughly every 14 days and holds reserves against returns. Shopify Payments runs on a rolling delay. TikTok Shop and Walmart each have their own settlement clocks. Revenue you earned today is cash you receive one to three weeks from now.
Sales tax you are holding. Money you collect for marketplace-facilitator or self-collected sales tax sits in your account looking like cash until the filing deadline claws it back. It was never yours.
Credit terms and financing. Net-30 supplier terms, Amazon lending repayments, and credit card float all shift the timing of cash without touching reported profit in the same period.
Owner draws and loan principal. Principal payments and distributions leave the bank but never appear on the P&L at all. You can be "profitable" and still bleed cash through the balance sheet.
| EVENT | EFFECT ON PROFIT (P\&L) | EFFECT ON CASH |
| Buy $100K of inventory | None until sold | Down $100K now |
| Sell $100K of that inventory | Recognized as revenue + COGS | Cash arrives 1-3 weeks later |
| Collect sales tax | None (liability) | Up now, out at filing |
| Pay loan principal | None | Down now |
| Owner distribution | None | Down now |
| Amazon reserve held | Revenue still recognized | Cash delayed |
A cash flow forecast is a forward-looking schedule of when money will land in and leave your bank account, week by week. It is not your P&L. It ignores accrual concepts entirely and asks one question: on any given Friday, will there be enough in the account to cover what clears that week?
The most useful version for ecommerce is a rolling 13-week forecast, which we break down step by step in our 13-week cash flow guide (/blog-posts/13-week-cash-flow-forecast). Thirteen weeks is one quarter, long enough to see a big inventory order coming and short enough that your estimates stay honest.
Start with your current confirmed bank balance. Then lay out 13 columns, one per week, and fill in the timing of every inflow and outflow.
Inflows you can model:
Outflows you can model:
The output is a running weekly ending balance. The moment any week dips toward zero or negative, you have found a problem early enough to fix it: delay an order, accelerate a disbursement, draw on a line of credit, or trim ad spend.
Every number in that forecast traces back to clean bookkeeping. If your COGS is wrong, your margin is wrong, and your projected inflows are fiction. If your marketplace fees are lumped into one "Amazon" line instead of split by settlement, you cannot model payout timing. This is the unglamorous truth: cash forecasting is a reporting problem before it is a strategy problem.
ConnectBooks syncs settlement-level data from Amazon, Shopify, Walmart, eBay, and TikTok Shop into QuickBooks or Xero, applies FIFO COGS per unit, and produces per-channel P&L. That settlement granularity is what makes a real cash forecast possible, because you can see exactly what each marketplace will pay and when.
A forecast you build once and never look at is worthless. The discipline is updating it weekly with actuals and re-rolling the window forward. Two patterns matter most.
The inventory trough. Every large purchase order creates a dip. The skill is sequencing your buys so two big dips never overlap, and so a dip never lands in a week with payroll and a tax payment.
The growth squeeze. Counterintuitively, faster growth makes cash tighter, not looser, because you are buying ahead of sales. A store growing 40% year over year often has worse cash flow than a flat one. Profit rising while cash falls is the signature of a scaling ecommerce business, and it is survivable only if you see it coming.
This is also where an AI layer earns its keep. ConnectBooks is building Crunch, an AI CFO that reads the books ConnectBooks already maintains and surfaces cash and margin signals you would otherwise catch too late. Crunch is in active beta with a waitlist for the full release. You can see what it does at /crunch.
| NEXT STEPClean, settlement-level books are the foundation of any cash forecast you can trust. See how ConnectBooks builds them at /pricing, and explore the Crunch AI CFO at /crunch. |
Yes, and it is common. Profit is measured on an accrual basis and ignores the timing of when cash moves. Large inventory purchases, delayed marketplace payouts, sales tax you are holding, and loan principal all drain cash without reducing reported profit. A store can post record profit and still miss payroll in the same month.
A rolling 13-week (one quarter) forecast is the standard for ecommerce. It is long enough to see a major inventory buy coming and short enough that your weekly estimates stay accurate. Update it weekly with actuals and roll the window forward.
Growth means buying inventory ahead of the sales it will generate. You spend cash on stock now and recover it weeks later as that stock sells and marketplaces disburse. The faster you grow, the larger the gap between cash out and cash in, which is why scaling stores often feel cash-starved despite rising profit.
A P&L reports earned revenue and incurred expenses under accrual rules over a period. A cash flow forecast projects the actual timing of money entering and leaving your bank account, week by week. The P&L tells you whether the business is profitable; the forecast tells you whether you can pay your bills next Tuesday.
Yes. The forecast inherits the accuracy of your books. Wrong COGS means wrong margins and wrong projected inflows. Marketplace fees lumped into a single line make payout timing impossible to model. Settlement-level, per-channel bookkeeping is the prerequisite for any forecast worth trusting.
Clean, accurate books make this manageable. Start a free trial of ConnectBooks to get settlement-level accuracy and real margin visibility for your ecommerce business. No credit card required.
Running an e-commerce business comes with plenty of challenges, but ConnectBooks is here to make your life easier. With real-time insights, seamless integrations, and detailed tracking of your profitability and inventory, you can stay ahead of the game. Whether you’re selling on Amazon, Shopify, Walmart, TikTok or eBay, ConnectBooks helps you manage your finances with 100% accuracy and confidence, so you can focus on growing your business.
Ready to level up? Start making smarter, data-driven decisions every step of the way. Try ConnectBooks Free Today or Schedule a Demo
