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).

When you click Reconcile on the Reconcile OFX Statements screen, Sage 300 transactions are automatically matched to transactions from the e-statement if they have the same transaction amount and at least one of the following:

• For payments:

  • The check number in Sage 300 matches the transaction number or reference in the e-statement.
  • The reference in Sage 300 matches the reference number or comment in the e-statement.
  • The description in Sage 300 matches the transaction number, payee name, or payee ID in the e-statement.
  • The payee/vendor name or ID in Sage 300 matches the payee name or payee ID in the e-statement.

• For deposits:

  • The transaction number (for example, check number) in Sage 300 matches the transaction number, reference, or comment in the e-statement.
  • The reference in Sage 300 matches the reference, comment, or transaction number in the e-statement.
  • The description in Sage 300 matches the payee name or payee ID in the e-statement.
  • The customer name or customer ID in Sage 300 matches the payee name or payee ID in the e-statement.