# Free 13-week cash flow forecast template for Shopify brands

> Download a free 13-week cash flow forecast for ecommerce as XLSX (Google Sheets or Excel) or CSV. Covers payout lag, fees, supplier POs, ad spend and a minimum cash flag.

Source: https://keelhq.io/tools/13-week-cash-flow-forecast · Published 2026-10-24 · Last verified 2026-10-24

**TL;DR:** A free spreadsheet that turns weekly Shopify sales into cash, lays your bills, payroll, supplier payments and ad spend against it, and flags every week that ends below your minimum cash. It comes as XLSX for Excel and Google Sheets and as CSV, filled with Vandelay Industries sample data. No signup.

**Download**

13-week cash flow forecast (XLSX, for Excel and Google Sheets) · CSV

## What's in it

One sheet, 13 weekly columns, and the rows Keel HQ's own forecast uses:

| Row                                | What it is                                                                                                                                                              |
| ---------------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| As of                              | Today's date. Week 1 starts on that week's Monday, and only the sales from today on are counted, because earlier ones are already in your balance or a scheduled payout |
| Opening cash                       | Week 1 is your balance today; every later week opens where the last ended                                                                                               |
| Sales                              | What customers paid that week, including shipping and tax (you enter it)                                                                                                |
| Cash from sales                    | Sales less fees and refunds, split across this week and next by the payout lag                                                                                          |
| Payouts already scheduled          | Shopify payouts in transit (you enter them)                                                                                                                             |
| Fixed costs, payroll, debt service | Each payment in the week it's paid                                                                                                                                      |
| Supplier payments                  | Purchase order deposits and balances                                                                                                                                    |
| Ad spend, other outflows           | Weekly run rate and one-offs                                                                                                                                            |
| Net cash flow, ending cash         | The totals, rolled forward                                                                                                                                              |
| Below minimum cash?                | **BELOW** when a week ends under your minimum                                                                                                                           |

## The formulas

cash from sales = sales × (1 − fee rate − refund rate)

share paid out the week after = (payout lag in business days + 2) ÷ 7

ending cash = opening cash + cash from sales + scheduled payouts − total cash out

The weekly split is an approximation: it spreads each week's sales evenly over seven days and assumes the lag is 1 to 5 business days. Shopify says payout schedules count business days only and lists a 3 business day minimum settlement time for the United States ([Shopify Help Center](https://help.shopify.com/en/manual/payments/shopify-payments/payouts/payout-timing), accessed 2026-10-24), so use your own payout history for the lag.

## A worked example

The file opens with Vandelay Industries: 50,000 in the bank, a 45,000 minimum, and Black Friday inside the quarter. It flags week 3, where payroll, a loan payment and a purchase order deposit land before sales have turned into cash. The [step-by-step guide](/guides/13-week-cash-flow-forecast-shopify) walks through each row and the full table.

## Make it live

A spreadsheet is a snapshot. [Keel HQ](/features/cash) keeps the same rows current from your Mercury balances, Shopify payouts, bills and purchase orders, and runs 14 weeks.

## FAQ

### Does it work in Google Sheets?

Yes. Upload the XLSX to Google Drive and open it with Google Sheets, or import the CSV into a new sheet. Both keep the formulas.

### What do I change?

The blue cells: the as-of date (today), opening cash, minimum cash, fee and refund rates, payout lag, and one input row per week for sales (in week 1, only the sales from the as-of day on), scheduled payouts and each cost. The black cells are formulas.

### Why is the sample data from Vandelay Industries?

Vandelay Industries is Keel HQ's demo company. Replace every blue cell with your own numbers before you rely on it.

### How is this different from Keel HQ's forecast?

It uses the same core rows. Keel HQ runs 14 weeks and fills them from your bank balances, Shopify payouts, bills, purchase orders and expected payments, with optional sales tax filings, so you don't retype them.

## Sources

- [Understanding Shopify Payments payout timing](https://help.shopify.com/en/manual/payments/shopify-payments/payouts/payout-timing), Shopify Help Center (accessed 2026-10-24)