The General Ledger Layout - Profit and Loss and Balance Sheet
GL Groups control the structure of the Profit & Loss and Balance Sheet layouts. Within each layout option, create GL Groups and add GL Accounts to these to manage reporting for the Profit and Loss, and Balance Sheet.
Create a new GL Group
In the Financials menu, click Layout on the toolbar and select either Profit and Loss or Balance Sheet from the Layout drop-down on the toolbar to open the new layout window.
Select +Add from the toolbar. A new box displays beside the ledger codes for creation of a new GL Group.
- Set the Title for the group. The Sub-total label defaults to the Title and can be overridden if required or removed if only a heading for the group is needed.
- Choose the Function Group. Profit and Loss offer Income or Expense while Balance Sheet offers a selection of Asset, Liability and Equity options.
- The Page-break before group option allows separation of groups to new pages on reports.
Moving and Grouping
The layout screens list GL Accounts and Groups.
Newly added Accounts and Groups are added to the bottom of the list ready to move into a Group. Use the Move icon to drag and drop accounts and groups into position.
Groups can be embedded within groups, for example have a series of Expenses groups nestled within a General Expenses group to create an overall General Expenses sub-total.
Edit a GL Group
To edit a GL Group select the GL Group within the Profit & Loss or Balance Sheet screen. The GL Group box re-opens, with the Group information displayed. Select Edit to activate the fields.
Make changes to the fields and Save to confirm.
Delete a GL Group
A GL Group can only be deleted if there are no GL accounts within the Group. After opening the GL Group, click on the spill buttons in the GL Group box and choose Delete from the menu.
The confirmation window displays. Delete to continue.
If there are GL Accounts within the Group a notification displays. Make the necessary changes before deleting.