Software Integrations

Import Invoices into FreeAgent: What Actually Works

FreeAgent supplier bill import options compared: manual entry, Smart Capture, Dext and AutoEntry, the Practice Partner bill importer, Fabio, and the API.

Published
Updated
Reading time
13 min
Topics:Software IntegrationsFreeAgentUKsupplier invoicesSmart CaptureCSV import

How you import invoices into FreeAgent on the purchase side depends on who is doing the importing. FreeAgent has a native CSV bill importer, but only an accountant or bookkeeper who is a FreeAgent Practice Partner can use it, working inside a client's account. A business running FreeAgent on its own cannot use that importer: its built-in choices are manual bill entry or Smart Capture-assisted entry, and beyond those it turns to a connected capture tool, a CSV-mediated migration route such as Fabio, or the FreeAgent API.

That distinction matters because supplier bills are not the same as sales invoices, and they are not the same as a one-off migration problem. FreeAgent's sales-invoice importer runs on the same Practice Partner terms, but this guide stays with supplier bills. A freelancer entering a handful of monthly bills needs a different answer from a bookkeeper backfilling six months of supplier invoices, or a finance team that wants reviewed data posted from another system.

The question is not whether FreeAgent can receive bill data somehow. It is which route preserves the data you actually need. If your downstream process depends on VAT treatment, supplier coding, approval checks, or usable bill detail, a workflow that only captures a date and total may still leave most of the work with you.

That is why this guide is organised by scenario rather than vendor promotion. The practical routes fall into six buckets: one-off manual entry, low-volume Smart Capture, recurring AP capture through a partner tool, FreeAgent's own bill importer when a Practice Partner keeps your books, historical migration through a CSV-mediated route, and custom workflows built around the FreeAgent API.

Best FreeAgent Bill Import Method by Scenario

If you want the quickest short-list before reading the detail, use the table below. It separates the problem you are solving from the tool category that usually fits it.

OptionBest whenWhat it handles wellMain trade-off
Manual bill entryYou only enter a few supplier bills each monthFull control over coding and review inside FreeAgentSlow, repetitive, no bulk handling
Smart CaptureLow volume, light-touch captureReads the date and amount and suggests a category, plus the due date and contact when a file becomes a billLine items and VAT detail still need completing by hand
Dext / AutoEntry / Datamolino / Receipt BotOngoing AP captureRicher extraction, publishing into FreeAgent, less rekeyingExtra software cost and setup
FreeAgent's bill importer (Practice Partners)An accountant or bookkeeper is bringing a client's bills in bulkLine items, VAT, due dates, currency, projects and CIS bills from a CSV template, up to 1,000 rows per importPractice-only; contacts must exist first; recurring, EC, reverse-charge, stock and hire-purchase bills still go in by hand
Fabio or another CSV-mediated routeHistorical backfill for a business working in FreeAgent on its ownBulk upload workflow where CSV preparation mattersMapping and cleanup work still matters
Extraction-first Excel, CSV, or JSON prepInvoices are messy, mixed-format, or need custom columnsCreates reviewed structured data before manual entry, upload, or postingStill needs a downstream handoff into FreeAgent
FreeAgent APIHigher volume or custom finance workflowsControlled posting from another systemRequires implementation work and process design

The main pattern is that one-off bills, light capture, recurring AP intake, historical migration, and custom integrations are different jobs, and whether a Practice Partner keeps your books changes which routes are open at all. Treating them as one problem is what leads to the wrong tool choice.

If you have seen similar limits in other small-business platforms, how another SMB accounting platform handles limited invoice imports shows the same lesson: choose the workflow based on data depth and operational fit, not on the assumption that every accounting package handles supplier-bill imports the same way.

When Manual Entry or Smart Capture Is Enough

Manual bill entry is still the baseline FreeAgent bill import route. If you only process a small number of supplier invoices each month, entering the bill directly in FreeAgent may be perfectly workable. You keep full control over the supplier, category, VAT treatment, payment timing, and any notes you need for bookkeeping review.

Smart Capture sits on top of that manual flow, but it is important to understand what it does and does not solve. FreeAgent positions it as a faster way to start bill creation, not as full accounts-payable automation. In practical terms, Smart Capture reads the date and amount and suggests a cost category, and when you convert a file into a bill it also attempts the due date and suggests a contact. Line items, VAT breakdowns and fuller supplier detail are still yours to complete. It also includes 10 files per month free, with unlimited Smart Capture costing GBP 5 + VAT per month.

