Historical adjustment import

The Payroll Historical Adjustment import is used to load historical payroll adjustment records. This is used for making retrospective corrections or additions to payroll data for past periods.

You can add fields in the import file depending on the record type.

See the master file layouts for Payroll Imports in KB3631943.

Importing records from a source file

  1. Administration Console > Database.
  2. In the Import pane, click Import to Database.
  3. Specify this information:
    Business Class
    Select HistoricalAdjustmentImport.
    Source File Format
    Select Zip File or CSV for the source file.
    TipWe recommend using a CSV file.
    Import Filename
    Specify the exact file name including the file extension.
  4. Click Submit.

Processing the historical adjustment import records

  1. Select Administration > Reports.
  2. For US payroll processing, in the US Regulatory pane, click Historical Adjustment.
    For Canada payroll processing, in the Canadian Regulatory pane, click Historical Adjustment.
  3. Click Historical Adjustment Import Records.
  4. Click the Not Processed tab.
  5. Select a record, then click Process Records.

    Once records are in a Processed state they move from Historical Adjustment Import to Pending Historical Adjustments.

Processing the pending adjustments

You must validate that the records are valid and complete, once they are Processed, they become closed Adjustment Payments in History.
  1. Select Administration > Reports.
  2. For US payroll processing, in the US Regulatory pane, click Pending Historical Adjustments.
    For Canada payroll processing, in the Canadian Regulatory pane, click Pending Historical Adjustments.
  3. Select a record, then click Process Imported Records.
    Once the Process Imported Records action is done, the records are deleted from the Pending Historical Adjustments list view and Closed into history.
  4. To verify that the payment is closed, select Reports > Payments and click the Closed Payments tab.