Import/export template > Module Financials > Import/export template KPS (Sage 50 Payroll transcriptions) 

If you have a large number of account codes, departments, cost centres or employee codes to transcribe from Sage 50 Payroll values you may find it easier to create the information in a spreadsheet and import it into Sage X3. 

Prerequisites

You should use the Sage 50 import transcribe function to create a Site type record and an Account type record.

You will use these records to generate a Microsoft® Excel® workbook to use as a template.

 See the documentation on Sage 50 import transcribe for more information.

Tables used

This template can be used in import and export modes. The data is updated in the following tables :

Table

Table description

COMPANY [CPY]

Company

GACM [GCM]

Account core model

GLED [LED]

Ledger

KPYIMPTRAN [KPT]

Sage 50 import transcribe