Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

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:

 Lettings/Rentals EOM report

Click Lettings/Rentals

In Reporting and Analysis, select End Of Month Report

 Sales Trust Accounts EOM 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

If required, the cashbook report can also be included in the draft report. Ensure Include Cashbook is ticked.

Generating a cashbook report will increase the amount of time the report takes to produce.

See 3a for notes on exporting the cashbook report to Excel


The Trust Account Balance, Adjusted Balance and Cashbook Balance should all be the same

If they are not, there is an issue that you must investigate further and, if required, contact Reapit Support

Until the issue is resolved, there should be no further changes made to the system

 3a. Exporting the cashbook report to Excel

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 

The final report will not display the word Draft

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 

The cashbook report can be exported as a CSV file and viewed in Excel - see 3a for more information

While the End of Month reports are running, a lock will be set against the system, preventing users from creating or amending any transactions - this is to ensure the balances remain static whilst the report is being calculated

Once the report has finished generating, the lock will automatically be released and users can continue as normal

  • No labels