Matching OFX Transactions to Sage 300 ERP Transactions

Matching OFX Transactions to Sage 300 ERP Transactions

When you click the Reconcile button on the Reconcile OFX Statements form, the program automatically matches transactions from the OFX statement to Sage 300 ERP 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 300 ERP and the reference number in the OFX file.
  2. The reference used in Sage 300 ERP and the reference number or comment in the OFX file.
  3. The payee name (or vendor name) in Sage 300 ERP and the payee name or payee ID in the OFX file.
  4. The transaction comment in Sage 300 ERP 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 300 ERP deposit and the reference number used in the OFX file.
  2. The comment used for the Sage 300 ERP deposit and the payee name, payee ID, or comment used in the OFX file.
  3. The payee name or payee ID in Sage 300 ERP and the payee name or payee ID used in the OFX file.

Note: If you are matching deposits by transaction, and the program matches at least one detail in a deposit, the deposit's status is set to Reconcile By Deposit Detail. This applies only to deposits that can contain multiple receipts (such as those entered through Accounts Receivable).

See also

Unmatched OFX Transactions