{"id":84748,"date":"2023-04-19T06:37:50","date_gmt":"2023-04-19T06:37:50","guid":{"rendered":"https:\/\/www.bigxperts.com\/sage\/?p=84748"},"modified":"2025-03-13T06:51:59","modified_gmt":"2025-03-13T06:51:59","slug":"sage-50-bank-reconciliation-issues","status":"publish","type":"post","link":"https:\/\/www.bigxperts.com\/sage\/sage-50-bank-reconciliation-issues\/","title":{"rendered":"Resolve Sage 50 Bank Reconciliation Issues: Unresolved Amount or Reconciliation Discrepancy"},"content":{"rendered":"\n<p>Bank reconciliation statements are financial papers that describe your bank account activity as well as internally recorded actions, show that the two records are consistent, and are used to reconcile your bank accounts. During the tax preparation process, bank reconciliation errors in Sage 50 can happen. When you reconcile, you are confirming that the transactions in Accounting match the ones on your bank statement.<\/p>\n\n\n\n<p>If you have found missing entries and still find &#8220;<strong>Bank reconciliation shows a discrepancy<\/strong>&#8220;, or<strong> <\/strong>&#8220;<strong>Bank reconciliation shows an unresolved amount<\/strong>&#8221; in the bank reconciliation journals then you need to verify the accounts appearing in the bank statement with the opening balance statement. If it is not zero at this stage, you should check Sage 50 bank reconciliation fixing techniques. Let\u2019s dive deep into Sage 50 bank reconciliation discrepancy or unresolved amount issues and their root causes and resolve them.<\/p>\n\n\n\n<p><strong>The exact error message is shown<\/strong>&#8230;<\/p>\n\n\n\n<p>Sage 50 Error: &#8220;Bank reconciliation shows a discrepancy&#8221; or &#8220;an unresolved amount&#8221;<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Post Navigation<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 eztoc-toggle-hide-by-default' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.bigxperts.com\/sage\/sage-50-bank-reconciliation-issues\/#reasons-for-unresolved-amount-in-sage-50-reconciliation\" >Reasons for Unresolved Amount in Sage 50 Reconciliation<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.bigxperts.com\/sage\/sage-50-bank-reconciliation-issues\/#resolution-steps-for-sage-50-bank-reconciliation-discrepancy\" >Resolution Steps for Sage 50 Bank Reconciliation Discrepancy<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.bigxperts.com\/sage\/sage-50-bank-reconciliation-issues\/#resolution-1-verify-the-causes-of-the-discrepancy\" >Resolution 1: Verify the causes of the discrepancy<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.bigxperts.com\/sage\/sage-50-bank-reconciliation-issues\/#resolution-2-if-a-discrepancy-is-found-but-a-bank-reconciliation-does-not-report-an-error\" >Resolution 2: If a discrepancy is found but a bank reconciliation does not report an error<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.bigxperts.com\/sage\/sage-50-bank-reconciliation-issues\/#resolution-3-how-should-i-approach-a-sage-50-unresolved-reconciliation-issue\" >Resolution 3: How Should I Approach a Sage 50 Unresolved Reconciliation Issue?<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.bigxperts.com\/sage\/sage-50-bank-reconciliation-issues\/#why-should-i-reset-sage-50s-bank-reconciliation\" >Why Should I Reset Sage 50&#8217;s Bank Reconciliation?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.bigxperts.com\/sage\/sage-50-bank-reconciliation-issues\/#resetting-the-sage-50-bank-reconciliation\" >Resetting the Sage 50 Bank Reconciliation<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.bigxperts.com\/sage\/sage-50-bank-reconciliation-issues\/#step-1-create-a-backup\" >Step 1: Create a backup<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.bigxperts.com\/sage\/sage-50-bank-reconciliation-issues\/#step-2-compile-a-list-of-all-outstanding-transactions\" >Step 2: Compile a list of all outstanding transactions<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/www.bigxperts.com\/sage\/sage-50-bank-reconciliation-issues\/#step-3-clear-the-bank-reconciliation-in-sage-50\" >Step 3: Clear the bank reconciliation in Sage 50<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/www.bigxperts.com\/sage\/sage-50-bank-reconciliation-issues\/#step-4-reactivate-the-bank-account-for-the-bank-reconciliation\" >Step 4: Reactivate the bank account for the bank reconciliation<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/www.bigxperts.com\/sage\/sage-50-bank-reconciliation-issues\/#setup-sage-50-bank-reconciliation\" >Setup Sage 50 Bank Reconciliation<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/www.bigxperts.com\/sage\/sage-50-bank-reconciliation-issues\/#how-important-is-bank-reconciliation\" >How Important is Bank Reconciliation?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/www.bigxperts.com\/sage\/sage-50-bank-reconciliation-issues\/#conclusion\" >Conclusion<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/www.bigxperts.com\/sage\/sage-50-bank-reconciliation-issues\/#faqs\" >FAQ&#8217;s<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"reasons-for-unresolved-amount-in-sage-50-reconciliation\"><\/span>Reasons for Unresolved Amount in Sage 50 Reconciliation<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Several reconciliation modifications, including journal entries and additional, amended, or deleted reconciled transactions, may be the cause of the mismatch. The main causes are: A reconciliation arrangement or previously reconciled transactions have been changed, eliminated, or added. As a result, you had problems reconciling the Sage 50 bank statement.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The statement&#8217;s end date is incorrect.<\/li>\n\n\n\n<li>The statement&#8217;s end balance is incorrect.<\/li>\n\n\n\n<li>Some transactions have the wrong date.<\/li>\n\n\n\n<li>The starting balance does not match the opening balance on your bank statement.<\/li>\n\n\n\n<li>A previous reconciliation was saved with a difference.<\/li>\n\n\n\n<li>A previous reconciliation was saved with the incorrect date.<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-verse\"><strong><em>Similar Topic<\/em><\/strong>: <a href=\"https:\/\/www.bigxperts.com\/sage\/undo-last-bank-reconciliation-in-sage-50\/\">How to Undo Last Bank Reconciliation in Sage 50<\/a><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"resolution-steps-for-sage-50-bank-reconciliation-discrepancy\"><\/span>Resolution Steps for Sage 50 Bank Reconciliation Discrepancy<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>The measures you must take if you have unresolved discrepancies or amount concerns in Sage 50 are as follows:<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"resolution-1-verify-the-causes-of-the-discrepancy\"><\/span>Resolution 1: Verify the causes of the discrepancy<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Verify the opening and closing balances as well as the statement&#8217;s start and end dates.<\/li>\n\n\n\n<li>Verify the transactions&#8217; dates.<\/li>\n\n\n\n<li>The system has a record of every transaction.<\/li>\n\n\n\n<li>Make sure that the transaction on the bank statement has been cleared.<\/li>\n\n\n\n<li>Verify the bank account&#8217;s book balance that is connected to Sage 50.<\/li>\n\n\n\n<li>The total of all unchecked items that show up in the Reconciliation window equals the outstanding amount.<\/li>\n\n\n\n<li>Check to see if the profits and fees you added for the bank in the costs and revenue choices were added appropriately.<\/li>\n\n\n\n<li>Resetting the reconciliation in Sage 50 is advised after it has been confirmed that they don&#8217;t.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"resolution-2-if-a-discrepancy-is-found-but-a-bank-reconciliation-does-not-report-an-error\"><\/span>Resolution 2: If a discrepancy is found but a bank reconciliation does not report an error<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Here is a formula to determine the discrepancy:<\/li>\n\n\n\n<li>Opening book balance minus (opening outstanding plus statement opening balance) equals discrepancy.<\/li>\n\n\n\n<li>You must use the reconciliation&#8217;s remaining outstanding balance from the prior year to determine the opening outstanding values.<\/li>\n\n\n\n<li>The quantity of past outstanding that you have added to the start date is your &#8220;opening outstanding&#8221; if you are undertaking reconciliation for the first time.<\/li>\n\n\n\n<li>The steps to determine the opening book balance value are listed below:\n<ul class=\"wp-block-list\">\n<li>The bank reconciliation cannot move on to the next phase without resolving the mismatch.<\/li>\n\n\n\n<li>Perform the comparisons below to determine if there is data corruption in the bank reconciliation:<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Look up the Opening Book Balance, which is the Statement Opening Balance plus the Opening Outstanding.<\/li>\n\n\n\n<li>If they are not equal, a difference known as a discrepancy amount is displayed.<\/li>\n\n\n\n<li>If they match yet there is still a disparity, the bank reconciliation table&#8217;s data is corrupt. You must restart the bank reconciliation to fix this.<\/li>\n<\/ul>\n\n\n\n<p>If you are starting a reconciliation for the first time, your &#8220;opening outstanding&#8221; is the amount of prior outstanding that you have added to the start date.<\/p>\n\n\n\n<p><strong>The following are the steps to calculate the opening book balance value<\/strong><\/p>\n\n\n\n<p>Without correcting the discrepancy, the bank reconciliation cannot proceed to the following stage:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>To check for data corruption in the bank reconciliation, make the comparisons listed below:<\/li>\n\n\n\n<li>Look up the Opening Book Balance, which combines the Opening Outstanding with the Statement Opening Balance.<\/li>\n\n\n\n<li>A difference known as a discrepancy amount is shown if they are not equal.<\/li>\n\n\n\n<li>If they are identical yet there is still a discrepancy, the data in the bank reconciliation table is flawed. To correct this, you must restart the bank reconciliation.<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">Sage 50 Reconcile for Negative Balance Amount<\/h4>\n\n\n\n<p>The start date of the statement and many missing debit entries for earlier start dates are wrong on the bank reconciliation window.<\/p>\n\n\n\n<h5 class=\"wp-block-heading\">Sage 50: What to Do if the discrepancy is positive<\/h5>\n\n\n\n<p><strong>Its key contributing elements may include:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Too many debit entries were identified before the commencement date, which resulted in an excessively high opening book balance, and the bank reconciliation window&#8217;s start date was set incorrectly.<\/li>\n\n\n\n<li>When a debit check&#8217;s outstanding is insufficient due to a too-low opening outstanding. It may be the consequence of incorrectly posted check posting dates or duplicate entries. Among other things, it might happen if there are a lot of overdue credit checks.<\/li>\n\n\n\n<li>Too low an opening balance on the statement: This is caused by human error on the bank&#8217;s end. Duplicate entries, entering the incorrect sum in the bank reconciliation box, or an incorrect account balance are additional examples of this.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"resolution-3-how-should-i-approach-a-sage-50-unresolved-reconciliation-issue\"><\/span>Resolution 3: How Should I Approach a Sage 50 Unresolved Reconciliation Issue?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Unresolved is typically displayed on screens as either negative or positive.<\/p>\n\n\n\n<p><strong>The following formula must be solved:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Unresolved equals ending book balance minus (statement end balance plus ending outstanding).<\/li>\n\n\n\n<li>The amount shown on the bank reconciliation window represents the outstanding balance.<\/li>\n\n\n\n<li>The following factors might lead to negative unresolved situations:<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">Maximum Book Balance:<\/h4>\n\n\n\n<p>It is due to several debit entries, missing credits when modified transactions occur, and incorrect end dates in reconciliation, among other things.<\/p>\n\n\n\n<p>Too little ending outstanding: Incorrect statement end date, missing outstanding, or problems with outstanding accounts.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">The statement&#8217;s final balance is too low:<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The incorrect end date entered in the statement&#8217;s end date field, human error, and bank errors are to blame.<\/li>\n\n\n\n<li>You must come up with good justifications.<\/li>\n\n\n\n<li>Once you identify the proper reason, make the necessary modifications.<\/li>\n\n\n\n<li>Restart the reconciliation if problems continue.<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">When resolved, is that positive?<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Start by looking for the reasons.<\/li>\n\n\n\n<li>The following causes contribute to this error:<\/li>\n\n\n\n<li>Find the true cause, then make the necessary modifications.<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-verse\"><strong><em>Read More<\/em><\/strong>: <a href=\"https:\/\/www.bigxperts.com\/sage\/sage-balance-sheet-doesnt-balance\/\">Resolve Sage 50 Balance Sheet Doesn\u2019t Balance<\/a><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"why-should-i-reset-sage-50s-bank-reconciliation\"><\/span>Why Should I Reset Sage 50&#8217;s Bank Reconciliation?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>There may be several reasons why you should reset the bank reconciliation. Some of them include:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Account reconciliation for the previous month has already been posted, and a variance amount has been identified.<\/li>\n\n\n\n<li>There is a balance that has not been settled, even though the ending balance and the open balance are equal and nothing is cleared.<\/li>\n\n\n\n<li>Because of certain faulty data in the bank reconciliation database, Sage 50 is reading the incorrect numbers.<\/li>\n\n\n\n<li>Sage 50 is unable to undo bank reconciliations for a certain month.<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-verse\"><strong><em>Read More<\/em><\/strong>: <a href=\"https:\/\/www.bigxperts.com\/sage\/sage-not-showing-all-transactions\/\">Fix Sage 50 Not Showing All Transactions<\/a><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"resetting-the-sage-50-bank-reconciliation\"><\/span>Resetting the Sage 50 Bank Reconciliation<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>If you have a Sage 50 Cloud subscription and are running Sage 50 older or newer, understand how to reverse bank reconciliations to reverse a single bank reconciliation rather than resetting all bank reconciliations linked with an account.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"step-1-create-a-backup\"><\/span>Step 1: Create a backup<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Make a backup of your data since you will permanently lose all previously completed bank reconciliation information.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"step-2-compile-a-list-of-all-outstanding-transactions\"><\/span>Step 2: Compile a list of all outstanding transactions<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Navigate to Reports, Banking, and Account Reconciliation Report.&nbsp;<\/li>\n\n\n\n<li>Select the appropriate bank account, then the appropriate Start Date and Finish Date to view the most recently successfully reconciled period.<\/li>\n\n\n\n<li>Select the \u2018 Report By Statement\u2019 End Date.<\/li>\n\n\n\n<li>Then select the \u2018 Report By Statement\u2019 Option Stop Date<\/li>\n\n\n\n<li>To view the report, click OK.<\/li>\n\n\n\n<li>To save this report, choose Print or Open in Excel.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"step-3-clear-the-bank-reconciliation-in-sage-50\"><\/span>Step 3: Clear the bank reconciliation in Sage 50<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Double-click on the Chart of Accounts.&nbsp;<\/li>\n\n\n\n<li>&nbsp;Then double-click on your bank account.<\/li>\n\n\n\n<li>Then select the \u2018Reconciliation &amp; Deposits\u2019 tab.<\/li>\n\n\n\n<li>&nbsp;Save Transactions for Account Reconciliation is marked; uncheck it.<\/li>\n\n\n\n<li>&nbsp;By selecting &#8220;Save and close,&#8221; you can close the account.<\/li>\n\n\n\n<li>&nbsp;To delete all reconciliation information, click OK.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"step-4-reactivate-the-bank-account-for-the-bank-reconciliation\"><\/span>Step 4: Reactivate the bank account for the bank reconciliation<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Click once or twice on your bank account<\/li>\n\n\n\n<li>The Reconciliation &amp; Deposits tab should be selected.<\/li>\n\n\n\n<li>Mark the box next to Save Transactions for Account Reconciliation with a checkmark.<\/li>\n\n\n\n<li>At the bottom of the page, the Set Up button is there.<\/li>\n\n\n\n<li>To set up revenue accounts for interest income, exchange gain, error gain, and adjustments, click on it.<\/li>\n\n\n\n<li>Additionally, you may create spending accounts for bank fees, NSF fees, and interest costs.<\/li>\n\n\n\n<li>You can close the account By selecting &#8220;Save and close.&#8221;<\/li>\n\n\n\n<li>Click on the X in the corner of the accounts window to close it<\/li>\n\n\n\n<li>Once you&#8217;ve added all the outstanding transactions, click OK.<\/li>\n\n\n\n<li>Leave the Outstanding Transactions list blank and click OK if you don&#8217;t have any outstanding transactions to bring in.<\/li>\n\n\n\n<li>Now you can easily do a new bank account reconciliation.<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-verse\"><strong><em>Similar Topic<\/em><\/strong>: <a href=\"https:\/\/www.bigxperts.com\/sage\/undo-the-last-bank-reconciliation-in-sage-50-2\/\">Undo the Last Bank Reconciliation in Sage 50<\/a><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"setup-sage-50-bank-reconciliation\"><\/span>Setup Sage 50 Bank Reconciliation<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Double-click on the Account Reconciliation journal to start.<\/li>\n\n\n\n<li>Next, decide which bank account you want to set up.&nbsp; Then, enter the statement&#8217;s start and end dates as well as the reconciliation date.&nbsp;<\/li>\n\n\n\n<li>Add the Statement opening and closing balances from the financial institution&#8217;s report to the statement.<\/li>\n\n\n\n<li>Select the button labeled &#8220;ADD Prior Outstanding&#8221; after listing all the open issues that date back to the start date.<\/li>\n\n\n\n<li>The question &#8220;Do you want to save the changes?&#8221; appears in a pop-up window. Next, click on OK.<\/li>\n\n\n\n<li>Next, make sure that \u2018Show Resolved Transaction On or after\u2019 is selected.&nbsp;<\/li>\n\n\n\n<li>Select the \u2018Resolved Transaction\u2019 option.<\/li>\n\n\n\n<li>To move it to Outstanding Transactions, select Add.<\/li>\n\n\n\n<li>Click on Insert Statement if any outstanding transactions aren&#8217;t listed in the list.<\/li>\n\n\n\n<li>Press the OK button in the end.<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-verse\"><strong><em>Read More<\/em><\/strong>: <a href=\"https:\/\/www.bigxperts.com\/sage\/enter-opening-balances-in-sage-50\/\">How to Enter Opening Balances in Sage 50<\/a><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"how-important-is-bank-reconciliation\"><\/span>How Important is Bank Reconciliation?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Comparing your records to the bank&#8217;s records is known as bank reconciliation. You can find any unexpected transactions that might be the result of fraud or accounting mistakes by using a monthly reconciliation.&nbsp;<\/p>\n\n\n\n<p>Users performed the initial balance adjustment to reconcile and then discovered they should have started from the next month. To deal with this situation, Sage enables you to investigate the Sage 50 Clear bank reconciliation method, which is quite similar to Undo Reconciliation, and clear the reconciliation account to reset the desired value. The difference between the two procedures in Sage 50 is that while resetting reconciliation, you must take a significant number of transactions.&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"conclusion\"><\/span>Conclusion<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>This article contains everything you need to know about Sage 50 reconciliation issues and solutions. Connect with our team if you run into any problems while executing these steps or if you require any more help with the reconciliation process. This article acts as a one-stop shop for all Sage reconcile-related issues, including reconciling statements. reconciliatory pharmacies, etc. If you still face any problems, <a href=\"https:\/\/www.bigxperts.com\/sage\/sage-50-live-chat\/\">connect to the Sage 50 experts via chat<\/a>, call 1800-892-1352, or email.<\/p>\n\n\n\n<h2 class=\"wp-block-heading has-text-align-center\"><span class=\"ez-toc-section\" id=\"faqs\"><\/span>FAQ&#8217;s<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n<div class=\"wp-block-uagb-faq uagb-faq__outer-wrap uagb-block-5da419e3 uagb-faq-icon-row uagb-faq-layout-accordion uagb-faq-expand-first-true uagb-faq-inactive-other-true uagb-faq__wrap uagb-buttons-layout-wrap uagb-faq-equal-height     \" data-faqtoggle=\"true\" role=\"tablist\"><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-207499c1 \" role=\"tab\" tabindex=\"0\"><div class=\"uagb-faq-questions-button uagb-faq-questions\">\t\t\t<span class=\"uagb-icon uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M432 256c0 17.69-14.33 32.01-32 32.01H256v144c0 17.69-14.33 31.99-32 31.99s-32-14.3-32-31.99v-144H48c-17.67 0-32-14.32-32-32.01s14.33-31.99 32-31.99H192v-144c0-17.69 14.33-32.01 32-32.01s32 14.32 32 32.01v144h144C417.7 224 432 238.3 432 256z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span class=\"uagb-icon-active uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M400 288h-352c-17.69 0-32-14.32-32-32.01s14.31-31.99 32-31.99h352c17.69 0 32 14.3 32 31.99S417.7 288 400 288z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t<span class=\"uagb-question\">How do I set up an account in Sage 50 for bank reconciliation?<\/span><\/div><div class=\"uagb-faq-content\"><p>\ud83d\udca0 Select Accounts from the Home window.\u00a0<br>\ud83d\udca0 Go to the desired account and open it.\u00a0<br>\ud83d\udca0 Check the box next to Save Transactions For Account Reconciliation on the Account Reconciliation tab.\u00a0<br>\ud83d\udca0 You don&#8217;t have to fill out every box; simply click the Set Up button and then choose the income, expense, and adjustment accounts you added in Step 2.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-dca4da37 \" role=\"tab\" tabindex=\"0\"><div class=\"uagb-faq-questions-button uagb-faq-questions\">\t\t\t<span class=\"uagb-icon uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M432 256c0 17.69-14.33 32.01-32 32.01H256v144c0 17.69-14.33 31.99-32 31.99s-32-14.3-32-31.99v-144H48c-17.67 0-32-14.32-32-32.01s14.33-31.99 32-31.99H192v-144c0-17.69 14.33-32.01 32-32.01s32 14.32 32 32.01v144h144C417.7 224 432 238.3 432 256z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span class=\"uagb-icon-active uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M400 288h-352c-17.69 0-32-14.32-32-32.01s14.31-31.99 32-31.99h352c17.69 0 32 14.3 32 31.99S417.7 288 400 288z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t<span class=\"uagb-question\">How can I identify and correct mistakes in my bank reconciliation?<\/span><\/div><div class=\"uagb-faq-content\"><p>\ud83d\udca0 Check if the beginning balance and the previous ending balance are equal.<br>\ud83d\udca0 Compare the account balance with the ending balance.<br>\ud83d\udca0 Check the total of the remaining checks and deposits.<br>\ud83d\udca0 Check the sum, deposits, and checks of the bank.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-0b096f68 \" role=\"tab\" tabindex=\"0\"><div class=\"uagb-faq-questions-button uagb-faq-questions\">\t\t\t<span class=\"uagb-icon uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M432 256c0 17.69-14.33 32.01-32 32.01H256v144c0 17.69-14.33 31.99-32 31.99s-32-14.3-32-31.99v-144H48c-17.67 0-32-14.32-32-32.01s14.33-31.99 32-31.99H192v-144c0-17.69 14.33-32.01 32-32.01s32 14.32 32 32.01v144h144C417.7 224 432 238.3 432 256z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span class=\"uagb-icon-active uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M400 288h-352c-17.69 0-32-14.32-32-32.01s14.31-31.99 32-31.99h352c17.69 0 32 14.3 32 31.99S417.7 288 400 288z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t<span class=\"uagb-question\">How is a bank reconciliation set up?<\/span><\/div><div class=\"uagb-faq-content\"><p>\ud83d\udca0 Acquire bank records. You require the list of transactions.<br>\ud83d\udca0 Get the company&#8217;s records. Open your income and expense ledger.<br>\ud83d\udca0 Decide where you want to start.<br>\ud83d\udca0 Check your bank deposits.<br>\ud83d\udca0 Check your books for income.<br>\ud83d\udca0 Make all necessary bank withdrawals.<br>\ud83d\udca0 Verify the costs listed in your books.<br>\ud83d\udca0 Check the ending balance.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-e93299ec \" role=\"tab\" tabindex=\"0\"><div class=\"uagb-faq-questions-button uagb-faq-questions\">\t\t\t<span class=\"uagb-icon uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M432 256c0 17.69-14.33 32.01-32 32.01H256v144c0 17.69-14.33 31.99-32 31.99s-32-14.3-32-31.99v-144H48c-17.67 0-32-14.32-32-32.01s14.33-31.99 32-31.99H192v-144c0-17.69 14.33-32.01 32-32.01s32 14.32 32 32.01v144h144C417.7 224 432 238.3 432 256z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span class=\"uagb-icon-active uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M400 288h-352c-17.69 0-32-14.32-32-32.01s14.31-31.99 32-31.99h352c17.69 0 32 14.3 32 31.99S417.7 288 400 288z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t<span class=\"uagb-question\">Why isn&#8217;t the balance in my bank reconciling?<\/span><\/div><div class=\"uagb-faq-content\"><p>\ud83d\udca0 Because the date on some transactions is incorrect.\u00a0<br>\ud83d\udca0 The opening balance on your bank statement does not match the starting balance.\u00a0<br>\ud83d\udca0 The date on a previous reconciliation was saved incorrectly.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-4eb068e1 \" role=\"tab\" tabindex=\"0\"><div class=\"uagb-faq-questions-button uagb-faq-questions\">\t\t\t<span class=\"uagb-icon uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M432 256c0 17.69-14.33 32.01-32 32.01H256v144c0 17.69-14.33 31.99-32 31.99s-32-14.3-32-31.99v-144H48c-17.67 0-32-14.32-32-32.01s14.33-31.99 32-31.99H192v-144c0-17.69 14.33-32.01 32-32.01s32 14.32 32 32.01v144h144C417.7 224 432 238.3 432 256z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span class=\"uagb-icon-active uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M400 288h-352c-17.69 0-32-14.32-32-32.01s14.31-31.99 32-31.99h352c17.69 0 32 14.3 32 31.99S417.7 288 400 288z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t<span class=\"uagb-question\">Can I post a reconciliation that includes an unsettled amount?<\/span><\/div><div class=\"uagb-faq-content\"><p>You can submit a Reconciliation with an Unresolved Amount. Simply will create an adjustment entry and allow you to pick the account to which you want to post the remaining amount of the transaction. For this purpose, clients frequently create an account named Temporary Unresolved.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-8002e0ab \" role=\"tab\" tabindex=\"0\"><div class=\"uagb-faq-questions-button uagb-faq-questions\">\t\t\t<span class=\"uagb-icon uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M432 256c0 17.69-14.33 32.01-32 32.01H256v144c0 17.69-14.33 31.99-32 31.99s-32-14.3-32-31.99v-144H48c-17.67 0-32-14.32-32-32.01s14.33-31.99 32-31.99H192v-144c0-17.69 14.33-32.01 32-32.01s32 14.32 32 32.01v144h144C417.7 224 432 238.3 432 256z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span class=\"uagb-icon-active uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M400 288h-352c-17.69 0-32-14.32-32-32.01s14.31-31.99 32-31.99h352c17.69 0 32 14.3 32 31.99S417.7 288 400 288z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t<span class=\"uagb-question\">Why is there an error in my bank reconciliation?<\/span><\/div><div class=\"uagb-faq-content\"><p>If the two sums are equal yet there is still a difference, the bank reconciliation table provides incorrect information. To resolve this issue, you can <a href=\"https:\/\/www.bigxperts.com\/sage\/reset-the-bank-reconciliation-in-sage-50\/\">reset the Sage 50 bank reconciliation<\/a>.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-ccc1d7ab \" role=\"tab\" tabindex=\"0\"><div class=\"uagb-faq-questions-button uagb-faq-questions\">\t\t\t<span class=\"uagb-icon uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M432 256c0 17.69-14.33 32.01-32 32.01H256v144c0 17.69-14.33 31.99-32 31.99s-32-14.3-32-31.99v-144H48c-17.67 0-32-14.32-32-32.01s14.33-31.99 32-31.99H192v-144c0-17.69 14.33-32.01 32-32.01s32 14.32 32 32.01v144h144C417.7 224 432 238.3 432 256z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span class=\"uagb-icon-active uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M400 288h-352c-17.69 0-32-14.32-32-32.01s14.31-31.99 32-31.99h352c17.69 0 32 14.3 32 31.99S417.7 288 400 288z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t<span class=\"uagb-question\">In Sage 50, where are the initial check and invalid transactions?<\/span><\/div><div class=\"uagb-faq-content\"><p>The original check will be displayed in the Checks and Bank Debits portion of the Account Reconciliation window, while the void (reverse) transaction will be displayed in the Deposits and Bank Credits area.<\/p><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>Bank reconciliation statements are financial papers that describe your bank account activity as well as internally recorded actions, show that the two records are consistent, and are used to reconcile your bank accounts. During the tax preparation process, bank reconciliation errors in Sage 50 can happen. When you reconcile, you are confirming that the transactions&hellip;&nbsp;<a href=\"https:\/\/www.bigxperts.com\/sage\/sage-50-bank-reconciliation-issues\/\" class=\"\" rel=\"bookmark\">Read More &raquo;<span class=\"screen-reader-text\">Resolve Sage 50 Bank Reconciliation Issues: Unresolved Amount or Reconciliation Discrepancy<\/span><\/a><\/p>\n","protected":false},"author":7,"featured_media":84749,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","footnotes":""},"categories":[7],"tags":[],"class_list":["post-84748","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sage-errors"],"featured_image_src":"https:\/\/www.bigxperts.com\/sage\/wp-content\/uploads\/2023\/04\/Sage-50-Bank-Reconciliation-Issues-Resetting-Setup.jpg","author_info":{"display_name":"Rick","author_link":"https:\/\/www.bigxperts.com\/sage\/author\/robert\/"},"uagb_featured_image_src":{"full":["https:\/\/www.bigxperts.com\/sage\/wp-content\/uploads\/2023\/04\/Sage-50-Bank-Reconciliation-Issues-Resetting-Setup.jpg",820,380,false],"thumbnail":["https:\/\/www.bigxperts.com\/sage\/wp-content\/uploads\/2023\/04\/Sage-50-Bank-Reconciliation-Issues-Resetting-Setup-150x150.jpg",150,150,true],"medium":["https:\/\/www.bigxperts.com\/sage\/wp-content\/uploads\/2023\/04\/Sage-50-Bank-Reconciliation-Issues-Resetting-Setup-300x139.jpg",300,139,true],"medium_large":["https:\/\/www.bigxperts.com\/sage\/wp-content\/uploads\/2023\/04\/Sage-50-Bank-Reconciliation-Issues-Resetting-Setup-768x356.jpg",768,356,true],"large":["https:\/\/www.bigxperts.com\/sage\/wp-content\/uploads\/2023\/04\/Sage-50-Bank-Reconciliation-Issues-Resetting-Setup.jpg",820,380,false],"1536x1536":["https:\/\/www.bigxperts.com\/sage\/wp-content\/uploads\/2023\/04\/Sage-50-Bank-Reconciliation-Issues-Resetting-Setup.jpg",820,380,false],"2048x2048":["https:\/\/www.bigxperts.com\/sage\/wp-content\/uploads\/2023\/04\/Sage-50-Bank-Reconciliation-Issues-Resetting-Setup.jpg",820,380,false],"neve-blog":["https:\/\/www.bigxperts.com\/sage\/wp-content\/uploads\/2023\/04\/Sage-50-Bank-Reconciliation-Issues-Resetting-Setup.jpg",820,380,false],"web-stories-poster-portrait":["https:\/\/www.bigxperts.com\/sage\/wp-content\/uploads\/2023\/04\/Sage-50-Bank-Reconciliation-Issues-Resetting-Setup-640x380.jpg",640,380,true],"web-stories-publisher-logo":["https:\/\/www.bigxperts.com\/sage\/wp-content\/uploads\/2023\/04\/Sage-50-Bank-Reconciliation-Issues-Resetting-Setup-96x96.jpg",96,96,true],"web-stories-thumbnail":["https:\/\/www.bigxperts.com\/sage\/wp-content\/uploads\/2023\/04\/Sage-50-Bank-Reconciliation-Issues-Resetting-Setup-150x70.jpg",150,70,true]},"uagb_author_info":{"display_name":"Rick","author_link":"https:\/\/www.bigxperts.com\/sage\/author\/robert\/"},"uagb_comment_info":0,"uagb_excerpt":"Bank reconciliation statements are financial papers that describe your bank account activity as well as internally recorded actions, show that the two records are consistent, and are used to reconcile your bank accounts. During the tax preparation process, bank reconciliation errors in Sage 50 can happen. When you reconcile, you are confirming that the transactions&hellip;&nbsp;Read&hellip;","_links":{"self":[{"href":"https:\/\/www.bigxperts.com\/sage\/wp-json\/wp\/v2\/posts\/84748","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bigxperts.com\/sage\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bigxperts.com\/sage\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bigxperts.com\/sage\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bigxperts.com\/sage\/wp-json\/wp\/v2\/comments?post=84748"}],"version-history":[{"count":2,"href":"https:\/\/www.bigxperts.com\/sage\/wp-json\/wp\/v2\/posts\/84748\/revisions"}],"predecessor-version":[{"id":87253,"href":"https:\/\/www.bigxperts.com\/sage\/wp-json\/wp\/v2\/posts\/84748\/revisions\/87253"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.bigxperts.com\/sage\/wp-json\/wp\/v2\/media\/84749"}],"wp:attachment":[{"href":"https:\/\/www.bigxperts.com\/sage\/wp-json\/wp\/v2\/media?parent=84748"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bigxperts.com\/sage\/wp-json\/wp\/v2\/categories?post=84748"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bigxperts.com\/sage\/wp-json\/wp\/v2\/tags?post=84748"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}