{"id":14627,"date":"2020-07-26T10:24:00","date_gmt":"2020-07-26T00:24:00","guid":{"rendered":"https:\/\/ebs.com.au\/?p=14627"},"modified":"2023-10-04T14:32:51","modified_gmt":"2023-10-04T03:32:51","slug":"reconciliation-of-general-ledger-and-sub-ledgers-business-central","status":"publish","type":"post","link":"https:\/\/ebs.com.au\/blog\/reconciliation-of-general-ledger-and-sub-ledgers-business-central","title":{"rendered":"Reconciliation of General Ledger and Sub Ledgers in Business Central"},"content":{"rendered":"\n[et_pb_section fb_built=&#8221;1&#8243; _builder_version=&#8221;4.4.7&#8243;][et_pb_row _builder_version=&#8221;4.4.7&#8243;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.4.7&#8243;][et_pb_text _builder_version=&#8221;4.4.7&#8243;]<h4>This blog will help you gain a better understanding of how to reconcile sub-ledgers to the general ledger in Microsoft\u00a0Dynamics 365 Business Central and NAV.<\/h4>\n<p>The reconciliation checks for each period sub-ledger so that\u00a0the balances of the general ledger accounts in general ledger match the balances of the assigned sub-ledger accounts. For example, compare the balances of the trade debtors accounts in a general ledger against the balances of the assigned customer in receivable.<\/p>\n<p>This process helps you find differences between sub-module (i.e. receivable, payable, bank) and general ledger. The general ledger balance for the receivable should agree with the total on the report generated from the sub-module (i.e. aged accounts receivable).<\/p>\n<p>Normally, if you are posting everything through from the sub-ledgers to the general ledger, the balances should match without any issue.<\/p>\n<h2>What can cause a difference in the sub-ledger and general ledger balances?<\/h2>\n<p>There are a few factors that can cause discrepancies between sub-ledgers and the general ledger balances:<\/p>\n<ul>\n<li>Entries posted in the sub-ledger is adjusted\/corrected at the general ledger level.<\/li>\n<li>Manual posting to the sub-ledger control account in the general ledger.<\/li>\n<\/ul>\n<p>Therefore, we suggest\u00a0that you regularly\u00a0review the general ledger accounts to ensure the control account (account assigned in posting group such as customer, vendor, bank, fixed asset and inventory) does not allow direct posting to the G\/L account.<\/p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/ebs.com.au\/wp-content\/uploads\/Reconciling-GL-sub-ledgers.jpg&#8221; alt=&#8221;reconciling general ledger and sub ledger in Business Central&#8221; title_text=&#8221;Reconciling-GL-sub-ledgers&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.4.7&#8243;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.4.7&#8243; custom_padding=&#8221;9px|||||&#8221;]<h2>What accounts should be reconciled in the general ledger?<\/h2>\n<p>The general ledger account should be setup in posting group such as:<\/p>\n<ul>\n<li>customer posting group,<\/li>\n<li>vendor posting group,<\/li>\n<li>bank posting group,<\/li>\n<li>fixed assets posting group, and<\/li>\n<li>inventory posting<\/li>\n<\/ul>\n<p>This determines which general ledger account system posts the transaction. Therefore, the total value generated from the sub-module needs to match with the control account in the general ledger.<\/p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/ebs.com.au\/wp-content\/uploads\/Reconciliation-of-General-ledger-and-sub-ledgers-in-MS-Dynamics-NAV-im2.png&#8221; title_text=&#8221;reconciliation-of-general-ledger-and-sub-ledgers-in-ms-dynamics2&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.4.7&#8243;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.4.7&#8243;]<h2>What reports should be used for general ledger reconciliation?<\/h2>\n<p><span>As part of the reconciliation process, we recommend that you run the following report for the reconciliation:<\/span><\/p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;1_3,1_3,1_3&#8243; _builder_version=&#8221;4.4.7&#8243;][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;4.4.7&#8243;][et_pb_text _builder_version=&#8221;4.4.7&#8243; hover_enabled=&#8221;0&#8243; header_3_font_size=&#8221;15px&#8221; header_3_text_color=&#8221;#9ab82f&#8221;]<h3>General Ledger<\/h3>\n<ul>\n<li>Trial balance<\/li>\n<li>Details trial balance<\/li>\n<li>Account schedule<\/li>\n<\/ul>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;4.4.7&#8243;][et_pb_text _builder_version=&#8221;4.4.7&#8243; hover_enabled=&#8221;0&#8243; header_3_font_size=&#8221;15px&#8221; header_3_text_color=&#8221;#9ab82f&#8221;]<h3>Receivables<\/h3>\n<ul>\n<li>Aged account receivable<\/li>\n<li>Reconcile customer and vendor accounts<\/li>\n<\/ul>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;4.4.7&#8243;][et_pb_text _builder_version=&#8221;4.4.7&#8243; hover_enabled=&#8221;0&#8243; header_3_font_size=&#8221;15px&#8221; header_3_text_color=&#8221;#9ab82f&#8221;]<h3>Payables<\/h3>\n<ul>\n<li>Aged account payable<\/li>\n<li>Reconcile customer and vendor accounts<\/li>\n<\/ul>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;1_3,1_3,1_3&#8243; _builder_version=&#8221;4.4.7&#8243;][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;4.4.7&#8243;][et_pb_text _builder_version=&#8221;4.4.7&#8243; hover_enabled=&#8221;0&#8243; header_3_font_size=&#8221;15px&#8221; header_text_color=&#8221;#9ab82f&#8221; header_3_text_color=&#8221;#9ab82f&#8221;]<h3>Cash management<\/h3>\n<ul>\n<li>Bank reconciliation<\/li>\n<li>Bank account &#8211; detail trial balance<\/li>\n<\/ul>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;4.4.7&#8243;][et_pb_text _builder_version=&#8221;4.4.7&#8243; hover_enabled=&#8221;0&#8243; header_3_font_size=&#8221;15px&#8221; header_3_text_color=&#8221;#9ab82f&#8221;]<h3>Fixed assets<\/h3>\n<ul>\n<li>FA book value 01<\/li>\n<li>Fixed asset &#8211; G\/L analysis<\/li>\n<\/ul>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;4.4.7&#8243;][et_pb_text _builder_version=&#8221;4.4.7&#8243; hover_enabled=&#8221;0&#8243; header_3_text_color=&#8221;#9ab82f&#8221; header_3_font_size=&#8221;15px&#8221;]<h3>Inventory<\/h3>\n<ul>\n<li>Inventory valuation<\/li>\n<li>Inventory &#8211; G\/L reconciliation<\/li>\n<\/ul>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]\n","protected":false},"excerpt":{"rendered":"<p>This blog will help you gain a better understanding of how to reconcile sub-ledgers to the general ledger in Microsoft\u00a0Dynamics 365 Business Central and NAV. The reconciliation checks for each period sub-ledger so that\u00a0the balances of the general ledger accounts in general ledger match the balances of the assigned sub-ledger accounts. For example, compare the [&hellip;]<\/p>\n","protected":false},"author":28,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"Reconciliation of General Ledger and Sub Ledgers in Business Central","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"content-type":"","_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[60],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v22.5 (Yoast SEO v22.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Reconciliation of General Ledger &amp; Sub Ledger in MS Dynamics BC - EBS<\/title>\n<meta name=\"description\" content=\"This blog post explains the general ledger and sub ledger reconciliation in Microsoft Dynamics 365 Business Central and NAV.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/ebs.com.au\/blog\/reconciliation-of-general-ledger-and-sub-ledgers-business-central\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Reconciliation of General Ledger and Sub Ledgers in Business Central\" \/>\n<meta property=\"og:description\" content=\"This blog post explains the general ledger and sub ledger reconciliation in Microsoft Dynamics 365 Business Central and NAV.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ebs.com.au\/blog\/reconciliation-of-general-ledger-and-sub-ledgers-business-central\" \/>\n<meta property=\"og:site_name\" content=\"Evolution Business Systems\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/EvolutionBusinessSystems\" \/>\n<meta property=\"article:published_time\" content=\"2020-07-26T00:24:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-04T03:32:51+00:00\" \/>\n<meta name=\"author\" content=\"Katrine Ng\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@ebsys\" \/>\n<meta name=\"twitter:site\" content=\"@ebsys\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Katrine Ng\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/ebs.com.au\/blog\/reconciliation-of-general-ledger-and-sub-ledgers-business-central#article\",\"isPartOf\":{\"@id\":\"https:\/\/ebs.com.au\/blog\/reconciliation-of-general-ledger-and-sub-ledgers-business-central\"},\"author\":{\"name\":\"Katrine Ng\",\"@id\":\"https:\/\/ebs.com.au\/#\/schema\/person\/e4765da8794d205b44669b2ab0d5e421\"},\"headline\":\"Reconciliation of General Ledger and Sub Ledgers in Business Central\",\"datePublished\":\"2020-07-26T00:24:00+00:00\",\"dateModified\":\"2023-10-04T03:32:51+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/ebs.com.au\/blog\/reconciliation-of-general-ledger-and-sub-ledgers-business-central\"},\"wordCount\":687,\"publisher\":{\"@id\":\"https:\/\/ebs.com.au\/#organization\"},\"articleSection\":[\"Blog\"],\"inLanguage\":\"en-AU\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ebs.com.au\/blog\/reconciliation-of-general-ledger-and-sub-ledgers-business-central\",\"url\":\"https:\/\/ebs.com.au\/blog\/reconciliation-of-general-ledger-and-sub-ledgers-business-central\",\"name\":\"Reconciliation of General Ledger & Sub Ledger in MS Dynamics BC - EBS\",\"isPartOf\":{\"@id\":\"https:\/\/ebs.com.au\/#website\"},\"datePublished\":\"2020-07-26T00:24:00+00:00\",\"dateModified\":\"2023-10-04T03:32:51+00:00\",\"description\":\"This blog post explains the general ledger and sub ledger reconciliation in Microsoft Dynamics 365 Business Central and NAV.\",\"breadcrumb\":{\"@id\":\"https:\/\/ebs.com.au\/blog\/reconciliation-of-general-ledger-and-sub-ledgers-business-central#breadcrumb\"},\"inLanguage\":\"en-AU\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/ebs.com.au\/blog\/reconciliation-of-general-ledger-and-sub-ledgers-business-central\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/ebs.com.au\/blog\/reconciliation-of-general-ledger-and-sub-ledgers-business-central#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/ebs.com.au\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Reconciliation of General Ledger and Sub Ledgers in Microsoft Dynamics\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/ebs.com.au\/#website\",\"url\":\"https:\/\/ebs.com.au\/\",\"name\":\"Evolution Business Systems\",\"description\":\"Microsoft Dynamics 365 Business Central \/ NAV Business Software\",\"publisher\":{\"@id\":\"https:\/\/ebs.com.au\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/ebs.com.au\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-AU\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/ebs.com.au\/#organization\",\"name\":\"Evolution Business Systems\",\"url\":\"https:\/\/ebs.com.au\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-AU\",\"@id\":\"https:\/\/ebs.com.au\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/i2.wp.com\/ebs.com.au\/wp-content\/uploads\/Evolution-Business-Systems-logo-81.jpg?fit=484%2C176&ssl=1\",\"contentUrl\":\"https:\/\/i2.wp.com\/ebs.com.au\/wp-content\/uploads\/Evolution-Business-Systems-logo-81.jpg?fit=484%2C176&ssl=1\",\"width\":484,\"height\":176,\"caption\":\"Evolution Business Systems\"},\"image\":{\"@id\":\"https:\/\/ebs.com.au\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/EvolutionBusinessSystems\",\"https:\/\/x.com\/ebsys\",\"http:\/\/www.linkedin.com\/company\/evolution-business-systems\",\"https:\/\/www.youtube.com\/user\/ebsystv\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/ebs.com.au\/#\/schema\/person\/e4765da8794d205b44669b2ab0d5e421\",\"name\":\"Katrine Ng\",\"description\":\"Katrine Ng is a Senior Solution Specialist at EBS and has a successful track record in project managing, implementing and delivering high-quality solutions. She likes to help customers translate their needs into business and user requirements. She has worked with Microsoft Dynamics 365 Business Central and Dynamics NAV in Australia and Malaysia since 2003.\",\"url\":\"https:\/\/ebs.com.au\/author\/katrine-ng\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Reconciliation of General Ledger & Sub Ledger in MS Dynamics BC - EBS","description":"This blog post explains the general ledger and sub ledger reconciliation in Microsoft Dynamics 365 Business Central and NAV.","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:\/\/ebs.com.au\/blog\/reconciliation-of-general-ledger-and-sub-ledgers-business-central","og_locale":"en_US","og_type":"article","og_title":"Reconciliation of General Ledger and Sub Ledgers in Business Central","og_description":"This blog post explains the general ledger and sub ledger reconciliation in Microsoft Dynamics 365 Business Central and NAV.","og_url":"https:\/\/ebs.com.au\/blog\/reconciliation-of-general-ledger-and-sub-ledgers-business-central","og_site_name":"Evolution Business Systems","article_publisher":"https:\/\/www.facebook.com\/EvolutionBusinessSystems","article_published_time":"2020-07-26T00:24:00+00:00","article_modified_time":"2023-10-04T03:32:51+00:00","author":"Katrine Ng","twitter_card":"summary_large_image","twitter_creator":"@ebsys","twitter_site":"@ebsys","twitter_misc":{"Written by":"Katrine Ng","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/ebs.com.au\/blog\/reconciliation-of-general-ledger-and-sub-ledgers-business-central#article","isPartOf":{"@id":"https:\/\/ebs.com.au\/blog\/reconciliation-of-general-ledger-and-sub-ledgers-business-central"},"author":{"name":"Katrine Ng","@id":"https:\/\/ebs.com.au\/#\/schema\/person\/e4765da8794d205b44669b2ab0d5e421"},"headline":"Reconciliation of General Ledger and Sub Ledgers in Business Central","datePublished":"2020-07-26T00:24:00+00:00","dateModified":"2023-10-04T03:32:51+00:00","mainEntityOfPage":{"@id":"https:\/\/ebs.com.au\/blog\/reconciliation-of-general-ledger-and-sub-ledgers-business-central"},"wordCount":687,"publisher":{"@id":"https:\/\/ebs.com.au\/#organization"},"articleSection":["Blog"],"inLanguage":"en-AU"},{"@type":"WebPage","@id":"https:\/\/ebs.com.au\/blog\/reconciliation-of-general-ledger-and-sub-ledgers-business-central","url":"https:\/\/ebs.com.au\/blog\/reconciliation-of-general-ledger-and-sub-ledgers-business-central","name":"Reconciliation of General Ledger & Sub Ledger in MS Dynamics BC - EBS","isPartOf":{"@id":"https:\/\/ebs.com.au\/#website"},"datePublished":"2020-07-26T00:24:00+00:00","dateModified":"2023-10-04T03:32:51+00:00","description":"This blog post explains the general ledger and sub ledger reconciliation in Microsoft Dynamics 365 Business Central and NAV.","breadcrumb":{"@id":"https:\/\/ebs.com.au\/blog\/reconciliation-of-general-ledger-and-sub-ledgers-business-central#breadcrumb"},"inLanguage":"en-AU","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ebs.com.au\/blog\/reconciliation-of-general-ledger-and-sub-ledgers-business-central"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/ebs.com.au\/blog\/reconciliation-of-general-ledger-and-sub-ledgers-business-central#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/ebs.com.au\/"},{"@type":"ListItem","position":2,"name":"Reconciliation of General Ledger and Sub Ledgers in Microsoft Dynamics"}]},{"@type":"WebSite","@id":"https:\/\/ebs.com.au\/#website","url":"https:\/\/ebs.com.au\/","name":"Evolution Business Systems","description":"Microsoft Dynamics 365 Business Central \/ NAV Business Software","publisher":{"@id":"https:\/\/ebs.com.au\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ebs.com.au\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-AU"},{"@type":"Organization","@id":"https:\/\/ebs.com.au\/#organization","name":"Evolution Business Systems","url":"https:\/\/ebs.com.au\/","logo":{"@type":"ImageObject","inLanguage":"en-AU","@id":"https:\/\/ebs.com.au\/#\/schema\/logo\/image\/","url":"https:\/\/i2.wp.com\/ebs.com.au\/wp-content\/uploads\/Evolution-Business-Systems-logo-81.jpg?fit=484%2C176&ssl=1","contentUrl":"https:\/\/i2.wp.com\/ebs.com.au\/wp-content\/uploads\/Evolution-Business-Systems-logo-81.jpg?fit=484%2C176&ssl=1","width":484,"height":176,"caption":"Evolution Business Systems"},"image":{"@id":"https:\/\/ebs.com.au\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/EvolutionBusinessSystems","https:\/\/x.com\/ebsys","http:\/\/www.linkedin.com\/company\/evolution-business-systems","https:\/\/www.youtube.com\/user\/ebsystv"]},{"@type":"Person","@id":"https:\/\/ebs.com.au\/#\/schema\/person\/e4765da8794d205b44669b2ab0d5e421","name":"Katrine Ng","description":"Katrine Ng is a Senior Solution Specialist at EBS and has a successful track record in project managing, implementing and delivering high-quality solutions. She likes to help customers translate their needs into business and user requirements. She has worked with Microsoft Dynamics 365 Business Central and Dynamics NAV in Australia and Malaysia since 2003.","url":"https:\/\/ebs.com.au\/author\/katrine-ng"}]}},"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/ebs.com.au\/wp-json\/wp\/v2\/posts\/14627"}],"collection":[{"href":"https:\/\/ebs.com.au\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ebs.com.au\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ebs.com.au\/wp-json\/wp\/v2\/users\/28"}],"replies":[{"embeddable":true,"href":"https:\/\/ebs.com.au\/wp-json\/wp\/v2\/comments?post=14627"}],"version-history":[{"count":1,"href":"https:\/\/ebs.com.au\/wp-json\/wp\/v2\/posts\/14627\/revisions"}],"predecessor-version":[{"id":18801,"href":"https:\/\/ebs.com.au\/wp-json\/wp\/v2\/posts\/14627\/revisions\/18801"}],"wp:attachment":[{"href":"https:\/\/ebs.com.au\/wp-json\/wp\/v2\/media?parent=14627"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ebs.com.au\/wp-json\/wp\/v2\/categories?post=14627"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ebs.com.au\/wp-json\/wp\/v2\/tags?post=14627"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}