05 / Receivables, payables and unapplied cashUnallocated items hide what is still owed.
Invoices, receipts and adjustments stay open after the underlying business is complete. Aged balances become harder to act on, and period-end checks need extra spreadsheets to explain allocations, currencies and movements.
Common causes
- Receipts without a usable reference, posted on account.
- Part-payments and short-payments left partly allocated.
- Credit notes raised but never matched to the invoice.
- Exchange differences left as small residual balances.
- Duplicate customer or supplier accounts splitting one relationship.
What to check first
- How much of the aged balance is unapplied cash or unmatched credit?
- Does each account balance agree with the sum of its open items?
- How many residuals fall below a write-off threshold?
- Which accounts carry both debit and credit open items?
What I can deliver
An accurate view of what is still owed. An allocation tool proposes matches and applies authorised changes; automated checks flag partial allocations, currency differences and unusual residuals. Aged reports and balance histories give colleagues the context for each item.
How it is solved
Make allocation a reviewable process.
Retrieve open items from the ledger and propose matches in code under written rules. The team reviews partial or uncertain allocations. Authorised changes go back through the accounting system’s supported interface, and the resulting balance is checked.
Check the ledger’s internal consistency.
Test how transaction balances, allocations and currency effects relate. Keep current balances separate from a position reconstructed at an earlier date, with the detail to explain movements between periods.
Wider benefits
- Collections
Follow-up concentrates on amounts genuinely outstanding.
- Cash planning
Reliable receivables and payables support collection and payment decisions.
- Period-end evidence
Balances and movements can be explained without rebuilding the workings.
Is this the problem in front of your team?
Describe how it shows up in your business. The next step is a focused investigation, a review of one workflow, or a wider finance systems assessment.