Info |
---|
This guide has been reviewed against our global client base and classed as relevant to all regions |
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
1. Access option from main menu & select client account From the main menu: | EstateBlock Select Daily Accounts Processes Click Bank Reconciliation Select the appropriate client account from the list and click Accept
| Image Removed |
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 |
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 |
|
Related articles
Filter by label (Content by label) |
---|
showLabels | false |
---|
max | 5 |
---|
spaces | com.atlassian.confluence.content.render.xhtml.model.resource.identifiers.SpaceResourceIdentifier@a45 |
---|
sort | modified |
---|
showSpace | false |
---|
reverse | true |
---|
type | page |
---|
cql | label = "est-dailyprocess" and type = "page" and space = "RW" |
---|
labels | est-dailyprocess est-accounts est-mgt |
---|
|
Excerpt |
---|
|
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 |
...