Two statements, two kinds of balance
A bank account statement shows money you hold. A credit card statement shows money you owe. That one difference changes which fields appear and how the arithmetic works when you move the data into a spreadsheet.
The U.S. Consumer Financial Protection Bureau (CFPB) publishes a sample credit card statement for teaching, and its Regulation E and Regulation Z pages describe what periodic statements must show. This article uses those pages for the fields and a made-up example for the formulas.
This article is general information, not tax, legal or financial advice. Statement layouts vary by issuer, so always compare against your own statement.
What a bank account statement shows
CFPB's Regulation E page on periodic statements says a statement for an electronic-funds-transfer account must show each transfer during the cycle, including its amount, posting date and type. It must also show the amount of any fees assessed against the account during the statement period, and the balance in the account at the beginning and at the close of the statement period.
In a spreadsheet this usually becomes Date, Description, Debit or Credit (or one signed Amount) and a running Balance, with an opening and closing balance for the period. Individual banks add their own columns, so the exact layout depends on the bank.
What a credit card statement shows
CFPB's "Understanding credit card statements" sample shows an Account Summary with these labelled lines: Previous Balance, Payment/Credits, Purchases, Cash Advances, Balance Transfers, Fees Charged, Interest Charged and New Balance. It also shows a payment due date, a minimum payment, the opening and closing dates of the billing cycle, and credit and cash access lines. In that sample, the payments and credits figure is displayed as a negative number (-$350.42).
The Regulation Z page on the periodic statement matches this structure. It defines the previous balance as the account balance outstanding at the beginning of the billing cycle, requires the statement to show any credit to the account during the billing cycle, and requires the closing date of the billing cycle and the account balance outstanding on that date. It says charges other than periodic-rate charges must be grouped under the heading "Fees", and periodic-rate finance charges must use the term "Interest Charge".
The formulas are different
The sample statement's own figures show how a card balance builds: previous balance $482.42, payments and credits -$350.42, purchases $1,258.56, fees $0 and interest $2.15 give a new balance of $1,392.71. Written as a formula this is previous balance plus the changes in the cycle:
=ROUND(B2 + B3 + B4 + B5 + B6, 2)
B2 previous balance 482.42
B3 payments/credits -350.42
B4 purchases 1258.56
B5 fees 0.00
B6 interest 2.15
Result 1392.71 (matches the sample new balance)Compare that with a bank statement, where the closing balance is the opening balance plus deposits minus withdrawals. On a card, purchases, fees and interest increase the amount you owe and payments reduce it, which is the opposite direction from a deposit account. If you reuse a bank-statement formula on a card, the sign logic will be wrong.
Check how your issuer shows each sign before building anything. The CFPB sample shows payments as a negative, but other statements may show them positive in a separate section. Look at one payment row first.
Setting up the spreadsheet
• Keep card and bank data on separate sheets, or add an Account Type column, so formulas do not mix the two.
• For cards, add a Statement Period column using the billing cycle dates, since a card cycle often does not match calendar months.
• Record the summary figures (previous balance, payments, purchases, fees, interest, new balance) in a small block and check that your transaction rows reproduce them.
• Treat a card payment made from your bank account carefully. It appears as a withdrawal on the bank statement and as a payment on the card statement, so including both in one total counts the same money twice.
Converting a PDF to a spreadsheet saves retyping, but it does not interpret the statement for you, so check totals against the printed figures. PDFtoRow can convert both bank and card statement PDFs to Excel or CSV.
Convert Bank Statement PDFs Cleanly with PDFtoRow
Tired of fixing broken columns, corrupted dates, and numbers stored as text? PDFtoRow extracts transaction tables directly from digital PDF vector layers, preserving check numbers and outputting true numeric amounts. Statements up to 5 pages are free once per email every 24 hours. Check the 10-row preview before you download.
Frequently Asked Questions
Previous Balance, Payment/Credits, Purchases, Cash Advances, Balance Transfers, Fees Charged, Interest Charged and New Balance, along with payment due date and minimum payment.
According to CFPB's Regulation E page, each electronic fund transfer in the cycle, any fees assessed during the statement period, and the balance at the beginning and at the close of the statement period.
On a card the balance is what you owe. Purchases, fees and interest add to it and payments reduce it, so the signs run the opposite way from a deposit account.
Primary Evidence & Official References
- Understanding credit card statements (sample statement poster) — files.consumerfinance.gov (Verified 2026-10-29). Official source documentation →
- Sample credit card statement (handout) — files.consumerfinance.gov (Verified 2026-10-29). Official source documentation →
- Regulation Z section 1026.7: Periodic statement — consumerfinance.gov (Verified 2026-10-29). Official source documentation →
- Regulation E section 1005.9: Receipts at electronic terminals; periodic statements — consumerfinance.gov (Verified 2026-10-29). Official source documentation →