Debit and credit columns in PDF bank statements split money out from money in. On a checking or savings statement, a debit is money leaving the account and a credit is money arriving. For QuickBooks or Xero, merge the two columns into one amount: debits become negative numbers and credits stay positive.
What debit and credit mean on a bank's own PDF statement
A bank statement uses debit and credit from the bank's side of the relationship. Your deposit is money the bank owes you, so the bank records it as a credit to your account. A card payment or a check you wrote reduces what the bank owes you, so it appears as a debit.
That viewpoint is why the words can feel backwards if you have done any bookkeeping. In your own books, cash arriving in the bank account is a debit to the bank account. On the bank's statement, the same deposit is a credit. Neither is wrong. They describe the same money from opposite ends.
For importing, you can set the theory aside. What matters is the direction of the money:
- Debit column on a bank statement: money out. Card purchases, checks, transfers out, fees.
- Credit column on a bank statement: money in. Deposits, transfers in, interest, refunds.
Banks print these columns under many names. "Withdrawals" and "Deposits", "Paid out" and "Paid in", "Subtractions" and "Additions" all mean the same thing. Some banks skip the split and print one column with a minus sign or the letters DR and CR beside each amount. The rules below still apply. The bank-specific posts show how two large banks label theirs: the columns on a Chase statement converted to QBO and the layout of a Wells Fargo statement converted to QBO.
Merging statement debit and credit columns into one signed amount
Merging the two columns is a single rule applied to every row. Take the figure from whichever column has one. If it came from the debit column, make it negative. If it came from the credit column, keep it positive. Each row should end up with exactly one number, never two and never none.
Here is how example rows from a checking statement and a card statement come out. The payees and figures are made up for illustration.
| Statement | Description (example) | Debit | Credit | Signed amount |
|---|---|---|---|---|
| Checking | ONLINE TRANSFER TO SAVINGS | 500.00 | -500.00 | |
| Checking | MOBILE DEPOSIT REF 2291 | 1,840.00 | 1840.00 | |
| Checking | CHECK 1187 | 265.40 | -265.40 | |
| Checking | INTEREST PAID | 0.83 | 0.83 | |
| Card | HARBOR PRINT SHOP | 118.25 | -118.25 | |
| Card | PAYMENT THANK YOU | 600.00 | 600.00 | |
| Card | RETURN HARBOR PRINT SHOP | 18.25 | 18.25 |
Three habits keep the merge clean. Strip currency symbols and thousands separators, so 1,840.00 becomes 1840.00. Treat a blank cell as empty, not as zero, because a zero in the wrong column can confuse the merge. And watch for a row where both columns hold a figure. That usually means two lines were read as one, and the row needs splitting before you go on.
A quick total proves the merge. Add the debit column and the credit column as printed, then add your signed amounts. The signed total must equal credits minus debits. If it does not, one row has the wrong sign or went missing.
Which way round do debit and credit columns run on a card statement?
On a credit card statement, the bank looks at the balance you owe, so the logic turns around. A purchase increases the debt and usually prints as a debit or a plain amount. A payment or refund reduces the debt and prints as a credit, often with a minus sign. For the import, purchases go negative and payments go positive.
Card issuers are less consistent than banks about this. Some print purchases as positive numbers and payments as negative ones, the opposite of the money-out-is-minus rule used here. Others list purchases and payments in separate sections with no signs at all. Read the statement's own summary box to work out its convention: if "Payments" carries a minus sign there, the issuer shows payments as negative.
In the table above, the card rows follow the import convention: the print shop charge is negative, while the payment and the return are positive. If a card issuer prints the opposite, flip every sign on that statement. American Express is a common example of an issuer whose layout needs care, and the guide to importing an Amex statement into QuickBooks works through its signs.
Can QuickBooks read debit and credit columns without merging them?
QuickBooks Online can read the two columns as they are when you upload a CSV. Intuit's page on uploading transactions to QuickBooks Online by hand accepts either a three-column file with one amount or a four-column file with separate credit and debit columns.
The same page asks for some tidying in the four-column layout: take the word "amount" out of the credit and debit headers, and leave cells blank where the value would be zero. So a four-column CSV saves you the sign step but not the clean-up.
A QBO file is different. Each transaction in it carries one signed amount, so the merge has to happen before the file is built. Xero's statement import also has its own column options, and the safest move there is to check what the import screen asks for. Once lines are in Xero, the difference between Xero statement lines and account transactions explains what the import has and has not created.
SimpleBankConvert is being built to apply this sign rule for you, so a statement with two money columns comes out as a file with one. It is in early access, and you can ask to be told when it opens.
Debit and credit signs reversed after an import
A file with reversed signs imports without any error, which is what makes it dangerous. Every deposit shows as a payment, every purchase as a deposit, and the account balance moves the wrong way. The tell is a balance that drifts further from the statement each month instead of matching it.
You can spot a flip quickly. Open the imported account in QuickBooks and find a line you know well, such as a regular client deposit. If it sits in the spent column, the signs are reversed. Another sign is a running difference from the statement that equals exactly twice the net movement for the period.
The fix is to undo the upload, flip every sign in the source file and upload it again. Do not fix lines one at a time in QuickBooks. A partial fix leaves some lines right and others wrong, and the reconciliation becomes much harder to read.
A flip affecting only a few rows has a different cause. It usually means a statement printed one section, such as refunds or reversals, with its own sign convention. Check those rows against the PDF and correct them in the file before re-importing.