Reconcile bank statements with AI
Compare authorised statement and ledger records, consider grouped settlements and keep unresolved differences visible for review.
Reconcile bank statements with AI when a bank deposit does not resemble any individual sale in the books. Three receipts may have been settled together. The bank-reconciliation skill helps review the relationship without silently changing the ledger or assuming that equal amounts are automatically the same payment.
Set the account and period first. Dates can differ across the two sources, especially near a reporting boundary. Compare references, amounts and descriptions, then document why a match is accepted or why the item still needs evidence.
What it does
- Check exact matches within the selected account and period.
- Compare near matches with different settlement dates.
- Investigate a bank amount against several ledger entries.
- Identify a possible duplicate without automatically deleting it.
- Prepare an exception list and a summary of approved matches.
Install and use
- Provide authorised bank and ledger exports. A local Python helper can summarise already determined matches; it is not a substitute for the matching judgement.
- Ask, “Could this deposit settle the three listed sales? Compare the references and leave the item open if the evidence is insufficient.”
- Have the responsible finance reviewer check unresolved items before considering any adjusting entry.
FAQ
Source
Made by Receiptor AI. Original skill: bank-reconciliation, published on GitHub under the MIT licence.
View on GitHub