How to Import Invoice Data into Sage from a PDF

Sage is one of those names that means something slightly different depending on who you talk to. In the UK and Ireland, Sage usually means Sage 50 or Sage Business Cloud Accounting. In North America, it's often Sage Intacct or Sage 50cloud. They all handle invoice imports, but the menus and the field names differ.

This guide covers the practical workflow for getting a PDF supplier invoice into Sage — regardless of which version you're using. The principles are the same: convert the PDF to CSV, then use Sage's built-in import.

Which Sage are you using?

The three most common ones:

• Sage Business Cloud Accounting (formerly Sage One) — the cloud-first product aimed at small businesses.
• Sage 50 / Sage 50cloud — the long-running desktop product, hugely common in the UK among accountants.
• Sage Intacct — the enterprise/mid-market cloud product, more common in North America.

If you're not sure, log into your Sage account and check the top of the screen. The product name is usually there.

The CSV workflow below applies to all three, with slightly different specifics for each.

Why not just use Sage's built-in capture?

Newer Sage products include AutoEntry (Sage acquired the AutoEntry product specifically for this). AutoEntry reads supplier invoices, extracts the data and pushes it into Sage.

It's a solid product. The reasons people still use a separate PDF-to-CSV workflow:

• AutoEntry is a subscription on top of Sage. Per-document fees add up if you have low or variable volume.
• It's tightly tied to Sage. If you want the same data in another tool, you're re-exporting.
• The review step in AutoEntry isn't always faster than reviewing a spreadsheet.

For bookkeepers who already use a separate extraction tool — or who want clean CSVs they can use beyond Sage — the manual import path below is fine.

The workflow in 30 seconds

1. Convert PDF invoices to CSV.
2. Format the CSV to match Sage's purchase invoice import template.
3. Upload via Sage's import function.
4. Review and post.

Step 1: Convert the PDF to CSV

Extract the fields you need for a Sage purchase invoice:

• Supplier (must match a supplier already in Sage)
• Invoice number / reference
• Invoice date
• Due date
• Net amount
• VAT/tax amount and rate
• Gross amount
• Nominal account code
• Department / cost centre (optional)

How to convert a PDF invoice to CSV walks through the conversion step. For a folder of invoices at once, batch processing PDF invoices covers the bulk version.

Step 2: Format the CSV for Sage

This is where the Sage variants diverge slightly. Get the right template:

Sage Business Cloud Accounting

1. Settings → Business Settings → Import Data.
2. Choose Sales Invoices or Purchase Invoices depending on what you're importing.
3. Click Download Template.

The template has columns like Date, Reference, Supplier Reference, Account Code, Net Amount, Tax Rate, Tax Amount, etc.

Sage 50 / Sage 50cloud

Sage 50 uses CSV imports via File → Import. The expected columns depend on the import type — supplier records, purchase invoices, journal entries — and there's a sample CSV for each.

Critically, suppliers and nominal codes must exist in Sage 50 before you import transactions referencing them. The import won't auto-create them.

Sage Intacct

Intacct uses CSV templates accessed under Company → Setup → Import Data. The Bills import template includes the standard fields plus dimensions (locations, departments, projects) if your account uses them.

Intacct is the strictest of the three about column names matching exactly. Use the downloaded template as your starting point and don't rename anything.

General formatting rules across all Sage versions

Dates. Sage UK products default to DD/MM/YYYY. North American Sage products often default to MM/DD/YYYY. Use whatever format matches your account's region.

Amounts. Decimal point, no thousands separators, no currency symbols.

Tax rates. Sage uses internal tax codes (T0, T1, T9 in UK Sage 50; specific code IDs in Intacct). The rate "20%" by itself won't work — you need the matching code from your Sage account.

Supplier names. Must exactly match an existing supplier in Sage. Trailing spaces, capitalisation differences and abbreviations all count as mismatches.

Nominal/account codes. Use the numeric code, not the account name.

One row per line item. Repeat the invoice header fields on every line item row. Sage groups by invoice reference.

Step 3: Upload to Sage

The upload menu varies by product:

• Sage Business Cloud: Settings → Business Settings → Import Data → choose import type → browse → upload.
• Sage 50: File → Import → CSV → select file → map columns.
• Sage Intacct: Company → Setup → Import Data → select template → upload file.

In all three, you'll see a preview before the import is committed. Use it.

Step 4: Review the import

Sage's preview screens flag errors before committing. The most common ones:

• Unrecognised supplier
• Unknown nominal/account code
• Invalid tax code
• Date out of range
• Duplicate invoice reference

Fix these in the CSV and re-upload until the preview is clean. Then commit.

Once posted, do a spot-check inside Sage:

• Sum the imported invoices and compare to the sum of your source PDFs.
• Open three or four at random and check against the source.
• Check the VAT summary — if the totals look wrong, a tax code is wrong somewhere.

Common Sage-specific gotchas

Sage 50 unique reference enforcement. Sage 50 won't let you post two purchase invoices with the same reference for the same supplier. If you're re-importing, either change the references or delete the previous batch.

Intacct dimension requirements. If your Intacct account requires certain dimensions on every transaction (e.g. department or location), the import will fail on rows without them. Add the columns even if all rows have the same value.

UK VAT scheme quirks. If you're on flat-rate VAT or the cash accounting scheme, the import behaves slightly differently. The amounts are the same — the tax treatment is what changes. Check with your accountant if you're not sure.

EC sales and reverse charge. Cross-border EU transactions need specific tax codes in Sage. If you handle a lot of these, build the right tax code into your CSV from the start rather than fixing them afterwards.

Long descriptions getting truncated. Sage has a character limit on description fields (usually 60 in Sage 50, longer in newer products). Long line-item descriptions get cut off. Decide in your extraction step whether to truncate or summarise.

Making the monthly Sage import painless

Once you've done it once, the monthly cadence settles into:

1. Drop the month's supplier PDFs into a folder.
2. Run them through a batch PDF extractor.
3. Open the output, do a 10-minute cleanup (mostly mapping tax codes and account codes if your extraction tool doesn't know your specific Sage setup).
4. Upload to Sage as a single import.
5. Spot-check and post.

A hundred invoices in 30 minutes, including review.

For a wider view of the time savings, see save time on invoice data entry. If you handle multiple clients on different accounting platforms, the same source CSV can usually be reformatted for QuickBooks, Xero or FreshBooks.

A word on choosing tools

The right PDF extraction tool for a Sage workflow has three things:

1. It outputs structured CSV that maps cleanly to Sage's templates (not just raw OCR text).
2. It handles line items, not just totals.
3. It doesn't require you to set up a template per supplier.

The best tools to extract data from PDF invoices covers the landscape in more detail.

Try it on your next Sage import

CsvInvoice converts PDF invoices to clean, structured CSV in about 10 seconds — formatted to drop into Sage Business Cloud, Sage 50 or Sage Intacct with minimal cleanup. Browser-based, no install, no subscription. $0.29 per invoice, paid only for what you process. Files are encrypted in transit and never shared.

Convert your first invoice →

Next month-end in Sage doesn't have to take a week.