Reconcile the books
Point it at the ledger and the bank file. It matches every entry and lands the exceptions next to the data.
- Reads only the ranges you approve
- Every match cites its cells
- Exceptions go to a person
=SERIES("Receipts",B2:D2,B3:D6)Total cash receipts
Reconcile the month
Which receipts don't match the ledger?
Thought 2s
Read rangeB3:D6
Summary chart atC10:E14
Analysis
Two June receipts have no ledger entry. Everything else ties out to the bank file.
1) Collections tie to the bank file
2) Returns match their credit notes
3) Two June receipts sent to a person
Work on anything...