Article Objective: To assist users in navigating Active Ledger & Reporting to generate a Statement of Changes in Equity report.
Context: There are three options available for displaying data in the Statement of Changes in Equity including: Normal, Equity Type Per Column Using Movements, and Entity Type Per Column Using Account Attributes.
Please refer to the Glossary for definitions of key terms used in this article.
TABLE OF CONTENTS
|
Accessing report variation
To choose the report variation, navigate to your report and add the Statement of Changes in Equity page if it is not already in your report template. Click on the Customise button. This will bring up all the options for customising the page.
Click on the dropdown menu of Report Variation to show the options, as below.
Normal report variation
This will display the report as per the layout selection. The layout can be modified by wrapping up, hiding or displaying detail in notes, as is the case with the Profit and Loss, Balance Sheet and Appropriation Statement.
For more information on how to modify the layout, see the knowledge article: Reporting - pages.
Equity type per column report variation
The 'Equity Type per Column' modes use the opening balance and movements classification header accounts to help construct the columns.
For each column, the opening balance is worked out using one of two methods based on which option was selected:
Equity type per column using movements
The opening balance for each column will be calculated by calculating the opening balance of each individual account within the header linked to that column. The balance of each account will be treated as 'movements'. This can be seen as a 'transaction' level mode as we look at the types of transactions/journals posted to the accounts to determine what is an opening balance versus what is a movement.
Equity type per column using account attributes
The opening balance for each column will be calculated by taking the account balance of each account within the header linked to that column which has 'Opening Balance Account' ticked in the account screen. All other accounts will be considered to be 'movements'. This can be seen as an 'account' level mode as we look at the type of each account as a whole to determine what is an opening balance versus what is a movement.
Columns
Columns are built from the following accounts in the equity statement:
Capital
The capital column is built from the default capital system account, noting it may be renamed based on practice preferences and entity type modifications.
If the capital account has only child headers, and no child accounts, then those headers will each become a column. For example:
Will be converted into the following columns:
Reserves
Are treated identically as capital accounts, including the ability to create additional columns by adding sub-headers.
Retained earnings
This account is a dedicated column. All child accounts will be laid out per the layout options defined when customising the page.
Both current year earnings and other comprehensive income will be consolidated into single rows of movements at the top of this column.
Minority interest
Will become its own column. All child accounts will be laid out per the layout options defined when customising the page.
Total
The total column will be a simple mathematic addition of each other column.
Editing column titles
Individual column titles will reflect the name of the account that they are based on. This means you can modify them by renaming the account, or by editing the header title in the customise screen:
Movement rows and titles
By default, accounts for each column will be laid out per the layout settings when customising the page.
For example, if you leave the distributions account expanded:
You will see the same account displayed and expanded with it's child accounts in the Statement of Changes in Equity:
For this reason, it is normal to collapse most of the headers inside of retained earnings unless there is particular detail you wish to expand upon in the statement. This means your customised report layout will look like this in most circumstances:
The title for each account in the Statement of Changes in Equity is set to the following by default:
Capital account | Using movements | Using account attributes |
Capital | Labelled as '##{{Account Name}} Issued/(Redeemed) During the Period' | Labelled with the account name |
Reserves | Labelled and combined as 'Transfers to Reserves' (using the Transfers to Reserves movement category, see paragraphs below). | |
All others | Labelled with the account name |
For any given account or custom header, you may customise the movement title or movement category used to describe movements by modifying the account name, by editing the below two fields in the account edit screen.
The movement Category gives you a dropdown menu with standard system naming conventions (preference these if they suit your situation), while the movement 'Title' lets you specify any text.
Specifying either of these values has two outcomes:
1) The label for this movement in the Statement of Changes in Equity will be updated
2) If there are other accounts with an identical movement category or title, they will be merged into a single row and shown side by side.
The latter outcome is commonly used to link transfers to/from reserve accounts together in one row.
Apportionments of other comprehensive income
To apportion amounts of other comprehensive income (OCI), you must first ensure such amounts are recognised in the OCI region.
For example, you may post the following journal entry:
Classification | Account | Debit | Credit |
Asset | Equity instruments | XXX | |
Other | Fair value gain/(loss) on investments in equity instruments designated as at FVTOCI | XXX |
This would result in an account that you would link to the equity section as follows:
To allocate some of these amounts of OCI to a reserve, separately recognise the allocation as a 'transfer to a reserve'.
Classification | Account | Debit | Credit |
Other | Allocation of OCI to asset revaluation reserve | XXX | |
Equity | Asset revaluation reserve | XXX |
These two accounts would appear in the chart as follows:
For both you would set the movement Category to the 'Allocation of Other Comprehensive Income'.
Setting the Category to 'Allocation of Other Comprehensive Income' will align the movements from these accounts with other comprehensive income itself, giving you the following result:
Note: If there are discrepancies in movements of equity accounts, you will receive an error:
To set up the accounts, navigate to the Accounts screen of the entity.
For information on how to customise the page layout and columns for this page type see the corresponding sections in the knowledge article: Reporting - pages.