Register budget of the balance sheet budget (Profit and loss statement/Sales/Management expenses report/Cost report/Cashflow/Financial statements by item)

Register by item the budget of the balance sheet, the profit and loss statement, the sales and management expenses report, the cost report, cashflow and the financial statements. All procedures are the same. The procedure for registering the budget is explained using the balance sheet as an example.
In the Entry area, specify the template to be used, the budget registration period, the item and the currency. The Entry spreadsheet displays the allocation status of the budget.
On the left half of the spreadsheet in the lower part of the screen, the content registered for the template of the financial statements that are specified in the Entry area is displayed. Enter the budget using the right half of the spreadsheet.
→To Operation Procedure

Screen Transition

[The Planning Control Module]
  ↓
[Register Accounting Budget]
  ↓
[Register Balance Sheet Budget]
[Register Profit and Loss Statement Budget]
[Register Sales/Management Expenses Report Budget]
[Register Cost Report Budget]
[Register Cashflow Budget]
[Register Budget for Financial Statements by Item]
  ↓
[Register balance sheet budget] screen
[Register profit and loss statement budget] screen
[Register sales/management expenses report budget] screen
[Register cost report budget] screen
[Register cashflow budget] screen
    "Refer" button → [Create cash flow budget] screen
[Register budget for financial statements by item] screen

Item setup

[Entry]

• Template Code
  Specify the templates of each financial statement registered in the [Financial statements module].
• Period (from/to)
  Set the registration unit of the budget. Select from [Term], [Quarter], [Half-yearly] and [Year].
• Accounting Year
  Specify the accounting year for which a budget is entered. It is possible to designate an accounting year as a period only when [Year] is selected in "Period (from/to)". It is possible to specify an accounting year that is not registered in [Accounting year setup].
• Budget Code
  Enter the code assigned to the budget. Where a new code is given, it is necessary to enter the code manually.
  When referencing a registered budget, it is possible to enter the code from the pop-up menu. However, the budget code displayed differs as follows depending on the value selected in "Period (from/to)".
  

  Period (from/to)	Values Displayed in the Pop-Up Screen
  Term	Only budget codes that are registered for the term budget
  Quarter	Only the budget codes that are registered for the quarterly budget
  Half-yearly	Only the budget codes that are registered for the half-yearly budget
  Year	Only the budget codes that are registered for the year budget

  
  If a budget is registered for all of the periods in "Period (from/to)" using the same template, if the same budget code is assigned, the annual budget and the total budget for each period is compared automatically. If the numbers are found to be inconsistent, a message is displayed when they are saved.
  If the [EVA/ROE analysis sheet] is output by the [Cashflow management module], it is necessary to assign the same budget code to the annual budget in the balance sheet and the annual budget in the profit and loss statement. It is also necessary to register the budget.
  
  Note: The pop-up menu only displays codes that have been already registered with the same "Period (from/to)". Therefore, even if the same budget code is assigned to budgets for all the periods in the "Period (from/to)", it is impossible to assign the same budget code unless the operator memorizes the budget code assigned for other periods and enters the code manually.
• Item
  Select from [None], [Department], [Correspondent], [Project code 1], [Project code 2], [Accounting analysis code 1], [Accounting analysis code 2] and [D Description code]. The default display is [None].
  [None] denotes that the entire company is specified. Where an item other than [None] is selected, enter the corresponding code. Where [Department] is specified, specify a depreciation department.
• Setup by Currency
  Where a budget is registered with a currency specified, select the checkbox. The default status is Off. When the checkbox is selected, the combo-box for Select Currency is displayed.
• Currency
  Displayed when the [Setup by currency] option is selected. Select from currencies that are registered in [Register currency].
• Budget Type ([Register cashflow budget] or [Register budget for financial statements by item])
  When [Register cashflow budget], if you enter the new budget code and click the "Refer" button, the [Create Cashflow statement budget] screen is displayed. If you select the existing budget code and click the "Refer" button, the value specified at new registration is displayed.
  In the case of [Registerbudget for financial statements by item], select either [Total budget from opening] or[ Period budget].
  

  Budget type	Description
  Total budget from opening	Selects the cashflow budget from the beginning of the term until the end day of the specified period.
  Period budget	Selects the cashflow budget only for the specified period.

