{"id":703,"date":"2026-03-26T14:42:13","date_gmt":"2026-03-26T14:42:13","guid":{"rendered":"https:\/\/www.sikasoftonline.net\/?p=703"},"modified":"2026-03-26T14:42:13","modified_gmt":"2026-03-26T14:42:13","slug":"bank-reconcilation","status":"publish","type":"post","link":"https:\/\/www.sikasoftonline.net\/index.php\/2026\/03\/26\/bank-reconcilation\/","title":{"rendered":"Bank Reconcilation"},"content":{"rendered":"\n<p>The\u00a0<strong>Bank Reconciliation<\/strong>\u00a0module provides financial administrators the tools to systematically compare internal financial records against external bank statements. It features an intuitive, dual-panel layout where users can filter down to specific bank ledgers on the left and immediately interact with live reconciliation summaries and ledger entries on the right. This ensures all cash book balances match the actual funds held at correspondent banks.<\/p>\n\n\n\n<!--more-->\n\n\n\n<h2 class=\"wp-block-heading\" id=\"user-content-purpose\">PURPOSE<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Accurately match internal GL (General Ledger) bank account balances with corresponding external bank statements.<\/li>\n\n\n\n<li>Visually track outstanding deposits (credit items) and unpresented cheques (debit items) from both &#8220;our&#8221; perspective and &#8220;their&#8221; (the bank&#8217;s) perspective.<\/li>\n\n\n\n<li>Auto-calculate the adjusted balances to highlight and resolve any financial discrepancies.<\/li>\n\n\n\n<li>Generate accurate, printable reconciliation summary reports and detailed ledger item lists for auditing purposes.<\/li>\n<\/ul>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"user-content-step-by-step-guide\">STEP-BY-STEP GUIDE<\/h2>\n\n\n\n<p class=\"has-medium-font-size\"><strong>Step 1 \u2014 Accessing the Module and Filtering<\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Navigate to the<strong>Back Office Module <\/strong>and select\u00a0<strong>Bank Reconciliation<\/strong>\u00a0page via the main navigation sidebar.<\/li>\n\n\n\n<li>Direct your attention to the\u00a0<strong>Reconciliation Filters<\/strong>\u00a0panel on the far left.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-large\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"493\" src=\"https:\/\/www.sikasoftonline.net\/wp-content\/uploads\/2026\/03\/Screenshot-2026-03-26-1434271-1024x493.png\" alt=\"\" class=\"wp-image-704\" srcset=\"https:\/\/www.sikasoftonline.net\/wp-content\/uploads\/2026\/03\/Screenshot-2026-03-26-1434271-1024x493.png 1024w, https:\/\/www.sikasoftonline.net\/wp-content\/uploads\/2026\/03\/Screenshot-2026-03-26-1434271-300x144.png 300w, https:\/\/www.sikasoftonline.net\/wp-content\/uploads\/2026\/03\/Screenshot-2026-03-26-1434271-768x370.png 768w, https:\/\/www.sikasoftonline.net\/wp-content\/uploads\/2026\/03\/Screenshot-2026-03-26-1434271-1536x740.png 1536w, https:\/\/www.sikasoftonline.net\/wp-content\/uploads\/2026\/03\/Screenshot-2026-03-26-1434271.png 1676w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Use the hierarchical dropdowns to locate your target Bank Account. Typically, you will select the target bank directly from the\u00a0<strong>A\/C Name<\/strong>\u00a0dropdown.<\/li>\n\n\n\n<li>Verify the\u00a0<strong>Financial Year<\/strong>\u00a0is correct.<\/li>\n\n\n\n<li>Set your target date range using the\u00a0<strong>From<\/strong>\u00a0and\u00a0<strong>To<\/strong>\u00a0date pickers.<\/li>\n\n\n\n<li>Click the blue\u00a0<strong>View Records<\/strong>\u00a0button at the bottom of the filter panel.<\/li>\n<\/ol>\n\n\n\n<p class=\"has-medium-font-size\"><strong>Step 2 \u2014 Interpreting the Ledger Entries<\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>After clicking &#8220;View Records&#8221;, shift your attention to the bottom-right panel labeled\u00a0<strong>Ledger Entries<\/strong>.<\/li>\n\n\n\n<li>Notice the large text indicators displaying the\u00a0<strong>Opening Balance<\/strong>\u00a0and the\u00a0<strong>Closing Balance<\/strong>\u00a0based on your requested date range.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"139\" src=\"https:\/\/www.sikasoftonline.net\/wp-content\/uploads\/2026\/03\/image-105-1024x139.png\" alt=\"\" class=\"wp-image-707\" srcset=\"https:\/\/www.sikasoftonline.net\/wp-content\/uploads\/2026\/03\/image-105-1024x139.png 1024w, https:\/\/www.sikasoftonline.net\/wp-content\/uploads\/2026\/03\/image-105-300x41.png 300w, https:\/\/www.sikasoftonline.net\/wp-content\/uploads\/2026\/03\/image-105-768x104.png 768w, https:\/\/www.sikasoftonline.net\/wp-content\/uploads\/2026\/03\/image-105.png 1233w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ol class=\"wp-block-list\">\n<li>The data table below will list every debit and credit transaction that occurred during your selected period.<\/li>\n\n\n\n<li>Double-click on any individual row to drill down into the specifics of that transaction if required.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"493\" src=\"https:\/\/www.sikasoftonline.net\/wp-content\/uploads\/2026\/03\/Screenshot-2026-03-26-1434279-1024x493.png\" alt=\"\" class=\"wp-image-706\" srcset=\"https:\/\/www.sikasoftonline.net\/wp-content\/uploads\/2026\/03\/Screenshot-2026-03-26-1434279-1024x493.png 1024w, https:\/\/www.sikasoftonline.net\/wp-content\/uploads\/2026\/03\/Screenshot-2026-03-26-1434279-300x144.png 300w, https:\/\/www.sikasoftonline.net\/wp-content\/uploads\/2026\/03\/Screenshot-2026-03-26-1434279-768x370.png 768w, https:\/\/www.sikasoftonline.net\/wp-content\/uploads\/2026\/03\/Screenshot-2026-03-26-1434279-1536x740.png 1536w, https:\/\/www.sikasoftonline.net\/wp-content\/uploads\/2026\/03\/Screenshot-2026-03-26-1434279.png 1676w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"has-medium-font-size\"><strong>Step 3 \u2014 Performing the Reconciliation<\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Move to the top-right panel labeled\u00a0<strong>Reconciliation Summary<\/strong>.<\/li>\n\n\n\n<li>Notice the top field:\u00a0<strong>Balance as per our books as at&#8230;<\/strong>\u00a0is automatically populated based on your ledger&#8217;s closing balance.<\/li>\n\n\n\n<li>Manually enter the closing balance from your physical or digital external bank statement into the right-hand column field labeled\u00a0<strong>Balance as per their statement<\/strong>.<\/li>\n\n\n\n<li>Identify any discrepancies in the lower table, and input missing items into the appropriate calculation fields:\n<ul class=\"wp-block-list\">\n<li><strong>Add their outstand. credit items<\/strong>\u00a0(Amounts the bank has credited, but are not in your cash book).<\/li>\n\n\n\n<li><strong>Less their outstand. debit items<\/strong>\u00a0(Amounts the bank has debited, but are not in your cash book).<\/li>\n\n\n\n<li><strong>Add our outstand. credit items<\/strong>\u00a0(Unpresented cheques &#8211; amounts you deducted, but the bank hasn&#8217;t yet).<\/li>\n\n\n\n<li><strong>Less our outstand. debit items<\/strong>\u00a0(Uncredited deposits &#8211; amounts you added, but the bank hasn&#8217;t yet).<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>As you type into these adjustment fields, the system will automatically calculate the\u00a0<strong>Their Balance After Reconciliation<\/strong>\u00a0and instantly show the\u00a0<strong>Diff. After Reconciliation<\/strong>\u00a0box.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"493\" src=\"https:\/\/www.sikasoftonline.net\/wp-content\/uploads\/2026\/03\/Screenshot-2026-03-26-1434278-1024x493.png\" alt=\"\" class=\"wp-image-705\" srcset=\"https:\/\/www.sikasoftonline.net\/wp-content\/uploads\/2026\/03\/Screenshot-2026-03-26-1434278-1024x493.png 1024w, https:\/\/www.sikasoftonline.net\/wp-content\/uploads\/2026\/03\/Screenshot-2026-03-26-1434278-300x144.png 300w, https:\/\/www.sikasoftonline.net\/wp-content\/uploads\/2026\/03\/Screenshot-2026-03-26-1434278-768x370.png 768w, https:\/\/www.sikasoftonline.net\/wp-content\/uploads\/2026\/03\/Screenshot-2026-03-26-1434278-1536x740.png 1536w, https:\/\/www.sikasoftonline.net\/wp-content\/uploads\/2026\/03\/Screenshot-2026-03-26-1434278.png 1676w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"has-medium-font-size\"><strong>Step 4 \u2014 Finalizing and Reporting<\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>If the &#8220;Diff. After Reconciliation&#8221; resolves to\u00a0<code>0.00<\/code>, your accounts are perfectly synchronized.<\/li>\n\n\n\n<li>Click the orange <strong>Do Bank Reconciliation<\/strong>\u00a0button to officially stamp and lock the reconciliation.<\/li>\n\n\n\n<li>Use the\u00a0<strong>Print Summary<\/strong>\u00a0or\u00a0<strong>Print Detailed<\/strong>\u00a0buttons to generate physical or PDF copies of the reconciled state for your end-of-month financial packs.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"493\" src=\"https:\/\/www.sikasoftonline.net\/wp-content\/uploads\/2026\/03\/r-1024x493.png\" alt=\"\" class=\"wp-image-708\" srcset=\"https:\/\/www.sikasoftonline.net\/wp-content\/uploads\/2026\/03\/r-1024x493.png 1024w, https:\/\/www.sikasoftonline.net\/wp-content\/uploads\/2026\/03\/r-300x144.png 300w, https:\/\/www.sikasoftonline.net\/wp-content\/uploads\/2026\/03\/r-768x370.png 768w, https:\/\/www.sikasoftonline.net\/wp-content\/uploads\/2026\/03\/r-1536x740.png 1536w, https:\/\/www.sikasoftonline.net\/wp-content\/uploads\/2026\/03\/r.png 1676w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"user-content-key-notes\">KEY NOTES<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Real-Time Calculation:<\/strong>\u00a0The difference calculator is live. Ensure your negative additions are placed in the correct &#8220;Less&#8221; inputs to allow the internal calculator to do the subtraction automatically.<\/li>\n\n\n\n<li><strong>Reporting by Branch:<\/strong>\u00a0If you operate a multi-branch network, utilizing the\u00a0<strong>Report by Branch<\/strong>\u00a0checkbox filter on the left allows you to isolate reconciliation activities to specific cost centers.<\/li>\n\n\n\n<li><strong>Double Click Drill-downs:<\/strong>\u00a0The ledger table supports double-click interaction to quickly jump into specific voucher histories without leaving the active reconciliation screen.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>The\u00a0Bank Reconciliation\u00a0module provides financial administrators the tools to systematically compare internal financial records against external bank statements. It features an intuitive, dual-panel layout where users can filter down to specific bank ledgers on the left and immediately interact with live reconciliation summaries and ledger entries on the right. This ensures all cash book balances match [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":709,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10,27],"tags":[],"class_list":["post-703","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-back-office","category-bank-reconcilation"],"_links":{"self":[{"href":"https:\/\/www.sikasoftonline.net\/index.php\/wp-json\/wp\/v2\/posts\/703","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sikasoftonline.net\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sikasoftonline.net\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sikasoftonline.net\/index.php\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sikasoftonline.net\/index.php\/wp-json\/wp\/v2\/comments?post=703"}],"version-history":[{"count":1,"href":"https:\/\/www.sikasoftonline.net\/index.php\/wp-json\/wp\/v2\/posts\/703\/revisions"}],"predecessor-version":[{"id":710,"href":"https:\/\/www.sikasoftonline.net\/index.php\/wp-json\/wp\/v2\/posts\/703\/revisions\/710"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sikasoftonline.net\/index.php\/wp-json\/wp\/v2\/media\/709"}],"wp:attachment":[{"href":"https:\/\/www.sikasoftonline.net\/index.php\/wp-json\/wp\/v2\/media?parent=703"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sikasoftonline.net\/index.php\/wp-json\/wp\/v2\/categories?post=703"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sikasoftonline.net\/index.php\/wp-json\/wp\/v2\/tags?post=703"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}