How to Build a 13-Week Cash Forecast Management Can Use

What is a 13-week cash forecast?

A 13-week cash forecast is a weekly projection of the money a business expects to receive, the payments it expects to make, and the resulting cash balance. It helps management identify potential shortages early enough to improve collections, reschedule discretionary spending, discuss supplier terms, or assess funding requirements.

The forecast normally starts with the cash available in the company’s bank accounts. It then adds expected receipts and deducts expected payments for each of the next 13 weeks.

The basic calculation is:

Beginning cash balance + expected cash receipts − expected cash payments = ending cash balance

Each week’s ending balance becomes the following week’s beginning balance.

This structure is simple, but the quality of the forecast depends on the quality of the assumptions behind it.

Why is a 13-week period useful for UAE businesses?

Thirteen weeks gives management enough forward visibility to identify upcoming pressure while keeping the forecast close enough to current operations to remain practical. It covers approximately one business quarter, allowing owners and finance teams to see payroll cycles, customer collection patterns, supplier commitments, rent, financing payments, and expected tax-related outflows.

A shorter forecast may not show a problem that is developing two or three months ahead. A much longer weekly forecast may rely too heavily on assumptions that cannot yet be supported.

For UAE SMEs, the 13-week period can be particularly useful where cash is affected by:

• Customer credit terms of 30, 60, or 90 days
• Post-dated cheques
• Project milestone billing
• Seasonal sales patterns
• Large inventory purchases
• Annual rent or insurance payments
• VAT payment timing
• Corporate tax provisioning
• Loan repayments
• Free zone or mainland licence renewal costs

The forecast does not replace annual budgeting or monthly financial reporting. It answers a different question: what is likely to happen to available cash over the next few weeks?

A cash forecast becomes useful when management can connect each weekly balance to a specific commercial decision, payment commitment, or collection action. — Consulting Journal editorial observation

What management decisions can the forecast support?

A well-maintained forecast helps management decide what can be paid, what may need to be delayed, which receivables require attention, and whether additional funding should be considered. It also allows decisions to be made before a bank balance becomes critical rather than after suppliers, employees, or lenders are already affected.

Management can use the forecast to consider questions such as:

• Will sufficient cash be available for the next payroll?
• Which customers must be followed up this week?
• Can a planned equipment purchase proceed?
• Should inventory orders be reduced or rescheduled?
• Is there enough liquidity for a new hire?
• Will an upcoming tax or licence payment create pressure?
• Should supplier payment terms be renegotiated?
• Is short-term working capital finance likely to be required?

The forecast should not make these decisions automatically. Its role is to show the expected timing and size of the cash impact so management can act with better information.

What information is needed before building the forecast?

A reliable forecast requires current bank information, realistic customer collection expectations, confirmed or expected payment commitments, and clear ownership of the underlying assumptions. Businesses should avoid building the forecast only from the general ledger because accounting entries do not always reflect the week in which cash will actually move.

Finance teams should gather:

• Current balances for all operating bank accounts
• Accounts receivable ageing
• Customer-specific payment history
• Expected sales invoices and billing milestones
• Accounts payable ageing
• Supplier payment terms
• Payroll dates and related employment costs
• Rent and lease payment schedules
• Loan and finance repayment schedules
• Credit card settlement dates
• Inventory and procurement plans
• Utility, insurance, and software renewal dates
• Planned capital expenditure
• VAT and corporate tax payment estimates
• Licence renewal and regulatory fees
• Expected owner funding, loans, or investment proceeds

The most important distinction is between revenue and cash receipts. An invoice issued this week is not necessarily cash received this week.

How should a 13-week cash forecast be built?

The forecast should be built as a simple weekly model that starts with available cash, records expected receipts and payments, and calculates the closing balance for each week. Management should be able to understand the main movements without navigating multiple files, hidden assumptions, or unnecessary accounting detail.

Step 1: Confirm the opening cash position

Begin with the cleared or available bank balance at the forecast start date.

Exclude amounts that are restricted, blocked, held as security, or otherwise unavailable for normal operations. Where a business uses several bank accounts, combine them only after confirming that the balances are usable and that transfers between accounts are practical.

The opening balance should reconcile to bank records.

