Corporate profit & loss layouts [in-depth guide]
Guide contents: Navigation | Columns setup | Example | Resources
This gives you control over what date ranges to display in the columns as well as comparing budgets to actuals and includes formulas for column-to-column calculations.
Navigation
Menu > Admin > System setup > GL settings > Corporate profit & loss layouts
Once you have at least one set made, then you can access this setup from the corporate P&L itself by pressing on Custom layouts. then the Setup button appears. Click this button to access the setup of these layouts.
Columns setup
Start a new layout or open an existing layout. Then click Insert row to add a new column. Each row you create is then displayed as a column in your report.
Column name
Here is the list of available fields and what they do to start off your column of data. You will need to type these exactly as you see here. You can also add some basic calculation in here such as "to", for example "@StartDate to @EndDate".
@StartDate = Start Date of the report
@EndDate = End Date of the report
@StartYear = Year of the Start Date
@EndYear = Year of the End Date
@StartMonthName = Month name of the Start Date
@EndMonthName = Month name of the End Date
Source
There are several preset choices, Actual, Budget and Calculation. Depending on which is used will then determine the use of the remaining fields.
Actual
Period
-
January - December. This is the specific month offset from the beginning of the fiscal year.
-
Base Month. This is the month specified when you run the report.
-
Year to Date. The date range is from the beginning of the fiscal year through the current date. You can put in a Month Ending Offset. If this is different than 0, it takes you to the last day of that month. So if you wanted YTD, but just through the last full month, you would use an ending date offset of -1.
Beginning and ending month offset
-
The month specified is used as a starting point. Then to create custom ranges of dates, you can use the beginning and ending offsets.
-
Examples:
-
If you wanted a column always to show last month, you would set the Period to the Base Month and the Beginning and Ending Month Offset would be -1.
-
If you wanted the last 3 months prior including the current month, your beginning offset would be -2 and your ending offset would be 0.
-
If you wanted the first quarter of the year, you would pick January as your source (assuming that was the beginning of your fiscal year) and the beginning offset would be 0 and your ending offset would be 2.
-
Year offset
-
The number of years to offset from the base year. If you wanted data from last year, you would enter a -1.
Calculation
-
NA
Budget
Period
-
January - December. This is the specific month offset from the beginning of the fiscal year.
-
Base Month. This is the month specified when you run the report
-
Year to Date. The date range is from the beginning of the fiscal year through the current date. You can put in a Month Ending Offset. If this is different than 0, it takes you to the last day of that month. So if you wanted YTD, but just through the last full month, you would use an ending date offset of -1.
Beginning and ending month offset.
-
The month specified is used as a starting point. Then to create custom ranges of dates, you can use the beginning and ending offsets.
-
Examples:
-
If you wanted a column to always show last month, you would set the Period to the Base Month and the Beginning and Ending Month Offset would be -1.
-
If you wanted the last 3 months prior including the current month, your beginning offset would be -2 and your ending offset would be 0
-
If you wanted the first quarter of the year, you would pick January as your source (assuming that was the beginning of your fiscal year) and the beginning offset would be 0 and your ending offset would be 2.
-
Year offset
-
NA
Calculation
-
NA
Calculation
Opens the Calculation field.
Calculation
-
You can specify a formula using the column numbers. The UI will display a number (display order) for each row, you can use that to enter the calculation such as:
-
[Col1] + [Col2] - [Col3]
-
If you reorder your columns you will need to update your calculations. You can use all of the same formulas you use in custom reports and listings.
-
If you are going to use division, then you need to add in protection against a divide by 0 error which will cause all the data in the column to show as 0.
-
If you are trying to divide column 1 by column 2 you would use the formula:
-
CASE When [Col2] = 0 then 0 else [Col1] / [Col2] end
Example
To make a column per month, you can simply add 12 columns, choose a month for each and name the column accordingly.
Resources
Corporate profit & loss report [in-depth guide]