Import Invoice Lines

When checking an invoice, you can import invoice lines from a spreadsheet to allow an efficient way to analyse and code the correct amounts to various Projects and Cost Codes.

Introduction

Import Invoice Lines

File Format

Introduction

You can import invoice lines from a spreadsheet when you receive large invoices that do not have the details split out onto separate lines for the coding you need. You can code the details to the different Projects or Cost Codes that you need by using a spreadsheet, and then import these invoice lines back to the invoice.

NOTE: Imported invoice lines will be appended to any existing lines that already exist in your invoice, so you would normally import lines where they have not been detailed by your Supplier, or if you wish to delete existing lines before you import the analysed lines.

When importing invoice line details to an invoice you have two options:

Import: This option requires you to fill in all the fields. Use this option where you have the Price, Unit Price and Quantity for each line.
Import with adjusted price: This option allows you to omit the price and this will be calculated based on the Unit Price x Quantity. Use this option where you have the Unit Price and Quantity.

TIP: If the Unit Price x Quantity calculates to 3 decimal places, you must adjust the file to calculate to 2 decimal places.

The required file format is detailed below.

Return to Top of Page