{"id":17479,"date":"2020-06-29T11:58:40","date_gmt":"2020-06-29T10:58:40","guid":{"rendered":"https:\/\/support.ospreyapproach.com\/?post_type=pracctice_guide&p=17479"},"modified":"2024-05-09T09:08:10","modified_gmt":"2024-05-09T08:08:10","slug":"perform-an-automatic-bank-reconciliation","status":"publish","type":"pracctice_guide","link":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/perform-an-automatic-bank-reconciliation\/","title":{"rendered":"Perform an automatic Bank Reconciliation"},"content":{"rendered":"
\n\n

Who is this guide for?<\/strong><\/p>\n

<\/i> Accounts Users<\/strong> and Accounts Supervisors<\/strong><\/p> \n<\/div>\n\n\n\n

This guide will show you how to perform automatic bank reconciliation<\/h2>\n\n\n\n

Using an online banking transaction download, it is possible to automatically reconcile your bank. <\/p>\n\n\n\n

Ensure your CSV file is valid<\/p>\n\n\n\n

The layout of the CSV file is described below:<\/p>\n\n\n\n

CSV Column<\/strong><\/td>Name<\/strong>  <\/strong><\/td>Description<\/strong><\/td><\/tr>
A<\/strong><\/td>Sort Code<\/td>As Supervisor > Financial Setup > Banks > Sort code saved against the bank you’re reconciling<\/td><\/tr>
B<\/strong><\/td>Account Number<\/td>As Supervisor > Financial Setup > Banks > Account Number saved against the bank you’re reconciling (no dashes but must be stored in here with a leading 0 – so 8 characters preceded by a 0)<\/td><\/tr>
C<\/strong><\/td>Account Alias<\/td>As Supervisor > Financial Setup > Banks > Account Description saved against the bank you are reconciling \u2013 must be identical.<\/td><\/tr>
D<\/strong><\/td>Account Short Name<\/td>As Supervisor > Financial Setup > Banks > Account ID saved against the bank you’re reconciling<\/td><\/tr>
E<\/strong><\/td>Currency<\/td>Currency of the bank<\/td><\/tr>
F<\/strong><\/td>Account Type<\/td>Not required<\/td><\/tr>
G<\/strong><\/td>BIC<\/td>Not required<\/td><\/tr>
H<\/strong><\/td>Bank Name<\/td>Not required<\/td><\/tr>
I<\/strong><\/td>Branch Name<\/td>Not required<\/td><\/tr>
J<\/strong><\/td>Date<\/td>Posting Date of transaction<\/td><\/tr>
K<\/strong><\/td>Narrative #1<\/td>Posting Detail of transaction<\/td><\/tr>
L<\/strong><\/td>Narrative #2<\/td>Not required<\/td><\/tr>
M<\/strong><\/td>Narrative #3<\/td>Not required<\/td><\/tr>
N<\/strong><\/td>Narrative #4<\/td>Not required<\/td><\/tr>
O<\/strong><\/td>Narrative #5<\/td>Not required<\/td><\/tr>
P<\/strong><\/td>Type<\/td>Posting Reference of transaction<\/td><\/tr>
Q<\/strong><\/td>Debit<\/td>If posting is for less than 0, minus value, else blank<\/td><\/tr>
R<\/strong><\/td>Credit<\/td>If posting is for more than 0, value, else blank<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

You can download this file as a template:<\/p>\n\n\n\n

AutoBankRecTemplate<\/a>Download<\/a><\/div>\n\n\n\n

Set up a new bank for auto reconciliation<\/p>\n\n\n\n

To successfully implement the Auto Reconciliation, first you need to create or amend the bank within Supervisor with all the correct details, ensuring that the sort code and account number are set correctly.<\/p>\n\n\n\n

Navigate to Supervisor > Financial Setup > Banks > Add Bank.<\/p>\n\n\n

\n
\"\"<\/figure>\n<\/div>\n\n\n

<\/p>\n\n\n\n

Fill in as much information in as you can for the bank. You must, at minimum, supply:<\/p>\n\n\n\n

\n
    \n
  • Account Code (in line with your other banks)<\/li>\n\n\n\n
  • Account Description<\/li>\n\n\n\n
  • Bank Account Number \u2013 should<\/em><\/strong> be 9 characters so prefix with a 0 if necessary \u2013 e.g. 10129833 becomes 010129833<\/em><\/strong><\/li>\n\n\n\n
  • Bank Sort Code<\/li>\n\n\n\n
  • Bank Type (O<\/strong>ffice or C<\/strong>lient)<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n\n

    Edit an existing bank for auto reconciliation<\/p>\n\n\n\n

    Navigate to Supervisor > Financial Setup > Banks.<\/p>\n\n\n

    \n
    \"\"<\/figure>\n<\/div>\n\n\n

    <\/p>\n\n\n\n

    Right click on the bank you want to amend and click Edit.<\/p>\n\n\n

    \n
    \"\"<\/figure>\n<\/div>\n\n\n

    <\/p>\n\n\n\n

    Now add:<\/p>\n\n\n\n

      \n
    • Bank Account Number \u2013 should<\/em><\/strong> be 9 characters so prefix with a 0 if necessary \u2013 e.g. 10129833 becomes 010129833<\/em><\/strong><\/li>\n\n\n\n
    • Bank Sort Code<\/li>\n<\/ul>\n\n\n\n

      Save your changes.<\/p>\n\n\n\n

      Auto reconcile your bank<\/p>\n\n\n\n

      Navigate to Banks & Journals, select the bank you wish to auto reconcile from the Bank\/Journal box at the top, and click Refresh.<\/p>\n\n\n\n

      Select Auto Reconciliation from the left hand menu.<\/p>\n\n\n

      \n
      \"\"<\/figure>\n<\/div>\n\n\n

      <\/p>\n\n\n\n

      Click Choose File<\/p>\n\n\n

      \n
      \"\"<\/figure>\n<\/div>\n\n\n

      <\/p>\n\n\n\n

      Select the CSV file which contains your bank statement. Double click it, or highlight it and click Open to select it.<\/p>\n\n\n

      \n
      \"\"<\/figure>\n<\/div>\n\n\n

      <\/p>\n\n\n\n

      Click the Upload button, and then the Verify button.<\/p>\n\n\n\n

      The transactions from your bank statement will now be displayed on the Auto Reconciliation screen. <\/p>\n\n\n

      \n
      \"\"<\/figure>\n<\/div>\n\n\n

      <\/p>\n\n\n\n

      Select the most appropriate method of reconciliation from the list of options.<\/p>\n\n\n\n

        \n
      • Show Unticked Statement Items<\/strong> – This lists all transactions from the CSV file which have not yet been ticked. (The first time the file is loaded, Osprey will display all entries in the file, and subsequent to performing any of the options below, will show anything remaining unticked).<\/li>\n\n\n\n
      • Find Exact Matches<\/strong> – Only locates transactions in Osprey where the reference, date and amount are identical in the CSV file. Should you wish to un-tick any of the items matched selecting Confirm Changes will reflect the change in the projected balance.<\/li>\n\n\n\n
      • Find First Batch<\/strong> – This finds batches of postings (one batch at a time) that have the same posting reference and date, and ticks them ready for instruction. Should you wish to un-tick any of the items matched selecting Confirm Changes will reflect the change in the projected balance.<\/li>\n\n\n\n
      • Match on Amount Only<\/strong> – Results are shown where matches are found by amount only.<\/li>\n\n\n\n
      • Show Cleared Statement Items<\/strong> – This shows all ticked items on the bank.<\/li>\n<\/ul>\n\n\n\n

        Select Tick Now to Reconcile the items ticked.<\/p>\n","protected":false},"excerpt":{"rendered":"

        This guide will show you how to perform automatic bank reconciliation Using an online banking transaction download, it is possible to automatically reconcile your bank. Ensure your CSV file is valid The layout of the CSV file is described below: CSV Column Name   Description A Sort Code As Supervisor > Financial Setup > Banks […]<\/p>\n","protected":false},"author":24,"featured_media":0,"template":"","categories":[53],"tags":[],"class_list":["post-17479","pracctice_guide","type-pracctice_guide","status-publish","hentry","category-using-month-year-end"],"acf":{"display_as_dashboard_announcement":false,"announcement_title":"","announcement_type":"New feature","announcement_link_text":"Learn more","announcement_image":null},"yoast_head":"\nPerform an automatic Bank Reconciliation | Osprey Academy - Customer Support and Training Centre<\/title>\n<meta name=\"description\" content=\"A step-by-step guide to using an online banking transaction download, it is possible to automatically reconcile your bank\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/perform-an-automatic-bank-reconciliation\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Perform an automatic Bank Reconciliation | Osprey Academy - Customer Support and Training Centre\" \/>\n<meta property=\"og:description\" content=\"A step-by-step guide to using an online banking transaction download, it is possible to automatically reconcile your bank\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/perform-an-automatic-bank-reconciliation\/\" \/>\n<meta property=\"og:site_name\" content=\"Osprey Approach Customer Support & Training | Osprey Academy\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/OspreyApproachUK\/\" \/>\n<meta property=\"article:modified_time\" content=\"2024-05-09T08:08:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2024\/05\/image-11.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@OspreyApproach\" \/>\n<meta name=\"twitter:label1\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/perform-an-automatic-bank-reconciliation\/\",\"url\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/perform-an-automatic-bank-reconciliation\/\",\"name\":\"Perform an automatic Bank Reconciliation | Osprey Academy - Customer Support and Training Centre\",\"isPartOf\":{\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/perform-an-automatic-bank-reconciliation\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/perform-an-automatic-bank-reconciliation\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2024\/05\/image-11.png\",\"datePublished\":\"2020-06-29T10:58:40+00:00\",\"dateModified\":\"2024-05-09T08:08:10+00:00\",\"description\":\"A step-by-step guide to using an online banking transaction download, it is possible to automatically reconcile your bank\",\"breadcrumb\":{\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/perform-an-automatic-bank-reconciliation\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/perform-an-automatic-bank-reconciliation\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/perform-an-automatic-bank-reconciliation\/#primaryimage\",\"url\":\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2024\/05\/image-11.png\",\"contentUrl\":\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2024\/05\/image-11.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/perform-an-automatic-bank-reconciliation\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/support.ospreyapproach.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Guides\",\"item\":\"https:\/\/support.ospreyapproach.com\/guides\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Perform an automatic Bank Reconciliation\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#website\",\"url\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/\",\"name\":\"Osprey Approach Customer Support & Training | Osprey Academy\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#organization\",\"name\":\"Osprey Approach Customer Support & Training | Osprey Academy\",\"url\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2021\/10\/Osprey-Logo-200px.png\",\"contentUrl\":\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2021\/10\/Osprey-Logo-200px.png\",\"width\":201,\"height\":61,\"caption\":\"Osprey Approach Customer Support & Training | Osprey Academy\"},\"image\":{\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/OspreyApproachUK\/\",\"https:\/\/x.com\/OspreyApproach\",\"https:\/\/www.linkedin.com\/company\/ospreyapproach\",\"https:\/\/www.youtube.com\/channel\/UClARKUq_3YvaK01GPvI6_qA\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Perform an automatic Bank Reconciliation | Osprey Academy - Customer Support and Training Centre","description":"A step-by-step guide to using an online banking transaction download, it is possible to automatically reconcile your bank","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:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/perform-an-automatic-bank-reconciliation\/","og_locale":"en_GB","og_type":"article","og_title":"Perform an automatic Bank Reconciliation | Osprey Academy - Customer Support and Training Centre","og_description":"A step-by-step guide to using an online banking transaction download, it is possible to automatically reconcile your bank","og_url":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/perform-an-automatic-bank-reconciliation\/","og_site_name":"Osprey Approach Customer Support & Training | Osprey Academy","article_publisher":"https:\/\/www.facebook.com\/OspreyApproachUK\/","article_modified_time":"2024-05-09T08:08:10+00:00","og_image":[{"url":"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2024\/05\/image-11.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_site":"@OspreyApproach","twitter_misc":{"Estimated reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/perform-an-automatic-bank-reconciliation\/","url":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/perform-an-automatic-bank-reconciliation\/","name":"Perform an automatic Bank Reconciliation | Osprey Academy - Customer Support and Training Centre","isPartOf":{"@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#website"},"primaryImageOfPage":{"@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/perform-an-automatic-bank-reconciliation\/#primaryimage"},"image":{"@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/perform-an-automatic-bank-reconciliation\/#primaryimage"},"thumbnailUrl":"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2024\/05\/image-11.png","datePublished":"2020-06-29T10:58:40+00:00","dateModified":"2024-05-09T08:08:10+00:00","description":"A step-by-step guide to using an online banking transaction download, it is possible to automatically reconcile your bank","breadcrumb":{"@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/perform-an-automatic-bank-reconciliation\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/perform-an-automatic-bank-reconciliation\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/perform-an-automatic-bank-reconciliation\/#primaryimage","url":"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2024\/05\/image-11.png","contentUrl":"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2024\/05\/image-11.png"},{"@type":"BreadcrumbList","@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/perform-an-automatic-bank-reconciliation\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/support.ospreyapproach.com\/"},{"@type":"ListItem","position":2,"name":"Guides","item":"https:\/\/support.ospreyapproach.com\/guides\/"},{"@type":"ListItem","position":3,"name":"Perform an automatic Bank Reconciliation"}]},{"@type":"WebSite","@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#website","url":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/","name":"Osprey Approach Customer Support & Training | Osprey Academy","description":"","publisher":{"@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#organization","name":"Osprey Approach Customer Support & Training | Osprey Academy","url":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#\/schema\/logo\/image\/","url":"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2021\/10\/Osprey-Logo-200px.png","contentUrl":"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2021\/10\/Osprey-Logo-200px.png","width":201,"height":61,"caption":"Osprey Approach Customer Support & Training | Osprey Academy"},"image":{"@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/OspreyApproachUK\/","https:\/\/x.com\/OspreyApproach","https:\/\/www.linkedin.com\/company\/ospreyapproach","https:\/\/www.youtube.com\/channel\/UClARKUq_3YvaK01GPvI6_qA"]}]}},"_links":{"self":[{"href":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/wp-json\/wp\/v2\/pracctice_guide\/17479","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/wp-json\/wp\/v2\/pracctice_guide"}],"about":[{"href":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/wp-json\/wp\/v2\/types\/pracctice_guide"}],"author":[{"embeddable":true,"href":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/wp-json\/wp\/v2\/users\/24"}],"version-history":[{"count":2,"href":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/wp-json\/wp\/v2\/pracctice_guide\/17479\/revisions"}],"predecessor-version":[{"id":66899,"href":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/wp-json\/wp\/v2\/pracctice_guide\/17479\/revisions\/66899"}],"wp:attachment":[{"href":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/wp-json\/wp\/v2\/media?parent=17479"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/wp-json\/wp\/v2\/categories?post=17479"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/wp-json\/wp\/v2\/tags?post=17479"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}