{"id":3695,"date":"2022-10-25T18:01:07","date_gmt":"2022-10-25T16:01:07","guid":{"rendered":"https:\/\/www.rentila.co.uk\/support\/?p=3695"},"modified":"2025-12-15T14:29:09","modified_gmt":"2025-12-15T13:29:09","slug":"bank-reconciliation-and-account-transactions-import","status":"publish","type":"post","link":"https:\/\/www.rentila.co.uk\/support\/archives\/3695","title":{"rendered":"Bank account synchronization and account import"},"content":{"rendered":"<h3>Automatic Account Synchronisation<\/h3>\n<p>This section of the software allows you to automatically synchronise and import a bank account and its transactions.<\/p>\n<ol>\n<li>Go to the \u201cFinances\u201d section and click on \u201cBank Import\u201d. Then select \u201cNew Import\u201d or \u201cNew Synchronisation\u201d.<\/li>\n<li>Select the owner and the synchronisation period (30, 60, or 90 days).<\/li>\n<li>You will be redirected to a secure page where you can enter your banking credentials and connect to your account.<\/li>\n<li>Follow the instructions, choose the accounts to be synchronised, and confirm.<\/li>\n<li>You can manage connected accounts from the \u201cAccounts\u201d section.<\/li>\n<li>Transactions from connected accounts will appear in the \u201cTransactions\u201d section.<\/li>\n<\/ol>\n<h3>Transaction Matching<\/h3>\n<p>The system checks for new transactions daily, which are displayed in the \u201cTransactions\u201d section.<\/p>\n<p>When a match is found, an indicator appears on the right showing the number of matches:<\/p>\n<ul>\n<li><strong>Green indicator <span class=\"label label-success\">1<\/span> for exact matches:<\/strong> The amount, date, and keyword match an existing entry. You can confirm the match directly as all details are identical.<\/li>\n<li><strong>Amber indicator <span class=\"label label-warning\">1<\/span> for partial matches:<\/strong> Some details match (e.g. amount and date), but other elements like keywords or reference may differ. Manual verification is recommended.<\/li>\n<li><strong>Grey indicator <span class=\"label\">0<\/span> when no match is found:<\/strong> You can either create a new entry in the \u201cFinances\u201d section or manually link the transaction to a yet unrecorded item.<\/li>\n<\/ul>\n<p>A match is considered exact when the amount, dates, and a keyword of the imported transaction correspond to an existing line in Finances.<\/p>\n<h4>Manual Matching<\/h4>\n<p>After import, you can manually match entries and add them to the Finances section by:<\/p>\n<ul>\n<li><strong>Confirming a match:<\/strong> If the system suggests a match with an unpaid line in Finances, you can confirm it to mark the payment as received.<\/li>\n<li><strong>Recording a payment for an existing line:<\/strong> If the transaction corresponds to an unpaid item, you can record the payment manually.<\/li>\n<li><strong>Adding a new line:<\/strong> If no match is found, you can create a new line in Finances for the transaction.<\/li>\n<\/ul>\n<p>When a transaction is confirmed and added to Finances, an <span class=\"label\">Already added<\/span> label will appear. If needed, you can reset the matched transactions and process them again.<\/p>\n<p>You can also split a single imported transaction and allocate it to multiple existing entries (e.g. if a tenant pays the first month\u2019s rent and the security deposit in one payment).<\/p>\n<p>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 <span class=\"label\">Already added<\/span>.<\/p>\n<h4>Automatic Matching<\/h4>\n<p>If an exact match is found for an unpaid rent, the system will automatically assign the transaction and mark the rent as paid.<\/p>\n<p>When rent is matched and marked as paid, the software also sends a notification email to the landlord.<\/p>\n<div class=\"alert alert-info\">\n<span class=\"lead\">Example<\/span><\/p>\n<p>If the January rent for a tenant named John, amounting to \u00a3500, is unpaid, and you import a bank transaction dated 5 January for \u00a3500 with the description \u201cPAYMENT JOHN DOE\u201d, the system will:<\/p>\n<ul>\n<li>automatically recognise it as the rent payment,<\/li>\n<li>assign the transaction to the correct rent entry,<\/li>\n<li>and mark the rent as paid.<\/li>\n<\/ul>\n<p>For automatic matching to work properly, the transaction amount and description must match the rent details.<\/p>\n<\/div>\n<h3>Disconnected Accounts<\/h3>\n<p>Occasionally, synchronisation may stop.<\/p>\n<p>For security reasons, some banks require re-authentication every 90 days. You may also delete and reconnect the account if needed.<\/p>\n<div class=\"alert\">\n<span class=\"lead\">Frequent Disconnections!<\/span><\/p>\n<p>Some banks allow you to adjust the frequency of strong customer authentication in your online banking settings. You can set this to \u201c90 days\u201d.<\/p>\n<p>If constant re-authentication is required, please contact your bank to check if it can be disabled.<\/p>\n<\/div>\n<h3>Delete a Synced Account<\/h3>\n<p>You can delete connected accounts from the \u201cAccounts\u201d section using the options on the right-hand side.<\/p>\n<p>Deleting an account also deletes all associated transactions.<\/p>\n<h3>Manual Import<\/h3>\n<p>This section lets you manually import a bank statement in QIF or OFX format for reconciliation.<\/p>\n<ol>\n<li>Download the statement file from your bank (QIF or OFX format).<\/li>\n<li>Click \u201cNew Import\u201d or \u201cNew Manual Import\u201d.<\/li>\n<li>Upload the file into Rentila.<\/li>\n<\/ol>\n<p>After the import, you can match the entries, review the data, choose the entry type if needed, and confirm.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Automatic Account Synchronisation This section of the software allows you to automatically synchronise and import a bank account and its transactions. Go to the \u201cFinances\u201d section and click on \u201cBank Import\u201d. Then select \u201cNew Import\u201d or \u201cNew Synchronisation\u201d. Select the owner and the synchronisation period (30, 60, or 90 days). You will be redirected to<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9,293],"tags":[315,313],"class_list":["post-3695","post","type-post","status-publish","format-standard","hentry","category-finance","category-bank-import","tag-bank-import","tag-finances"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Bank account synchronization and account import Support center - Rentila<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.rentila.co.uk\/support\/archives\/3695\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bank account synchronization and account import Support center - Rentila\" \/>\n<meta property=\"og:description\" content=\"Automatic Account Synchronisation This section of the software allows you to automatically synchronise and import a bank account and its transactions. Go to the \u201cFinances\u201d section and click on \u201cBank Import\u201d. Then select \u201cNew Import\u201d or \u201cNew Synchronisation\u201d. Select the owner and the synchronisation period (30, 60, or 90 days). You will be redirected to\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.rentila.co.uk\/support\/archives\/3695\" \/>\n<meta property=\"og:site_name\" content=\"Support center - Rentila\" \/>\n<meta property=\"article:published_time\" content=\"2022-10-25T16:01:07+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-12-15T13:29:09+00:00\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.rentila.co.uk\\\/support\\\/archives\\\/3695#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.rentila.co.uk\\\/support\\\/archives\\\/3695\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/www.rentila.co.uk\\\/support\\\/#\\\/schema\\\/person\\\/59484648d8fef310098cc569a6fd1a2b\"},\"headline\":\"Bank account synchronization and account import\",\"datePublished\":\"2022-10-25T16:01:07+00:00\",\"dateModified\":\"2025-12-15T13:29:09+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.rentila.co.uk\\\/support\\\/archives\\\/3695\"},\"wordCount\":681,\"keywords\":[\"Bank import\",\"Finances\"],\"articleSection\":[\"Finance\",\"Bank import\"],\"inLanguage\":\"en-GB\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.rentila.co.uk\\\/support\\\/archives\\\/3695\",\"url\":\"https:\\\/\\\/www.rentila.co.uk\\\/support\\\/archives\\\/3695\",\"name\":\"Bank account synchronization and account import Support center - Rentila\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.rentila.co.uk\\\/support\\\/#website\"},\"datePublished\":\"2022-10-25T16:01:07+00:00\",\"dateModified\":\"2025-12-15T13:29:09+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.rentila.co.uk\\\/support\\\/#\\\/schema\\\/person\\\/59484648d8fef310098cc569a6fd1a2b\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.rentila.co.uk\\\/support\\\/archives\\\/3695#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.rentila.co.uk\\\/support\\\/archives\\\/3695\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.rentila.co.uk\\\/support\\\/archives\\\/3695#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.rentila.co.uk\\\/support\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bank account synchronization and account import\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.rentila.co.uk\\\/support\\\/#website\",\"url\":\"https:\\\/\\\/www.rentila.co.uk\\\/support\\\/\",\"name\":\"Support center - Rentila\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.rentila.co.uk\\\/support\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.rentila.co.uk\\\/support\\\/#\\\/schema\\\/person\\\/59484648d8fef310098cc569a6fd1a2b\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/20e4a7d3e81bf2b540f56b8c153cb632e62dc95802d33694aa38846415dc20d1?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/20e4a7d3e81bf2b540f56b8c153cb632e62dc95802d33694aa38846415dc20d1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/20e4a7d3e81bf2b540f56b8c153cb632e62dc95802d33694aa38846415dc20d1?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"url\":\"https:\\\/\\\/www.rentila.co.uk\\\/support\\\/archives\\\/author\\\/admin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Bank account synchronization and account import Support center - Rentila","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.rentila.co.uk\/support\/archives\/3695","og_locale":"en_GB","og_type":"article","og_title":"Bank account synchronization and account import Support center - Rentila","og_description":"Automatic Account Synchronisation This section of the software allows you to automatically synchronise and import a bank account and its transactions. Go to the \u201cFinances\u201d section and click on \u201cBank Import\u201d. Then select \u201cNew Import\u201d or \u201cNew Synchronisation\u201d. Select the owner and the synchronisation period (30, 60, or 90 days). You will be redirected to","og_url":"https:\/\/www.rentila.co.uk\/support\/archives\/3695","og_site_name":"Support center - Rentila","article_published_time":"2022-10-25T16:01:07+00:00","article_modified_time":"2025-12-15T13:29:09+00:00","author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Estimated reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.rentila.co.uk\/support\/archives\/3695#article","isPartOf":{"@id":"https:\/\/www.rentila.co.uk\/support\/archives\/3695"},"author":{"name":"admin","@id":"https:\/\/www.rentila.co.uk\/support\/#\/schema\/person\/59484648d8fef310098cc569a6fd1a2b"},"headline":"Bank account synchronization and account import","datePublished":"2022-10-25T16:01:07+00:00","dateModified":"2025-12-15T13:29:09+00:00","mainEntityOfPage":{"@id":"https:\/\/www.rentila.co.uk\/support\/archives\/3695"},"wordCount":681,"keywords":["Bank import","Finances"],"articleSection":["Finance","Bank import"],"inLanguage":"en-GB"},{"@type":"WebPage","@id":"https:\/\/www.rentila.co.uk\/support\/archives\/3695","url":"https:\/\/www.rentila.co.uk\/support\/archives\/3695","name":"Bank account synchronization and account import Support center - Rentila","isPartOf":{"@id":"https:\/\/www.rentila.co.uk\/support\/#website"},"datePublished":"2022-10-25T16:01:07+00:00","dateModified":"2025-12-15T13:29:09+00:00","author":{"@id":"https:\/\/www.rentila.co.uk\/support\/#\/schema\/person\/59484648d8fef310098cc569a6fd1a2b"},"breadcrumb":{"@id":"https:\/\/www.rentila.co.uk\/support\/archives\/3695#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.rentila.co.uk\/support\/archives\/3695"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.rentila.co.uk\/support\/archives\/3695#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.rentila.co.uk\/support\/"},{"@type":"ListItem","position":2,"name":"Bank account synchronization and account import"}]},{"@type":"WebSite","@id":"https:\/\/www.rentila.co.uk\/support\/#website","url":"https:\/\/www.rentila.co.uk\/support\/","name":"Support center - Rentila","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.rentila.co.uk\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Person","@id":"https:\/\/www.rentila.co.uk\/support\/#\/schema\/person\/59484648d8fef310098cc569a6fd1a2b","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/secure.gravatar.com\/avatar\/20e4a7d3e81bf2b540f56b8c153cb632e62dc95802d33694aa38846415dc20d1?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/20e4a7d3e81bf2b540f56b8c153cb632e62dc95802d33694aa38846415dc20d1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/20e4a7d3e81bf2b540f56b8c153cb632e62dc95802d33694aa38846415dc20d1?s=96&d=mm&r=g","caption":"admin"},"url":"https:\/\/www.rentila.co.uk\/support\/archives\/author\/admin"}]}},"_links":{"self":[{"href":"https:\/\/www.rentila.co.uk\/support\/wp-json\/wp\/v2\/posts\/3695","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rentila.co.uk\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rentila.co.uk\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rentila.co.uk\/support\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rentila.co.uk\/support\/wp-json\/wp\/v2\/comments?post=3695"}],"version-history":[{"count":26,"href":"https:\/\/www.rentila.co.uk\/support\/wp-json\/wp\/v2\/posts\/3695\/revisions"}],"predecessor-version":[{"id":4995,"href":"https:\/\/www.rentila.co.uk\/support\/wp-json\/wp\/v2\/posts\/3695\/revisions\/4995"}],"wp:attachment":[{"href":"https:\/\/www.rentila.co.uk\/support\/wp-json\/wp\/v2\/media?parent=3695"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rentila.co.uk\/support\/wp-json\/wp\/v2\/categories?post=3695"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rentila.co.uk\/support\/wp-json\/wp\/v2\/tags?post=3695"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}