How to Import Bank Statements into FreeAgent from a PDF
FreeAgent bank feeds cover most UK banks, but not every account and not every month. A feed starts late, a bank is unsupported, or a client hands you a PDF instead of a login. In those cases you import the statement yourself. This guide shows how to import bank statements into FreeAgent from a PDF: convert the file with a bank statement converter, reshape it to FreeAgent's three-column CSV, upload it, and explain the transactions.
When you need to import bank statements into FreeAgent by hand
Use a manual import when the feed cannot give you the lines. Common cases are history from before the feed started, a closed account, a bank with no FreeAgent feed, or a gap left when a feed stopped syncing. FreeAgent itself frames manual upload for exactly those gaps, alongside its bank feeds.
Do not import a whole period blindly. First check the latest transaction already in FreeAgent for that account. Your statement should start the day after that transaction, or the same lines will come in twice and you will have to undo the upload.
- Write down the missing date range for the one bank account.
- Keep each bank and card account in a separate file.
- Keep the original PDF beside the converted file, so any row can be traced back.
- If you are VAT-registered, import one historic VAT period at a time rather than a whole year at once.
FreeAgent's CSV rules in one table
FreeAgent accepts OFX and QIF files as they come, but a CSV must follow a strict shape. There are only three columns, in a fixed order, and the file must use a comma as the delimiter and end in .csv. You also need level 6 access or above in the FreeAgent account to upload a statement.
| FreeAgent column | Format | What to put there |
|---|---|---|
| Date | dd/mm/yyyy | Transaction date, day first, for example 14/03/2026 |
| Amount | Number, 2 decimal places | One signed column: money in positive, money out negative |
| Description | Text | Invoice reference or a brief description of the transaction |
That is the whole file. No balance column, no account number, no header row with extra fields. Anything beyond those three columns has to be removed before you upload.
Step 1: Convert the PDF to a file FreeAgent can read
FreeAgent cannot read a PDF statement directly, so convert the PDF first. Drop it into the bank statement converter and review every row against the PDF page. Check the balance result before you download: opening balance plus money in, minus money out, should equal the closing balance.
That balance check matters more for FreeAgent than for a spreadsheet. A spreadsheet error stays visible. A wrong statement line in FreeAgent gets explained, categorised, and can end up on a VAT return before anyone notices. Our guide on how to check a bank statement conversion explains the test in detail.
Download CSV for the simplest FreeAgent route, or OFX if you will import the same account every month. Our comparison of OFX, QBO and QIF formats explains the trade-offs: FreeAgent accepts OFX and QIF directly, but QBO is the QuickBooks variant and is not the file to send to FreeAgent.
Step 2: Reshape the CSV to FreeAgent's three columns
A normal statement conversion gives you separate money-in and money-out columns, plus a running balance. FreeAgent wants them combined into one signed Amount column: a 1,200 deposit becomes 1200.00, and a 45 fee becomes -45.00. If you upload two columns and map only one, half the statement will be missing or have the wrong sign.
| Converted file | FreeAgent CSV | Notes |
|---|---|---|
| Date column | Date (dd/mm/yyyy) | Convert to day-first format; 03/04/2026 must mean 3 April, not 4 March |
| Money in + money out | Amount (signed) | Money in positive, money out negative, two decimal places |
| Description / narrative | Description | Keep the bank narrative; add an invoice reference where you have one |
| Running balance | Remove | FreeAgent ignores balance on import, and the column breaks the three-column shape |
| Summary and header rows | Remove | Opening balance, totals and fee notes are not transactions |
- Remove currency symbols, commas inside numbers and blank rows.
- Use one date format throughout, and confirm it is day-first before you save.
- Keep one transaction per row, even when the PDF wrapped its description over two lines.
- Save the file with a .csv extension, not .xls or .xlsx, and keep the comma delimiter.
Step 3: Import bank statements into FreeAgent, step by step
- In FreeAgent, open the Banking tab at the top of the screen and choose Bank Accounts.
- Find the account you want and select Upload Statement. You can also use Upload a Statement from the Quick Links menu on the Overview screen.
- Choose Select a file and pick the CSV you prepared. If the statement overlaps transactions already in FreeAgent, narrow the file to the missing dates first.
- Check the preview. Confirm the dates read day-first and that money out shows as negative.
- Select Upload Statement to complete the process. The lines land as unexplained bank transactions — they are not categorised yet.
If FreeAgent rejects the file, check the format before trying again: the three-column shape, the comma delimiter, the .csv extension, and your access level. A file saved from a spreadsheet as semicolon-separated or as .xlsx is the most common cause.
After the upload: explain every transaction
Importing and explaining are two separate jobs, and keeping them separate is what lets you review the file before it touches the books. Each imported line needs an explanation: match it to an invoice or bill, categorise it, or mark it as a transfer. FreeAgent's Guess feature suggests categories from the description, but check each suggestion — a guess is not a decision.
Work through the oldest transactions first, and reconcile the account as you go. If the FreeAgent balance for the month does not match the PDF closing balance, the file was wrong before FreeAgent saw it. Go back to the conversion check rather than fixing lines one by one in FreeAgent.
Duplicates, date errors and other import problems
| Problem | Likely cause | What to do |
|---|---|---|
| Dates are a month and day swapped | File uses MM/DD/YYYY but FreeAgent read DD/MM/YYYY, or the reverse | Delete the upload, fix the date format to dd/mm/yyyy, and re-import |
| Money out shows as money in | Separate in/out columns were uploaded as one unsigned Amount | Combine them into a signed Amount column and re-import |
| The same lines appear twice | The period overlaps a bank feed or a previous import | Undo the upload, then narrow the next file to start the day after the last existing transaction |
| Upload is rejected | Wrong delimiter, .xlsx extension, or extra columns | Save as comma-delimited .csv with exactly three columns |
| A row imports as 0.00 | A summary or fee note was converted as a transaction | Remove zero rows before import; they are not statement lines |
FreeAgent lets you undo a bank statement upload from the same Banking area. Use that rather than deleting transactions one at a time — it is faster and it leaves no stray lines behind.
FreeAgent, Xero or QuickBooks? The file choice is different
If you also work in Xero or QuickBooks, do not reuse the same export without thinking. Xero wants a signed Amount column too, but its date rules and optional fields differ, and QuickBooks Online has its own CSV mapping while QuickBooks Desktop uses QBO. Our guides to importing bank statements into Xero and importing bank statements into QuickBooks cover those sides, so you can keep one clean conversion and export the right file for each system.
Whichever system you use, the workflow is the same at its core: get a clean, balance-checked file from the bank statement converter, reshape only what the target system requires, import a defined date range, and review before you explain or reconcile. That habit turns a messy historical cleanup — a shoebox of PDFs from a new client — into a set of monthly imports you can prove, one statement at a time.
Sources and further reading
- Format a CSV file to upload a bank statement — FreeAgent Support
- Upload bank transactions from a bank statement — FreeAgent Support
Put it into practice
Convert a statement now and watch the balance check run on your own file. The first 10 pages each month are free, and exports are never cut short.
More guides
How to Convert a Bank Statement PDF to CSV · How to Convert a Bank Statement PDF to Excel · How to Import Bank Statements into QuickBooks (QBO Files) · OFX vs. QBO vs. QIF: Which Format Should You Download? · Why a Converted Bank Statement Does Not Balance — and How to Fix It · How to Check a Converted Bank Statement Is Correct · Scanned vs. Digital Bank Statements: Why One Converts and the Other Does Not · How to Convert a Password-Protected Bank Statement PDF · How to Convert Many Bank Statements at Once (and Merge Them Cleanly) · Is It Safe to Convert Bank Statements Online? A Privacy Checklist · How to Import Bank Statements into Xero · How to Reconcile a Bank Statement in Excel After Converting PDF to CSV · How to Import Bank Statements into Sage from a PDF