How to reconcile unpaid invoices using a KashFlow customer statement

Open a statement from the customer’s Actions menu in IRIS KashFlow. Select Exclude paid invoices for a view focused on the open items, then check each invoice against the customer’s remittance advice, the bank receipts and any credit notes. If an older balance is missing, widen the date range and check whether opening balances are included.
Upload a case

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.

Build a statement with the right scope

  1. In KashFlow’s newer design, go to Sales, select Customers and open the correct customer. Choose Statement from the three-dot Actions menu.
  2. 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.
  3. 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

RELATED ARTICLES

Illustration of a free e-book representing the 'Free International Debt Collection Guide.' This guide offers proven debt collection techniques. Get your free copy now.
FREE GUIDE

Download our free debt collection guide

Practical steps to get unpaid invoices paid, at home and abroad. Download our debt collection guide for free.

Thank you! The guide will land in your inbox shortly
Oops! Something went wrong while submitting the form.