Article Objective: To assist users in navigating Active Ledger & Reporting to create account divisions to assist with reporting. Context: Trading accounts are a way of separating profit and loss items into a separate reporting section. This is primarily used for sales trading and livestock trading. Trading accounts are set up on a per entity file basis. Please refer to the Glossary for definitions of key terms used in this article. TABLE OF CONTENTS |
Overview
There are three steps in the process of creating a trading account report:
- Creating a trading account classification
- Allocating an account to a trading account classification
- Producing a report with separate trading account report settings.
A sample of a trading account report layout is as follows.
Creating a trading account classification
To create a new trading account, navigate to the Trading Accounts section from the File Settings menu from any screen within the client file.
You will be directed to a screen with a list of all available trading accounts. To create a new one, select +New Trading Account.
You will need to give the trading account both a code and a name. You can then select the profit and loss location. There are three options; income, other income or none. This will determine where the summary will appear on the profit and loss. You can also choose to select an alternative page title for the trading account report. By default, if the field is left blank the page title will just be the name of the trading account. If the 'Primary Production' checkbox is ticked, another checkbox will appear for you to indicate whether the trading account is also a 'Livestock' account.
Finally, click the Add Trading Account button in order to add the trading account to the client file.
Note: Nominating a trading account as 'Livestock' will allow you to use the primary production calculator for that particular trading account. For more information, see the knowledge article: Datasets - other info - primary production.
You will now see it appear in the list.
Allocating an account to a trading account classification
To allocate an account to a trading account, navigate to the Accounts screen and edit an account by selecting the edit icon to the right of the relevant account.
On the account edit screen, select the required trading account from the drop-down list.
There are two options, you can either select the default behaviour of the whole Active Ledger account or select the behaviour of a single source account. This is useful for sub-accounts or linked accounts that may have different properties.
Note: An account can be added to both a division and a trading account. For more information on divisions, see the knowledge article: Accounts - Divisions. This allows you the most flexibility when reporting.
After editing the account, select the Save Account button. The account has now been allocated to that trading account for the purpose of reporting.
Divisional and trading account view
To allocate multiple accounts to divisions quickly you can use the 'Divisional and Trading Accounts' view in the Accounts screen. For more information, see the knowledge article: Accounts - overview.
Producing a report with trading account report settings
To produce a report that separates trading accounts page by page, refer to the 'Generating a livestock report' section of the knowledge article: Datasets - other info - primary production. Further, to produce a summary page for all trading accounts, refer to the 'Generating a livestock summary report' section of the knowledge article: Datasets - other info - primary production.
For more information relating to general report settings, see the knowledge article: Reporting - creating a report.
Divisions vs trading accounts
You can also use trading accounts in a similar way.
For a comparison between the two, refer to the table below. See the knowledge article: Accounts: divisions for more information.
Feature | Divisions | Trading accounts |
---|---|---|
Tag Accounts | ü | ü |
Tag Transactions | ü | |
Filter Report Columns | ü | ü |
Separate Profit and Loss Pages | ü | ü |
Primary Production | ü |