Opening balances represent the financial position of your business on the day you start using Sage 50 Accounts.
Typically opening balances consist of information such as:
Outstanding customer transactions
Outstanding supplier transactions
Nominal Ledger Trial Balance figures
You're likely to have opening balances even if you're just starting your business. When you enter accurate opening balances for Sage 50 Accounts financial reports, you'll see a true picture of your financial position.
NOTE:
If you're using the VAT Cash Accounting VAT Scheme, follow our alternative opening balances article.
To age transactions for debt chasing purposes, enter each transaction individually using the original posting date. If you don't need to age the debt, enter the balance as a total on the default date you set for your opening balances.
Complete the Customer Opening Balances window as follows:
A/C
Choose the required customer account.
Date
The default opening balances date appears. If required, change this to the actual transaction date.
To age transactions for debt chasing purposes, enter each transaction individually using the original posting date. If you don't need to age the debt, enter the balance as a total on the default date you set for your opening balances.
Complete the Supplier Opening Balances window as follows:
A/C
Choose the required supplier account.
Date
The default opening balances date appears. If required, change this to the actual transaction date.
After entering the customer and supplier opening balances, you need to check you've entered the correct values.
Use this option to run the aged analysis and trial balance reports to confirm the correct values.
Complete the Criteria for Batch Report window as follows:
Exc Later Payments
Leave this checkbox clear.
Transaction Date
Leave the first box as 01/01/1980. In the second box, enter the last day of the period before you're starting date. For example, if you're entering your opening trial balance as at 01/08/2011, enter 31/07/2011 here.
Inc Future Tran
Leave this checkbox clear.
Period
From the dropdown list, select Brought forward. Use the period before your starting date. For example, if you enter your opening balances on the last day of your previous financial period.
Customer Ref
To run this for all customers, don't change this. To run this for a specific customer or range of customers, use the dropdown lists to select your customers.
Supplier Ref
To run this for all suppliers, don't change this. To run this for a specific supplier or range of suppliers, use the dropdown lists to select your suppliers.
When you enter your supplier and customer opening balances, these appear on your nominal ledger under the debtors and creditors control accounts. To stop these duplicating when you enter your trial balance from your accountant, clear these values first. This option automatically identifies the correct transactions to post.
If you want to create a backup of your data, select Yes. If you don't want to create a backup of your data, select No.
In the Opening Balances Reversals window, confirm the figures are correct then select Reverse.
Enter the individual transactions that haven't yet cleared the bank account. When you run your first bank reconciliation each of these individual bank payments or receipts, the software lists them for you to reconcile.
NOTE:
The software flags these transactions as unreconciled and they don't increase the bank opening balance. The software assumes that you included the totals in the trial balance. If you want the uncleared items to affect the bank opening balance, enter them separately as bank payments or bank receipts.
Complete the Bank Opening Balances window as follows:
Bank AC
Choose the required bank account.
Name
The bank account name appears.
Date
The default opening balances date appears. If required, change this to the actual transaction date.
Ref
The reference O/Bal appears.
Department
Choose the required department.
Type
Choose either Receipt or Payment.
Amount
Enter the amount of the uncleared item.
T/C
Choose the required tax code.
VAT
The VAT amount appears.
Press Save.
This posts either a bank payment or bank receipt to the suspense account. As well as journals to reverse the affect on the nominal ledger
Once you've entered your nominal and bank opening balances, compare the trial balance in Sage 50 Accounts to the your accountants trial balance. This ensures that you've entered the correct values.
In the Criteria for Period Trial Balance window, select the Period dropdown list and choose the period before your starting date. For example, if you enter your opening balances on the last day of your previous financial period, select Brought Forward.
Press OK.
The Period Trial Balance appears and will match the trial balance from your accountant.