Registration of templates for financial statements (balance sheet, profit and loss statement, sales/management expenses report, cost report, and cashflows statement) by item

You can register templates for balance sheet, profit and loss statement, sales/management expenses report, cost report, cashflows statement, and the financial statement of [Valuation accounting module] by item.
For the cashflows statement and Advanced FS (Item) in [Valuation accounting module], the items to register are slightly different from other financial statements.
→To Operation Procedure

Screen Transition

[Financial Statements Module]
  ↓
[Register]
  ↓
[Register Templates (Balance Sheet, Profit and Loss Statement, Sales/Management Expenses Report, Cost Report, and Cashflows Statement)]
  ↓
[Register templates (balance sheet, profit and loss statement, sales/management expenses report, cost report, and cashflows statement)] screen
    "Print" button → [Print template] screen

or

[Valuation Accounting Module]
  ↓
[Financial statements by item]
  ↓
[Register template for financial statements by item]
  ↓
[Register template for financial statements by item] screen
    "Print" button → [Print template] screen

Item setup

[Header]

• Template code, Name 1, Name 2
  Enter the code and name of the form template you want to register, and click the "Refer" button at the bottom of the screen. To edit an existing template, enter the code of the target template, and click the "Refer" button.
• Item (only for financial statements by item)
• Default
  Displayed when a template code is entered. In the case of a new registration, select [Display all] or [Hide], and decide whether to automatically display a registered A/C in the spread portion.

[Spread]

Register a financial statement format of the template code specified at the [Header].

• No.
  Enter the row number to be used in "Formula."
• Summary A/C 1, Summary A/C 2, Summary A/C 3
  Manually enter the summary A/C name to be displayed upon output. When you need to output a financial statement in more than one language (e.g., when you want to output in Japanese, English and Chinese), enter item name in Japanese in A/C1, English in A/C2, and Chinese in A/C). Delete unnecessary rows.
  Since the rows in which a summary A/C is entered is regarded as a row to display summary results, A/C and sub A/C cannot be entered.
• A/C code, Name
  Select the A/C to be output in the row.
• Sub A/C code, Name
  When an A/C with a sub A/C is selected, select the sub A/C to be output in that row.
• Item code, Name (financial statements by item only)
  Enter the item code specified at the [Header] only in the rows you set "A/C" and "sub A/C". If you enter a code, the item name corresponding to the "Item code" will be displayed.
  For A/C for which the item you selected at the [Header] is registered as "Required" in [Register A/C property], item code and name must be entered in the row of such A/C.
  Items selected at the [Header] and item codes that can be entered are as described in the table below.

  Item (Header)	Item code
  Department	Choose from departments and summary departments. An asterisk (*) can be specified.
  Correspondent	Choose from correspondents and correspondent groups. Not restricted by transaction type. An asterisk (*) can be specified.
  D description	Choose a D description code. A memo cannot be entered. An asterisk (*) can be specified.
  Project code 1	Choose from Project Code 1 and Project Group Code 1. An asterisk (*) can be specified.
  Project code 2	Choose from Project Code 2 and Project Group Code 2. An asterisk (*) can be specified.
  Accenting Anlys code 1	Select Accounting analysis Code 1. Only existing accounting analysis codes can be selected. An asterisk (*) can be specified.
  Accenting Anlys code 2	Select Accounting analysis Code 2. Only existing accounting analysis codes can be selected. An asterisk (*) can be specified.

• Indent
  Specify the indent width for that row to output.
• ( - ) type
  Mark a check here on the rows which you want to highlight the plus and minus of the amount when outputting.
• Hide
  Mark a check on the rows which you want to hide when output.
• Ratio (excluding cashflows statement)
  You can only mark a check on any one row. A ratio of each row compared to the row with a check mark assuming the row represents 100% will be output.
