Import Invoices into Dynamics 365 Business Central from Excel or CSV

Upload a PDF or scanned vendor invoice and InvoicesOCR pulls the vendor, invoice number, dates, tax, totals, and line items into a clean spreadsheet you can load through a Business Central configuration package or the Purchase Invoice Import app. Stop keying purchase invoices into Business Central by hand.

PDF, JPG, PNG, BMP, HEIC, TIFF

Upload your receipts and invoices

Business Central-ready Excel & CSV
Captures full line items
Bulk purchase invoices at once
Encrypted, files auto-deleted

Getting purchase invoices into Business Central by hand is the bottleneck

Dynamics 365 Business Central imports purchase invoices from a structured Excel or CSV file, but it does not read your PDFs. Someone still has to open every vendor invoice and type the vendor number, dates, amounts, and line items into the template before it will load. That manual step is where the hours go.

Retyping every vendor invoice

Each PDF or scanned invoice has to be read and keyed into the Purchase Header and Purchase Line columns one field at a time before Business Central will import it.

Line items get dropped

Typing full line-item tables is tedious, so people enter a single total and lose the G/L and quantity detail Business Central could have held.

Import errors from bad formatting

A renamed column, a wrong date format, an unknown vendor number, or a currency symbol in an amount makes the configuration package import fail.

It does not scale at month end

A handful of bills is manageable; a stack of fifty at month end turns Business Central data entry into an evening of typing.

How InvoicesOCR gets your invoices into Business Central

InvoicesOCR reads the invoice for you and returns structured data as Excel or CSV. You arrange those columns to match the Business Central configuration-package template (or the Purchase Invoice Import app layout), then load the file in Business Central. The reading and typing step is gone.

Reads any invoice layout

PDFs, scans, and phone photos from any vendor, with no per-supplier template to build.

Full line-item capture

Description, quantity, unit price, and amount for every line, so your Business Central purchase invoices keep their detail.

Excel & CSV output

Download a clean spreadsheet you can map to the Purchase Header and Purchase Line import columns, including vendor, dates, and amounts.

Bulk processing

Process a stack of invoices at once and build one import file instead of keying them individually.

Clean, import-safe values

Amounts come through as plain numbers without currency symbols, which is what the Business Central import needs to avoid validation errors.

Secure and private

Files are encrypted and deleted automatically after processing, so vendor data does not linger.

Why Choose InvoicesOCR?

  • No per-vendor templates to maintain
  • Works on scanned and photographed bills
  • Keeps line items, tax, and totals intact
  • Output maps to the Business Central purchase import
  • Browser-based, nothing to install
  • Handles a few bills or a month-end stack

How to convert invoices for Business Central in 3 steps

From a vendor PDF to a Business Central import file in about a minute per batch.

1

Upload your invoices

Drag in PDF, JPG, PNG, or scanned invoices, one at a time or as a batch.

Tip: Multi-page PDFs are supported.

2

Extract to a spreadsheet

InvoicesOCR reads vendor, invoice number, dates, tax, totals, and line items and returns Excel or CSV.

3

Arrange and import into Business Central

Line up the columns with your configuration-package export (Purchase Header and Purchase Line) or the Purchase Invoice Import app, then load the file in Business Central and apply it.

Tip: Keep the template headers unchanged and make sure the vendor number already exists in Business Central.

Who imports invoices into Business Central

US businesses on Microsoft Dynamics 365 Business Central and the finance teams who keep its purchase ledger accurate without hours of manual entry.

Accounts payable teams

Turn the vendor invoice pile into one clean Business Central import file each cycle.

Controllers and accountants

Load purchase invoices into Business Central in batches instead of keying each one.

ERP implementation partners

Bring opening AP backlogs into Business Central during a go-live without manual entry.

Outsourced accounting firms

Standardize how the team gets client invoices into Business Central.

Common Search Terms

import invoices into dynamics 365 business central import purchase invoices business central convert invoices to business central business central invoice import excel bulk import vendor invoices business central business central configuration package purchase invoice

Document Types We Handle

Vendor invoices
Purchase invoices
Scanned paper invoices
Phone-photo invoices
Multi-page invoices
Recurring invoices
Purchase credit memos
Opening AP backlogs

What Business Central needs to import a purchase invoice

