How are the totals calculated on the Income & Expenditure Summary Report?

The Income and Expenditure Summary (by Fund) report provides an overview of actual totals and projections, compared with and calculated against the corresponding planned budget.

At the top of this report, you can set the 'display to' date. No transactions after this date will be included in this report. The projected totals in this report also use this date to calculate from.

Here is an example (the display to date is set as 31st October 2018)

Monthly Totals - this is the sum of all the transactions in each month. In the example, the total for September 2018 is £2. If the 'display to date' was set as 10th September, the September total would display the sum of the transactions between 1st-10th September.

Actual Income/Expenditure - this is the sum of all transactions between the start of the financial year (up to and including the 'display to date'). In the example above, the total for the financial year to date is £1,130.60.

Anticipated Income/Expenditure - this is based on the budget projection per month for the category (up to and including the 'display to date'). To view the budget projection for a category, go to the 'category settings' screen (see below). In the example, the sum of the budget projection for each month up until the display date of 31st October 2018 is £1,083.30.

Variance - this is the difference between the 'Actual Income/Expenditure' and the 'Anticipated Income/Expenditure, expressed as a percentage. In the example, this is [(£1,130.60 - 1,083.30) / 1,083.30] * 100 = 4%.

Total Budget - this displays the budget total (which has been set in the 'category settings' screen). In the example, this is £1,300.

Budget Spend/Received - this displays how much of the total annual budget amount has been spent, expressed as a percentage. In the example, this is (£1,130.60 / £1,300) * 100 = 87%.

Projected Total - this uses the variance between the actual total to date and the anticipated total and uses this to forward project a total budget spend. In the example, this is (£1,130.60 / £1,083.30) * £1,300 = 1,356.76. This works for categories with both linear or non-linear budgets. Where the anticipated total is zero, the projected total calculates as 'Actual Total' + 'Total Budget'.