ERP Cash Flow Management: Predict Shortfalls 90 Days Ahead & Avoid Saudi Project Failures
TranquilTRANQUIL

ERP Cash Flow Management

Predict Shortfalls 90 Days Ahead & Avoid Saudi Project Failures

Home/Blog/ERP Cash Flow Management: Predict Shortfalls 90 Days Ahead & Avoid Saudi Project Failures
Accounts
October 17, 202511 min read
Share:

Profitable on Paper, Short of Cash

Many Saudi companies that run into trouble are not losing money. Their income statements show healthy profits. What they lack is cash in the bank on the day salaries, suppliers or the VAT return fall due. Contractors waiting on progress payments, distributors selling on 60 to 90 day terms and service firms with a few large clients are especially exposed.

The reason is simple. Profit is measured on an accrual basis: revenue is recognised when you invoice or complete the work, whether or not the customer has paid. Salaries, rent, suppliers and taxes are paid in cash on fixed dates. The gap between the two is working capital, and if nobody manages it deliberately, reported profit turns into a liquidity squeeze.

ERP cash flow management means seeing that gap before you hit it: what will be collected and when, what is owed and when, and where the bank balance will stand each week for the next quarter. This guide covers the practical tools, with hypothetical worked examples and a calendar of the statutory payments Saudi businesses need to plan around.

A Worked Example of Profit Versus Cash

Take a hypothetical distributor that sells SAR 3 million of goods in a quarter at a 20% gross margin, earning SAR 600,000 gross profit. In the same quarter:

  • Customers pay after about 75 days on average, so only around SAR 1 million is collected.
  • Suppliers expect payment within 30 days, so about SAR 2 million goes out.
  • The company builds SAR 500,000 of extra stock ahead of Ramadan.

Gross profit looks good. Operating cash flow is negative by more than SAR 1.5 million before salaries and overheads. The business is not losing money; it is financing its customers and its warehouse out of its own pocket. Every increase in sales widens the gap, which is why companies so often run out of cash in their growth years rather than their bad years.

The Cash Conversion Cycle

The cash conversion cycle (CCC) measures how many days pass between paying a supplier and collecting from the customer:

CCC = days sales outstanding + days inventory outstanding − days payables outstanding

ComponentFormulaHypothetical value
DSOReceivables ÷ credit sales × 36575 days
DIOAverage inventory ÷ cost of sales × 36560 days
DPOPayables ÷ purchases × 36530 days
CCC75 + 60 − 30105 days

If daily cost of sales is SAR 30,000, every day in the cycle ties up SAR 30,000 of working capital. Cutting the cycle from 105 to 85 days releases about SAR 600,000 without a loan or new equity. This belongs on the management dashboard every month, calculated straight from system data rather than estimates.

The 13-Week Rolling Cash Forecast

The most useful single tool is a weekly cash forecast that rolls forward 13 weeks, roughly one quarter. Weekly beats monthly because payroll, tax payments and large supplier runs land on specific days. A month can be positive overall while one week inside it goes below zero.

Building it

  1. Opening balance: all bank accounts at the start of the week.
  2. Expected receipts: open invoices by due date, adjusted for each customer's actual behaviour. A customer who habitually pays 20 days late should be forecast 20 days late.
  3. Expected payments: supplier invoices by due date, plus approved purchase orders not yet invoiced.
  4. Fixed commitments: payroll, rent, loan instalments and GOSI contributions.
  5. Statutory payments: VAT and zakat on their due dates.
  6. Closing balance: compared with a minimum liquidity threshold set by management.

Each week, drop the oldest week, add a new one at the end and compare actuals with the previous forecast. Variances are information, not failure. If receipts always arrive later than forecast, your assumptions about customers need adjusting.

A simplified six-week view

A hypothetical services company (SAR thousands) with a minimum cash threshold of SAR 500,000:

WeekOpeningReceiptsPaymentsClosing
11,2004503801,270
21,2703004201,150
31,1503503101,190
4 (payroll)1,1902801,050420
5420600290730
6730380340770

Across the month the business roughly breaks even, yet week four dips below the threshold because payroll coincides with a large supplier payment. The fix may be easy: agree a one-week delay with that supplier, or bring forward collection of a big invoice expected in week five. But you only see the option if you are looking several weeks ahead.

In an ERP most of these lines already exist as data: open invoices from sales, purchase orders and bills from purchasing, payroll from HR and balances from the bank. The finance manager's job becomes reviewing assumptions and making decisions, not assembling numbers.

Saudi Statutory Payments to Plan Around

A lot of cash surprises come from obligations that were entirely predictable but never made it into the plan:

ObligationDuePlanning note
VATLast day of the month after the tax periodMonthly if annual taxable turnover exceeds SAR 40 million, otherwise quarterly
Zakat and corporate income taxWithin 120 days of financial year endEnd of April for a December year end
PayrollFixed monthly dateWPS file must follow within 30 days
GOSI contributionsMonthlyBased on basic wage plus housing
End-of-service awardsWhen contracts endAccrue monthly and forecast known exits

VAT timing rules matter too. VAT becomes due on the earliest of supply, issue of the tax invoice or receipt of payment, so an advance received before delivery is taxable when it arrives. On the purchase side, if you have not paid a supplier within 12 months of the supply, input VAT you deducted must be reversed. Both affect when tax cash actually leaves the business.

Hypothetical example: a quarterly filer with SAR 4 million of standard-rated sales in the quarter owes SAR 600,000 output VAT and has SAR 390,000 input VAT, leaving SAR 210,000 payable on the last day of the following month. A company that tracks accumulated net VAT weekly sees that payment coming; one that waits for the return does not.

Collections: Where Most Cash Is Trapped

Almost every company has an aged receivables report. Fewer turn it into a daily routine:

  • Segment customers by actual behaviour: pays on time, sometimes late, always late. Base it on payment history in the system, not impressions.
  • Review credit limits: a limit set three years ago may not fit how the customer pays today. The system can block new sales orders when a customer is over limit or has overdue invoices.
  • Chase before due date: a reminder a week before the due date, confirming the invoice was received and is not disputed, works far better than a call a month after it is late.
  • Resolve disputes fast: an invoice held over a quantity difference will not be paid until the dispute is closed. Linking the invoice to a signed delivery note shortens that conversation.
  • Assign ownership: aged receivables by salesperson make collection part of the sales job.

Much late payment starts before the invoice, with an unclear quotation, a short delivery or an invoice error. Our article on the order-to-cash process walks through the whole chain.

Paying Suppliers at the Right Time

The aim is not to stretch suppliers. That damages relationships and tends to come back as higher prices. The aim is to pay exactly when agreed, not earlier without reason and not later.

  • Take early-payment discounts when they pay off: "2/10 net 30" means 2% off for paying within 10 days instead of 30. Paying 98 instead of 100 twenty days early is equivalent to an annual return of about 37%. If the cash is available, that beats most alternatives.
  • Protect critical suppliers: a sole source of a key material is always paid on time.
  • Align large payments with expected receipts: schedule them after, not before, a big expected collection.
  • Three-way match first: purchase order, goods receipt and supplier invoice must agree before anything is paid.

Inventory Is Cash on Shelves

Every riyal in stock that is not moving is a riyal that cannot pay a salary or a supplier. If movement analysis shows that 15% of inventory value has not moved in six months, part of that cash can be released by clearing dead stock at a discount, returning it to suppliers where possible, or at least no longer reordering it. Setting reorder points and safety stock from actual demand, rather than buying habits, keeps the problem from returning.

What-If Scenarios

A single forecast assumes everything goes to plan. It rarely does, so maintain two or three scenarios:

  • What if our two biggest customers pay 60 days later than usual?
  • What if a key raw material rises 15%?
  • What if we win a project that needs 40 workers hired three months before the first client payment?

Take the last one. Forty workers at SAR 5,000 a month each is SAR 200,000 a month, or SAR 600,000 before the first progress invoice is paid, plus materials. If the forecast shows the balance breaching the threshold in week nine, now is the time to negotiate an advance payment or arrange a bank facility, not in week eight.

Early Warning Signs

  • DSO rising two months in a row, even while sales grow.
  • A growing share of receivables more than 60 days overdue.
  • Receivables concentrated in one or two customers.
  • Inventory growing faster than sales.
  • Suppliers asking for advance payment or shortening terms.
  • Overdraft use in the same week every month.

Each of these can be set as a dashboard alert with a threshold, so nobody waits for the monthly meeting to spot it.

When a Gap Appears

OptionBest forWatch out for
Accelerate collectionsAlways; the cheapest optionDiscounts offered to customers have a cost
Reschedule supplier payments by agreementShort, defined gapsNever with critical suppliers
Short-term bank facilityRecurring seasonal gapsArrange it before you need it
Customer advanceNew projects needing start-up fundingVAT is due when the advance is received
Defer capital spendingNon-urgent equipment purchasesEffect on capacity

Projects and Branches

A healthy group balance can hide one project burning cash or one branch funding the rest. Contractors should compare cost incurred on each project with what has been invoiced and what has actually been collected, and treat retentions held by clients as cash that will not arrive until completion. Multi-branch distributors should watch branches that look strong on sales reports but weak on collections. Tagging every transaction to a project or cost center in the system is what makes this possible. See our guide to project budgeting and cash flow for contractor detail.

Bank Reconciliation Underpins Everything

A forecast built on unreconciled balances is not worth much. If the bank is reconciled once a month, two weeks after month end, decisions are made today on numbers that are six weeks old. Reconcile at least weekly so the opening balance of every forecast can be trusted.

Where ERP Fits

A spreadsheet is fine for a first model, but it tires quickly: numbers are copied from several systems each week and copying errors slip through. When sales, purchasing, inventory, payroll and accounting share one system, the cash forecast becomes a natural extension of the data.

Tranquil's accounting and finance module brings sales, purchasing, projects and HR into one set of books, with ZATCA-compliant e-invoicing and bank integration for salary transfers. Reports and multi-level approvals can be customized to match your payment policy. Explore financial management or talk to the Tranquil team about your requirements.

Frequently Asked Questions

What is the difference between cash flow and profit?

Profit is measured on an accrual basis and includes revenue not yet collected and costs not yet paid. Cash flow is actual money in and out. A business can be profitable and short of cash at the same time.

Why forecast weekly rather than monthly?

Because large payments such as payroll, tax and supplier runs fall on specific days. A month can be positive overall while one week inside it is negative.

When is VAT due on an advance payment?

When the advance is received, to the extent of the amount received, even if nothing has been delivered yet, because VAT is due on the earliest of supply, invoice or payment.

What is the fastest way to improve liquidity without borrowing?

Reduce DSO by chasing before due dates, resolving disputes quickly and linking credit limits to real payment behaviour. Clearing dead stock comes next.

Do I need AI for cash forecasting?

Not necessarily. Most accuracy comes from clean, current data and realistic assumptions about customer behaviour. An integrated ERP and a disciplined weekly review are enough for most mid-sized companies.