Skip to content
logo Knowledgebase

Utilities - Batches - Backdated Adjustment Batch

Created on  | Last modified on  Highlight Matches

Summary

This guide will assist you to make adjustments for the current tax year within the Sage 300 People System for employees in bulk.

Description

Backdated adjustment for the current Tax year for more than one employee can done using the Backdated Adjustment Batch.

Resolution

From Navigation Pane                

Expand            Utilities
Expand            Batches                                                                                                                          
Double Click   System Defined Batches                                                                                                   
Select               Adjustment Batches

Click on Create Import Batch File to export a file with no employee data.

Image

Select the Company Rule and the Pay Run Definition where you want to do adjustment.

Click on OK.

Image 

Select the format and location to where the file must be export, then click OK.

Image

The processing meter will show the progress on the export, then click OK

Image 

The following message will be displayed: 

Image

Open the MS Excel Spreadsheet from the saved location. The spreadsheet will contain all the relevant column headings. From here all the other information can be added or edited before the batch is imported again.

Image

Following is an indication on how to complete the MS Excel sheet.

Employee Code Capture Employee Code
Line Type

Use the following codes for Line Type
*  EA for Earnings line
*  DD for Deduction line
*  FB for Fringe Benefits line
*  AA for Additional Line
*  CC for Company Contribution Line

Def Code Capture the definition code that you want to adjust
Backdated Adjustment Amount Capture the adjustment amount.
Effective period

Capture the effective period for adjustment


Once the Excel sheet has been completed, Save and navigate back to the system.

Click on the process button on the ribbon to import the sheet.

Image 

Browse to the saved MS Excel sheet and click on OK.

Image 

 The processing meter will display the progress on the import.  Click on OK

Image

Review the information to be imported. If all the information is correct, click on OK to continue.

Image 

The batch results will display if the import was successful. 

Image 

Close the screen. 

Image

The following screen will display.  Click on OK to finish the process. 

Image

Note:  Should the backdated amount not be included for the current period’s net salary, a negative definition or “advance” may be entered.