Guide

How to Import Credit Card Statements Into Wave (2026)

15 min read
|By CreditCardToExcel Team

Wave is one of the best free accounting tools for freelancers and small businesses — but it can't read credit card statement PDFs. Credit card companies deliver statements as PDFs, and Wave's transaction import only accepts CSV, OFX, or QBO files. You need a conversion step: turn the PDF into a CSV, then upload it through Wave's statement import.

The whole process from PDF statement to categorized Wave transactions takes about 2 minutes. This guide walks through every step. If you're new to converting credit card statements, our credit card statement to Excel guide covers the fundamentals.


Can Wave Import Credit Card PDFs Directly?

No. Wave does not accept PDF files for transaction imports. Wave supports CSV, OFX, and QBO file formats for manual statement uploads. Since credit card issuers provide statements as PDFs, you need an intermediate step: convert the PDF to CSV, then upload that CSV into Wave.

Wave does offer automatic bank connections on its paid plan that pull new transactions in real time. But automatic imports don't help when you need to bring in historical PDF statements — whether you're catching up on past months, switching from another accounting tool, importing data from a card you've cancelled, or preparing for tax season. For all those cases, the PDF-to-CSV import method is what you need.

Wave accepts for statement upload:

  • CSV (comma-separated values)
  • OFX (Open Financial Exchange)
  • QBO (Quicken/QuickBooks Online format)

Wave does not accept:

  • PDF files
  • Excel (.xlsx or .xls) files
  • QIF (Quicken Interchange Format)
  • Images or scans

What CSV Format Does Wave Need?

Wave's CSV import is flexible. At minimum, your CSV needs three columns: Date, Description, and Amount. During upload, Wave walks you through a column mapping wizard where you tell it which column contains dates, which contains descriptions, and which contains amounts. It handles both single-column (positive/negative amounts) and double-column (separate debit/credit columns) formats.

Here is the format that works best for Wave:

ColumnFormatExample
DateMM/DD/YYYY, DD/MM/YYYY, or YYYY-MM-DD02/15/2026
DescriptionText (merchant name)Office Depot
AmountNumber (negative = charge, positive = payment)-84.50
CategoryOptional textOffice Supplies

Key formatting rules:

  • The first row should contain column headers
  • Dates must be in a consistent format throughout the file
  • Amounts should be plain numbers without currency symbols (no "$" prefix)
  • Use negative numbers for credit card charges and positive numbers for payments or credits
  • No blank rows between transactions
  • The file must be in UTF-8 encoding (standard CSV)

💡 Pro Tip

CreditCardToExcel's CSV export includes Date, Description, Amount, and Category columns — formatted to match Wave's import requirements. You can upload the CSV directly without any reformatting.

How to Import Credit Card Statements Into Wave Step by Step

The process has three parts: download your statement PDF, convert it to CSV, then upload the CSV into Wave. The first 3 conversions on CreditCardToExcel are free with no signup required.

  1. Download your credit card statement PDF. Log in to your credit card issuer's website and download the statement for the billing period you want to import. Most issuers keep 5-7 years of statements available. If you need help finding your statement, see our issuer-specific guides for Chase, Amex, Capital One, or Discover.

  2. Convert the PDF to CSV. Go to CreditCardToExcel.com and upload your statement PDF. The AI extracts every transaction in about 10-30 seconds. Once the extraction finishes, click "Download CSV." The file will include Date, Description, Amount, and Category columns — ready for Wave.

  3. Open Wave and go to Transactions. In Wave, click Accounting in the left sidebar, then select Transactions. Click the "More" button in the top-right corner and choose "Upload transactions" from the dropdown menu.

  4. Select the credit card account and upload the CSV. Wave asks which account to associate the transactions with. Select your credit card account from the dropdown. If you haven't added a credit card account yet, you'll need to create one first under Accounting > Chart of Accounts. Then click "Choose File" and select the CSV file you downloaded from CreditCardToExcel.

  5. Map the columns. Wave displays a mapping screen where you match your CSV columns to Wave's fields. Set Date to your Date column, Description to your Description column, and Amount to your Amount column. If Wave asks whether your file uses one amount column or separate debit/credit columns, select "one column" — CreditCardToExcel uses a single Amount column with negative values for charges.

  6. Select the date type. Wave asks which date to use for each transaction. For credit card statements, choose the posting date (the date the bank processed the charge). This matches how credit card issuers record transactions on statements.

  7. Review and import. Wave shows a preview of the transactions. Scan through to verify the dates, descriptions, and amounts look correct. Click "Import" to finalize. The transactions appear in your Transactions list under the credit card account.

How to Add a Credit Card in Wave's Chart of Accounts

If this is your first time importing credit card transactions, you need a credit card account in Wave's chart of accounts before you can assign transactions to it.

