Business Management

How to Track Cash Flow in a Spreadsheet (and Let AI Build It)

November 13, 2026 3 min read
How to Track Cash Flow in a Spreadsheet (and Let AI Build It)

Profit is an opinion; cash is a fact. A business can show a profit on paper and still miss payroll because a big customer pays in 60 days and the rent is due in 10. A cash flow sheet is the one piece of finance every owner should look at weekly, and it takes a spreadsheet, not an accountant.

What a 13-week cash flow shows

Thirteen weeks is a quarter: far enough to see trouble coming, near enough to be accurate. Each column is a week; each row is money in or out. The bottom line is your bank balance at the end of each week — and if it dips below zero in week nine, you know today.

The rows

SectionRows
Opening balanceCash in the bank at the start of the week
Money inCard and cash sales · Invoices due to be paid · Other income (grants, refunds, loans)
Money outRent · Wages · Suppliers and stock · Software and subscriptions · Marketing · Loan repayments · Tax set aside · Owner's pay
NetMoney in minus money out
Closing balanceOpening + net — becomes next week's opening

Filling it in

  1. Fixed costs first. Rent, wages, subscriptions, loans — these are known and go in the exact weeks they leave the account.
  2. Known income next. Invoices already sent, with the date you realistically expect payment (not the due date — the date they usually pay).
  3. Estimate the rest from the last three months' average, adjusted for the season.
  4. Be pessimistic. Round income down and costs up. The sheet is for finding problems, not for feeling good.

Reading it

  • Lowest closing balance: your danger point. Keep at least a month of fixed costs above it.
  • Weeks that dip: usually payroll or tax weeks. Move spending or chase invoices around them.
  • Trend: if the closing balance falls week after week, the business is shrinking in cash terms whatever the sales look like.

What to do when a dip is coming

  • Invoice faster and chase earlier — ask for deposits or shorter terms.
  • Delay non-essential spending into a better week.
  • Ask suppliers for longer terms before you need them.
  • Run a short promotion to pull income forward.
  • Arrange an overdraft or line of credit while the numbers still look healthy.

Let AI build and update it

Describe the sheet and it appears, formulas and all:

"Build a 13-week cash flow spreadsheet starting next Monday. Rows: opening balance, card sales, invoice payments, rent 2,500 on the 1st, wages 6,000 every 4th Friday, suppliers 1,800 weekly, software 320 monthly, loan 900 monthly, tax set-aside 15% of sales, owner pay 2,000 monthly. Opening balance 9,400. Average weekly sales 4,200, 20% lower in weeks 6–8. Highlight any week where the closing balance is below 5,000."

Each week, paste in your actual figures and ask it to roll the sheet forward and flag what changed. Export your bank statement and let it categorise the transactions.

Weekly habit: ten minutes

  1. Update last week's actual figures.
  2. Add any new invoices or bills.
  3. Look at the lowest closing balance and the trend.
  4. Decide one action if anything looks tight.

Frequently asked questions

Is this the same as a budget?

No. A budget is what you plan to spend over a year. A cash flow is when money actually moves. You need both, but the cash flow is the one that stops surprises.

What about my accountant's software?

It is excellent for what has happened. The 13-week sheet is about what is coming, and it is yours to look at every Monday.

Volnyn's AI Spreadsheets build the sheet from a description, update it from your statements and explain the numbers in plain language. Start free at volnyn.com.