This is a block level report which will show received income against expenditures spent in the financial period.

It has 3 tabs. In the first tab they are grouped by Schedule and in the following two by Schedule and Category.



This report will include following items:

Income:

- Payment for revenue invoices

- Leaseholder's Payments on Account

- Leaseholder's Refunds

- Credit Ledger Items

- Freeholder's Payments


Expenditure:

- Payments for Supplier's invoices

- Supplier's Payment on Account

- Supplier's refunds

- Debit Ledger Items


Items not included:

- Leaseholder's Credit Notes

- leaseholder's Opening Balance

- Supplier's Credit Notes

- Supplier's Opening Balance


Tab 1: Summary


Column Headers:

  • Schedule - name of the schedule linked to the item
  • YTDIncome - Total of income items per schedule up to the current date (or up to the end of financial period whichever is earlier)
  • YTDExpenditures - Total of expenditure items per schedule up to the current date (or up to the end of financial period whichever is earlier)
  • YTDVariance - YTDIncome minus YTDExpenditures 
  • PeriodIncome - Income in that period. This should match YTDIncome. If it does not then there might be some future dated items
  • PeriodExpenditues - Expenditures in the period. This should match YTDExpenditures. If it does not then there might be some future dated items
  • PeriodVariance - PeriodIncome minus PeriodExpenditues 
  • PreviousPeriodIncome - Income in the Financial period prior to reported
  • PreviousPeriodExpenditure - Income in the Financial period prior to reported
  • PreviousPeriodVariance - PreviousPeriodIncome  minus PreviousPeriodExpenditure


Tab 2: Income


Column Headers:


  • Parent Category - Name of the category group
  • Nominal Code - Code assigned to a category
  • Category Name - Name of the category
  • Schedule - Schedule of the Income Items
  • YTDAmount - Total of all income items for the specific category and schedule up to date
  • Period Amount - Total of all income items for the specific category and schedule for the whole period.
  • Budget - Total budgeted per category and schedule. It will only be above zero for the mixed type categories (Revenue & Expense) included in the budget 
  • Previous Period Amount - Total of all income itesm for the specific category and schedule in the previous period
  • Previous Budget Amount - Total budgeted per category and schedule in the previous period. It will only be above zero for the mixed type categories (Revenue & Expense) included in the budget

Tab 3: Expenditures


Column Headers:


  • Parent Category - Name of the category group
  • Nominal Code - Code assigned to a category
  • Category Name - Name of the category
  • Schedule - Schedule of the Expenditure Items
  • YTDAmount - Total of all expenditure items for the specific category and schedule up to date
  • Period Amount - Total of all expenditure items for the specific category and schedule for the whole period.
  • Budget - Total budgeted per category and schedule.  
  • Previous Period Amount - Total of all expenditure items for the specific category and schedule in the previous period
  • Previous Budget Amount - Total budgeted per category and schedule in the previous period.