A 13-week cash flow forecast is a week-by-week projection of the cash you expect to receive and pay over the next quarter. It shows your closing bank balance for each week, so you can spot a shortfall a month or two ahead instead of on the day it arrives. For a small business or freelancer, a basic spreadsheet with 13 weekly columns, about 17 rows, and a few copyable formulas is enough. Update it once a week. Each update adds a new week at the end, which turns it into a rolling cash flow forecast.
More Freelancer Finance Resources
Calculate the difference between pricing and real profit in our free calculator. Pair this forecast with our invoice payment terms guide and business expense tracking tutorial.
Liquidity, Profit, and Insolvency Are Different Problems
Three ideas often get mixed up, and the forecast only measures one of them:
- Profit is income minus expenses over a period, usually measured on an accrual basis. A business can show a profit and still run out of cash.
- Liquidity is whether you have enough cash on hand this week to pay what is due this week. This is what a weekly cash flow forecast tracks.
- Insolvency is a legal and financial condition in which a business cannot pay its debts as they fall due, or its liabilities exceed its assets. One bad week in a forecast does not mean you are insolvent. Persistent shortfalls with no realistic fix are a reason to get professional advice quickly.
What belongs in a cash forecast
- Actual receipts, not invoices. Put cash in the week you realistically expect it to land, not the week you sent the invoice.
- No depreciation. Depreciation is a non-cash accounting expense, so leave it out.
- Owner draws are included. Draws reduce cash even though they are not a P&L expense for a sole trader or partnership.
- The full loan payment. Only the interest portion reaches the P&L, but principal and interest both leave your account.
- Tax on its due date. Record tax in the week you pay it, not the period it relates to.
Build the 13-Week Cash Flow Model in a Spreadsheet
Create a tab named Forecast. Put labels in column A and weeks 1–13 in columns B through N. Enter every input as a positive number, because the formulas already handle the subtraction. The layout works the same in Excel, Google Sheets, or Numbers.
Enter =B16 in C3, then copy column C’s formulas across to column N. Each week now opens with the previous week’s closing balance. If you would rather manage the buffer in one place, use =B17 in C17.
Worked Example: A Freelancer’s First Four Weeks
Maya is a fictional freelance designer. She starts with $6,000 of spendable cash. Her recurring weekly outflows total $2,100: contractors $800, software $200, rent/utilities $300, loan payment $150, owner draw $500, and other costs $150. In Week 2 she also makes a $2,000 tax payment.
Maya’s bank balance never goes negative, but in Week 4 it drops $1,100 below her $1,500 safety buffer. Because she can see this three weeks early, she has time to act. If she collects an additional $1,200 from overdue invoices by Week 4, her closing balance becomes $1,600, which is $100 above the buffer. Other options include pausing her owner draw or moving a contractor payment to a later date.
Three Scenarios Worth Modeling
Copy the Forecast tab twice and change one assumption on each copy. The late client scenario moves the $3,000 Week 1 receipt to Week 3. The higher cost scenario raises contractors, software, and rent/utilities by 20%, which adds $260 per week.
In the late client scenario, total cash received over four weeks does not change, yet the shortfall shows up two weeks earlier. That gap comes purely from timing, and timing is exactly what a monthly view tends to hide.
7-Step, 45-Minute Setup
- Opening cash (5 min): Reconcile today’s actual bank balance and outstanding payments. Either include all available bank cash and forecast tax remittances as outflows, or exclude separately restricted tax reserves and exclude the corresponding remittances from this operating-cash model; do not subtract the same tax twice.
- Build the grid (10 min): Set up rows 3–19 using the formulas above.
- Receipts (10 min): List open invoices and estimate when each will be paid, based on how quickly that client has paid before.
- Fixed outflows (5 min): Add rent, software, loan payments, and payroll on their actual due dates.
- Tax and irregular items (5 min): Enter tax deadlines, insurance, and annual renewals.
- Buffer (5 min): Set a minimum balance. As a first exercise, calculate one or two weeks of essential outflows, then choose a buffer that reflects your actual payment delays, volatility and obligations; there is no universal safe amount.
- Check (5 min): Confirm that Week 1 closing equals opening plus inflows minus outflows. Then look for the first week marked “BELOW BUFFER.”
Tax Timing by Country
Sales taxes you collect are usually owed to the government, not kept by you. Reserve that money and schedule each payment in the week it is due.
- US: Sales tax rules are set by states and localities, and filing frequency varies. Self-employed people also generally make estimated federal income tax payments during the year.
- UK: VAT-registered businesses pay VAT on their return schedule. Self Assessment may require payments on account.
- Canada: GST/HST registrants remit according to their assigned reporting period, and provincial rates differ.
- Australia: GST and PAYG installments are typically reported and paid through your BAS.
13-Week Action Roadmap
- Week 1: Build the model. Output: baseline forecast.
- Week 2: Chase every overdue invoice. Output: a list of promised payment dates.
- Week 3: Record your first variances. Output: forecast vs. actual notes.
- Week 4: Confirm your tax reserve. Output: a separate tax savings balance.
- Week 5: Audit subscriptions. Output: list of cancellations.
- Week 6: Review payment terms. Output: deposit or shorter terms on new quotes.
- Week 7: Run the three scenarios. Output: trigger points for action.
- Week 8: Talk to suppliers. Output: agreed due-date flexibility.
- Week 9: Set your owner-draw rule. Output: draw linked to headroom.
- Week 10: Review financing options before you need them. Output: a written backup plan.
- Week 11: Map the pipeline. Output: likely receipts for weeks 12–20.
- Week 12: Recheck the buffer. Output: updated minimum.
- Week 13: Hold a quarterly review. Output: accuracy score and next quarter’s plan.
The 20-Minute Weekly Review
Each week, replace last week’s forecast numbers with actuals (5 minutes). Calculate the cash variance with =Actual-Forecast for receipts and total outflows (5 minutes). Ask why any large gap happened (5 minutes). Then archive the completed week in a dated snapshot, roll the 13-week window forward by one week, and act on any status flag (5 minutes). If receipts keep coming in late, adjust your timing assumptions rather than hoping the next client pays on time.
Common pitfalls
- Treating your full bank balance as spendable when some of it is collected tax.
- Recording receipts on the invoice date instead of the expected payment date.
- Leaving out annual or quarterly bills.
- Entering outflows as negative numbers, which reverses the formulas.
- Building the forecast once and never updating it.
For more context, see this guide to offering websites to small-business clients, a AI video service-business tutorial, and our small business finance category.
FAQ
Why 13 weeks?
Thirteen weeks is one quarter. That is short enough to forecast with reasonable accuracy and long enough to show quarterly tax payments and slow-paying clients.
Is a monthly cash flow projection spreadsheet enough?
A monthly view can hide a mid-month low point. Weekly columns show it.
Do I need accounting software?
No. A spreadsheet is enough to start. Software can make it easier to pull in actuals later.
Cash or accrual accounting, which matters here?
Your books can use either method, but this forecast always tracks cash, meaning money actually received and paid.
How big should my buffer be?
There is no universal safe amount. Test several buffers against your essential payments, tax dates, and customer payment delays.
What if every scenario goes below the buffer?
Act early. Collect receivables, cut or defer costs, and speak to an accountant or lender before payments are actually missed.
Can I use this with irregular freelance income?
Yes. Forecast irregular income conservatively and rely on the late client scenario to test your plan.
Summary and Next Step
- Track liquidity, not profit. Include draws, loan principal, and tax, and leave out depreciation.
- Use the copyable formulas, keep every input positive, and watch the headroom row.
- Update weekly, compare against actuals, and roll the forecast forward.
Next step: Set aside 45 minutes this week to build your model and find your first “BELOW BUFFER” week.
