Credit card reconciliation compares a business card statement with the card liability account in your books at the statement closing date. Match purchases, repayments, fees, interest, and refunds; correct book errors and document timing differences so the reconciled balances agree. Track receipt or invoice evidence separately: a balanced account does not establish that every purchase is supported.
The card account records what the business owes, not just what it spent. Purchases increase that liability; repayments and refunds reduce it. In the general ledger, increases in the card liability are credits and decreases are debits. For the calculations below, amounts owed are displayed as positive numbers.
Two dates matter: the date you recorded a purchase and the date the issuer posted it. A valid purchase already in your books but absent from the current statement can leave the actual ledger balance higher than the statement balance. Reconciliation explains that difference on a schedule while leaving the purchase in the books.
Prepare the complete statement and card register
Gather the full card statement, the previous reconciliation, the card liability register through the closing date, and the bank record of repayments. Keep purchase receipts, invoices, and refund documents alongside them. Confirm the account, currency, statement period, and opening balance before matching individual transactions. The statement's previous balance should tie to the prior statement close, with any outstanding book items carried forward from the previous reconciliation.
Use a usable issuer export or accounting feed where available. If the starting point is a PDF or scanned statement, create a transaction table from every activity section. Repayments count even when they appear beneath the purchases or on a separate page. Include fees, interest, refunds, and other credits as well as merchant charges.
Opening and closing balances are controls, not extra transaction rows. A cardholder subtotal is also a control: adding it to the purchases it summarizes duplicates the activity. Compare the extracted purchase, payment, fee, and credit totals with the statement summary before relying on the table.
For client PDFs, Invoice Data Extraction can extract financial documents into spreadsheets. Its supported jobs include Bank & card statements: one row per transaction, from PDF or scanned statements, and Receipts & expenses: photos and scans into an expense sheet. Request the transaction date, posting date where shown, description, transaction type, amount, and cardholder or masked card identifier where relevant. Save the recurring instructions to the Prompt Library for the next month's documents.
Keep Source File: the file and page each row came from. A value or a row the panel of AI agents cannot agree on is flagged as Review Needed, with what to check. Check those values against their pages, then use the prepared rows in your worksheet or accounting software to match entries, make corrections, and document outstanding items. Add your own ledger-match and evidence-status fields for the bookkeeping review.
Retain both transaction and posting dates when the issuer provides them; leave an unavailable date blank rather than substituting another date. If several employees share one account, extract corporate card statements with cardholder attribution so each purchase keeps its owner without counting it twice in the account total.
Prove the balance with one worked reconciliation
Start by proving the statement's own movement:
Previous balance + purchases + fees + interest − repayments − refunds and other credits = statement closing balance.
Consider an illustrative dollar-denominated statement for August 26 to September 25. It opens at $2,000 and shows $1,250 of purchases, a $35 fee, $15 of interest, a $1,500 repayment, and a $100 supplier refund:
$2,000 + $1,250 + $35 + $15 − $1,500 − $100 = $1,700 owed at September 25.
The card register at that same date shows $1,730 owed. It includes an $80 supply purchase made and recorded on September 25 that the issuer posts on September 27. It omits the $35 fee and $15 interest charge. All other activity is recorded correctly, and there are no opening reconciling items in this example.
These differences need different treatment. Record the missing $50 of costs in the books, increasing the actual card liability to $1,780. Keep the $80 purchase in the register and identify it as outstanding on the reconciliation schedule. Deducting it from the corrected ledger balance for comparison explains the issuer's $1,700 balance.
| Balance control | Amount | Treatment |
|---|---|---|
| Statement opening balance | $2,000 | Agrees with previous statement and reconciled opening ledger |
| Statement closing balance, September 25 | $1,700 | Target supported by statement activity |
| Unadjusted ledger liability, September 25 | $1,730 | Includes outstanding purchase; omits fee and interest |
| Missing fee and interest | +$50 | Post correcting entries in the books |
| Corrected ledger liability, September 25 | $1,780 | Actual amount recorded in the books |
| Supply purchase not yet posted by issuer | −$80 | Timing item on the schedule only |
| Ledger adjusted for statement comparison | $1,700 | $1,780 minus $80 |
| Unexplained difference | $0 | Adjusted comparison agrees with statement |
Cornell's guidance on reconciling asset and liability balances says to compare the general ledger ending balance with the ending balance of the supporting source and finish with matching adjusted balances. Here, that means $1,780 − $80 = $1,700. It does not mean forcing the actual ledger to $1,700 with a journal entry. Carry the outstanding purchase forward and confirm it clears on the next statement.
If the statement closes before month-end
A September 25 statement reconciliation does not by itself establish the September 30 liability. Roll the corrected ledger forward using every intervening balance-changing transaction. If September 26 through September 30 brings $220 of new purchases, a $300 repayment, and a $20 refund, the month-end liability is:
$1,780 + $220 − $300 − $20 = $1,680 owed at September 30.
The $80 purchase's September 27 issuer posting is not another purchase in the ledger. It was already booked on September 25, so adding it again would duplicate the liability.
Book repayments, fees, refunds, and corrections correctly
A purchase and its later repayment are separate events. The purchase debits the appropriate expense or asset account and credits the card liability. The repayment settles that liability; charging it to purchases again would count the cost twice.
For the worked case, the relevant entries are:
| Transaction | Debit | Credit |
|---|---|---|
| $1,500 card repayment | Card liability $1,500 | Bank account $1,500 |
| Missing $35 card fee | Card fee expense $35 | Card liability $35 |
| Missing $15 interest | Interest expense $15 | Card liability $15 |
| $100 supplier refund, where the original purchase was expensed | Card liability $100 | Original expense account $100 |
The repayment appears as money leaving the bank and as a payment received by the card issuer. Match those two records to one transfer, with one debit to the card liability and one credit to cash. Do not add a second transfer when the other feed downloads it. Check the bank-side clearing date when reconciling the bank account used for card repayments; the bank and issuer can record the same payment on different dates.
The refund entry depends on the original purchase. A return of an item recorded as an asset generally reverses the relevant asset amount rather than an unrelated expense. Check the original transaction and supplier credit document before assigning the offset account. Other issuer credits also need their own explanation; do not label every reduction a purchase refund.
Investigate a missing entry against the statement and underlying document before posting it. For a suspected duplicate, compare amounts, dates, merchant references, and the original manual entry with the imported record. Correct the duplicate rather than creating an offsetting charge just to make the account balance.
Personal spending still increases the amount owed to the issuer. Its offset belongs in the account appropriate to the entity and circumstances, such as an amount due from an owner or employee, or an owner distribution account. Coding every personal charge as a business expense, or prescribing an owner's draw for every entity, misstates the books even if the card balance reconciles.
A disputed charge remains part of the issuer's balance until the issuer removes or credits it. Track the dispute and any provisional credit separately; do not assume a disputed charge has already been reversed.
If repayments and credits exceed the amount owed, the issuer can show a credit balance. Under the positive-amounts-owed convention, that balance is negative. Preserve its sign in the worksheet and check how the accounting software represents it; changing it to an absolute value creates a false difference.
Build a credit card reconciliation worksheet in Excel
Use two tabs: Balance control for the table above and Transactions for the matching record below. Copy the tables into Excel and adapt the references to your files. Keep the account identifier, currency, statement period, preparer, and review date above the balance control.
In the transaction tab, define positive amounts as increases in what is owed and negative amounts as reductions. These are liability movements, not a list of deductible expenses. The $2,000 opening balance stays in the control tab rather than becoming a transaction row.
The following completed rows use the same example. Dates are in September; the current statement is Sep-card.pdf. The final row starts from a purchase receipt and is linked to the next statement when its September 27 posting is confirmed.
| Source file/page | Transaction date | Posting date | Type and description | Signed amount | Book reference / coding | Ledger-match status | Evidence reference / status | Exception action |
|---|---|---|---|---|---|---|---|---|
| Sep-card.pdf p. 2 | Sep 3 | Sep 4 | Purchase: software | +$600 | CC-101 / software expense | Cleared on current statement | INV-101 / present | None |
| Sep-card.pdf p. 2 | Sep 8 | Sep 9 | Purchase: office supplies | +$450 | CC-102 / office supplies | Cleared on current statement | REC-102 / present | None |
| Sep-card.pdf p. 2 | Sep 12 | Sep 13 | Purchase: hotel | +$200 | CC-103 / travel expense | Cleared on current statement | Receipt missing; purpose to confirm | Cardholder to supply receipt and trip purpose |
| Sep-card.pdf p. 1 | Sep 15 | Sep 16 | Repayment from bank | −$1,500 | TR-104 / bank transfer | Cleared on current statement | Bank payment BP-104 / present | Confirm both feeds use one transfer |
| Sep-card.pdf p. 2 | Sep 18 | Sep 19 | Refund: returned supplies | −$100 | CC-105 / office supplies reversal | Cleared on current statement | Credit note CN-105 / present | None |
| Sep-card.pdf p. 1 | Sep 25 | Sep 25 | Card fee | +$35 | JE-106 / card fee expense | Cleared after book correction | Issuer statement / present | Correction posted |
| Sep-card.pdf p. 1 | Sep 25 | Sep 25 | Interest | +$15 | JE-107 / interest expense | Cleared after book correction | Issuer statement / present | Correction posted |
| REC-108.pdf p. 1; next statement p. 2 | Sep 25 | Sep 27 | Purchase: supplies | +$80 | CC-108 / office supplies | Outstanding at Sep 25 | REC-108 / present | Carry forward; confirm next-statement clearing |
Add a Current statement? column: Yes for the first seven rows and No for the $80 outstanding purchase. Sum signed amounts for Yes rows only: the statement movement is −$300, which takes the opening $2,000 to $1,700. Summing all eight rows gives −$220, which takes that same opening balance to the corrected $1,780 register balance.
In Excel, store the amounts as numbers and use SUMIF to total the rows marked Yes. Compare that movement with closing balance minus opening balance in the control tab. Filter ledger-match status to see outstanding items, and filter evidence status separately to see purchases awaiting support. In a real file with opening outstanding items, retain the prior schedule and track which of those items clear during the period as well.
Assign each open exception to a person with a follow-up date. The hotel's missing receipt belongs on the evidence list; it does not create a $200 balance difference. The supported $80 supplies purchase belongs on the timing schedule because it has not posted by statement close.
Check purchase evidence separately from balance agreement
The $200 hotel charge in the worksheet is recorded and cleared, but its receipt and business purpose still need confirmation. The $80 supplies purchase has its receipt, but it is outstanding at statement close. Evidence status and ledger-match status answer different questions.
Use support appropriate to the transaction:
- Purchases: a receipt or invoice showing what was bought, with the business purpose and any required approval.
- Repayments: bank transfer or payment confirmation matched to the issuer's payment record.
- Fees and interest: the issuer's statement or charge detail supporting the amount booked.
- Refunds: the supplier credit note, return confirmation, or other credit documentation tied to the original purchase.
For US tax records, IRS Publication 583 explains that payment evidence alone does not establish entitlement to a deduction. Supporting documents must also establish the cost and its business character. A card statement can support payment; it does not resolve every question about what was purchased or why.
For the hotel row, follow the process for handling missing business receipts: request the missing support, document the explanation and follow-up, and retain the exception until it is resolved under the business's policy. Give it an owner and due date without changing a correctly recorded card liability merely because the receipt is absent.
Where a purchasing-card program requires separate cardholder certification and approval, use the additional purchasing-card reconciliation and approval controls. Approval of spending and proof of the liability balance each need their own record.
Retain the full statement, corrected card register, correcting-entry references, outstanding-item schedule, and evidence references together. Date the balance reconciliation and record who prepared and reviewed it. If receipt exceptions remain, identify them explicitly in that close record, with the responsible person and follow-up date, so a completed balance check does not conceal unfinished evidence work.
Reconcile the card account in QuickBooks Online
Apply the same statement-date method in QuickBooks Online. Intuit's account reconciliation instructions currently direct you to All apps → Accounting → Reconcile. Some accounts also have a statement-upload reconciliation experience; use the available workflow and a usable feed or export where it meets the job.
- Select the credit card account. Check the beginning balance against the previous reconciliation and review the last statement ending date. Investigate an opening discrepancy before reconciling the new period.
- Enter the statement Ending balance and Ending date. For the example, these are $1,700 and September 25, even if you are completing the work at month-end.
- Add or correct missing book entries. Record the $35 fee and $15 interest in their appropriate expense accounts against the card liability. Confirm the $1,500 repayment is one transfer from the bank account.
- Match and select transactions appearing on the statement. Clear the purchases, repayment, refund, fee, and interest. Leave the September 25 $80 purchase unchecked because it posts after this statement closes.
- Finish when Difference is $0.00. The reconciliation can reach zero while the corrected card register still shows $1,780: the unchecked $80 explains the gap to the $1,700 statement balance.
If Difference remains, check the entered statement balance and date, the beginning balance, missing fees or credits, duplicate entries, and whether the repayment was recorded twice. For purchases entered from receipts and then imported through a feed, use the steps for fixing receipt and bank-feed duplicate expenses in QuickBooks. Resolve the cause rather than accepting a balancing adjustment that hides it. Save the completed reconciliation report with the timing schedule and evidence exceptions.