Skip to main content

Batch Importing Invoices

This guide walks through the step-by-step process of batch posting multiple invoices into Chaindrive Accounting from a file.

Prerequisites​

Before starting the invoice posting process, ensure you have:

  • Access to the ChainDrive Accounting - AP Invoice Import application.
  • A copy of the invoice inthe appropriate format.
tip

This application works best if done from the same computer each time as it will save the

Batch Importing​

  1. Launch the ChainDrive Accounting - AP Invoice import application. It is a separate application from Accounting and should be in the Multidev Accounting folder on your desktop named Accounting-AP Invoice Import. You'll be presented with the following screen.

AP Batch Import

  1. Select the file that will be used for import this is done by double-clicking on the file input text in the upperleft. This file should being using one of the known import file formats.

  2. Select the know import file format by navigating to the profile tab and selecting the appropriate profile. In almost call circumstances this should be the one with the description ASG Invoices

ASG The format for ASG is fixed.

Other In order to import a generic spreadsheet with a list of invoices you must have a CSV to import that contains the following columns in a the following order, the header is skipped so the columns names need not be identical: Supplier ID, Invoice Number, Invoice Date, Due Date, Total, G/L Code, Branch Label, Allocation Amount, Line Notes, and HDR Notes. The fields all must meet the import requirements. The Supplier ID, G/L Code, and Branch Label all must match their expected value from the Accounting module. The dates all must be specified as DD.MM.YYYY.

The profile Sample Expense should be used. An example file that is able to successfully import:

SUPPID,SUPPNUMBER,INVOICEDATE,DATEDUE,TOTAL,GL_MAJ,BRANCHID,AMOUNT,LINENOTE,MEMONOTES
5338,INV000001,12/02/2025,12/03/2025,1250.75,101004,101,1250.75,,
5338,INV002345,12/02/2025,11/03/2025,2340.50,602802,101,2340.50,,
5338,PO9876543,12/02/2025,10/03/2025,875.25,101004,101,875.25,,
5338,INV123456,12/02/2025,15/03/2025,4500.00,602802,101,4500.00,,
5338,BILL89012,12/02/2025,14/03/2025,960.30,101004,101,960.30,,
5338,INV445566,12/02/2025,13/03/2025,1875.45,602802,101,1875.45,,
5338,PO112233,12/02/2025,16/03/2025,3200.00,101004,101,3200.00,,
5338,INV998877,12/02/2025,17/03/2025,1640.25,602802,101,1640.25,,
note

It is possible to create mutliline invoice imports by specifying different line ids