Daily Bank Reconciliation Reports

The reports listed below should be generated daily during the trust reconciliation process and should be approved by the licensee.

Three Way Balance Report

The Three Way Balance Report should look like the image below and the figures shown in 1, 2 and 3 should all be equal to result in $0.00 as shown in 4 in the Variance Area

Trust Reconciliation Report

1. In Menu Search type Trust Reconciliation and select Reports, Owner Accounting and Trust Reconciliation
2. Select By Date Range - we need to set the dates for this report to reflect the trust period that is being reconciled - i.e. if you are reconciling on the the 10th then the date range will be set from the 1st - 10th
3. Build

Items to check on this report

On the last page of the Trust Reconciliation Report:

1. Please ensure this report balances before continuing.  If any Area does not balance, there will be an X to the right margin of the Area and also on the Grand Total row

• The Closing Balance (1) and MHIT figure (2) for each Area must be the same

Column B total should equal the Total Credits on your Trust Cash Book and Columns C, D, E, F & G combined should equal the Total Debits on your Trust Cash Book.

If they don’t, please log an urgent support request for a Homhero/RMS Trust Account Specialist to contact you. 

Monies Held in Trust Report

1. In Menu Search type Monies Held In Trust and select Reports, Owner Accounting and Monies Held In Trust
2. Enter the date for which you are reconciling
3. Build
   Optional: To view your report where monies held in trust is grouped by each property and reservations display in number order - select Sort By: Reservation No and Group By Area

On the last page of the Monies Held in Trust Report, the Total should equal the amounts on your Three Way Balance Report

Cash Book Report

1. In Menu Search type Cash Book and select Reports, Owner Accounting and Cash Book
2. Select By Date Range - we need to set the dates for this report to reflect the trust period that is being reconciled - i.e. if you are reconciling on the the 10th then the date range will be set from the 1st - 10th
3. Build

The credit column total (1) should equal the Cash Receipts Total from the Three Way Balance Report

The debit colum total (2) should equal the Cash Payments Total from the Three Way Balance Report