End of Month (EOM) Report

Owned by Fiona Wilson
Last updated: Jul 15, 2022
4 min read

This guide has been reviewed against our global client base and classed as relevant to all regions

The guide explains how to run the End of Month (EOM) and Cashbook report

The report must be run on the first working day of the month, as soon as you have imported and reconciled the last day of the month.

On the first working day of the month, ensure you have imported and reconciled all items from the previous month. There should be no items from the current month imported into AgencyCloud

1. Launching the report screen

The report can be run for both Sales Trust Accounts and/or Lettings/Rentals, as follows:

Click Lettings/Rentals

In Reporting and Analysis, select End Of Month Report

Click Property

In Trust Accounting, select Reporting and Analysis, then End Of Month Report

  • Selecting the End Of Month Report option from either menu option displays the screen shown on the right

 

Previously run EOM reports can be accessed from the bottom section of the screen - double-click to open or right-click for a quick print option

2. Ensure Draft mode is selected

From the top section of the screen:

  • If prompted, select the relevant Trust Account

  • Run the EOM in Draft mode

  • Leave Include Cashbook un-ticked 

  • Click Proceed

3. Review the EOM Report

A draft version of the EOM report will be available for review

  • Check that the account reconciles and review the subsequent pages for further details of the balances held

  • Once you are satisfied the report is correct, close the PDF

  • A final report should now be run for sign off

 



A configuration option is available which creates the cashbook report as CSV file, instead of a PDF - this is useful when very large amounts of data are involved - the CSV file option automatically exports the cashbook to Excel

To enable this configuration option, click here to contact Reapit Support

4. Run the Final EOM Report

  • If prompted, select the relevant Trust Account

  • Run the EOM in Final mode

  • Ensure Include Cashbook is ticked 

  • Click Proceed

 

5. Final EOM Report

  • The final EOM Report will be produced and should be signed as per legislation
    The closing balance will now be stored in the system, and carried over to the following month

  • The final report is automatically saved and can be retrieved from the main screen, as shown in step 1 

 

6. Final Cashbook report

A breakdown of the cashbook balances for that month will be displayed

  • The final report is automatically saved and can be retrieved from the main screen, as shown in step 1 

 

Â