Free credit card statement template for Excel (with a sample)
Need a credit card statement layout in Excel, to track a card month by month, check a statement line by line, or test an import? This one is free with no sign-up. The workbook has a blank credit card statement template with the formulas already in place, and a fictional sample statement filled in with 21 transactions, so you can see how a finished month ties out to the new balance before you type your own.
Short answer: download the credit card statement template (.xlsx). The Blank template sheet has a card statement layout (previous balance, payments and credits, purchases, fees and interest, new balance, and a Check line), 300 transaction rows and a Balance owed column that fills in by itself. The Sample statement sheet is the made-up Example Community Bank Business Cash Rewards Card ending 7316, September 2026: previous balance 2,846.12, payments and credits 1,542.18 (2), purchases, fees and interest 1,939.94 (19), new balance 3,243.88. It's the same statement as the sample credit card statement PDF.
See the same card statement read from the PDF
Open the sample PDF in Utilly's converter: the same 21 transactions come out of the PDF, signed for your books, with the check against the 3,243.88 new balance and every download free, because the data is fictional. Then try your own card PDF, downloaded or scanned, for a free preview, instead of typing it into the template.
1. What's in the template
One workbook, three sheets. It opens on the sample.
- Blank template: yellow input cells for the card issuer, the card (last 4 digits only), the statement period and the previous balance, a summary that calculates itself, and 300 empty transaction rows with the Balance owed formula on each.
- Sample statement: the fictional statement filled in. A header block, the summary (previous balance; payments and other credits with a count; purchases, fees and interest with a count; the calculated new balance; the new balance printed on the statement; the Check line), then all 21 transactions in date order.
- How to use: short instructions, including what to do when the check doesn't tie out.
Only Balance owed, the totals and the check are formulas. The workbook uses only SUM, COUNT, ROUND, IF, AND and TEXT, so it works the same in Excel, Google Sheets (File, Import), LibreOffice and Numbers. It's the card twin of the bank statement Excel template, with the columns turned around: on a card, charges raise what you owe and payments lower it.
2. Credit card statement format in Excel
One row per transaction and one kind of value per column. The template uses the layout most card statements print:
| Column | Sample | Tip |
|---|---|---|
| Date | 09/01/2026 | The transaction date, as a real Excel date so it sorts and filters. Many cards also print a post date; keep one date column for imports |
| Description | GOOGLE *WORKSPACE CC@GOOGLE.COM | Keep the card's wording; it's what QuickBooks and Xero rules match on |
| Charges | 72.00 | Purchases, fees and interest, as a positive number |
| Payments and credits | 1,500.00 | Payments, refunds and returns, as a positive number |
| Balance owed | 2,918.12 | What you owe after the row: previous balance plus charges minus payments and credits so far |
Card statements print payments and credits in their own section above purchases; the sample PDF does too. The template lists everything by date in one table, the way a card's online activity page does, so the balance owed runs down the page. Most card statements don't print a running balance at all, so on your own card this column is a check you add, not a number to compare line by line. A real statement also has things the template leaves out: the minimum payment and due date, the credit limit, the interest rate table and the issuer's disclosures.
3. Credit card statement formulas
On the Sample statement sheet the previous balance is in E10 and the transactions are rows 19–39 (C = Charges, D = Payments and credits, E = Balance owed).
| What | Formula | Sample result |
|---|---|---|
| Payments and credits | =SUM(D19:D39) | 1,542.18 |
| Purchases, fees and interest | =SUM(C19:C39) | 1,939.94 |
| Number of credits / charges | =COUNT(D19:D39) / =COUNT(C19:C39) | 2 / 19 |
| New balance | =ROUND(E10-E11+E12,2) | 3,243.88 |
| Balance owed (first row, then fill down) | =E10+C19-D19, then =E19+C20-D20 | 2,918.12, then 3,336.72 |
| Balance owed that survives blank rows (what the file uses) | =IF(AND(C19="",D19=""),"",ROUND($E$10+SUM(C$19:C19)-SUM(D$19:D19),2)) | 2,918.12 |
| Two columns into one signed Amount (charges negative, for imports) | =D19-C19 | −72.00 |
| Spending on one merchant | =SUMIFS(C19:C39,B19:B39,"UBER*") | 56.38 |
| Interest charged | =SUMIFS(C19:C39,B19:B39,"*INTEREST*") | 21.36 |
If a total comes out as 0 or too small, the amounts are probably stored as text (they sit left-aligned). Use Data, Text to Columns, Finish on the column, or =VALUE(SUBSTITUTE(SUBSTITUTE(C19,"$",""),",","")). Some card downloads print credits with a minus sign or a trailing CR; type them as positive numbers in Payments and credits.
4. Using the blank template
- Type the card issuer, the card's last 4 digits, the statement period and the previous balance from the statement into the yellow cells.
- Enter each transaction: the date, the description, and the amount under Charges or Payments and credits as a positive number.
- Type the new balance printed on the statement. The Check line reads Ties out when every transaction is there, or Off by the difference.
- Need more than 300 rows? Insert rows above the last transaction row so the totals and Balance owed formulas stretch with them.
- One sheet per statement keeps the months apart: right-click the Blank template tab, Move or Copy, tick Create a copy. Each month's previous balance is the last month's new balance.
The template is for organising transactions you already have, not for making a statement. To compare a card statement with your books, finding reconciliation discrepancies covers the same checks for any account.
5. When the check doesn't tie out
The sample shows what each common mistake does to the new balance:
| Mistake | New balance you'd get | Clue |
|---|---|---|
| None | 3,243.88 | Ties out |
| Interest charge left out | 3,222.52 | Off by exactly the interest line (21.36); it usually prints apart from purchases |
| The 42.18 return typed as a charge | 3,328.24 | Off by twice one amount (84.36): a row in the wrong column |
| The 1,500.00 payment typed as a charge | 6,243.88 | Off by 3,000.00, twice the payment |
| Charges and payments columns swapped | 2,448.36 | Balance owed falls as you spend |
Off by an amount that matches one row? That row is missing or entered twice. Off by twice a row? It's in the wrong column. The free bank statement balance checker runs the same test on any pasted list.
6. Getting it into QuickBooks or Xero
QuickBooks Online and Xero import card transactions from CSV or bank files (.QBO, .OFX), not from a statement-style workbook. For a credit card account they expect purchases negative and payments positive, the opposite of how the statement prints them. Two ways to get there:
- Save as CSV yourself: keep one header row and the transaction rows, add an Amount column with
=D19-C19(charges come out negative), and save as CSV with Date, Description, Amount. - Upload the workbook to a converter: Excel to QBO or Excel to IIF reads the first sheet with data, finds the header row under the summary and combines Charges and Payments and credits into one signed amount, with a preview before you download. Pick Credit card as the account type. The blank template is the first sheet, so a filled-in copy uploads as it is. Free up to 100 rows.
Try it with the sample in a test or demo company only, never your real books.
7. The sample in other formats
The same 21 fictional transactions also come as files, all free:
| File | Use it for |
|---|---|
| Statement workbook (.xlsx) | The layout, formulas and a blank template (this page) |
| Statement PDF | How the printed statement looks, explained line by line on sample credit card statement PDF |
| Card export CSV | A raw card download with Transaction Date, Post Date, Type and Amount |
| Clean CSV | Date, Description, signed Amount |
| QuickBooks Online CSV / .QBO | A QuickBooks credit card account in a test company |
| Xero CSV | A Xero credit card account in the Demo Company |
A matching fictional checking statement, with its own Excel template, is on sample bank statement Excel.
8. What the sample is not for
It's for learning the layout, practising formulas and testing software. The bank, card and transactions are made up, and the file says FICTIONAL DATA next to the card and not a real bank next to the issuer. It can't be used as proof of anything. Making up or altering financial records to use as proof is fraud. If someone needs your card statement, download the real one from your card issuer.
Reconciling the card to your books? The credit card reconciliation template uses this same sample card in its worked example: the 3,243.88 new balance against 2,089.17 in the books, both adjusted to 2,130.28.
9. Your own card statement in Excel
Most card issuers let you download recent activity as CSV from the card's website, often under Download or Export, and statements as PDFs for longer. For a month that's only a PDF, upload it to statement to Excel instead of typing it in: credit card statements work too, the preview is free with no sign-up, and it checks the rows against the statement's previous and new balance. Downloading uses 1 credit ($9 for 5, no subscription) or Pro at $19 a month. Converting a credit card statement PDF to Excel covers the details.
Turn your card statement PDF into Excel
PDF statements, downloaded or scanned, get a free preview with the balance check, no sign-up. CSV and Excel exports convert to QuickBooks, Xero and Quicken files free up to 100 rows. Files are processed in memory and not stored.
FAQ
Is there a free credit card statement template for Excel?
Yes, on this page, with no sign-up. The .xlsx has a Blank template sheet with a card statement layout (previous balance, payments and credits, purchases, fees and interest, new balance), 300 transaction rows and the formulas already in place: enter the previous balance and the transactions and it works out the balance owed on every row, the totals and whether the result matches the new balance printed on the statement. It works in Excel, Google Sheets, LibreOffice and Numbers.
What's in the sample credit card statement?
A fictional business card from the made-up Example Community Bank, card ending 7316, September 2026: previous balance 2,846.12, 2 payments and credits totalling 1,542.18, 19 purchases, fees and interest totalling 1,939.94 and a new balance of 3,243.88. It's the same statement as the sample credit card statement PDF, so you can compare the Excel version with the printed one.
How do you calculate the new balance on a credit card statement?
Previous balance plus purchases, fees and interest, minus payments and credits. On the sample that's 2,846.12 + 1,939.94 - 1,542.18 = 3,243.88. In the template it's =ROUND(E10-E11+E12,2), with the previous balance in E10, payments and credits in E11 and charges in E12.
What is the running balance formula for a credit card in Excel?
Start from the previous balance and add each charge and subtract each payment: with the previous balance in E10, charges in C and payments and credits in D from row 19, use =E10+C19-D19 on the first row and =E19+C20-D20 below it, filled down. The template uses =IF(AND(C19="",D19=""),"",ROUND($E$10+SUM(C$19:C19)-SUM(D$19:D19),2)) so empty rows stay blank.
Is this a real credit card statement?
No. The bank, card and transactions are made up, the file says FICTIONAL DATA next to the card and not a real bank next to the issuer, and it can't be used as proof of anything. Making up or altering financial records to use as proof is fraud. It's for learning the layout, practising formulas and testing software.
Can I import a credit card statement from Excel into QuickBooks or Xero?
Not as a statement-style workbook. Both import card transactions from CSV or bank files such as .QBO and .OFX. Keep one header row and the transaction rows, combine the two columns into one signed Amount with charges negative (=D19-C19) and save as CSV, or upload the workbook to an Excel to QBO converter, which finds the header row and combines the columns for you.
Related guides
- Free sample credit card statement PDF (fictional, with known totals)
- Free credit card reconciliation template for Excel (with a worked example)
- Free sample bank statement in Excel (with a blank template)
- How to convert a credit card statement PDF to Excel
- Free sample bank statement files: PDF, CSV, QBO, IIF, QIF and Xero CSV
- How to find a bank reconciliation discrepancy: 7 causes and a 15-minute method
Related tools
- Bank reconciliation checker: compare a bank statement to your books and list missing, duplicate and mismatched transactions.
- Receipt to CSV: turn PDF or photo receipts and invoices into CSV, Excel, or QuickBooks and Xero bill imports.
