How to Reconcile OFX Statements in Sage 300 Bank Services


  1. Open Common Services > Bank Services > Bank Transactions > Reconcile OFX
  2. Enter the code for the bank you are reconciling, or use the Finder to select it.
  3. Press Tab.  The Reconcile OFX Statements screen displays transactions from the imported OFX file that were processed by the bank before the reconciliation cutoff date.
  4. Fill in the following fields on the Reconcile OFX Statements screen:
    • Reconciliation Date.  The reconciliation date determines the year and period to which the reconciliation is posted. (The year and period are displayed in the field to the right.)  You must use a reconciliation date that is later than the one used when you last reconciled the bank account.
    • Reconciliation Cutoff Date.  Imported transactions must have cleared the bank by the cutoff date to be included in a reconciliation.  You can reconcile only transactions posted in Sage 300 to a date no later than the reconciliation cutoff date, including outstanding transactions posted to earlier fiscal periods.  When you leave the Reconciliation Cutoff Date field, the display changes to show transactions processed up to and including the specified cutoff date, for the specified
      year and period.
    • Automatically Clear Reconciled Transactions.  When you select this option, then click Reconcile, automatically matched transactions are immediately cleared from the table, leaving only transactions that you must reconcile manually.  This option can save you time if you have many transactions to reconcile. However, if more than one transaction uses a given amount, it is best not to select the option, to ensure that you clear the correct entry.
    • Match Deposits By.  You should select the method that is consistent with the presentation of deposits on your bank statement:
      • Transaction. Reconcile each receipt or receipt-related amount.  If your bank statement does not include details of individual receipts, do not select
        Transaction because the Reconcile OFX Statements function will not be able to
        match receipt amounts automatically to amounts on the bank statement.
        • 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).
      • Deposit Slip. Reconcile one amount for each deposit slip. While reconciling by deposit amount is generally faster, if there was a keying error or some other problem that caused the bank to report a different deposit amount than you recorded in Sage 300, you must reconcile each receipt amount manually.
        • Note:  Depending on whether you match by deposit slip or transaction, comments included in the OFX file are handled as follows:
          • When matching by deposit slip. If there is a comment in the OFX file, it is
            entered in Reconciliation Description for both the deposit and all receipts in the deposit.
          • When matching by transaction. If there is a comment in the OFX file, it is
            entered in Reconciliation Description for the related receipt only.
  5. Click Reconcile to match OFX statement transactions to Sage 300 transactions, and then close the message box that appears when matching is finished. For more information, see
    “Matching OFX Transactions to ERP Transactions” (page 47).  The Cleared status for matched transactions changes to Yes. However, if you selected the Automatically Clear Reconciled Transactions option, only unmatched transactions appear on the table.  You must clear unmatched transactions manually.
  6. Clear unmatched transactions you identify as bank entries (for example, bank service charges that you have not yet entered in your Sage 300 system).
    1. Select the transaction on the grid, and then click the Bank Entry button.  The Bank Entry screen appears.
    2. In the Distribution Code field, enter the distribution code (for example, Bank Error or
      Service Charge).
    3. In the G/L Account field, specify the G/L account to use.
    4. If the bank entry is taxable, select the Taxable option, click the Zoom button, and then enter tax information on the Taxes form that appears:
      1. Select the tax group to which your company is subject.
      2. Change the entries in the table if required, and then click Close to return to the
        Bank Entry screen.
    5. Enter a description, reference, and comment, as needed.
    6. Click Process, and then click Yes when prompted to add this transaction to bank entries.
    7. Click Close to return to the Reconcile OFX Statements screen.
  7. Clear other unmatched transactions.
    1. Select the transaction on the table, and then click Clear.  A Detail screen appears.
    2. Select the matching detail on the table, click Clear, and then click Yes to confirm the
      match.  Be sure you select the correct line, as there may be more than one detail with the same amount or date.
    3. Click Close to return to the Reconcile OFX Statements screen.
  8. You can click Refresh to remove all cleared items from the table. (Removing cleared items from the table is optional.)  The only items remaining on the table will be unmatched items that you did not clear manually. (Their Cleared status is No.)
  9. Close the Reconcile OFX Statements screen.  If a message appears asking whether to process the entries now, click Yes.