Bank Reconciliation
Matches the bank statement to the general ledger, ties out both sides and drafts the entries for review.
- Reconciles cash
- Drafts entries for review
About
Upload the bank statement and the general ledger cash detail. The agent clears last month’s open items, matches every check and deposit, and sorts what only the bank has recorded.
It ties both sides to the cent and hands back a workbook with live formulas to your files. Bank errors, stale items and anything it can’t support are listed for a person to decide.
What it needs
- Bank statementCSV, Excel or PDFRequired
- General ledger cash detailOr the check and deposit registersRequired
- Last month’s reconciliationIts outstanding checks and deposits in transitRecommended
- Support for unusual itemsCheck images, deposit slips, loan schedulesOptional
What you get
- The reconciliation, both sides tied to the cent
- Outstanding checks and deposits in transit
- Items that need a person: bank errors, stale items, missing support
- Proposed adjusting entries, marked not booked
- A workbook with live formulas back to your files
Example
| Balance per bank, Feb 28 | $85,485 |
|---|---|
| Add: deposits in transit | $13,191 |
| Less: outstanding checks | ($13,542) |
| Add: bank error, check #2217 | $875 |
| Adjusted bank balance | $86,009 |
| Balance per books, Feb 28 | $85,471 |
| Add: wire and interest not recorded | $4,503 |
| Less: fees, returned check and loan payment | ($3,425) |
| Less: book errors | ($540) |
| Adjusted book balance | $86,009 |
| Difference | $0 |
How it works
- Clear last month's open items
- Match the checks
- Match deposits by day
- Sort what only the bank has
- Tie out
- Propose the adjusting entries
Start it in Jiro
Open a new session, attach your files and send:
/bank-reconciliation Reconcile the operating account for February. The bank statement, the GL cash detail and January’s reconciliation are attached.
Upload your GL and bank records. Jiro does the rest.
More agents
- BookkeepingFree download
Transaction Categorizer
Sorts bank and card transactions into your chart of accounts the way you’ve booked them before, and flags what needs a person. - ReconciliationsFree download
Difference Finder
Finds why a reconciliation won’t tie: swapped digits, items on the wrong side, and the entries that add up to the gap. - Close support
Workpaper Writer
Shows how every number in an answer was derived, step by step, with the calculation behind each one.