Credit Card Statement Bookkeeping for Client Accounts

Credit card statement bookkeeping records each purchase on the card as an expense, each refund as a reduction of that expense, and the payment from the bank as a transfer that pays down the card balance. Get the payment wrong and expenses are counted twice. Get the statement period wrong and months stop matching.

How is a credit card statement different from a bank statement?

A credit card statement records money owed, not money held. A bank statement shows a balance the client owns; a card statement shows a balance the client owes the issuer. Purchases raise it, payments and refunds lower it, and interest and fees raise it again.

The same fields with the signs flipped

A card statement still has dates, descriptions and amounts, but the meaning of a positive number reverses. In the books the card is a liability account. A purchase is a credit to the card and a debit to an expense. A payment is a debit to the card and a credit to checking. Many statements print purchases as positive amounts and payments as negative amounts, so a converter that assumes "negative means money out" will flip them.

What else is different

Several things set a card statement apart from a checking statement:

• No running balance on each line. Most card statements print a previous balance, a list of activity and a new balance, not a balance after every line.
• A closing date that is not the end of the month. Card cycles often close on a set day such as the 14th or the 27th.
• Interest and fees as separate lines. Finance charges and annual fees appear as their own entries and need their own accounts.
• Rewards and credits. Cash back or statement credits reduce the balance and may be income or an expense reduction, depending on how the client treats them.
• Authorized users. Employees or family members may hold cards on the same account, with charges the owner never sees.

The balance check still works

Without a line balance, the check happens for the whole statement: previous balance, plus purchases and fees, minus payments and credits, must equal the new balance. If it does not, a line is missing or a sign is flipped. AutoBankConvert applies the same rule that governs its other statements, that opening balance plus transactions must equal the closing balance before a statement is marked done, and flags a card statement that fails it.

Getting card data into a spreadsheet

Bookkeepers often ask how to convert a credit card statement to Excel. The practical steps are the same as for a bank statement: get the PDF from the card portal, extract the lines into columns for date, description and amount, fix the signs, and check the totals against the statement. Do the sign check carefully, because a spreadsheet will happily add a payment as if it were a purchase. If you convert many statements for many clients, a batch tool saves the retyping; the AutoBankConvert homepage describes how a folder of PDFs becomes categorized, export-ready files.

Card payments recorded as transfers, not expenses

A credit card payment is a transfer from checking to the card account. It is not an expense, because the expense was already recorded when the purchases were. Recording the payment as an expense counts the same spending twice: once as the purchase, and again as the payment.

The two-sided entry

When the client pays the card from checking, the entry has one side in each account:

• Checking goes down by the payment.
• The card liability goes down by the same amount.

No expense account is touched. That is why the payment line on the bank statement and the payment line on the card statement describe the same event and must match.

Where it goes wrong

The most common mistake is categorizing the bank-side payment, "CARD PAYMENT" or "ONLINE PMT," as an expense because it has no vendor. If the card's purchases were also recorded, expenses are overstated by the amount paid. Another version occurs when the card statements are not in the books at all: the payment then looks like the only evidence of spending, and the real categories are lost. You get totals but no detail.

Checking the match

After posting, look at the card account and the checking account side by side:

1. Every payment on the card statement should have a matching withdrawal on the bank statement.
2. The dates may differ by a few days, since the bank and the issuer post at different times.
3. The amounts should be identical.
4. Any card payment in checking with no match on a card statement points to a card account missing from the books.

A payment whose card account has no statements is a gap in your record, and the guide to fixing uncategorized transactions lists it among the transfer problems to resolve.

Autopay and partial payments

Autopay can draw the minimum, a fixed amount or the full balance. When the client pays only part of the balance, the remainder carries forward, and interest is added to the next statement. The treatment is the same: the payment is a transfer, and the interest is an expense posted from the card statement.

Transfers between the two accounts

If both accounts appear on a combined or multi-account statement, one file can hold both sides of the payment. For the rules on handling those, see transfers between accounts on a combined statement.

Personal charges on a business credit card

A personal charge on a business card is not a business expense, so it must not stay in an expense account. Move it to an owner's draw or a due-from-owner account, and record the repayment when the owner settles it. What you call the account depends on the type of business and the CPA's preference.

