![\"\"](\"https:\/\/sagefinancialsknowhow.com\/wp-content\/uploads\/2019\/01\/BankREc-1.jpg\")
<\/h2>\n<\/h2>\nThe new Bank Reconciliation is a real game changer for Sage Financials. It has the potential to drastically reduce the time and effort required to process basic bookkeeping and improve accuracy by reducing data entry.<\/p>\n
It is a massive improvement on the old Bank Matching – intuitive, bulk enabled, clean and easy to use. I’m not going to explain how to use it,\u00a0there is some great help on the Sage site<\/a> but focus on how it works.<\/p>\n I’ve only been working with the new Financials Bank Reconciliation for a few weeks, and this is what I’ve learnt so far… Sage are also likely to be improving this feature over the next months and this article is based on my experience with v89.<\/p>\n How does the new Bank Reconciliation process differ from the old Bank Matching?<\/p>\n <\/p>\n Re-configuring has been made really easy. All you need to do is link your Feed to a different Feed Rule Set:<\/p>\n And you do this by replacing the Rule Set By Feed<\/em>. This shows the data structure for the feeds.<\/p>\n The old Feed Broker Rules have records with the Property Name of ‘type’ but in the new\u00a0Feed Broker Rules the Property Name is ‘journalType’. This is the key magic that tells Sage Financials to use the new Bank Reconciliation or the old Bank Matching. Bear this in mind if you edit the Feed Broker Rules that you MUST have at least one\u00a0Property Name of ‘journalType’ to action the new Bank Reconciliation.<\/p>\n It is the ‘journalType’ records that can be used to automatically generate reconciliation Journals using matching criteria.<\/p>\n The most important change in terms of configuration is the Bank Rec matches to Journal Line Items<\/em>\u00a0whereas the old Bank Matching matches to Dimension Tags<\/em>.<\/p>\n If you raise a Sales Invoice, the Bank Reconciliation can be used to create a new ‘Customer Receipt’ Journal or if you have made a ‘Supplier Payment’ Journal you can match to it using Bank Reconciliation<\/p>\n The Balance in your bank account as it appears in the Balance Sheet or Profit & Loss is calculated from the Ledger Items. But the Bank Reconciliation matches to Journal Line Items, NOT Ledger Items. This has important implications:<\/p>\n Its clear we are going to be using Journals more than ever. However Journals have been rather left behind in terms of developing the user interface.<\/p>\n Please vote for the ‘ideas’ I’ve posted for improving the Journals interface, and add your own ideas as well!<\/p>\n Grid Entry for Journals<\/a><\/span><\/p>\n Choose Date when Cloning Journals<\/a><\/span><\/p>\n Copy over Reference when Cloning Journal<\/a><\/span><\/p>\n <\/p>\n <\/p>\n <\/p>\n","protected":false},"excerpt":{"rendered":" New Bank Reconciliation – how does it work? The new Bank Reconciliation is a real game changer for Sage Financials. It has the potential to drastically reduce the time and effort required to process basic bookkeeping and improve accuracy by reducing data entry. It is a massive improvement on the old Bank Matching – intuitive, Read more about **All New** Bank Reconciliation in Sage Financials – how does it work?<\/span>[…]<\/a><\/p>\n","protected":false},"author":1,"featured_media":249,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[7],"_links":{"self":[{"href":"https:\/\/sagefinancialsknowhow.com\/wp-json\/wp\/v2\/posts\/506"}],"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=506"}],"version-history":[{"count":0,"href":"https:\/\/sagefinancialsknowhow.com\/wp-json\/wp\/v2\/posts\/506\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sagefinancialsknowhow.com\/wp-json\/wp\/v2\/media\/249"}],"wp:attachment":[{"href":"https:\/\/sagefinancialsknowhow.com\/wp-json\/wp\/v2\/media?parent=506"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sagefinancialsknowhow.com\/wp-json\/wp\/v2\/categories?post=506"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sagefinancialsknowhow.com\/wp-json\/wp\/v2\/tags?post=506"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}What has changed?<\/h3>\n
Old Bank Matching<\/h5>\n
\n
![\"\"](\"https:\/\/sagefinancialsknowhow.com\/wp-content\/uploads\/2019\/01\/OldBankFeed.jpg\")
<\/p>\nNew Bank Reconciliation<\/h5>\n
\n
![\"\"](\"https:\/\/sagefinancialsknowhow.com\/wp-content\/uploads\/2019\/01\/NewBankFeed.jpg\")
<\/p>\nRe-configuring the Feeds<\/h3>\n
\n
![\"\"](\"https:\/\/sagefinancialsknowhow.com\/wp-content\/uploads\/2019\/01\/BankFeed1a.jpg\")
<\/p>\nNew or Old?<\/h3>\n
Journals not Dimension Tags<\/h3>\n
![\"\"](\"https:\/\/sagefinancialsknowhow.com\/wp-content\/uploads\/2019\/01\/BankFeed2.jpg\")
<\/p>\nJournal Items NOT Ledger Items<\/h3>\n
\n
\nThese will need to be converted into Journals to benefit from Bank Reconciliation<\/li>\n
\nYou need to be careful with your posting rules to make sure EVER posting to the Bank Account is associated with the correct Bank Account Tag AND the Bank Account Tag is ONLY associated with postings to the Bank Account as all postings with the Bank Account Tag affect the Tag balance.<\/li>\n<\/ul>\nIts all about Journals<\/h3>\n