“My digital bank export has too much detail”
App-based banks export generously: category, notes, emoji, location, local currency, exchange rate, receipt links. Traditional accounting software accepts a narrow shape and refuses everything else, so a richer file is a harder file to import.
Symptoms
The upload is refused on formatting grounds with no specifics The mapping screen is overwhelmed with columns you do not need Foreign purchases import at the local-currency amount
What actually causes it
More columns than the importer accepts
Products like QuickBooks Online take a fixed three- or four-column shape. A file carrying fifteen columns falls outside it no matter how correct each one is.
Several amount columns
Local amount, account amount, fee and exchange rate may all appear. Mapping the wrong one records what you spent abroad rather than what left your account.
Emoji and free text in descriptions
Notes fields can contain anything, including characters that break naive CSV readers or arrive as garbage after an encoding mismatch.
How to fix it
- Run the file through the checker below to see the true column count, delimiter and any encoding problems.
- Keep date, description and the amount in your account currency; delete the rest before importing.
- For foreign spending, use the account-currency column rather than the local one, and handle fee rows deliberately.
- Re-check after editing, because the spreadsheet you edit in may change the delimiter or encoding on save.
Related import problems
Skip the manual edit — fix it automatically
The checker names the exact columns and rows that do not line up, so trimming a wide export becomes precise rather than trial and error. Free, no signup, no upload.
Open the fixer