Convert several statements at once

Select or drop up to 12 files on the home page. If you drop more, the first 12 are kept and a notice says so. The files upload first, then are read in parallel, so a year of statements takes about as long as the slowest one.

If one file fails, the others still finish. The results page lists the failed file with its error and shows the rest.

The batch results page

The heading counts the statements. A summary box says how many balance, how many need a look, and how many could not be verified, with totals for transactions, pages, money in and money out.

Each statement appears in a list with a coloured badge, its row count, page count, bank name, and the amount it is off by if it is unbalanced. Click a statement to open its full table under the list. If any statement is unbalanced, the first one is opened for you. Edits you make there are carried into the batch downloads.

A file that holds several accounts appears as several entries, each tagged with its account number, and the heading counts accounts and files separately. Such entries have their own QuickBooks and Xero download buttons under the table, since they have no page of their own.

The continuity check

When two or more statements come from the same account, they are put in period order and each pair is compared:

• Same period twice: probably a duplicate upload.
• Overlapping periods: transactions in the overlap may be counted twice.
• A gap of more than 3 days between one period ending and the next starting: a statement may be missing.
• The closing balance of one statement not equal, to the cent, to the opening balance of the next.

Statements are matched to an account by bank name, last four digits and currency. If none of the statements print a bank or account number, they are assumed to be one account. A statement that cannot be placed is listed in a note rather than guessed at. Fixing a balance in one statement updates the continuity check straight away.

Downloads

The Download everything panel offers two files. The Excel workbook has an Overview sheet with one row per statement (period, opening, money in, money out, closing, balance check, continuity, row count) followed by one sheet per statement with Date, Description, Money Out, Money In, Amount, Balance and Category, and a Categories sheet that totals money out and money in per category across every statement with live formulas, plus 8 blank rows for labels you add. The Merged CSV puts every transaction in date order with a Statement column saying which file it came from and a Category column at the end.

Under those, One file per statement offers zip downloads: all QuickBooks .qbo files, all Xero CSVs, all Tally XML files, all Excel workbooks (each with its own Summary sheet), all reconciliation reports, all plain CSVs or all QuickBooks CSVs, one file per statement, named after the statement. You can still open a statement in the list for its own downloads.

You can see a finished batch at the sample batch.