How to Reconcile Credit Card Statements Each Month

To reconcile credit card statements, match the card's liability account to each statement as of the statement's closing date, not the calendar month end. The balance runs the other way from a bank account: purchases and interest raise what the client owes, while payments and refunds lower it. Payments the issuer has not posted yet stay outstanding.

Credit card statement closing dates versus calendar months

A credit card statement covers a billing cycle that ends on a closing date, and that date rarely falls on the last day of the month. A card that closes on the 23rd reports February 24 to March 23, so the statement you reconcile against never lines up with the calendar month in the client's books.

For consumer cards, the closing date is a defined part of the statement. Under Regulation Z, section 1026.7(b), the periodic statement must show the balance outstanding at the start of the cycle, the closing date of the cycle and the balance outstanding on that date. Those are the three figures a reconciliation needs: previous balance, closing date and new balance. Regulation Z, section 1026.3 exempts credit extended primarily for business purposes, so a business card's statement is not bound by that list. Look for the same three figures on it anyway, and ask the issuer if one is missing.

Reconcile to the closing date. Enter the statement's closing date and new balance in the reconcile screen, and clear only the charges, payments and credits the statement lists. Transactions between the 24th and the 31st belong to the next statement even though they fall in the same calendar month. Trying to force the card to the 31st means guessing which late-month charges the issuer will post, and the guess is often wrong.

Calendar month end still matters for the client's reports. At March 31 the books will hold charges dated March 24 to 31 that no statement shows yet. That is expected. They will appear on the statement closing April 23 and be cleared then, the same way an outstanding check clears on a later bank statement.

Two dates sit close together on every statement and are easy to confuse. The closing date ends the cycle. The payment due date comes later; for consumer cards, Regulation Z says it must fall on the same day of each month. Reconcile to the closing date and use the due date only to understand when the client's payment is likely to arrive.

A closing date can move from one cycle to the next, so read it off each statement rather than assuming last month's. Keeping the run of statements complete helps here too, because a cycle that seems to cover 35 days is often a sign one statement is missing.

Card payments, refunds and interest on the credit card statement

A credit card account in the books is a liability, so it works in reverse from a checking account. A purchase increases the balance owed. A payment from the client's bank account decreases it. A refund from a merchant decreases it. Interest and fees increase it. Each item on the statement has a matching entry in the liability account.

Payments are two-sided. The same payment appears as money out on the bank statement and as a payment on the card statement, usually on different days. In the books it should be one transfer from the bank account to the card account, not an expense. If the payment is recorded as an expense and the card charges are recorded as expenses too, the client's costs are counted twice.

Refunds are credits. On consumer cards, Regulation Z requires the statement to show each credit to the account during the cycle, with its amount and the date it was credited. For the reconciliation, a refund is simply a line that lowers the balance owed. Match it to the original charge by merchant and amount when you can; a refund that arrives in a later cycle than the purchase is normal and still clears on the statement where it appears.

Interest is the item most often missing from the books. On consumer card statements, Regulation Z requires interest charges to be grouped under the heading "Interest Charged," with fees grouped separately under "Fees." A business card statement may label them differently. Because the client never initiated these charges, they do not show up in a receipt pile. Read the interest and fee section of each statement and enter what is there before you start clearing.

Cash advances and balance transfers also appear on some statements. They increase the liability like a purchase, and any fee charged for them appears as its own line. Enter them as the statement presents them.

The receipts that support each charge are a separate job from the reconciliation. The receipts and invoices category covers collecting and matching them. The reconciliation proves the liability balance; the receipts prove what each charge was for.

Reconciling credit card statements in QuickBooks

Reconciling credit card statements in QuickBooks follows the same Begin Reconciliation flow as a bank account, with two differences. The lists in the reconcile window are named for card activity, and trying to finish with a difference left over brings up a payment prompt instead of an adjustment prompt. The figures you enter still come from the statement.

Intuit's Reconcile an account in QuickBooks Desktop guide covers both account types. Go to Banking > Reconcile and select the card account. Set the Statement Date to the card's closing date, which will not be the 30th or 31st for most cards. Confirm the Beginning Balance against the statement's previous balance, enter the new balance as the Ending Balance, and select Continue.

In the reconcile window, Intuit names the two lists Charges and Cash Advances and Payments and Credits, and suggests working through one at a time. Tick each purchase, interest charge and fee under the first list, and each payment and refund under the second. Use "Hide transactions after the statement's end date" so charges from the 24th onward stay out of view. When the difference reaches $0.00, select Reconcile now.

