Build a 13-week cash flow forecast from reconciled available bank balances, dated cash receipts, and scheduled payments. Update it weekly, assign owners to material assumptions, and set minimum cash triggers so your ecommerce business can address payroll, inventory, and funding gaps before payment deadlines arrive.
Your store can show a profitable month and still face a payroll shortfall on Thursday. The cash forecast needs to explain the Thursday, not just the month.
Annual budgets and monthly dashboards can look tidy, but payroll clears weekly and vendors want actual dollars, not pro forma charts. That is why many finance leads run a 13-week cash flow as their operating heartbeat. Thirteen weeks is long enough to see seasonality, debt service, and tax remittances coming, yet near enough to act on collections, vendor terms, and hiring starts. Done well, it is not just a spreadsheet. It becomes a standing weekly conversation tied to bank balances, ACH cutoffs, and accountable owners. This article outlines a practical way to design that cadence so founders and controllers can steer liquidity with confidence.
Start with the bank, not the P&L. Record cash at bank by account, separate restricted cash, and note any undrawn revolver capacity. Reconcile to your general ledger so the opening balance matches the latest close. Fix the 13-week horizon on a consistent Friday or Monday to align with payroll cycles and vendor payment runs. Pull your AR aging and AP aging as of the start date to anchor near-term inflows and outflows. A common mistake is to start with revenue assumptions, then work back to cash, which hides timing gaps and leaves you surprised on payroll week.
If you do not have a full-time CFO, independent specialists such as PHG Advisory for fractional CFO strategy can help formalize the model structure and governance. Still, the core discipline is the same: start with what is in the bank and how quickly it moves through receivables and payables.
Lay out expected cash receipts by week, tagged to real events: customer check dates from the AR aging, subscription renewals from your CRM, credit card settlements from your merchant processor, loan draws, and any R&D or VAT refunds. For outflows, build lines for payroll and benefits by cycle, rent, cloud platforms such as AWS or GCP, software vendors, insurance premiums, sales tax and income tax payments, debt service, CapEx deposits, and annual prepaids. Assign an internal owner to each line and flag its certainty as committed, probable, or speculative. Do not copy your expense categories straight from the income statement. Expense recognition and cash movement rarely align, and that difference is where liquidity surprises hide.
Add working capital levers next to the dates. For inflows, target a net DSO and list actions like dunning cadence, auto-pay offers, or short-term early-payment discounts. For outflows, note opportunities to extend vendor terms, shift from upfront to milestone-based deposits, or smooth inventory buys. Recognize the trade-off: pushing out suppliers can strain relationships or raise prices, while paying early to capture discounts pulls cash forward. Document the intended choice and its rationale so everyone understands why a date moved.
Freeze the prior week and compare actuals to forecast line by line. Pull actuals from your treasury portal or bank feed, not from memory. Use simple cause codes for variance such as timing, amount, or cancellation, and have the named owner explain. If a large customer missed payment because a lockbox check posted after the ACH cutoff, record the reason and new date, then update the next two weeks. Convert the review into actions: escalate a collections call, move a purchase order, or reschedule a nonessential SaaS renewal. The relationship is direct: faster variance clarity creates more runway to intervene before the next payroll clears.
Treat governance like you would a financial close. Keep version control with date-stamped files, require sign-offs from finance and operations, and maintain an audit trail of date moves and decisions. Share the current view with a consistent distribution list that may include the CEO, sales operations, and, when appropriate, investors or board observers. One failure point in stressed situations is ownerless lines that roll forward week after week with stale estimates. Names and due dates fix that.
Use the base case to create fast scenarios. Model a collections slip to reflect a large customer extending terms, a churn spike for a SaaS business, a seasonal dip in retail traffic, or a delayed financing milestone. In each case, set explicit triggers that force action, such as minimum cash equal to two payroll cycles, a looming covenant test, or forecasted cash below a board-approved threshold. Predefine actions in a playbook: pause discretionary marketing, defer a noncritical CapEx deposit, renegotiate a supplier prepay, draw the revolver, or slow open requisitions. A rolling 13-week window that extends to 26 weeks quarterly can show how today’s adjustments cascade into next quarter’s tax and debt obligations.
Expect trade-offs when money is tight. Hoarding cash preserves runway but can starve growth, while keeping an aggressive ad budget might raise pipeline but risk a covenant breach. Build a ranked queue of discretionary spend with ROI notes and test both paths in the model. For example, compare maintaining early payment discounts with a key supplier versus stretching them 15 days. The model should show not only the cash delta this month but the impact on unit costs and shipment timing if the relationship sours.
A cash plan that lives only in finance misses the business’s timing reality. Link weekly receipts to the renewal calendar in your CRM and align invoices with delivery milestones in your project system. Tie outflows to procurement approvals and PO issue dates so a promised vendor prepay does not sneak onto the bank calendar. Sync hiring starts with payroll cutoffs, benefits enrollments, and commission payouts to avoid collision weeks. The relationship to manage is simple but often overlooked: when operating calendars drift from the cash plan, certainty downgrades, and variance grows.
Consider two common scenarios. A SaaS startup with strong ARR but sloppy collections shortens DSO by introducing card-on-file renewals and a tiered dunning cadence. Within two cycles, predictable ACH and card settlements tighten the model enough to avoid an emergency bridge loan. A light manufacturing firm facing lumpy inventory buys works with suppliers on vendor-managed inventory and adjusts purchase order lead times. By matching customer progress billing to deposit schedules and moving to milestone-based prepayments, the firm smooths outflows without starving production lines.
A 13-week cash flow is a management habit, not a one-time spreadsheet. Start with accurate opening balances, map dated inflows and outflows with named owners, and review variances every week. Add scenario branches and action triggers before pressure mounts, so choices are pre-agreed rather than improvised. Tie the cadence to sales, procurement, and people calendars so timing is a shared truth. Keep the annual strategy plan, but let the weekly cash view run the near term. Built this way, the model becomes a practical control system that protects payroll, reduces surprises, and creates room to invest when the numbers support it.
A 13-week cash flow forecast helps ecommerce teams plan dated receipts and payments, review weekly variances, and act before projected cash falls below their operating threshold.
Build a 13-week cash flow forecast for your Shopify store by starting with reconciled available bank cash and scheduling expected receipts and payments into 13 weekly columns. Use processor payout records for ecommerce receipts, customer-level assumptions for wholesale collections, and dated schedules for payroll, inventory, advertising, taxes, and debt. Calculate closing cash each week and carry it into the following week’s opening balance. Assign owners to material inputs, set a minimum cash threshold, and update the forecast weekly using actual bank movements.
A cash flow forecast predicts when money enters and leaves the bank, while a profit budget estimates revenue, expenses, and profitability for an accounting period. Inventory deposits, customer payment delays, loan principal, and annual prepayments can affect cash differently from reported profit. A profitable Shopify brand can therefore face a payment shortfall before expected receipts arrive. Use the profit budget to evaluate business economics and the cash forecast to test whether dated obligations can be funded. Neither replaces the other.
Update your 13-week cash flow forecast every week, and refresh it sooner when a material receipt, payment, or financing assumption changes. Reconcile the completed week to bank activity, compare actual receipts and payments with the saved forecast, and explain important variances. Then update the remaining weeks and add a new week 13. When liquidity is tight, supplement weekly totals with a daily schedule for the next one or two weeks. This catches payment deadlines that occur before receipts within the same week.
Do not include an undrawn credit line in your opening cash balance; show it separately as potential liquidity and record a planned draw when funding is expected to reach the bank. Available borrowing depends on the facility’s terms, conditions, and any applicable borrowing limits. Counting undrawn capacity as cash hides those constraints and risks double counting when proceeds arrive. Keep the forecast’s cash balance distinct from a separate schedule of usable borrowing capacity, and verify draw timing with the relevant lender before relying on it.
When your forecast shows a cash shortfall, verify the underlying dates and amounts, identify the first affected payment deadline, and assign an owner to a funded response. Confirm material collections, review uncommitted discretionary spending, negotiate supplier timing, and evaluate available financing under its actual terms. Test the effect of each response on future receipts, margins, and obligations before approving it. Do not make the forecast look healthier by silently moving contracted payments. If payroll, taxes, or solvency are at risk, involve qualified advisers promptly.
