Sign Control


Menu option Setup > Account Structure > Categories defines whether an account number is an asset, liability, income, expense, etc. Amounts are normally displayed as positive (user friendly) for the type of account, unless it is a reversal of the norm. 

For example, an income account has a credit balance (normally a negative sign), but it would display as positive (user friendly) on reports or when browsing account balances.  However, when browsing individual transactions, signs will show as they truly are (debit or credit transaction).

The only exception to this rule is if in a financial statement the General tab is set to “Show true sign”.

The “verbal way of saying” how signs are displayed for account variances is this:

  • Good variances show as positive.
  • Bad variances show as negative.
  • Over in assets to last year or budget is good.
  • Under in assets to last year or budget is bad.
  • Over in liabilities to last year or budget is bad.
  • Under in liabilities to last year or budget is good.
  • Over in equity to last year or budget is good.
  • Under in equity to last year or budget is bad.
  • Over in revenue to last year or budget is good.
  • Under in revenue to last year or budget is bad.
  • Over in expenses to last year or budget is bad.
  • Under in expense to last year or budget is good.
  • Better in surplus to last year or budget is good.


__________________________________________________________________________________________________________________

Signs on a Variance Column

Comparing Year Variances:

For asset, equity, and revenue accounts, as well as net gain loss, signs show a positive for an increase, negative for a decrease.

For liability and expense accounts, signs show a negative for an increase, positive for a decrease.

Account Type

This Yr

Last Yr

$ Var

% Var

Increase shows as

Decrease shows as

Asset

2,100

2,000

100

5

Positive

Negative

Liability

1,100

850

-250

-23

Negative

Positive

Equity

1,200

1,050

150

14

Positive

Negative

Revenue

6,700

6,000

700

12

Positive

Negative

Expense

5,000

4,800

-200

-4

Negative

Positive

Net Gain/Loss

15,650

15,150

500

3

Positive

Negative


Actual to Budget Variances for the same year:

For asset, equity, and revenue accounts, as well as net gain loss, signs show a positive when actual is over budget and negative when actual is under budget.

For liability and expense accounts, signs show a negative when actual are over budget, positive when actual is under budget.

Account Type

Actual

Budget

$ Var

% Var

Over budget shows as

Under budget shows as

Asset

2,100

2,000

100

5

Negative

Positive

Liability

1,100

850

-250

-23

Positive

Negative

Equity

1,200

1,050

150

14

Negative

Positive

Revenue

6,700

6,000

700

12

Negative

Positive

Expense

5,000

4,800

-200

-4

Positive

Negative

Net Gain/Loss

15,650

15,150

500

3

Negative

Positive


__________________________________________________________________________________________________________________

Financial Statements – Sign control on total rows

By default financial statements try to figure out the correct sign to display on a total row. If a row on the report contains only revenue or only expense then it shows as a positive number.

If a row is made up of both revenue and expense accounts then it shows as a net. Therefore, if you have a report that shows a department or branch summary total, but consists of only expense accounts and no revenue accounts included in that total, the total would then show as a positive. 

If you have this issue with the sign displaying wrong on a summary total, do the following:  Add any revenue account to that department or branch; it may be marked as inactive. As long as there are both revenue and expense accounts in whatever is being summarized (branch, department, etc.), the summary total will display correctly.