Processing imported records
-
Import the records from the CSV file.
- Select Administration Console > Database > Import to Database.
-
Specify this information:
- Business Class
- Select PayrollHistoryImport.
- Source File Format
- Select Zip File or CSV for the source file.
- Import Filename
- Specify a file name for the import.
-
Click Submit.
For more information, see Importing to the database in the Landmark Administration Console Configuration and User Guide.
-
After the import is complete, process the records.
- Select Payroll Administrator > Regulatory Reporting > History Load > Import Records.
-
Click Process
Records.
The Process Records action validates any records that do not have a Processed status, including records in an Error status.
The Process Records action has an optional parameter to create
PayrollCheck
business class records or only theEmployeePayment
business class records. If you are creating checks, the check number can be specified on the CSV record. If the check number is not specified, the payment identifier is used.After the import records have been processed, they become Employee Payment records with a status of Import.
Note: To purge payments instead of processing them, click Purge Pending Imported Payments. The pending imported records are changed from a Processed to Not Processed status. To view these records, select Payroll Administrator > Regulatory Reporting > History Load > Import Records and click the Not Processed tab.
-
Process the imported payments.
- Reconcile each payment before processing to ensure that all associated payment records are successfully processed.
- Select Payroll Administrator > Regulatory Reporting > History Load > Pending Payments.
-
Click Process All Imported
Payments.
The records are closed and the payroll business classes are updated.Note: To purge payments instead of processing them, click Purge Pending Imported Payments. The pending imported records are changed from a Processed to Not Processed status. To view these records, select Payroll Administrator > Regulatory Reporting > History Load > Import Records and click the Not Processed tab.
- To verify that the payment is closed, selectReports > Payments and click the Closed Payments tab.