Importing timesheets or activity slips from AccountRight into Payroll

Check the following details in AccountRight and Payroll.

Last Name/Code

The Last Name field in the employee's card in AccountRight must be the same as the employee Code in Payroll. This must be in upper case letters, and be a maximum of 8 characters.

The employee Code in Payroll

The Last Name field in AccountRight

Activity ID/PAY CODE

The Activity ID in AccountRight needs to match the PAY CODE in Payroll. This must be in uppercase and be a maximum of 8 characters. The Pay Code in Payroll needs a rate entered for the employee.

The Pay Code in Payroll

The Activity ID in AccountRight

Job Number/Costcentre Code (Optional)

If you use jobs in AccountRight then the Job Number must match the Costcentre Code in Payroll.

1. In AccountRight, go to the File menu and choose Import/Export Assistant.
   
   
2. Choose Export data then click Next.  
   
   
3. In the Export field, select Activity Slips and specify the applicable date range, then click Next.
   
   
4. For the option Separate data using, select Commas. Also deselect the option Include field headers in the file.
   

   

   
   
   
5. Click Next.
   
   
6. Choose the following fields in the order listed by clicking them in the Available fields column, then clicking Add.
   The program assumes that the start and stop times will be blank. If they won't be then choose other fields that will be blank. If the times are to be allocated against costcentres/jobs then choose the Job field instead of Stop Time.
   
   Field 1: Date
   Field 2: Emp Co./Last Name
   Field 3: Activity ID
   Field 4: Must be blank (try Start Time)
   Field 5: Job or must be blank (try Stop Time).
   Field 6: Units
   
   The example below shows that Job has been selected rather than Stop Time.
   

   

   
   
   
7. Click Export.
   
   
8. Save the export file in an easily accessible location, for example the Desktop. Make a note of where this file is being saved, and overwrite any previous file if necessary.

1. In AccountRight, go to the File menu and choose Export Data then choose Activity Slips.
   
   
2. In the Export File window, select Comma Separated and Data Record.
   

   

   
   
   

3. Set the applicable date range in the Dated From and To fields, then click Continue.
   
   

4. In the Export Data window, choose the following fields in the order listed by clicking in the Export Order column. The program assumes that the start and stop times will be blank, if they won t be then choose other fields that will be blank.) If the times are to be allocated against costcentres/jobs then choose the Job field instead of Stop Time.
   
   Field 1: Date
   Field 2: Emp Co./Last Name
   Field 3: Activity ID
   Field 4: Must be blank (try Start Time)
   Field 5: Job or must be blank (try Stop Time).
   Field 6: Units
   
   The example window below shows that Job has been selected rather than Stop Time.
   

   

   
   
   

5. Click Export.
   
   

6. Save the export file in an easily accessible location, for example the Desktop. Make a note of where this file is being saved, and overwrite any previous file if necessary.

1. In Payroll, go to the Prepare Pays command centre and click Import Timesheets.
   
   
2. Click on the ellipsis (...) button then browse to and select the file exported from AccountRight.
   

   

   
   
   
3. Click Import.