Step 2: Forecast customer collections

Estimate when customers are likely to pay, not when invoices were issued or when contracts say payment is due.

Review each material receivable and consider:

• The contractual due date
• The customer’s actual payment history
• Whether the invoice has been approved
• Whether supporting documents have been submitted
• Whether a dispute or credit note is pending
• Whether payment depends on a project milestone
• Whether a post-dated cheque has been received
• Whether the customer has recently delayed other payments

Smaller receivables may be grouped using historical collection patterns, but large balances should normally be assessed individually.

Example 1:

A Dubai-based professional services company has AED 900,000 recorded in accounts receivable. Its accounting report appears strong, but only AED 240,000 is likely to be collected within the next four weeks. One major invoice is awaiting client approval, while another customer usually pays 20 days after the contractual due date.

The 13-week forecast helps management separate reported receivables from expected cash. The company can then prioritise collection follow-ups, postpone non-essential spending, and avoid treating the full AED 900,000 as immediately available.

Step 3: Forecast other cash receipts

Include other expected inflows only where there is a reasonable basis for the timing and amount.

These may include:

• Owner or shareholder funding
• Loan proceeds
• Security deposit refunds
• Insurance claims
• Asset sale proceeds
• Investment income
• Grants
• Intercompany receipts
• Tax refunds where timing is sufficiently clear

Avoid entering uncertain funding as though it were confirmed. A financing application, investor discussion, or proposed asset sale should be identified separately until approval and timing are reasonably established.

Step 4: Forecast weekly cash payments

Record payments in the week they are expected to leave the bank account.

Typical outflows include:

• Salaries and wages
• Employee benefits
• Supplier invoices
• Rent and service charges
• Utilities and telecommunications
• Inventory purchases
• Freight and customs costs
• Loan principal and interest
• Insurance premiums
• Software subscriptions
• Marketing commitments
• Professional fees
• VAT and corporate tax payments
• Licence renewals
• Capital expenditure
• Owner withdrawals or distributions

Separate essential payments from discretionary payments. Payroll, critical suppliers, rent, utilities, and statutory liabilities may require different treatment from optional travel, non-urgent equipment, or a campaign that can be rescheduled.

Step 5: Calculate weekly ending cash

For each week, add total expected receipts to the opening balance and deduct total expected payments.

The closing balance should then become the opening balance for the following week.

Where the forecast falls below a minimum acceptable cash level, management should identify the cause. A weak week may result from delayed collections, an annual payment, a large inventory order, or several obligations falling due together.

The cause matters because the response will differ.

Step 6: Add scenarios without overcomplicating the model

A base case should reflect the most realistic expected outcome. Management may also consider a downside case and an upside case.

A downside case could assume:

• Selected customers pay later
• Sales receipts are lower
• A supplier requires earlier settlement
• An unexpected repair or legal cost arises
• Funding is delayed

An upside case could reflect faster collections or stronger sales, but it should not be used to justify commitments that the base case cannot support.

The objective is not to create dozens of scenarios. It is to understand which assumptions create the greatest liquidity risk.

How should the forecast be updated each week?

The forecast should be updated weekly by replacing the completed week with actual cash movements, investigating differences, and adding a new thirteenth week. This rolling process keeps the model connected to current bank balances, customer behaviour, supplier commitments, and management decisions.

A disciplined weekly process normally includes:

1. Reconcile the opening cash balance to the bank.
2. Replace forecast receipts and payments with actual results.
3. Record material variances.
4. Review overdue customer balances.
5. Update supplier and payroll commitments.
6. Revise assumptions for the remaining weeks.
7. Add a new week at the end.
8. Highlight decisions required from management.

Forecast accuracy should improve over time. If it does not, the business should examine whether information is arriving too late, assumptions are too optimistic, or responsibility for updating the forecast is unclear.

Which variances should management review?

Management should focus on material differences between forecast and actual cash, especially those that may repeat. A variance is not simply a spreadsheet error. It may reveal a customer collection problem, weak purchasing controls, unrecorded commitments, inaccurate sales assumptions, or communication gaps between finance and operations.

Useful questions include:

