Bank export to Xero, in seconds
Bank exports and Xero rarely line up: separate debit and credit columns, different date formats, the odd broken row. This turns the bank's file into a clean Xero import and flags anything a person should check first, like an impossible date or a missing amount.
For firms I build this in Excel with Power Query, so each month it's: drop in the new file, click Refresh, save.
Runs in your browser. Files are never uploaded.
