Skip to content
logo Knowledgebase

Import Backdated Adjustment Batch

Created on  | Last modified on  Highlight Matches

Summary

How to create, complete, and import an Adjustment Batch in Sage 300 People. Use Adjustment Batches to process backdated payroll adjustments for employees.

Description

Use an Adjustment Batch to import payroll adjustments from a Microsoft Excel file. Complete the exported file, then import it back into the system.
If you don't want to include the backdated amount in the current period's net salary, use a negative definition or an advance.

Resolution

Open Adjustment Batches

  1. On the Navigation Pane, expand Utilities.
  2. Expand Batches.
  3. Double-click System Defined Batches.
  4. Select Adjustment Batches.

Create the import file

  1. Select Create Import Batch File.
  2. Select the required Company Rule.
  3. Select the required Pay Run Definition.
  4. Select OK.
  5. Select the export format and save the location.
  6. Select OK.
  7. Wait for the export process to complete.
  8. Select OK when prompted.

Complete the Microsoft Excel file

  1. Open the exported Microsoft Excel file.
  2. Enter or update the required information.

Complete the following fields:

Use the following line type codes:

  • EA for Earnings
  • DD for Deductions
  • FB for Fringe Benefits
  • AA for Additional Lines
  • CC for Company Contributions
  1. Save the file.

Import the adjustment batch

  1. Return to Adjustment Batches.
  2. Select Process on the ribbon.
  3. Browse to the saved Microsoft Excel file.
  4. Select OK.
  5. Wait for the import process to complete.
  6. Select OK.

Review and complete the import

  1. Review the information displayed for import.
  2. Select OK to continue if the details are correct.
  3. Review the batch results.
  4. Confirm that the import completed successfully.
  5. Close the results screen.
  6. Select OK on the final confirmation screen.

Unlock payroll management across multiple African countries — all in one platform.

Sage 300 People provides full compliance with local tax laws, statutory deductions, and reporting requirements.

I want to know more

Image