For our Asia-Pacific customers, the term "Trust Account" is used, while European customers refer to it as "Client Account". It's important to mention that the Client/Trust Accounting functionality does not apply to customers in North America. For further information on regional terms, check out our Glossary of Regional Terminology.
Efficiently manage your Client/Trust Account records by importing bank statements for one or several accounts at once using a CSV file. This guide will walk you through preparing your file, mapping your data, and finalizing the import process in Re-Leased, while ensuring the reconciliation is seamless, even during simultaneous disbursements.
Check out Section 9 of our self-guided learning video for an interactive demo: Settings for Trust Accounts
For our European users, see Settings for Client Accounts (EMEA)
Preparing Your CSV File
If you're wanting to import statements across multiple bank accounts, you'll need a CSV file that contains the bank account numbers alongside transaction details. It's essential that the bank account numbers in your CSV file match those linked to your Client/Trust Accounts in Re-Leased for accurate importation.
If you're only importing transactions for a single bank account this information is not required, as you'll be asked to select a bank account during the import process.
Starting the Import Process
To kick off the import process:
- Navigate to the Client/Trust Accounts tab and click View bank statements.
- Click the Import Bank Statement option.
- Choose the appropriate CSV file from your files to begin the process.
- Select Create new mapping to specify how the CSV data corresponds to your Client/Trust Account records.
Mapping Your CSV File
During the mapping phase:
- Input the details of your mapping to determine which CSV column aligns with each field in Re-Leased.
- Save the mapping settings for efficient future imports—it’ll save you time on the next upload, as you can simply select it from the CSV mapping dropdown.
Note: If the bank account number in your CSV file is within a single column, mapping it to one of the account code fields will suffice for the import to recognize it.
Finalizing Your Import
If you imported multiple bank statements in one go, they will be uploaded and stored in a "Pending" state. This stage is crucial as it allows for appropriate reviews and approvals, specifically in scenarios where a disbursement might be concurrently in process. Once your statements have been duly reviewed and approved, you can move ahead with the reconciliation steps.