{"id":11342,"date":"2015-05-31T11:57:29","date_gmt":"2015-05-31T11:57:29","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=11342"},"modified":"2015-05-31T11:57:29","modified_gmt":"2015-05-31T11:57:29","slug":"bank-reconciliation-status-report","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/05\/31\/bank-reconciliation-status-report\/","title":{"rendered":"Bank Reconciliation Status Report in Sage 300"},"content":{"rendered":"<p style=\"text-align: justify;\">The Bank Reconciliation Status of SAGE 300 ERP lists the status of all transactions for bank accounts, with the amount stated in the bank\u2019s statement currency. The report includes:<\/p>\n<p style=\"text-align: justify;\"><strong>For each bank:<\/strong><\/p>\n<ol style=\"text-align: justify;\">\n<li>Lists of transactions and subtotals for all transactions that appear on the Reconcile Statements form.<\/li>\n<li>The bank total (the sum of all transactions that increase the bank balance, less the transactions that decrease it).<\/li>\n<\/ol>\n<p style=\"text-align: justify;\"><strong>For each transaction:<\/strong><\/p>\n<ol>\n<li style=\"text-align: justify;\">The reconciliation status (for deposits, checks, or returned customer checks), or the transaction type description (for bank statement entries).<\/li>\n<li style=\"text-align: justify;\">The documented amount (that is, the item amount recorded in Sage 300 ERP), the cleared amount (entered when you reconciled the bank account), and the amount of the clearing difference. If the item has not been reconciled, the cleared amount is zero.<\/li>\n<li style=\"text-align: justify;\">If you did not use the Print Deposit Details option, any deleted deposits appear as empty deposits on the report, showing \u201cDeleted\u201d in the status column and zeroes in the other columns. (If you used the Print Deposit Details option, deleted deposits do not appear on the report.)<\/li>\n<li style=\"text-align: justify;\">A summary by a bank for all selected banks appears at the end of the report.<\/li>\n<\/ol>\n<p style=\"text-align: justify;\">So we have come up with the\u00a0<strong>\u201c<a href=\"https:\/\/www.greytrix.com\/product\/sage-300-erp-add-ons\/auto-bank-reconciliation\">Auto Bank Reconciliation module in Sage 300 ERP<\/a>\u201d<\/strong>\u00a0which\u00a0lists the status of all transactions for bank accounts.<\/p>\n<p style=\"text-align: justify;\">To print this report follow the steps mentioned below:<\/p>\n<ol style=\"text-align: justify;\">\n<li>Open Common Services \u2192 Bank Services \u2192 Bank Transactions Reports \u2192 Bank Reconciliation Status Report.<a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/05\/Vendor3.png\"><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter wp-image-11343\" src=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/05\/Vendor3.png\" alt=\"Vendor\" width=\"360\" height=\"345\" \/><\/a><\/li>\n<\/ol>\n<ol start=\"2\">\n<li>Specify the bank or a range of banks to include in the report.<\/li>\n<li>Specify criteria for selecting transactions to include in the report, including:<\/li>\n<\/ol>\n<ul>\n<li>The range of dates to which transactions were posted.<\/li>\n<li>The source application (or a range of applications) that sent the transactions to Bank Services.<\/li>\n<li>Select Reconciliation statuses for withdrawals.<\/li>\n<li>Select Reconciliation statuses for deposits.<\/li>\n<\/ul>\n<ol start=\"4\">\n<li>Select the Print Deposit Details option to print details of individual receipts in a deposit.<\/li>\n<li>Click Print.<\/li>\n<\/ol>\n<p style=\"text-align: justify;\">Below is the screen Shot of the report, it is printed as\u00a0including the withdrawal &amp; deposit reconciliation status as Not Posted &amp; Outstanding.<\/p>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/05\/Vendor4.png\"><img decoding=\"async\" class=\"aligncenter wp-image-11344\" src=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/05\/Vendor4.png\" alt=\"Vendor\" width=\"415\" height=\"289\" \/><\/a><\/p>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/05\/Vendor5.png\"><img decoding=\"async\" class=\"aligncenter wp-image-11345\" src=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/05\/Vendor5.png\" alt=\"Vendor\" width=\"462\" height=\"182\" \/><\/a><\/p>\n<p style=\"text-align: justify;\">This report will help you determine why the reconciliation does not balance &amp; also help you to identify the cleared and outstanding amount in a bank account.<\/p>\n<p><span style=\"font-size: Medium;\"><strong>About Us<\/strong><\/span><br \/>\nGreytrix is a one-stop solution provider for Sage ERP and Sage CRM needs. We provide complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development and implementation expertise.<br \/>\n<a href=\"http:\/\/www.greytrix.com\/\">Greytrix<\/a>\u00a0has some unique solutions of\u00a0<a href=\"http:\/\/www.greytrix.com\/product\/sage-crm\/gumu-sage-100-erp-integration\">Sage 100 integration with Sage CRM<\/a>,\u00a0and <a href=\"http:\/\/www.greytrix.com\/product\/sage-100-erp\/gumu-100-salesforce-integration\">Salesforce.com\u00a0<\/a> along with Sage 100 Migration from Sage 50 US, QuickBooks, Sage Business Vision and Sage Business Works. We also offer best-in-class\u00a0<a href=\"http:\/\/www.greytrix.com\/product\/erp-development\/sage-100-erp\">Sage 100 customization and development services\u00a0<\/a>to Sage business partners, end users, and Sage PSG worldwide.<br \/>\nFor more details on Sage 100 Services, please contact us at\u00a0<a href=\"mailto:sage@greytrix.com\">sage@greytrix.com<\/a>. We will be glad to assist you.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The Bank Reconciliation Status of SAGE 300 ERP lists the status of all transactions for bank accounts, with the amount stated in the bank\u2019s statement currency. The report includes: For each bank: Lists of transactions and subtotals for all transactions that appear on the Reconcile Statements form. The bank total (the sum of all transactions\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/05\/31\/bank-reconciliation-status-report\/\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[18,336,338,339,343,497,879,2188,2311],"class_list":["post-11342","post","type-post","status-publish","format-standard","hentry","category-sage-accpac","tag-18","tag-bank-reconciliation","tag-bank-reconciliation-status-of-sage-300-erp","tag-bank-reconciliation-status-report","tag-bank-services","tag-common-services","tag-erp-accpac","tag-reconciliation-status","tag-sage"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Bank Reconciliation Status Report in Sage 300 - Sage 300 ERP \u2013 Tips, Tricks and Components<\/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.greytrix.com\/blogs\/sageaccpacerp\/2015\/05\/31\/bank-reconciliation-status-report\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bank Reconciliation Status Report in Sage 300 - Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"The Bank Reconciliation Status of SAGE 300 ERP lists the status of all transactions for bank accounts, with the amount stated in the bank\u2019s statement currency. The report includes: For each bank: Lists of transactions and subtotals for all transactions that appear on the Reconcile Statements form. The bank total (the sum of all transactions\u2026 Read More &raquo;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/05\/31\/bank-reconciliation-status-report\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2015-05-31T11:57:29+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/05\/Vendor3.png\" \/>\n<meta name=\"author\" content=\"sage300\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"sage300\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/05\/31\/bank-reconciliation-status-report\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/05\/31\/bank-reconciliation-status-report\/\",\"name\":\"Bank Reconciliation Status Report in Sage 300 - Sage 300 ERP \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/05\/31\/bank-reconciliation-status-report\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/05\/31\/bank-reconciliation-status-report\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/05\/Vendor3.png\",\"datePublished\":\"2015-05-31T11:57:29+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/05\/31\/bank-reconciliation-status-report\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/05\/31\/bank-reconciliation-status-report\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/05\/31\/bank-reconciliation-status-report\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/05\/Vendor3.png\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/05\/Vendor3.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/05\/31\/bank-reconciliation-status-report\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bank Reconciliation Status Report in Sage 300\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\",\"name\":\"Sage 300 ERP \u2013 Tips, Tricks and Components\",\"description\":\"Explore the world of Sage 300 with our insightful blogs, expert tips, and the latest updates. We\u2019ll empower you to leverage Sage 300 to its fullest potential. As your one-stop partner, Greytrix delivers exceptional solutions and integrations for Sage 300. Our blogs extend our support to businesses, covering the latest insights and trends. Dive in and transform your Sage 300 experience with us! \",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\",\"name\":\"sage300\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"caption\":\"sage300\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/author\/sageaccpac\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Bank Reconciliation Status Report in Sage 300 - Sage 300 ERP \u2013 Tips, Tricks and Components","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.greytrix.com\/blogs\/sageaccpacerp\/2015\/05\/31\/bank-reconciliation-status-report\/","og_locale":"en_US","og_type":"article","og_title":"Bank Reconciliation Status Report in Sage 300 - Sage 300 ERP \u2013 Tips, Tricks and Components","og_description":"The Bank Reconciliation Status of SAGE 300 ERP lists the status of all transactions for bank accounts, with the amount stated in the bank\u2019s statement currency. The report includes: For each bank: Lists of transactions and subtotals for all transactions that appear on the Reconcile Statements form. The bank total (the sum of all transactions\u2026 Read More &raquo;","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/05\/31\/bank-reconciliation-status-report\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2015-05-31T11:57:29+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/05\/Vendor3.png","type":"","width":"","height":""}],"author":"sage300","twitter_card":"summary_large_image","twitter_misc":{"Written by":"sage300","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/05\/31\/bank-reconciliation-status-report\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/05\/31\/bank-reconciliation-status-report\/","name":"Bank Reconciliation Status Report in Sage 300 - Sage 300 ERP \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/05\/31\/bank-reconciliation-status-report\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/05\/31\/bank-reconciliation-status-report\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/05\/Vendor3.png","datePublished":"2015-05-31T11:57:29+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/05\/31\/bank-reconciliation-status-report\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/05\/31\/bank-reconciliation-status-report\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/05\/31\/bank-reconciliation-status-report\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/05\/Vendor3.png","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/05\/Vendor3.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/05\/31\/bank-reconciliation-status-report\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"Bank Reconciliation Status Report in Sage 300"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/","name":"Sage 300 ERP \u2013 Tips, Tricks and Components","description":"Explore the world of Sage 300 with our insightful blogs, expert tips, and the latest updates. We\u2019ll empower you to leverage Sage 300 to its fullest potential. As your one-stop partner, Greytrix delivers exceptional solutions and integrations for Sage 300. Our blogs extend our support to businesses, covering the latest insights and trends. Dive in and transform your Sage 300 experience with us! ","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5","name":"sage300","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","caption":"sage300"},"url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/author\/sageaccpac\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/11342","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/comments?post=11342"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/11342\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=11342"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=11342"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=11342"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}