In addition to the Budget vs actual report type in the Ledger analyser, you may print the Budget vs Actual (realisation - 3 periods) report.

The Budget vs Actual (realisation - 3 periods) report, lists the Income and Expense account balances and budget figures for three (3) periods as comparative figures. 

Only the transactions in documents and batches which are posted (updated) to the ledger will be included in this report.

Options to print lists of budget figures

The "Budget" option, if selected, will list only the budget figures (Budget listing) in the Trial balance, Income statement, Balance sheet and Standard column balances report types (if budget figures were entered in the Accounts on the Action ribbon). 

If you have activated Cost centres and have entered the budget figures for Cost centres, you may select (tick) the Cost centres to print this report for your Cost centres. 

Report options

To print a Budget vs actual report: 

1.On the Reports ribbon, select Reports → Ledger → Budget.  

budget-vs-actual-3-periods-options

2.Select the following options: 

a)Period - Select up to three (3) periods on the Per period tabs. You may click on the Free selection tab to select a specific date or a range of dates to include balances and budget figures in the report. 

b)Include zero balances - If this option is not selected (not ticked), it will list only the expense and income accounts which has balances and / or budget figures. Tick this option to include all accounts including those with no actual transactions and / or budget figures).

c)Balances - If this option is not selected (not ticked), it will list the expense and income accounts which has balances and / or budget figures. Tick this option to show only the actual transactions totals and / or budget totals of expense and income accounts for the selected period or dates.

d)Cost centre 1 - Cost centre 1 will be listed if you have activated Cost centres and created Cost Group 1 (Groups on the Setup ribbon). You may select any of these Cost centres, to include in the report. 

e)Cost centre 2 - Cost centre 2 will be listed if you have activated Cost centres and created Cost Group 2 (Groups on the Setup ribbon). You may select any of these Cost centres, to include in the report. 

3.Click on the OK button. 

Printed example : Budget vs actual (realisation - 3 periods) report

An example of the "Budget vs actual (realisation - 3 periods)" report, is as follows:

budget-vs-actual-3-periods-printed

The details is as follows: 

1.Header section - Report name and Periods as selected on the Periods in the Report parameters.

2.Expenses - A list of the accounts (created as Income and Expense account type and linked to the Expenses Group / Financial category). If the "Include zero balances" field is selected (ticked), all expense accounts will be listed (including those accounts with no actual transactions and or budget figures. If the "Balances" field is selected (ticked), only the Total - *Expenses will be displayed.

3.Income - A list of the accounts (created as Income and Expense account type and linked to the Income Group / Financial category). If the "Include zero balances" field is selected (ticked), all income accounts will be listed (including those accounts with no actual transactions and or budget figures). If the "Balances" field is selected (ticked), only the Total - *Income will be displayed.

4.Totals -

a)Net Profit / Net Loss: Actual - This is the total of the Expenses minus the Income totals for posted batches and documents. A negative figure indicates a Net Profit and a positive figure displays a Net Loss for the selected periods (dates). 

b)Net Profit / Net Loss: Budget - This is the total of the Expenses minus the Income totals for the budget figures as entered / edited in Accounts (Action ribbon). A negative figure indicates a Net Profit and a positive figure displays a Net Loss for the selected periods (dates).

c)Net Profit / Net Loss: Actual - Budget - This is the total of the Net Profit / Net Loss: Actual minus the Net Profit / Net Loss: Budget totals. A negative figure indicates that the posted batches and documents exceeds (overspend) the budget figures for the selected periods (dates). A positive figure indicates that the posted batches and documents is less than the budget figures (available) for the selected periods (dates).