The P&L - Layout Format Report allows the User to edit the layout of the P&L directly from this report by drilling into the GL Types and GL Accounts. A User can then review this format to ensure it is providing the most beneficial layout for his/her Organization.
The following areas can be edited through the Profit and Loss - Layout Format report:
To navigate to the Profit and Loss - Layout Format Report, click 'My Reports' in the Accounting Module and select 'Financial' in the top header. Once opened, a listing of reports will be shown.
Find 'Profit and Loss - Layout Format', as displayed in the image above. Because there are no Report Parameters, a User can either click 'Run' or 'Customize' and then 'Run' in the next window to create your report.
Different aspects of the P&L, such as the Running Totals, Percentage Of settings, and GL Account Remapping, can always be readjusted to better display your Organization's data.
To add a Running total, click the last GL Account that you want included for the Running Total to open its GL Account record.
When the GL Account record opens, navigate to the 'Report Settings' tab and check the 'Show Running Total' checkbox. Additional fields will appear where you will fill out the necessary information. In the example above, all GL Accounts mapped as child accounts of 4110 Food Sales were used to calculate the Running Total. For more information on these fields, click here to view their descriptions.
Creating a Running Total helps to keep your P&L categorized by different kinds of Sales through parent-child GL Accounts.
Percentage Of Settings
Adjusting the 'Percent Of' Settings can determine whether the '% Based On' column will display no percentage, percentage of the GL Type, or percentage of the GL Account. Click here to view descriptions of these options.
GL Account Remapping
Remap GL Accounts that were connected with the wrong GL Type or that should be connected to a different GL Type by clicking the GL Account within the report.
When the GL Account record opens, update the 'GL Type' field and save the record. Run the report once more to see the updates applied.
1) GL Accounts and Account Types - A listing of all GL Acccounts and GL Account Types broken down by Parent Account. The 'Guest Check Average' and the 'Guest Count' are included on this report when the 'Metrics' parameter is set to 'Show'
2) % Based On - The percentage of the Income or Expense based on the listed GL Account
3) Visibility - Either visible or hidden on the P&L Report
4) Ops Rpt Category - The Operational Reports Category listed for that GL Account
5) Sort Order - The Account Numbers tied to the GL Accounts