Skip to main content
SUWANVARA LAWFIRM
Suwanvara Law Firm Co., Ltd.
SUWANVARA LAWFIRM
SUWANVARA LAWFIRM
Suwanvara Law Firm Co., Ltd.
Business Law

13-Week Cash Flow Forecast for Thai SMEs: How to Know Which Week the Money Runs Short (With a Working Table)

How to build and use a 13-week cash forecast step by step: gather the data, separate receipts you can really collect from those you cannot, list the payments that cannot move, stress-test a plan that goes wrong, and update weekly. Includes a hypothetical example table you can copy.

Suwanvara Law Firm— Business Law TeamNovember 21, 202616 min read
13-Week Cash Flow Forecast for Thai SMEs: How to Know Which Week the Money Runs Short (With a Working Table)

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 situationRead
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 planSection 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.

DataUsed forSource
Actual cash and bank balances on the start dateOpening cash for week 1Latest bank statement, not unreconciled book balances
Receivables list by ageJudging who pays in which weekAccounting system or invoice register
Each customer's payment historyAdjusting receipt dates to real behaviourReceipts and bank credits for the past 6 to 12 months
Payables list with actual due datesSupplier paymentsInvoices received and credit terms in contracts
Payroll, wages and contribution calendarThe large payments that cannot moveHR or the payroll preparer
Loan schedules, rent and instalment contractsRegular paymentsLoan, lease and hire-purchase agreements
Taxes and contributions to be remittedEntered on the due dates that apply to the companyYour accountant or auditor
Orders, work already won, planned capital spendingReceipts and payments not yet invoicedSales 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

GroupTestHow to enter
ConfirmedInvoiced, work delivered and accepted, and the customer has confirmed a payment date or has a steady record of paying on timeIn the base case, in the expected week
LikelyNear due, customer sometimes pays late, or work is close to deliveryOn a separate line, outside the base-case closing balance
UncertainLong overdue, disputed, not yet delivered, or no order yetNot 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

  1. Has this customer ever paid on the date entered? If not, why would this time differ?
  2. Has the work behind the invoice been delivered and accepted? If not, the customer may be entitled to withhold payment.
  3. 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.

GroupExamplesHow to enter
Cannot movePayroll and wages, taxes and contributions due on the dates that apply to the company, loan instalments, rentOn the actual due date; watch weeks where several large items land together
Negotiable, but ask before the due dateSuppliers, contracted utilities, monthly services that can be deferred by agreementOn the due date first, adjust once a deferral is agreed in writing
Your own decisionCapital spending, new hires, bonuses, marketing, over-buying stockAs 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.

Week12345678910111213
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)

Week12345678910111213
Opening cash30030032027519020523018018585165125185
Confirmed receipts1209011010013095105115125150110130140
Suppliers80708575757085707570807075
Payroll and wages---110----110---110
Rent and loan instalments40---40---40---40
Tax and contributions--70---70---70--
Capex and discretionary-------40-----
Net cash020(45)(85)1525(50)5(100)80(40)60(85)
Closing cash30032027519020523018018585165125185100
Minimum line (100)100100100100100100100100100100100100100
Headroom over the line200220175901051308085(15)6525850
Likely receipts (shown separately, not counted)30402035304525304020353025

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.

ScenarioAssumptionWeeks with closing cash below 100Lowest point
A. Base caseAs in table 5.1985 (week 9)
B. Customers pay late20 percent of confirmed receipts slip by two weeks9, 11 and 1337 (week 9)
C. Sales fallConfirmed receipts down 20 percent from week 5, payments unchanged8 to 13negative 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.

  1. 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.
  2. Enter actuals. Replace last week's forecast with actuals from the bank statement.
  3. Compare line by line. See whether the difference is in receipts, suppliers or a forgotten payment, and note the cause briefly.
  4. Learn from the gap. If one customer pays later than entered twice in a row, shift that customer's remaining invoices too.
  5. Adjust the remaining weeks and add week 14 at the end, so the table always looks 13 weeks ahead.
  6. One-page summary. State the lowest week, the headroom above the line and the decision needed this week.
Accuracy measureHow to checkIf it is poor
Actual receipts against forecastTotal as a percentage for the past weekPush receipt dates later and review the sales team's assumptions
Payments not enteredCount per monthComplete the list of irregular payments
Warning weeks that proved rightDid the weeks flagged actually occurCount 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 weekWhat you can do
More than 8 weeksAdjust 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 weeksChase confirmed and likely receivables harder, ask suppliers to defer or split payments with written agreement, cut discretionary spending
Under 4 weeksSet 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

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

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.

Frequently asked questions

How is a 13-week cash forecast different from an annual budget?+

An annual budget sets targets for the year. A 13-week forecast shows how much money will be in the bank at the end of each week. It uses near-term figures and is corrected against reality every week, so it can warn you before cash runs out. An annual budget does not do that job.

Should receipts be counted from the invoice date or from the date the customer actually pays?+

Count them on the date you expect the money to reach the bank, not the invoice date or the contractual due date. Use each customer's payment history. A customer who usually pays two weeks late goes into the table two weeks late.

Should uncertain receipts go in the table?+

They can, but on a separate line and outside the base-case closing balance. If you mix them in, the table looks better than reality and you will see the tight weeks too late.

Which payments cannot be delayed?+

Usually payroll and wages, loan instalments, tax and contributions payable on the dates that apply to your company, and rent. Supplier payments, capital expenditure and bonuses may be negotiable, but ask before the due date and check the terms of each contract.

How often should the table be updated, and by whom?+

Weekly, on the same day, by one named person. Replace last week's forecast with actuals, adjust the remaining weeks, and add week 14 at the end so the table always looks 13 weeks ahead.

If the table shows cash will run short next week, what comes first?+

Start with what you control: chase the receivables that are likely, set a payment order, and ask suppliers to defer or split payments before the due date. If you need a credit line or outside funding, talk to the provider while you can still pay.

Lawyer-client handshake symbolizing trust at Suwanvara Law Firm

Ready to hear your story

Get an initial consultation with one of our experienced attorneys.