The finish is where cards differ. When the difference is not zero and you try to finish, QuickBooks opens a reconcile adjustment window for a bank account. For other account types, Intuit's guide says it opens the make payment window instead, and you select Cancel if you do not want to record a payment. That prompt offers to write a payment toward the card. If the difference comes from something else, such as an unrecorded interest charge, cancel it and go back to the lists, or a payment lands in the books that the client never made.

The QuickBooks Online reconcile screen uses its own layout and wording. The post on ticking off transactions in the QuickBooks Online reconcile window walks through it.

A worked card reconciliation closing on the 23rd

This example is fictional. Birchwood Dental Studio (example client) has one business card ending XXXX-5530. The statement covers February 24 to March 23.

In the books, the card account at March 23 shows $2,921.85. The $1,500.00 difference is a payment the office manager sent from checking on March 22; the issuer posted it on March 26, so it appears on the April statement. In QuickBooks the bookkeeper enters a statement date of March 23 and an ending balance of $4,421.85, ticks the March 3 payment, the 27 purchases, the refund and the interest charge (entered first, since nobody had recorded it), and leaves the March 22 payment unticked. The difference is $0.00, so the bookkeeper selects Reconcile now and no payment prompt appears.

How do you reconcile several cardholders on one credit card statement?

Several cardholders on one credit card statement means employee cards billed to a single company account. The account has one previous balance, one new balance and one payment, so the reconciliation happens once, at the account level. Individual cardholders matter for reviewing charges and collecting receipts, not for reaching a zero difference.

Reconcile the whole statement to the single liability account first. Every cardholder's charges feed one balance owed to the issuer, and the issuer accepts one payment against it. Splitting the account into one ledger account per cardholder can make reports easier to read, but the reconciliation then has to add those accounts back together to compare with the statement total.

When the statement groups charges by cardholder, use those subtotals as a review tool. Compare each cardholder's subtotal with the receipts that person submitted. A cardholder whose charges total $1,846.20 but whose receipts total $1,611.20 has $235.00 of charges to explain, and that conversation happens with the cardholder, not with the issuer.

Watch the last four digits. When each employee card carries its own number, a charge listed under card ending 7712 belongs to that cardholder even if the receipt landed in someone else's folder. Matching by card number keeps a shared receipt inbox from sending charges to the wrong person.

Refunds can cross cardholders. A return made by one employee may be credited to the card that made the purchase, or to the account as a whole. Match the refund to the original charge by amount and merchant rather than by who returned the item.

When an employee leaves, the card is usually closed but the account stays open. Charges and refunds can still post under the closed card number for a cycle or two. Keep reconciling them on the same statement until they stop.

Why does the card payment not match the statement balance?

A card payment that does not match the statement balance is usually a partial payment or a payment that crossed periods. Clients often pay the minimum, a round amount, or the balance from an earlier statement. And a payment sent near the closing date may post after it, landing on the next statement instead of this one.

Partial payments are the simpler case. The statement's previous balance minus the payment equals the amount carried into the new cycle, and interest may then be charged on what was carried. Nothing is wrong in the books as long as the payment amount matches what the bank statement shows leaving checking.

Cross-period payments look like errors but are timing. Take a card that closes on March 23 (example dates): a $1,500.00 payment sent on March 22 posted on March 26, after the close. It is in the books in March and on the April card statement. On the March reconciliation it stays unticked, the same as an outstanding check. On the April reconciliation it gets ticked.

Autopay settings explain many mismatches. A card set to pay the statement balance pays what was owed at the last closing date, not the current balance, so the payment will never equal the balance shown on the day it is drafted. Ask the client how the autopay is set before treating the difference as a problem.

A mismatch that is not timing points to the books. Check for a payment recorded twice, once from the bank feed and once when the bookkeeper entered it by hand, or a payment posted to the wrong card account. Compare the payment's amount and date on three documents: the bank statement, the card statement and the ledger. The one that disagrees with the other two is where the fix goes.

A missing statement makes every one of these checks harder. Without February's statement, March's previous balance cannot be confirmed and a February payment has nowhere to clear. Schema CPA reads credit card statements alongside bank statements, carries each new balance into the next statement's previous balance, and calls out a month that is missing from the run. The document types it reads are listed on the homepage.

Most clients have more than one card or account. The post on reconciling multiple bank accounts covers ordering that work, and catch-up bookkeeping from bank statements covers a client whose cards have gone unreconciled for months.