Workflow Guide

FreeAgent PDF Import for Accounting

FreeAgent doesn't accept PDF bank statements or invoices directly — it needs CSV. Convert your PDFs into a FreeAgent-ready spreadsheet in minutes, then upload as usual.

FreeAgent is built around CSV, OFX, or QIF imports for bank transactions, and its invoice tools work best when data is already structured — but most banks and clients only hand you a PDF. This workflow uses AI-powered extraction to turn bank statement PDFs, scanned receipts, and invoice PDFs into clean CSV or Excel files with columns matched to what FreeAgent's import screens expect, so you can upload rather than manually re-key every line.

Who This Is For

  • UK sole traders and freelancers who use FreeAgent for self-assessment and VAT
  • Bookkeepers managing several FreeAgent client accounts with paper or PDF-only statements
  • Contractors receiving PDF invoices from suppliers that need entering as bills
  • Small agencies digitizing a backlog of PDF receipts before a FreeAgent expense catch-up

When This Is Relevant

  • Your bank only lets you download statements as PDF, not CSV, for older date ranges
  • You're switching to FreeAgent mid-year and need to backfill several months of transactions
  • A client sends invoices as PDF attachments and you need them logged as FreeAgent bills
  • You have a shoebox or photo folder of receipts to enter before a Making Tax Digital deadline

Supported Inputs

  • Digital PDF bank statements (Barclays, HSBC, NatWest, Monzo, Starling, etc.)
  • Scanned or photographed paper statements and receipts
  • PDF invoices and purchase orders from suppliers or clients
  • PNG and JPEG photos of receipts taken on a phone

Expected Outputs

  • CSV file with Date, Description, and Amount columns ready for FreeAgent's bank statement upload
  • Excel spreadsheet with one row per invoice or receipt, including invoice number, vendor, amount, and date fields

Common Challenges

  • FreeAgent's bank import screen expects CSV (or OFX/QIF) — it has no native 'upload PDF statement' option, so PDFs must be converted first
  • Bank statement PDFs often export dates in US-style MM/DD/YYYY, but FreeAgent's UK-based import expects DD/MM/YYYY, causing dates to land on the wrong day if not corrected
  • Statements with combined 'money in' and 'money out' columns need to be reconciled into a single signed Amount column before FreeAgent will accept them
  • Multi-currency statements (common for freelancers with overseas clients) aren't handled by FreeAgent's standard single-currency CSV import and need splitting by currency first

How It Works

  1. Upload your bank statement PDF, invoice PDF, or receipt photos to pdfexcel.ai — batch upload works if you have several months or several invoices at once
  2. Select the fields you need extracted: for statements that's Date, Description, and Amount; for invoices it's invoice number, vendor name, date, and total
  3. Export the result as CSV, checking that dates are formatted DD/MM/YYYY to match FreeAgent's expected format before upload
  4. In FreeAgent, go to Banking → select the account → Upload a Statement, choose the CSV, and map the columns; for invoices, use Bills → Add a Bill and attach the source PDF alongside the extracted totals for your records

Why PDFexcel.ai

  • Handles both scanned and digital PDFs, which matters because older bank statements are often flat scans with no embedded text layer
  • Custom field selection lets you pull exactly the columns FreeAgent's importer wants, rather than exporting an entire raw table you then have to reshape
  • Batch processing means a year of monthly statement PDFs, or a folder of supplier invoices, can be converted in one pass instead of one file at a time
  • Files are encrypted during processing and deleted afterward, which matters when statements contain full account numbers and personal financial detail

Limitations

  • Accuracy depends on document quality — a photographed receipt with glare or a skewed scan can produce a misread amount, so it's worth spot-checking totals before import
  • Very long bank statements with nested subtotal rows or multi-line transaction descriptions may need a manual review pass before the CSV is import-clean
  • This tool produces the CSV or Excel file, not a one-click FreeAgent plugin — you still map columns and confirm the upload inside FreeAgent's own interface
  • Handwritten notes on receipts (e.g., a scribbled category or tip amount) are not reliably captured compared to printed text

Example Use Cases

  • A UK freelance designer converts six months of Barclays PDF statements into one CSV for a first-time FreeAgent bank import
  • A bookkeeper handling four FreeAgent clients batch-converts each client's monthly statement PDFs before the end-of-month reconciliation
  • A contractor converts a folder of supplier PDF invoices into a spreadsheet to speed up entering quarterly VAT-relevant bills
  • A sole trader photographs three months of paper till receipts and extracts vendor, date, and amount ahead of a Making Tax Digital submission

Frequently Asked Questions

Can FreeAgent import PDF bank statements directly?

No — FreeAgent's Banking upload accepts CSV, OFX, or QIF files, not PDF. If your bank only offers PDF downloads for a given date range, you need to convert the PDF to CSV first, matching FreeAgent's expected Date, Description, and Amount columns.

What date format does FreeAgent expect in CSV imports?

FreeAgent, being UK-based software, expects dates in DD/MM/YYYY format. A common failure mode is exporting from a US bank template that outputs MM/DD/YYYY, which silently swaps day and month for dates below the 13th — check this before uploading.

Can I convert PDF invoices for FreeAgent bills, not just bank statements?

Yes. You can extract vendor name, invoice number, date, and total from PDF invoices into a spreadsheet, then use those values to create bills in FreeAgent manually or as a reference sheet while entering them, attaching the original PDF for your records.

How does this handle a folder of photographed receipts for expenses?

The tool runs OCR on JPEG or PNG receipt photos and extracts fields like vendor, date, and amount into one row per receipt. Accuracy is strong on clear, well-lit photos of printed receipts, but crumpled or faded till receipts may need manual correction.

Ready to extract data from your PDFs?

Upload your first document and see structured results in seconds. Free to start — no setup required.

Get Started Free

Related Resources