Bank Reconciliation - daily process

1. Bank Reconciliation screen

Open

• To speed up the reconciliation process, all items that match with the statement are automatically ticked, meaning that the un-ticked items cannot be reconciled at this time as they do not appear on the statement
  
  

• All items on the left should be reconciled; items on the right may be un-reconciled as the payment is still waiting to leave the bank
  
  

• To process the selected entries, click Post (bottom right of screen)
  
  

2. Produce as an Excel spreadsheet

• Click Print (bottom right of screen)
  
  

• Click Yes to include un-reconciled entries then select Excel Export and click Accept
  An example spreadsheet is shown on the right
  
  

• This report cannot be reproduced 
  Before closing the spreadsheet, it should be saved locally
  Close Excel and exit the Bank Reconciliation screen

3. Client/Trust Account Reconciliation

From Lettings/Rentals option on the main menu:

• Click Client/Trust Account Reconciliation
  An example spreadsheet is shown on the right
  
  

• Both the Balance and Statement Balance (shown at the bottom of the screen) should match
  This figure should also match the physical bank statement
  
  

• This report is not automatically saved
  Before closing the spreadsheet, it should be saved locally