Monthly financial report generator

How to build a monthly financial report from a transaction export

1. Export the transactions. CSV or XLSX from your bank, card, accounting tool or spreadsheet. One row per transaction, with a date and an amount.
2. Drop it in. The date, amount and grouping columns are detected from the data and the header names. Change any of them from the dropdowns.
3. Read the report. A month-by-category table with row and column totals, plus the change from the previous month. Rows that could not be read are counted rather than silently dropped.
4. Take it away. Download as .xlsx or CSV, or copy it as a Markdown table.

What it does with your columns

A transaction export has one row per transaction. A report has one row per category and one column per month. Getting from the first to the second is a pivot, and pivots are where people lose an hour to argument dialogs.

This page picks the date, amount and grouping columns by looking at the data as well as the header names — a column of things that parse as dates is a date column whatever it is called. All three are dropdowns, so a wrong guess costs one click.

The formats it reads without being told

• Amounts: $1,234.56, 1.234,56 (European), (89.00) for a negative, a plain minus sign, and currency symbols anywhere in the cell.
• Dates: 2026-03-15, 15/03/2026, 03/15/2026, Mar 15, 2026, 15 March 2026, and real Excel date cells.
• The ambiguous one: 03/04/2026 is March in the US and April almost everywhere else. There is no way to tell from the number, so there is a checkbox. Get it wrong and your months shuffle — the tell is transactions landing in a month you know had none.

Rows it could not read are counted, not hidden

If 40 of 900 rows had no readable date, the report says so above the table. That matters more than it sounds: a summary that silently drops a tenth of the data looks exactly like a correct one. Blank rows, subtotal rows and header rows repeated mid-file are the usual causes, and they are usually fine to drop — but you should be the one deciding that.

What this is not

• Not accounting. There is no double entry, no chart of accounts, no reconciliation and no audit trail. It sums a column by month and by group.
• Not a categorizer. It groups by a column you already have. If your export has no category column, you get one row — still a useful monthly total, but the grouping has to come from somewhere.
• Not a chart. The numbers come out as a table you can chart wherever you like.

When the report is monthly, the tool should be too

Re-dropping the same export every month is the tell that a browser tab is the wrong home for this. TableDI 2 is a desktop app for file work you redo every period: it keeps your sources, rules and delivery as a job, so next month you drop in the new files and run it again. Everything runs on your own machine. Pulling several monthly files into one summary is one of the jobs it is built for, and the delivery is an Excel file with the summary, the detail and the exceptions on separate sheets.