Those limits matter because the bottleneck is rarely just typing in the bill date and total. Once you need line items, richer invoice fields, or faster handling across batches, the workflow quickly stops being a genuine FreeAgent supplier invoice import solution and becomes assisted re-entry instead.

For readers deciding whether to stay native, the break point is straightforward. If your invoice volume is low and you mainly want a nudge on basic bill creation, Smart Capture can be enough. If you need deeper OCR-style capture, how FreeAgent Smart Capture compares with OCR tools is the more useful comparison. If the real pain is field depth or throughput, you are already in partner-tool or workaround territory.

When Dext, AutoEntry, Datamolino, or Receipt Bot Are the Better Fit

Once supplier invoices arrive every day rather than occasionally, connected capture tools become the more realistic option. This is the category to look at when you want recurring AP intake, not just a slightly faster way to open a bill form inside FreeAgent.

Dext, AutoEntry, Datamolino, and Receipt Bot all sit closer to that recurring workflow. The exact depth varies by product, but this group is where you look when you need more than a date and total: richer field extraction, tax handling, line items, supplier matching or coding support, and a more direct handoff into FreeAgent. That is the practical difference between a native aid and an ongoing capture layer.

The useful comparison is not brand-versus-brand at first. It is whether your process needs more structured data and less manual review than Smart Capture can provide. If your team has to check VAT breakdowns, push bills into the right supplier records, or work through repeat formats at pace, these tools usually justify their place faster than another month of rekeying.

They are not the default answer for every FreeAgent user, though. They add cost on top of your accounting subscription, and some teams do not need that extra layer. If the native workflow is still acceptable, keep it. Move into Dext, AutoEntry, Datamolino, or Receipt Bot when recurring supplier-bill volume has become the bottleneck rather than a minor annoyance.

How Historical Invoice Migration Works in FreeAgent

FreeAgent historical invoice migration is a different problem from day-to-day bill capture. When you are backfilling old supplier invoices, the priority is usually getting a clean block of historical data into the system with the right suppliers, dates, values, and VAT treatment, not building the perfect long-term capture workflow.

The first decision is which bills to import at all. FreeAgent imports bills only when they are dated on or after the business's FreeAgent start date. Anything older goes in as part of the opening balances, as opening trade creditor balances against the supplier contacts, rather than as individual bills. Settle the start date before you prepare a file, because it decides how much of the backlog needs to become bills in the first place.

If your books are kept by an accountant or bookkeeper who is a FreeAgent Practice Partner, they can use FreeAgent's own bill importer from inside your account. They start from one of two CSV templates in the Bills area. The simple template covers the contact, reference and bill date, then a category, value and quantity for each line. The complete template adds due dates, currency, VAT-exclusive amounts with a VAT rate or status, projects, descriptions, and CIS bills. Dates go in as DD/MM/YYYY whatever date format the account uses, amounts as plain numbers with no currency symbols or commas, and category, project and property names must match FreeAgent's exactly. A bill with several line items takes one row per line, with the extra lines directly under the bill's first row, and FreeAgent calculates the total. Supplier contacts must already exist, each import takes up to 1,000 rows, and recurring bills, EC goods or services, reverse-charge VAT, stock purchases and hire purchase agreements are still entered by hand. After the upload, the practice can filter bills by 'Last import' and undo the whole batch if something went wrong. FreeAgent's guide to importing a client's bills has the full column reference.

If you run FreeAgent on your own, that importer is not open to you: FreeAgent states that a client can import out-of-pocket expenses and mileage claims but cannot currently import invoices or bills. Its own guide to switching points businesses to third-party integrations such as AutoEntry, Dext, Fabio or Zapier for historical sales invoices and bills. That is where a CSV-mediated route helps. A tool such as Fabio prepares records for bulk upload, so the CSV file becomes the bridge between your source invoices and the records you want to create inside FreeAgent. If the backlog is large and your accountant is a Practice Partner, handing them a prepared file may be the shorter path.

Whichever route you take, validate the migration file as carefully as you would a payroll import. Check that supplier names match existing records, VAT columns map correctly, duplicate bills are removed, and the field layout matches FreeAgent's bill template or whatever the intermediary tool expects. Decide up front whether line-item detail must survive the move or whether invoice-level totals are enough for the historical record you are creating.

