Who is this guide for?
Accounts Users and Accounts Supervisors
The interest calculator is a tool designed to enable you to track interest due on monies held in client’s accounts.
Before the Interest Calculator can work a Supervisor level user must set up the Interest Rates and Bands in the Supervisor area of Osprey.
Set up your interest rates, bands and accrual periods
Navigate to the Supervisor area and select Financial Setup. Then click on Interest Rates/Bands. Now choose to Add Band.
Enter the information according to the details received from your bank including a lower and an upper bound, and then click Save.
For example, if you have a table which looks like the below, you would need to add 3 bands:
We can now select Add Rates.
Enter the start date and interest rate, then select the band it applies to by ticking in the relevant box. You can add as many different rates and start dates to a band as your bank have supplied you with. Osprey will calculate interest on each ledger transaction based on the rate at the time of the posting date.
Click Save to keep your changes.
E.g. In the example below, we would add 3 different interest rates:
Now, you will need to add an accrual period. Accrual periods are used by the system to decide when to calculate the interest, and are stored as a number of months. Navigate to Supervisor > Financial Setup > Interest Rates/Bands/Accrual Periods and click New:
- Bank interest is paid monthly – enter the start date (if this is the first accrual period you are adding, enter your earliest interest rate start date, otherwise enter the date when this changed), and 1 in the Accrue Period box.
- Bank interest is paid quarterly – enter the start date (if this is the first accrual period you are adding, enter your earliest interest rate start date, otherwise enter the date when this changed), and 3 in the Accrue Period box.
- Bank interest is paid annually – enter the start date (if this is the first accrual period you are adding, enter your earliest interest rate start date, otherwise enter the date when this changed), and 3 in the Accrue Period box.
Click Save when you are done.
It is possible to calculate interest on a single matter or run the Batch Interest Calculation report. Navigate to Client Ledgers and select the Interest Calculator.
The postings are listed down the page.
You need to tick the tick box under the Range heading to select a posting for calculation.
You will also have to select a posting that details the amount on which interest is to be calculated. You have to select the end date for the calculation, interest being calculated on the period from today’s date to then.
Add the rate at which tax is to be paid on this interest, then click the ‘Calculate Interest’ button.
The below screen will now appear.
This page will display relevant information in columns and rows. There is a box at the bottom of the table that displays the total amount of tax payable. You can then make a note of the Total Interest to separately post to the Client Ledger at a later point.
If you click the Printer-Friendly Screen option, a new window will open allowing you to print a copy of the results in an easily readable format. Remember to close this window after printing.
There is also a report available to show the interest due on all matters. Under the Reports tab, navigate to Financial Management and then select Batch Interest Calculation.
This report allows you to calculate interest due to all clients according to the filters you have specified. It does not post the interest on the accounts, but just lists the interest due for each transaction on each client’s ledger (along with a total due at the end). You will need to post the interest separately.
You have several filter options on this report:
Work Type – Tick this box if you want to show only one or a selection of work types. Once the box is ticked all work types marked as In Use will appear. You can then tick each one that you want to report on. If you want to see all work types, do not tick the work types box and it will produce all work types.
Fee Earner – Choose the fee earner whose clients you want to calculate interest for.
Limit – Enter the minimum interest amount to calculate. For example if £10 is entered here, only matters where the interest held is greater than £10 will be shown.
Currency – select the currency you wish to report on.
Date Filters – Enter the start and end dates that you wish to calculate interest for.
Once filtered, select Run to open your report. You can export these results to Excel or a PDF should you wish to.