Convert Invoices to Epicor and Load AP Invoice Entry from Excel or CSV

Upload a PDF or scanned invoice and InvoicesOCR pulls the vendor, invoice number, dates, tax, totals, and line items into a clean spreadsheet you save as CSV for an Epicor DMT import into AP Invoice Entry. Stop keying supplier invoices into Epicor Kinetic one field at a time.

PDF, JPG, PNG, BMP, HEIC, TIFF

Upload your receipts and invoices

DMT-ready CSV or Excel output
Header and line-item rows captured
Bulk invoices at once
Encrypted, files auto-deleted

Keying supplier invoices into Epicor is the slow part

Epicor records each supplier invoice in AP Invoice Entry, inside an invoice group, but the system does not read your PDFs. Someone still has to open every invoice and key the vendor, dates, amounts, tax, and each line into the screen, or into a file the Data Management Tool loads. That reading and keying step is where the hours go.

Retyping every supplier invoice

Each PDF or scanned invoice has to be read and keyed into the AP invoice fields, one value at a time, before the group can post.

Line items get dropped

Typing a full line-item table into the invoice lines is tedious, so people post a single total and lose the detail Epicor could have held against each GL account, part, or job.

DMT imports fail on bad formatting

A wrong date format, a currency symbol inside an amount, a missing required field, or a comma inside a vendor name makes a DMT load stop and report row errors against the business logic.

It does not scale at month end

A few invoices are manageable; a stack of fifty supplier invoices at month end turns AP entry in Epicor into an evening of typing.

How InvoicesOCR gets your invoices into Epicor

InvoicesOCR reads the invoice for you and returns structured data as Excel or CSV. You arrange those columns to match an Epicor DMT AP Invoice template, the invoice header and the invoice lines, then run the load. The reading and typing step is gone.

Reads any invoice layout

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

Header and line rows

Vendor and invoice totals for the header, plus description, quantity, unit cost, and amount for every line, ready for a DMT load.

Excel & CSV output

Download a clean spreadsheet. DMT reads both CSV and Excel, so either format imports.

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, and dates in a consistent format, which is what DMT needs to load without row errors.

Secure and private

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

Why Choose InvoicesOCR?

  • No per-page recognition charges
  • Works on scanned and photographed invoices
  • Keeps line items, tax, and totals intact
  • Output maps to a DMT AP Invoice template
  • Saves as CSV or Excel, both of which DMT reads
  • Browser-based, nothing to install

How to convert invoices for Epicor in 3 steps

From a supplier PDF to an Epicor 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

Map and import with DMT

Line up the columns with your DMT AP Invoice template for the header and the invoice lines, then run the load to create the invoice group.

Tip: Keep the required fields the template expects (vendor, invoice number, invoice date, group ID, amount), use a consistent date format, and strip currency symbols so DMT loads cleanly.

Who imports invoices into Epicor

US manufacturers and distributors on Epicor Kinetic, and the people who keep AP posting accurate without hours of manual entry.

AP clerks on Epicor

Load supplier invoices into AP Invoice Entry in batches instead of typing each one into a group.

Manufacturing and distribution AP teams

Turn the supplier invoice pile into one clean Epicor import file with line items intact.

Epicor consultants and VARs

Give clients a repeatable way to get invoice data into a DMT AP Invoice load.

Controllers and finance managers

Standardize how the team gets vendor invoices into Epicor.

Document Types We Handle

Supplier invoices
Vendor invoices
Scanned paper invoices
Phone-photo invoices
Multi-page invoices
Recurring invoices
Miscellaneous invoices
Job-cost invoices

Last updated June 2026

What Epicor needs to import an AP invoice

Epicor, the US mid-market ERP now sold as Epicor Kinetic and known in earlier releases as Epicor ERP 10 and Vantage, records each supplier invoice in AP Invoice Entry. Invoices are entered into an invoice group, which carries the vendor, invoice number, dates, terms, and the invoice lines that hit your GL, part, or job accounts, and the group is then posted. To bring invoices in without keying them, most teams use the Data Management Tool, or DMT, Epicor's standard import utility. DMT ships with a pre-built AP Invoice template, validates your data against Epicor's business logic, and flags the required fields before it loads. You map each Epicor field to a column in your source file once, then reuse that layout for every future batch.

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, tax, total, and the full line-item detail as columns in Excel or CSV. You arrange those columns to match your DMT template once, then reuse that layout for every batch. Because the values come out clean, as plain numbers and consistent dates, the load does not stall on the formatting that DMT rejects.

