Versions Compared

Key

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

Jump to:

Table of Contents
minLevel1
maxLevel3

Trust Bank Reconciliation

Trust accounts must be reconciled to the last day of the calendar month, every month, within 14 business days of the last day of the month. 

For larger firms, it may be practical to reconcile more frequently, for example weekly.  
To reconcile select the trust icon (the red courthouse) from the top menu bar.    Image Removed

...

From the trust register, select the 'Bank Rec' button. Image Removed

...

The 1st trust bank reconciliation screen will appear. From here:

...

From here the user works from a printed bank statements and reconciles what movements have occurred within the trust bank account and what has been recorded in Wise Owl Legal.
A transaction can be reconciled by clicking the transaction line or by hitting the space bar.  Image Removed

...

Transactions can be sorted by date, transaction, ref #, amount and cleared. Using a combination of 'sort by' filters can be most effective in the reconciliation process. 

Whilst the default 'sort by' is date, sorting by date alone can be problematic as trust cheques are not usually written on the same day as they are presented to the bank. 
To overcome this it may be useful to 'sort by' Ref # or amount.   Image Removed

...

A summary screen is displayed at the bottom of the page, and shows all the amounts cleared. This summary highlights the amount of any variance.   Image Removed

...

A useful function is the 'mark all' and 'unmark all' buttons. Please note that these buttons only apply to each specific type of transaction (e.g. all payments, receipts or adjustments). 
Therefore to mark all items on the bank reconciliation, you will need to select 'Mark All' for all three categories. 

Each month there may be adjustments necessary. Select the adjustments button from the top of the bank reconciliation screen.   Image Removed

...

If applicable enter the transaction reference number, cheque or receipt number, to not only assist with matching up the adjustment next month, but also for the auditing process. 
At any point the bank reconciliation can be closed by selecting the 'Back to Trust Register' button. 
All transactions are saved at this point, allowing the bank reconciliation to be later resumed at its current state. Image Removed

...

 Be sure to thoroughly check the bank reconciliation report before rolling to the next period. Before finalising the reconciliation check for:

...

 
The 'Complete Reconciliation' button is only available when the bank statement balance is in agreement with the calculated closing balance on Wise Owl Legal.
Make sure to run the reports for Trust EOM at this point in time; including the bank reconciliation, the trust trial balance, the cashbook, and the client accounting ledger for trust only.

An interim bank reconciliation report can be printed by opening up the in progress bank reconciliation, through Trust Accounting > Bank Rec > Continue Bank Reconciliation.
Then selecting the  browsers print function: either by right clicking and selecting print or selecting print from the top menu bar.  Image Removed

...

This report will be displayed with an 'In Progress' watermark.

...

 Bank reconciliation reports can be printed at any time, not just upon completion of the bank reconciliation, through the reports tab.  Image Removed

...

 A new tab will open with the Trust Bank Reconciliation.

...

 To print reports 2-5 click the reports icon from the top menu bar.        Image Removed

...

Click on the necessary report from the list.
Enter the date parameters if prompted. Make sure to select the dates of the first day of the month to the last day of the month (EXACTLY the same as the closing date used on the bank reconciliation).
The Reports then need to be checked to ensure that the bank reconciliation was completed correctly.

...

  • The Trust Matter ledger balance equals the Trust Trial Balance.

  • This amount also equals the Cash book Balance on the Bank Reconciliation.

  • The cash receipts and payments reports must equal the figures for receipts and payments on the Bank Reconciliation for that same period.

  Image Removed

...

Additional Resources:

How to check your Trust Bank Reconciliation
Trust Accounting - New Adjustment