Difference between revisions of "Profit and Loss GL Pivot Reports"

From ExcelReportLink Wiki
Jump to navigation Jump to search
 
Line 16: Line 16:


This report displays your profit and loss figures for each financial year. For more information on customising this report, see [[Yearly Profit and Loss Report]].
This report displays your profit and loss figures for each financial year. For more information on customising this report, see [[Yearly Profit and Loss Report]].
=== Budget Analysis ===
This report displays your profit and loss figures compared to your budget for each month for a given financial year. For more information on customising this report, see [[Budget Analysis Report]].


=== Data Source ===
=== Data Source ===

Latest revision as of 01:12, 28 September 2017

Overview

The Profit and Loss GL Pivot Reports workbooks provides the following standard reports.

Standard Reports

MTD Profit and Loss Report

This report displays your profit and loss figures for each month for a given financial year. For more information on customising this report, see MTD Profit and Loss Report.

YTD Profit and Loss Report

This report displays your profit and loss figures for each month for a given financial year as a year-to-date rolling total. For more information on customising this report, see YTD Profit and Loss Report.

Yearly Profit and Loss Report

This report displays your profit and loss figures for each financial year. For more information on customising this report, see Yearly Profit and Loss Report.

Data Source

The data source worksheet is a standard Excel Query Table which allows you to configure, restrict or add additional calculations to your pivot reports. For more information, see ExcelReportLink GL Pivot Solution Data Source.


Related Topics