Worksheet
Collections to bank reconciliation sheet
Each row of this sheet carries the date, receipt number, amount received, bank credit reference and the gap. Four blocks beneath it cover pending clearance, unallocated credits, returned cheques and fees netted off; a sign off line records who matched the day and when.
Name: ______________________ Business: ______________________ Date: ______________
Scroll the table sideways to see every column.
| Item | Who owns it | Where it is kept today | What is missing |
|---|---|---|---|
Cross out or rewrite any heading that does not fit your business. From the guide “Why collections in your software never match the bank statement”, www.gullysystem.com/blog/why-collections-in-your-software-never-match-the-bank-statement