What are opening balances?
If you are not a new business and had a previous accounting system before Pandle, then opening balances are required. You should choose a date to stop using your old system and start using Pandle. On this date, your old system will have closing balances, usually in the form of a trial balance report. These balances will be things like the value of assets, bank balances, loan balances etc. These closing balances are then used as opening balances in Pandle so you must ensure that the bookkeeping completed on your previous system was correct and complete up to that date.
What date should I start using Pandle?
Starting from a new financial year (usually 6th April for sole traders, or the day after your year end on Companies House if you have limited company) is usually the best option as it means your bookkeeping is not across two systems when preparing the accounts/tax return, although you can technically start to use Pandle at any date. However, we would strongly advise that you start from the beginning of a new VAT quarter (if your business is VAT registered) to ensure VAT calculations are correct. If you start during a VAT quarter then you will need help from a professional to ensure the first VAT return in Pandle is submitted correctly.
How to enter opening balances
Go to Categories > New '+' > Opening Balance Wizard. You will then be presented with a wizard (as below).
The first two steps are to add your customers and suppliers (if you haven't done this already). You only need to add the customers and suppliers who you owe money to and who owe money to you at the date you're starting to enter transactions in Pandle. If you have lots of customers/suppliers to add, you can import them all in one go by heading to Enter Transactions > Customers Tab/Suppliers Tab.
If your business is VAT registered then the next step is for you to supply your VAT details. You may have already entered this information when setting up Pandle originally but if not, you will need to enter it now. It is important to get the VAT settings right at this stage so that Pandle knows how to calculate the VAT correctly on the opening balance transactions, such as the amounts owed from your customers.
You will then need to change the outstanding amounts to the same date you begin entering transactions in Pandle. If you were neither owed money from customers (debtors) or owed money yourself to suppliers (creditors), you can skip this stage.
If money was owed then all invoices which make up the amounts owed will need to be entered here. You can enter customer and supplier invoices here by changing the 'type' of transaction on each row.
The final step asks for the remainder of your opening balances which you can take from the trial balance of your previous system. You will notice that the amount owed from customers and amount owed to suppliers have been populated for you. These amounts should match those on your closing trial balance; if they do not then you will need to go back to the previous step and correct the invoicing entries.
Please ensure that the date entered (highlighted above) is the start date transactions are being entered from (the day after the closing trial balance date).
Opening balances can sometimes get complex depending on your previous system and how many balances you have. Therefore if you have any doubts then it's always best to ask your accountant.