Budget Income Statement Current Vs. Prior Custom Settings

Use Special YTD Format

The ‘Budget Income Statement Current Vs. Prior’ will print additional columns if you have the setting in place AND the ‘Use Special YTD Format’ option selected.

Section	Item	Value
GLReport	UseSpecialYTDFormat	Yes

Here is how the columns are being calculated:

Revenue
MTD VAR:	MTD Actual – MTD Budget
YTD VAR:	YTD Actual – YTD Budget
Prior YR YTD VAR:	YTD Actual – Prior YR YTD

Cost Section
MTD VAR:	MTD Budget – MTD Actual
YTD VAR:	YTD Budget – YTD Actual
Prior YR YTD VAR:	Prior YR YTD - YTD Actual

% Calculations: (this will be the same for revenue and cost)
MTD % = MTD Actual/MTD Actual Total Revenue
YTD% = YTD Actual/YTD Actual Total Revenue
Prior YR MTD% = Prior YR MTD/Prior YR MTD Total Revenue
Prior YR YTD% = Prior YR YTD/Prior YR YTD Total Revenue