Skip to content
Berri
Sign in Try Berri
Sign inTry Berri

Match a bank statement against your sales register

Find the receipts that do not match, without ticking line by line.

  • ForAccountants and owners who reconcile the bank by hand every month.
  • HelperBank Match
  • ModeBerri Mango 1
  • AttachExcel sheet

Copy the prompt

The first sheet has my bank credits and my sales register side by side for [month]. Match each credit to an invoice by amount and date (within [number] days). List what does not match and why.

Change the words in [brackets] to your own.

What to attach

An Excel sheet (.xlsx). Berri reads the first sheet, so keep the data there.

Run it

Berri opens with the prompt filled in and the Bank Match helper picked. Nothing is sent until you press send.

Run this in Berri

Tips

  • Berri reads the first sheet of an Excel file, so put both lists on that sheet.
  • For a very long statement, split it into two halves of the month.
What Berri sends back
Match a bank statement against your sales registerBank Match
XLSbank-and-sales.xlsx

The first sheet has my bank credits and my sales register side by side for October. Match each credit to an invoice by amount and date (within 5 days). List what does not match and why.

Reading bank-and-sales.xlsx

61 of 65 credits match an invoice. These four do not:

CreditAmountLikely reason
4 OctRs 24,500Two invoices paid together
11 OctRs 9,880Short paid by Rs 120
19 OctRs 15,000Advance, no invoice yet
27 OctRs 3,240Duplicate entry in register

Shall I draft a note to the customer about the Rs 120 short payment?

Figures here are made up to show the shape of the answer. Yours come from your own file and words.

Your own job, in your own words.

Try Berri