QuickBooks Credit Card Reconciliation: How to Clean Up a Card Account That Will Not Reconcile
No account needed for your first conversions. We never store your bank login.
Short answer: When a credit card will not reconcile in QuickBooks, the difference is almost always one of five things: the card payment was recorded twice, the beginning balance is wrong, transactions were entered by hand and then downloaded again, the card was set up as a bank account instead of a credit card, or the feed dropped charges that never made it into the register. Find which one you have before you touch a single transaction.
Last updated August 2026.
Reconciling a credit card is not the same job as reconciling a checking account, and treating it like one is why so many card accounts end the month with a stubborn difference. Charges increase what you owe, payments decrease it, and the statement you are reconciling against is a liability statement. Get the direction of any one item wrong and the difference will not close.
Set the account up correctly first
Before anything else, check the account type in the chart of accounts. A business credit card should be a Credit Card type account, not a Bank type. This sounds cosmetic and is not. The Credit Card type gives you the correct sign behavior, the right reconcile screen, and the enter credit card charges workflow. Cards set up as bank accounts reconcile backwards and will fight you every month.
This trips people up most often with cards from issuers that most people think of as store credit, such as the retail and co-branded cards serviced by Synchrony, and with fintech corporate cards. See the credit card CSV to QuickBooks converter page for how to bring those into the right kind of account from the start.
The five causes, in the order you should check them
1. The card payment is recorded twice
This is the single most common one. The payment from your checking account to the card gets entered once from the checking side (as a transfer or a check) and once again from the card side (as a payment), so the same money moves twice. In the card register, look for two payments of the identical amount within a few days of each other. Delete one, do not adjust it, and the difference usually collapses to zero.
2. The beginning balance is wrong
If the beginning balance QuickBooks shows does not match the closing balance on last month's statement, you cannot reconcile this month, no matter how correct this month's transactions are. Something changed, deleted, or was added to a previously reconciled period. Run the Reconciliation Discrepancy report (in Desktop, Reports, Banking, Reconciliation Discrepancy) or the Reconciliation Discrepancy report in QuickBooks Online to see exactly which reconciled transaction was edited, and by whom. Fix that transaction rather than plugging the difference.
3. Manual entries meeting downloaded ones
Someone entered the charges by hand to keep the books current, then the feed delivered the same charges later and they were added rather than matched. Now every charge exists twice. In the register, sort by amount and look for adjacent identical pairs. Keep the downloaded transaction, which carries the bank's own identifier, and delete the manual one.
4. Missing charges the feed never delivered
The opposite problem, and the one people least expect, because a bank feed that is half working looks like a bank feed that is working. Compare the transaction count on the statement with the count in the register for the same period. If the register is short, the feed dropped them, and no amount of reconciling will conjure them back. Export the statement period as a CSV from the card issuer, convert it, and import the missing range. If your card feed is silently returning nothing at all, that is a known pattern worth reading about in QuickBooks bank feed not working, and it is exactly what happened to Barclays cardholders in 2026, where the balance kept updating while no transactions arrived.
5. Refunds and credits posted as charges
A refund from a vendor reduces what you owe, so it must be entered as a credit, not as a negative charge in the wrong column. This one is easy to spot: the difference is exactly twice the refund amount, which is the classic signature of a sign error anywhere in accounting.
Working the difference down
Reconcile against the statement, one month at a time, oldest first. Do not try to reconcile six months at once because the difference figure becomes meaningless when it is the sum of six unrelated errors. If the difference is exactly the amount of one transaction, you have found it. If it is exactly twice a transaction, you have a sign error. If it is exactly the amount of a payment, check for the double payment first.
Resist the adjusting entry. QuickBooks will happily let you force a reconciliation with an adjustment, and it lands in an expense account where it will sit forever, misstating your books and confusing whoever reconciles next month. An adjustment is an admission that you could not find the error, and by this point in the checklist you can find it.
Getting the missing charges back in
When the register is genuinely missing transactions, the fastest path is a file. Sign in to the card issuer, export the statement period as a CSV, and run it through the CSV to QBO converter to build a Web Connect (.qbo) file. QuickBooks Desktop imports it through File, Utilities, Import, Web Connect Files, and QuickBooks Online accepts it as an upload under Bank transactions. Desktop cannot import a raw CSV of bank or card transactions at all, so on Desktop the conversion is not optional. If you are still choosing a tool for that step, the best CSV to QBO converter comparison covers accuracy, pricing and QuickBooks compatibility.
Import into the credit card account, not a bank account, and check the converter's transaction total against the statement total before you import. That single check catches misread rows before they become next month's reconciliation problem.
Stop the cleanup from recurring
Two habits prevent most of this. Record the card payment in exactly one place, every time, and pick which place as a rule the whole team follows. Second, reconcile the card monthly, on the statement close date, rather than when something feels wrong. A month of card charges takes twenty minutes to reconcile. A year takes a weekend.
It also helps to know what is actually on the card. On most business cards a large share of the recurring charges are software subscriptions, and getting a clear read on what your recurring software spend actually is tends to surface duplicate tools and forgotten renewals that you were quietly reconciling every month without questioning.
Before you start hunting line by line, read the difference itself. The number QuickBooks shows you is diagnostic, and in most cases it names the error category outright.
| The difference is | What it almost always means | Where to look first |
|---|---|---|
| Exactly one transaction amount | A single charge is missing, duplicated, or was never marked cleared | Sort the register by amount and search that figure |
| Exactly twice a transaction amount | A sign error: a refund entered as a charge, or a payment entered as a charge | Every refund and vendor credit in the period |
| Exactly the card payment amount | The payment is recorded twice, or is missing entirely | The checking register and the card register on the payment date |
| A small odd amount, usually under $100 | An unrecorded finance charge, interest, annual fee, or foreign transaction fee | The fees and interest section of the statement |
| Evenly divisible by 9 | A transposition: two digits typed out of order, such as 54 for 45 | Amounts made of the same digits as the statement figure |
| The same figure every month | The beginning balance was wrong once and has carried forward ever since | The first month that failed, not this one |
The divisible-by-nine test is the one people forget. If the difference divides evenly by 9, stop scanning for missing transactions and start comparing digits, because you almost certainly typed 1,247.00 where the statement says 1,274.00.
Should you reconcile a credit card to the statement balance or the current balance?
Always reconcile to the statement closing balance, never the current balance. The current balance shown in your online card account includes charges posted after the statement cut off, so it will never agree with a reconciliation. Enter the statement closing date and the closing balance exactly as printed, and ignore anything dated after that.
This is the single most common reason a first reconciliation fails for someone who has only ever reconciled checking accounts. A checking balance feels current and stable; a card balance moves every day. The statement is a snapshot with a date on it, and the reconcile screen wants that snapshot.
Do you enter the finance charge when you reconcile, or before?
Enter it in one place only. QuickBooks gives you a finance charge field on the reconcile screen, and it will post that expense for you when the reconciliation completes. If you already entered the interest as a charge in the register, leave the field blank. Filling it in anyway creates a duplicate and throws the reconciliation off by the interest amount.
Pick a rule and hold the whole team to it. Entering fees during reconciliation is convenient and keeps the register clean, but it hides the expense until month end. Entering them as they post gives you a live P&L. Either works; doing both is what breaks.
How do you reconcile a credit card with a credit balance?
Enter the ending balance as a negative number. When you have overpaid the card or a large refund landed after the payment, the statement shows a credit balance, and QuickBooks accepts that directly: open Reconcile, set the statement date, and type the closing figure with a minus sign in the Ending Balance field. The reconciliation then proceeds normally.
Enter the refund that caused it as a credit against the original expense account, not as a negative charge and not as income. A vendor refund reverses the expense you booked when you made the purchase, so it belongs in the same account. Booking it to income overstates both revenue and expenses for the year and is a common finding in a cleanup.
How do you undo a credit card reconciliation in QuickBooks?
It depends on which product you are in, and the difference matters more than most people expect. QuickBooks Desktop has a real undo button. QuickBooks Online only offers a one-click full undo to accountants, and everyone else has to unreconcile the transactions one at a time.
| Product | How to undo | What to watch |
|---|---|---|
| QuickBooks Desktop | Banking, then Reconcile, then Undo Last Reconciliation | One month at a time, newest first. Undoing permanently deletes the reconciliation reports and attachments, so save them first |
| QuickBooks Online Accountant | Undo from the Action column on the reconciliation history | Undoes that reconciliation and every one after it. Does not undo transactions someone marked reconciled by hand |
| QuickBooks Online, regular user | Open the register and click the status box on each transaction | No bulk option. The box cycles R to C to blank, so click until it is blank |
One trap worth naming: Accountant view inside a regular QuickBooks Online company is a display toggle, not a license. It rearranges the menus and it does not give you the bulk undo. That belongs to a connected accountant working in QuickBooks Online Accountant, or to a user assigned the in-house accountant role.
Before you undo anything in Desktop, export the previous reconciliation report to PDF. Undoing wipes the stored report and any attachments permanently, and if the cleanup goes sideways that report is the only record of what was cleared as of that date.
Where does a forced reconciliation adjustment actually post?
In QuickBooks Desktop it posts to an expense account called Reconciliation Discrepancies, created automatically the first time you force one. It is not Opening Balance Equity, which is a separate account people often confuse it with. In QuickBooks Online the adjustment posts to the account you pick on the adjustment screen, which defaults to a reconciliation discrepancy expense.
Run a QuickReport on that account before you accept any new adjustment. If it already holds three or four entries, you are not looking at this month's problem, you are looking at a habit, and every one of those entries is an error somebody gave up on. Reversing them and reconciling forward from the last clean month is usually faster than it sounds.
Related cleanups
If the card is only one of several accounts giving you trouble, the same discipline applies elsewhere: see the bank reconciliation discrepancy guide, the undeposited funds cleanup, and, if you keep client books, the CSV to QBO converter for accountants.