I want to produce a budget variance report in QuickBooks which shows adverse variances as a negative number, as per the accounting convention.
It appears that the normal QuickBooks report shows all amounts in excess of the budgeted amount, even excess expenditure, as a positive number.
A normal budget report will show sales variances as Actual minus Budget so excess sales (i.e. good news) is a plus amount and expenditure variances as Budget minus actual because excess expenditure is bad news.
Is this possible in QuickBooks?