Limit Transactions on Reconciliations

We added a feature to limit the number of transactions that will load on a new Reconciliation document.  The purpose of this feature is to allow you to reconcile an account that exceeds the number of line items that RIMSS can process on a Reconciliation.  This situation typically occurs when an account has not been reconciled after a number of years.  Our recommendation is to Limit Transactions prior to selecting the G/L account on a Reconciliation that may exceed 10,000 line items.

To use the Limit Transactions feature, navigate to: Banking > New > Reconciliation

Prior to selecting the G/L account, click on the option to Limit Results.  After selecting Limit Results, add your G/L account.  

The sytem will pull the oldest 10,000 unreconcilied transactions in the account and will stop including line items on a specific date rather than at the 10,000 limit.  This may create a situation where you have total number of line items that is less than 10,000.  You can verify the date of the last unreconciled transaction in the grid to determine if your list was limited.

You can now reconcile your account as normal keeping in mind that any transactions posted after the last date listed are not yet available to be included.  You may need to complete multiple reconciliations before the number of line items remaining is less than 10,000 and you are able to fully reconcile to the current date.

As you work on the reconciliations, you may need to use the feature to Save and Finish Later. Every time that you open the reconciliation, you will need to select to Limit Results prior to selecting the G/L account.

Once the number of unreconciled line items is below the 10,000 line threshhold, the system will populate all unreconciled items whether or not you select to limit results for the account.  This allows you to use the feature even if you are not sure if it will be needed.