The 13-Week Cash Flow Forecast: A Template for a Small Business

A business closes its best month. The profit report looks excellent. Three weeks later the owner is moving personal savings into the company account to cover payroll. Nothing was stolen and nothing was miscounted. The customers simply have not paid yet, and the suppliers were paid on delivery. A 13-week cash flow forecast is the tool that would have shown that week coming two months earlier.

What it is

A table with thirteen columns, one per week, and three blocks of rows:

1. Cash in. What you expect to receive each week.
2. Cash out. What you expect to pay each week.
3. Balance. Opening balance, plus cash in, minus cash out, giving the closing balance, which becomes next week's opening balance.

That is the whole structure. Its value comes from being filled with real expectations and updated every week.

Step 1: the opening balance

Add up what is in the business bank accounts and cash today. Use the actual bank balance, not the balance in the books, and exclude money that is not yours to spend, such as customer deposits you may have to refund or tax you have collected and will remit.

Step 2: cash in

List each expected receipt in the week you expect it to arrive, not the week it is due.

• Unpaid invoices. For each customer, use the date they usually pay. If a customer on 30-day terms always pays on day 45, put day 45.
• Confirmed orders not yet invoiced. Estimate invoice date plus their usual delay.
• Regular cash sales. Use the average of recent weeks, adjusted for the season.
• Other receipts. A loan drawdown, a deposit, a refund from a supplier.

Be conservative. If you are not sure a payment will arrive in week 5, put it in week 6.

Step 3: cash out

• Payroll. With the dates, including holiday allowance and bonuses in the weeks they fall.
• Suppliers. Each bill in the week you will pay it.
• Rent, utilities, subscriptions.
• Loan instalments.
• Taxes and social contributions. These are easy to forget because they are not weekly.
• Planned purchases. Equipment, stock for a season, a deposit on a new location.
• Owner's drawings. If you take money out, it belongs here.

Step 4: read the result

Look along the closing balance row and find three things.

• The lowest point. Which week, and how much.
• Any week below zero. That is a week you cannot pay everything.
• Any week below your safety level. Decide a minimum you are comfortable with, for example enough for two weeks of payroll and rent.

A small example

Opening cash: 80 million rupiah.

Figures in millions. Week 3 carries payroll and a large supplier payment. The balance falls to 25 and then to 15 in week 4, before a large customer payment arrives in week 5. If that customer pays one week late, week 5 opens at 15 with 25 to pay. The forecast shows this on day one, when there are still four weeks to act.

What to do about a shortfall

With weeks of warning there are options:

• Collect sooner. Call the customers whose invoices fall due before the low point. Offer a small discount for early payment if it is cheaper than borrowing.
• Invoice sooner. Work delivered and not yet invoiced is cash you have delayed yourself.
• Ask for deposits on new orders.
• Move payments. Ask a supplier for two more weeks before the due date, not after it.
• Delay a purchase that is not urgent.
• Arrange a facility while the numbers still look healthy. Lenders are more willing before the crisis than during it.

The weekly routine

Thirty minutes, the same day each week:

1. Replace last week's forecast with what actually happened.
2. Compare. Where were you wrong, and why?
3. Move anything that did not arrive into the week you now expect it.
4. Add a new week 13 at the end.
5. Look at the lowest point again and decide whether anything needs doing.

Step 2 is what makes the forecast improve. After a month you will know which customers pay late and by how much, and you will stop being surprised.

Common mistakes

• Using due dates as payment dates.
• Forgetting irregular payments: tax, annual insurance, holiday allowance.
• Counting hoped-for sales as cash.
• Building it once and not updating it.
• Mixing personal and business money, which makes the opening balance meaningless.
• Treating the forecast as a target. It is a prediction. Its job is to be right, not to look good.

Tools

A spreadsheet is enough. What helps is having the inputs to hand: a list of unpaid invoices with customer names and dates, and a list of bills to pay. If your invoices and expenses are already recorded in one system, as in the bookkeeping part of Polynusa, pulling those two lists each week takes minutes. The forecast itself, and the judgement about when a customer will really pay, remains yours.

Summary

Start with the real bank balance. Place each expected receipt and payment in the week the cash will move, conservatively. Find the lowest point and compare it with your safety level. Update every week, replacing forecast with actual and adding a new week. A forecast kept this way gives you weeks to deal with a shortfall that would otherwise arrive as a surprise.

FAQ

Why 13 weeks and not 12 months?

Thirteen weeks is one quarter, far enough to see trouble coming and near enough that most receipts and payments are already known from invoices, orders and bills. A 12-month forecast is useful for planning, but its later months are guesses. The 13-week view is for managing cash.

How accurate does the forecast need to be?

The first four weeks should be close, because they are built from real invoices and bills. Later weeks will be rougher. The purpose is to see a shortfall early enough to act, and a forecast that is roughly right every week does that better than a precise one made once.

What is the difference between a cash flow forecast and a profit and loss report?

A profit and loss report records income when it is earned and costs when they are incurred. A cash forecast records money when it actually arrives and leaves. A sale on 60-day terms is profit today and cash in two months, and that gap is what the forecast exists to show.