How to reconcile unpaid invoices using a KashFlow customer statement
Key facts
Use a customer statement to compare open invoices, payments and credits against your customer’s records. Expand the date range and include opening balances when investigating a gap.
This guide is not legal advice and laws/rules may change; consult a qualified professional for personalized assistance. Use at your own risk.
Build a statement with the right scope
- In KashFlow’s newer design, go to Sales, select Customers and open the correct customer. Choose Statement from the three-dot Actions menu.
- Choose All transactions or set the two dates you want to compare. The dates default to the last quarter, so use a wider range if you are tracing an older invoice or receipt.
- Choose whether to exclude paid invoices and opening balances. Select Refresh data after changing the filters. Use Download to obtain a CSV if you want to compare invoice references in a spreadsheet. IRIS KashFlow help on producing customer statements · IRIS KashFlow help on downloading statements
Compare the entries invoice by invoice
A maintenance contractor’s customer says its records show £920 due. The contractor’s statement shows invoice M-310 at £1,200 less a £450 part payment and invoice M-327 at £320, for £1,070 outstanding. Comparing references reveals another transfer for £150. The bank shows it reached the contractor’s account, and the remittance advice identifies M-310. After the team checks whether the transfer is already recorded and resolves the allocation, it refreshes the statement and confirms £600 on M-310 and £320 on M-327. It can then ask the customer to confirm a payment date for both invoices.
If a receipt or opening balance needs tracing
When a receipt seems to have disappeared, clear Exclude paid invoices while investigating. Check the invoice’s payment entries and the bank reference to see whether it was applied to another invoice. For an opening balance you cannot tie to the customer’s schedule, agree the comparison period and identify the invoices that make up the brought-forward figure. Once the statement agrees, choose Email Statement and check the auto-filled recipient and attachment before sending. IRIS KashFlow help on producing customer statements · IRIS KashFlow help on emailing customer statements


.webp)