Blog
A monthly worksheet for reconciling business card statements to your books
Match each business card charge to a receipt and a category, set aside pending items and refunds, and tie the statement to your ledger. Worked example included.
To reconcile a card statement is to prove that your books and the issuer's statement describe the same month. You do it by matching every line on the statement to something in your records, explaining every difference, and ending with two totals that agree. It takes about thirty minutes for a small business with a dozen charges, and it is one of the most useful habits for catching errors, duplicates, missing receipts and charges you did not make.
This post is a worksheet. It gives you the steps, then fills them in for an invented month so that you can see the arithmetic, then gives you a blank to repeat. The business, merchants and amounts are made up. Use the same method on your own statement, and ask your bookkeeper or accountant how your particular books should record things such as returns and mixed-use charges.
What you need on the table
Gather four things before you start, so that you are not hunting for them halfway.
- The statement for the cycle, as a PDF or the issuer's online version. It lists the beginning balance, purchases, credits, fees, interest, payments and the new balance.
- Your ledger, the place where you record business activity: a spreadsheet, accounting software or a bookkeeping app. You need the entries for this card for the same dates.
- Receipts and invoices for the month, in a folder, an app or a pile sorted by date.
- A list of anything pending, which is any charge you made near the end of the cycle that has not yet reached the statement.
Two ideas will make the rest simpler. First, a statement lists charges by posting date, the day the merchant's charge settled, which can be a day or more after the purchase. A coffee bought on the 24th may post on the 26th and land on next month's statement. Second, a pending transaction is a charge that has been authorized but not yet settled. It can change in amount, as with a restaurant tip or a hotel authorization hold, and it does not belong in this month's tie-out. Keep a separate pending list and carry it forward.
The nine steps
- Check the ends. The beginning balance on this statement should equal the ending balance on last month's. If it does not, find out why before anything else.
- List the charges. Go down the statement and give each charge a number.
- Match each charge to a receipt. A tick mark means you have a receipt or invoice that shows the amount, date and merchant. No receipt means a note.
- Assign a category. Use the same categories as your ledger: materials, fuel, software, insurance, advertising and so on.
- Set aside refunds and credits, and match each to the original charge.
- Compare the statement to the ledger, line by line, and mark what is in one but not the other.
- Compute the difference between the statement's ending balance and the ledger's balance for the card.
- Explain every part of the difference. The reconciling items must add to the difference exactly.
- Record the payment and sign off. Note the date and the person who completed the reconciliation.
The worked example
Dana runs a small remodeling business. Her October statement shows a beginning balance of $0, because the card was paid in full last month, and no interest or fees. These are the charges and the single credit, with the match and category she assigned:
| Date | Merchant | Amount | Receipt | Category |
|---|---|---|---|---|
| Oct 2 | Lumber supplier | $412.60 | yes | Materials |
| Oct 3 | Fuel | $58.14 | yes | Vehicle fuel |
| Oct 5 | Estimating software | $29.00 | yes | Software |
| Oct 7 | Hardware store | $87.45 | yes | Materials |
| Oct 8 | Office supplies | $63.20 | yes | Office |
| Oct 10 | Restaurant, client meeting | $46.75 | yes, note names client | Meals |
| Oct 11 | Lumber supplier, return | −$38.00 | return slip | Materials |
| Oct 14 | Insurance premium | $45.00 | yes | Insurance |
| Oct 15 | Phone carrier, business share | $48.00 | yes | Phone |
| Oct 17 | Fuel | $61.33 | yes | Vehicle fuel |
| Oct 19 | Online marketplace, tools | $129.99 | no | Tools and rental |
| Oct 21 | Tool rental | $140.00 | yes | Tools and rental |
| Oct 23 | Advertising | $75.00 | yes | Advertising |
Step 1. Beginning balance $0, matching last month's ending balance.
Purchases. Adding the twelve purchases: 412.60 + 58.14 + 29.00 + 87.45 + 63.20 + 46.75 + 45.00 + 48.00 + 61.33 + 129.99 + 140.00 + 75.00 = $1,196.46.
Credits. One return, $38.00.
Ending balance. 0 + 1,196.46 − 38.00 = $1,158.46. That is the statement balance she will pay.
Pending list. On October 24 Dana placed a $52.80 supply order. It has not posted, so she writes it on the pending list and does not count it now.
The ledger side
Dana's ledger shows the card activity she has already recorded. When she compares the two, she finds three differences.
- A charge with no entry. The $129.99 marketplace purchase on October 19 has no receipt, so she never entered it. It is on the statement but not in the ledger.
- A mistyped amount. The tool rental on October 21 is in the ledger as $104.00. The statement and the receipt both say $140.00. Two digits were swapped.
- A credit not recorded. The $38.00 lumber return is on the statement, but she has not recorded it.
Her ledger total for the card is the purchases she entered, with the wrong rental amount and without the marketplace charge or the return: 1,196.46 − 129.99 − 140.00 + 104.00 = $1,030.47.
The tie-out
Step 7. Statement ending balance 1,158.46 minus ledger balance 1,030.47 = $127.99 difference.
Step 8. Explain it:
| Reconciling item | Effect on the ledger | Amount |
|---|---|---|
| Marketplace charge missing from ledger | Add | +$129.99 |
| Tool rental keyed at $104.00, should be $140.00 | Add | +$36.00 |
| Lumber return not recorded | Subtract | −$38.00 |
| Total | $127.99 |
The items add to 129.99 + 36.00 − 38.00 = $127.99, exactly the difference. That is the test: if the reconciling items do not equal the difference, there is still an error. Keep looking, or the next month will start with it.
Once she makes the three corrections, the ledger balance becomes 1,030.47 + 127.99 = $1,158.46, which matches the statement.
Fixing what the worksheet found
Each difference has its own follow-up.
- The missing receipt. Dana checks her email for an order confirmation, and finds it. If she could not, she would write a note with the date, merchant, amount and what the item was for, and attach the bank or card record. A line with no support is not wrong, but it is harder to defend if anyone asks. Ask your tax professional what documentation is expected for your expenses.
- The typo. She corrects the entry to $140.00. A transposition error is easy to spot because the difference between the two numbers, $36.00, is divisible by 9, a handy trick: when two digits are swapped, the difference is always a multiple of 9.
- The return. She records the credit and ties it to the original lumber purchase on October 2, so the net cost is visible. what happens to your cash back when you return an online order shows how refunds and returns post, and why a credit may arrive a week or two after the return.
After the corrections, her categories for the month look like this:
| Category | Amount |
|---|---|
| Materials (500.05 less the 38.00 return) | $462.05 |
| Vehicle fuel | $119.47 |
| Software | $29.00 |
| Office | $63.20 |
| Meals | $46.75 |
| Insurance | $45.00 |
| Phone | $48.00 |
| Tools and rental | $269.99 |
| Advertising | $75.00 |
| Total | $1,158.46 |
The categories add to the same $1,158.46 as the statement. That second tie-out, categories to statement, catches a different kind of mistake: a charge entered in the ledger but left out of a category.
A reasonableness check
A reconciliation proves the books match the statement. It does not prove that the spending makes sense. Spend two minutes comparing this month's categories with last month's. Say last month's total was $1,102.30, so this month is up by 1,158.46 − 1,102.30 = $56.16, about 5 percent. That is unremarkable. A category that doubled, or a new merchant you do not recognize, deserves a look. Decide a threshold you will investigate, such as any change of more than a quarter in a category or any charge over a set amount, and apply it every month.
When a charge is not yours
Sometimes the worksheet finds something that cannot be matched: a merchant you have never used, an amount you did not authorize, or a charge for a service you cancelled. Do this in order.
- Check inside the business. An employee, a partner, a bookkeeper or a subscription renewal may have made it. Ask before assuming fraud.
- If no one in the business made it, call the number on the back of the card and ask the issuer to investigate and, if needed, replace the card. Do not use a number from an email or a text, even one that appears to come from the issuer.
- Keep the evidence: the statement line, the date you noticed and the name of the person you spoke to. I see a card charge I do not recognize. What do I do in the first hour? has the steps for the first hour.
- Read your cardholder agreement. Federal rules on billing errors and unauthorized use were written mainly for consumer accounts, and a business card agreement can set its own reporting windows and liability terms, especially for accounts with several employee cards. The agreement and the issuer's instructions control, so report promptly, and in writing if the issuer asks for it. The CFPB takes complaints about some problems with financial companies, and the issuer or your attorney can tell you whether a business account is covered.
what to gather before you dispute a charge: an evidence checklist covers what to gather if the dispute goes further, and billing error explains the consumer-side terms.
Blank worksheet
Copy this into your ledger each month.
| Line | Item | Amount |
|---|---|---|
| A | Beginning balance (must equal last statement's ending balance) | |
| B | Purchases on the statement | |
| C | Credits and returns | |
| D | Fees and interest | |
| E | Payments received | |
| F | Ending balance (A + B − C + D − E) | |
| G | Ledger balance for the card | |
| H | Difference (F − G) | |
| I | Reconciling items (list each, with amount) | |
| J | Unexplained difference (H − I, must be 0) | |
| K | Pending items carried forward | |
| L | Date reconciled and initials |
How often, and who
Monthly is the right rhythm for a business with a handful of charges. Do it within a few days of the statement date, while memories and receipts are fresh and while any dispute window is still open. A business with employee cards, or with a card that is used heavily, benefits from a weekly scan of new charges in addition to the monthly tie-out. Software that imports transactions and matches receipts, often sold as spend management tools, can shorten the work, and how spend management tools use virtual cards and limits to control spending explains what the category of tools does. Even with automation, someone has to look at the totals and sign off. For a one-person business that person is the owner.
If the work is repeated by a bookkeeper, give them the worksheet and the standing rules for mixed-use items, so that the same charge is categorized the same way every month. how to separate business and personal spending, starting this week sets out how to draw that line.
Lines that need their own treatment
Dana's month was clean: no fees, no interest, no foreign charges. Yours may not be. These lines show up on business statements and are easy to mishandle.
- Interest. If the card was not paid in full, the statement shows interest charged. Record it as its own line, not inside a category, so that you can see what carrying a balance costs. Ask your accountant how interest is treated in your books.
- Annual fee and other fees. Record a fee on the date it posts, with a note of what it is. If a fee surprises you, look at the cardholder agreement before paying it, and ask the issuer if it can be waived.
- Foreign transaction charges. A purchase in another currency can appear as two lines or as one amount with a fee included. Match the receipt amount in the foreign currency to the converted amount, and keep both.
- Tips and adjusted charges. A restaurant charge that was authorized at one amount may post at a higher one after the tip. Match the posted amount, not the amount on the first alert.
- Statement credits and rewards. A credit that reduces the balance, such as a rewards redemption or a promotional credit, is not a refund of a purchase. Record it separately so that expense categories do not shrink by mistake.
- Split and shared charges. If one charge covers two purposes, such as a supplier order for two jobs, enter it once and allocate it by job in your ledger, or enter two lines that sum to the charge. Never alter the amount to fit.
- Charges in dispute. Leave a disputed charge in the ledger with a flag, and record the credit when it arrives. Do not delete it.
When the difference does not go away
Occasionally the arithmetic leaves a difference you cannot explain after an honest effort. Three habits stop it from spreading.
First, do not plug it. Forcing the ledger to match by adding an unexplained entry hides the problem and leaves the next month to inherit it. Write the unexplained amount on line J of the worksheet, and say so.
Second, narrow it. Say the unexplained amount is $18.40. Look for a charge of exactly $18.40, then for a charge of $9.20, since a doubled or halved entry is a common cause. Look for a charge that appears twice in the ledger or once instead of twice, and for a payment recorded on the wrong date. Then check the beginning balance again, since a carry-over error from last month is the most frequent culprit.
Third, time-box it. Give yourself fifteen minutes. If the amount is small and unexplained, record it, note it for next month and continue. If it is large, or if it keeps appearing, ask your bookkeeper to review, and consider whether the cause is a process problem, such as receipts that are kept in too many places, more than an arithmetic one.
A rolling record helps with all of this. If you keep each month's completed worksheet, including the pending list, anyone can pick up the trail. The next month's step 1 then starts with the ending balance from the last signed sheet, and a break in the chain shows up immediately.
Key takeaways
- Reconciling means tying the statement's ending balance to the ledger and explaining every cent of the difference. In the example, a $127.99 gap was a missing charge, a typo and an unrecorded return.
- A statement lists charges by posting date, so recent purchases may be pending. Keep a pending list and carry it forward, not into this month's tie-out.
- Reconciling items must add exactly to the difference. If they do not, there is another error.
- A second tie-out of categories to the statement catches items left out of a category, and a month-to-month comparison catches spending that does not look right.
- If a charge cannot be matched and no one in the business made it, call the number on the back of the card and read the business card agreement, which can differ from consumer rules.