{"id":106997,"date":"2024-01-16T10:47:43","date_gmt":"2024-01-16T10:47:43","guid":{"rendered":"https:\/\/www.askforaccounting.com\/?p=106997"},"modified":"2024-01-16T10:47:43","modified_gmt":"2024-01-16T10:47:43","slug":"sage-50-opening-balances","status":"publish","type":"post","link":"https:\/\/www.askforaccounting.com\/sage\/sage-50-opening-balances\/","title":{"rendered":"Enter Opening Balances in Sage 50"},"content":{"rendered":"\n<p>This article gives you a brief overview of the enter opening balances in Sage 50 for ledger accounts, bank accounts, suppliers, and customers. Opening balance continuously refers to the balances of a financial account that are debited by the opening credits for a transaction.<\/p>\n\n\n\n<p>This article has been compiled for users who are trying to achieve one or more of the following goals.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Enter opening balances for a customer<\/li>\n\n\n\n<li>Enter opening balances for a supplier<\/li>\n\n\n\n<li>Enter opening balances for a bank account<\/li>\n\n\n\n<li>Enter ledger account opening balances<\/li>\n\n\n\n<li>Record a payment or receipt against an opening balance.<\/li>\n<\/ul>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_81 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\">Table of Contents<\/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 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.askforaccounting.com\/sage\/sage-50-opening-balances\/#Guide_to_Enter_Opening_Balances_for_Customers_in_Sage_50\" >Guide to Enter Opening Balances for Customers in Sage 50<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.askforaccounting.com\/sage\/sage-50-opening-balances\/#Needs_to_keep_a_few_things_in_mind_before_importing_the_customer_opening_balances\" >Needs to keep a few things in mind before importing the customer opening balances<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.askforaccounting.com\/sage\/sage-50-opening-balances\/#To_import_the_customer_or_supplier_opening_balances_file_the_user_can_follow_these_steps_in_order\" >To import the customer or supplier opening balances file, the user can follow these steps in order<\/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.askforaccounting.com\/sage\/sage-50-opening-balances\/#Following_are_the_steps_for_how_users_can_import_their_customer_or_supplier_opening_balances_file\" >Following are the steps for how users can import their customer or supplier opening balances file<\/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.askforaccounting.com\/sage\/sage-50-opening-balances\/#Enter_the_customer_balances\" >Enter the customer balances<\/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.askforaccounting.com\/sage\/sage-50-opening-balances\/#Guide_to_Enter_Opening_Balances_for_Suppliers_in_Sage_50\" >Guide to Enter Opening Balances for Suppliers in Sage 50<\/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.askforaccounting.com\/sage\/sage-50-opening-balances\/#Guide_to_Enter_Opening_Balances_for_a_Bank_Account_in_Sage_50\" >Guide to Enter Opening Balances for a Bank Account in Sage 50<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.askforaccounting.com\/sage\/sage-50-opening-balances\/#Tips_to_Enter_Opening_Balances_for_Ledger_Accounts_in_Sage_50\" >Tips to Enter Opening Balances for Ledger Accounts in Sage 50<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.askforaccounting.com\/sage\/sage-50-opening-balances\/#Tips_to_Record_a_Payment_or_Receipt_Against_an_Opening_Balance_in_Sage_50\" >Tips to Record a Payment or Receipt Against an Opening Balance in Sage 50<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/www.askforaccounting.com\/sage\/sage-50-opening-balances\/#Tips_to_Fix_the_Error_Sage_50_Opening_Balances\" >Tips to Fix the Error Sage 50 Opening Balances<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/www.askforaccounting.com\/sage\/sage-50-opening-balances\/#Steps_to_resolve_the_Sage_50_error_opening_balances\" >Steps to resolve the Sage 50 error opening balances<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Guide_to_Enter_Opening_Balances_for_Customers_in_Sage_50\"><\/span>Guide to Enter Opening Balances for Customers in Sage 50<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>For users who have moved their business accounting to Sage Accounting for the first time, the first thing that they need to do is that they need to enter any outstanding customer transactions. Users can choose between importing the customer opening balances and entering them manually.<\/p>\n\n\n\n<p>Also, the user needs to check and make sure that their VAT scheme and account start date information is correct. Furthermore, the user also needs to ensure that they create their customer records. Lastly, the user also needs to compile a list of any outstanding customer <a href=\"https:\/\/askforaccounting.com\/sage\/import-invoices-into-sage-50\/\">invoices<\/a> and credit notes. The steps to <a href=\"https:\/\/askforaccounting.com\/sage\/import-data-into-sage-50\/\">import data into Sage 50<\/a> such as customer opening balances have been mentioned below.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Needs_to_keep_a_few_things_in_mind_before_importing_the_customer_opening_balances\"><\/span>Needs to keep a few things in mind before importing the customer opening balances<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The first thing that needs to be kept in mind before the user can import their customer opening balances is that users are required to have already <strong>entered the customers<\/strong> and\/or <strong>suppliers<\/strong>.<\/li>\n\n\n\n<li>Another thing that needs to be kept in mind before the user can import their customer opening balances is that users must have already set an account start date and the <strong>VAT<\/strong> scheme.<\/li>\n\n\n\n<li>Users also need to make sure that the file that they are trying to import for the customer opening balances only contains the opening balances of customers or suppliers. If the user wishes to import the opening balances of both the customers and the suppliers, the user must do so using two separate files.<\/li>\n\n\n\n<li>The file that the user wants to import for the customer opening balances must be in a <strong>comma-separated value<\/strong> (CSV) format. No other format is accepted.<\/li>\n\n\n\n<li>Users also need to make sure that the column headings and the formatting of the file that they are trying to import match the column headings and the formatting of the customer opening balances template file.<\/li>\n<\/ul>\n\n\n\n<p>After making sure of the things mentioned above, the user can proceed to import their customer or supplier opening balances file.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"To_import_the_customer_or_supplier_opening_balances_file_the_user_can_follow_these_steps_in_order\"><\/span>To import the customer or supplier opening balances file, the user can follow these steps in order<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>First, the user is required to <strong>download the CSV template file<\/strong>. The <a href=\"https:\/\/help.accounting.sage.com\/en-ie\/accounts-production\/TrialBalance\/ap-import-csv-file.html\" target=\"_blank\" rel=\"noopener\">CSV template file<\/a> is available for download from within the application itself, so the user does not need to look for it elsewhere. The reason this step is mentioned and, in fact, highly recommended is that users can compare their own customer or supplier opening balances file to the template customer or supplier opening balances file and check if the column headings and the formatting match or not.&nbsp;<\/li>\n\n\n\n<li>If there is any formatting issue, then it can be avoided by comparison.<\/li>\n\n\n\n<li>Then they need to move on to preparing their customer or supplier opening balances file. The column headers and formatting of the file that the user has must match the column headers and the formatting of the template file.<\/li>\n\n\n\n<li>If the user does not have a customer or supplier opening balances file, then the user can simply <strong>enter their data<\/strong> into the template file that they downloaded.<\/li>\n\n\n\n<li>Once the user has successfully prepared their customer opening balances file, the user can proceed to begin the import process of their file.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Following_are_the_steps_for_how_users_can_import_their_customer_or_supplier_opening_balances_file\"><\/span>Following are the steps for how users can import their customer or supplier opening balances file<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>First, the user needs to go to the \u2018<strong>Settings menu<\/strong>.<\/li>\n\n\n\n<li>Select the option titled \u2018<strong>Business Settings<\/strong>.<\/li>\n\n\n\n<li>After selecting either \u2018<strong>Customers<\/strong>\u2019 or \u2018<strong>Suppliers<\/strong>\u2019 based on whose opening balances they wish to import. This choice will be asked of the user in the \u2019Opening Balances\u2019 section.<\/li>\n\n\n\n<li>Then the user needs to then select \u2018<strong>New Opening Balance<\/strong>\u2019, and after that, the user needs to select \u2018<strong>Import Opening Balance<\/strong>\u2019.<\/li>\n\n\n\n<li>Now, the user needs to press the button with the title \u2018<strong>Choose File<\/strong>\u2019. Clicking on this button will open the file explorer on the user\u2019s workstation, and the user must navigate to the location where their customer or supplier opening balances file is located.<\/li>\n\n\n\n<li>Select that file to upload it. The user will need to click \u2018<strong>Upload<\/strong>\u2019.<\/li>\n\n\n\n<li>Now, the user will be prompted when the import process has been completed successfully. Upon receiving the prompt from Sage, the user can press \u2018<strong>OK<\/strong>\u2019 and the file will have been imported successfully.<\/li>\n<\/ul>\n\n\n\n<p>After the completion of the importing of the customer opening balances file, the user can proceed to enter the customer balances by following the steps mentioned below.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Enter_the_customer_balances\"><\/span>Enter the customer balances<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>In the first step go to the \u2018<strong><span style=\"background-color: rgba(62, 60, 60, 0.2);\">Setti<\/span>ngs<\/strong> menu select \u2018<strong>Business Settings<\/strong> and then select the \u2018Customer\u2019 option.<\/li>\n\n\n\n<li>The user will need to make sure that the <strong>account start date<\/strong> that is in front of them is correct. If it is not correct, then the user will be required to change it. After changing the date, the user can press \u2018<strong>Save<\/strong>\u2019, and the update will have been made successfully.<\/li>\n\n\n\n<li>The user will now need to click the \u2018<strong>New Opening Balance<\/strong>\u2019 option the user will be asked to enter the following information:\n<ul class=\"wp-block-list\">\n<li><strong>Type<\/strong>: To record an <a href=\"https:\/\/askforaccounting.com\/sage\/sage-50-invoice-issues\/\">invoice<\/a>, the user must choose \u2018Inv\u2019. Alternatively, to record a credit note, the user needs to choose \u2018Crn\u2019.<\/li>\n\n\n\n<li><strong>Date<\/strong>: The user needs to provide the date of the invoice or credit note. This date that the user provides has to be before the Accounts Start Date entered by the user earlier.<\/li>\n\n\n\n<li><strong>Customer<\/strong>: The user is required to choose the relevant customer.<\/li>\n\n\n\n<li><strong>Reference<\/strong>: The user needs to provide a relevant reference for the opening balance. For example, the invoice or credit note number will work if the user decides to provide this information.<\/li>\n\n\n\n<li><strong>Details<\/strong>: Here, the user can provide any additional information, for example, what the invoice or credit note was for.<\/li>\n\n\n\n<li><strong>Net<\/strong>: The user will only see this option if the user uses the VAT Cash Accounting Scheme. Here, the user is required to provide the net value of the transaction that was made.<\/li>\n\n\n\n<li><strong>VAT Rate<\/strong>: The user will only see this option if the user uses the VAT Cash Accounting Scheme. Here, the user needs to choose the appropriate VAT Rate.<\/li>\n\n\n\n<li><strong>Total<\/strong>:<strong>&nbsp;<\/strong>If the user uses the Standard or Flat Rate VAT Scheme, then they are also required to provide the gross value of the invoice or credit note.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p>If the user uses the <strong>VAT Cash Accounting scheme<\/strong>, this value is automatically calculated from the net amount and VAT rate.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>If the user also makes transactions in multiple currencies and if the customer is located overseas, then they are also required to provide the following information:\n<ul class=\"wp-block-list\">\n<li><strong>Total<\/strong>:<strong>&nbsp;<\/strong>The user needs to enter the amount in the base currency of the customer instead of their currency.&nbsp;<\/li>\n\n\n\n<li><strong>Exchange rate<\/strong>: If the user is making transactions according to the live exchange rates, then they need to provide this as well. Users are allowed to change this to the rate that was agreed upon during the transaction.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>The user can finally press \u2018Save\u2019, and this process needs to be repeated till the user has entered all outstanding invoices and credit notes for all their customers.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Guide_to_Enter_Opening_Balances_for_Suppliers_in_Sage_50\"><\/span>Guide to Enter Opening Balances for Suppliers in Sage 50<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>After the completion of the importing of the supplier opening balances file, the user can proceed to enter the supplier balances by following the steps mentioned below.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The first step go to the \u2018<strong>Settings<\/strong>\u2019 menu &gt;&gt; \u2018<strong>Business Settings<\/strong> &gt;&gt; \u2018<strong>Supplier<\/strong>\u2019 option.<\/li>\n\n\n\n<li>The user will need to make sure that the <strong>account start date<\/strong> that is in front of them is correct. If it is not correct, then the user will be required to change it. After changing the date, the user can press \u2018<strong>Save<\/strong>\u2019, and the update will have been made successfully.&nbsp;<\/li>\n\n\n\n<li>The user will now need to click the \u2018<strong>New Opening Balance<\/strong>\u2019 option, the user will be asked to enter the following information.\n<ul class=\"wp-block-list\">\n<li><strong>Type<\/strong>: To record an invoice, the user must choose \u2018Inv\u2019. Alternatively, to record a credit note, the user needs to choose \u2018Crn\u2019.<\/li>\n\n\n\n<li><strong>Date<\/strong>: The user needs to provide the date of the invoice or credit note. This date that the user provides has to be before the Accounts Start Date entered by the user earlier.<\/li>\n\n\n\n<li><strong>Supplier<\/strong>: The user is required to choose the relevant supplier.<\/li>\n\n\n\n<li><strong>Reference<\/strong>: The user needs to provide a relevant reference for the opening balance. For example, the invoice or credit note number will work if the user decides to provide this information.<\/li>\n\n\n\n<li><strong>Details<\/strong>: Here, the user can provide any additional information, for example, what the invoice or credit note was for.<\/li>\n\n\n\n<li><strong>Net<\/strong>: The user will only see this option if the user uses the Cash Basis VAT Scheme. Here, the user is required to provide the net value of the transaction that was made.<\/li>\n\n\n\n<li><strong>VAT Rate<\/strong>: The user will only see this option if the user uses the Cash Basis VAT Scheme. Here, the user needs to choose the appropriate VAT Rate.<\/li>\n\n\n\n<li><strong>Total<\/strong>:<strong>&nbsp;<\/strong>If the user uses the Invoice Basis VAT Scheme, then they are also required to provide the gross value of the invoice or credit note. If the user uses the Cash Basis VAT Scheme, this value is automatically calculated from the net amount and VAT rate.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p>If the user also makes <strong>transactions in multiple currencies<\/strong> and if the supplier is located overseas, then they are also required to provide the following information.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Total<\/strong>:<strong>&nbsp;<\/strong>The user needs to enter the amount in the base currency of the supplier instead of their currency.<\/li>\n\n\n\n<li><strong>Exchange rate<\/strong>: If the user is making transactions according to the live exchange rates, then they need to provide this as well. Users are allowed to change this to the rate that was agreed upon during the transaction.<\/li>\n<\/ul>\n\n\n\n<p>The user can finally press \u2018<strong>Save<\/strong>\u2019, and this process needs to be repeated till the user has entered all outstanding invoices and credit notes for all their customers.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Guide_to_Enter_Opening_Balances_for_a_Bank_Account_in_Sage_50\"><\/span>Guide to Enter Opening Balances for a Bank Account in Sage 50<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>This is for users who are trying to enter the opening balance for a bank account in Sage 50. It could be for the existing balance of their bank or credit card when they first start using Accounting, or it could be for the balance of a new account that the user wants to add to Accounting and if they have been using it for a while.<\/p>\n\n\n\n<p>Before the user can enter their opening balance for a bank account, the user needs to do a few things. The user needs to check and make sure that their VAT scheme and account start date information is correct. Furthermore, the user also needs to ensure that they create their bank accounts, including any loan and credit card amounts. Lastly, the user also needs to compile a list of any unrepresented bank items, and they need to gather their bank statements.<\/p>\n\n\n\n<p>Following are the steps the user needs to complete to be able to enter the opening balance for a bank account.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The first step that the user needs to do is go to the \u2018<strong>Settings<\/strong>\u2019 menu.<\/li>\n\n\n\n<li>Now, select \u2018<strong>Business Settings<\/strong>.<\/li>\n\n\n\n<li>After making it to the \u2018<strong>Business Settings<\/strong>\u2019 section, the user then needs to select the \u2018<strong>Bank<\/strong>\u2019 option, which can be found in the \u2018<strong>Opening Balances<\/strong>\u2019 section.<\/li>\n\n\n\n<li>The user will need to make sure that the account start date that is in front of them is correct. If it is not correct, then the user will be required to change it.&nbsp;<\/li>\n\n\n\n<li>After changing the date, the user can press \u2018<strong>Save<\/strong>\u2019, and the update will have been made successfully.<\/li>\n\n\n\n<li>The user will be asked to enter the following information regarding the opening balance:\n<ul class=\"wp-block-list\">\n<li><strong>Date<\/strong>: This date that the user provides has to be before the Accounts Start Date entered by the user earlier.<\/li>\n\n\n\n<li><strong>Type<\/strong>: This needs to be entered after the user has decided whether the balance is a \u2018Receipt (debit)\u2019 or a \u2018Payment (Credit)\u2019 type.<\/li>\n\n\n\n<li><strong>Opening Balance<\/strong>: The user needs to enter the balance in the account on the account&#8217;s Start Date.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Finally, the user can press \u2018<strong>Save<\/strong>\u2019. After saving this information, the user will see the updated balance of the bank account, including the opening balance. The user will also be able to see an opening balance transaction.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Tips_to_Enter_Opening_Balances_for_Ledger_Accounts_in_Sage_50\"><\/span>Tips to Enter Opening Balances for Ledger Accounts in Sage 50<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>This is for the users who are moving from another accounting system to Sage Accounting.&nbsp; Before the user can begin, the user needs to check and make sure that their VAT scheme and account start date information is correct. Furthermore, the user must ensure that they have a copy of their trial balance from their accountant. Also, the user needs to understand the fact that they cannot enter the opening balance for bank accounts or the trade debtors and trade creditors accounts here.<\/p>\n\n\n\n<p>Now, the user can move on to follow the steps mentioned below to enter the ledger account opening balance.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The first step go to the \u2018<strong>Settings<\/strong>\u2019 menu then \u2018<strong>Business Settings<\/strong>.<\/li>\n\n\n\n<li>Then need to select the \u2018<strong>Nominal Ledger<\/strong>\u2019 option, which can be found in the \u2018Opening Balances\u2019 section.<\/li>\n\n\n\n<li>After that, the user needs to <strong>enter the date<\/strong> for their opening balance. The date that the user enters must be before or on the date they have provided as the start date of their accounts.<\/li>\n\n\n\n<li>The user must also provide the reference which helps the user track the transactions that are opening balances on their reports.<\/li>\n\n\n\n<li>Now the user will be able to see their bank accounts, Trade Debtors, and Trade Creditors at the top.<\/li>\n\n\n\n<li>The user must begin from the first row where no ledger account has been entered. The user is required to pick a ledger account from the drop-down menu. The user can also provide any additional details here.<\/li>\n\n\n\n<li>The user must now <strong>enter a Debit or Credit value<\/strong> from their trial balance.<\/li>\n\n\n\n<li>After all the aforementioned steps have been completed, the user must repeat them for all their remaining ledger accounts.&nbsp;<\/li>\n\n\n\n<li>Thereafter, Once done, the user can simply press \u2018<strong>Save<\/strong>\u2019.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Tips_to_Record_a_Payment_or_Receipt_Against_an_Opening_Balance_in_Sage_50\"><\/span>Tips to Record a Payment or Receipt Against an Opening Balance in Sage 50<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>This is for users who are trying to record a payment or receipt against an opening balance. No steps have to be completed beforehand, and the user can just move on to complete the following steps to complete the process.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The first thing go to the \u2018<strong>Banking<\/strong>\u2019 tab and then click the required bank account.<\/li>\n\n\n\n<li>After that, the user needs to choose \u2018<strong>New Entry<\/strong>\u2019, and then they need to either select Sales\/Receipt or Purchase\/Payment.<\/li>\n\n\n\n<li>After making the appropriate selection, the user then needs to select the relevant <strong>customer or supplier<\/strong> from the drop-down menu and fill in the information that is asked.<\/li>\n\n\n\n<li>Now, the user must look for the opening balance that needs to be paid.<\/li>\n\n\n\n<li>The user needs to select the <strong>checkbox<\/strong> that is next to the opening balance.<\/li>\n\n\n\n<li>Finally, the user can press \u2018<strong>Save<\/strong>\u2019.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Tips_to_Fix_the_Error_Sage_50_Opening_Balances\"><\/span>Tips to Fix the Error Sage 50 Opening Balances<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>When adding uncleared transactions for your bank accounts in the Opening Balances process, the software may hang for a while before displaying the following message&#8230;<\/p>\n\n\n\n<pre class=\"wp-block-verse\"><em>SBDDesktop.exe is no longer working.\nThe program stopped functioning properly due to a problem caused.\nIf a fix is available, Windows will end the program and let you know.<\/em><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Steps_to_resolve_the_Sage_50_error_opening_balances\"><\/span>Steps to resolve the Sage 50 error opening balances<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>You can get around this by adding uncleared transactions like bank payments or receipts to the suspense nominal code, after which you can use a journal to reverse the balance.<\/p>\n\n\n\n<p><strong>Step I- Enter any uncleared receipts<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>You have to click <strong>Bank accounts<\/strong> and then you have to click the <strong>relevant bank account<\/strong> on the navigation bar.<\/li>\n\n\n\n<li>Then you have to click the <strong>Receipts<\/strong> drop-down and then you have to click <strong>Bank receipt<\/strong>.<\/li>\n\n\n\n<li>After that, for your first receipt, you have to <strong>enter the transaction<\/strong> details including the following:\n<ul class=\"wp-block-list\">\n<li><strong>Date<\/strong>&#8211; Opening balance date<\/li>\n\n\n\n<li><strong>N\/C<\/strong>&#8211; 9998 &#8211; Suspense Account<\/li>\n\n\n\n<li><strong>Net<\/strong>&#8211; Total receipt amount<\/li>\n\n\n\n<li><strong>T\/C<\/strong>&#8211; T9<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Click <strong>Save<\/strong>, to save the receipt.<\/li>\n\n\n\n<li>For each receipt that you want to post you have to repeat the upper steps then you have to click <strong>Close<\/strong>.<\/li>\n<\/ul>\n\n\n\n<p><strong>Step II- Enter any uncleared payments<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Click <strong>Bank Accounts<\/strong> in the navigation bar before selecting the appropriate bank account.<\/li>\n\n\n\n<li>Then you have to click <strong>Bank payment<\/strong> from the Payments drop-down menu.<\/li>\n\n\n\n<li>Enter the <strong>transaction<\/strong> information, including the following, for your first payment.\n<ul class=\"wp-block-list\">\n<li><strong>Date<\/strong>&#8211; Opening balance date<\/li>\n\n\n\n<li><strong>N\/C<\/strong>&#8211; 9998 &#8211; Suspense Account<\/li>\n\n\n\n<li><strong>Net<\/strong>&#8211; Total receipt amount<\/li>\n\n\n\n<li><strong>T\/C<\/strong>&#8211; T9<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Then, to save the payment you have to click <strong>Save<\/strong>.<\/li>\n\n\n\n<li>After that, you have to repeat steps 3 and 4 for each payment that you want to post and then click <strong>Close<\/strong>.<\/li>\n<\/ul>\n\n\n\n<p><strong>Step III- Reverse the suspense balance<\/strong><\/p>\n\n\n\n<p>You must match up the two journal entries when you do your next <a href=\"https:\/\/askforaccounting.com\/sage\/reconcile-in-sage-50\/\">bank reconciliation<\/a> to make sure your reconciled <a href=\"https:\/\/askforaccounting.com\/sage\/sage-50-balance-sheet-out-of-balance\/\">balance is correct<\/a>.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Click <strong>Journal entry<\/strong> after selecting <strong>Nominal<\/strong> Codes from the navigation bar.<\/li>\n\n\n\n<li>Enter <strong>OB Reverse<\/strong> in Reference, and then your opening balance date in Posting Date.<\/li>\n\n\n\n<li>Enter the following in the <strong>journal<\/strong>&#8230;<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>N\/C<\/strong><\/td><td><strong>Details<\/strong><\/td><td><strong>T\/C<br>Debit<\/strong><\/td><td><strong>Credit<\/strong><\/td><\/tr><tr><td>Choose your bank nominal code<\/td><td>Reverse OB<\/td><td><br>T9<\/td><td><br>Total uncleared receipts<\/td><\/tr><tr><td>9998 &#8211; Suspense Account<\/td><td>Reverse OB<\/td><td><br>T9<br>Total uncleared receipts<\/td><td>_<\/td><\/tr><tr><td>Choose your bank nominal code<\/td><td>Reverse OB<\/td><td><br>T9<br>Total uncleared receipts<\/td><td>_<\/td><\/tr><tr><td>9998 &#8211; Suspense Account<\/td><td>Reverse OB<\/td><td><br>T9<\/td><td><br>Total uncleared receipts<\/td><\/tr><\/tbody><\/table><figcaption class=\"wp-element-caption\">Enter the journal<\/figcaption><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Lastly, you have to click <strong>Save<\/strong> to save the journal and then click <strong>Close<\/strong>.<\/li>\n<\/ul>\n\n\n","protected":false},"excerpt":{"rendered":"<p>This article gives you a brief overview of the enter opening balances in Sage 50 for ledger accounts, bank accounts, suppliers, and customers. Opening balance continuously refers to the balances of a financial account that are debited by the opening credits for a transaction. This article has been compiled for users who are trying to &#8230; <a title=\"Enter Opening Balances in Sage 50\" class=\"read-more\" href=\"https:\/\/www.askforaccounting.com\/sage\/sage-50-opening-balances\/\" aria-label=\"Read more about Enter Opening Balances in Sage 50\">Read more<\/a><\/p>\n","protected":false},"author":3,"featured_media":109617,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"single-with-sidebar","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[3],"tags":[],"class_list":["post-106997","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sage-accounting"],"acf":[],"featured_image_src":null,"author_info":{"display_name":"Lawrence Flanagan","author_link":"https:\/\/www.askforaccounting.com\/sage\/author\/openfolderbin\/"},"_links":{"self":[{"href":"https:\/\/www.askforaccounting.com\/sage\/wp-json\/wp\/v2\/posts\/106997","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.askforaccounting.com\/sage\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.askforaccounting.com\/sage\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.askforaccounting.com\/sage\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.askforaccounting.com\/sage\/wp-json\/wp\/v2\/comments?post=106997"}],"version-history":[{"count":0,"href":"https:\/\/www.askforaccounting.com\/sage\/wp-json\/wp\/v2\/posts\/106997\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.askforaccounting.com\/sage\/wp-json\/"}],"wp:attachment":[{"href":"https:\/\/www.askforaccounting.com\/sage\/wp-json\/wp\/v2\/media?parent=106997"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.askforaccounting.com\/sage\/wp-json\/wp\/v2\/categories?post=106997"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.askforaccounting.com\/sage\/wp-json\/wp\/v2\/tags?post=106997"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}