Exporting Your Payroll Data
Step 1 - Backup Your Sage Line 50 Data
Before you do anything else, you should create a backup of your Sage Line 50 data file. This can be done by selecting Back Up from the File menu in Sage Line 50.
Step 2 - Starting the Nominal Ledger Export In CollSoft Payroll
The process of exporting your Payroll data from CollSoft Payroll is just a matter of running the Nominal Ledger Export Wizard. To run this wizard simply select the Nominal Ledger Export... option from the Payroll menu.
Step 3 - Specify Date Range For Export
This step requires you to specify the dates for the export. All wages (weekly & monthly) between these dates will be included in your export file.
Note: It is very important that you do not choose dates that overlap with a previous export.
For Example: If you had previously exported all the wages between 1st Jan and 15th Jan, then the next export file should commence on 16th Jan. If you were to run the next export from 15th Jan then there is the possibility that wages on the 15th would be exported into Sage Line 50 twice!
Press the Next button to continue
Step 4 - Specify a Filename for the Export File
Specify a name for the export file, or click on the Browse button to navigate to the desired location.
Press the Next button to continue. CollSoft Payroll will now process all the wages between the dates that you specified.
If the export process was successful you will be asked if you want to view a report of the postings. This report shows you a summary of the amounts posted to each account, and a detailed breakdown on a wage by wage basis of the individual transaction involved. Press the Finish button to close the wizard. You are now ready to import your Payroll data into Sage Line 50. Click Here for more Information
Errors That Can Occur
If for any reason CollSoft is not able to export your payroll data then you will be shown a list of errors at the end of the wizard (and your export file will not be created).
The most common reason for an export to fail is that there is an amount associated with a category that has not been mapped to a nominal account in your company settings.
For example, if you do not specify a bank account in your nominal settings then Payroll will be unable to post the net payments to each employee, and you will see a screen similar to the following:
To rectify this problem review your nominal settings and try the export wizard again.