Entering Opening Balances
Unless you are starting a new business and intend to use Enterprise by HansaWorld to administer your accounts from the first day, you will need to enter some opening balances. If you are starting to use Enterprise by HansaWorld at the beginning of the fiscal year, these opening balances will take the form of the closing balances for each Account for the end of the previous year. If you are starting to use Enterprise by HansaWorld in the middle of the fiscal year, there will be two components to opening balance figures: the closing balances for each Account for the end of the previous year and Account balances for the current year to date.To carry out this task, you should equip yourself with as much information as you can in the form of transaction data and reports produced by the old system, in order to make this task as easy as possible.
We recommend that you change during a current financial year. You should enter Account balances for the previous year and then enter individually all current year transactions registered so far. This will a) make you familiar with Enterprise by HansaWorld, and b) automatically give you a check of the old transactions.
You should already have specified the current and, if appropriate, previous financial years using the Fiscal Years setting and entered the Chart of Accounts and VAT Codes you wish to use. A sample Chart of Accounts is supplied with Enterprise by HansaWorld that you can use or adapt. If this is not suitable, you can import your own chart from a text file or enter it manually. For more instructions about this process, please refer to the Importing Sample Data page.
If you will be using Currencies, you should also enter the Currencies used in your business together with Exchange Rates. If any Accounts will have Currency balances, enter the appropriate Currency in the relevant Account records. You should specify in the Base Currency setting in the System module that your local Currency is to be used as Base Currency 1 and the Default Base Currency and, if you are using the Dual-Base currency conversion system you should also specify in the same setting the Currency that is to be used as Base Currency 2. The Dual-Base system will be useful for companies that have offices in two countries that need to report in both Currencies, for companies operating in countries where there is a second Currency (usually the US Dollar or Euro) in common use in addition to the national one, and for companies in the Euro zone who retain their old national Currency for comparison purposes.
If you will not be using Currencies, it is still a good idea (and a recommended course of action) to enter one record in the Currency register to represent your local Currency, and to specify in the Base Currency setting in the System module that this is your Base Currency 1 and Default Base Currency. This will make it easier to start using Currencies in the future if you need to do so while having absolutely no impact on your work before that time comes.
Once you have entered your Fiscal Year, Chart of Accounts, VAT Codes and Currencies it's a good idea to enter all the opening balances at once. Ideally, this process should be completed before you start to enter new Transactions but it is possible to change the opening balances at any time during the financial year.
When entering opening balances, the level of detail is up to you. Factors influencing this decision may be the number of Transactions, the time available to enter these Transactions, whether you can import them (otherwise, you will have to enter them manually) and the level of detail required in your reports. It might be that you enter or import all Transactions individually (in the form of Invoices, Receipts, Purchase Invoices, Payments and Nominal Ledger Transactions) or it might be that you enter a single opening balance for each Account. Full details covering the necessary data entry processes follow in the next sections.
Once you have entered your opening balances in their chosen form, print the reports you usually use and compare them with the reports from your old system. These reports should include the Trial Balance, Profit & Loss and Balance Sheet from the Nominal Ledger, and lists of Debtors and Creditors using the Sales and Purchase Ledger reports respectively.
---
In this chapter:
Opening Balances in the Nominal Ledger
In the Nominal Ledger, the task of entering opening balances can have two stages:You can enter a single opening balance figure for each Account, or you can divide the opening balance figure into individual postings. This decision may depend on the Account itself.
The advantages of using the Brought Forward Balance register for this purpose are that you can save unbalanced Brought Forward Balance records, and you can return to a Brought Forward Balance record to change it. This allows you to enter opening balances as a gradual process, saving frequently. The disadvantage is that the Account Reconciliation register does not recognise balances entered in the Brought Forward Balance register. So, if you are entering opening balances for Bank Accounts as individual postings that later you will need to reconcile with your bank statement, as may be the case in the UK, you will need to use the Simulation register. You can return to saved Simulations to edit them, again allowing the process of entering opening balances to be a gradual one. While a Simulation must balance before you can save it, you can save a Simulation periodically with a posting to a temporary balancing Account on the last line until it is complete. You can then convert it to a Transaction, after which the postings will be made available to the Account Reconciliation register.
If you want to use the Brought Forward Balance register, refer to steps 1-8 below. If you want to use the Simulation register, refer to steps 9-17.
The following sections assume you have already defined a Chart of Accounts and a set of VAT Codes.
To enter Account balances as they stood at the end of the previous financial year to the Nominal Ledger using the Brought Forward Balance register, follow these steps:
If you are not using Currencies, enter the balances in the Base 1 Debit and Credit fields.
If you have Accounts with balances in Base Currency 2, enter those balances in the Base 2 Debit and Credit fields on flip B (click the small button marked "B" on the right of the grid to see these fields). If you have Accounts with balances in a foreign Currency (i.e. not in Base Currency 1 or 2), use the fields on flip C. You should also enter home Currency balances for these Accounts on flip A: no Currency conversion will take place because users will have many different methods of converting opening balance figures.
If you are not using Currencies, enter the balances in the Base 1 Debit and Credit fields.
If you have Accounts with balances in Base Currency 2, enter those balances in the Base 2 Debit and Credit fields on flip C (click the small button marked "C" on the right of the grid to see these fields). If you have Accounts with balances in a foreign Currency (i.e. not in Base Currency 1 or 2), use the fields on flip D. In both cases, enter the Currency itself on flip D as well. You should also enter home Currency balances for these Accounts on flip A: no Currency conversion will take place because users will have many different methods of converting opening balance figures.
When you are sure the Simulation is correct, close it by clicking the close box. On returning to the 'Simulations: Browse' window and highlight the Simulation in the list. Choose 'Create NL Transactions' from the Operations menu in the top left-hand corner of the window:
If you created more than one Simulation, you can highlight them all in the 'Simulations: Browse' window before choosing the 'Create NL Transactions' function. Nominal Ledger Transactions will be generated from each highlighted Simulation. To highlight several Simulations, click on the first one, hold down the Shift key on your keyboard and click on the last one.
You can use another feature when you need to enter several Transactions quickly in one sitting and don't want to interrupt your typing by reaching for the mouse. Enter the debits in a Transaction first and then, with the cursor in the Base 1 Credit field in the final credit row, press the Return or Enter key twice. The first pressing causes the correct credit amount to be entered for you, balancing the entry. The second saves, closes and commits the Transaction to the Nominal Ledger and opens a new, empty, Transaction.
In this chapter:
Opening Balances in the Sales Ledger
It is worth repeating that there can be two components to opening balance figures in the Sales Ledger: the final Customer balances from the previous fiscal year and, if you will be starting to use Enterprise by HansaWorld in the middle of a fiscal year, Customer balances for the current year to date.In considering Customer balances from the previous year, you only need to take account of those that are open (i.e. unpaid). You can enter these in one of two ways:
If you need to enter opening balances in the Sales Ledger, you should first ensure that you have entered your Customers in the Contact register using the process described on the Entering the First Customers, Suppliers and Contact Persons page. If you are entering individual Invoices, you should also ensure that you have entered the Items that you sell in the Item register, as described on the Entering the First Items page. You may be able to import this information from text files. Finally, if you are entering Receipts in any form (i.e. individual Receipts, or monthly or year-to-date Receipts) make sure you have entered all relevant Payment Modes (i.e. payment methods), so that you can post the Receipt amounts to the correct Bank or Cash Account.
---
In this chapter:
Opening Balances in the Sales Ledger - and the Nominal Ledger
You should enter Sales Ledger opening balances in the form of Invoices and Receipts. Any Invoices and Receipts from the previous fiscal year that you enter should not be posted to the Nominal Ledger if you have already entered previous-year Nominal Ledger opening balances to the Brought Forward Balance and Simulation registers as described here. The Nominal Ledger opening balances include balances for the Accounts affected by Invoices (e.g. the Debtors Account) and so to post to those Accounts from opening balance Invoices is to post the same amounts twice. Therefore, before you can enter your Sales Ledger opening balances, you need to ensure that Invoices and Receipts from the previous fiscal year will not update the Nominal Ledger.Using the [Module] button in the Master Control panel, ensure that you are in the Nominal Ledger. Click [Settings] in the Master Control panel or use the Ctrl-S/⌘-S keyboard shortcut. In the subsequent list, double-click 'Sub Systems'. The following window appears:
It is recommended that for each Sub System you enter the first day of your fiscal year. When you enter previous-year opening balances, use a date prior to the Sub System date. This will ensure that Nominal Ledger Transactions will be created when expected and that they will not be created for opening balances. If it takes longer than expected to enter opening balances, you can continue doing so and start to create new records without needing to worry about the consequences in the Nominal Ledger. For example, you can enter previous-year Invoices and Receipts (dated prior to the dates in the Sub System setting) at the same time as issuing new Invoices. The Sub Systems setting will ensure the Nominal Ledger is only updated when it should be.
If you are starting to use Enterprise by HansaWorld in the middle of a financial year, you should already have entered the Nominal Ledger Transactions for the current year so far, as described here. If, as was recommended, you entered these from the original documentation and did not copy them from Transaction Journal reports produced from your old system, you will not have any current year Transactions that relate to the Sales or Purchase Ledger. These will now be created automatically from the Invoices and Receipts (and Purchase Invoices and Payments) that you are about to enter, providing that they are dated later than the Sub System date (the first day of your fiscal year). If you did enter current year Transactions relating to the Sales or Purchase Ledger as part of the previous exercise, you will not want them created again when you enter Invoices and Receipts. In this case, make the Sub System date later (a few days before the date when you will start originating transactions in Enterprise by HansaWorld). This means you will be able to enter Invoices for the current year to date and to issue new Invoices simultaneously without needing to worry about the consequences in the Nominal Ledger.
If you are not certain whether you have entered current year Transactions relating to the Sales or Purchase Ledger, produce a Trial Balance report for the current year and check the balances for your Sales, Purchase, Debtor and Creditor Accounts. If these are zero, you have not entered these Transactions. If they are the same as those on the Trial Balance produced from your old system, you have entered these Transactions already. Please refer to this page for instructions about printing a Trial Balance report.
Once the Sub Systems setting is to your satisfaction, save and close the window by clicking [Save] in the Button Bar.
! | Note that if you have entered previous-year opening balances in the Nominal Ledger, you should not post any Sales, Purchase or Stock opening balances to your Nominal Ledger. To do so will duplicate the work you have already done and will immediately render your accounts inaccurate. |
In this chapter:
Opening Balances in the Sales Ledger - Payment Modes
Before entering the first opening balance in the Sales Ledger, there is a single setting that you need to check if you will be entering Receipts for the fiscal year to date.Use the [Module] button in the Master Control panel to enter the Sales Ledger and click the [Settings] button, also in the Master Control panel. In the subsequent list window, double-click on 'Payment Modes'.
If you imported the sample Chart of Accounts supplied with Enterprise by HansaWorld as described on the Importing Sample Data page, you will also have imported some basic Payment Modes. If you have modified the Chart of Accounts supplied, or you have created your own, ensure that the Account Numbers shown in the second column now refer to the correct Account (remember, you can use 'Paste Special' if necessary).
To create a new Payment Mode, simply click in the first blank row and enter a unique Code. Then enter the other details as appropriate, referring to this page if necessary. Referring to the 'Sales Ledger' manual for details, click flips B-E to complete the entry. Click [Save] when you have finished. Then, close the 'Settings' list using the close box.
---
In this chapter:
Opening Balances in the Sales Ledger - Opening Balances
The process described below applies to the entering of opening balances both from the previous fiscal year and for the current year to date.You are now ready to enter the first Invoice. Follow the described below. If you are entering a single opening balance figure per Customer, either for the previous fiscal year or for the current year to date, you will need to do this by entering it in an Invoice. If so, omit step 7 in the following procedure.
If you are entering a single opening balance figure for each Customer, you might like to use a separate numbering sequence for opening balances (use the Number Series - Invoices setting in the Sales Ledger to set up numbering sequences). If you are entering individual Invoices, you will need to use the Invoice Number and Date of the original Invoice. In multi-user systems, an Invoice Number will be allocated when you save the Invoice for the first time, but you can enter the Invoice Number yourself before saving to be sure that it is correct. When entering individual Invoices for the current year to date, it is recommended that you enter these Invoices in number order from a single client computer to ensure each Invoice retains the number with which it was originally issued.
The window title changes to 'Invoice: Inspect'. You can now correct any mistakes before you click the OK check box in the bottom left-hand corner. With the OK box checked, clicking the [Save] button once again approves the Invoice and commits it to your Sales Ledger. After this you may not change the individual fields. You must approve Invoices before you can allocate Receipts to them and for them to appear in the Periodic Customer Statement.
In this chapter:
Opening Balances in the Sales Ledger - Entering Receipts
As with entering Invoices, you can get a lot of help with entering your Receipts using the shortcuts built in to Enterprise by HansaWorld. Perhaps the most useful tool is the 'Paste Special' command. You can use 'Paste Special' whenever you enter data in a field that refers to another register or setting.There is no need to enter any Receipts from the previous fiscal year, because you should only have entered outstanding Invoices from that year. You should only follow the steps described below for Receipts from the current year to date (i.e. only if you are starting to use Enterprise by HansaWorld in the middle of a fiscal year).
In this chapter:
Opening Balances in the Purchase Ledger
When entering opening balances in the Purchase Ledger, you should follow the same basic decisions and procedures described on the Sales Ledger page, using the Purchase Invoice and Payment registers in the Purchase Ledger. Before entering opening balances, use the Sub Systems setting in the Nominal Ledger to make sure that your previous year Purchase Ledger opening balances will not be posted to the Nominal Ledger, as described here.---
In this chapter:
Opening Balances in the Stock Module
When entering opening balances in the Stock module, the precise procedure to be followed will be determined by the nature of your business and the Items that are sold. Again, as in the Sales Ledger, the accuracy of the opening balances increases with the level of detail entered, but the time required by the task increases as well.You should decide whether to:
You should also use the Goods Receipt check box and date in the Sub Systems setting in the Nominal Ledger to make sure that your stock control opening balances will not be posted to the Nominal Ledger, as described here.
When entering opening balances in the Stock module, follow the same basic procedures described on the Sales Ledger page, using the Goods Receipt register.
---
In this chapter:
Importing Opening Balances
If you are changing to Enterprise by HansaWorld from another computer program, it is likely that you will want to import opening balances for all three ledgers from text files created by your old system. If you wish to do this, please follow the import instructions described on the Importing Sample Data page to import your text file. This procedure, although described there as one used to import a Chart of Accounts, is in fact an all-encompassing function that will import whatever is in the selected text file and save it in the appropriate place in your Enterprise by HansaWorld database. For details of the composition of the text files, please refer to your HansaWorld representative. Ensure that they contain opening balances as they were at the beginning of the fiscal year and all subsequent transactions as described in the previous sections.---
In this chapter:
Printing Reports
You can produce many different reports from Enterprise by HansaWorld. Detailed descriptions of each report can be found in the appropriate sections of these web pages. You should, however, always print a Transaction Journal for the Transactions entered during one work session. The same goes for the Invoice Journal in the Sales Ledger.Having completed the process of entering your opening balances, you should now print a Trial Balance and compare it with a Trial Balance produced from your old system.
To print a Trial Balance, follow these steps:
In this chapter: