Which monthly reports help me understand why sales rose but cash fell?

Start with two questions instead of one headline

“Did sales rise?” and “Why did cash fall?” are different questions. Sales describe business activity recognised in the reporting period. Cash reflects actual receipts and payments. The timing and nature of those events can differ, so a higher sales figure does not guarantee a higher bank balance.

First confirm that the reports cover the same company and dates and have been properly reconciled. A comparison between calendar-month sales and a bank balance taken midway through the next month can create confusion before any real analysis begins.

The IFRS Foundation’s IAS 7 overview explains the distinction between operating, investing and financing cash flows. A practical monthly pack should help the owner see those different causes of movement without requiring them to reconstruct every transaction.

Use the profit report to test the sales story

Compare sales, direct costs and operating expenses with the earlier period and budget. Determine whether the sales increase came from more work, a price change, a particular large transaction or a change in how items were recorded. Higher turnover can coincide with lower margins or additional delivery costs.

Ask whether the result includes credit notes, returns and costs relating to the sales. An impressive sales total can be misleading if related costs have not yet been captured. The bookkeeper should identify incomplete records rather than letting the owner assume the margin is final.

Keep unusual transactions visible. A single sale of equipment is different from recurring customer revenue. Classify and explain it appropriately so that the owner does not mistake a one-time event for a sustainable increase in trading activity.

Read customer balances to see where sales became unpaid debt

An aged customer-balance report shows amounts still owed and helps identify overdue or disputed invoices. Compare the closing total with the previous month and investigate significant increases. The question is not only how much was invoiced, but when the related cash is realistically expected.

Review large balances individually. Check whether invoices reached the right customer, whether supporting documents were accepted and whether a dispute is delaying payment. A contractual due date is useful, but it is not evidence that cash will arrive on that date.

Assign collection actions to specific people and record the latest evidence. Do not resolve a cash forecast by simply moving all unpaid invoices into next week. The timing should reflect what is known and show uncertainty where it remains.

Check inventory and supplier movements

A growing business may buy stock before selling it, or pay suppliers before collecting customer invoices. Cash can therefore be tied up in goods and in the period between paying for inputs and receiving customer money. Review stock movement and supplier balances together.

Look for purchases made for future demand, slow-moving stock and unusually large settlements of old supplier balances. These explain different issues: planned investment in stock, goods that are not selling and cash used to settle earlier obligations. They should not all be described as the current month’s expense increase.

Ask whether the timing assumptions still work. If customers pay later while suppliers require earlier payment, growth may increase cash pressure. The reports should make that mismatch visible before the owner commits to further orders.

Ask for a cash bridge with a clear opening and closing balance

The figures are fictional and illustrate the logic, not a model return or a complete financial statement. Positive profit coexists with a cash decline because working balances, equipment and financing movements affect cash differently. A real bridge must use the business’s reconciled records and applicable treatment.

Separate equipment and financing from ordinary trading

A significant equipment purchase can reduce cash even though the full payment is not treated as an ordinary expense in the same period. Loan principal repayments also use cash without representing a new operating expense. Review these movements separately from day-to-day trading costs.

Similarly, a new loan or owner contribution can increase cash without being customer revenue. If these receipts are grouped with sales collections, the owner may think trading is generating more cash than it actually is. The source of the cash matters when planning the next month.

Match the movements to asset records, loan statements and the underlying agreements. The labels on bank transactions are only a starting point. Ask the preparer to explain large items and confirm that transfers between the company’s own accounts are not being counted as fresh cash generation.

Review tax and payroll payment timing

Tax, payroll and related payments can fall in a month different from the underlying activity reflected in the profit report. Review the applicable liabilities and payment schedule rather than treating every large bank payment as a surprise expense of the month.

The relevant amount and due date should come from the business’s actual returns, statements and current requirements. Do not copy a generic calendar into the forecast without checking the taxpayer, tax type and period. Keep amounts being investigated separate from confirmed obligations.

Payroll also contains a distinction between gross cost, deductions and the net amounts paid to employees. A payment-only view can miss liabilities still to be settled. The monthly review should connect the payroll records with both the bank movements and outstanding balances.

A report map for the owner’s review

Ask for commentary on the significant movements rather than a stack of unexplained reports. The owner should be able to identify the cause, the supporting evidence and any action needed.

Turn the explanation into a realistic forecast

Once the past movement is understood, update the forward cash forecast. Use realistic customer collection dates, planned supplier payments, payroll, tax and approved spending. Separate committed items from proposals and show important uncertain receipts as scenarios.

A forecast should not assume that last month’s sales increase immediately fixes next month’s cash pressure. Check whether new orders require deposits, stock or staffing before the business receives payment. Growth can increase the cash needed to operate.

Use the cash flow management service when timing and funding needs require focused support. The historical explanation and forward forecast should use consistent records, while remaining clearly distinguished as actual results and assumptions.

Investigate an unexplained difference before making decisions

If the cash bridge does not reconcile to the opening and closing balances, ask what is missing. Common areas to investigate include omitted accounts, duplicated transfers, unreconciled payment processors and changes in the dates used for the comparison. Do not insert an unexplained “other” figure merely to make the total agree.

Document the difference and its possible effect on the owner’s decision. A small known timing item is different from a large unidentified movement. The reviewer should explain the limitation and the plan for resolving it.

The monthly close checklist supports the underlying reconciliations. Reliable explanation depends on those records, even when the finished management pack is concise.

Ask for management accounts that answer the business question

For recurring reports and interpretation, enquire about management accounts and explain the decision the owner needs to make. Useful context includes customer payment patterns, stock requirements, recent borrowing and planned equipment purchases.

If the basic records are incomplete, monthly bookkeeping may be needed first. A well-designed chart cannot repair an omitted liability or an incorrect bank entry.

The outcome should be a clear explanation of the movement and a practical action list. Higher sales, reported profit and available cash are connected, but the monthly pack must show how the connection works in this particular business.