Uploading Service Invoice from CSV file

Uploading Service Invoice from CSV file

Sales Invoices are often raised on an external in house system with the facility to download to excel or CSV.
Sage has the ability to upload a CSV file (also excel in 2012 version), using the nominal audit trail option.

To do so a CSV file must contain certain columns, a full list can be found in the help section.

The details below are an example of a sales invoice.

entry Customer Nom Code Dept Date Ref Details Net T/C VAT
SI IMPE001 4000 01/02/2012 IN1001 IMPE001 110.00 T1 19.25

Versions prior to 2012 cannot be imported with the headings – they must be deleted from the CSV file first.

Import can be found under menu FILE / IMPORT.  To import CSV invoices click on Audit Trail and Run.  Find the saved CSV file

Field Mapping is required for V.2012 however once completed can be saved for future.

Any errors will be listed example as below.

– Once corrected close and try run again. You will receive message confirming import success and close and close again.

This tutorial is provided exclusively to OpenTuition.com by CBK Training, in Association with Complete Book-Keeping Ltd

** Book your Sage 50 Classroom Training – Ringwood **
Courses : Sage 50 : Credit Control : VAT : Sage Payroll Basics
Website: www.cbktrain.co.uk

Leave a Reply