Overview
Generally, you will be entering these opening balance figures from financial statements.
- Balance Sheet
- Operating statement
- Record of purchases of assets (CGT Register)
The following will need to be completed when entering opening balances for your Company:
- Create the Company
- Add additional equity accounts to the Chart of Accounts
- Input balance sheet items
- Input operating statement (optional)
- Update ledger to the current year
The article will guide you through the process of entering opening balances.
Example
Company Details
Company Name: Zap Pty Ltd Incorporation Date:21/11/2005 Financial Year Start:01/07/2018 Financial Year End: 30/06/2019 System Start Date:01/07/2019
Financials
The following financial will be used in entering the opening balances for the Company.
Instructions
From the Main Toolbar, select Home then click Entity Setup
Record the Company details:
Entity Type | Select Company. |
Company Type |
Select one of the following:
|
Import from CAS 360 | Select the existing company in your CAS 360 to import the basic details. For more information, click here. |
Badge | Assign a Badge to the Company. |
Company Name | Enter Company Name |
Entity Code | Entity code will be automatically created, however, the field is editable. |
ABN | Enter the ABN |
TFN | Enter the TFN |
ACN | Enter the ACN |
Opening Balances | Select Yes, if you are setting up and entering opening balances. |
Incorporation Date | Input the Date Formed. |
Financial year | Input the Financial Period as per your Financial Statements. |
The Company tax rate will need to be set up in the Company Details screen. For further information regarding setting up Company tax rates, please see the following article
Investment Revaluation will automatically trigger from the System Start Date going forward.
Automatic Revaluations can be controlled from the Company Details Screen:
From the Main Toolbar, go to Company. | |
Select Company Details. |
|
Select Yes for Automatic Revaluations. |
The balance sheet can now be entered into Simple Invest 360.
The following components of the Balance Sheet will be entered:
- Assets
- Liabilities
- Equity
In this section we're going to cover an example of how to enter an investment (AGL Energy Limited).
When entering investment history, purchases must use the more details panel and input the actual date of purchase as the contract date.
Fund Investments must be entered at the original purchase price.
In this task you will learn how to input all investment history manually. However, the option to import investment history using the BGL XML Import or Smart Docs - CGT is also supported.
New to Simple Invest 360, is the Quick Data Entry screen to record your investment history. For more information, click here.
From the Main Toolbar, go to Accounting. | |
Select Transaction List | |
Select the New Transaction. | |
Select Journal. |
Record the purchase of AGL Energy Limited.
Date | Input 30/06/2019 |
Reference | Input 3 |
Description | Buy 1092 AGL |
Select an account | Select |
Create Investment | Select Investment |
Investment Type | Select Shares in Listed Company (Australian) |
Investment Code | Input AGL.AX |
Name | AGL Energy Limited. |
Save Investment | Select |
Account | Account 77600/AGL.AX will now display. |
Amount | Input a debit amount of $23,753.09 |
Account | Select Account 99800 - Unspecified Data Clearing Account |
Amount | Input a credit amount of $23,753.09 |
We'll now look at entering liabilities for the company based on the balance sheet above: We'll enter the example - AP Current.
From the Main Toolbar, go to Accounting. | |
Select Transaction list | |
Select the New Transaction. | |
Select Journal. |
Date | Input 30/06/2019 |
Reference | Input 5 |
Description | Input Asset Purchase: AP Current |
Select an account | Select Account 800001/AP Current - Asset Purchase Liabilities (Create Sub Account) |
Amount | Input a credit amount of $18,001.56 |
Select an account |
Select Account 99800 - Unspecified Data Clearing Account |
Amount | Input a debit amount of $18,001.56 |
Once your balancing entry has been entered, save the transaction by selecting .
80101 | Loans - Related Parties | Control Account |
80200 | Unitholders Loans | Control Account |
80500 | Amount owing to other persons | Control Account |
81000 | Interest Accrued | Control Account |
83000 | Investment Liabilities | Control Account |
84000 | GST Payabale/Refundable | Normal |
84500 | Income in Advance | Normal |
85000 | Income Tax Payable/Refundable | Normal |
85660 | Investment Loan | Control |
86000 | PAYG Payable | Normal |
88000 | Sundry Creditors | Normal |
88500 | Beneficiary Loans | Control |
89000 | Deferred Tax Liability/Asset | Normal |
89990 | Migration Suspense Account | Normal |
.
First we will create the sub account - Issued Units: Ordinary Shares.
From the Main Toolbar, go to Accounting. | |
Select Chart of Accounts | |
Locate the 58600 Control Account using the search bar | |
Select the + icon. | |
Select Sub Account from the drop-down menu. | |
Enter the relevant information, including the Sub Account Code and name of the security. Once this has been entered, select Save. |
Once the Equity account has been created, we will post the opening balance entry to the account.
From the Main Toolbar, go to Accounting. | |
Select Transaction list | |
Select the New Transaction. | |
Select Journal. |
Date | Input 30/06/2019 |
Reference | Input 5 |
Description | Input Equity |
Select an account | Select Account 58600/Units - Issued Units: Ordinary Shares |
Amount | Input a credit amount of $2.00 |
Select an account |
Select Account 99800 - Unspecified Data Clearing Account |
Amount | Input a debit amount of $2.00 |
In this task, you will learn how to input the Operating Statement for comparative purposes. This step is optional based on whether you wish to report this year's profit and loss statement with comparative balances from the previous year.
Franking credits and Distributions
Prior year franking credit and taxable distribution components (tax deferred, tax-free, etc.) can be recorded in the More Details Panel of the respective line items when inputting comparatives for dividends (23900) and distributions (23800).
In this task, you will learn how to input Operating Statement items as of 30/06/2020.
You will be using Journals to enter the Operating Statement items.
From the Main Toolbar, go to Accounting. | |
Select Transaction list | |
Select the New Transaction. | |
Select Journal. |
Note: The investment income and expense accounts have been automatically created. This occurred when the investment accounts were created.
Date | Input 30/06/2019 |
Reference | Input 6 |
Description | Operating Statement |
Select an account | Select Account 28001/00001 (Commission Income) |
Amount | Input a credit amount of $40,000 |
Select an account | Select Account 23800/VSO.AX (Distribution) |
Amount | Input a credit amount of $145,975.50 |
Continue entering the remaining operating statement items by selecting Add Line.
Account | Description |
Amount
|
37900 | Interest Paid | 4,234.83 |
23900/AGL.AX | Dividends Received | (15,792.79) |
28000/ZapCommercial | Property Income | (4493.90) |
30100 | Accountancy Fees | 1080.00 |
30001 | Filing Fees | 263.00 |
31500 | Bank Charges | 34.93 |
38000 | Insurance | 322.47 |
37500/MVCost | Investment Expenses | 507.88 |
37901 | Motor Vehicle Interest | 3567.31 |
37902 | Less: Motor Vehicle Contribution | (3924.52) |
37999/Donation | Discounts | 2000.00 |
35000 | General Expenses | 419.77 |
41960/ZapCommercial | Property Expenses - Council Rates | 843.65 |
24700 | Changes in Market Values of Investments | (8853.67) |
48500 | Income Tax Expense | 5615.42 |
33400/MVCost | Expense - Depreciation | 13,552.00 |
33400/P&E | Expense - Depreciation | 2421.00 |
49000 | Profit/Loss Allocation Account | 184178.12 |
To save the transaction, select .
The following message will display:
Select Ok.
In this task, you will learn how to close the financial year, which will update the ledger to the next accounting period to begin working on current year transactions.
From the Main Toolbar, go to Compliance. | |
Select Period Compliance. |
From within the Period Compliance screen, select 4. Close Period.
*Note that the other tabs - Calculate Taxable Income, Distribute Profit are not required to be processed at this stage. All required information should have been entered when entering opening balances.
From within the Close Period screen, select the Close Period button.
The Company is now ready for the current financial year.