{"id":963,"date":"2020-01-14T13:13:52","date_gmt":"2020-01-14T13:13:52","guid":{"rendered":"http:\/\/sagefinancialsknowhow.com\/?p=963"},"modified":"2020-01-14T13:13:52","modified_gmt":"2020-01-14T13:13:52","slug":"bank-tag-reconciliation","status":"publish","type":"post","link":"https:\/\/sagefinancialsknowhow.com\/bank-tag-reconciliation\/","title":{"rendered":"Bank Tag balance and Ledger Statement Balance"},"content":{"rendered":"<p>Before trying to work out why your Bank Statement does not match the bank account in Sage, check the Bank Account Tag balance matches the Ledger Statement balance:<\/p>\n<p>The Bank Account Dimension Tag balance is displayed when you go to the tab &#8216;Bank-BANK ACCOUNTS&#8217;. For the Ledger Balance go to &#8216;Ledger-LEDGER STATEMENT&#8217;, choose the Ledger Account for you bank account and a FY and Period further in the future than any of you postings.<\/p>\n<h4>Bank Tag Balance<\/h4>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-934\" src=\"https:\/\/sagefinancialsknowhow.com\/wp-content\/uploads\/2019\/12\/Bank-Tag-Balance.png\" alt=\"\" width=\"1883\" height=\"429\" srcset=\"https:\/\/sagefinancialsknowhow.com\/wp-content\/uploads\/2019\/12\/Bank-Tag-Balance.png 1883w, https:\/\/sagefinancialsknowhow.com\/wp-content\/uploads\/2019\/12\/Bank-Tag-Balance-300x68.png 300w, https:\/\/sagefinancialsknowhow.com\/wp-content\/uploads\/2019\/12\/Bank-Tag-Balance-768x175.png 768w, https:\/\/sagefinancialsknowhow.com\/wp-content\/uploads\/2019\/12\/Bank-Tag-Balance-1024x233.png 1024w, https:\/\/sagefinancialsknowhow.com\/wp-content\/uploads\/2019\/12\/Bank-Tag-Balance-560x128.png 560w\" sizes=\"(max-width: 1883px) 100vw, 1883px\" \/><\/p>\n<h4>Ledger Statement Balance<\/h4>\n<h4><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-936\" src=\"https:\/\/sagefinancialsknowhow.com\/wp-content\/uploads\/2019\/12\/Bank-Ledger-Statement2.jpg\" alt=\"\" width=\"1871\" height=\"451\" srcset=\"https:\/\/sagefinancialsknowhow.com\/wp-content\/uploads\/2019\/12\/Bank-Ledger-Statement2.jpg 1871w, https:\/\/sagefinancialsknowhow.com\/wp-content\/uploads\/2019\/12\/Bank-Ledger-Statement2-300x72.jpg 300w, https:\/\/sagefinancialsknowhow.com\/wp-content\/uploads\/2019\/12\/Bank-Ledger-Statement2-768x185.jpg 768w, https:\/\/sagefinancialsknowhow.com\/wp-content\/uploads\/2019\/12\/Bank-Ledger-Statement2-1024x247.jpg 1024w, https:\/\/sagefinancialsknowhow.com\/wp-content\/uploads\/2019\/12\/Bank-Ledger-Statement2-560x135.jpg 560w\" sizes=\"(max-width: 1871px) 100vw, 1871px\" \/><\/h4>\n<p>Clearly something is wrong, as these two figures should match. The first step is to run &#8216;Rebuild Balances&#8217; see: <a href=\"https:\/\/help-financials.sage.com\/en-gb\/General%20Ledger\/Rebuild%20ledger%20balances.htm\">Sage Help<\/a>\u00a0which will recalculate the Tag Balance based on all the Ledger Postings. I would always recommend Rebuilding Balances before trying to trouble shoot incorrect figures.<\/p>\n<p>If Rebuild Balances does not fix it, there may be manually adjustments of the Bank Ledger Account that you entered without including the Bank Dimension Tag in the posting. You can create a report based on &#8216;Ledger Items&#8217; to track these down: filter using the essential filters (see Sage Financials <em>knowhow<\/em> article on\u00a0 <a href=\"https:\/\/sagefinancialsknowhow.com\/reporting2\/\">Salesforce Reports<\/a>) and also filtering on:<\/p>\n<ul>\n<li>Ledger Account &#8216;equals\u00a0<em>&lt;Bank Account Ledger Account&gt;<\/em> (eg <em>1200 Bank Account<\/em>)<\/li>\n<li>Bank Account Tag &#8216;not equal&#8217; <em>&lt;leave blank&gt;<\/em><\/li>\n<\/ul>\n<p><strong>Did you find this useful? Please\u00a0<a href=\"http:\/\/eepurl.com\/dxW1z1\" target=\"_blank\" rel=\"noopener\">register to receive regular updates from Sage Financials\u00a0<em>knowhow<\/em><\/a>.\u00a0<\/strong><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Before trying to work out why your Bank Statement does not match the bank account in Sage, check the Bank Account Tag balance matches the Ledger Statement balance: The Bank Account Dimension Tag balance is displayed when you go to the tab &#8216;Bank-BANK ACCOUNTS&#8217;. For the Ledger Balance go to &#8216;Ledger-LEDGER STATEMENT&#8217;, choose the Ledger <a href=\"https:\/\/sagefinancialsknowhow.com\/bank-tag-reconciliation\/\" rel=\"nofollow\"><span class=\"sr-only\">Read more about Bank Tag balance and Ledger Statement Balance<\/span>[&hellip;]<\/a><\/p>\n","protected":false},"author":1,"featured_media":834,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[4],"_links":{"self":[{"href":"https:\/\/sagefinancialsknowhow.com\/wp-json\/wp\/v2\/posts\/963"}],"collection":[{"href":"https:\/\/sagefinancialsknowhow.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sagefinancialsknowhow.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sagefinancialsknowhow.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sagefinancialsknowhow.com\/wp-json\/wp\/v2\/comments?post=963"}],"version-history":[{"count":0,"href":"https:\/\/sagefinancialsknowhow.com\/wp-json\/wp\/v2\/posts\/963\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sagefinancialsknowhow.com\/wp-json\/wp\/v2\/media\/834"}],"wp:attachment":[{"href":"https:\/\/sagefinancialsknowhow.com\/wp-json\/wp\/v2\/media?parent=963"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sagefinancialsknowhow.com\/wp-json\/wp\/v2\/categories?post=963"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sagefinancialsknowhow.com\/wp-json\/wp\/v2\/tags?post=963"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}