Steps to add a credit card account:

  1. Go to Accounting > Chart of Accounts
  2. Click "Add a New Account"
  3. Under Account Type, select Credit Card
  4. Name it after your card (e.g., "Chase Sapphire Preferred" or "Amex Business Gold")
  5. Click Save

The account now appears in the dropdown when you upload transactions.

What account type should a credit card be in Wave?

In Wave's chart of accounts, credit cards belong under the Credit Card account type — not "Liability" or "Loan," even though credit cards are technically liabilities. Wave has a dedicated Credit Card account type specifically so that statement uploads, reconciliation, and the Transactions view all work correctly.

If you set the account type to something other than Credit Card, statement imports may not work as expected and the card won't appear in Wave's credit card reconciliation workflows.

Account TypeUse For
Credit CardAll personal and business credit cards
LoanInstallment loans, lines of credit
Long-Term LiabilityMortgages, multi-year obligations

How many credit card accounts should you add?

Add one account per card. If you have a Chase Sapphire and an Amex Blue Business Plus, create two separate Credit Card accounts. This lets you:

  • Import and reconcile each card's statement independently
  • See per-card spending in Wave's reports
  • Track balances accurately when you carry a balance month-to-month

All imported transactions will be associated with the correct account for reporting and reconciliation.


Wave Free Plan vs. Pro Plan for Credit Card Import

Wave's free plan includes full accounting, invoicing, and manual statement uploads. The Pro plan ($16/month) adds automatic bank connections, among other features. For credit card statement imports, here's how the two plans compare:

FeatureFree PlanPro Plan
CSV/OFX/QBO upload
Manual transaction entry
Automatic bank connections
PDF statement import
Receipt scanning

When CSV import (free plan) is all you need:

  • You import statements monthly or quarterly, not daily
  • You have a small number of credit card transactions per month
  • You're catching up on historical statements
  • Your card issuer isn't supported by Wave's bank connections
  • You want to keep costs at zero

When the Pro plan bank connection is worth it:

  • You have multiple cards with high transaction volumes
  • You want daily transaction syncing without manual steps
  • Your card issuer is supported by Wave's connection partners

Either way, PDF statements still need the CSV conversion step. Wave's bank connections import transactions going forward — they don't retroactively import data from PDF statements.

ℹ️ Info

Wave's free plan is genuinely free — not a trial. You can use CSV imports indefinitely without paying. This makes Wave + CreditCardToExcel one of the most affordable bookkeeping setups available: free accounting software plus 3 free conversions per month.

Which Credit Card Statements Work With Wave Import?

Any credit card statement PDF that CreditCardToExcel can convert will produce a CSV compatible with Wave. This includes all major US issuers and most international ones.

IssuerStatement FormatWorks with Wave Import
ChasePDF only
American ExpressPDF + limited CSV
Capital OnePDF + limited CSV (90-day window)
CitiPDF only
DiscoverPDF only (QFX discontinued in 2022)
Bank of AmericaPDF only for credit cards
Wells FargoPDF + limited CSV
US BankPDF + limited CSV

Wave is popular with freelancers and small businesses in the US and Canada. For Canadian credit card statements (TD, RBC, Scotiabank, BMO), the same PDF-to-CSV workflow applies — CreditCardToExcel handles CAD amounts correctly, and Wave supports Canadian dollar accounts natively.


Categorizing Transactions After Import

Wave assigns imported transactions to the account you selected during upload, but individual transactions aren't automatically categorized by expense type. After import, you can categorize each transaction from the Transactions page:

  1. Click on a transaction to open it
  2. Select a category from the dropdown (e.g., Advertising, Meals & Entertainment, Office Supplies)
  3. Add notes or tags if needed
  4. Save

Wave's default expense categories map to common business expense types:

Wave CategoryCommon Credit Card Charges
AdvertisingGoogle Ads, Facebook Ads, promoted posts
Meals & EntertainmentRestaurants, coffee shops, client dinners
Office Supplies & SoftwareStaples, Amazon office purchases, SaaS subscriptions
Professional ServicesLegal fees, accounting, consulting
TravelAirlines, hotels, car rentals, ride shares
UtilitiesPhone bill, internet service
Education & TrainingCourses, conferences, books

For a detailed breakdown of how expense categories map to tax deductions, see our guide on categorizing credit card expenses for taxes. Freelancers tracking Schedule C deductions should also check our freelancer expense tracking guide.

💡 Pro Tip

Wave lets you create custom categories under Accounting > Chart of Accounts. If you regularly import transactions that don't fit the defaults — like "Continuing Education" or "Client Gifts" — create the category first, then use it when categorizing imported transactions.

Importing Multiple Months Into Wave

Catching up on several months of credit card statements is common when setting up Wave for the first time, taking over bookkeeping for a new client, or preparing for tax season. Batch conversion speeds this up significantly.

