Automatic Account Synchronisation
This section of the software allows you to automatically synchronise and import a bank account and its transactions.
- Go to the “Finances” section and click on “Bank Import”. Then select “New Import” or “New Synchronisation”.
- Select the owner and the synchronisation period (30, 60, or 90 days).
- You will be redirected to a secure page where you can enter your banking credentials and connect to your account.
- Follow the instructions, choose the accounts to be synchronised, and confirm.
- You can manage connected accounts from the “Accounts” section.
- Transactions from connected accounts will appear in the “Transactions” section.
Transaction Matching
The system checks for new transactions daily, which are displayed in the “Transactions” section.
When a match is found, an indicator appears on the right showing the number of matches:
- Green indicator 1 for exact matches: The amount, date, and keyword match an existing entry. You can confirm the match directly as all details are identical.
- Amber indicator 1 for partial matches: Some details match (e.g. amount and date), but other elements like keywords or reference may differ. Manual verification is recommended.
- Grey indicator 0 when no match is found: You can either create a new entry in the “Finances” section or manually link the transaction to a yet unrecorded item.
A match is considered exact when the amount, dates, and a keyword of the imported transaction correspond to an existing line in Finances.
Manual Matching
After import, you can manually match entries and add them to the Finances section by:
- Confirming a match: If the system suggests a match with an unpaid line in Finances, you can confirm it to mark the payment as received.
- Recording a payment for an existing line: If the transaction corresponds to an unpaid item, you can record the payment manually.
- Adding a new line: If no match is found, you can create a new line in Finances for the transaction.
When a transaction is confirmed and added to Finances, an Already added label will appear. If needed, you can reset the matched transactions and process them again.
You can also split a single imported transaction and allocate it to multiple existing entries (e.g. if a tenant pays the first month’s rent and the security deposit in one payment).
If the amount linked to one item is less than the transaction amount, the remainder can be allocated to another line. Once the full amount is used, the transaction will be marked as Already added.
Automatic Matching
If an exact match is found for an unpaid rent, the system will automatically assign the transaction and mark the rent as paid.
When rent is matched and marked as paid, the software also sends a notification email to the landlord.
If the January rent for a tenant named John, amounting to £500, is unpaid, and you import a bank transaction dated 5 January for £500 with the description “PAYMENT JOHN DOE”, the system will:
- automatically recognise it as the rent payment,
- assign the transaction to the correct rent entry,
- and mark the rent as paid.
For automatic matching to work properly, the transaction amount and description must match the rent details.
Disconnected Accounts
Occasionally, synchronisation may stop.
For security reasons, some banks require re-authentication every 90 days. You may also delete and reconnect the account if needed.
Some banks allow you to adjust the frequency of strong customer authentication in your online banking settings. You can set this to “90 days”.
If constant re-authentication is required, please contact your bank to check if it can be disabled.
Delete a Synced Account
You can delete connected accounts from the “Accounts” section using the options on the right-hand side.
Deleting an account also deletes all associated transactions.
Manual Import
This section lets you manually import a bank statement in QIF or OFX format for reconciliation.
- Download the statement file from your bank (QIF or OFX format).
- Click “New Import” or “New Manual Import”.
- Upload the file into Rentila.
After the import, you can match the entries, review the data, choose the entry type if needed, and confirm.