<< Click to Display Table of Contents >>

Favorable Variance Reporting

To access the Reverse sign for expenses checkbox, you can either go to Column Designer right away under Financial Report Designer of Report Module…

 

FavVariance_01

 

Or from Financial Report Builder of Financial Report Designer from the Report Module.

 

FavVariance_02

 

If you will select Financial Report Builder, this form below will open first. Click the highlighted ellipse button to open the Column Designer form.

 

FavVariance_03

 

Click Column Type drop down button then select ColumnCalculation from the list.

 

FavVariance_04

 

Next, click Formula ellipse button to open the Column Calculation form.

 

FavVariance_05

 

In this form, you can find this Enhancement, Reverse sign for expenses checkbox. Click the checkbox to enable it. Then construct a formula. You can either manually create a formula like what it is being shown below or use Advanced Calculations button to make a calculation.

 

Info Note: When Reverse sign for expenses checkbox is enabled, the system will reverse the sign of the resulting calculation for any rows containing Expense accounts. Asset, Liability, Equity, or Revenue accounts will not be affected by this option.

 

FavVariance_06

 

To open Row Designer form, you can either select Row Designer under Financial Report Designer of Report Module

 

FavVariance_07

 

Or from Financial Report Builder under Financial Report Designer of Report Module.

 

FavVariance_08

 

If you will select Financial Report Builder, this form below will open first. Click the highlighted ellipse button to open the Row Designer form.

 

FavVariance_09

 

Click Accounts Used ellipse button to open the Filter Accounts form. When the said form opens, click the Edit Filter button.

 

FavVariance_10

 

After you click the Edit Filter button, click Account Group, then select Account Type from the list.

 

FavVariance_11

 

Next, click the next row drop down button, choose Expense as shown below.

 

FavVariance_12

 

From the sample below, there are 4 Accounts which contain Expense.

 

FavVariance_13

 

 

Click Generate button to open the Report Preview.

 

FavVariance_15

 

This is now the Preview of the Report.

 

FavVariance_14