Summary P & L reports allow users to compare year-to-date profit and loss data with budgeted year-to-date profit and loss data. In addition, reports allow comparison of current year-to-date information with prior year-to-date information.
Reports are available for assigned profit centers.
Note: Keep the following things in mind regarding this report:
This report is generated offline. Normally the report will be generated once monthly after all posting is complete for the month. See the offline reports topic for more information.
The gross percent calculated in this reports matches the gross percent of the sales reports only when you do not use account types PR (Product Revenue) or PE (Product Expense) for cost of goods sold or sales accounts in the alternate category set up. This discrepancy occurs because the merchandise sales data on the sales reports excludes sales and cost of goods sold for alternate categories.
When you select Summary P & L reports, the system displays the report selection criteria screen. The criteria that you enter on this screen allows you to specify the information you want to compare on the report and the way the report is viewed.
Enter the period ending date. The report will print year-to-date information for the year through the period you specify. You must make an entry in this field and it must be in mm/dd/yy format. For example:
01/10/99
Note: You do not need to know the exact Period End Date. The system will find the actual End date for any date you enter.
You may specify how you want to view and/or print the report by choosing from the following selections:
· View Report Directly
· Condense Print
· Print Directly to LPN
· Display/Print Selection Page
Note: Summary P & L reports print in Landscape format.
The report lists the following information:
YTD Actual
YTD Budget
Variance Dollars
Prior Year Actual
Prior Year Variance $
Prior Year Variance %
Profit Center
The report columns are as follows:
Year-To-Date Actual
The Year-to-Date (YTD) Actual column displays current year-to-date data.
Year-To-Date Budget
The YTD Budget column displays the budgeted year-to-date data.
Variance Dollars
The Variance Dollars column displays the difference between the actual and budgeted data. The Variance Dollar value is calculated by using the following formula:
X – Y
X = the YTD Actual column value.
Y = the corresponding YTD Budget column value.
Variance Percent
The Variance Percent column displays the percent of difference between the actual and budgeted data.
(X – Y) / Y
X = the YTD Actual column value.
Y = the corresponding YTD Budget column value.
Prior Year Actual
The Prior Year Actual column displays year-to-date data for the prior year.
Prior Year Variance Dollars
The Prior Year Variance Dollars column displays the difference between the current YTD Actual dollar amount and the Prior Year Actual dollar amount.
X – Y
X = the YTD Actual column value.
Y = the corresponding Prior Year Actual column value.
Prior Year Variance Percent
The Prior Year Variance Percent column displays the percent of difference between the current and prior year data.
(X – Y) / Y
X = the YTD Actual column value.
Y = the corresponding Prior Year Actual column value.
The following sections are listed on the report:
Profit Center
Summary P & L reports print information for assigned profit centers.
You may notice a slight rounding difference between totals on detail and summary reports. Click here to see why.