Versions Compared

Key

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

...

1. Launching the report screen

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

Expand
titleLettings/Rentals EOM report

Click Lettings/Rentals

In Reporting and Analysis, select End Of Month Report

Expand
titleSales 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

Image RemovedImage Added
Tip

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

Image RemovedImage Added

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

Tip

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


Image RemovedImage Added
Note

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

Expand
title3a. 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

Image RemovedImage Added

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 

Tip

The final report will not display the word Draft

Image RemovedImage Added

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 

Tip

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

Image RemovedImage Added
Info

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

Filter by label (Content by label)
showLabelsfalse
max5
spacescom.atlassian.confluence.content.render.xhtml.model.resource.identifiers.SpaceResourceIdentifier@a45
sortmodified
showSpacefalse
reversetrue
typepage
cqllabel in ( "reporting-accounts" , "eom-report" ) and type = "page" and space = "RW"
labelstobereviewed trustaccts

...