VisionCore How To
Home Search Support Forum Knowledge Base Print

Reverse Sign for Expenses

Reverse sign for expenses checkbox on the Column Calculation form will reverse the sign of the total calculation of rows containing Expense accounts.

reverse1

 

Here are the rules that must be considered when using the reverse sign for expense option:

 

Rule 1: If all the accounts are Expenses, the following variance applies:

a)Spent more than the budget, the variance should show negative (unfavorable).

b)Spent less than the budget, the variable should show positive (favorable).

 

Rule 2: If all the accounts are Revenues, the following applies:

a)Earned more than the budget, the variance should show positive (favorable).

b)Earned less than the budget, the variance should show negative (unfavorable).

 

Rule 3: Mix of Revenues, Expenses, and/or other account types, the following applies:

a)Recorded less than the budget, the variance should show negative (unfavorable).

b)Recorded more than the budget, the variance should show positive (favorable).

 

Calculation for this report is Actual - Budget = Variance. Notice the amounts for the row where all accounts are expenses, the sign of the Variance amounts are being reversed.

 

reverse2