Exports and imports
The Excel and CSV exports explained
What is on the Transactions and Summary sheets, how the totals-by-category table works, and what the plain CSV contains.
Last reviewed
The Excel download is built in your browser from the table on screen, including any edits you have made. It has two sheets.
Transactions sheet
One row per transaction with these columns: Date, Description, Money Out, Money In, Amount, Balance, Category, Page. Dates are real date cells and amounts are real numbers, so sorting and formulas work without cleaning. Amount is signed (money in positive, money out negative). Balance is the running balance printed on the statement, blank where the statement did not print one. Page is the page of the original file the row came from.
The header row is frozen and has a filter. Rows the reader was unsure about are shaded pale yellow.
Summary sheet
The Summary sheet makes the file self-describing. It lists the file name, bank, account, currency and period, then the balance check: BALANCED, NOT BALANCED or NOT VERIFIABLE, with the opening balance, total money in, total money out, computed closing, printed closing, difference and transaction count. Any notes from the check, such as the statement being listed newest-first, appear below.
Totals by category
Under the summary is a small table with one row per category found in the statement and its money out and money in. These are live SUMIF formulas over the Category column on the Transactions sheet. If you change a category label on the Transactions sheet, the totals follow.
Below the listed categories are 8 blank rows with the same formulas. Type a new label into column A of one of them and its total appears, so you can add a property, a client or a label like personal without writing a formula.
The plain CSV
The CSV download has the columns Date, Description, Money Out, Money In, Amount, Balance and Category, one row per transaction, dates as YYYY-MM-DD, amounts to two decimals. Category is blank where there was no suggestion. Descriptions that begin with a character a spreadsheet would treat as a formula are prefixed with an apostrophe so they open as text.
The reconciliation report
The Reconciliation report download is a PDF for the client file or a reviewer. Page one gives the file, bank, account, period and page count, then the verdict in plain words (Balanced, Not balanced: off by an amount, or Could not be verified), the figures behind it (opening balance, total money in, total money out, computed closing, printed closing, difference), any notes from the check, and the first row to look at when something is off. The pages after list every transaction as read, with the flagged row in red. Like every download it is made in your browser from the table on screen, so it reflects your edits.
Batch files are different
When you convert several statements together, the workbook has an Overview sheet, one sheet per statement (with the same Category column) and a Categories sheet whose totals add up every statement sheet. The merged CSV has a Statement column and a Category column. There is no per-statement Summary sheet in the batch file; open a statement on its own for that. See Convert several statements at once.
For other software, see Import into QuickBooks, Import into Xero and Import into TallyPrime, or the Excel conversion page.