How to find them

Personal charges rarely announce themselves. Scan the card activity for:

• Grocery stores, pharmacies and streaming services.
• Travel on dates that match no business trip.
• Online retail with no matching supply need.
• Repeated small charges at a restaurant near the owner's home.

Anything you cannot place goes on the client's question list. Ask what it was, rather than assuming.

Where to put them

The right account depends on the business structure, and the CPA should set the rule. A common approach for a sole proprietor or single-owner LLC is owner's draw. For a corporation, it may be a loan to the shareholder or a payroll item. Do not guess; record what the CPA has told you, and write the choice in the client notes.

Mixed purchases

Some charges are partly business. A phone bill, a warehouse club run or a trip with a client dinner and a family dinner may need splitting. Ask for the business share, record it as two lines on the same transaction, and keep the client's note. A split without a source note is hard to defend later.

A posting example

The table below shows a card statement for an example client, with a purchase, a payment, a refund and a personal charge. The figures are made up for illustration.

Reading it line by line: the purchases and the personal charge raise what the card owes. The refund lowers both the liability and the earlier expense or asset purchase it reverses. The payment reduces the liability and checking and touches no expense. Starting from a previous balance of 1,000.00, the new balance is 1,000.00 plus 412.80, 96.40 and 29.00, minus 150.00 and 500.00, which is 888.20. If the statement's new balance differs, a line is missing or has the wrong sign.

Refunds show why the sign matters. A refund credited to the card goes back to the account that took the original charge. Putting it into income would inflate both income and expenses.

Which date to post: card transaction or statement close?

Post each charge on its transaction date, not the statement closing date, so expenses fall in the month they happened. A statement that closes on the 14th still contains charges from the month before, and posting everything on the close date moves a month of spending into the wrong period.

Transaction date or posting date

Card statements often print two dates: when the client made the purchase and when the issuer posted it. A purchase on the last day of a month may post on the first day of the next. Use the transaction date for the expense so the month is right, and keep the posting date visible for matching. The practice should pick one rule for each client and apply it every month. Both dates are valid only if used consistently.

Why not the closing date

Posting by closing date has one advantage: it is simple, and each statement posts as one batch. The cost is that expenses land one cycle late, which distorts monthly profit and breaks cutoff at year end. For clients whose reports go to a lender or an owner each month, the transaction date is worth the extra care. For a client who needs only annual numbers, a consistent posting date may be acceptable if the CPA agrees.

The payment date

The payment follows the bank's date, because that is when cash left the account. It is a transfer, so the date affects the cash balance but not profit. Match it to the bank statement date and not to the card statement's cycle.

Credit card statement periods that cross month end

A card statement period crosses month end when the cycle closes mid-month, so one statement holds the end of one month and the start of the next. The fix is to post by transaction date and let the statement span two months, rather than forcing each statement into one month.

An example of a mid-month cycle

Suppose a card closes on the 14th. The March statement runs from February 15 to March 14. Its charges belong to two months: those dated February 15 to 28 are February expenses, and those dated March 1 to 14 are March expenses. The balance check runs on the whole statement, but the posting follows each line's date.

What this does to month end

At the end of each month, part of that month's spending is not yet on a statement. A purchase on March 20 appears on the April statement. To close March completely, you either wait for the April statement or accept that the last stretch of March is still to come. Which choice fits depends on the client's reporting:

• Wait for the next statement. Cleanest, but delays the close of the month.
• Use the card portal's activity list. Pull the recent unbilled charges and post them, then replace them with the statement when it arrives.
• Close on the statement basis and say so. Report that card expenses run to the 14th, and apply the same cut every month.

The year end edge

The last statement of the year usually closes before December 31. Charges from the closing date to year end sit on the January statement, and you need that statement to finish the year. The year end bookkeeping checklist includes it in the count of statements per account. For a client who is months behind on cards, the plan in the guide to catching up on bookkeeping from bank statements puts statements in order before anything is posted.

Keep the routine light

Posting by transaction date across cycles sounds fussy, but it is mechanical once rules and a monthly routine exist. The steps for automating bookkeeping without losing control show where conversion, categorization and review fit, so card statements go through the same path as every other account.