DMT reads CSV and Excel

Unlike some ERP importers, DMT accepts both a CSV file and an Excel workbook, so you can keep the InvoicesOCR output in either format. A few details still trip people up: a comma inside a text field such as a vendor name should be wrapped in quotes in a CSV so it is not read as a delimiter, every row needs a group ID so the invoices land in the right AP invoice group, and amounts must be plain numbers without a dollar sign. InvoicesOCR returns the data already structured into columns, so preparing the file is a matter of arranging columns rather than retyping every figure.

AP invoices versus AR invoices in Epicor

An AP invoice records a supplier invoice you owe and posts to accounts payable. An AR invoice is the sales invoice you issue to a customer and posts to accounts receivable. Most teams converting received invoices are loading AP invoices, and that is the document the extracted spreadsheet is built for. Capturing line items rather than a single lump total means your Epicor records keep the detail you need for GL distribution, tax, part receipts, and job costing.

Epicor runs heavily in industrial settings, and the invoice mix follows. Plants loading material and component bills with PO and job detail can see how the capture handles that document set on the manufacturing invoice extraction page, distributors and dealers billing wholesale stock will want the SKU and unit-cost angle on the retail invoice extraction page, and buyers checking each invoice against the order before it posts can follow the control on the invoice matching software page.

Already on a different system as well? The same extracted spreadsheet also produces an Acumatica AP bill import or a NetSuite vendor bill import from the same data.

Why teams use InvoicesOCR for Epicor

No retyping
The reading and keying step is gone
Line items
Full detail, not just totals
Bulk
One file for a whole stack of invoices

Security & Privacy

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

Convert Invoices to Epicor FAQ

You import invoices into Epicor with the Data Management Tool, or DMT. You map a CSV or Excel file to the DMT AP Invoice template, which covers the invoice header and the invoice lines, then run the load to create an AP invoice group. InvoicesOCR extracts the data from your PDF or scanned invoices into a spreadsheet you arrange to match that template.

AP Invoice Entry is the Accounts Payable screen in Epicor where each supplier invoice is recorded inside an invoice group before it posts. It carries the vendor, invoice number, dates, terms, and the invoice lines that hit your GL accounts. DMT can load the same data from a file instead of having someone type each invoice into the screen.

DMT, the Data Management Tool, is Epicor's standard utility for importing and updating data in bulk. It ships with pre-built templates, including one for AP Invoice Entry, reads CSV and Excel files, validates your data against Epicor business logic, and flags required fields. It is the usual way to load AP invoices into Epicor without keying them one at a time.

Yes. DMT reads both Excel workbooks and CSV files, so you can load the InvoicesOCR output in either format. You prepare the columns to match the DMT AP Invoice template, then run the load. InvoicesOCR reads each supplier invoice and returns the vendor, dates, amounts, tax, and line items, so you map the columns and import a batch instead of typing each invoice.

No. Epicor does not extract data from a PDF on its own and needs structured data in a file for a DMT load. InvoicesOCR fills that gap by reading the PDF or scan and returning the vendor, dates, totals, and line items as a clean spreadsheet you save as CSV or Excel and import yourself.

DMT accepts both CSV and Excel files. Match your columns to the DMT AP Invoice template, keep the required fields it expects such as vendor, invoice number, invoice date, group ID, and amount, wrap text fields that may contain a comma in quotes when using CSV, and keep amounts as plain numbers. InvoicesOCR returns the data already in columns, so building that file is straightforward.

Yes. DMT is built to create many records at once from a single data file. InvoicesOCR processes a batch of invoices together and builds one structured spreadsheet, so a month-end stack of supplier invoices becomes one DMT load rather than dozens of manual AP Invoice Entry sessions.

An AP invoice records a supplier invoice you owe and posts to accounts payable, while an AR invoice is the sales invoice you send a customer and posts to accounts receivable. Converting received invoices means loading AP invoices, which is what the InvoicesOCR output is structured for.

InvoicesOCR produces an Excel or CSV file ready for an Epicor DMT AP Invoice load, rather than writing into the company database for you. That keeps you in control of how each batch is reviewed and loaded, and the same output also works for Acumatica, NetSuite, and QuickBooks imports.