Available in Sage 50 Premium Accounting and higher.
The Account Variance report lists amount and percentage variances between budget and actual figures for General Ledger account(s) within a specified time frame.
Options
Select the Options button to determine the data criteria for the reports you want to see or print. For this report Sage 50 offers the following filter options:
- Budget: Select the budget to use for this report.
- Variance Calculation: The variance on the report can be calculated as actual minus budget, budget minus actual, or favorable/unfavorable. The favorable/unfavorable calculation depends on the account type.
Favorable/unfavorable
calculation
A favorable calculation is what you would expect or hope to see for that account type. You would want to see assets, equity, and income exceed your budget; therefore, the favorable calculation for these types is actual minus budget.
On the other hand, you would hope that you could hold liabilities and expenses under budget; therefore, the favorable calculation for them is budget minus actual.
- Include Accounts with Zero Amounts: If you want the report to show variance figures even for accounts with zero balances, select this check box .
Columns
Select the Columns link to choose which data fields to include and where the columns break on your report. Tell me more about choosing report fields.
Fonts
Select the Fonts link to set the font styles for the heading and body of the report. You can also have the titles of the report show special codes, such as the current period, today's date, an as-of date, and the company name. Tell me more about formatting reports.