...
Role Required: Super User/Payroll
Permission Required: N/A
| Table of Contents |
|---|
Download Raw Payroll Dump File
...
*Please note: The headers must be spelled exactly as listed above and in the same sequence as listed above or there will be an error when trying to import the text file.
Reconcile a Single Batch
If on the final step of processing a batch and have the batch details screen open:
On an approved batch, click the green Reconcile button.
Complete the Reconcile from Payroll form wizard
Enter a Ref Reconcile Id - Choose any reference number
File Name - The name that will appear in the Attachments tab describing the reconcile file
Click Add Attachment to attach the reconcile text file discussed in the previous steps
Click Save
Click on the Attachments tab
Click anywhere on the row in the attachments table to open the results file
In the Attachment Details widget, next to the name field, click the blue download arrow icon to start the download.
Open the downloaded TXT file
Review the results file
First row is headers
Subsequent rows are results for each line on the payroll reconcile file
Each row will state Failure or Success at the end of the row (see ReconcileStatus header)
- Failures will include a failure reason (see Reconcile Reason header)
Review Reconciled Batches
Select Payroll from the main menu
Select Reconcile from the submenu
Search for the file by typing the reconcile text file name into the search filters and clicking Search
Click anywhere on the row in the attachments table to open the results file
In the Attachment Details widget, next to the name field, click the blue download arrow icon to start the download.
Open the downloaded TXT file
Review the results file
First row is headers
Subsequent rows are results for each line on payroll reconcile file
Each row will state Failure or Success at the end of the row (see ReconcileStatus header)
Failures will include a failure reason (see Reconcile Reason header)
Reconcile Multiple Payroll Batches
...
Create the Reconcile Text File using the steps above
Select Payroll from the main menu
Select Reconcile from the submenu
From the attachments table, select one or more files to reconcile.
Click Actions
Select Upload File
The reconcile text file will include the entries from the selected batches
Complete the Reconcile File form wizard
Enter a Ref Reconcile Id - Choose any reference number
File Name - The name that will appear in the attachments tab describing the reconcile file
Click Add Attachment to attach the reconcile text file discussed in the previous steps
Click Save
The system will start the reconciliation process. The batch status will update to ReconciliationInProcess. When complete, the user can see results under the Attachments tab on that batch page.
If all entries were successfully reconciled, the batch status will update to reconciled.
If any entries failed reconciliation, the results file will display the reconciliation status and the reason for failure.
If entries were successfully reconciled, the results file will list success as the reconciliation status and the entry status will update to paid.
...