How to reconcile a credit card statement, step by step

Reconciling a card means proving that your records agree with the issuer's statement for the period. The routine is short once you know what to compare.

What you need

The statement for the period, with its statement date and new balance.
The card account in your books or spreadsheet, with transactions entered through the statement date.
The previous period's reconciled ending balance.

Steps

Check the starting point. Your opening balance for the card should equal the previous statement's closing balance. If not, an earlier period was changed after it was reconciled.
Tick off transactions. Go through the statement line by line and match each one to an entry in your records, by date, amount and merchant.
List what does not match. Statement items missing from your books need to be entered. Entries in your books that are not on the statement may fall in the next period, or may be errors.
Include fees, interest and payments. Annual fees, interest charges, and the payment you made are part of the balance and are frequently forgotten.
Compare ending balances. After the changes, your records' balance at the statement date should equal the statement's new balance. The difference should be zero.
If it is not zero, look for an amount equal to the difference (a missing or extra entry) or half of it (a sign error, since a flipped sign moves the total by twice the amount). Check for duplicates, and for refunds entered as purchases.

Using a CSV to speed up the matching

If the statement arrives only as a PDF, converting the transactions to CSV lets you sort and match them against your ledger in a spreadsheet instead of by eye. Add a column for your own category or a matched flag, and filter for unmatched rows. Our Excel reconciliation guide shows a layout for this.

Where PennyTie fits

PennyTie is one way to get that CSV. It reads a text-based card statement PDF in your browser, outputs the transactions, and checks previous balance plus transactions against the new balance. That tells you whether the extraction itself is complete before you start matching, so you are not chasing a difference that came from the conversion.

Limits

PennyTie works on text PDFs only; scanned statements are not supported. A passing check shows the file adds up, not that your books agree with it, which is what the reconciliation itself is for. Review any flagged rows against the PDF.

Try it: open PennyTie, drop a text-based statement PDF (or use the built-in fictional sample) and see whether the totals tie out. Free for statements up to 5 pages; nothing is uploaded.