1. On the accounts ribbon, click ‘Import Periodic Interest.’
2. Select the IBD account from the drop-down menu
3. Select date
4. Click the open to locate downloaded bank file (the format and name will differ between the different banks)
5. Select file and click ‘Open’
Interest transactions as per the bank file will display on the ‘Import Periodic Interest’ screen.
(There may be a slight delay before the data is displayed on the screen, depending on the number of records being read in).
The bottom left hand corner of the ‘Import Periodic Interest’ screen will provide details of unmatched items (if any) and totals are displayed to the right.
If a yellow triangle warning is shown in the column between the ‘Compound’ and ‘Message’ columns then there are unmatched items in your list. Unmatched items are entries where the bank records don’t match OneLaw records for a specific IBD instrument number. If this warning is displayed click on the warning symbol in the column header to sort all unmatched items to the top of the list.
Example shows two accounts in the bank CSV file that haven’t found a match in OneLaw. Message column will indicate what the problem is. In this case the bank reference number in the CSV file doesn’t match with IBD instrument numbers in OneLaw.
To manually match transactions, highlight the record and click the grey cog to open the ‘Match Bank Transaction to IBD Instrument’ window.
The transaction data field is the information contained in the downloaded bank file and can be used to find the client/matter to post unmatched entries to.
In this example the IBD Instrument number in OneLaw is different to the IBD Instrument number recorded at the Bank. OneLaw number 55555555 Bank Reference is 5724.
Input client and matter number.
Use the IBD Instrument drop down to select the IBD account.
Note the message “The IBD instrument will be updated with the Bank Reference number” – this is telling you that the bank ref number (in this case 5724) will update the OneLaw IBD instrument number (in this case 55555555) to the bank reference number.
Click ‘Match’ to save the record.
Once all unmatched items are matched and you have checked and balanced your totals with the bank you can import the items to the client ledgers.
On clicking ‘Import’ a message will be displayed so you can check dates and what will be posted before you post it.
If you have ticked the ‘Withdraw Commission’ box further information will be displayed
After the import is complete a message will be displayed and each item in the list will show as ‘Imported’.
If for some reason there is an error in the import that is discovered during the bank reconciliation process, return to the Import Periodic Interest screen, choose the IBD Account and insert the date of the import - you will get a message saying an import for this date already exists, click ok to continue. Once the information is displayed, the "Delete Batch" button will come live, click this to delete the entire import and re-process.