Importing Bank Statements for Multiple Client/Trust Accounts

  • Updated

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 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.


Preparing Your CSV File

Before you begin, 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.

 

Starting the Import Process

To kick off the import process:

  1. Navigate to the Client/Trust Accounts tab and click View bank statements. 
  2. Click the Import Bank Statement option.
  3. Choose the appropriate CSV file from your files to begin the process.
  4. Select Create new mapping to specify how the CSV data corresponds to your Client/Trust Account records.

 

Copy of HelpCentre_Desktop Landscape_Static  (81).jpg

 

Mapping Your CSV File

During the mapping phase:

  1. Input the details of your mapping to determine which CSV column aligns with each field in Re-Leased.
  2. 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.

 

Copy of HelpCentre_Desktop Landscape_Static  (82).jpg

Finalizing Your Import

After mapping your data, your bank statements 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.

 

Copy of HelpCentre_Desktop Landscape_Static  (84).jpg

Was this article helpful?