How to Import Credit Card Statements Into FreshBooks (2026)

FreshBooks makes expense tracking straightforward for freelancers and small business owners — until you need to import credit card statement data. Credit card companies deliver statements as PDFs, and FreshBooks cannot read PDFs. You need to convert the statement to CSV format first, then import it through FreshBooks' expense import feature.

The entire process from PDF statement to categorized FreshBooks expenses takes about 2 minutes per statement. This guide covers every step. If you're new to converting credit card statements, our credit card statement to Excel guide covers the basics before you dive into the FreshBooks-specific workflow.

Can FreshBooks Import Credit Card PDFs Directly?

No. FreshBooks does not accept credit card statement PDFs for expense import. FreshBooks supports CSV file uploads for bulk expense imports, along with bank connections for automatic transaction feeds. Since credit card companies issue statements as PDF files, you need a middle step: convert the PDF to CSV, then import that CSV into FreshBooks.

FreshBooks does offer automatic bank connections for many financial institutions, which pull new transactions in real time. But bank connections don't help with historical PDF statements — whether you're catching up on past months, switching from another accounting tool, or importing data for a cancelled card. For those scenarios, the PDF-to-CSV import method is the way to go.

FreshBooks accepts for expense import:

• CSV (comma-separated values) via the expense import tool

FreshBooks does not accept:

• PDF files
• Excel (.xlsx or .xls) files
• OFX, QIF, or QBO files (for expense import — bank connections handle these formats separately)
• Images or scans (though FreshBooks can capture receipt photos for individual expenses)

What CSV Format Does FreshBooks Need?

FreshBooks' expense import requires a CSV file with four columns: Date, Description, Category, and Amount. These must appear as headers in the first row of your file. The column order matters — FreshBooks expects them in a specific sequence during import and lets you map columns during upload.

Here is the format FreshBooks expects:

Key formatting rules:

• Date, Description, Category, and Amount headers must be in the first row
• Dates must use dashes (-) or slashes (/) as separators — not periods or spaces
• Amounts should be plain numbers without currency symbols (no "$" prefix)
• The file cannot exceed 5 MB or 10,000 rows
• Only one sheet per file — no multi-tab spreadsheets (CSV files are single-sheet by nature, so this is only relevant if you've opened and resaved the file in Excel)
• No blank rows between transactions

How to Import Credit Card Statements Into FreshBooks Step by Step

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

Mapping columns during import

When FreshBooks shows the column mapping screen, you'll see dropdowns for each column. Set them as follows:

If FreshBooks auto-detects the columns correctly — which it usually does when the headers match — you can skip mapping and go straight to confirmation.

FreshBooks Bank Connection vs. CSV Import

FreshBooks offers automatic bank connections that sync transactions from your credit card account in real time. If you have a live bank connection, new charges appear automatically. The CSV import method is for situations where the bank connection can't cover what you need.

When to use CSV import instead of (or alongside) a bank connection:

• Importing months of history before you connected the bank feed
• Filling in gaps from bank connection outages or sync failures
• Importing transactions from a credit card you've since closed
• Taking over bookkeeping for a new client with no FreshBooks history
• Verifying bank feed data against the official PDF statement
• Importing from a card issuer that FreshBooks doesn't support for direct connections

Which Credit Card Statements Work With FreshBooks Import?

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

FreshBooks 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.

Categorizing Expenses After Import

One advantage of the CreditCardToExcel CSV export is that it includes a Category column based on the merchant type. After import, FreshBooks uses this category to pre-sort your expenses. You can review and adjust categories from the Expenses page.

FreshBooks uses its own set of expense categories, which map to common tax-deductible expense types:

For a deeper look at how expense categories map to tax deductions, see our guide on how to categorize credit card expenses for taxes. If you're a freelancer, the freelancer expense tracking guide covers Schedule C categories specifically.

Importing Multiple Months Into FreshBooks

Catching up on several months of credit card statements is common when switching to FreshBooks from another tool or when onboarding a new bookkeeping client. 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 their 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 FreshBooks individually, starting with the oldest month

This multi-month workflow pairs well with our guide on why bookkeepers should stop manual credit card data entry, which covers how batch processing replaces hours of typing with a few minutes of uploads.

Troubleshooting Common FreshBooks Import Errors

"Invalid date format"

FreshBooks accepts dates with dashes or slashes (02/15/2026, 2026-02-15, 15-02-2026). If the import fails on dates, check whether Excel reformatted them when you opened the CSV. The safest approach: import the CSV directly from CreditCardToExcel without opening it in Excel first. If you must edit the file, use a text editor like Notepad instead.

"Amount column contains invalid values"

This happens if the Amount column includes currency symbols ("$42.50" instead of "42.50") or thousands separators ("1,500.00"). CreditCardToExcel outputs clean numeric values, but manually edited files sometimes introduce these formatting issues. Remove all currency symbols and ensure commas are only used as column delimiters, not within numbers.

"File exceeds maximum size"

FreshBooks limits CSV imports to 5 MB and 10,000 rows. A single credit card statement rarely hits either limit, but if you've combined multiple months into one CSV, split the file into separate monthly files and import them individually.

"Duplicate expenses after import"

If the same transactions appear twice — once from a bank feed and once from the CSV import — FreshBooks won't flag them automatically. Sort your Expenses by date and amount to find duplicates. Select and delete the duplicated entries. To avoid this, disconnect the bank feed for the overlapping period before importing, or only import CSV data for periods not covered by the bank feed.

Import succeeded but categories are wrong

FreshBooks maps the Category column from your CSV to its own expense categories during import. If a category in the CSV doesn't match a FreshBooks category exactly, the transaction may be imported as "Uncategorized." You can bulk-edit categories from the Expenses page by selecting multiple transactions and choosing a new category.

Related Guides

• Credit Card Statement to Excel: The Complete Guide
• How to Import Credit Card Statements into QuickBooks
• How to Import Credit Card Statements Into Xero
• How to Import Credit Card Statements Into Wave
• How to Categorize Credit Card Expenses for Taxes
• How Freelancers Should Track Credit Card Expenses
• Why Bookkeepers Should Stop Manual Credit Card Data Entry