Versions Compared

Key

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

...

If you use another system, consult with your client accountant/software provider on how to produce the required reports

If you have any covering sheets or additional reports that you produce in addition to the reports from your system, these should be included in your submission

If your existing system is manual (e.g. Excel, Sage, etc.), a sample reconciliation report is included below, showing an example of the information required

View file
nameRPS-Sample-Reconciliation.xlsx

CFP

There are two reports you need to produce from CFP:

Reconcile Balances Report

The Reconcile Balances Report is a breakdown of all of the balances in CFP - there should be no negative balances in the Cash Client Account or Cash Book Balance columns on this report

Image RemovedImage Added

Bank Reconciliation Report

The Bank Reconciliation Report is produced when the bank account is reconciled; it should have a figure matching to the bank statement on the same day. There should be no unreconciled credits showing on this report. Unreconciled debits are not a problem, but any dating back several years should be reviewed.

There are two important figures on this report:

  • Balance Carried Forward - this figure should match your bank statement

  • Report Cash Book Balance Calculated - this figure should match the Reconciled Balances total on the Reconcile Balances Report

Vebra

Landlord Bank Balance

The Landlord Bank Balance Report needs to be provided from Vebra - Reapit may also contact you to connect to your Vebra database in order to obtain additional reconciliation information

Image RemovedImage Added

Gemini

The following three reports are required from Gemini.

Account Totals Report

The Accounts Totals Report lists the balances for all your landlords and tenants.

Image RemovedImage Added

Cashbook Report

The Cashbook Report lists the unreconciled items. There should be no credits showing.

Image RemovedImage Added

Holding Account Report

You need to produce a breakdown of all balances in the Holding Account. This may need to be manually produced

Jupix

The Trial Balances Report is required from Jupix. There should be no negative cash balances or unreconciled credits showing.

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" , "bankrec" ) and type = "page" and space = "RW"
labelsreporting-accounts bankrec

...