• Which receipts arrived late, and why?
• Were customer promises documented?
• Which payments were higher than expected?
• Did departments commit spending without informing finance?
• Were taxes, renewals, or annual charges omitted?
• Did the forecast assume revenue would convert to cash too quickly?
• Are the same variances recurring every week?

A forecast should become more accurate because the business learns from these differences.

Common mistakes business owners make

Forecasting sales instead of collections

Sales invoices and accounting revenue do not equal available cash. The forecast should reflect when customers are expected to pay.

Assuming every customer follows contractual terms

A 30-day payment term does not mean every invoice will be settled on day 30. Actual customer behaviour is often a better starting point.

Ignoring individual large receivables

A single delayed project payment can materially change the cash position of an SME. Large balances should be reviewed separately.

Recording monthly totals without weekly timing

A business may appear to have enough cash for the month while still facing a shortage before a major receipt arrives.

Forgetting irregular payments

Annual insurance, licence renewals, bonuses, deposits, equipment purchases, tax liabilities, and software renewals can create pressure if omitted.

Treating unapproved funding as confirmed cash

Potential borrowing or investor funding should not be relied upon until the business has sufficient confidence in approval, amount, and timing.

Making the model too complicated

Excessive detail can make the forecast difficult to maintain. Management usually needs clear categories, reliable assumptions, and visible decision points.

Failing to assign ownership

A forecast without a responsible owner often becomes outdated. One person should coordinate the weekly process, even where information comes from several departments.

What documents should be prepared?

A business should prepare enough supporting information to verify opening cash, customer collection timing, payment obligations, financing movements, and statutory commitments. The forecast should be traceable to source documents so that management can challenge assumptions and understand why a particular receipt or payment appears in a specific week.

The preparation checklist should include:

• Recent bank statements and online balances
• Bank reconciliation records
• Accounts receivable ageing
• Copies of major unpaid invoices
• Customer payment commitments
• Sales and project billing schedules
• Accounts payable ageing
• Supplier statements
• Purchase orders and approved commitments
• Payroll summaries and payment dates
• Employment-related payment schedules
• Rent and lease agreements
• Loan and finance schedules
• Insurance renewal notices
• Tax calculations and payment calendars
• Trade licence renewal information
• Capital expenditure approvals
• Inventory purchase plans
• Details of expected funding or shareholder support

Example 2:

A mainland trading company in the UAE plans to place a large inventory order before a seasonal sales period. Its profit forecast supports the purchase, but the 13-week cash forecast shows that the supplier deposit, payroll, VAT payment, and warehouse rent will fall within the same three-week period.

Management divides the order into two shipments and agrees revised payment terms with the supplier. The decision does not reduce expected sales; it reduces the risk created by payment timing.

How can KPM Global Services UAE assist?

KPM Global Services UAE can support business owners and finance teams in building a practical cash forecasting process based on actual banking, accounting, receivables, payables, payroll, tax, and operational information.

Depending on the business’s requirements, support may include:

• Designing a 13-week cash forecast
• Reviewing the reliability of source data
• Mapping customer collection assumptions
• Organising supplier and statutory payment schedules
• Establishing weekly forecast-versus-actual reviews
• Identifying working capital pressure points
• Improving management reporting
• Coordinating cash forecasts with budgets and financial plans
• Supporting finance teams with accounting record quality
• Preparing management information for funding discussions

The objective should be to give management a forecast it can understand, maintain, and use. No forecast can remove uncertainty, but a structured process can show where uncertainty exists and which assumptions require attention.

Final advisory conclusion

A 13-week cash forecast is most valuable when it becomes part of the weekly management routine.

The model should be simple enough to update, detailed enough to explain material cash movements, and realistic enough to challenge optimistic assumptions. Its purpose is not to predict every dirham perfectly. Its purpose is to give management enough warning to act before a cash issue becomes urgent.

For UAE businesses, that may mean accelerating collections, adjusting purchasing, protecting payroll, planning for tax and licence obligations, discussing supplier terms, or evaluating funding earlier.

The forecast should remain connected to bank balances, customer behaviour, supplier commitments, and actual business decisions. When those inputs are current, the forecast can provide a practical view of short-term liquidity that monthly financial statements alone may not show.

This article is for informational purposes and does not constitute legal, tax, accounting, or financial advice.