> Reports and documents / Designing financial statements / Balance sheet/profit and loss layouts

Maintain balance sheet/profit and loss layouts

To maintain a balance sheet/profit and loss layout

Open: Nominal Ledger >Utilities > Ledger Set Up > Financial Statement Layouts.

  1. Select the report type, Profit and Loss or Balance Sheet.
  2. To create a layout:
  3. To edit a layout, select the Layout Name and click Edit.
  4. A new line is automatically displayed. To add more lines, press the down arrow key or click in the space under the last line.
  5. Select the Type of information to display on the line:
  6. Text lines

    These lines contain text only, titles, subtitles or notes that you want to include. A text line could even be a blank line or a line of dashes, used to split the report into sections.

    Add Text lines where required by specifying:

    • Title.
    • Heading style (1-9).
    • Note: The heading style is derived from the layout file in Report Designer. If you need to establish the format for each heading, use the Report Designer. For more information, see the Sage Report Designer help.

    Account Groups

    Used to define a group of accounts that you want to print on the report in one section usually with a group title and possibly with a subtotal. Add Account Groups where required by specifying:

    • If you want to display a Single Account Group or Multiple Account Groups.
    • The Category code from a list.
      • If you are displaying a Single Account Group, click on the box and select the code from the list.
      • If you want to display Multiple Account Groups, click on the box to display a list of available codes, then select the codes that you want to display.
    • Title.
    • If the account balance is normally a Debit\Credit.
    • If the value is to be printed in the Left\Right column.

    Sub Totals

    Sub Totals are normally used with each account grouping to show the sub-total for that group. They can also be used to show the subtotal for many groups together. Add Sub Totals where required, by specifying:

    • The Title.
    • The Sub Total Level, 1-9.
    • This tells the system what account values to add together to print in a subtotal.

      • Level 1 adds up all the accounts already processed that have not yet been included in another subtotal of any level.
      • Level 2 adds up all the accounts already processed, not already included in a subtotal level 2 or higher. It will include any that have been rolled up into a subtotal level 1, but not any higher level.
      • Level 3 will add up all accounts not already included in a subtotal level 3 or higher.
    • If the subtotal is normally a Debit\Credit.
    • The value is to be printed in the Left\Right column.
    • If the Base total is displayed as a percentage.

    Current period profit

    Display Current period profit for Balance Sheet layouts only.

  7. Click Close to return to the Financial Statement Layouts window.
  8. Click Validate to check the category codes and nominal accounts used in the layout. If errors occur, messages will be displayed advising what the problem is. Click Close to return to the Layouts list.
  9. Click Preview to view the layout.
  10. This shows you how the report will look.

    Note: To print the report, choose the relevant option under Reports > Financial Statements.

  11. To delete a layout, select the Layout Name and click Delete.

Go to top