Skip to content

G.34Receivables

How to Build a Cash Flow Forecast From Your Receivables

A week-by-week model for a marketing agency that looked healthy every month-end, and the week-12 shortfall the forecast caught nearly three months ahead.

By PayLinkPublished 6 min read

On this page7 sections
  1. 01What you need before you start
  2. 02Step 1: Turn the aging report into expected receipts
  3. 03Step 2: Add receipts from invoices you haven't sent yet
  4. 04Step 3: List everything going out
  5. 05Step 4: Assemble the 13-week forecast
  6. 06Step 5: Read the forecast and act on it
  7. 07Step 6: Roll it forward every week

To build a cash flow forecast from your receivables, start with cash in the bank, then estimate which week each open invoice will be paid, using your aging report and how quickly each bucket has paid in the past. Add receipts from invoices you will send, subtract planned payments, and carry the closing balance forward week by week, usually for 13 weeks.

Definition

A cash flow forecast is a projection of the cash a business expects to receive and pay out over a coming period, showing the expected balance at the end of each week or month. A 13-week cash flow forecast covers one quarter week by week, which is short enough to estimate with reasonable accuracy and long enough to see a shortfall in time to act.

Most of the guesswork in a forecast is on the receipts side. Payroll and rent are known in advance; when customers pay is not. Building receipts from your actual receivables, instead of from a monthly revenue target, is what makes the forecast worth trusting.

What you need before you start

  • Your bank balance today.
  • An accounts receivable aging report, aged by due date.
  • The same report from about a quarter ago, plus the payments received since, so you can see how each bucket actually paid.
  • Your billing plan for the next 13 weeks, both recurring and one-off.
  • Every regular and one-off payment you expect to make.

The example below is a hypothetical digital marketing agency with $85,000 in the bank and $205,000 of open receivables.

Step 1: Turn the aging report into expected receipts

Look at how each aging bucket from a quarter ago was actually collected. Say that of the invoices that were current back then, 55% were paid within four weeks, another 35% in weeks five to eight, and 5% in weeks nine to thirteen, leaving 5% still open. Do the same for each older bucket. Older buckets pay more slowly and less completely, and your own history tells you by how much.

Apply those rates to today's balances:

BucketBalanceWeeks 1–4Weeks 5–8Weeks 9–13Not expected in 13 weeks
Current$120,00055%: $66,00035%: $42,0005%: $6,000$6,000
1–30 days$48,00060%: $28,80025%: $12,0005%: $2,400$4,800
31–60 days$22,00040%: $8,80025%: $5,50010%: $2,200$5,500
61–90 days$9,00025%: $2,25015%: $1,35010%: $900$4,500
90+ days$6,0000%10%: $6000%$5,400
Total$205,000$105,850$61,450$11,500$26,200

Spread each block evenly across its weeks: about $26,500 a week in weeks 1 to 4, $15,400 a week in weeks 5 to 8, and $2,300 a week after that. The forecast expects $178,800 of the $205,000 to arrive within the quarter. The other $26,200 isn't written off; it simply isn't counted on.

Override the averages for large invoices

Averages work for many small invoices. For any single invoice large enough to move the balance, use what you know instead. If a client has told you a $30,000 invoice is scheduled for its payment run on the 15th, put it in that week and take it out of the bucket estimate.

Step 2: Add receipts from invoices you haven't sent yet

Next, forecast the invoices you will issue during the quarter, and push each one forward by how long that kind of invoice usually takes to pay. The agency's billing has two parts:

  • Monthly retainers of $60,000, invoiced in weeks 1, 5 and 9. Clients pay on average about four weeks after invoicing, and roughly 3% runs later than that, so the forecast books $58,200 in weeks 5, 9 and 13.
  • Project invoices of about $15,000 every other week. These take around six weeks to pay, and 5% slips, so $14,250 lands in weeks 8, 10 and 12. Project invoices issued from week 8 onward won't be paid until after the forecast ends.

Step 3: List everything going out

Outflows are easier to forecast because you decide most of them. For the agency:

PaymentAmountWeeks
Payroll$46,0002, 4, 6, 8, 10, 12
Freelancers and contractors$7,000Every week
Rent and software$11,0001, 5, 9
Loan payment$3,5003, 7, 11
Estimated tax payment$18,00010

Don't forget annual and quarterly items such as insurance renewals and tax payments. They are the payments most often missing from a first forecast, and they tend to be large.

Step 4: Assemble the 13-week forecast

Each week's closing cash is its opening cash plus receipts minus payments, and the closing figure becomes the next week's opening. Figures are rounded to the nearest $100 where needed.

WeekOpening cashFrom current receivablesFrom new invoicesPayments outClosing cash
1$85,000$26,500–$18,000$93,500
2$93,500$26,500–$53,000$67,000
3$67,000$26,500–$10,500$83,000
4$83,000$26,500–$53,000$56,500
5$56,500$15,400$58,200$18,000$112,100
6$112,100$15,400–$53,000$74,500
7$74,500$15,400–$10,500$79,400
8$79,400$15,400$14,250$53,000$56,050
9$56,050$2,300$58,200$18,000$98,550
10$98,550$2,300$14,250$71,000$44,100
11$44,100$2,300–$10,500$35,900
12$35,900$2,300$14,250$53,000−$550
13−$550$2,300$58,200$7,000$52,950

Step 5: Read the forecast and act on it

The agency ends the quarter with $52,950, which on a monthly view looks fine. The weekly view shows the problem: in week 12, a payroll week, the account dips below zero before the next retainer payments arrive. A monthly forecast would have averaged it away.

Seeing it nearly three months ahead leaves time for real options:

  1. Bring the retainers forward. Clients pay retainers about four weeks after invoicing. If they were charged automatically on the invoice date through recurring payments, the forecast could book each retainer in the week it is billed (check the actual funding time with your processor). That moves $58,200 from week 13 into week 1, and week 12 closes at about $57,650 instead of −$550.
  2. Collect the older buckets. The forecast counts on only $21,600 of the $37,000 in the three oldest buckets arriving this quarter, which is a cautious assumption. A concerted push on the $22,000 that is 31 to 60 days old could add several thousand dollars to the early weeks. Our guide to collecting unpaid invoices sets out the steps.
  3. Ask for deposits on new projects. A 30% deposit on each $15,000 project invoice issued in the quarter brings $4,500 in at the start of each project instead of six weeks after billing. See deposit invoices for how to set one up.
  4. Arrange a credit line now. If none of the above is enough, a lender will be more receptive to a request made with a forecast in hand, well before the week it is needed.

Step 6: Roll it forward every week

A forecast is most useful when it is updated on the same day each week. Every Monday, replace last week's forecast figures with actual receipts and payments, drop the week just finished, and add a new week 13 at the end. The horizon stays one quarter ahead.

Then compare what you expected to collect last week with what came in. If receipts keep falling short of the forecast, your collection percentages are too optimistic; lower them until the forecast and actuals line up. If one client is behind your estimate every week, call them, and move their invoices into a slower bucket until they catch up. After a few months, the gap between forecast and actual is itself a measure of how well your receivables are being managed.

The forecast also makes every other cash decision easier. Whether to buy equipment this month, or when to draw on credit, are questions the week-by-week numbers answer. For the routine that sits around the forecast, see our guide to cash flow management.

Talk to us

Talk to us about how long you wait to get paid.

Book a free consultation and talk through how this applies to your business. If you have a recent processing statement, bring it along.