How to Reconcile a Business Credit Card in QuickBooks

Convert a PDF bank statement to a QuickBooks file

Drop in a PDF statement and get a QBO (Web Connect) or IIF file you can import into QuickBooks Online or Desktop.

To reconcile a business credit card in QuickBooks Online, open the Reconcile screen, pick the card account, enter the ending balance and closing date from your statement, then check off each charge and payment until the difference reads zero. The trick is getting every transaction into QuickBooks accurately first, because a reconciliation only balances when the underlying data is complete. This guide covers the full workflow, the reasons it usually fails to match, and how to reconcile from a PDF statement when there is no live bank feed to lean on.

How do I reconcile a business credit card in QuickBooks Online?

Go to the Gear icon and select Reconcile, or open Accounting and choose Reconcile, then pick the credit card account. Enter the ending balance and the statement closing date exactly as they appear on the card statement, select Start reconciling, and check off every transaction that matches the statement. When the difference at the top reaches zero, finish the reconciliation.

The steps in order:

  1. Get all of the statement's charges, payments, refunds, and fees into QuickBooks before you start. Review anything sitting in the For Review tab so it is posted to the register.
  2. Open Reconcile, choose the credit card account, and confirm the beginning balance matches the statement's opening balance.
  3. Type the statement ending balance and ending date, then select Start reconciling.
  4. Tick each transaction on screen against the line items on the statement. Add any finance charge or annual fee the statement shows that is not yet in QuickBooks.
  5. Watch the Difference figure. When it is 0.00, select Finish now. QuickBooks marks those transactions as reconciled and locks the period.

Reconcile one statement at a time, oldest first. Trying to reconcile several months in a single pass is the fastest way to lose track of which charge belongs to which period.

What is the beginning balance when reconciling a credit card?

The beginning balance is the ending balance from your last reconciliation, and QuickBooks fills it in automatically. The very first time you reconcile a card it should be zero, and your first statement's opening balance should also be zero or match the opening balance entry you created when you set up the account. If the beginning balance does not match your statement, an earlier reconciled transaction was edited or deleted, and that has to be fixed before the current month can balance.

A credit card is a liability account, so the balance represents what you owe, not what you have. Charges increase the balance, payments and credits reduce it. That reversal from a bank account trips up a lot of first-time reconcilers, but the reconciliation math works the same way: match every line, drive the difference to zero.

Why doesn't my credit card reconciliation match the statement?

The most common reason a credit card reconciliation will not balance is a missing or duplicated transaction. A finance charge or annual fee on the statement was never entered, a payment got recorded twice, or a transaction has the wrong date or amount. Fix the single bad line and the difference usually collapses to zero.

Run through this checklist when you are stuck:

  • Missing charges or fees. Interest and annual fees rarely come through a feed cleanly. Add them from the statement.
  • Duplicates. A charge entered manually and also imported shows up twice. Delete the duplicate.
  • Wrong dates. A transaction dated outside the statement period will not appear in the reconcile window. Correct the date.
  • The payment counted twice. A credit card payment recorded as both a check and a transfer double-counts. Keep one entry.
  • Uncleared prior items. A charge posted after the statement cut-off belongs to next month; leave it unchecked.

Reconciliation goes far faster when the data was clean going in. If your transactions came from an unreviewed import, our guide on reviewing imported transactions before you add them explains how to catch duplicates and miscategorized lines before they wreck a reconciliation.

How do I record a credit card payment in QuickBooks?

Record a credit card payment as a transfer from the bank account that paid it to the credit card liability account, or use the Pay down credit card feature under the New menu. Do not enter it as an expense, because the expense was already recorded when you posted the individual charges. Double-recording the payment as an expense is one of the classic reasons a card reconciliation ends up off by the payment amount.

The payment reduces the credit card balance and reduces the bank balance by the same figure, which keeps both accounts honest. When you reconcile the card, the payment shows up as a line you check off against the statement just like any charge.

How do I reconcile multiple months of credit card statements?

Reconcile them one statement at a time, starting with the oldest, and finish each month before moving to the next. QuickBooks carries the ending balance of one reconciliation forward as the beginning balance of the next, so the periods have to be done in order. Skipping around or trying to reconcile a whole year in one window almost always produces a difference you cannot trace.

Catching up a card that was never reconciled means working through a run of monthly statements. If those statements are PDFs, converting each one to a QuickBooks-ready file first gives you complete, correctly dated data for every period. Our walkthrough on catch-up bookkeeping from PDF statements covers the full backlog workflow, and the batch statement converter handles a stack of months in one pass.

How do I add finance charges and interest when reconciling?

Enter finance charges and interest as an expense on the credit card account, dated to match the statement, before you finish the reconciliation. QuickBooks Online no longer has a dedicated finance-charge box on the reconcile screen for cards, so add the charge as a regular transaction on the card, categorize it to an interest expense account, then check it off with the other lines. The same goes for annual fees and late fees the statement lists.

These small statement-only items are behind a surprising share of failed reconciliations, because a bank feed often does not surface them the way it surfaces purchases. Adding them straight from the statement is the reliable fix.

Can I reconcile a credit card from a PDF statement without a bank feed?

Yes. You do not need a live bank feed to reconcile a credit card in QuickBooks. Convert the PDF credit card statement to a QBO file, import it so every charge and payment posts to the card register, then reconcile against the same statement's ending balance and date. This is the dependable route when a card will not connect, when the feed missed a month, or when you are cleaning up a prior year.

Because the converted file carries the exact dates and amounts from the statement, the register already agrees with the paper you are reconciling against, so the difference tends to fall to zero on the first pass. You can convert any credit card statement PDF to QuickBooks this way, whether it is a Visa, Mastercard, or Amex. Corporate and fintech cards work the same: a Mercury statement or any card export becomes a clean QBO file ready to import and reconcile.

Clean data is what makes a reconciliation quick

The slow part of reconciling a card is almost never checking off the lines; it is hunting down the one missing fee or duplicated payment that leaves you off by a few dollars. Getting every transaction into QuickBooks accurately the first time, with the right dates and no duplicates, is what turns a reconciliation into a ten-minute job. That is the whole case for converting each PDF statement to a reviewed QBO file instead of retyping charges or trusting an unreviewed feed.

If part of your month-end lives in spreadsheets, you can also convert the same card statements to Excel to build a quick reconciliation worksheet or spot-check totals before importing. And when you are matching charges back to what you actually bought, pulling the numbers off your paperwork with a receipt scanning tool makes it easier to tie each line to a real expense. However you gather the data, the goal is the same: complete, reviewed transactions that reconcile to the penny.

Ready to reconcile a backlog of card statements? Convert your first credit card statement to QBO free and import it into QuickBooks in about a minute.

Z tej samej rodziny narzędzi