Open topic with navigation

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:
   • To create a new layout, click New.
     • Enter a unique name for the layout.
   • To copy an existing layout, select the layout to copy and click Copy.
   • To import a layout, click Import.

     The CSV file is best seen when you export an existing layout. If you create a CSV file manually to import, you must ensure that you use the correct case in the CSV file or you will not be able to import the file. For example, SubTotal and not Subtotal.

     File identifiers

     One header line of identifiers is required in this order:

     • "Line", "Type","Category","Title","Heading Style",Subtotal Level","Debit\Credit","Left\Right","Base".

     The lines are the report lines you want to generate:

     • For Line, the entry is an ascending numeric, e.g. the first line is 1, the second 2 and so on.
     • For Type, the entry may be one of the following, however case and spacing should be as follows: "Text", "SingleAccountGroup", "SubTotal", "MultipleAccountGroup".
     • For Category, the entry is a report category code, e.g. 31.
     • For Heading Style, the entry may be a number from 1 to 9. The style is derived from the layout file in Report Designer.
     • For Subtotal Level, the entry may be a number from 1 to 9. This tells the system what account values to add together to print in a subtotal. For example, 3 will add up all accounts not already included in a subtotal level 3 or higher.
     • For Debit\Credit, the entry is Debit or Credit.
     • For Left\Right, the identifier is Left or Right.
     • For Base, the identifier is Yes or No.

     For more information about the report lines, see Select the Type of information to display on the line.

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:

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.

6. Click Close to return to the Financial Statement Layouts window.
7. 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.
8. Click Preview to view the layout.

This shows you how the report will look.

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

• Click Close to return to the Layouts list.
9. To delete a layout, select the Layout Name and click Delete.

Go to top