• Entry (displayed only for [Register Cashflow budget])
  Click this button to display the [Create Cash Flow Budget] screen. This screen is displayed when the cash flow budget is created. This screen cannot be revised. This button cannot be used before pressing the "Refer" button.

[Spread] (within the [Entry] frame)

Click the "Refer" button to display the following values for the registered budget in the rows for each allocated period.

• Start date
• End date
• Committed
• Comment Code and Name
  The comment code and the name as of approval are displayed. In the case of a new budget, nothing is displayed.
• Update Operator and Name
  The update operator and name are displayed. In the case of a new budget, nothing is displayed.
• Modification Date
  The date of modification is displayed. In the case of a new budget, nothing is displayed.
• Commit Operator and Name
  The commit operator and name are displayed. In the case of a new budget, nothing is displayed.
• Committed Date
  The committed date is displayed. In the case of a new budget, nothing is displayed.

• Number
  Row numbers are displayed.
• Summary A/C 1 ~ 3
  The name of the summary A/C is displayed.
• A/C code and name
  The account title code and name are displayed.
• Sub A/C code and name
  The sub A/C code and name are displayed.
• ( - )type
  The minus type is displayed. The plus and minus of amounts in rows with a check-mark are inverted.
• Hide
  The hidden type is displayed.
• Net profit (displayed only for [Register cashflow budget])
  The row in which "net profit" (= assets - debts - capital) is tabulated is displayed with a check-mark.
• Tax shield (displayed only for [Register cash flow budget])
  The row deemed as the task shield is displayed with a check-mark.
• FCF (displayed only for [Register cashflow budget])
  The row that is considered free cash flow is displayed with a check-mark.
• Dr/Cr (displayed only for [Register cashflow budget])
  Either of the following types is displayed in each row.
  

  Type	Description
  Opening balance	Balance at the beginning of the term
  Closing balance	Opening balance + amount generated from the beginning of the term until the end day of the specified period
  Dr side	Dr amount from the beginning of the term until the end day of the specified period
  Cr side	Cr amount from the beginning of the term until the end day of the specified period
  Fluctuation	In the case of a Dr A/C: Dr amount - Cr side Amt In the case of a Cr A/C: Cr amount - Dr side Amt

• Formula
  The formula for an amount that is output in the row for a summary A/C is displayed.
• Free code
  The free code that is registered in connection with other software is displayed.
• Field for entry of the Budget Amt
  According to the specified "Period (from/to)", enter the budget amount. The entered budget amount changes as follows according to the selection of "Period (from/to)".
  

  Period (from/to)	Display
  Term	The columns for entry of the budget from the first term to the 12th term
  Quarter	The columns for entry of the budget from the first quarter to the forth quarter
  Half-yearly	The columns for entry of the budget of the first half and the second half
  Accounting year	The column for entry of the budget of the designated year

  
  In the case of a balance sheet, the balance is set up as the [budget as of the closing date] for each term, quarter, half-yearly and year.
  In cases other than a balance sheet, the amount generated during the period is setup as the [amount budgeted during that period] for each term, quarter, half-yearly and accounting year.
  
  If "Setup by currency" is selected and a currency other than the Std currency is selected, two columns are displayed for the budget to be entered in the standard currency and another currency.
  Note that only the budget for the accounting period, for which there is a check-mark at the top of the column for each budget is saved.
  
• Total (displayed only for other than [Register the balance sheet budget])
  After a budget is saved, the total of the budgets that have been totaled according to the template used for budget registration (summary items and formula) is displayed.
  After the budget is saved, the value totaling all of the periods in the accounting period is displayed in each row.
  If Total Budget since Opening is selected as the budget type in [Register cashflow budget] and [Register budget for financial statements by item], this item is not displayed.
• Annual budget
  The budget for an [Year] that is registered with the same template and the same budget code is displayed.
  Where the period is an [Year], this item is not displayed.
  

  Type of annual budget	Description
  P/L budget	If saved where the [Total] is not consistent with the [Annual budget], the following message is displayed: There is a row where the entered budget amount and annual budget do not match. Is it OK to save?
  B/S budget	If saved where the final term (month) budget is not consistent with [Annual budget], the following message is displayed: There is a row where the entered budget amount and annual budget do not match. Is it OK to save?

  
  If "Setup by Currency" is selected and a currency other than the Std currency is selected, two columns are displayed for the budget to be entered in the standard currency and another currency.