Back

Reconcile a bank statement to my books

A clean reconciliation with every unmatched item flagged for review

FoundersOpsEAsAnalysts
Prompt

Reconcile my [month] bank statement against my bookkeeping. Open the statement [link or upload] and my books sheet [link]. Match each transaction by date and amount, then list: matched items, deposits in transit, outstanding or uncleared items, bank fees or interest not yet recorded, and anything in my books with no bank match. Show the adjusted bank balance and the adjusted book balance and confirm whether they tie out. Put the reconciliation and the exceptions list into a Google Sheet.

Works withsheets.google.comdrive.google.com