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 all regions

...

1. Access option from main menu & select client account

From the main menu:

  • Click Estate

  • Select Daily Accounts Processes

  • Click Bank Reconciliation

  • Select the appropriate client account from the list and click Accept

Image RemovedImage Added

2. Bank reconciliation screen

When opening the bank reconciliation screen, you are presented with two lists of transactions, split into different sections of the screen

The right-hand side represents transactions within the system and the left shows your bank account

  • This process is done to mark payments as cleared and reconciled before funds can be processed out of the system

  • Selecting an item on one side of the screen will highlight the corresponding item on the other side, making it clear what matches

  • With receipted payments, it is likely that they will already be ticked
    Payments going out, shown as negative amounts on the bank statement items list, will not be ticked by default as you need to check the values are as expected (and match on both sides), before posting

Tip

Balance brought forward (Balance B/fwd) and the Reconciled Balance as well as total debits, credits and the grand totals are shown at the bottom left of the screen

3. Post entries

  • To process the selected entries, click Post (bottom right of screen)
    Green ticks will be displayed next to the reconciled items

  • Click OK

4. Produce reconciliation report (export to Excel)

A reconciliation report should then be generated and saved for future reference - this allows transactions to be tracked to the last point everything was correctly reconciled

  • Click Print (bottom right of screen)

  • Click Yes to include un-reconciled entries

  • Select Excel Export and click Accept

Image RemovedImage RemovedImage AddedImage Added

5. Save report

An example format report is shown below

Note

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

  • Close Excel and exit the Bank Reconciliation screen
    This completes the process of bank reconciliation

Filter by label (Content by label)
showLabelsfalse
max5
spacescom.atlassian.confluence.content.render.xhtml.model.resource.identifiers.SpaceResourceIdentifier@a45
sortmodified
showSpacefalse
reversetrue
typepage
cqllabel = "est-dailyprocess" and type = "page" and space = "RW"
labelsest-dailyprocess est-accounts est-mgt
Excerpt
hiddentrue

The Bank Reconciliation screen displays all items that have been receipted previously - the Statement Items panel displays details of the statement and the Transactions panel shows the items to be reconciled

...