Budget Analysis Report - Revision history

Nic at 04:52, 9 January 2018

2018-01-09T04:52:20Z

← Older revision		Revision as of 23:52, 8 January 2018
Line 12:		Line 12:
	* [[Account Number Field]]		* [[Account Number Field]]
	* [[Account Name Field]]		* [[Account Name Field]]
	* [[~~Version Name~~ Field]]		* [[Actual Amount Field]]
	* [[~~Tax Exclusive~~ Amount Field]]		* [[Budget Amount Field]]
			* [[Variance Amount Field]]
			* [[Variance Percentage Field]]

	It includes the following filters.		It includes the following filters.

Nic at 04:51, 9 January 2018

2018-01-09T04:51:48Z

← Older revision		Revision as of 23:51, 8 January 2018
Line 3:		Line 3:
	[[File:ExcelReportLinkGLPivotSolution_BudgetAnalysisReport.png\|300px\|thumb\|right\|Budget Analysis Report]]		[[File:ExcelReportLinkGLPivotSolution_BudgetAnalysisReport.png\|300px\|thumb\|right\|Budget Analysis Report]]

	This report compares your Actual and Budget profit and loss figures. This report lists your [[Account Classification Field\|account classifications]] and [[Account Number Field\|accounts]] down the page. It displays ~~the [[Month Field\|months]] and~~ [[Version Name Field\|versions]] across the page.		This report compares your Actual and Budget profit and loss figures. This report lists your [[Account Classification Field\|account classifications]] and [[Account Number Field\|accounts]] down the page. It displays [[Version Name Field\|versions]] across the page.


Line 12:		Line 12:
	* [[Account Number Field]]		* [[Account Number Field]]
	* [[Account Name Field]]		* [[Account Name Field]]
	* [[Month Field]]
	* [[Version Name Field]]		* [[Version Name Field]]
	* [[Tax Exclusive Amount Field]]		* [[Tax Exclusive Amount Field]]
Line 22:		Line 21:
	* [[Job Number Field]]		* [[Job Number Field]]
	* [[Financial Year Field]]		* [[Financial Year Field]]
			* [[Month Field]]

	== Customising the Report ==		== Customising the Report ==

Nic at 22:30, 2 April 2014

2014-04-02T22:30:36Z

← Older revision		Revision as of 17:30, 2 April 2014
Line 3:		Line 3:
	[[File:ExcelReportLinkGLPivotSolution_BudgetAnalysisReport.png\|300px\|thumb\|right\|Budget Analysis Report]]		[[File:ExcelReportLinkGLPivotSolution_BudgetAnalysisReport.png\|300px\|thumb\|right\|Budget Analysis Report]]

	This report compares your Actual and Budget profit and loss figures.		This report compares your Actual and Budget profit and loss figures. This report lists your [[Account Classification Field\|account classifications]] and [[Account Number Field\|accounts]] down the page. It displays the [[Month Field\|months]] and [[Version Name Field\|versions]] across the page.


	By default, the report is set to produce a consolidated profit and loss report by including all companies, cost centres, jobs and months. It is restricted to display your Actual numbers.		By default, the report is set to produce a consolidated profit and loss report by including all companies, cost centres, jobs and months. It is restricted to display your Actual numbers.

Nic at 21:44, 2 April 2014

2014-04-02T21:44:23Z

← Older revision		Revision as of 16:44, 2 April 2014
Line 1:		Line 1:
	== Overview ==		== Overview ==

	[[File:~~BudgetAnalysisReport~~.png\|300px\|thumb\|right\|Budget Analysis Report]]		[[File:ExcelReportLinkGLPivotSolution_BudgetAnalysisReport.png\|300px\|thumb\|right\|Budget Analysis Report]]

	This report compares your Actual and Budget profit and loss figures.		This report compares your Actual and Budget profit and loss figures.

Nic: Created page with "== Overview == Budget Analysis Report This report compares your Actual and Budget profit and loss figures. By default, t..."

2014-04-02T00:52:04Z

Created page with "== Overview == 300px|thumb|right|Budget Analysis Report This report compares your Actual and Budget profit and loss figures. By default, t..."

New page

== Overview ==

[[File:BudgetAnalysisReport.png|300px|thumb|right|Budget Analysis Report]]

This report compares your Actual and Budget profit and loss figures.

By default, the report is set to produce a consolidated profit and loss report by including all companies, cost centres, jobs and months. It is restricted to display your Actual numbers.

It displays the following columns across the page.
* [[Account Classification Field]]
* [[Account Number Field]]
* [[Account Name Field]]
* [[Month Field]]
* [[Version Name Field]]
* [[Tax Exclusive Amount Field]]

It includes the following filters.

* [[Company Name Field]]
* [[Cost Centre Name Field]]
* [[Job Number Field]]
* [[Financial Year Field]]

== Customising the Report ==

The report can be customised by editing each filter and selecting a value. As such, the report can produce figures for one or more companies, cost centres, jobs or financial years.

== Related Topics ==

* [[Profit and Loss GL Pivot Reports]]