This is also the point where comparison with other platforms becomes useful. If you are weighing software behaviour, how Xero's CSV invoice import differs from FreeAgent's workflow shows why the FreeAgent path can feel more indirect. A Practice Partner now has a native upload for bulk importing invoices into FreeAgent; for a business working on its own, the route still runs through a connected tool or a prepared CSV handoff.

When an Extraction-First Workflow or the FreeAgent API Makes More Sense

Some teams do not really have an accounting-software problem. They have an intake problem. Supplier invoices arrive as mixed PDFs, email attachments, phone photos, and inconsistent layouts, so the first job is to turn that mess into reliable structured data. In that situation, it can make more sense to extract supplier invoice data before it reaches FreeAgent, then decide whether the clean output should feed manual bill entry, FreeAgent's bill importer, a CSV-mediated route, or a custom posting workflow.

That extraction-first route is especially useful when you need custom columns, consistent VAT handling, invoice-level and line-item data, or a review step before anything is created in FreeAgent. Invoice Data Extraction is built for that preprocessing layer: it turns invoice PDFs and images into Excel, CSV, or JSON, supports prompt-based field selection, and can pull line items when that detail matters. Just as important, it is not a native one-click FreeAgent integration. The value is in preparing reviewed data before your FreeAgent workflow starts.

FreeAgent's bill importer gives that preparation a fixed target. A practice can extract a client's supplier PDFs with a Structured Prompt that names the template's columns in the template's order, such as contact, reference, dated_on, category and total_value, with dates formatted as DD/MM/YYYY and amounts as plain numbers, and set the task to one row per line item. FreeAgent's own multi-line example repeats the contact, reference and date on each line's row, which is the shape a one-row-per-line-item extraction produces. The Source File and Review Needed columns can be left out in Preferences so the file carries only the template's columns, while the flagged values stay visible in the dashboard for review. Import a few bills first and check them: the 'Last import' undo makes a test batch cheap to reverse.

There is a clear operational reason this preparation step matters in the UK. In qualitative interviews with 45 UK SMEs, the most commonly cited invoicing practice was using accountancy software to generate PDF invoices and send them by email, and many businesses mixed e-invoicing with PDF workflows, according to HMRC's qualitative research on how UK SMEs still handle invoices. When invoices still arrive in mixed document formats, preprocessing them into reviewed structured data can remove a large amount of cleanup before bills are entered or posted.

The FreeAgent API belongs in the same conversation, but for a different reason. It starts to make sense when you have higher recurring volume, custom approval logic, mapping rules that need to happen outside FreeAgent, or another system that should control bill creation programmatically. At that point, the decision is less about a FreeAgent CSV import workaround and more about whether you want governed data preparation first, then controlled posting into FreeAgent through the API.

How to Choose the Right FreeAgent Import Workflow

If you are choosing between these routes, start with the shape of the work rather than the product names. The comparison usually comes down to six variables: monthly volume, VAT complexity, supplier coding, line-item requirements, historical backlog, and budget tolerance.

  • Choose manual entry if you only handle occasional bills and want the cleanest possible review inside FreeAgent.
  • Choose Smart Capture if low volume is the main constraint and pulling the date and amount is enough to speed up bill creation.
  • Choose a partner capture tool if recurring AP work now depends on better field extraction, supplier matching, VAT handling, or less manual review.
  • Choose FreeAgent's bill importer if a Practice Partner keeps your books and has a batch of bills, line items and VAT included, to bring in at once.
  • Choose a CSV-mediated migration route if you run FreeAgent on your own and the main task is backfilling historical supplier bills rather than improving your long-term intake process. On any route, bills dated before your FreeAgent start date belong in the opening balances, not in the import.
  • Choose an extraction-first workflow or API route if invoices are messy, custom fields matter, or you need another system to prepare and control the data before it lands in FreeAgent.

The common mistake is choosing on headline price alone. A cheaper route is rarely cheaper if someone still has to fix VAT breakdowns, re-enter line items, or recode suppliers by hand after import.

A practical next step is to test the lowest-complexity route that could plausibly work on a representative batch of invoices. Run a small sample, check the VAT, supplier coding, and data depth you actually need, then scale the workflow that survives real review instead of the one that only sounds acceptable in theory.

Extract invoice data to Excel with AI

Upload your invoices, say what you need in plain words, and download the spreadsheet.

  • A panel of AI agents has to agree on every value
  • What the panel cannot agree on is flagged as Review Needed
  • 50 free pages every month, no subscription
  • Any layout, any language, scans and phone photos
  • Numbers come through as numbers and dates as dates
  • Files encrypted and deleted within 48 hours