Matching OFX Transactions to Sage HRMS Payroll Transactions

When you click the Reconcile button on the Reconcile OFX Statements window, the program automatically matches transactions from the OFX statement to Sage HRMS Payroll transactions.

• For payments, it tries to match transaction amounts, as well as the following additional elements, in this order:

1. The check number used in Sage HRMS Payroll and the reference number in the OFX file.
2. The reference used in Sage HRMS Payroll and the reference number or comment in the OFX file.
3. The payee name (or vendor name) in Sage HRMS Payroll and the payee name or payee ID in the OFX file.
4. The transaction comment in Sage HRMS Payroll to the payee name, payee ID, or comment used in the OFX file.

• For deposits, it tries to match transaction amounts, as well as the following additional elements, in this order:

1. The transaction number used for the Sage HRMS Payroll deposit and the reference number used in the OFX file.
2. The comment used for the Sage HRMS Payroll deposit and the payee name, payee ID, or comment used in the OFX file.
3. The payee name or payee ID in Sage HRMS Payroll and the payee name or payee ID used in the OFX file.

If the Sage HRMS Payroll bank uses an error spread, the program matches amounts that fall within the range prescribed by the error spread, although you must approve the clearing of amounts that do not match exactly.