Importing a Bank Statement into Your Client/Trust Account

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: File formats vary, so we have a mapping feature to allow you to match your format to be imported without editing the CSV file)
  
  

OFX stands for Open Financial Exchange, a format specifically designed for financial data transfer. Here's why it stands out:

• Each transaction within an OFX file includes a unique identifier (ID).
• Re-Leased tracks these IDs, allowing the software to detect and ignore duplicate transactions.

This means that if you inadvertently import the same bank statement more than once, or if you attempt to import statements that contain previously recorded transactions, Re-Leased will recognise the repetition and maintain the integrity of your records by discarding duplicates.

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. Click on View bank statements to the right of the page under Bank Statements.
4. Press the Import Bank Statement button.
5. Select the correct Bank Statement Format.
6. Choose the appropriate Client / Trust Account from the Account drop-down list.
7. Click Choose File to browse and select your bank statement file, typically found in your downloads folder.
8. For certain file types, choose a date format and input the statement's start and end dates. 
9. Click Submit to complete the import process.

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