Card Statement Proof Worksheet

A fill-in worksheet that proves a credit card statement is complete before you book it: previous balance to new balance, line by line, with four worked statements that add up. Maintained by ZeraBooks. Last checked November 2026.

What's the short answer?

A card statement is complete when previous balance, minus payments and credits, plus purchases, cash advances, balance transfers, fees and interest, equals the new balance printed on the statement, to the cent. If it doesn't, a line is missing or doubled, or one has the wrong sign. ZeraBooks, the converter and AI ledger I built, runs this check on every card statement it reads.

Is a card statement proved the same way as a bank statement?

No. It runs the other way. On a bank statement, deposits raise the balance. On a card, the balance is what you owe, so charges raise it and payments lower it. If you reuse a bank formula on a card, every payment looks like a deposit and the proof comes out backwards.

The blank worksheet

Copy these lines into a notebook or a spreadsheet. Fill in the numbers the statement prints in its account summary, then add up the transaction rows yourself and compare.

• Line 1. Previous balance (from the summary)

• Line 2. Minus payments

• Line 3. Minus credits and refunds

• Line 4. Plus purchases or new charges

• Line 5. Plus cash advances and balance transfers

• Line 6. Plus fees charged this period

• Line 7. Plus interest charged this period

• Line 8. Your result: Line 1 - 2 - 3 + 4 + 5 + 6 + 7

• Line 9. New balance (from the summary)

• Line 10. Difference: Line 9 - Line 8. It must be 0.00.

Then one check on the rows. If money out is negative in your spreadsheet (charges, cash advances, fees, interest) and money in is positive (payments, refunds), the rows should add up to previous balance minus new balance. That catches a row that's in the summary but missing from your file.

Worked statement 1: American Express, two card members

Copper Kettle Catering (made up) has an Amex business card with two card members. The billing period is 10/08/26 to 11/07/26, so it closes in the middle of the month, the way Amex billing periods typically do. The summary typically prints Previous Balance, Payments/Credits with a minus, New Charges, Fees, Interest Charged and New Balance.

• Previous balance: 4,318.62

• Payment: 2,500.00

• Credit (a returned order): 129.40

• Payments/Credits total: 2,500.00 + 129.40 = 2,629.40

• New charges, card member Nguyen: 1,084.55 + 367.20 = 1,451.75

• New charges, card member Brooks: 2,212.90

• New charges total: 1,451.75 + 2,212.90 = 3,664.65

• Fees: 0.00

• Interest charged: 31.87 (the card carried a balance)

• Result: 4,318.62 - 2,629.40 + 3,664.65 + 31.87 = 5,385.74

• New balance printed: 5,385.74. Difference 0.00.

Row check: 2,500.00 + 129.40 - 3,664.65 - 31.87 = -1,067.12, and 4,318.62 - 5,385.74 = -1,067.12. They match.

When Amex prints a total per card member, check each person too. Nguyen's rows must add to 1,451.75 and Brooks's to 2,212.90. Payments and interest belong to the account, not to a card member.

More on Amex layouts: American Express statement to Excel.

Worked statement 2: Discover, with a cash advance

Fernwood Bike Repair (made up) used a Discover card for parts and took one cash advance. Discover's account summary shows the previous balance and each category for the cycle: payments and credits, purchases, balance transfers, cash advances, fees and interest charges.

• Previous balance: 2,940.15

• Payments and credits: 1,000.00

• Purchases: 418.27 + 96.50 + 1,302.88 = 1,817.65

• Balance transfers: 0.00

• Cash advances: 200.00

• Fees: 10.00 (the cash advance fee in this example)

• Interest charged: 38.41

• Result: 2,940.15 - 1,000.00 + 1,817.65 + 200.00 + 10.00 + 38.41 = 4,006.21

• New balance printed: 4,006.21. Difference 0.00.

Row check: 1,000.00 - 1,817.65 - 200.00 - 10.00 - 38.41 = -1,066.06, and 2,940.15 - 4,006.21 = -1,066.06.

