Analysis Reporting

Analysis reports provide information on part of the business rather than the whole. They can be run on a Profit and Loss basis or by Cash Flow.

To run an Analysis report from the main menu select Reporting > Analysis Reporting.

Criteria

Firstly select which Analysis codes you wish to report on using the filter button:

Tick one or more analysis codes in the left hand column or simply click on Select All. Click on Confirm to take you back to the criteria screen.

Report type

Select either Profit and Loss or Cash Flow.  

The report criteria defaults the From date as the start of the financial year and the To Date as today's date but these dates may be changed as required.

If the dates or the report period are changed then you need to click on the refresh button to update the report.

Report Period

Annual - This report produces one column of figures showing the total for the chosen date range.

Quarterly - The Quarterly layout will include the total of up to 3 months of values in each column.

If the From date is not an exact quarter date then the first column may not be a full quarter as it will start at the From date. 

If the date range does not end on an exact quarter date then the final column may not be a full quarter as it will only include figures up to the To date.

Monthly -  The monthly totals for each code plus a total column on the right-hand side.

Compare To

Gives the option to compare the actual figures to a selected budget.This will not show Draft budgets.

Include Unassigned

If this is switched on then all transactions will be included even if they do not have an analysis code. 

Break page by Analysis

When this is switched on the report will start a new page for each analysis code. 

Drilldown

You can drilldown on any of the values to view the nominal transactions which make up that total.

The cursor will change to a small hand when you hover over the correct place:

From the nominal transaction report you can further drilldown on the transaction number to the original entry. If you edit and save the transaction you will need to refresh the reports to see the new values. 

Export to PDF

Use this to export the report to pdf which can then be downloaded or printed: