Spreadsheets

A 13-week cash flow forecast sheet for a freelancer

Build a 13-week cash flow forecast sheet for a freelancer: client payments, known bills, opening and closing balance, and a flag for the week the balance runs low.

Editorial illustration for A 13-week cash flow forecast sheet for a freelancer

A 13-week cash flow forecast is a sheet with one column per week, rows for money you expect in and money due to go out, and an opening and closing balance carried from week to week. For a freelancer, whose income arrives on clients' schedules rather than a payday, it shows the week your balance is likely to go low while you still have time to act.

How do I lay the sheet out?

Use column A for labels and columns B to N for weeks 1 to 13. Here is one layout, with the formulas for week 1 in column B:

RowLabelWeek 1 entry
1ItemWeek 1, Week 2 ... Week 13
2Week startingB2: a start date you type; C2: =B2+7, then fill right
3Opening balanceB3: your balance today; C3: =B14
4 to 6Client A, Client B, Other incomeAmounts you expect to receive that week
7Total in=SUM(B4:B6)
8 to 12Rent, EMI, bills, household, tax set-asideAmounts due that week
13Total out=SUM(B8:B12)
14Closing balance=B3+B7-B13
15Check=IF(B14<$B$16,"Low","OK")

Put your minimum comfortable balance in B16, the cushion you want to keep. Fill C3 and the formulas in rows 7, 13, 14 and 15 across to column N.

What do I enter for each client?

Enter a payment in the week you realistically expect the money in your bank, not the week you invoiced. If a client usually pays 30 days after the invoice, put it a month out. If you are unsure, put it a week later than hoped. A forecast that is a little pessimistic is more useful than one that is cheerful.

What are the known bills?

Go through the last three months of your bank statement and list everything that repeats: rent, EMI, society maintenance, insurance premiums, electricity, mobile and internet, subscriptions. Put each in the week its due date falls. Monthly items appear three times in 13 weeks; yearly items appear once or not at all. For tax, put a set-aside amount in a row of its own and confirm the amount and dates with your CA, as these change.

A four-week example

Say you start with ₹40,000. Rent ₹18,000, EMI ₹7,000 and bills ₹3,000 fall in week 1. A client payment of ₹50,000 is expected in week 3. All numbers are made up.

WeekOpening (₹)In (₹)Out (₹)Closing (₹)
140,000028,00012,000
212,00004,5007,500
37,50050,0002,00055,500
455,50006,00049,500

With a cushion of ₹20,000 the Check row flags weeks 1 and 2 as Low. If the client pays one week late, week 3 also turns Low. The forecast has shown you two things: you are thin for two weeks, and you rely on one client.

How do I find the lowest week?

  • Lowest closing balance: =MIN(B14:N14)
  • Which week: =INDEX(B1:N1,MATCH(MIN(B14:N14),B14:N14,0))

The second formula looks up the week label above the lowest closing balance. Put both at the top of the sheet.

What do I do when a week looks tight?

Use it as a planning prompt: chase an invoice, ask for a part-payment up front, postpone a non-urgent purchase, or talk to a lender or landlord before a due date rather than after. These are options to weigh, not advice about what you should do.

Where does an app fit?

The bills come from your actual history. SpendixAI can import your bank statements so you can look at the last three months, and its Pro plan has bills and budgets. It is not a forecasting tool, so the 13-week sheet stays a sheet.

Checklist

  • Opening balance matches your bank today.
  • Payments entered in the week you expect cash, not the invoice week.
  • Every recurring bill placed in its due week.
  • Cushion set, check row filled across.
  • Updated every week.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports