A profitable business with a cash shortfall: diagnose the cause and build a payment forecast

Understand why profit and cash diverge

A sale can produce revenue and profit before the customer pays. Inventory consumes cash before it is sold. Equipment purchases and repayment of loan principal also affect cash differently from current-period profit. A profit-and-loss report therefore cannot answer every payment question.

Illustrative example, excluding taxes and other transactions: services produce revenue of TJS 200,000 and recognised expenses of TJS 140,000. Profit is TJS 60,000. Customers have paid only TJS 80,000, while all expenses have been paid. Cash has fallen by TJS 60,000. The uncollected amount remains a receivable, not money available for payments.

IAS 7 treats cash movements separately from financial performance and groups them by activity. The forecast below is a management tool. It does not replace an IAS 7 cash flow statement or imply that every company must apply IFRS Accounting Standards.

Establish the cash actually available

Start with bank statements and physical cash at the same date. Identify restricted funds and money belonging to others separately. Count an instructed but uncleared payment once: either deduct it from the starting balance or include it among forecast payments. An anticipated collection, an unconfirmed facility and an unreconciled accounting balance are not additional available cash.

Maintain separate currency forecasts where necessary. Translating everything into TJS helps consolidate the view but does not establish that a foreign-currency payment can be made. Conversion, charges and the date funds become available still matter.

Exclude transfers between the company’s own accounts from consolidated inflows and outflows. Such transfers do not generate new company cash. Continue checking the balance of the specific account from which a payment must be made.

Build a rolling 13-week forecast

Thirteen weeks is a useful working horizon, not a statutory requirement. Detail the first two weeks by day and the rest by week. Replace estimates with actuals weekly and add the next week. Seasonal businesses also need a longer view.

Give every material line a source: a contract, invoice, payroll schedule, calculation of a required payment or approved purchase plan. For collections, identify the customer, expected date and evidence supporting that date. For payments, record the payee, basis, deadline and person authorised to negotiate a change.

A sales target is not a collections forecast. Separate confirmed, likely and disputed receipts so that uncertainty can be modelled rather than hidden inside one optimistic total.

Calculate the gap at the critical date

Illustration only: opening cash is TJS 50,000. A supplier needs TJS 40,000 on Tuesday; other obligations require TJS 25,000 on Wednesday. TJS 60,000 is expected from a customer on Friday. Taxes, charges and other movements are excluded.

Friday’s positive balance conceals Wednesday’s TJS 15,000 shortfall. The negative line represents an unfunded need; it does not mean an empty account can make the payment. If management requires a TJS 10,000 operating reserve, TJS 25,000 is needed to preserve it.

Check daily timing inside each weekly column. Netting a Friday receipt against a Monday payment can hide several days without sufficient funds.

Distinguish timing problems from structural deficits

A temporary mismatch resolves when a credible later receipt arrives. A structural problem repeatedly requires new funds to support ordinary operations. Borrowing can delay the next shortfall without curing weak margins, excessive customer credit or inventory that is not selling.

Review late-paying customers, cash tied up in stock or unfinished work, and payments growing faster than collections. Analyse receivables by age and reason. A balance within agreed terms requires different action from a disputed amount.

Run a downside scenario, such as moving the largest receipt one week later while retaining required payments. In the illustration, Friday’s TJS 60,000 would no longer resolve the current week’s deficit. Change the underlying collection date rather than manually adjusting a desired closing balance.

Compare responses beyond the amount raised

Possible responses include collecting part of a customer balance earlier, negotiating a supplier schedule, delaying a discretionary purchase or arranging funding. Moving a date in a spreadsheet does not amend the underlying agreement.

For each response calculate cash available before the critical date, next week’s impact, cost and new obligations. Early-payment discounts reduce margin; supplier extensions may affect deliveries; borrowing needs a credible repayment source. Compare the options against the same baseline and downside assumptions.

Keep unconfirmed financing outside the base forecast. Show it as a separate scenario until agreed and available. Check repayment capacity under delayed collections as well as the expected case.

Use the model in a weekly decision meeting

Assign an owner to the forecast and named people to its inputs. Review actual-versus-forecast differences, the lowest balance, the next critical date and decisions requiring the owner. End with actions and responsibilities rather than another unowned spreadsheet.

• A collection moves: update its date and understand the reason.
• A new payment appears: verify its basis and funding.
• The reserve is breached: compare responses before the payment date.
• Forecasts are repeatedly optimistic: revise collection assumptions.

The useful output is a traceable forecast in which every material number has a basis and proposed actions visibly change future balances. Start with reconciled funds, obligations and expected collections. Greater spreadsheet complexity will not repair unreliable inputs.