The cash advance is a row of its own. So is its fee. Book the advance as cash taken out, not as a purchase. The rewards box on the statement isn't part of this math. More on Discover: Discover statement to Excel.

Worked statement 3: Capital One Spark, two cardholders

Mill Pond Landscaping (made up) pays its Spark card in full each month. Capital One says a card statement typically has a payment information section, an account summary, a rewards summary, transactions, a year-end summary and an interest charge calculation.

• Previous balance: 5,602.30

• Payment: 5,602.30

• Credit (a refund on Okafor's card): 48.00

• Charges, cardholder Ruiz: 2,145.60 + 733.19 = 2,878.79

• Charges, cardholder Okafor: 1,920.00 + 58.44 = 1,978.44

• Charges total: 2,878.79 + 1,978.44 = 4,857.23

• Fees: 0.00. Interest: 0.00 (paid in full).

• Result: 5,602.30 - 5,602.30 - 48.00 + 4,857.23 = 4,809.23

• New balance printed: 4,809.23. Difference 0.00.

Row check: 5,602.30 + 48.00 - 4,857.23 = 793.07, and 5,602.30 - 4,809.23 = 793.07.

The trap here is the year-end summary. U.S. card statements group fees and interest with year-to-date totals, a rule in Regulation Z (12 CFR 1026.7(b)(6)). Say Mill Pond's year-to-date fees read 39.00. That's the year so far, not this month. Put it on Line 6 and you're off by exactly 39.00. More on Spark statements: Capital One statement to Excel.

Worked statement 4: Citi co-branded card, balance carried

Sutter Lane Bakery (made up) buys supplies on a store card issued by Citi. Co-branded cards like a Costco card are Citi accounts, so the statement comes from Citi's site, not the store's. This month the bakery paid part of the balance.

• Previous balance: 1,275.48

• Payment: 900.00

• Credits: 0.00

• Purchases: 642.11 + 1,118.36 + 87.25 = 1,847.72

• Fees: 0.00

• Interest charged: 14.22

• Result: 1,275.48 - 900.00 + 1,847.72 + 14.22 = 2,237.42

• New balance printed: 2,237.42. Difference 0.00.

Row check: 900.00 - 1,847.72 - 14.22 = -961.94, and 1,275.48 - 2,237.42 = -961.94.

Interest is a real charge and it goes in the books as an expense, even though no one swiped the card for it. Check the account summary for the previous and new balance and the fee and interest totals before you convert. More on Citi: Citi bank statement to Excel.

What does it mean when the worksheet doesn't tie?

The size of the difference usually tells you what went wrong.

• The difference equals one row. That row is missing or doubled. Search the statement for that exact amount.

• The difference is twice one row. That row has the wrong sign. In statement 1, if the 129.40 credit came through as a charge, you'd get 4,318.62 - 2,500.00 + 129.40 + 3,664.65 + 31.87 = 5,644.54. That's 258.80 too high, and 258.80 is 2 x 129.40.

• The difference equals a year-to-date figure. You picked up a total from the year-end or fee summary instead of this period's line.

• The difference is a foreign currency amount. A line under a purchase that shows the amount in another currency is detail, not a second charge.

• The whole page total is missing. A page didn't make it into your file. Count the pages in your file against the page numbers printed on the statement.

Can software do this for me?

Yes. The worksheet takes five minutes a statement by hand. If you handle a lot of cards, the ZeraBooks credit card statement converter reads the PDF, runs the previous balance to new balance proof, checks each cardholder against their printed total where the issuer prints one, and shows the result above the rows before you download Excel or CSV. It reads bank statements the same way, see the bank statement converter. It costs $79 a month billed annually or $149 billed monthly, with 1,000 pages a month and a 7-day free trial.

About this page

I founded ZeraBooks. It's an AI-native general ledger and bank statement converter for small businesses and accounting firms, and we also do bookkeeping for you if you'd rather not. Every business and number on this page is made up and checked to add up. Issuers change their layouts, so read the labels on your own statement. Corrections welcome at support@zerabooks.com.