Matching OFX Transactions to Bank Transactions

When you click Reconcile on the Reconcile OFX Statements screen, Bank Services automatically matches transactions from the OFX statement to Sage 300 transactions, as follows:

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

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

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

  1. The transaction number used for the Sage 300 deposit and the reference number used in the OFX file.
  2. The comment used for the Sage 300 deposit and the payee name, payee ID, or comment used in the OFX file.
  3. The payee name or payee ID in Sage 300 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).

Last published: 4/8/2016