Month End Trust Reconciliation Package Checklist

1. Cover page (optional word document)
2. Bank Reconciliation
   • Bank Statement Date - end of reconciling period.
   • Enter balance as per generate bank statement - should be zero difference.
   • Scroll down and click on submit above changes.  
   • Click on 'return to previous page' - view bank reconciliation report and download PDF. 
   • The 'Out By' should be zero.
   • Download PDF and save
   • Click 'Update Bank Reconciliation'. (only click this at month end)
      
3. Bank Statement - as per latest download.
4. Reconciling items - Bank Reconciliation Reports 
   • Select Date range, one of the below report types, click Generate Report, repeat for the rest.
     1. Cheque Register
     2. EFT Register
     3. Deposit Register
     4. Adjustments
   • Tick 'show unpresented amounts only', one of the below report types, click Generate Report, repeat for the rest
     1. Cheque Register - Unpresented Cheque
     2. EFT Register - Unpresented EFT & BPAY.
5. Cashbook
   • Accounting Reports - cashbook.
   • Select reporting period for the month.
   • Select by Bank Account rather than per Property.  
6. Bank Balance
   • Accounting Report - Partitioned/Simple Bank Balance. 
   • Select reporting period for the month. 
7. Aged Debtors Report for Deposits (Optional)
   • Accounting Reports - Aged Debtors
   • Reports as at: last day of month. 
   • Select deposits property - run report.
8. Unallocated cashfor remaining deposits that have not been allocated to charges
   • Management Reports - Excel Report - Tenants with Receipts not yet allocated. 

Double check that Bank Reconciliation Report matches to all Reconciling Items