Upload a PDF bank statement and get a clean CSV with the date, description, and amount in their own columns, dates in MM/DD/YYYY and debits as negatives, formatted to import under FreshBooks Bank Reconciliation. No retyping, no fighting the column rules.
Upload your bank statement
Drop file here or click to upload
PDF, JPG, PNG, BMP, HEIC, TIFF, MT940
Uploading...
FreshBooks imports transactions from a CSV file, never from a PDF. Its own help center states that if your bank only allows transactions to be downloaded in other file formats such as PDFs, you have to convert the PDF into a CSV first. Convert the statement here, then pick your path: Bank Reconciliation needs Date plus an Amount column (or an Amount Spent and Amount Earned pair), while the Expenses importer needs Amount, Category, Date, Description and Merchant. Keep each file to 500 transactions or fewer, which is the FreshBooks per-file limit.
FreshBooks import rules re-checked against the FreshBooks help center on 4 September 2026.
FreshBooks pulls transactions automatically when your bank connects through its bank feed, but plenty of accounts never connect: smaller banks, older periods, closed accounts, and statements a client emails you as a PDF. For those, FreshBooks lets you upload a CSV under Bank Reconciliation, and the file has to follow its rules. It needs a Date column plus either a single Amount column or an Amount Spent and Amount Earned pair, headers in the first row, one date format used consistently across every row, rows in chronological order, plain numbers with no currency symbols or thousands commas, and no more than 500 transactions. Get one of those wrong and the import fails or posts the wrong dates. This converter reads the statement PDF and builds the CSV in that shape, so the upload matches on the first try.
Date, description, and amount land in their own columns with a header row, the layout the Bank Reconciliation upload expects, so nothing imports as a single jumbled field.
FreshBooks lets you pick the date order in the import screen, but every row in the file has to use the same one. The converter writes every date in US MM/DD/YYYY order, in statement order, so the import does not silently shift days and months.
Money out is written as a negative number and money in as positive, with no dollar signs or thousands commas, so the amounts post with the right sign and FreshBooks can match them.
Four steps, no software to install.
Download the statement PDF from your bank, or use the file a client sent you. It works for checking, savings, and credit card statements from any US bank.
Drop the PDF into the converter at the top of this page. Password-protected files are detected the moment you upload them.
The statement is read into rows. Check the date, description, and amount columns in the preview before you export to CSV.
In FreshBooks, open Accounting, Bank Reconciliation, pick the account, and upload the CSV. FreshBooks matches the lines so you can reconcile.
Want the full walk-through with the FreshBooks screens? See the step-by-step guide on how to import a bank statement into FreshBooks, which covers the column headers, the date format, and the reconciliation step in detail.
FreshBooks is built for service businesses. When your bank will not connect, convert each month's statement and upload it, so reconciliation stays current without manual entry.
Turn a stack of bank and card PDFs into FreshBooks-ready CSVs, so your books reconcile each month even on accounts the bank feed does not cover.
Clients often send only the statement PDF. Convert it into a CSV that matches the Bank Reconciliation rules and post the activity without retyping a thing.
Backload past statements when you move to FreshBooks, turning old PDFs into clean CSVs so the opening history is complete and the account reconciles.
A bank statement PDF carries opening and closing balances, deposits, withdrawals, checks, card activity, fees, and interest, often across several pages. FreshBooks needs that as a CSV with a header row and the right formatting, and it caps each file at 500 transactions. The converter produces that shape, so the import maps cleanly and you can split a long statement into files that stay under the limit.
Export to CSV for the FreshBooks upload or to Excel (.xlsx) to review first. The same file works in other systems too. If you also bring vendor bills into your books, you can pull line items off those documents with an invoice data extractor, and turn any other report PDF into a spreadsheet with a PDF to Excel converter.
This is the decision that trips people up, because FreshBooks has two separate importers that create different records and want different columns. Picking the wrong one is how deposits quietly vanish or a reconciliation refuses to balance.
| Import path | What it creates | Use it when |
|---|---|---|
| Accounting, then Upload CSV | Unreconciled bank transactions you then match against existing entries. | You are reconciling an account and need money in as well as money out. |
| Expenses, then Import Expenses from a File | New expense records in the Expenses list, categorized on the way in. | You only need spending loaded and you are not reconciling. |
One thing to check before you choose: FreshBooks makes accounting features including Bank Reconciliation available on trials and on the Plus, Premium and Select plans. On a plan without it, the expense importer is the path open to you.
Each importer has its own required headers. Bank reconciliation is the more forgiving of the two, because it accepts either a single signed amount column or a debit and credit pair.
| Column | Bank Reconciliation import | Expense import |
|---|---|---|
| Date | Required. One format for the whole file, rows in chronological order. | Required. One format for the whole file. |
| Amount | Required as one column: positive for money in, negative for money out. | Required. Only negative values are imported. |
| Amount Spent and Amount Earned | Alternative to the single Amount column. Positive numbers only in both. | Not used. |
| Description | Optional, but it is what you match on. | Required. |
| Category | Optional. Operating Expense parent categories only. | Required. Parent categories or subcategories. |
| Merchant | Not used. | Required. |
A category you invent does not create itself. FreshBooks files anything under an unrecognized category into Uncategorized Expenses, so it is faster to map to a real Operating Expense category in the spreadsheet than to fix it in the app afterwards. And nothing here deduplicates: FreshBooks imports every row you give it, duplicates and internal transfers included, so overlapping statement periods need a cleanup pass first. Our page on categorizing transactions from a bank statement covers building that category column, and catch-up bookkeeping from bank statements covers sequencing a long backlog into files that stay under the 500 row ceiling.
No. FreshBooks does not read PDF statements. It pulls transactions through a connected bank feed, or it imports a CSV under Bank Reconciliation. A PDF has to be converted to a CSV first. This converter reads the statement PDF and outputs the file with a Date, Description, and Amount column, one consistent date format, and money out as negative amounts, which is the shape the FreshBooks upload expects.
Convert the statement PDF to a CSV here, then in FreshBooks open Accounting and Bank Reconciliation, choose the account, and upload the CSV. FreshBooks reads the rows and matches them against your records so you can reconcile. Keep the headers in the first row, use one date format for every row and put the rows in chronological order, and split long statements so each file stays at 500 transactions or fewer.
For Bank Reconciliation, FreshBooks requires a Date column plus either a single Amount column or an Amount Spent and Amount Earned pair, with Description and Category optional. In the one column layout, positive is money in and negative is money out. Every row needs the same date format, the rows have to be in chronological order, and no file may carry more than 500 transactions. The converter writes that shape for you.
Bank feeds cover many institutions but not all of them, and connections drop for smaller banks, business accounts, closed accounts, and older statements you need to backload. When the feed is unavailable, the supported path is to upload a CSV under Bank Reconciliation. Converting the PDF statement to a properly formatted CSV lets you import that activity without waiting on a connection.
Yes. FreshBooks caps each CSV upload at 500 transactions, so a busy account or a long date range can exceed one file. Because the converter produces a clean spreadsheet, it is simple to split a long statement into batches that stay under the limit and upload each one in turn, so every line lands in FreshBooks without a failed import.
Yes. The converter includes optical character recognition, so it reads scanned statements and image-only PDFs, not just digital ones. That matters for older periods and for files a client photographed or saved from a teller. The text is pulled into the same Date, Description, and Amount columns, so the CSV imports into FreshBooks the same way a digital statement would.
The most likely cause is the sign convention. The FreshBooks expense importer only brings in negative amounts, so if your file mixes positive deposits with negative spending, only the negatives arrive. In Bank Reconciliation, the other common cause is that the rows fall before the Opening Balance Start Date on that account, which hides them from matching until you move the start date back.
No. FreshBooks imports every row in the file, including duplicates and transfers used to pay off a balance. Check the spreadsheet before importing, especially where two statement periods overlap by a few days. Sorting by date and amount and deleting the repeated rows takes a minute and saves untangling a reconciliation later.
FreshBooks makes accounting features including Bank Reconciliation available on trials and on the Plus, Premium and Select plans. On a plan without it, use the expense importer instead, which loads spending into the Expenses list but does not give you the reconciliation workflow or a place to record deposits.
Up to fifteen minutes for a bank reconciliation import, and you have to stay logged in to FreshBooks for the whole run or the import is interrupted. That is another reason to split a long period into several files of 500 transactions or fewer rather than pushing one oversized upload and hoping it completes.
Files are encrypted in transit and at rest while they are processed, and the conversion runs without sharing your data with third parties. You never enter your bank login or FreshBooks credentials, because the converter works straight from the PDF you already downloaded. You stay in control of the file and the CSV export from upload to download.
The full step-by-step guide with the FreshBooks screens.
Convert statements for a Wave import too.
A CSV import path for Sage accounting.
The general converter for any CSV import target.
Statement data prepared for solo and small business books.
How to choose a converter for accounting work.
Need to pull in statements from a checking or savings account too? The bank statement converter reads any US bank format from one upload, and the PDF bank statement to Excel converter returns a clean XLSX with the same date, description, and amount columns.
Cancel anytime from your account settings · refund policy
Get started converting bank statements to spreadsheets.
USD
per month
per month
$288 charged today
Choose speed vs accuracy when extracting
| Base AI Faster | 2,500 pages |
| Pro AI Best accuracy | 500 pages |
Scale statement conversion across your team with automation.
USD
per month
per month
$888 charged today
Choose speed vs accuracy when extracting
| Base AI Faster | 10,000 pages |
| Pro AI Best accuracy | 2,000 pages |
Enterprise-grade bank statement conversion and controls.
USD
per month
per month
$ charged today
Choose speed vs accuracy when extracting
| Base AI Faster | pages |
| Pro AI Best accuracy | pages |
Try it once, free: sign up and convert up to 15 pages (5 per statement) with no credit card. The demo does not renew.
