How To: Running First Time Reconciliation (15-91-07)
Overview
This selection allows first-time users of Bank Reconciliation (15-50) to easily reconcile previous bank account postings. It should be run before using G/L Bank Reconciliation.
To avoid reconciling account postings one by one, a through date is entered (up to 10 years prior) to reconcile all account postings that fall in that time period.
After running this selection, you will only need to use Bank Reconciliation to reconcile postings from the date entered, plus postings from the current month and future months, if any.
Step-by-Step
- In the ‘Employee Number’ field, enter your Employee Number.
- In the ‘Account to Reconcile’ field, enter the 12-digit G/L account number being reconciled.
- In the ‘Through Date’ field, enter the last day of the cleanup period.
NOTE: If bank reconciliation has been kept up-to-date off Tyler, consider the checks that have not cleared the bank and for which month. Use this information when setting your ‘Through Date’ to allow for non-reconciled checks to display in G/L Bank Reconciliation (15-50).
For example, if bank reconciliation has been kept up to date through October 2017, but you have checks that have still not cleared from August or September, set the ‘Through Date’ field to “07/31/2017.” You will need to manually clear the data for August and September in G/L Bank Reconciliation (15-50); however it will give you a chance to not flag those checks that have not cleared, allowing them to roll over.
If you are reconciling up to the current month, another option for non-reconciled checks is to make a note on the first bank reconciliation that these checks have not been cleared.
- Click the ‘Ok’ button.
- At the completed prompt, click ‘Continue.’