Previous Topic

Next Topic

Book Contents

Book Index

GL Design Wizard Band Contents Fields

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.