Small Business Cash Flow Sheet, 13 Week Rolling Cash Flow Tracker, Excel Spreadsheet in CAD

$29.00

Small Business Cash Flow Sheet, 13 Week Rolling Cash Flow Tracker, Excel Spreadsheet in CAD

$29.00

A small business cash flow spreadsheet for Excel, in Canadian dollars: a rolling 13 week cash flow you can keep in 20 minutes a week. Enter what came in and what went out; the sheet carries your balance forward, totals every category, and flags the weeks that end below zero while there is still time to collect a receivable, move a payment, or arrange credit on your terms instead of the bank's.

What is inside

Cover: what the file does, how to start, the white and blue cell rule.

Setup: business name, the Monday the first week starts, opening bank balance; everything else reads from these.

Weekly Cash Flow: 13 weeks across, money in (sales receipts, receivables collected, other income) and money out (rent, payroll, inventory, utilities and software, marketing, loan and lease payments, taxes, other), with weekly totals, net, and a closing balance the sheet carries forward.

Category Summary: totals for every category across the 13 weeks, each category's share of its side, and the net over the period.

Cash Health: lowest closing balance, how many weeks end below zero, average weekly net, and the projected balance at week 13.

Planning tool only, not financial or accounting advice. Amounts in Canadian dollars. Works in Excel.

Personalize Your Product

You may also like