Error guides / Any importer

Any importer

“All my debits imported as credits”

When every purchase appears as money coming in, no individual transaction is wrong — the whole file is using the opposite sign convention from the one your app expects. It is a single decision applied consistently, which is why the fix is also a single decision.

Updated Aug 2026 · Applies to Any importer

Symptoms

  • Spending shows as income and deposits show as charges, across the board
  • The account balance moves in the wrong direction after import
  • Credit-card accounts are affected while checking accounts are not, or vice versa

What actually causes it

Cause 1

Bank statements written from the bank's point of view

A charge on your credit card is money owed to the bank, so some exports write it as positive. Your finance app expects your point of view, where the same charge is negative.

Cause 2

Separate debit and credit columns in CSV

Many CSV exports use two columns instead of one signed amount. Map them to the wrong fields during import and every row flips.

Cause 3

Accounting-style parentheses

Some exports write negatives as (1,234.56). An importer that strips punctuation reads that as a positive 1234.56, silently reversing the entry.

How to fix it

  1. Drop the file into the fixer below. It reports amounts written in parentheses or with unusual separators, which is the case where the reversal happens invisibly.
  2. For CSV, redo the import and check the column mapping: outflow/inflow or debit/credit must be assigned deliberately, not accepted by default.
  3. For OFX/QFX, the sign is inside the file and correct by the standard, so a reversal points at the account type in your app — a credit card set up as a bank account inverts the display.
  4. Reverse a bad import rather than editing the file: your next download will carry the same convention, and two conventions in one register are worse than one wrong one.
Any importer“Accented payee names import as garbled characters”Any importer“All my transactions imported with a zero amount”Any importer“My imported amounts have lost their cents”Any importer“My bank only gives PDF statements”

Skip the manual edit — fix it automatically

The fixer never rewrites an amount whose sign convention is ambiguous — parenthesised and European-formatted values are reported for you to decide, never silently converted. Free, no signup, no upload.

Open the fixer

Your file never leaves your browser.