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 BerriTips
- 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.
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:
| Credit | Amount | Likely reason |
|---|---|---|
| 4 Oct | Rs 24,500 | Two invoices paid together |
| 11 Oct | Rs 9,880 | Short paid by Rs 120 |
| 19 Oct | Rs 15,000 | Advance, no invoice yet |
| 27 Oct | Rs 3,240 | Duplicate 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.