This article describes how to create an .csv file that can be imported to Xledger

Description

If you use Xledger as your Accounting System, you can at the end of the month generate a .CSV file via our Custom Export tool. 

Export - Step-by-Step

If you run payroll for more than one company, you will need one export for each one set up in General Codes.

To export the file:

1. Go to Tools | Export | Custom Export | Xledger - XXX
   Select the company you want to export a file for
   
2. Input information in the dialogue window as follows:
   Payroll Period - The payroll period you want to do an export for. You can export both the open payroll period and any closed payroll periods. 
   Voucher No. - This number will become part of the file and be the Voucher number in Xledger
   Export Number - This should always default to 1. Currently there is not a possibility to do a second export with only selected records.
   
3. Select the Path where you want to export the file to by clicking on the 3 dots button 
   

Setup of the Export

General Codes

The export is created in General Codes by importing the attached Template file. 
 Xledger.xml

To import this template you need to take the following steps. 

1. Save the Xledger.xml file above to your computer. 
2. Then go to Adonis Personnel Manager and Setup | General Codes
   
3. Select Custom Export | Export
   
4. Give the export a Code (max 10 char) and a Name in the Text field
   
5. Select Template | Import in the bottom of the window
   
6. Find the file in the location where you saved it, select it and click Open
   
7. Click OK and save. You are now ready to start using the export

Access Rights

You have three options for setting access restrictions to the Custom exports.

• All Users on a specific level should have no access to any export tools
• All Users on Levels that has access to Custom Exports should be able to use all Exports. 
• Users on one level should only have access to specific Exports

The below describes how to make the correct settings in the Adonis Control Centre, by using the Security code available in General Codes. 

1. All Users on a specific level should have no access to any export tools
   Set Export to N under Routines tab in the Adonis Control Centre
   
2. All Users on Levels that has access to Custom Exports should be able to use all Exports. 
   • Set the Security Code on each of the Custom Exports to the same number, e.g. 200 (The number is random)
     
     
     
   • Go to the Adonis Control Centre. Select the User Level that should have access and go to General Codes - Custom Export | Export
     
   • Select Write access on one of the Custom Exports and all exports with same code in the Field column will be granted access. 
     
3. Users on one level should only have access to specific Exports
   
   • Set the Security Code on each of the Custom Exports to a different number, e.g. 200, 201, 202 (The numbers are random)
     
   • Go to the Adonis Control Centre. Select the User Level that should have access and go to General Codes - Custom Export | Export
   • Select Write access on one of the Custom Exports and only exports with same code in the Field column will be granted access. 

Defining Cost Dimensions 

The Cost dimensions you have set up in Payroll can be part of the export for any Account numbers that has this selected. In this template file, only the dimension in the field Accountdim2, which is normally a vessel, is part of the export and the CODE of the vessel will be included for the selected accounts. 

To enable the cost dimension on the individual GL accounts; 

1. Go to Set up | Tables | Payroll | Accounts
   
2. Set a tick in Dim2 for the accounts that should have the amounts split by the vessel accounting code in the file. 
   

Adonis Template file and SQL statement

Xledger file Specification

Sample Generated File in APM