Merge statement exports

Why not just copy and paste

You can, and for two files it is faster. It stops being faster at twelve, and it stops being safe as soon as one month's export has a column in a different place — pasting then puts amounts under dates without complaining.

This checks the header of every file against the first one. When they match, the header is kept once and the rows are stacked. When one doesn't, its rows are still included — a month exported with a renamed column is a real thing and dropping those transactions silently would be worse — but the file is marked so you know to look.

Order is preserved

Files are stacked in the order you add them, and rows keep their original order within each file. Nothing is sorted, because sorting by a date column that a spreadsheet has misread as text produces a convincing and entirely wrong sequence. Sort after importing, once you have confirmed the date column is really a date.

After merging

Overlapping exports are the most common source of duplicate rows — a January-to-March file and a March-to-May file both contain March. It is worth running the result throughthe duplicate finderbefore importing it anywhere that pays invoices.