Versions Compared

Version Old Version 5 New Version 6
Changes made by

Tamzin Stone

Tamzin Stone

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Completing the Bank Reconciliation

...

  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

...

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

...

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

...

1Go to Period Close menu, then click on Bank Reco Search.Image Removed
1

Go to Period Close menu, then click on Bank Reco Search.

Image Added


Select your search filters. These can either be one or a combination of the following

  • Bank Account
  • Date
  • Only Unverified Statements

Click 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

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

If there is one started, highlight and Select the relevant reconciliation

If not, to also see Verified statements untick the "Only Unverified Statements" box, enter

a Date From and Date  at

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

Image Addedat the bottom of the screen

Select your search filters. These can either be one or a combination of the following

  • Bank Account
  • Date
  • Only Unverified Statements

Click Search


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 
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
Image Removed

Image Added


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


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


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


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 

selected with a Yes

 will

 will be at the top of the screen and those lines that have not been

selected 

selected with a

No 

No will be lower down


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


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

entries by clicking on Period Close, then on Bank Reco Search


Once you have ticked off  said Yes to every item that is showing on your bank statement the

box

field showing 

Variance 

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

Contact your TOORS support personnel at your local conference office if you need further assistance


Once the Variance of $0.00 shows on the bank reconciliation screen, click Save


Click the Print button to print the reconciliation report


This process must be completed for each bank account, each month