If your bank if offers online services and supports the Open Financial Exchange (OFX) data format, you can download bank statements for reconciliation in Sage HRMS Payroll. (Follow the instructions on the bank's website to download your statements.)
Before Downloading OFX Statements
- Make sure your administrator assigned you the security rights to Import Bank Services Data and Reconcile Bank Statements.
- In the Banks window, for each bank for which you plan to download statements, check that the correct numbers are entered in the Bank Account Number field (with no punctuation, no dashes, and no spaces) and in the Transit Number field (except for credit card accounts).
After Downloading an OFX Statement
- You use the Import OFX Statements window to import the statement into your Sage HRMS Payroll database.
- You use the Reconcile OFX Statements window to reconcile the downloaded statements.
Currency Concerns
In a multicurrency Sage HRMS Payroll system, the default currency for your downloaded bank statement must be the same as the statement currency or one of the source currencies specified for that bank in your Sage HRMS Payroll system.
In a single-currency Sage HRMS Payroll system, you use the Currency Rates table to specify exchange rates between your company's functional currency and the OFX statement's transaction currencies. You should specify exchange rates for each transaction's posting date. This way, if any imported transactions are unmatched due to currency differences, the program can convert them to your functional currency and enter them in the Reconcile Statements window, so that you can clear the transactions manually.