Cash flow vs profit: plan for payments before they fall due

Do not use sales, profit and cash interchangeably

Sales measure revenue recorded under the applicable recognition policy. Profit compares recognised revenue with the relevant costs and expenses. Cash availability is about money that can be used when a payment is due. Under accrual accounting, an invoice may be recorded before the customer pays, and a stock purchase may happen before the goods become cost of sales.

Do not treat every bank balance as freely spendable if money is restricted or already committed. An unused credit limit is also not the same as cash received from a customer. Keep those distinctions visible when discussing performance with the team.

A worked example: 25,000 profit and a 40,000 cash decrease

Assume recorded sales of 120,000, cost of goods sold of 70,000 and operating expenses of 25,000. Simplified operating profit is 25,000. In the same period, customer cash receipts are only 45,000, cash paid to suppliers for inventory is 60,000, and operating expense payments are 25,000.

There is no contradiction. Some recorded sales remain uncollected, while cash spent buying stock does not necessarily equal the cost of goods sold in the period. The example deliberately excludes tax, financing, asset purchases, depreciation and other details to isolate timing; it is not a complete set of financial statements.

Build a weekly forecast around receipt and payment dates

Start with cash reconciled to bank and cash records. Place expected receipts in the week they are likely to arrive, and payments in the week they fall due. Closing cash = opening cash + receipts − payments. Carry each closing balance into the next week's opening balance rather than resetting the worksheet to the original amount.

Week two is the issue, even though the month finishes with positive cash. A negative figure is an unmet funding or timing need, not an assumption that an overdraft is available. You can extend the worksheet to 13 weeks, but keep uncertainty explicit as the horizon becomes longer.

Do not place the entire receivables ledger in next week's receipts. Review due dates, payment history, disputes and confirmed commitments. Show owner funding or loans on separate lines so they do not look like sales.

Test a late receipt before it becomes a crisis

If 7,000 of week two's receipts move to week three, the week-two closing balance falls to negative 10,000 rather than negative 3,000. This simple sensitivity test reveals dependence on one collection promise. Moving a date forward just to make the spreadsheet positive does not solve the underlying problem.

Review contracts and operating constraints before changing customer or supplier terms. Cancelling unnecessary purchases is different from unilaterally delaying a committed payment. This guide does not select a financing product or recommend borrowing.

• Base case: use dates supported by customer history and current payment agreements.
• Slower-collection case: delay a major uncertain receipt and find the deepest shortfall.
• Unexpected-cost case: add a plausible operating cost and label it as an assumption rather than an existing invoice.
• Action plan: assign an owner and review date to each response; distinguish agreed actions from negotiations.

Look for the bottleneck in the workflow

A service firm may have delivered work that has not been invoiced or accepted. A contractor may depend on a certificate or approval before collection. A trading business may be holding slow-moving products. The useful response depends on the operational cause, not just the total balance on a financial report.

Adapt the calendar and currencies to your market

The arithmetic does not change between Egypt, the GCC and other markets, but payment calendars, documentation and currencies do. Use your actual payroll, rent, holiday and settlement dates. Seasonal trading or major campaigns may affect receipts and purchases differently; check the business history rather than assuming the same effect for every company.

If receipts are in Egyptian pounds while purchases are in US dollars or a Gulf currency, maintain separate currency forecasts or document the conversion assumptions and sensitivity. Adding unlike currencies directly creates a misleading balance. A planning exchange rate is not a guaranteed settlement rate.

Enter tax and other statutory obligations using amounts and dates reviewed for the entity's jurisdiction and activity. Accounting software does not automatically imply tax approval or government integration in every country. Use the forecast to organise known obligations, not to invent a universal regional compliance rule.

Use seven questions in a weekly cash meeting

Bring together the people responsible for collections, purchasing and accounting. Keep the previous forecast and compare it with actual receipts and payments before updating future weeks. The aim is to learn which assumptions failed and assign follow-up, rather than produce a tidier-looking worksheet.

• Is opening cash reconciled to bank and cash records?
• Which receipts are confirmed, and which remain promises?
• Which invoices are disputed or missing supporting documents?
• Which payments have fixed deadlines?
• Which inventory purchases can change without disrupting customers?
• Where is the lowest forecast balance, and what happens if the largest receipt is late?
• Who owns each action, and when will its result be reviewed?

Try the business cycle in MizanX

Create a sample invoice and a partial receipt, then review the remaining customer balance and the relevant cash or account movement under the available plan and permissions. Add a sample purchase and expense and compare recorded sales with actual collections. This is a practical way to test whether the team understands the cycle as well as the software screens.

MizanX brings together invoices, customer and supplier balances, inventory and reports. Use available records as inputs to your forecast. This article does not promise an automatic cash-prediction engine or an unverified direct bank feed. Check required functionality, interface language and integrations in the trial before committing.

Starting a trial requires no payment or card. Entering an email in the article card is only the first step: you then complete company and account details and choose a password. The signup page states the currently available trial duration. Submitting this form does not initiate an automatic charge.

Frequently asked questions

Sources and editorial notes

• Set up a cash flow statement — business.gov.au
• Cash flow forecasting — Business.govt.nz

References support general forecasting principles. The calculations, comparisons and meeting checklist are original educational examples, not customer results or individual tax or financing advice.

Prepared with AI assistance and checked against the linked primary references. Worked examples are hypothetical. Verify country-specific requirements and your own figures before applying them.