Summarize transactions
summarize_transactionsRead-only
Use this when the user pastes or lists bank or credit card transactions (date, description, amount) and wants them reconciled, totaled by month or category, or exported: "does my statement balance", "money in and out by month", "categorize these transactions", "make a QuickBooks CSV from these". Checks opening + transactions = closing to the cent and the running balance row by row, points to the rows that break it, suggests categories, and returns Excel, CSV and QuickBooks CSV downloads. Do not use when a statement file is attached (use convert_bank_statement); does not give tax or accounting advice.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| account_type | No | auto (default): a PDF is classified from its text; pasted rows and CSV/Excel exports count as bank unless the balances or the sign pattern show a credit card (the result says so). bank: checking or savings. credit_card: charges are money out and the statement shows a previous and new balance owed. Example: credit_card. | |
| transactions | Yes | The transactions in statement order, e.g. [{"date":"2026-09-02","description":"PAYROLL ACME INC","amount":2450}, {"date":"2026-09-03","description":"GREENLEAF MARKET","amount":-82.17}]. | |
| statement_year | No | Closing year of the statement, used for dates printed without a year when the period is not on the file, e.g. 2026 (a December-January statement uses the January year). | |
| closing_balance | No | Closing (ending or new) balance in dollars, e.g. 5034.47. Used with opening_balance to prove the total to the cent. | |
| opening_balance | No | Opening (beginning or previous) balance in dollars, e.g. 4123.55. Only needed when the file has none, such as a CSV export without a balance column, or to override. |
Output Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| note | Yes | ||
| months | Yes | ||
| period | Yes | ||
| source | Yes | ||
| account | Yes | ||
| preview | Yes | ||
| warnings | Yes | ||
| downloads | Yes | ||
| categories | Yes | Suggested categories from keyword rules; review before filing. | |
| transactions | Yes | ||
| reconciliation | Yes |