Two variance columns will have to be created to show the difference between budget and expense, and another column to show difference between budget and revenue. On the filters tab of each column, you must filter for whichever accounts you want to use in that particular column (i.e., expense or revenue). One column will be filtered on expense while the other will be filtered on revenue accounts.
1. Click 'Reports' and select 'Financial Statements'
2. Double-Click 'Income statements' to create a new income statement
3. Click the 'Columns tab' and click 'New Column'
4. On General tab, select 'Original Budget' and chose the appropriate scenario
5. Click 'Ok'
6. On the Columns tab, select 'New Column'
7. Select 'Original Budget' and chose the appropriate scenario. Click the '-' symbol and then select {Actual}. Click 'Filters' and filter on the expense account code and click 'Ok'
8. Select 'New Column' and select 'Original Budget' and chose the appropriate scenario. Click the '-' symbol and then select {Actual}. Click 'Filters' and filter on the revenue account code and click 'Ok'
9. Run the 'Income Statement'