• Opening/Closing inventory value (profit and loss statement, sales/management expenses report, and cost report only)
  When an "Opening/closing" is set in the [Register A/C and Sub A/C] in [Accounting master], the content will be displayed.
• Net profit (cashflows statement only, and financial statement by item only)
  You must mark a check on just one row of any summary A/C. "Net profit" (= Assets-Liabilities-Capital) will be summed up in the row marked with the check.
• Tax shield (cashflows statement only)
  Mark a check on the rows to which tax shield is set when outputting a free cashflow. The tax shield is used to recognize A/C and sub A/C that are expensed as non-cash payment expenses when computing the profit on cashflow basis. This is used to compute corporate taxes value saved.
  For A/C and sub A/C with the check box checked, the amount calculated by multiplying the total amount of A/C and sub A/C by the effective tax rate of that year ("Register analysis index for cashflow") is output based on [Discounted cashflows].
• FCF (cashflows statement only)
  Rows with the check box checked are considered to be free cashflows (FCF). A row considered to be FCF will be referred in [Discounted cashflows] and [EVA/ROE analysis sheet] in [Cashflow management module].
  You must mark a check on a specific row only. In addition, in the row with a check mark, the calculation method must be set for "Formula" field.
• Dr/Cr (only for cashflows statement, and financial statement by item)
  Choose one from the following summary methods:

  Summary method	Comment
  Opening balance	Opening balance
  Closing balance	Opening balance +Amount for the period from Opening to Closing date of the required period
  Dr side	Dr side for the period from Opening to Closing date of the required period
  Cr side	Cr side for the period from Opening to Closing date of the required period
  Fluctuation	In the case of Dr A/C: Dr side amount-Cr side amount In the case of Cr A/C: Cr side amount-Dr side amount

• Formula
  Enter a formula for the amount to be output in summary A/C row. For instance, when you wan to display ((an amount in a third row minus an amount in a fourth row plus an amount in a fifth row) times 2) as an amount in the second row, enter a formula such as "(3-4+5)*#2" in the second row. Rules on the formula are as follows:
• Symbols of the four basic operations of arithmetic calculation used are "+" (add), "-" (subtract), "*" (multiplication), and "/" (division).
  For additions with more than one rows, insert ":" (colon) between the beginning and ending rows of the addition so that you do not have to write "2+3+4+5".
• A portion parenthesized with "(" and ")"(parentheses) is calculated precedently to others. You can use more than one parentheses. When no parentheses are used, calculation is unconditionally started from the left side. For instance, if "2+3*4" is entered, 4 is multiplied after computing 2 + 3. Please note that the calculation method differs from ordinary rules for the four basic operations of arithmetic calculation.
• It is possible to directly enter figures in a formula (5 figures+6 figures after the decimal points). "#" is attached immediately before figures in order to distinguish the figures from a row number. Minus figures are also acceptable.
• In a formula entered, automatic checks are conducted whether the number of parentheses match, the symbol before "#" is the one for the four basic operations of arithmetic calculation, or a figure or symbol after "#" is negative, or not.

• Free code
  This item is entered when connecting with consolidation accounting software. 50 figures of en quad and ennage and symbols can be entered.
• Variable valuation, variable valuation (comment) (only for cashflows statement)
  Choose "No valuation", "+Valuation", or - Valuation" and enter comments.
• Budget/actual comparison, budget/actual comparison (comment) (only for cashflows statement)
  Choose "No valuation", "+Valuation", or - Valuation" and enter comments.

[Buttons]

• Name1/2
• Readjust No.
  When a row is added or deleted, the row number may not be sequential. In this case, if this button is clicked, the row number is rearranged in sequential number. However, if the rearrangement is done in the midst of an edition, a respective "Formula" of the summary item must be modified. Use this button only when a new template is registered otherwise specified.
• Copy
  Clicking this button copies financial statement templates.
• Clear
• Refer
• Save
• Delete
• Add row
• Del row
• Print
• Exit