Its actually pretty unusual for the Balance Sheet to match the Bank Statement at the end of the year, so the challenge is to track down why it does not match. But before you get into the details of the transactions there are a couple of checks you should run first.<\/p>\n
- \n
- Run re-build balances<\/a>
\nBefore doing end of year processing, I would always recommend running ‘Rebuild Balances<\/a>‘ even though it means your users need to keep out of the system for a while.<\/li>\n- Check the Tag Balance matches the ‘Ledger Account Statement’ balance for each bank account<\/a><\/li>\n
- Refresh the Balance Sheet report<\/li>\n
- Check the\u00a0bank balance in your Balance Sheet is the same as the ‘Ledger Account Statement’ balance at the end-of-year date. If not, there is something wrong with your Balance Sheet configuration. (See Sep Issue of Sage Financials knowhow<\/em><\/a>)<\/li>\n<\/ul>\n
Tools in Sage Financials<\/h3>\n
Bank Matching<\/h4>\n
The Bank Matching will reliably show you bank payments or receipts that have not been recorded in Sage.<\/p>\n
- \n
- Remember to set the date range large enough to catch all the bank transactions<\/li>\n
- Be warned that you can bypass Bank Matching by using the ‘Ignore’ function<\/li>\n
- With earlier versions of Bank Matching you could get into a mess with the bank transaction being ‘Reconciled’ but the related Journal Item unposted or deleted<\/li>\n<\/ul>\n
Reconciliation problems not managed by Bank Matching<\/h4>\n
There are several scenarios that cause problems with Bank Reconciliation – here are some:<\/p>\n
- \n
- Payment to suppliers\u00a0processed in Sage, but money not actually paid
\nThis can be alleviated by posting to a clearing bank first, but does involve additional processing.<\/li>\n - Posting errors in Bank Matching journals
\nIf a Bank Match journal fails to post, the record appears as ‘reconciled’ in Bank Matching, but is not actually posted.<\/li>\n - Unposting and Deleting journals
\nIn early versions of Bank Matching, if you unposted and\/or deleted a matched journal, the record still appeared as reconciled<\/li>\n - Manual Adjustments using Ledger Entries
\nThese will never appear in Bank Matching<\/li>\n - Old ‘Bank Takings’ journals from the old Bank Matching can be altered or unposted<\/li>\n
- Using the ‘Ignore Transaction’ in Bank Matching<\/li>\n
- Foreign currency transactions not handled in the correct way.<\/li>\n<\/ul>\n
Unreconciled Journals<\/h4>\n
Some of these bank reconciliation problems are due to ‘reconciled’ journals that are not posted, or simply ‘unreconciled’ journals. So it would be really useful to to have a report to show a journal’s reconciliation status.\u00a0With a bit of configuration it is possible to create a report that shows Journal Items<\/em> that have not been reconciled and with careful choice of filters this report can show what you need:<\/p>\n
- \n
- You will need to create a Custom Report Type to include\u00a0‘Journals with Journal Items with\/without Feed Item’<\/li>\n
- Use the essential filters (see Sage Financials knowhow<\/em> article on\u00a0 Salesforce Reports<\/a>) and also filtering on: JournalType UID to select Payment & Receipt journals only, Feed Item ‘Reconciliation Status’ and Journal Status (Submitted or Unsubmitted).<\/li>\n<\/ul>\n
This report is likely to display more data than you want, but at least its a starting point. The idea is to show posted journal items that are NOT reconciled in Bank matching, and unposted journal items that ARE reconciled in Bank Matching.<\/p>\n
Reconciled Ledger Items<\/h4>\n
Some of these errors are much more difficult to track down, and when the obvious mistakes have been ruled out, what you really want is a list of ALL the Ledger Items that impact the Bank Account, with their Bank Matching reconciled status. Unfortunately this is not available in Sage Financials. The reason being Bank Matching works on Journal Items, not Ledger Items. There is a loose connection between the two, but not enough to create a report.<\/p>\n
![\"\"](\"https:\/\/sagefinancialsknowhow.com\/wp-content\/uploads\/2020\/01\/Diagram-1.jpg\")
<\/p>\nThe good news is Alpha Index have released a new plugin that enables you to get this report with a high degree of accuracy. And right now, you can download it as a free trial<\/strong><\/em> to see if it works for you.<\/p>\n
Feature Pack Bank Reconciliation<\/h4>\n
Newly release, the Feature Pack Reconcile plugin<\/a> can process your data to enable you to display the reconciliation status of Ledger Items. It also includes the kind of reports I’ve been talking about and is available as a free trail.<\/p>\n
Click here to download the free trial<\/a>.<\/p>\n
<\/p>\n
<\/p>\n
Did you find this useful? Please\u00a0register to receive regular updates from Sage Financials\u00a0knowhow<\/em><\/a>.\u00a0<\/strong><\/p>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
Why Bank Reconciliation? Bank Reconciliation makes sure the bank balance in your Balance Sheet is the same a the actual balance at the bank. This is a crucial part of ensuring the overall accuracy and integrity of your accounts and a requirement for auditing. Verifying that your balance sheet bank balance matches the balance at Read more about Bank Reconciliation & Bank Matching<\/span>[…]<\/a><\/p>\n","protected":false},"author":1,"featured_media":990,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[4],"_links":{"self":[{"href":"https:\/\/sagefinancialsknowhow.com\/wp-json\/wp\/v2\/posts\/931"}],"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=931"}],"version-history":[{"count":0,"href":"https:\/\/sagefinancialsknowhow.com\/wp-json\/wp\/v2\/posts\/931\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sagefinancialsknowhow.com\/wp-json\/wp\/v2\/media\/990"}],"wp:attachment":[{"href":"https:\/\/sagefinancialsknowhow.com\/wp-json\/wp\/v2\/media?parent=931"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sagefinancialsknowhow.com\/wp-json\/wp\/v2\/categories?post=931"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sagefinancialsknowhow.com\/wp-json\/wp\/v2\/tags?post=931"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
- Payment to suppliers\u00a0processed in Sage, but money not actually paid
- Check the Tag Balance matches the ‘Ledger Account Statement’ balance for each bank account<\/a><\/li>\n