12 Month P & L Statement Tab

eFinancials—Reports—GL Reports—P & L 12 Month or
ePO—Reports—P & L 12 Month

Use this tab to print a general ledger 12 month profit and loss statement. The report displays a 12 month profit and loss statement for the selected period with or without unapproved transactions.

This report is available as a Standard Report or an Alternate Report.

How the report prints is based on your selections (first set of selections is the default).

Note

These examples do not describe the impact of the Include Unapproved Transactions check box. Refer to Default value for "Include unapproved transactions" on the global policies Other Tab for this information.

Rolling 12 Month Analysis—unchecked

Displays a 12 month Profit and Loss statement for the selected period.

The Last Column Value options are not available when Rolling 12 Month Analysis (Uncheck for Fiscal Year Analysis) is unchecked.

Rolling 12 Month Analysis—checked

Last Column Value—Total

The report prints for the Fiscal Year selected. The last column, Period End, Total, shows the value of all the columns added together.

Example:

If period 08/2011 is selected, the report prints 01/2011—12/2011, activity only in 01/2011-08/2011, and the last column is a total of all the columns printed.

Rolling 12 Month Analysis—checked

Last Column Value—YTD Total

The last column of the report is Period End, Year To Date, which shows a total of the YTD months but does not include months that list on the report for the previous year. So, twelve months back from the period/fiscal year selected prints first on the report and then the last column in the report shows a total of only the YTD months.

Example:

If period 08/2011 is selected, the report prints 09/2010—08/2011 and the last column is YTD for 08/2011.

Rolling 12 Month Analysis—checked

Last Column Value—Prior Year Total

The report includes the period one year prior to the selected period, plus the selected period amount, and the amounts for each of the eleven periods prior to the selected period. The last column in the report, Period End, is the actual amount for the period for the prior year.

Example:

If period 08/2011 is selected, the report prints 09/2010—08/2011 and the last column is 08/2010.

Note

Before generating this report, you must have set up report formats.

From the eFinancials menu, select Reports—GL Reports—P & L 12 Month. Or, from the ePO menu, select Reports—P & L 12 Month.
Click Select EntitiesCompanies. Select the entitiescompanies for which you want to print the report and click Save.
From the Fiscal Year field, type the year for the report (for example, 2011).
From the Period field, type the period for the report (for example, 8).
From the Report Format drop-down list, select a format.
To include unapproved transactions on the report, select the Include Unapproved Transactions check box.
To print an analysis for the past 12 months, leave the Rolling 12 Month Analysis check box selected. Or, clear the check box if you want the report to provide a fiscal year analysis.
If Rolling 12 Month Analysis is checked, new options appear. Select Total, YTD Total, or Prior Year options based on how you want the report to print. Refer to Report Description, above, for details on how this check box affects the report output.
Select the type of report you want to print: Standard Report or Alternate Report (refer to report description).
Select one of the following report printing options:

PDF Format: Print the report in PDF format for use in a PDF viewer, such as Acrobat.

Create Spreadsheet: Prints the report in an Excel spreadsheet.

Click Print. If you selected Create Spreadsheet, you are prompted to open or save the report Excel file. Otherwise, the report opens in PDF format.

GL: P & L 12 Month