Annual accounting is a custom assessment method for regulated water in the resource assessment module. The related water user, bulk licensing or environmental demand nodes must be configured consistently with the resource assessment system. The general principles for an annual accounting system are:
- An available Available resource is calculated during a defined water year;
- Allocation of the resource is made to different account types;
- Each account type’s allocation are is distributed between accounts linked to this account type; and
- Any allocated water that has not been carried over at the end of the defined water year will be returned to the available resource for allocations of next year.
An annual accounting system set up in Source follows these principles.
...
Enabling annual accounting
Firstly, create an annual accounting system as follows:
- Choose Edit » Resource Assessment... to open the Resource Assessment Explorer; and
- Right click Resource Assessment and choose Add Annual Accounting.
...
In the top Annual Accounting level, you can:
- Configure annual accounting using the Configuration tab;
- View summary information of all accounts added with the Accounts tab;
- Set the available resource vs allocation table using the Allocation tab; and
- Set trigger priority with the Trigger Priority tab.
The next sections provide further details of all the tabs listed above.
Configuring an annual accounting system
This tab provides an overview of the annual accounting system (as shown in Figure 1). The required parameters are explained in Table 1.
Figure 1. Annual Accounting, Configuration
Table 1. Annual accounting, Configuration tab
Item | Description |
---|---|
Owner | This lists all the owners that have been configured using the Ownership Setup dialog (refer to Ownership in Source) |
Debit Type | Determines how water is deducted from all accounts associated with this annual accounting system; based on either order or extractions. |
Start of Water Year | Day-month that the water year starts. |
Usage to date | Determines how much of the water allocated has been ordered or used by water users in the water year to date. There are two options available: Usage From Function and Usage From Account Host. When losses upstream of the water user need to be considered, a function may be required to account for this. |
Storages | Lists all the water storages in the project. Tick any storage whose resources are used for the annual accounting system. |
Inflows | Lists all the inflow in the project. Select any inflow whose resources are used for the annual accounting system. The recession factor of each inflow can be set using the corresponding Function Editor. It provides the total volume of recession between the current time-step and end of the current water year. |
Other Resources | Represents other resources such as inter-valley transfers. |
Commitments | These are used to represent other commitments such as special reserves or provision for minimum flows. |
Accounts
This tab provides a summary of all the accounts in the annual accounting system. As shown in Figure 2, you can add or delete accounts using the corresponding buttons below the Accounts table. Each of the parameters in the Accounts table is explained in Table 2.
Figure 2. Annual Accounting, Accounts tab
Table 2. Annual accounting, Accounts tab
Item | Description |
---|---|
Name | Name of the account. |
Account host | Node that the account is associated with (Water User, Bulk Licensing or Environmental Demand). |
Account type | Type of account (named by you). This is configured under the hierarchical item Account Type. |
Unit shares | Number of unit shares assigned to the account. For convenience, this should be the volume (in ML) in an annual accounting system. |
The next sections explain the contextual menu items when you right click on the annual accounting system.
Add Off-Allocation System
...
Initial balance | The initial account balance. If you are going to use the initial account function, you need to ensure that there is sufficient water in storages to cover the total initial balances as well as the required reserves. If the initial balances are set too high a warning message will be generated and the results may not follow the required logic. |
Info | ||
---|---|---|
| ||
Note: The last two column values correspond to the account information entered under Account Type. |
To add an account in the table, click Add Account below the Accounts table to open the Add New Account dialog (shown in Figure 3) and add an account in the table. To associate an account with a host, click on the individual account below the Account type. The section on the far right lists all the associated account hosts available in the scenario. Then, click on the required host.
Info | ||
---|---|---|
| ||
Note: If a host has already been associated with an account, it will not appear in the list. |
Hosts in a scenario may consist of water users, bulk licensing nodes or an environmental demand node.
Figure 3. Annual accounting, Accounts tab, Add New Account
Allocation
The Allocation tab shows the quality of resources required to achieve the specified allocations, including provision for carryover. Configuration of the Resource and Account Type columns depends on the how the Account type has been configured, in particular the Method to apply for this account type in ARA table parameter. Figure 4 shows how the ARA table varies with this parameter and Table 3 explains the variations.
The columns shown in the Figure 4 are:
- Resource - The water available in the system;
- Carryover - The proportion of water that is carried over to the next water year; and
- There is an additional column for each Account Type, and it is configured as shown in Figure 1.
Figure 4. Annual accounting, Allocation tab
Table 3. Annual accounting, Allocation, Variations
Menu option in ARA table | Resulting variation in Allocation tab (Annual Accounting) | |||||
---|---|---|---|---|---|---|
Percent (with linked volume) | The Account Type column can be edited directly on the table. The Resource column is calculated automatically based on the percentage allocation of the Account Type share volume. | |||||
Function | The Resource column is calculated based on the function specified for the Account Type.
| |||||
Monthly-varying | In the Account Type column, click the hyperlink to open the table showing the allocations for each month in the water year (shown in Figure 5). Values in the table will be calculated depending on the option chosen for the calculation method in the Account type tab. If interpolate is chosen for the calculation method, the Resource of the first column is calculated based on the current and next month values. If Threshold is chosen, the value in the Resource column corresponds to the value in the current month. You can set the resource for each monthly manually or by importing it. This data can also be exported. | |||||
Percent (with function) | In the Account Type column, click Function... to specify what proportion of Shares (in the Account Type) will be assigned to the Resource column. For example, consider Shares = 50000ML, and the function specifies 10% in the Account Type column, the value in the Resource column will be 5000 (10%*50000) ML. | |||||
Volumetric | The value is directly editable in the table. The Resource column is then based on the value in the Account Type column. |
Trigger Priority
Figure 5 shows the Trigger Priority tab. Priorities are separated into two: Timestep Beginning and Timestep End. You can re-order the priority of triggers.
Info | ||
---|---|---|
| ||
Note: Trigger must be configured before prioritising them (refer to Adding a trigger to an account type for defining a trigger). |
Figure 5. Annual accounting, Priority Trigger
The next section deals with how to configure the different items shown in Figure 1.
Adding an off-allocation system
Off-Allocation Systems are assigned at the top Annual Accounting level. To add an off-allocation system, right click Annual Accounting and choose Add Off-Allocation System. Refer to the Off Allocation node for more information.
...
Account Type
An annual accounting system may contain several account types (as defined by you). Each account type can also include many accounts. As To add an account type, as shown in Figure 1, right click on the annual accounting system and choose Add Account Type.
In the Account Type level, you can use the:
- Configuration tab to configure the account type (shown in Figure 6);
- Accounts tab to view a summary of all accounts in the account type; and
- Non-Debit Accounts tab to view and configure all non-debit accounts in the account type.
The next section describes each of these tabs.
Configuring an account type
Figure 6 shows the configuration parameters required for an account type. These are explained further in Table 4.
Figure 6. Annual accounting, Account type, Configuration
Table 4. Annual Accounting, Account Type, Configuration
Item | Description |
---|---|
Debit Type | Determines how water is deducted from all accounts associated with this continuous accounting system; based on either order or extractions. |
Priority | Not used. |
Minimum Balance | If a minimum balance is defined, then order or extractions will not be allowed if it will cause the balance to drop below the minimum specified. |
Maximum Balance | Defines the maximum volume of water which can be held in an account. If an allocation results in this limit being exceeded, then the excess amount is available to other account types. Choose Per Unit Share to define the maximum balance as a volume per share. |
Allocation Calculation | The default is Available Resource Allocation Table, which opens the Available Resource Allocation (ARA) table. The options available for this are shown in Table 2. Choose Function to determine an account type's allocation using this method. This function may reference a wide range of variables available in the model, including allocations to other account types and resource assessment system. The Allow Decrease checkbox controls whether or not an account’s allocation can reduce within the water year. |
Info | ||
---|---|---|
| ||
Note: The Method to apply for this account type in ARA table drop-down menu has several options available (as shown in Figure 6), each with a different set of input parameters, explained in Table 5. The option chosen here affects the view in the Allocation tab (Figure 4). |
Table 5. Input parameters for the ARA Table options.
Method | Input parameters |
---|---|
Function | Enter a function using the Function Editor. |
Monthly varying | Choose the appropriate Calculation Method - either Interpolate or Threshold. |
Percent (with function) | Configure the following parameters:
|
Percent (with linked volume) - default | Same parameters as Percent (with function). |
Volumetric | Volume. |
Accounts
Choose the Accounts tab to view a summary of all the accounts configured in the account type. The Accounts table is similar to that shown in Figure 2, with parameters summarised in Table 2.
Non-debit accounts (for NSW)
This tab allows you to work with Non-debit accounts. Enable the Enable Non-Debit Accounts checkbox, which allows you to edit the remaining parameters (as shown in Figure 7). These are:
- Availability Threshold - The allocation level at which the water user gets access to the account;
- Repayment Threshold - The allocation level at which repayments need to be made. As the water user approaches its maximum allocation, repayments need to be made;
- Carry-Over Discount - A discount implemented on the water that is carried over to the following water year. Note that this applies only when Murrumbidgee is chosen as the Balance Calc Method; and
- Balance Calc Method - choose either Murray or Murrumbidgee. This will affect the value assigned to the first two parameters.
Figure 7. Annual accounting, Account type, Non-Debit Accounts
Once an account type has been created, right click to reveal you can create the following items in using the contextual menu (as shown in Figure 1):
- Accounts
- Triggers; and
- Usage limits
These are explained in further detail next.
...
Adding an account to an account type
To add an account to an account type, you must configure Number of Shares, the Initial Account Balance and Previous Usage parameters (as shown on the left side of Figure 7). To link the account to a host, choose the water user, Bulk licensing or Environmental demand node under Associated Account Host. The associated account host column lists all the
...
available nodes in the project. Once these have been configured, you will notice that the value configured for the Number of Shares relates to the Demand distribution item of the water user node (
...
shown
...
on the right side of Figure 7). Refer to Demand distribution for details on configuring the water user node. Notice also that the Account
...
Distribution table (in the node's feature editor)
...
shows details of the resource assessment system.
Info | ||
---|---|---|
| ||
Note: Each account can have only one water user associated with it. |
Figure
27. Annual accounting, Account type, Add account
Add trigger - Triggers are used to initiate or cancel certain actions for an account and can be added at any level in annual accounting.
Adding a trigger to an account type
To add a trigger, right click on the account type and choose Add trigger.
In the resulting right side panel (as shown in Figure 3), you must configure the Trigger and Execution options (as shown in Figure 3) and the resulting Action Configuration panel below will change depending on what is chosen. You can also trigger actions using a function. This is accomplished by choosing Function as the Trigger optionYou can rename or delete an existing trigger by right clicking the trigger and choosing the appropriate contextual menu option.
Info | ||
---|---|---|
| ||
Note: An account can have several triggers, each can be designed to initiate a particular action. |
As shown in Figure 8, configure the following parameters under Trigger Configuration:
- Trigger - the type of trigger. For example, transfer or truncate accounts (refer to Table 6 for the full list). To trigger an action using a function, choose Function in the Trigger drop-down menu. The format of a function should be like this: “IF A>B, 1, 0”, where “1” indicates the action will occur and “0” means the action will not happen. An account can have several triggers, each can be designed to initiate a particular action. You can rename or delete a trigger by right clicking the trigger and choosing the appropriate contextual menu option. After ; and
- Execution - when to execute the trigger (either at the beginning or end of the time-step.
The resulting Action Configuration panel will change depending on what is chosen under Trigger Configuration.
Once triggers are configured, you can prioritise them
usingusing the Trigger Priority tab (Figure 5).
Figure
38. Annual accounting, Account type, Trigger
Add
Adding a usage limit
- Rightto an account type
Right click the account or account type and choose Add usage limit
, see Figure 1. The GUI is similar for that in Continuous Accounting (here). You can limit water usage for all accounts by absolute volume or per-unit-share for moving water year or movable time window. An account can have several usage limits, each can be designed to initiate a particular limit. Just like triggers, you can rename or delete usage limits.
Configuring an Account Type
When account, trigger and water usage limit are all set up, you can go back to account type to configure and see summary information of all added accounts.
Click Account Type on the left hand panel, and make sure the configuration tab is selected on the right (Figure 2), set debit type, priority, minimum and maximum balance, minimum and maximum volume. If they are non-debit accounts, you need to tick the box Enable non-debit accounts, and then the availability threshold and repayment threshold become editable.
For allocation calculation method, there are two options from the allocation calculation drop down menu (Figure 2). One is as a function, where you can determine an account type’s allocation. The other is by using an available resource allocation table (ARA table). This function may reference a wide range of variables available in the model, including allocations to other account types and resource assessment systems. If an ARA table is chosen (Figure 7), configuration options will display for you to set detailed information.
Figure 7 Configuring Allocation Calculation Model
There are five methods can be chosen form the drop-down menu of method to apply for this account type in ARA table (Figure 7):
Function You set the function at this level.
Monthly varying You can set the calculation method as either interpolate or threshold.
Percent (with Function) This is similar to percent (with linked volume), difference exists at the annual accounting level allocation page which is discussed somewhere.
Percent (with linked volume) The default option for method to apply for this account type in ARA table. You can set Announced Increment, Maximum Announced Percent and Shares. If Use Shares from Accounts is ticked, Shares will get value automatically from account shares which is set at the account (rather than the account type) level.
Volumetric. You will need to set the volume at the annual accounting level allocation page which is discussed somewhere.
Accounts summary at Account Type Level
Clicking on the Accounts tab beside configuration at the top of the right hand panel (Figure 7), will show all the accounts created under this Account type.
You can also add an account simply by click the Add Account button below the list, or delete an account by selecting the account that to be deleted and clicking the Delete Account button. The Unit Shares and Initial Balance values are transferred automatically from the account but can also be edited here (Figure 7b).
Figure 7b. Accounts Summary Tab
Add an Off-Allocation System
Off-Allocation Systems are assigned at the top Annual Accounting level. Right click annual accounting and choose add off-allocation system from the drop-down menu. An off-allocation system can be configured using the properties panel shown in Figure 13. Detailed information of off-allocation system can be found under Off-Allocation Node
Configuration of Annual Accounting and Summary of accounts, allocation and trigger Priority
After account type and triggers are set up, you can go back to annual accounting to
- configure annual accounting
- see summary information of all accounts added
- set the available resource vs allocation table
- set trigger priority.
Figure 7c. Annual Accounting Configuration
Configure Annual Accounting
Click Configuration on the top of right hand panel. For option parameters:
- Owner: Users can set owner from Edit » Ownership..., right click resource assessment form the left hand panel and choose Enable Ownership from the drop-down menu. Users can edit details of owner from the owners table. Once ownership system are set up, users can choose any owner from the drop-down menu beside Owner in Figure 7c.
- Debit Type: determines how water is deducted from all the accounts based on either order or use
- Start of Water Year: Day-month that the water year starts for the system.
- Usage to Date: represents how much of the water allocated has been ordered or used by water users in the water year to date. There are two options for usage to date - usage from function and usage from account host. When losses need to be considered, an expression may be required to account for this.
The storage window lists all the water storage in the project. Users can tick any storage type they want to run in this project.
The Inflow window lists all the inflow in the project. Users can also tick any inflow they want to run in this project. The recession factor of each inflow can be edited by a constant or a function manager.
Users can also set Other Resources and Commitments by click the line under the Name of these two windows and a constant value or a function will also be available for editing the resources or commitments that added.
Accounts Summary
Accounts can be managed at Annual Accounting or Account Type levels.
Allocation
Click Allocation beside accounts on the top of right hand panel, Available Resource Versus Allocation displays below (Figure ?). The appearance of Allocation depends on the choice of method to apply for this account type in ARA tablein configuration of Account Type, The ARA table will display as the variations below (Figure ?).
- If function was chose in Method to apply for this account type in ARA table before, the Resource in the table will calculate automatically based on the function that was set at the Account or Account Type level
- If Monthly Varying was chose in Method to apply for this account type in ARA table before, users need to set the date for resource calculations. The calculation method was already chosen at an Account Type level, either interpolate or thresholds. Click the number below the Account Type name, the monthly varying window will display as in Figure ??. Users can set resource of each monthly manually or by import or export data from the Import andExport button below. If interpolate is chosen for calculation method, the Resource of the first column will calculated automatically based on current and next month values. More details about interpolate can be found in SRG. Ifthreshold is chosen, Resource of the first column will get value automatically form current month.
- If Percent (with Function) was chose in Method to apply for this account type in ARA table before, “Function” below the account type is editable because functions of this method cannot be set at a lower level.
- If Percent (with linked volume) was chose in Method to apply for this account type in ARA table before, the account type has a unit of (%) and the account type column can be editable by typing number directly to the table. Then the Resource column will calculated automatically based on account shares times percentage.
- If Volumetric was chose in Method to apply for this account type in ARA table before, the account type has a unit of (ML) and the rural column can be editable by typing number directly to the table. Then the value in Resourcecolumn is equal to that in Account Type column.
Figure ? Allocation summary
Figure ?? Monthly Varying Allcoation Window
Trigger Priority
Click Trigger Priority on the top of right hand panel, the trigger priority page is shown as Figure ???. The triggers will be separated into two types based on “timestep begining” and “timestep End”. For each type or triggers, users can choose the trigger and move it up or down to set the priority for this trigger.
Figure ??? Trigger Priority screen
Triggers
Triggers are used to initiate or cancel certain actions for an account and various triggers can be added at different levels in annual accounting. They are similar to the triggers created at the Account Type level (as shown in Figure 8) and can be managed at the
- System level (right click Annual Accounting and choose Add trigger from the contextual menu) - this is shown in Figure 9; and
- Account level - once an account has been created, right click the account and choose Add trigger. This is shown in Figure 10.
Info | ||
---|---|---|
| ||
Note: The options available for the Action item is similar for all three levels. These are outlined in Table 6. |
Figure 9. Annual Accounting, Trigger
Figure 10. Annual Accounting, Account, Trigger
Table 6. Triggers in Annual accounting
'Action' item option | Description |
---|---|
Transfer | Transfers a specified proportion or volume of account balance or entitlement between different account types or accounts. |
Truncate accounts | Truncates the account balance or entitlement to a specified ratio or volume. |
Write off accounts | Resets the account balance to zero. |
Per Unit Share Allocation | Resets per unit share allocation to a specified volume. |
Assign balance | Assigns the account balance to a specified volume. |
Carry over | Carries over a specified ratio or volume of account balance or entitlement into the next water year. |
Transfer use | Transfers the water used, back to the destination. |
Adjustment | Resets the account balance, entitlement or carry over to a specified ratio or volume. |
Re-assessment | Available only at the system-level. Reassesses the available resources based on the specified time-step. Only existed in accounting system level. |