• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Free ACCA & CIMA online courses from OpenTuition

Free ACCA & CIMA online courses from OpenTuition

Free Notes, Lectures, Tests and Forums for ACCA and CIMA exams

  • ACCA
  • CIMA
  • FIA
  • OBU
  • Books
  • Forums
  • Ask AI
  • Search
  • Register
  • Login
  • ACCA Forums
  • Ask ACCA Tutor
  • CIMA Forums
  • Ask CIMA Tutor
  • FIA
  • OBU
  • Buy/Sell Books
  • All Forums
  • Latest Topics

June 2025 ACCA Exam Results

Comments & Instant poll >>

20% off ACCA & CIMA Books

OpenTuition recommends the new interactive BPP books for June 2025 exams.
Get your discount code >>

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.

entryCustomerNom CodeDeptDateRefDetailsNetT/CVAT
SIIMPE001400001/02/2012IN1001IMPE001110.00T119.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.

t1p1

Any errors will be listed example as below.

t1p2

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

t1p3


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

Reader Interactions

Leave a Reply Cancel reply

You must be logged in to post a comment.

Primary Sidebar

Donate

Donate

If you have benefited from OpenTuition please donate

Donate now

You can also “donate your time” and help out other students on the Students Forums

BPP

Copyright © 2025 · Support · Contact · Advertising · OpenLicense · About · Sitemap · Comments · Log in