Dynamics 365 Business Central imports purchase invoices from structured data, not from a PDF. The built-in route is a configuration package: you search Configuration Packages, create a package, add the Purchase Header and Purchase Line tables, and use Export to Excel so Business Central generates a spreadsheet with the correct column headers and data types. You fill in the vendor, dates, and line detail, keep the headers unchanged, then choose Import from Excel and apply the package. The Purchase Invoice Import app from AppSource works similarly but reads a CSV directly, and Power Automate or the Business Central API cover recurring or developer-built imports.

That is exactly the gap InvoicesOCR fills. It reads each PDF or scanned invoice and gives you the vendor, invoice number, invoice date, due date, subtotal, tax, total, and the full line-item detail as columns in Excel or CSV. You arrange those columns to match the configuration-package export once, then reuse that layout for every future batch instead of opening each PDF and retyping it.

Vendors and accounts have to exist first

Business Central matches each imported invoice to records that already exist, so the vendor number on the Purchase Header must be set up in your vendor list, and the G/L account or item on each Purchase Line must be valid. Configuration packages create unposted draft purchase invoices; you review and post them through the normal posting process, since you cannot import already-posted documents or ledger entries. Keeping line items rather than a single lump total means your Business Central purchase ledger stays detailed enough for reporting and reconciliation.

Running a different system too? The same extracted spreadsheet also maps to NetSuite, Sage, Xero, and QuickBooks imports, so one extraction step feeds whichever accounting platform you use.

Business Central reaches across mid-market sectors, and the purchase invoices each one posts read differently. Distributors and retailers bringing in high volumes of SKU-priced vendor bills will recognize the pattern in invoice extraction for retail, finance leaders who want every bill turned into spend visibility should see invoice extraction for CFOs, and procurement teams matching each purchase invoice to a PO before it posts will want invoice processing for procurement managers.

Last updated June 2026

Why teams use InvoicesOCR for Business Central

BC-ready
Output maps to the purchase import
Line items
Full detail, not just totals
Bulk
One file for a whole stack of bills

Security & Privacy

  • Encrypted upload and storage
  • Files auto-deleted after you download
  • Vendor and financial data never shared
  • Private, per-account processing

Import Invoices into Business Central FAQ

You import invoices into Business Central from a structured Excel or CSV file. The built-in way is a configuration package: add the Purchase Header and Purchase Line tables, export the template, fill it in, then import and apply. Business Central does not read PDFs, so InvoicesOCR extracts the data from your invoices into a spreadsheet that matches that template.

Yes. You can bulk import purchase invoices using a configuration package or the Purchase Invoice Import app from AppSource, both of which load many invoices from one file. InvoicesOCR processes a batch of invoices together and builds a single structured spreadsheet, so a month-end stack of vendor bills becomes one Business Central import.

Open Configuration Packages in Business Central, create a package, add the table you need, and use Export to Excel to get a template with the correct headers. Fill it in, then choose Import from Excel and apply the package. InvoicesOCR returns invoice data already in Excel so you only have to line the columns up with that template.

Business Central can capture some incoming documents, but its bulk import tools work from structured Excel or CSV, not from arbitrary PDF layouts. To load a stack of vendor PDFs reliably, you first turn them into structured rows. InvoicesOCR reads each PDF or scan and outputs the vendor, dates, amounts, and line items as clean spreadsheet columns.

Business Central needs an Excel or CSV file whose columns match its import template, with headers left unchanged, valid vendor and G/L account references, the correct date format, and amounts as plain numbers without currency symbols. InvoicesOCR returns values in that clean, import-safe form so the configuration-package import does not error out.

Yes. Business Central matches each invoice to an existing vendor, so the vendor number on the Purchase Header has to be set up in your vendor list first, and the G/L account or item on each line must be valid. InvoicesOCR captures the vendor name and details so you can map them to the right vendor number before importing.

No. Configuration packages create unposted draft purchase invoices, not posted documents or ledger entries. You import the drafts, review them, then post them through the normal Business Central posting process. InvoicesOCR builds the unposted import file; posting stays in your hands so your controls and approvals are preserved.

Upload the PDF to InvoicesOCR and it extracts the vendor, invoice number, dates, tax, total, and line items into Excel or CSV. Arrange those columns to match your configuration-package export or the Purchase Invoice Import app, then load the file in Business Central. This replaces opening the PDF and retyping every field into the template.

InvoicesOCR produces a Business Central-ready Excel or CSV file that you load through a configuration package, the Purchase Invoice Import app, or your own API flow, rather than pushing data into Business Central for you. That keeps you in control of how each batch is reviewed and posted, and the same file also works for NetSuite, Sage, Xero, and QuickBooks.