Completing the Bank Reconciliation

1. In the Period Close menu, select Bank Reco Search
   Select the Bank Account you wish to reconcile and click Search. (Cash Management Facility shows as the default). A list of Unverified bank reconciliations display on the screen
   1. Look at the bottom of the list to see if a bank reconciliation has already been started for the month required. New Cash Management Facility reconciliations are automatically started every month
   2. If there is one started, highlight and Select the relevant reconciliation
   3. If not, to also see Verified statements untick the "Only Unverified Statements" box, enter a Date From and Date To, and click Search, and check the bottom of the list. If no bank reconciliation has already been started for the month required, click New at the bottom of the screen
   
    
   
   
2. If starting a new reconciliation check the correct bank account name is showing (if not, click Bank Reco Search, select the correct Bank Account name, then click New), enter the Statement Date – the last day of the month regardless of the date of the last transaction on the bank statement
   Enter the bank balance at the end of month in the Statement Amount field
   
   
   
   
3. A list of transactions will appear in the Outstanding Transactions table below. If it is a new reconciliation, the left hand column titled "On Statement" will show No for all of the transactions

4. Look at the first item on your bank statement, and find the same amount on your outstanding transactions list.  This will always be the in the opposite column on screen to where it is on the bank statement. So if the entry is on the left hand column of your bank statement, it should show on the right hand column on your screen

5. Match each transaction against the bank statement – tick off on the hard copy bank statement the transactions that appear. On the screen click on the check boxes to include these transactions. on the No, click the drop-down arrow and click Yes for these entries
6. Click Save at any time to save the changes that you have made, this will re-arrange the screen list so that all of those which have been selected with a Yes will be at the top of the screen and those lines that have not been selected with a No will be lower down
7. If there are entries on the bank statement that are not ticked, they must be entered into the system either by income, expense or journal entry (for more information, see the relevant sections of this manual).  It is possible to finish your bank reconciliation and still have items with a No on your screen because they have not shown on your bank statement yet, but you cannot have items on your bank statement that are not a Yes on the screen
8. Always click Save on the Bank Reconciliation screen before moving to another screen – this will save your work so far. The Fee Entry, Interest Entry, Deposit Entry and Payment Entry buttons can be used as shortcut buttons to complete these entries. Return to the bank reconciliation after completing the necessary entries by clicking on Period Close, then on Bank Reco Search

9. Once you have said Yes to every item that is showing on your bank statement the box showing Variance should be $0.00.  This is what you want to see.  If it is not 0.00 you need to find out why.  A monthly report should never be finalised by doing a Period Close if a bank reconciliation does not show a zero in the Variance box. Contact your TOORS support personnel at your local conference office if you need further assistance

10. Once the Variance of $0.00 shows on the bank reconciliation screen, click Save
11. Click the Print button to print the reconciliation report
12. This process must be completed for each bank account, each month