Payment Reconciliation
Review payment reconciliation for a selected payroll scope.
Purpose and access
Open Payroll → Reports → Payment Reconciliation. The payroll feature and payroll finance report permission are required; CSV export requires report-download permission.
Run the report
- Select the report in the report picker, then set the office and Date range for the period to review. Open More filters and choose Run Status: RELEASED.
- Choose Team and Employee as needed; use More filters to set the available Department, Payroll group and Component. Choose All permitted to include all available choices.
- Choose Run, inspect the results and use Export CSV if available. The export uses the selected permitted scope.
Compare the recorded export and reconciliation evidence with the bank’s actual results before resolving differences.
What the results show
The report includes: Run ID, Run Version, Run Status, Office, Period Start, Period End, Export Status, Payment Status, Bank Reference, Export Records, Export Total, Reconciled Records, Reconciled Total, Reconciliation Reference, Reconciliation Status.
Example and troubleshooting
Compare export records and total with reconciled records and total and check the reconciliation reference and status. If no rows appear, check the date range and scope, then confirm report access. Choose Report office, Team and Employee separately; clear a filter or widen the dates if a valid selection has no records.
Results and limits
Review the summary above the sortable result table and any available charts. Dates are inclusive in the viewer timezone; From must not follow To, and the range cannot exceed two years. If more than 2,000 results match, narrow the range or scope. Export CSV uses the selected scope and requires download permission.
Interpret the result
MATCH requires reconciled payment status and matching exported and reconciled record counts and totals. NOT_EXPORTED or NOT_SUBMITTED identifies the missing stage; PENDING_OR_MISMATCH requires further review.
