Bank account synchronization and account import

This section allows you to synchronize and import a bank account.

Automatic account synchronization

This section of the software offers you the ability to automatically synchronize and import a bank account and transactions.

Here is how to proceed:

  1. Go to the Finance section, Bank Import. Click on the “New Import” or “New Synchronization” button.
  2. Select the landlord and the synchronization period (30, 60, 90 days).
  3. You will be redirected to a new page where you can enter your banking credentials and connect to your account.
  4. Follow the instructions, and select the accounts to synchronize and validate.
  5. You can manage the connected accounts from the “Accounts” section.
  6. The transactions from the connected accounts are imported into the “Transactions” section.

Transaction tally

The site retrieves transactions daily, which you will find in the “Transactions” section.

In case of a match, you will see an indicator on the right with the number of matches.

  • A green indicator 1 for exact matches.
    The amount, date, and a keyword in the imported transaction are identical to those of an existing entry. This level of match allows you to quickly validate the operation without making changes, as all information perfectly aligns.
  • An orange indicator 1 for partial matches.
    Some details match (for instance, the amount and date), but other information such as the keyword or reference is not recognized. This situation requires manual verification to confirm it is indeed the same transaction or to make any necessary corrections.
  • A grey indicator 0 if there is no match.
    None of the data from the imported transaction corresponds to an existing entry. In this case, you can either create a new line in the “Finances” section or reassign the transaction if it relates to an item that has not yet been recorded.

A match is considered exact when the amount, dates, and a keyword of the imported transaction correspond to an existing line in Finances.

Manual reconciliation

After import, you can manually reconcile the entries and add them to the Finance section by doing one of the following:

  • Confirm a match.
    When the system detects a similarity between the imported transaction and an existing “unpaid” entry in the Finances section, you can immediately validate the match to mark the payment as settled.
  • Record a payment for an existing line.
    If the transaction corresponds to an already recorded (but unpaid) expense or income in your accounting, you can enter the payment to update its status.
  • Add a new line in Finances.
    If no match is found, you can manually add a new line in the Finances section to account for the imported transaction.

When you confirm and add a transaction in Finances, an Already added indicator appears. In case of an error, you have the possibility to reset the transactions that have already been reconciled, to redo them.

Automatic reconciliation

When an exact match is found for unpaid rent, the system automatically associates the transaction and marks the rent as paid. For example, if John’s January rent of £500 has not been paid and you import a transaction from January 5th of £500 with the description “PAYMENT JOHN DOE”, the rent will automatically be set as paid and the transaction associated with that same rent.

When rent is automatically reconciled and recorded as paid, the software also sends an email notification to the landlord.

Disconnected account

Occasionally, synchronization may stop.

For security reasons, it may be necessary to identify yourself again and reconnect your account every three months. This depends on the bank.

You can also delete the accounts and the connection, and then recreate them.

Frequent Account Disconnections!

With some banks, it’s possible to change the frequency of strong authentication in the banking space. Simply set it to “90 days.”

If systematic strong authentication is required, it’s advisable to check with your bank if it can be disabled.

Delete a synchronized account

You can delete connected accounts from the “Accounts” section using the actions on the right.

When you delete an account, the system will also remove the transactions.

Manual import

This section allows you to import a bank statement in QIF or OFX format and proceed with reconciliation.

  1. Download the file provided by your bank (in QIF or OFX format).
  2. Click on the “New Import” or “New Manual Import” button.
  3. Import the file into Rentila.

After the import, you can reconcile the entries. You need to verify the data, choose the type of entry if necessary, and validate.