Docs  /  NCB Balance  /  Setup

Edit Balance Schedule

2023/04/24 • 6 min. to read

In this topic

• Fields
• Actions
• See also

The lines of the balance schedule are set up in the NCB Balance Schedule page. To do this, select the balance schedule that you want to edit in the Name field. For more information, see Setup, Balance Schedules. A balance schedule consists of the 3 areas Assets, Liabilities and Income Statement. The Area field determines which area is to be displayed or which lines are to be edited.

Fields

Row No.	Specifies a row number which can be used in other lines in a Formula (field Totaling Type). You can also assign a row number more than once. This allows you, for example, to add together several classifications located in different positions in one formula. Tip Use letters in row numbers (e.g. A0003, R4711, etc.) to clearly distinguish between rubric numbers and values in formula.
Description	Specifies a description for the line.
Numbering	Specifies the numbering type. For example, the first time you select A-B-C (Upper), that line is marked with A, the next one with B, and so on. The other options work in exactly the same way.
No Numbering	Specifies that no numbering should be done for this line.
Totaling Type	Determines which type of calculation should be performed for the line. Options: Classification Select a Classification. G/L Account Select one or more G/L Accounts from the Chart of Accounts in Financial Accounting. All Income Accounts All G/L Accounts that are marked as Income Statement in the Income/Balance field are calculated in total. This option is needed for the current period result (Liabilities). Formula This option allows you to perform calculations with the row numbers. End-Total This option calculates up to this line the cumulative value of all previous lines with Totaling Type Classification or G/L Account. Begin-End-Total At the first occurrence of Begin-End-Total, the sum of all previous lines is calculated. The next occurrence of Begin-End-Total calculates the sum of the values since the last Begin-End-Total line, and so on. Only lines with the Totaling Type Classification or G/L Account are considered. Classification-Total Here you can add up different classifications. In contrast to the Classification option, no G/L Accounts are listed and the calculated total is not included again in the overall result. Note Lines with Totaling Type Formula, End-Total, Begin-End-Total, and Classification-Total have no effect on the total Assets/Liabilities.
Totaling	Depending on the Totaling Type field, select the valid values here.
Thereof Line	Specifies whether this is a Thereof Line whose value is not automatically included in the total lines. The display is automatically indented by a further level. Lines with Totaling Type Classification and G/L Account can be defined as a Thereof Line.
No Total View	Specifies whether the automatic display as a total line (right-justified with separator lines) should be suppressed. This selection affects the Formula, End-Total, Begin-End-Total, and Classification-Total Totaling Types.
Hide	Specifies which information of this line should be hidden. Options: Empty (default setting) The line will be printed only if the value is <> 0. Detailed G/L Account Lines The G/L Accounts of this line are hidden or not printed. Line Incl. Detailed G/L Account Lines All G/L Accounts and the line itself are hidden or not printed. Never The line is always displayed. For Totaling Type Classification or G/L Account, the final result line of the totaling is also always displayed, even if there are no detailed G/L Account lines and the amount is therefore 0.
No Assets/Liabilities Switch	Indicates whether no asset/liability switch should be made. By default, an account defined in Assets is displayed only if it has a positive balance. In the liabilities, only those with a negative balance are displayed. If you activate this field, the line will be displayed where it is defined, regardless of the balance. (e.g. negative balances of depreciation accounts if you use indirect depreciation for assets). Note that the negative or positive balance definition always refers to the actual balance in Financial Accounting. The Show Opposite Sign field has no effect on this function. The setting in this field affects the Classification, G/L Account and Classification-Total Totaling Types.
Row No. Assets/Liabilities Switch	Specifies whether the asset/liability switch should be made based on another line. In this case, specify the Row No. of the line that should control the switch of the current line. Only lines located before the current line can be accessed.
Show Opposite Sign	Specifies whether the sign of the result in this line should be reversed. The setting is ignored for Totaling Type Formula.
Income Base	Specifies whether the selected line should be used as the basis for the income statement. This field is used as a reference point (100% basis) in the income statement. All other lines are calculated in relation to this as a percentage. For example, you can specify the line Operating performance as the basis. A multiple selection is possible - the sum of the lines for which the income base is set forms the calculation basis.
Income Balance at Date	Indicates whether the Balance at Date and not the Net Change should be used in the selected line. Thus, not only profit and loss accounts but also balance sheet accounts can be evaluated in the income statement.
Orientation	Specifies the orientation for the line.
New Page	Specifies whether a page break should occur before the current line.
Bold	Specifies whether to print the line in bold or not. With Automatic, only automatically generated total lines are printed in bold. The setting does not affect the Detailed G/L Account Lines.
Italic	Specifies whether to print the line in italics.
Underline	Specifies whether to underline the line when printing.

Actions

• Show Preview

  Opens the balance in a preview window. For more information, see Reports and Analysis, Balance Preview.

• Print

  Prepare to print the balance. A report request window opens where you can specify what to include on the print-out. For more information, see Reports and Analysis, Balance Preview.

• Print incl. Difference

  Prepare to print the balance incl. difference. A report request window opens where you can specify what to include on the print-out. For more information, see Reports and Analysis, Balance Preview.

• Not incl. Accounts

  Displays a list of all G/L Accounts that are not yet included in the current schedule.

• Copy from

  Copies the settings from another schedule and adds it to the current schedule.

See also

• Setup, Balance Schedules
• Reports and Analysis, Balance Preview