A customer says the payment will arrive next week. Payroll is due on Thursday, and a supplier needs a deposit before releasing your order. Your sales report looks healthy, but it does not tell you whether you can cover all three.
A 13-week cash-flow forecast puts those dates in one place. It estimates what you expect to collect and pay each week, then shows the cash you expect to have left. You can use it to spot a tight week while you still have time to act.
What goes into a 13-week cash-flow forecast?
Start with available cash, add expected receipts and subtract planned payments for each of the next 13 weeks. Carry each week's closing balance into the following week.
Closing cash = opening cash + cash received − cash paid
Thirteen weeks gives you roughly a quarter of visibility. Weekly columns help you see a payment squeeze that a monthly total might hide. BDC also recommends updating a rolling 13-week forecast at the beginning of each week.
You are estimating future bank movements. Keep the model separate from your historical cash-flow statement and profit report. An invoice can appear in your accounts well before the customer pays it.
Gather the records before opening a spreadsheet
You will need current bank balances, unpaid customer invoices, supplier balances and a calendar of upcoming payments. Add payroll, rent instalments, loan repayments, software renewals and any licence or insurance payments that fall within the forecast.
For tax payments, use the amounts and due dates confirmed for your business. Keep estimates clearly labelled until you have agreed the figures with your accountant.
Outdated records make the forecast harder to trust. If customer balances or bank entries need attention first, A&A's accounting services in Dubai can help you discuss the records and reporting support your business needs.
Build the forecast around actual payment dates
Start with cash you can use
Choose a start date and check the available balance across the business bank accounts in scope. Account for pending payments consistently so you do not deduct the same payment twice. Identify restricted funds separately.
Keep an unused overdraft or an unapproved loan outside the opening cash figure. You can show confirmed funding separately, with its expected drawdown date and any conditions.
Place customer receipts in the week you expect collection
Review the larger invoices individually. A contractual due date is a starting point; a customer's payment history and any unresolved dispute may tell a different story.
Suppose an AED 25,000 invoice falls due in week four. If the customer is waiting for a signed delivery note, check who will provide it and when. Put a realistic collection date in the forecast and record the assumption beside it.
For card or marketplace sales, use the expected settlement date. If you forecast the net payout, do not also deduct fees already withheld from that payout.
Schedule payments when money will leave the bank
Enter supplier payments and recurring costs by payment week. A quarterly rent instalment belongs in the week it is paid; spreading it evenly across three months would hide the cash impact.
Include loan principal repayments and equipment purchases when they are due, even though their treatment in your profit report differs. Depreciation is a non-cash accounting charge; the asset purchase payment belongs in the week you expect to pay it.
Keep tax treatment consistent. If customer receipts and supplier payments include VAT, record the actual gross cash amounts and show the separate expected VAT settlement or refund when applicable. Do not apply a blanket percentage of revenue as a substitute for the business's tax calculation.
A worked 13-week example in AED
Assume a small UAE business starts with AED 80,000 of available cash. Its owner chooses AED 50,000 as a planning buffer. That buffer is a management choice for this example, not a legal requirement or a suitable target for every business.
All figures below are hypothetical. Payments combine supplier costs, payroll, overheads and other scheduled outflows. A working spreadsheet should keep those categories separate so the owner can see what is driving each week.
| Week | Opening cash | Receipts | Payments | Closing cash |
|---|---|---|---|---|
| 1 | 80,000 | 35,000 | 30,000 | 85,000 |
| 2 | 85,000 | 40,000 | 50,000 | 75,000 |
| 3 | 75,000 | 25,000 | 35,000 | 65,000 |
| 4 | 65,000 | 45,000 | 65,000 | 45,000 |
| 5 | 45,000 | 30,000 | 30,000 | 45,000 |
| 6 | 45,000 | 55,000 | 40,000 | 60,000 |
| 7 | 60,000 | 40,000 | 55,000 | 45,000 |
| 8 | 45,000 | 35,000 | 30,000 | 50,000 |
| 9 | 50,000 | 60,000 | 50,000 | 60,000 |
| 10 | 60,000 | 30,000 | 40,000 | 50,000 |
| 11 | 50,000 | 55,000 | 45,000 | 60,000 |
| 12 | 60,000 | 45,000 | 35,000 | 70,000 |
| 13 | 70,000 | 50,000 | 55,000 | 65,000 |
Across the 13 weeks, receipts total AED 545,000 and payments total AED 560,000. The business finishes with AED 65,000: AED 80,000 + AED 545,000 − AED 560,000.
The closing balance falls to AED 45,000 in weeks four, five and seven. The business still has cash, but it has crossed the owner's chosen buffer. That gives the owner specific weeks to investigate.
A weekly closing balance can also hide a midweek shortage. If payroll leaves on Thursday and a large receipt arrives on Friday, check those days separately.
Test what happens if a customer pays late
Now move an AED 25,000 customer receipt from week four to week six, leaving all other figures unchanged.
| Week | Base forecast closing cash | Closing cash with delayed receipt |
|---|---|---|
| 4 | 45,000 | 20,000 |
| 5 | 45,000 | 20,000 |
| 6 | 60,000 | 60,000 |
The balance at the end of week 13 stays the same, but the business has much less room to manage payments in weeks four and five. This is why collection dates deserve as much attention as sales totals.
The owner could follow up on the invoice now, review a discretionary purchase or discuss revised commercial terms with a supplier before committing to them. If funding may be needed, start that conversation early. A forecast should not assume that a lender will approve finance or that a supplier will accept a later payment.
Set up a simple spreadsheet you can maintain
Use columns B to N for the 13 weeks and column A for the row labels. Put actual week-start dates above the figures. The following layout gives you a starting point:
| Row | Label | Week-one entry or formula in column B |
|---|---|---|
| 3 | Opening cash | Enter the checked starting balance |
| 4–5 | Customer receipts; other cash receipts | Enter expected cash amounts |
| 6 | Total receipts | =SUM(B4:B5) |
| 7–12 | Suppliers; payroll; rent and overheads; tax and fees; loan repayments; other payments | Enter payments as positive amounts |
| 13 | Total payments | =SUM(B7:B12) |
| 14 | Net cash movement | =B6-B13 |
| 15 | Closing cash | =B3+B14 |
| 16 | Chosen cash buffer | Enter your planning threshold |
| 17 | Headroom above or below the buffer | =B15-B16 |
In cell C3, enter =B15 to bring forward the previous week's closing balance. Copy the formulas across the remaining weeks. Keep a separate assumptions sheet for major invoices, payment dates and uncertain receipts.
Transfers between bank accounts already included in the same forecast are internal movements. Exclude both sides from total business receipts and payments so they do not inflate your totals.
Keep the forecast useful after week one
Choose one person to maintain the file. At the weekly review, save the previous forecast, enter actual receipts and payments for the completed week, and check the closing cash against the bank records.
Then explain the differences. If you expected AED 40,000 and collected AED 28,000, find out whether the missing AED 12,000 is simply late, disputed or unlikely to arrive. Move a delayed receipt to its revised collection week; remove or reduce it if the assumption no longer holds.
Refresh the remaining weeks and add a new week at the far end so you continue to look 13 weeks ahead. Keep the delayed-payment scenario alongside the main forecast rather than quietly building optimistic assumptions into both.
Questions business owners ask
Can I build this in Excel?
Yes. A spreadsheet can work for a small business if someone maintains the inputs and checks the formulas. Add more detailed schedules or software connections when the number of accounts and transactions makes manual updates difficult.
Should I include invoices that customers have not paid?
Include the cash you realistically expect to collect, in the expected collection week. Keep doubtful or disputed invoices visible in your assumptions rather than treating every unpaid invoice as a certain receipt.
What does a negative forecast balance mean?
It shows a funding gap under the assumptions you entered. Recheck the dates and amounts, then decide what action is feasible before that week arrives. Document any agreed changes and retain contractual and statutory payment obligations in the plan.
How does this fit with an annual budget?
An annual budget supports broader planning. The weekly forecast helps you manage near-term payment timing. You can use both, and reconcile their assumptions through your budgeting and finance planning process.
Bring your payment dates to the next accounting review
A useful first forecast starts with a checked bank balance, a realistic collection schedule and a complete payment calendar. The weekly review is where you find out which assumptions need changing.
If you need help organising those records or preparing a forecast, speak to A&A about accounting and cash-flow forecasting support. Share your latest bank balances, outstanding invoices and upcoming payments so the team can assess the work and agree a scope.
