Opening balance journal

Opening balance journals are required if you have just joined us and need to add opening balances for bank accounts for example.

Check your nominal codes

Using your old trial balance data, check that you have the same nominal codes set up in your IRIS Elements Cashbook chart of accounts.

You will also need to create a new code for your Debtor and Creditor Control Accounts as you are unable to post Journal entries directly to these codes on the opening balance journal.

Step 1 - Creating new codes

You can create a new code called Opening Balances or create a Suspense account.

When creating a new code, you will be asked to select the Type. This type determines whether the nominal code will appear on the Balance Sheet or Profit and Loss report, and on which section of that report it will appear.

If you would like the nominal code to appear on the Profit and Loss report, you will need to select either Turnover, Cost of Sale or Expenditure.

If you would like the nominal code to appear on the Balance Sheet you will need to select either Fixed Asset, Current Asset / Liability or Capital & Reserves.

Whilst in this screen, you will also need to change a setting under Show Advanced Configuration Options at the bottom of the screen.

You will need to select the following options:

  • Allow me to access all codes in all areas – not just Sales Codes in the Sales area and so on.

  • Allow me to configure Fixed Assets, Cost of Sale (etc.) options directly on the page where I edit nominal codes instead of just from this page.

  • Enable the journal (a link will show in the main menu for it).

Once you have selected these options, select Update.

You have now enabled the Journal, enabled all types of Nominal Codes to be accessed in all areas, and created an Opening Balance code / Suspense Account.

The Name and Code can be anything you want to best suit your preferred method of record keeping.

Step 2 – Entering the Journal

The next step is to enter in the Opening Balance Journal. This is your Trial Balance as of the date you are switching from your previous accountancy software to IRIS Elements Cashbook.

  1. Go to Journals > +Create.

  2. Enter the Date of your Trial Balance, or the date you wish to start recording data within IRIS Elements Cashbook

  3. Enter a Category. This should be Standard Journals.

  4. Enter Opening Balances for the Comment or anything you feel best represents the journal for your records

  5. Select Create Journal.

On the next screen, enter in your opening balance journal, you will need to work through the lines on your Trial Balance report and select the relevant nominal code as per that line.

The information needed on the journal entry line is:

Type – select the Nominal Code using this drop-down (for instance, if you wish to define an Opening Balance for your default Bank Account you may select Nominal Code 1200 – …).

Narrative – this will simply be the Description of the monetary movement when viewing the Nominal Codes history.

Debit – this is the column you will put in any amounts you wish to give the Nominal Code account.

Credit – this is the column you will put in any amounts you wish to take from the Nominal Code account.

Example:

A Journal must always balance, as if values are supplied to one account they must be recorded as being taken from another, the reverse also applies.

Step 3 – Debtor control account balance

There are two ways you can do this; one is to create one bulk amount, or you can set the opening balance per customer record.

If you wish to do this as one bulk amount:

  1. Go to Customers > + Create and Name the customer Opening Balance.

  2. Create an invoice for this customer; go to Invoices > + Create.

  3. Select Add Line Item and select the same code as used on your opening balance journal (Opening Balance or Suspense).

  4. Then enter the following details:

    Sales Code – select Opening Balance code or Suspense code.

    Rate – this should be the amount of your Debtors figure.

    VAT Rate – this should be N/A as the VAT will already be accounted for in your Opening Balance Journal (if you are recording the Opening Balances of your VAT Liabilities, too).

  5. Select Save. Your Trial Balance for the Debtors Control Account will now have this figure recorded.

If you wish to record this per customer, you will need to set up your customer records:

  1. Go to Customers > + Create and enter the details.

  2. You will then need to create an invoice for each customer, using the same method as above by selecting Add Line Item and selecting the same code as used on your opening balance journal for the Debtor Control Balance.

Example:

Step 4 – Creditor control account balance

There are two ways you can do this; one is to create one bulk amount, or you can set the opening balance per supplier record.

If you wish to do this as one bulk amount:

  1. Go to Suppliers > + Create and Name the supplier Opening Balance.

  2. Create a purchase for this supplier by going to Purchases > + Create.

  3. Select Add Line Item and select the same code as used on your opening balance journal (Opening Balance or Suspense).

  4. You will need then need to enter the following details:

    Purchase Code – select Opening Balance code or Suspense code.

    Rate – this should be the amount of your Creditors figure.

    VAT Rate – this should be N/A as the VAT will already be accounted for in your Opening Balance Journal (if you are recording the Opening Balances of your VAT Liabilities, too).

  5. Select Save. Your Trial Balance for the Creditor Control Account will now have this figure recorded.

If you wish to record this per supplier:

  1. Go to Suppliers > + Create and enter the details.

  2. Create an invoice for each supplier, using the same method as above by selecting Add Line Item and selecting the same code as used on your opening balance journal for the Creditor Control Balance.

Steps Completed

All steps are now completed.

Go to Reports > Business > Nominal Ledger report to view all of your nominal codes to check that they have been assigned the right opening balance.

When you see the amounts for the Debtor and Creditor Control account you will see that the balance of that code is now zero.

You can also print the Trial balance report within IRIS Elements Cashbook by going to Reports > Financial > Trial Balance. Here you will see that the Debtor and Creditor Control Accounts are now showing with the correct opening balances.

If you are on the Cash Accounting scheme then you may wish to take a look at this knowledge base article as there are additional steps you will need to take.