The core answer
A 13-week cash forecast is a table that sets out, week by week for the next quarter, how much money comes in, how much goes out and how much is left in the bank at the end of each week. Whether you will know in advance which week the money runs short depends on three things: counting only receipts you can realistically collect, on the date they reach the bank; entering every payment that cannot move, on its date; and testing the table against a plan that goes wrong before it does.
The table does not predict the future. It is an early-warning tool. The numbers will be wrong by some amount every week. What matters is comparing them with reality and correcting them. After a couple of months the table gets sharper because you know which customers pay late and which payments you tend to forget.
This guide goes deep on how to build, maintain and use the table. For the bigger picture of why profitable companies run short of cash, and for the tax and contract points that speed up collection, see Profitable but short of cash, which has a summary section on the 13-week forecast. For a new company's first annual budget, see the first-year budget.
Information as of 21 November 2026. The method here is general cash-management practice, not a legal requirement. Every number in the tables is a hypothetical example. For tax and contribution due dates, use the dates that apply to your company and have your accountant or auditor check them.
Who should read which part
| Your situation | Read |
|---|---|
| Before deciding (no table yet, or about to borrow, hire or invest) | Sections 1 to 4 to prepare data and build the table, then the example in section 5 |
| In progress (you already have a table) | Sections 6 and 7 on weekly updates and comparing actuals |
| When the numbers go off plan | Section 5 on off-plan scenarios and section 8 on what to do by weeks remaining |
1. What do you need before you start?
The table is only as good as its inputs. Set aside half a day to collect them the first time. After that the weekly work is short.
| Data | Used for | Source |
|---|---|---|
| Actual cash and bank balances on the start date | Opening cash for week 1 | Latest bank statement, not unreconciled book balances |
| Receivables list by age | Judging who pays in which week | Accounting system or invoice register |
| Each customer's payment history | Adjusting receipt dates to real behaviour | Receipts and bank credits for the past 6 to 12 months |
| Payables list with actual due dates | Supplier payments | Invoices received and credit terms in contracts |
| Payroll, wages and contribution calendar | The large payments that cannot move | HR or the payroll preparer |
| Loan schedules, rent and instalment contracts | Regular payments | Loan, lease and hire-purchase agreements |
| Taxes and contributions to be remitted | Entered on the due dates that apply to the company | Your accountant or auditor |
| Orders, work already won, planned capital spending | Receipts and payments not yet invoiced | Sales and department managers |
If you do not yet have a receivables list by age, make it first. It affects the accuracy of the table more than anything else.
2. Receipts: in which week will you really collect?
The most common mistake is to enter receipts on the invoice date or the contractual due date. Enter them on the date you expect the money to reach the bank.
2.1 Split receipts into three groups
| Group | Test | How to enter |
|---|---|---|
| Confirmed | Invoiced, work delivered and accepted, and the customer has confirmed a payment date or has a steady record of paying on time | In the base case, in the expected week |
| Likely | Near due, customer sometimes pays late, or work is close to delivery | On a separate line, outside the base-case closing balance |
| Uncertain | Long overdue, disputed, not yet delivered, or no order yet | Not in the main table; track on a separate list |
2.2 Adjust dates to each customer's behaviour
- Check how many days late each customer pays on average against their credit terms and enter the receipt that much later.
- A customer that pays in cycles, for example only in the second week of the month, goes in by that cycle.
- Enter a customer that makes up a large share of the quarter's receipts individually, not pooled with others.
- Deposits and advances already received go in on the date received, but check in which week they must be spent on materials or work. See customer deposits and working capital.
- New sales without a purchase order: if you include them, put them in the likely or uncertain group, according to the sales team's confidence. See sales pipeline and quotation follow-up.
2.3 Three questions to test each receipt
- Has this customer ever paid on the date entered? If not, why would this time differ?
- Has the work behind the invoice been delivered and accepted? If not, the customer may be entitled to withhold payment.
- Is there anything the customer could deduct or dispute, such as a late-delivery penalty or rework?
3. Payments: what cannot move, what can
Sort payments by flexibility, not by accounting category, so you can see what can be shifted in a tight week.
| Group | Examples | How to enter |
|---|---|---|
| Cannot move | Payroll and wages, taxes and contributions due on the dates that apply to the company, loan instalments, rent | On the actual due date; watch weeks where several large items land together |
| Negotiable, but ask before the due date | Suppliers, contracted utilities, monthly services that can be deferred by agreement | On the due date first, adjust once a deferral is agreed in writing |
| Your own decision | Capital spending, new hires, bonuses, marketing, over-buying stock | As planned, and the first items you slow down when the table warns you |
Points to watch when entering payments:
- Enter items that do not fall every month: insurance, annual fees, contract renewals and hire-purchase instalments. They are often forgotten because they are not monthly.
- Enter tax and contribution payments on the due dates that apply to your company, and have your accountant check the figures. Do not guess from memory.
- Suppliers that give short credit or require payment before delivery go in on those terms.
- Month-end payroll can fall in week 4 or 5 depending on the calendar. Use the real calendar, not four weeks to a month.
4. The working table: structure and blank template
Use the table below in a spreadsheet or on paper. The rows keep a fixed order so the formulas stay the same. The example in section 5 is in thousand baht.
| Week | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Opening cash | |||||||||||||
| Confirmed receipts | |||||||||||||
| Suppliers | |||||||||||||
| Payroll and wages | |||||||||||||
| Rent and loan instalments | |||||||||||||
| Tax and contributions | |||||||||||||
| Capex and discretionary | |||||||||||||
| Net cash | |||||||||||||
| Closing cash | |||||||||||||
| Minimum line (100) | |||||||||||||
| Headroom over the line | |||||||||||||
| Likely receipts (shown separately, not counted) |
How to calculate
- Net cash = confirmed receipts minus all payments for the week.
- Closing cash = opening cash plus net cash, and next week's opening cash equals this week's closing cash.
- Minimum line = the figure you will not let cash fall below, for example two weeks of regular costs. It is management's decision, not a fixed rule.
- Headroom = closing cash minus the minimum line. A negative figure marks a warning week.
If you are starting from nothing, use the compact version first: four rows only, namely confirmed receipts, payroll and tax, other payments and closing cash. Add detail once you are comfortable.
5. Hypothetical example: the full 13 weeks and an off-plan scenario
Hypothetical example. This is an invented company providing services to business customers, not a real case. All figures are illustrative, in thousand baht. Opening cash is 300 and the minimum line is 100. The tax and contribution dates in the example are placed arbitrarily and are not actual dates.
5.1 Base case (confirmed receipts only)
| Week | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Opening cash | 300 | 300 | 320 | 275 | 190 | 205 | 230 | 180 | 185 | 85 | 165 | 125 | 185 |
| Confirmed receipts | 120 | 90 | 110 | 100 | 130 | 95 | 105 | 115 | 125 | 150 | 110 | 130 | 140 |
| Suppliers | 80 | 70 | 85 | 75 | 75 | 70 | 85 | 70 | 75 | 70 | 80 | 70 | 75 |
| Payroll and wages | - | - | - | 110 | - | - | - | - | 110 | - | - | - | 110 |
| Rent and loan instalments | 40 | - | - | - | 40 | - | - | - | 40 | - | - | - | 40 |
| Tax and contributions | - | - | 70 | - | - | - | 70 | - | - | - | 70 | - | - |
| Capex and discretionary | - | - | - | - | - | - | - | 40 | - | - | - | - | - |
| Net cash | 0 | 20 | (45) | (85) | 15 | 25 | (50) | 5 | (100) | 80 | (40) | 60 | (85) |
| Closing cash | 300 | 320 | 275 | 190 | 205 | 230 | 180 | 185 | 85 | 165 | 125 | 185 | 100 |
| Minimum line (100) | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |
| Headroom over the line | 200 | 220 | 175 | 90 | 105 | 130 | 80 | 85 | (15) | 65 | 25 | 85 | 0 |
| Likely receipts (shown separately, not counted) | 30 | 40 | 20 | 35 | 30 | 45 | 25 | 30 | 40 | 20 | 35 | 30 | 25 |
Reading the table:
- In week 9 closing cash is 85, which is 15 below the 100 line. It is a warning week because payroll, a loan instalment and supplier payments all land together.
- You know from week 1 that a tight week is coming, so you have eight weeks to prepare.
- If the likely receipts were included, week 9 closing cash would be 380 and everything would look fine. That is why the groups must be kept separate. Otherwise the signal disappears.
- In week 13 closing cash equals the line exactly, with no cushion.
5.2 Stress-testing an off-plan scenario
Use the same table, change only the receipt assumptions, and see how the warning weeks move.
| Scenario | Assumption | Weeks with closing cash below 100 | Lowest point |
|---|---|---|---|
| A. Base case | As in table 5.1 | 9 | 85 (week 9) |
| B. Customers pay late | 20 percent of confirmed receipts slip by two weeks | 9, 11 and 13 | 37 (week 9) |
| C. Sales fall | Confirmed receipts down 20 percent from week 5, payments unchanged | 8 to 13 | negative 120 (week 13) |
What the example shows:
- Scenario B does not make the company run out of cash, but it turns one tight week into three. Chasing payment two weeks faster matters more than it looks.
- Scenario C pushes cash negative from week 9. That calls for cutting discretionary spending or arranging funding in advance, not waiting until the balance is negative.
- Run at least two off-plan scenarios: a large customer paying late and receipts falling proportionally. Write down the point at which you will act.
6. Weekly update: the routine that keeps the table usable
A table made once goes stale within weeks. Set a routine that takes no more than an hour.
- Day and owner. Pick the same day each week, for example Monday morning. One person owns the table and a manager or owner reviews it.
- Enter actuals. Replace last week's forecast with actuals from the bank statement.
- Compare line by line. See whether the difference is in receipts, suppliers or a forgotten payment, and note the cause briefly.
- Learn from the gap. If one customer pays later than entered twice in a row, shift that customer's remaining invoices too.
- Adjust the remaining weeks and add week 14 at the end, so the table always looks 13 weeks ahead.
- One-page summary. State the lowest week, the headroom above the line and the decision needed this week.
| Accuracy measure | How to check | If it is poor |
|---|---|---|
| Actual receipts against forecast | Total as a percentage for the past week | Push receipt dates later and review the sales team's assumptions |
| Payments not entered | Count per month | Complete the list of irregular payments |
| Warning weeks that proved right | Did the weeks flagged actually occur | Count fewer uncertain receipts |
7. Who should do it, and with what tools
- A plain spreadsheet is enough for most SMEs. You do not need to buy special software.
- Let accounting or the finance manager own the table. Sales supplies the dates customers are expected to pay and purchasing supplies supplier payment dates.
- The owner or directors read the one-page summary weekly. They do not need to read every line.
- Have your accountant or auditor check tax, contributions and revenue recognition. This guide does not give tax rates or dates it has not confirmed.
To review monthly targets alongside the table, see the monthly management meeting agenda.
8. The table gives a warning. What do you do?
How far ahead the warning week is decides your options. The earlier you know, the more options you have.
| Time before the warning week | What you can do |
|---|---|
| More than 8 weeks | Adjust credit terms with new customers, invoice sooner, slow capital spending and hiring, negotiate a credit line with the bank while the numbers are still good |
| 4 to 8 weeks | Chase confirmed and likely receivables harder, ask suppliers to defer or split payments with written agreement, cut discretionary spending |
| Under 4 weeks | Set a payment order, decide on funding immediately, tell key creditors before the due date, and check whether any financial covenant in a loan agreement may be breached |
- If the numbers suggest a loan covenant may be breached, talk to the bank before the breach, not after the due date.
- If debts exceed what the business can pay, see options when a company cannot pay its debts.
- If cash is stuck in stock, see cash tied up in inventory.
9. Working checklist
- Confirm opening cash from the latest bank statement
- List receivables by age and note the payment history of the largest customers
- Split receipts into confirmed, likely and uncertain, and count only the first group in the base case
- Enter every payment that cannot move on its date: payroll, contributions, tax, loan instalments, rent
- Enter items that do not fall monthly, such as insurance, annual fees and hire-purchase instalments
- Have the accountant check the dates and amounts of tax and contributions that apply to the company
- Set the minimum cash line and record the reason
- Run at least two off-plan scenarios and decide at what point you will act
- Name the table owner, the weekly update day and the one-page summary for management
- Compare actuals with forecast each week and add week 14 at the end
- Book time with the bank or key suppliers early when the table first warns more than eight weeks ahead
Common misunderstandings
- "The profit and loss looks good, so there is enough cash." Accounting profit is not money in the bank. Customers not yet paid, stock already bought and loan instalments are not in profit. Look at the cash table.
- "Entering expected sales is enough." Enter the date the money arrives, not the date of sale. Sales without a purchase order should not be in the base case.
- "The numbers must be right to the baht." The table does not need accounting precision. It needs to show the tight week before it arrives. Small errors are fine. Forgetting a large item is not.
- "Doing it once at the start of the quarter is enough." A table not compared with actuals loses credibility within weeks.
- "A good table gets a loan approved." The table is an internal tool. Lending decisions belong to the lender, and a good table does not guarantee that result.
- "Suppliers can always defer." You must ask, and obtain agreement, before the due date, and check the contract for penalties or interest.
Further reading
- Profitable but short of cash: the cash cycle, tax and contract terms
- First-year company budget: sales, expenses and cash
- Monthly management meeting agenda
- Sales pipeline and quotation follow-up
- Cash tied up in inventory and product profitability
- Options when a company cannot pay its debts
A 13-week cash forecast works when you count only cash you can really collect, enter every payment that cannot move on its date, test the plan against things going wrong, and update it every week, so you see the tight week before it arrives.
We help companies with the legal side of cash pressure, such as payment and penalty terms in contracts, debt collection and negotiating deferrals with creditors. We do not prepare the figures or check tax; we are not accountants or auditors, and we cannot promise that a negotiation with a bank or creditor will succeed. Fees depend on the stage of the matter and the work required. Send us the documents first, and we will give you the scope of work and fees in writing before we start. Call +66 92 254 2045 or send us the details. See also accounting and tax services and business plan services.
This guide is published by Suwanvara Law Firm — a Khon Kaen law firm established in 1986. General information only, not legal advice on a specific matter.

