Reconcile OFX Statements
Overview
Generally, to reconcile a downloaded OFX statement you:
-
Download your bank or credit card statement from your financial institution's Web site in Open Financial Exchange (OFX) format.
-
Use the Import OFX Statements form, in Bank Services, to import the downloaded statement into Sage ERP Accpac.
-
Use the Reconcile OFX Statements form to:
-
Match transactions from the OFX file to transactions in Sage ERP Accpac.
-
Enter bank transactions.
-
Manually clear or write off any unmatched transactions.
-
Check the Summary tab of the Reconcile Statements form to ensure that the ending balance from the bank statement matches the ending bank balance in your Sage ERP Accpac system.
-
Print the Withdrawal Status and Deposit Status reports, which are not available after you post the bank reconciliation.
-
Post the reconciliation (using the Post Reconciliation form).
Before you start
-
Download your bank or credit card statement in OFX format from your financial institution's Web site.
To reconcile OFX statements:
-
Open Common Services > Bank Services > Bank Transactions > Reconcile OFX Statements.
Click here for help on the fields in the Reconcile OFX Statements form.
The Reconcile OFX Statements form displays transactions from the imported OFX file that were processed by the bank before the reconciliation cutoff date.
-
Fill in the following fields on the Reconcile OFX Statements form:
Automatically Clear Reconciled Transactions
-
Click Reconcile to match statement transactions to Sage ERP Accpac transactions, then close the message box that appears when matching is finished.
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 grid.
You must clear unmatched transactions manually.
-
To clear unmatched transactions you identify as bank entries (for example, bank service charges that you have not yet entered in your Sage ERP Accpac system):
-
Select the transaction on the grid, and then click the Bank Entry button.
-
In the Bank Entry dialog box that appears:
-
In the Distribution Code field, type the distribution code (for example, Bank Error or Service Charge), or use the Finder to select the code.
-
To use a different G/L account than the default that appears, use the Finder for the G/L Account field to select the account.
-
If the bank entry is taxable, select the Taxable option, click the Zoom button, then enter tax information on the Taxes form that appears.
-
Select the tax group to which your company is subject.
-
Change the entries in the grid if required, then click Close to return to the Bank Entry dialog box.
-
Enter a description, reference, and comment, as needed.
-
Click Process, and then click Yes when prompted to add this transaction to bank entries.
-
Click Close to return to Reconcile OFX Statements.
-
To clear other unmatched transactions:
-
Select the transaction on the grid, and then click the Clear button.
-
In the Detail dialog box that appears:
-
Select the matching detail on the grid, click Clear, and then click Yes to confirm the match.
-
Click Close to return to Reconcile OFX Statements.
Be sure you select the correct line, as there may be more than one detail with the same amount or date.
-
Click Refresh to move all cleared items from the grid (optional).
The only items remaining in the grid will be unmatched items that you did not clear manually. (Their Cleared status is No.)
-
Close the Reconcile OFX Statements form.
If a message appears asking whether to process the entries now, click Yes.
After using the Reconcile OFX Statements form
-
Check that the statement date, reconciliation date, and reconciliation posting date are correct.
-
Check that the transactions you processed using the Reconcile OFX Statements form appear on the Reconcile Statements form (if you matched deposits by deposit slip) or the Deposit Details form (if you matched deposits by transaction).
-
Continue at Step 4 of the Reconcile a Bank Account instructions.