Transfer Your Trial Balance into Khaos Control Cloud
WARNING
This information can not be imported and must be manually entered.
This process can have severe long term implications if not carried out correctly.
Prerequisites
Besides some of the system nominals, the following nominals will be required for this process:
- CUOB
- Description - Customer Opening Balance
- System Type - Customer Opening Balance
- Account Type - Company
- SUOB
- Description - Supplier Opening Balance
- System Type - Supplier Opening Balance
- Account Type - Company
- SysOB
- Description - System Opening Balance
- System Type - Current Asset
- Account Type - Company
- 621
- Description - Expense Account
- System Type - Expense Account
- Account Type - Company
The blue nominals will need creating if not already done so.
Where we have listed an expense nominal in green, for your accounts this would be broken down and you would need to create individual expense nominals for tea and coffee, printing, rent, salaries etc.
How to your Transfer Trial Balance into Khaos Control Cloud
Info
In this guide we will be using the following table as an example of the Trial Balance in our existing system that we are going to enter into Khaos Control Cloud from our old system:
Code
|
Description
|
Debit
|
Credit
|
0101
|
Debtors
|
233.00
|
0.00
|
0102
|
Creditors
|
0.00
|
414.00
|
0110
|
Purchase Delivery
|
20.00
|
0.00
|
0115
|
Sales Delivery
|
0.00
|
10.00
|
0120
|
Stock
|
100.00
|
0.00
|
0122
|
Stock – COS
|
200.00
|
0.00
|
200
|
Sterling Account
|
246.00
|
0.00
|
300
|
Sales
|
0.00
|
400.00
|
621
|
Expense Account
|
25.00
|
0.00
|
|
|
824.00
|
824.00
|
Enter Customer Opening Balances
This process will use customer balances totalling £223.00 as stated against Debtors in the grid above however for the purpose of this guide we will only be adding this to a single customer.
- Go to [Accounts | Trial Balance].
- Click Actions and select Enter Opening Balances.
- Select the Company (Customer) whose balance you will be entering.
- In the Invoice Code field OB will already be present however if this has been used for this customer you will need to use a unique value.
- Enter the Amount. In our example we will enter £223.00.
- This will be the customer opening balance.
- Enter the date you wish this opening balance to be invoiced.
- In the Nominal box, select Customer Opening Balance.
- If the amount entered above is a credit, enable the Credit toggle.
- Set the tax rate as required and enable the Post Tax toggle if required.
- Usually any Tax will have been reported using your previous system so leave this disabled.
- Specify the Currency the opening balance is in.
- Click Post Transaction.
Having followed the process above our debt for this customer is £223.00. Repeat for each customer.
Enter Supplier Opening Balances
This process will use customer balances totalling £414.00 as stated against Creditors in the grid above however for the purpose of this guide we will only be adding this to a single supplier.
- Go to [Accounts | Trial Balance].
- Click Actions and select Enter Opening Balances.
- Select the Company (Supplier) whose balance you will be entering.
- In the Invoice Code field OB will already be present however if this has been used for this customer you will need to use a unique value.
- Enter the Amount. In our example we will enter £414.00.
- This will be the customer opening balance.
- Enter the date you wish this opening balance to be invoiced.
- In the Nominal box, select Supplier Opening Balance.
- If the amount entered above is a credit, enable the Credit toggle.
- Set the tax rate as required and enable the Post Tax toggle if required.
- Usually any Tax will have been reported using your previous system so leave this disabled.
- Specify the Currency the opening balance is in.
- Click Post Transaction.
Having follow the process above our debt for this supplier is £414. Repeat for each supplier.
After refreshing the screen our trial balance will now look like this:
You will need to adjust the quantity of stock into the system, when doing this you can also specify the stock item value and this will update the stock nominal. The process for doing this can be found here, How to Adjust Stock Levels.
To do this you must have either imported or manually created your stock in the system, and it must also have a value although this can be set as part of your initial stock adjustment. This is very important as this is the value that the system will use when updating the stock nominal. In our example above, this is £100 of stock and our trial balance now looks like this:
System
Opening Balance Nominal
We
are now going to use the [SysOB] System Opening Balance nominal to journal
against the remaining nominals to complete the trial balance.
Enter Purchase Delivery
- Open [Accounts | Journal].
- Click on the Edit button in the top right.
- Enter the date for the journal.
- Enter a note for the journal.
- Click on the blue +New button to the top right of the grid.
- Add the Purchase Delivery Nominal.
- Click on the blue +New button to the top right of the grid.
- Add the System Opening Balance nominal.
- Enter the Debit amount, in this case £20.00 against the Purchase Delivery nominal.
- Enter £20.00 in the Credit column against the System Opening Balance nominal.
- Click on the Save Journal button in the top right to post the information to the accounts.
Enter Sales Delivery
- Open [Accounts | Journal].
- Click on the Edit button in the top right.
- Enter the date for the journal.
- Enter a note for the journal.
- Click on the blue +New button to the top right of the grid.
- Add the Sales Delivery Nominal.
- Click on the blue +New button to the top right of the grid.
- Add the System Opening Balance nominal.
- Enter £10.00 in the Debit column against the System Opening Balance nominal.
- Enter the Credit amount, in this case £10.00 against the Sales Delivery nominal.
- Click on the Save Journal button in the top right to post the information to the accounts.
Add the Stock Cost of Sale
- Open [Accounts | Journal].
- Click on the Edit button in the top right.
- Enter the date for the journal.
- Enter a note for the journal.
- Click on the blue +New button to the top right of the grid.
- Add the Stock - COS nominal.
- Click on the blue +New button to the top right of the grid.
- Add the System Opening Balance nominal.
- Enter £200.00 in the Debit column against the Stock - COS nominal.
- Enter the Credit amount, in this case £200.00 against the System Opening Balance nominal.
- Click on the Save Journal button in the top right to post the information to the accounts.
Add the Bank Opening Balance
- Open [Accounts | Journal].
- Click on the Edit button in the top right.
- Enter the date for the journal.
- Enter a note for the journal.
- Click on the blue +New button to the top right of the grid.
- Add the Bank Account nominal.
- Click on the blue +New button to the top right of the grid.
- Add the System Opening Balance nominal.
- Enter £246.00 in the Debit column against the Bank Account nominal.
- Enter the Credit amount, in this case £246.00 against the System Opening Balance nominal.
- Click on the Save Journal button in the top right to post the information to the accounts.
Add the Sales Opening Balance
- Open [Accounts | Journal].
- Click on the Edit button in the top right.
- Enter the date for the journal.
- Enter a note for the journal.
- Click on the blue +New button to the top right of the grid.
- Add the Sales nominal.
- Click on the blue +New button to the top right of the grid.
- Add the System Opening Balance nominal.
- Enter the Credit amount, in this case £400.00 against the Sales nominal.
- Enter £400.00 in the Debit column against the System Opening Balance nominal.
- Click on the Save Journal button in the top right to post the information to the accounts.
Enter the Expense Accounts (Phone bills, utilities, rent etc) Opening Balance
- Open [Accounts | Journal].
- Click on the Edit button in the top right.
- Enter the date for the journal.
- Enter a note for the journal.
- Click on the blue +New button to the top right of the grid.
- Add the Expense nominal.
- In our example this is Office Consumables nominal.
- Click on the blue +New button to the top right of the grid.
- Add the System Opening Balance nominal.
- Enter £25.00 in the Debit column against the Expense nominal.
- In our example this is the Office Consumables nominal.
- Enter the Credit amount, in this case £25.00 against the System Opening Balance nominal.
- Click on the Save Journal button in the top right to post the information to the accounts.
Check
all the old trial balance has been entered
You can check that all has been entered correctly by opening the Trial Balance and green selecting all the nominals from your original trial balance, for example:
The next stage of the process is the clear down all the opening balance accounts that we used for the double entry to zero (Customer, Supplier, System and Stock Adjusted).
Clear Down the Opening Balance Nominals
Clear down the Customer OB nominal
- Open [Accounts | Journal].
- Click on the Edit button in the top right.
- Enter the date for the journal.
- Enter a note for the journal.
- Click on the blue +New button to the top right of the grid.
- Add the System Opening Balance nominal.
- Click on the blue +New button to the top right of the grid.
- Add the Customer Opening Balance nominal.
- Create a journal that will clear down the Customer Opening Balance nominal, in this example:
- Debit Customer Opening Balance by £233.00
- Credit System Opening Balance by £233.00.
- Click on the Save Journal button in the top right to post the information to the accounts.
Clear down the Supplier OB nominal
- Open [Accounts | Journal].
- Click on the Edit button in the top right.
- Enter the date for the journal.
- Enter a note for the journal.
- Click on the blue +New button to the top right of the grid.
- Add the System Opening Balance nominal.
- Click on the blue +New button to the top right of the grid.
- Add the Supplier Opening Balance nominal.
- Create a journal that will clear down the Customer Opening Balance nominal, in this example:
- Debit System Opening Balance by £414.00
- Credit Supplier Opening Balance by £414.00.
- Click on the Save Journal button in the top right to post the information to the accounts.
Clear down the Stock Adjusted OB nominal
- Open [Accounts | Journal].
- Click on the Edit button in the top right.
- Enter the date for the journal.
- Enter a note for the journal.
- Click on the blue +New button to the top right of the grid.
- Add the System Opening Balance nominal.
- Click on the blue +New button to the top right of the grid.
- Add the Stock Adjusted nominal.
- Create a journal that will clear down the Customer Opening Balance nominal, in this example:
- Credit System Opening Balance by £100.00
- Debit Stock Adjusted by £100.00.
- Click on the Save Journal button in the top right to post the information to the accounts.
Checking
that the Trial Balance has been entered correctly
Once you have cleared down the accounts, check the Trial Balance to make sure that the opening balances have been entered correctly and the totals match those of your previous accounting system.