Skip to content
logo Knowledgebase

Financial batch file import layout specification

Created on  | Last modified on 

Summary

Review the file layout to import financial batches into Sage VIP Classic and Sage VIP Premier. Provide this to you clock-card or time and attendance service provider.

Description

If you use a clocking or time and attendance system, you can import hours into the payroll system instead of capturing them manually. The import will only work using the correct file format.

To import data from Excel or a clocking system, the file must meet these requirements below.

NOTE:

As an alternative, your Business Partner can provide you with a financial batch macro to create the import files. The macro also forms part of SMART reporting for Sage VIP.

 

File type

Allowed import file types:

  • Text (.TXT)
  • ASCII (.ASC)

File layout

  • Each line represents one employee’s data
  • Company and employee codes needs to be correct 
  • Include no column headings in the file
  • For verification purposes, your file can include batch totals
  • No decimal symbols (comma or full-stop) are allowed
  • All values include decimal values (two spaces)

TIP:

A value of 156.80 displays as 00000015680 in the file. Image

File layout specification for Detail record.

File layout specification for Trailer record.

File examples

Normal batch layout without trailer record

Example of a normal batch layout file in Notepad.

Download an example file

Normal batch layout with trailer record

Example of a normal batch layout file with trailer record.

Download an example file