My Reports do not show all the records that I was expecting.
I can see unmatched G/L checks on the 'All Records' report, but when I run an 'Outstanding Check list' they don't show up.
Please check your current period. If you imported checks dated September 2018, but are running an Outstanding Check List as of August, the checks will not show up on the report.
You can verify/change your current period by going to the Reports Menu (View, Export, Actions, Current Period). If you need to change the current period, click on 'Current Period'.
Is your Reconciliation Report out of balance?
If so, please follow these steps to identify the transaction and get back in balance.
When the system attempts to run the reconciliation report, it is really running two processes:
1. It first runs a report to make sure that your current period is in balance (Ending Balance = Beginning Balance + Net Activity).
If your current period is out of balance, you'll get the 'Red Screen' and be asked to re-enter your ending balance.
Of course, if the issue is in the net activity, you should exit the report and add/delete/update your current period's transactions.
If both the Bank and G/L are in balance, it then proceeds to the next process.
2. The system then runs the reconciliation report, which is a history to date report.
If there is an 'out-of-balance', a transaction(s) in a prior period has been added, deleted or adjusted.
Note: With the introduction of our 'Stay-In-Balance' lock feature, prior periods are automatically locked.
Check to see if transactions have been introduced circumventing our security (via SQL), or if a user has unlocked prior periods.
If you cannot identify the entry, re-run the reconciliation report for earlier periods until it is back in balance. Therefore if November 2018 and earlier was in balance, and December 2018 and forward is out of balance, investigate/make the entry for December 2018.
Once you identify the entry in the prior period entry that knocked it out of balance, please update.
Note: Depending on your version, the system may prohibit you from making the entry (Stay-In-Balance lock).
You'll then need to unmark the periods as reconciled in order to make the entry.
To do so: Run the 'Periods' report (All Reports > Periods).
Select/highlight the period. On the Report sub-menu select Actions > 'Unmark Period as Reconciled'.
Repeat this unmarking for the period containing the error as well as all subsequent periods.
In the example, you would unmark December 2018 and all subsequent/future periods.
You can then make the correcting entry.
Note: In current versions of the software, we have blocked all activity to reconciled periods with our 'Stay in Balance' feature. You may want to upgrade.
Once you have made the entry, re-run the Reconciliation Report for that period (i.e., December 2018).
Then re-run all subsequent periods.