Importing a Bank Statement into Your Client/Trust Account

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

This article provides a guide on how to import your bank statement into your Client/Trust Account, ensuring your financial records are up-to-date and accurate. We'll cover the supported file types and the process for both automatic and manual imports.

Supported File Types for Import

Re-Leased supports various file types for bank statement imports:

  • OFX (recommended type)
  • QIF
  • TXN
  • CSV (Note: CSV file formats vary, and not all files may be compatible. If possible, opt for other file types available from your bank.)


Option 1: Importing an Automatic Bank Statement

To import a bank statement file:

  1. Download the transaction file from your bank in one of the above formats.
  2. Navigate to Client / Trust Accounts on the main menu.
  3. Select the appropriate Account, if you manage multiple Trust Accounts. This can be changed by selecting Switch account next to the Account Name.
  4. Click on View bank statements to the right of the page under Bank Statements.
  5. Press the Import Bank Statement button.
  6. Click Choose File to browse and select your bank statement file, typically found in your downloads folder.
  7. Select the correct Bank Statement Format.
  8. For certain file types, choose a date format and input the statement's start and end dates. We recommend importing statements one day at a time.
  9. Click Submit to complete the import process.

import statement.gif

Option 2: Manual Bank Statement Upload

If you're unable to obtain a bank file, you can manually upload a bank statement by following these steps:

  1. Access your Client / Trust Accounts page.
  2. Ensure the correct Account is selected. This can be changed by selecting Switch account next to the Account Name.
  3. Click on View Bank Statements to the right of the page under Bank Statements.
  4. Click the Manual Bank Statement option at the top of the page.
  5. For each transaction on your bank statement, enter the following details:
      • The date of the transaction.
      • Name/memo/reference (fill in at least one of these fields or use more for additional detail).
      • An amount in either the spent or received column.
  6. Click on Add Transaction to insert more entries.
  7. Verify the Closing Balance matches the figure on your bank statement.
  8. Check the box to confirm the accuracy of the statement and its impact on your Account balance in Re-Leased.
  9. Finally, click Save Statement to finalise the manual entry and continue receipting.

manual statement.gif


Was this article helpful?