| 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 | Yes | Ending balance on the bank statement at period end, in dollars, e.g. 48210.55. | |
| book_ending_balance | Yes | Cash account balance in the books at period end, in dollars, e.g. 51022.10. | |