Blog

How to Import a Bank Statement PDF into FreeAgent

FreeAgent uploads a bank statement as CSV, OFX or QIF, not PDF. Turn the PDF into the exact CSV FreeAgent reads, upload it, and check it.

FreeAgent gets bank transactions from a bank feed, or from a statement file you upload: OFX, QIF or CSV. A PDF is not one of them, so a statement you only have as a PDF has to become a CSV first, in the exact shape FreeAgent reads.

What FreeAgent needs in the file

FreeAgent's CSV is stricter than most:

  • Three columns, in this order: the date, the amount, the description.
  • No header row. The first line is the first transaction.
  • Dates as dd/mm/yyyy, with the year.
  • One amount column, money in positive and money out with a minus sign.
  • No commas and no quote marks in the amounts or the descriptions, and each description on one line.

So the file looks like this, with no header:

03/06/2024,1850.00,FPI A CUSTOMER LTD INVOICE 114
04/06/2024,-41.20,DD WATER COMPANY
05/06/2024,-23.49,CARD PAYMENT STATIONERY SHOP

The rows above are an example, not a real statement.

A statement's own layout is a long way from that: separate money in and money out columns, a balance, thousands separators, and descriptions full of commas.

Turn the PDF into FreeAgent's file

With BankPDFtoXLS, you do not build this file by hand. We write it for you, from the statement's own dates and amounts.

  1. Create an account, with no card, and upload the PDF. The free trial converts 15 pages, so you can check the columns first.
  2. Take a Standard or Plus plan and convert the whole statement. The free trial gives this file too; Lite gives Excel and CSV only.
  3. In your list of statements, select FreeAgent beside the other downloads.

We take each date's year from the statement itself, and leave out lines that are not transactions, such as "Balance brought forward". We turn any comma in a description into a space and drop quote marks, because FreeAgent refuses both.

If we cannot settle a date, for example on a scan where a month did not read clearly, we make no FreeAgent file for that statement rather than one with a wrong date. Your Excel download still has every row.

If a statement holds several accounts, such as an account and its savings pots, you get one file for each account.

Upload it to FreeAgent

  1. In FreeAgent, go to Banking > Bank Accounts.
  2. Choose the bank account the statement belongs to.
  3. Select Upload Statement, choose the file, and upload it.

You can also choose Upload a Statement from the Quick Links on the Overview screen, and FreeAgent asks which bank account it is for.

The transactions then wait to be explained, as any others do. FreeAgent can guess explanations from what your account already knows; if you would rather explain them all yourself, untick the option to guess before you upload.

Check it before you explain it

  • Compare the balance. After the upload, the bank account's balance in FreeAgent should match the closing balance on the PDF.
  • Do not upload a period twice. If the account also has a bank feed, upload only the dates the feed does not cover.
  • Check any flagged rows. We check every balance against the row before it. If a row does not follow, your list of statements says so. Open the Excel download, filter the Ledger column for break, and compare those rows with the PDF before you upload. Why a balance breaks explains what to look for.

Convert your own statement.

We read every row, check every balance, and give you a file for your spreadsheet or your books.

Start your free trial

15 pages free, up to 5 for each statement. No card.

See plans and prices