Free sample credit card statement PDF (fictional, with known totals)

Need a credit card statement PDF to test a converter, an accounting import or a parser, or just to see how one is laid out? This one is free to download with no sign-up. It's a fictional one-page business card statement with an account summary, 21 transactions and an interest charge, and its numbers tie out to the cent, so you know exactly what a correct import looks like. The same statement is also here as CSV, QuickBooks, Xero, Quicken and OFX files.

1. What's on the sample statement

One US Letter page, as a text PDF (the words can be selected and copied, like a statement downloaded from online banking, not a scan). SAMPLE STATEMENT · FICTIONAL DATA FOR DEMONSTRATION ONLY runs across the top, and the footer says it isn't a real bank, account or person. Under the header and the masked card number (XXXX XXXX XXXX 7316) is the account summary:

The summary is a sum you can check: 2,846.12 − 1,542.18 + 1,918.58 + 0.00 + 21.36 = 3,243.88. Every real card statement works the same way, which is why the new balance is the best check that a conversion didn't miss a row.

2. All 21 transactions

The account activity, exactly as printed on the PDF, in the statement's three sections. On a card statement a plain number is a charge (it adds to what you owe) and a minus sign is a payment or credit. The statement shows one date per row.

Merchant names are there so the descriptions look like a real card feed (store numbers, city and state, SQ * and AMAZON MKTPL* prefixes). The amounts, dates, account and customer are made up; none of these businesses is involved.

3. How to read a credit card statement, using the sample

• Start with the summary, not the rows. Previous balance, plus purchases, fees and interest, minus payments and credits, gives the new balance. If the summary adds up, the statement is complete.
• Signs are from the bank's side. On the statement, a purchase is a positive number because it raises what you owe; the payment is -1,500.00. Bank statements print it the other way round, which is why card statements trip up tools built for checking accounts.
• Returns sit with payments. The 42.18 Office Depot return is in Payments and other credits, not next to the 142.18 purchase it refunds.
• Interest gets its own section. The 21.36 purchase interest is dated on the closing day, September 30, and has its own total line under the activity.
• Paying the new balance vs the minimum. Paying the full 3,243.88 by the due date usually avoids interest on new purchases. Paying only the 64.88 minimum keeps the account current, but interest keeps being charged on the rest.
• Dates have no year. Rows say 09/05, not 09/05/2026; the year comes from the statement period at the top. A statement that runs from December into January needs that year rule, and it's a common converter bug.

4. What a real card statement adds

The sample is kept to one page so the structure is easy to see. A US consumer credit card statement must also show, under Regulation Z (12 CFR 1026.7(b), checked Oct 31, 2026):

• each Annual Percentage Rate that could apply (purchases, cash advances, balance transfers) and the Balance Subject to Interest Rate;
• interest and fees grouped under Interest Charged and Fees, with totals for the period and for the year to date;
• next to the due date, the late payment fee and penalty APR that a late payment could trigger;
• a Minimum Payment Warning with how long, and how much, paying only the minimum would take, and in many cases the monthly payment that clears the balance in 3 years;
• an address for billing-error notices.

Business cards like this sample's aren't always held to the same rules, and real statements usually add rewards summaries, an authorized-user section, a payment coupon and several pages. For a classroom handout with an APR box and a minimum-payment layout, the CFPB publishes a sample credit card statement too; it has no transaction rows and its dates are masked, so it's for reading practice rather than testing software.

5. The same statement as import files

These are what Utilly's converter writes from the PDF: the same 21 transactions in each file. In every import file except the Wave CSV, purchases and interest are negative and payments and credits are positive, the opposite of the statement, because that's how QuickBooks and Xero record spending on a credit card account.

Want a raw card export rather than a converted file? sample-credit-card-transactions.csv has Transaction Date, Post Date and Type columns, the way card sites export activity. Want it as a spreadsheet with formulas, or a blank layout for your own card? The credit card statement Excel template has this statement filled in and a blank copy. A matching fictional checking statement is explained the same way on sample bank statement PDF, and its files are on sample bank statement files.

Ready to convert your own card statement? Credit card statement PDF to Excel or to CSV works the same way as the sample: upload the PDF, check it ties to the New Balance, download the spreadsheet.

6. Testing a converter or import with it

A sample is only useful if you know the right answer. After converting or importing, compare four numbers:

With the CSV open in Excel or Google Sheets, =2846.12-SUM(C2:C22) returns 3,243.88. It's a minus because the file records purchases as negative. The free bank statement balance checker runs the same test on any pasted list. In QuickBooks or Xero, import into a demo or test company only, never into real books; where to test safely covers the Xero Demo Company and QuickBooks sample files.

Practising a card reconciliation? The credit card reconciliation template reconciles this same card's 3,243.88 new balance to a set of fictional books, item by item.

7. What the sample is not for

It's for learning the layout and testing software. It isn't a template for a statement that looks real, and it can't be used as proof of address, income, funds or a payment: the bank, card, customer and transactions don't exist, and the watermark says so. Altering or making up a statement to use as proof is fraud. If someone asks you for a card statement, download your real one from your card issuer.

8. Converting your own card statement

When the sample converts the way you need, your own PDF works the same way. Upload a card statement on statement to Excel, QuickBooks or Xero: the preview is free with no sign-up and shows whether the rows add up to the new balance. Your first 3 full statements are free with your email; after that, downloading uses 1 credit ($9 for 5, no subscription) or Pro at $19 a month. Card issuers with their own pages: American Express, Chase, Capital One, Citi and Discover. For the manual route, see how to convert a credit card statement PDF to Excel.

FAQ

Related guides

• How to import credit card transactions into QuickBooks Online and Desktop (CSV, Excel or PDF)
• Free sample bank statement PDF (fictional, with known totals)
• Free credit card reconciliation template for Excel (with a worked example)
• Free sample bank statement files: PDF, CSV, QBO, IIF, QIF and Xero CSV
• How to convert a credit card statement PDF to Excel
• QBO vs IIF vs QIF: which file QuickBooks and Quicken actually need

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.