Should debits be negative in a bank CSV? Sign conventions explained
Published 23 September 2026 · by Tekiba
Yes, when the file has a single Amount column: money out negative, money in positive. The other shape is two columns, Debit and Credit, both unsigned, with the unused side left blank. What a file cannot be is half of each — Intuit's rule is that it “needs either 3 (Date, Description, Amount) or 4 (Date, Description, Credit, and Debit) columns”. Whichever you send, check it against the statement's own numbers — opening balance plus every row should reach the closing balance — though that sum catches a dropped row far better than a convention applied backwards.
The two conventions
Three transactions, written each way:
| Row | One signed column | Two unsigned columns | |
|---|---|---|---|
| Amount | Credit | Debit | |
| Deposit, 1,450.00 in | 1450.00 | 1450.00 | |
| Card purchase, 86.40 out | -86.40 | 86.40 | |
| Direct debit, 52.15 out | -52.15 | 52.15 | |
The single column carries the direction in the sign, so a row is one number. The two-column form carries it in which cell is filled, so a row survives a sign lost in transit — and the price is that an empty cell now means something, which is why Intuit asks you to “remove any zeroes (0) from the file. Leave those cells blank.”
Zoho Books names three shapes — “Double Column”, “Single Column and Amount Type”, and “Single Column with Negative Values”, the last being one column “where positive values indicate deposits and negative values indicate withdrawals”. The point is not which is best, but that the importer has to be told — so a file commits to one.
Which of the two columns is money in
Get this backwards and every row inverts while the file still looks reasonable. The words are no help: a bank's ledger is written from the bank's side, where your deposit is money it owes you — the opposite of what “debit card” trains everyone to expect.
So do not reason it out — read it off the help page of whatever receives the file. Which column it treats as money in is its own definition, worth looking up before the export. LedgerDrop's four-column preset follows Intuit's worked example, from your books' side: money out under Credit, money in under Debit. Before 24 September 2026, LedgerDrop's four-column preset wrote these two columns the other way round; if you imported a file made with it, check a deposit.
A credit card statement is the other way round
A card statement signs amounts by what they do to the balance you owe: a purchase increases it, a payment reduces it. A cash-flow CSV wants the reverse, so a converter that takes the page at face value hands you a file where every card purchase is income.
LedgerDrop decides that from the document — the wording a card statement uses, plus rows whose printed sign contradicts their section heading — and never from the balances. Using them to choose would let a missing row be cancelled out by inverting a good one, and the result would report as balanced.
What the sum can and cannot catch
Opening balance, plus every row, should reach the closing balance. It is a good test of a dropped row or a misread amount: one sign the wrong way round moves the total by twice that amount, loudly.
It is a much weaker test of a convention. A file with every sign inverted still balances whenever the rows net to zero, which a month of matched purchases and payments will do. And debt moves a balance the opposite way from savings, so LedgerDrop tries the sum both ways round and accepts either, which an inverted card statement can satisfy. Treat it as a test of the rows, and confirm the convention on a transaction you remember. Checking a converted bank statement CSV for errors covers the rest.
What LedgerDrop writes
One signed column, with the balance beside it:
Date,Description,Amount,Balance,Check# 2024-05-08,Deposit - invoice 2110 Brightwell Ltd,1450.00,6262.35, 2024-05-14,Card purchase - Halden Tools,-86.40,6175.95, 2024-05-21,Direct debit - Orrell Water,-52.15,6123.80,
Money in is positive and money out negative, whatever the statement printed: brackets, a trailing minus and a DR are all read as the sign they are, and separate paid-in and paid-out columns are netted into the one number. That normalising is the subject of why “PDF to Excel” makes bank statements messy.
The four-column shape is a paid preset, and writes the same rows unsigned, with the unused side empty:
Date,Description,Credit,Debit 08/05/2024,Deposit - invoice 2110 Brightwell Ltd,,1450.00 14/05/2024,Card purchase - Halden Tools,86.40, 21/05/2024,Direct debit - Orrell Water,52.15,
A preset changes which columns are written and how the date is spelled. It never changes a number.
Convert a statement → Free, no account, and the PDF stays in your browser.
What this will not do
It will not tell you how to set up an import in a particular product. Which shape yours wants, and what it calls the columns, is its vendor's business; their help pages are the authority, and both are linked above.
It will not invent a sign that is not on the page — but nor does it flag one. Where nothing carries the direction, the amount is written as the positive number printed, and nothing says so; check that case by eye. Where a printed sign contradicts its own section heading, the page does say so, and leaves the row as printed.
Questions
My accounting software rejected the file — should I have used two columns?
Possibly, but check the column count first. Some importers take one shape or the other and nothing between: Intuit's rule is that a file “needs either 3 (Date, Description, Amount) or 4 (Date, Description, Credit, and Debit) columns”, so an extra column, even a helpful one naming the source file, makes it neither. The convention is the second question.
Why is every purchase on my credit card statement showing as income?
Because the statement signs amounts by what they do to the balance you owe, and a cash-flow CSV by what they do to your money. The two are opposites, so a file read at face value has every purchase backwards. Do not expect the balance check to catch it: a debt balance moves the opposite way from a savings balance, so an inverted card statement can still add up. Check one purchase you remember instead.
Can a file have an Amount column and Debit and Credit columns?
Not usefully. Each shape says where the direction is recorded; a file carrying both says it twice, with nothing to decide which wins when they disagree — and it falls outside any format that documents a column count. Export the fields the far end's documentation asks for, and only those.
Next: how to check a converted bank statement CSV for errors, why Excel changes the dates in your bank CSV, and why “PDF to Excel” makes bank statements messy.