Versions Compared

Key

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

Info

This guide has been reviewed against our global client base and classed as relevant to the following regions: UK, APAC, UAE

The Bank Reconciliation screen displays all items that have been receipted previously, with Statement Items on the left displaying details of the statement and Transactions on the right showing the items to be reconciled.

From the main menu, click Lettings/Rentals, select Daily Accounts Processes and select Bank Reconciliation option:

1. Bank Reconciliation screen

  • To speed up the reconciliation process, all items that match with the statement are automatically ticked, meaning that the un-ticked items cannot be reconciled at this time as they do not appear on the statement

  • By the end of each day, all All items on the left should be reconciled; items on the right may be un-reconciled , but only money out (cheques not cashed, BACS/ABA payment not cleared)as the payment is still waiting to leave the bank

  • To process the selected entries, click Post (bottom right of screen)

2. Produce as an Excel spreadsheet

  • Click Print (bottom right of screen)

  • Click Yes to include un-reconciled entries then select Excel Export and click Accept

    An example spreadsheet is shown on the right

  • This report cannot be reproduced 
    Before closing the spreadsheet, it should be saved locally

    Close Excel and exit the Bank Reconciliation screen


3. Client/Trust Account Reconciliation

From Lettings/Rentals option on the main menu:

  • Click Client/Trust Account Reconciliation

    An example spreadsheet is shown on the right

  • Both the Balance and Statement Balance (shown at the bottom of the screen) should match

    This figure should also match the physical bank statement

  • This report is not automatically saved
    Before closing the spreadsheet, it should be saved locally




Filter by label (Content by label)
showLabelsfalse
max5
spacescom.atlassian.confluence.content.render.xhtml.model.resource.identifiers.SpaceResourceIdentifier@a45
showSpacefalse
sortmodified
reversetrue
typepage
cqllabel = "bankrec" and type = "page" and space = "RW"
labelsbankrec

Page Properties
hiddentrue


Related issues