GAG Pooling - Income and expenditure

Use this tab to income and expenditure. This tab consists of four tabs:

NOTE: Changes that are made in this view are not applied to the multi-year budget until the Calculate GAG pooling box at the top of the view has been ticked (see image). The calculations start when you save the view and close it. If you do not do this, the allocation will be calculated overnight and the results will be visible the next day.

The Income and expenditure tab in the GAG pooling view consists of four tabs. To define an allocation, go through the tabs in the sequence in which they are displayed in the view. Below is an explanation of each tab.

Definition

On the first tab, you can add source keys and allocation keys by clicking on the Add key button at the bottom of the table. A new row displays for you to fill in as follows:

$stappen$

1. Enter the name of the key in the Key column by clicking on the row and then on the pencil.
2. In theType column, specify whether you are adding a source key or an allocation key. A source key enables you to specify the percentage you will be allocating from the different establishments. An allocation key enables you to specify the establishments to which the allocation will be applied.
3. Next, select a level. In this column, you can choose between Financial year or Academic year. The level you choose depends on how you’re allocating an amount. For example, you may choose to allocate amounts by academic year because the budget was adopted for the academic year.
   Or you may choose to allocate amounts by financial year because the grant is received for a financial year. Both options are possible.
4. If you added a source key, specify in the Input column whether the amount you are allocating is a percentage or an amount.
5. You can also use a report fact to allocate the amount. You can add a report fact yourself; see the examples and the tutorial at the bottom of the page. If you would like to do this, you can select a report fact in the Report fact column. You can choose, for example, between the total number of pupils, a GL account or a consolidation. Click on the black square to display the options.
6. If you selected a report fact, you must enter the relative period. The relative period indicates the reference period. If you would like to refer to the current year, enter 0; if you would like to refer to last year, enter -1; and if you would like to refer to next year or future years, enter 1, 2, 3 etc.
7. If you selected a report fact, you must also select a status. We always advise selecting Forecast, as it’s the most current status in Anago.
8. Finally, the key used for the report fact must be updated. Select the corresponding key in the Select column and click on Update selected keys.
9. If you would like the key for the report fact to be updated automatically every night, tick the box in the Update column.

$/stappen$

Below is an example of a defined source key and a defined allocation key. In this example, the allocation key uses a report fact:

Source keys

Once you have created your source and allocation keys, you can define them. Go to the Source keys tab. NOTE: If your source key is set to Academic year, change the Year filter to Academic year.

In this tab, you can specify the amount/percentage to be allocated by entering the desired amount/percentage in the Allocation amount row for the relevant establishments. This should look as displayed in the image below.

If a report fact was used, you can tick the establishments from which the amount should be allocated.

$note$

When the year changes, the source keys’ input/settings are automatically copied from the academic/financial year that was last displayed to the newly added academic/financial year.

$/note$

Allocation keys

Go to the Allocation keys tab. This is where you specify the establishments to which the allocation amount/percentage should be applied. NOTE: If your allocation key is set to financial year, change the Year filter to Academic year.

If you chose to enter a ratio manually, enter it in the Weighted row. Then tick the corresponding establishments in the Apply to row.

The Percentage row will populate automatically. The allocation is calculated based on the ratio you entered. If you entered ‘1’ in two establishments, each establishment will receive 50% of the amount. See the image below for an example of one establishment that was allocated the full amount:

If you are using a report fact, you can tick the corresponding establishments in the Apply to row. The mutual weighting is calculated and converted into a percentage based on the report fact you are using and the boxes you ticked.

$note$

When the year changes, the allocation keys’ input/settings are automatically copied from the academic/financial year that was last displayed to the newly added academic/financial year.

$/note$

GAG pooling

Finally, specify on the last tab the Ledgers from which the amount will be allocated and the Ledger that will be used to calculate the allocation. This is done in the Allocate tab

as follows:

$stappen$

1. Click on Add key to add a new key.
2. Give the key a name by clicking on the key in the Allocation key column and clicking on the pencil.
3. In the Source GL column, select a ledger from which the amount/percentage should be allocated.
4. In the Allocation GL column, select the ledger that is used to calculate the allocation. This can be the same ledger as the source ledger. If you select the same ledger as the source ledger, the end users, for example, will see the amount that is left over for their establishment. If you select a different ledger, the end users, for example, will see the amount that was allocated to the trust.
5. In the Source key column, select the source key you added.
6. In the Allocation key column, select the allocation key you added.

$/stappen$

TIP: If you do not want amounts to be manually added to the ledger that is used to calculate the allocation, untick the Input box in the Ledgers view. The ledger will not display in the Other income and expenditure view but will display in the multi-year budget.

$note$

NOTE: If you define an allocation with your own report fact, make sure you use a ‘.’ (full stop) and not a ‘,’ (comma) as the decimal separator in your report fact!

$/note$