Navigator > Setup > General Ledger > Financial Report Designer >
Wizard button > Bands tab > Contents field
The following fields are available in the Contents lookup of the GL Design Wizard Bands tab.
Note: FavSign used in variance calculations is set to -1 for Income, Expense and Capital accounts, and is set to +1 for Asset and Liability accounts.
Account |
|
Account Code |
The Account Number for the GL Account, formatted as 4.3 characters. These are setup in GL Account. |
Account Name |
The name of the GL Account, setup in GL Account. |
Friendly Code |
An alphanumeric code used to refer to the GL Account. These can be easier to recall than numeric codes. For example, you could use ADV for the Advertising account. |
External Code |
The Accountant's code for this account.
|
Branch Code |
The Branch Code. (Accredo Saturn Only)
|
Branch Name |
The Branch Name. (Accredo Saturn Only)
|
Dept Code |
The Department Code. (Accredo Saturn Only)
|
Dept Name |
The Department Name. (Accredo Saturn Only)
|
Actual > Period |
|
Period Balance Current Period |
The Balance of the Account at the end of the period. Calculated as the Period Opening Balance + Period Activity. |
Period Balance Current Period Percent |
The Period Balance Current Period as a percentage of the Account Code's Percentage Account total for the period. |
Period Opening Balance |
The Balance of the Account at the start of the period. |
Period Activity |
The sum of the activity for the Account for the period. |
Period Activity Percent |
The Period Activity as a percentage of the Percentage Account for the Account Code. |
Period Balance Variance |
The difference between the Period Balance for the Current Period and for the same period in the previous year. Calculated as (Period Balance Current Period - Period Balance Previous Year) * FavSign. |
Period Balance Variance Percent |
The Period Balance Variance as a percentage of the Period Balance Previous Year, calculated as (Period Balance Variance / Period Balance Previous Year) * 100 * FavSign. |
Actual > Year |
|
Year Balance |
The Account current balance for the year. |
Year Balance Percent |
The Year Balance as a percentage of the Account Code's Percentage Account year balance. |
Year Opening Balance |
The Account Opening Balance at the start of the year. |
Year Activity |
The Activity for the year. |
Year Activity Percent |
The Year Activity as a percentage of the Account Code's Percentage Account year activity. |
Year Balance Variance |
The difference between the Year Balance for the current year and for the previous year. Calculated as (Year Balance - Year Balance Previous Year) * FavSign. |
Year Balance Variance Percent |
The Year Balance Variance as a percentage of the Year Balance for the previous year. Calculated as (Year Balance Variance / Year Balance Previous Year) * 100 * FavSign. |
Full Year Balance |
The Account balance for the last financial period in the current year, i.e. excluding Adjustment period. |
Full Year Balance Percent |
The Full Year Balance as a percentage of the Account Code's Percentage Account full year balance. |
Full Year Balance incl Adjustment |
The Account balance for the last period in the current year including Adjustment period. |
Full Year Balance Percent incl Adjustment |
The Full Year Balance incl Adjustment as a percentage of the Account Code's Percentage Account full year balance incl adjustment. |
Actual > Last Year Period |
|
Last Year Period Balance |
The balance for the current Period in the previous year. |
Last Year Period Balance Percent |
The Last Year Period Balance as a percentage of the Percentage Account Last Year Period Balance. |
Last Year Period Activity |
The Activity for the current period in the previous year. |
Last Year Period Activity Percent |
The Last Year Period Activity as a percentage of the Percentage Account Last Year Period Activity. |
Actual > Last Year |
|
Last Year Balance |
The Year To Date Balance for the current Period in the previous year. |
Last Year Balance Percent |
The Last Year Balance as a percentage of the Percentage Account Last Year Balance. |
Last Year Activity |
The Activity for the previous year up to the current period in the previous year. |
Last Year Activity Percent |
The Last Year Activity as a percentage of the Percentage Account Last Year Activity. |
Last Year Full Year Balance |
The Activity for the full year for the previous year. |
Last Year Full Year Balance Percent |
The Last Year Full Year Balance as a percentage of the Percentage Account Last Year Full Year Balance. |
Actual > By Period |
|
Period Balance [X] |
The Period Balance for Period [X] of the current year. If your Financial Year starts in April, April will be Period 1, May will be Period 2 and so on. |
Period Balance [X] Percent |
The Period Balance [X] as a percentage of the Account Code's Percentage Account total for the period. |
Actual > Periods Ago |
|
Period Balance [X] Periods Ago |
The Period Balance for X number of periods prior to the current period. The Period Name will be displayed on the report. |
Period Balance [X] Periods Ago Percent |
The Period Balance [X] periods prior as a percentage of the Account Code's Percentage Account total for the period. |
Actual > Quarterly |
|
[X] Quarter Balance |
The balance for the [X] Quarter of the current year. |
[X] Quarter Balance Percent |
The [X] Quarter Balance as a percentage of the Account Percentage Account [X] Quarter Balance. |
Projected > Year |
|
Projected Year |
Calculated by adding the Period Balance for periods that have actual Figures, and Budget figures for periods that do not have actual figures, for the current Year excluding adjustment periods. |
Projected Year Percent |
The Projected Year as a percentage of the Account Code's Percentage Account total for the year. |
Projected Year Incl Adjustment |
Calculated by adding the Period Balance for periods that have actual Figures, and Budget figures for periods that do not have actual figures, for the current Year including adjustment periods. |
Projected Year Incl Adjustment Percent |
The Projected Year Incl Adjustment as a percentage of the Account Code's Percentage Account total for the year. |
Projected > By Period |
|
Period Projected [X] |
If Period [X] has actual figures, the Actual Period Balance for Period [X] is shown. If Period [X] does not have actual figures, the Budget for Period [X] is shown. |
Period Projected [X] Percent |
The Period [X] Projected as a percentage of the Account Code's Percentage Account total for the period. |
Budget > Period |
|
Period Budget Opening |
The budget opening for the current period. |
Budget Period |
The budget for the current period. |
Budget Period Percent |
The Budget Period as a percentage of the Percentage Account Budget Period. |
Period Budget Activity |
The sum of the activity for the Budget for the period. |
Period Budget Activity Percent |
The Budget Activity as a percentage of the Percentage Account for the Account Code. |
Budget > Year |
|
Year Budget |
The Budget for the year up to the current period. |
Year Budget Percent |
The Year Budget as a percentage of the Account Percentage Account Year To Date Budget. |
Full Year Budget |
The budget for the full year. |
Full Year Budget Percent |
The Full Year Budget as a percentage of the Account Percentage Account Full Year Budget. |
Unused Year Budget |
Calculated as the Total Year Budget - Balance Year To Date. |
Percent Year Budget Used |
Calculated as the Year to Date Balance as a percentage of Full Year Budget. |
Budget > Last Year Period |
|
Last Year Budget Period |
The Budget for the current Period in the previous year. |
Last Year Budget Period Percent |
The Last Year Budget Period as a percentage of the Percentage Account Last Year Budget Period. |
Budget > Last Year |
|
Last Year Budget |
The budget for the previous year, up to the current period in the previous year. |
Last Year Budget Percent |
The Last Year Budget as a percentage of the Percentage Account Last Year Budget. |
Total Last Year Budget |
The total budget for the previous year. |
Total Last Year Budget Percent |
The Total Last Year Budget as a percentage of the Percentage Account Total Last Year Budget. |
Budget > By Period |
|
Budget [X] |
The Period Balance for Period [X] of the current year. If your Financial Year starts in April, April will be Period 1, May will be Period 2 and so on. |
Budget > Periods Ahead |
|
Budget [X] Periods Ahead |
The Period Balance for [X] number or periods ahead. |
Budget > Periods Ago |
|
Period Budget [X] Periods Ago |
The Period Budget for [X] number or periods prior. |
Period Budget [X] Periods Ago Percent |
The Period Budget [X] periods prior as a percentage of the Account Code's Percentage Account total for the period. |
Budget > Quarterly |
|
[X] Quarter Budget |
The budget for the [X] Quarter of the current year. |
Budget Variance > Period |
|
Budget Variance Period |
The difference between the Budget and the Activity for the current period. Calculated as (Period Balance - Budget Period) * FavSign. |
Budget Variance Period Percent |
The Budget Variance Period as a percentage of the Budget Period. Calculated as (Budget Variance Period / Budget Period) * 100 * FavSign. |
Budget Variance > Year |
|
Year Budget Variance |
The difference between the Year to Date at the current period, and the Year Budget up to the current period. Calculated as (Year Balance - Year Budget) * FavSign. |
Year Budget Variance Percent |
The Year Budget Variance as a percentage of the Year Budget up to the current period. Calculated as (Year Budget Variance / Year Budget) * 100 * FavSign. |
Full Year Budget Variance |
The difference between the Year to Date for the Full Year, and the Year Budget for the Full Year. Calculated as (Full Year Balance - Full Year Budget) * FavSign. |
Full Year Budget Variance Percent |
The Full Year Budget Variance as a percentage of the Year Budget for the FUll Year. Calculated as (Full Year Budget Variance / Full Year Budget) * 100 * FavSign. |
Budget Variance > By Period |
|
Budget Variance [X] |
The difference between the Budget and the Activity for Period [X]. Calculated as (Period Balance [X] - Budget Period [X]) * FavSign. |
Budget Variance [X] Percent |
The Budget Variance Period as a percentage of the Budget Period. Calculated as (Budget Variance Period [X] / Budget Period [X]) * 100 * FavSign. |
Budget Variance > Periods Ago |
|
Budget Variance [X] Periods Ago |
The Budget Variance for [X] number or periods prior. |
Budget Variance [X] Periods Ago Percent |
The Budget Variance [X] periods prior as a percentage of the Account Code's Percentage Account total for the period. |
Budget Variance > Quarterly |
|
[X] Quarter Budget Variance |
The difference between the [X] Quarter Balance and the [X] Quarter Budget. Calculated as ([X] Quarter Balance - [X] Quarter Budget) * FavSign. |