Efficient multi-month workflow:

  1. Download all statement PDFs from your credit card issuer at once (most issuers let you download multiple months from the Statements page)
  2. Upload them together using CreditCardToExcel's batch processing (available on Pro and Business plans — up to 5 and 20 files per batch, respectively)
  3. Download the resulting CSV files
  4. Import each CSV into Wave individually, selecting the same credit card account each time
  5. Start with the oldest statement and work forward chronologically

💡 Pro Tip

Import statements in chronological order — oldest first — so Wave's transaction history and reports reflect the correct progression over time.

If you're switching from another accounting tool like QuickBooks, Xero, or FreshBooks, this multi-month import approach lets you rebuild your transaction history in Wave. See our related guides for importing into QuickBooks, Xero, or FreshBooks if you're evaluating which platform fits best.


Wave vs. QuickBooks, Xero, and FreshBooks for Credit Card Import

If you're choosing between accounting platforms for credit card statement management, here's how Wave compares:

FeatureWaveQuickBooks OnlineXeroFreshBooks
Starting priceFree$35/mo$15/mo$19/mo
CSV statement upload
PDF statement import
Bank feed connectionsPro plan ($16/mo)All plansAll plansAll plans
Import file formatsCSV, OFX, QBOCSV, QBO, OFXCSV, OFX, QIFCSV only
Transaction categorizationManualAuto-suggestRules-basedManual
Multi-currency supportYes (Plus plan)Yes (Business plan)Yes (Select plan)

Wave's biggest advantage is the price: full accounting with CSV imports at zero cost. The trade-off is fewer automation features — QuickBooks and Xero offer smarter transaction categorization and matching. For a freelancer or sole proprietor processing one or two credit cards, Wave is hard to beat on value.


Troubleshooting Common Wave Import Errors

"Date format not recognized"

Wave accepts dates with slashes or dashes (02/15/2026, 2026-02-15). If the import fails on dates, check whether you opened the CSV in Excel before uploading — Excel can silently reformat dates. Redownload the CSV from CreditCardToExcel and upload directly without opening it in a spreadsheet program.

"Amount column not detected"

This happens when the Amount column includes currency symbols ("$42.50" instead of "42.50") or uses commas as thousands separators ("1,500.00"). CreditCardToExcel outputs clean numeric values, but manually editing the CSV in Excel can introduce these. If needed, open the file in a text editor like Notepad to verify formatting.

"Currency mismatch"

Wave requires that imported transactions match the currency of the account you're importing into. If your credit card account is set to USD and you import a CSV with CAD amounts, the import will either fail or record incorrect amounts. Create a separate credit card account in the correct currency first, then import.

"Duplicate transactions after import"

If you import a CSV covering a period that overlaps with transactions already in Wave (from a previous import or bank feed), Wave may create duplicates. Wave does not automatically deduplicate imports. Check for duplicates by sorting transactions by date and amount, then delete any extras from the Transactions page.

Import succeeded but transactions are in the wrong account

During upload, Wave asks which account to associate transactions with. If you selected the wrong account, delete the imported transactions and re-import them, this time selecting the correct credit card account from the dropdown.


Frequently Asked Questions

No. Wave only accepts CSV, OFX, and QBO files for transaction uploads. Since credit card companies provide statements as PDFs, you need to convert the PDF to CSV first using a tool like CreditCardToExcel, then upload the CSV into Wave through the Transactions page.

Yes. CreditCardToExcel outputs CSV files with Date, Description, Amount, and Category columns. Wave's import wizard lets you map these columns during upload. The format is compatible out of the box — no reformatting needed.

Yes. Wave's free plan includes unlimited accounting, invoicing, and manual statement uploads (CSV, OFX, QBO). You can import as many credit card statements as you want without paying. The Pro plan ($16/month) adds automatic bank connections and receipt scanning, but CSV imports work on the free plan indefinitely.

For ongoing tracking of new transactions, a bank connection (Pro plan, $16/month) is more convenient — transactions import automatically. CSV import is better for historical statements, one-time imports, cancelled cards, or issuers that Wave doesn't support for direct connections. Many users start with CSV imports on the free plan and upgrade to bank connections once they outgrow the manual workflow.

Yes. Create a separate credit card account in Wave for each card (under Accounting > Chart of Accounts). When importing a CSV, select the matching credit card account. This keeps transactions organized by card for reporting and reconciliation. For tips on managing multiple cards, see our guide on managing multiple credit cards in one spreadsheet.

Refunds and credits appear as positive amounts in the CreditCardToExcel CSV export (while charges are negative). When imported into Wave, these show up correctly as credits on the credit card account, reducing the outstanding balance. Wave's reports will reflect the net amount accurately.


Related Guides

Ready to stop manual data entry?

Convert your credit card statements to Excel in seconds. Free, no signup required.

Try CreditCardToExcel Free