Reconcile bank to books
reconcile_bank_to_booksUse this when the user attaches a bank export or statement AND their books (cash account register or general ledger export from accounting software or a spreadsheet) and wants a bank reconciliation: "reconcile my bank statement", "reconcile bank statement against my books", "list what doesn't match", "find outstanding checks and deposits in transit", "match bank transactions to the ledger". Matches rows by check number, amount and date (with a date window), and sums (one deposit = several invoices); lists all unmatched rows on both sides with a classification (outstanding check, deposit in transit, bank fee, interest, NSF, likely duplicate, likely amount typo); builds adjusted bank vs adjusted book balance (PASS only at $0.00); returns an Excel workbook and a PDF reconciliation statement. Does not connect to bank accounts or accounting software, does not post entries, and is not for a single statement without books (use a statement converter for that). Supports up to 20,000 rows per file; CSV and text tables have a 2,000,000-cell limit (including empty cells). Each call saves new Excel and PDF files on the plugin server for 1 hour (private download links), then deletes them.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"bank_file": "<bank_file>",
"books_file": "<books_file>"
},
"name": "reconcile_bank_to_books"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| bank_file | Yes | The bank side: the bank's CSV or Excel (.xlsx) transaction export, or a text PDF bank statement, e.g. bank-september.csv. | |
| books_file | Yes | The book side: the cash/bank account register or general ledger export from accounting software or a spreadsheet (CSV or .xlsx), e.g. books-september.xlsx. | |
| books_sign | No | Sign of the books file amounts: auto (default) flips only when the amounts clearly match the bank with the opposite sign; as_written keeps them; flip reverses them. Example: auto. | |
| date_order | No | Order of numeric dates in both files: MDY (US, 09/02/2026) or DMY (02/09/2026). Detected per file when a day is above 12; US is assumed otherwise. | |
| period_end | No | Statement / period end date YYYY-MM-DD, e.g. 2026-09-30. Default: the statement end on a PDF, else the month end of the last book entry (capped by the bank file). | |
| bank_columns | No | Optional column names for the bank file when auto-detection picks the wrong column, e.g. {"date":"Post Date","amount":"Amount"}. | |
| books_columns | No | Optional column names for the books file, e.g. {"date":"Date","debit":"Debit","credit":"Credit","check_no":"Num"}. | |
| max_group_size | No | Most rows combined when one deposit equals several book entries (or the reverse), e.g. 4 (default). | |
| check_clear_days | No | Days a check may take to clear and still match by amount, e.g. 60 (default). Matches by check number allow the same span. | |
| date_window_days | No | Days a bank posting may differ from the book date and still match the same amount, e.g. 5 (default). | |
| bank_ending_balance | No | Ending balance on the bank statement at period end, in dollars, e.g. 48210.55. With book_ending_balance this gives the full adjusted-balance reconciliation. | |
| book_ending_balance | No | Cash account balance in the books at period end, in dollars, e.g. 51022.10. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| mode | Yes | ||
| note | Yes | ||
| files | Yes | ||
| counts | Yes | ||
| status | Yes | PASS only when both ending balances are known and the difference is $0.00; BALANCES_NEEDED = activity explained, balances needed. | |
| warnings | Yes | ||
| downloads | Yes | ||
| period_end | Yes | ||
| explanation | Yes | ||
| top_bank_only | Yes | ||
| top_book_only | Yes | ||
| reconciliation | Yes | ||
| bank_only_by_class | Yes | ||
| book_only_by_class | Yes |