Back  Top

Create cashflow statement budget

Register a new budget for the cashflow statement.
→To Operation Procedure

Screen Transition

[The Planning Control Module]
  ↓
[Register Accounting Budget]
  ↓
[Register Cashflow Budget]
  ↓
[Register cashflow budget] screen
    "Refer" button → [Create cashflow statement budget] screen

[Create cashflow statement budget]

Specify the template code, the period type, the period, the budget code and the item, then press the "Refer" button. If there is no budget data for the specified object, the operation is handled as a new entry. In some cases, "None" is specified for Item. For a new entry, the [Create cashflow statement budget] screen is displayed.
It is possible to create a cashflow budget. Select "New" and "Budget type" from the option buttons on the screen and enter [B/S template, code] [B/S budget code], [P/L template code] and [P/L budget code]. It is possible to create a budget automatically with the setup of B/S and P/L. In this case, only the items in the B/S a/c and the P/L a/c are automatically created.

[New]

[Budget ype]

[Balance sheet budget]

This section is displayed only [Create from B/S and P/L budget] is selected in "New".

  • Template Code
    Selects the template that is registered in [Register B/S template code]. It is also possible to enter the code manually.
  • Budget Code
    Selects the budget codes that fall into [Accounting period] and [Items] that are specified on the Register cashflow budget screen and the B/S template that is specified on this screen. The pop-up menu arranges the codes. If a budget code that does not fall into any of the previous choices is entered manually, the system displays the message, "Entry data doesn't exist.." If the B/S template is specified, it is necessary to enter the budget code.

[Profit and loss statement budget]

This section is displayed only when [Create from B/S and P/L Budget] is selected in "New".

  • Template Code
    Selects the template that is registered in Register [P/L template code]. It is also possible to enter the code manually.
  • Budget Code
    Selects the budget codes that fall into the [Accounting period] and [Items] that are specified on the Cashflow Budget Registration Screen and the P/L template that is specified on this screen. The pop-up menu arranges the codes. If a budget code that does not fall into any of the previous choices is entered manually, the system displays the message, "Entry data doesn't exist." If the B/S template is specified, it is necessary to enter the budget code.

[Buttons]

  • OK
    Press the OK button to reflect the selected data on the Register cashflow budget screen. The status changes to that of new budget registration.
  • Cancel
    Press the Cancel button to discard the data and return to the Register cashflow budget screen.

Refer to:

[Concept of the Budget Amt]

Note that the mechanism for automatic creation and processing differs according to the budget type specified for new creation (either [Total budget from opening] or [Period budget]).

  • Instruction for Entry
    -

    When [Total budget fron opening] is select ed

    When [Period budget] is selected

    Row of opening balance

    Enter the balance at the opening of the accounting year

    Enter the balance at the start day of the period

    Row of Dr side/Cr side/Fluctuation

    Enter Dr side/Cr side/Fluctuation from opening until the end day of the period

    Enter Dr side/Cr side/Fluctuation within the period concerned

    Row of closing balance

    Enter the balance at the end day of the period

    Enter the balance at the end day of the period

  • Outputting the Total column
    In the case of [Total budget from opening], the total column is not output.
    In the case of [Period budget], the Total column is output. The data output is as follows:
    -

    When [Period budget] is selected

    Row for Opening balance/Closing balance/Summary A/C

    Nothing is output.

    Row for Dr side/Cr side/Fluctuation

    The total value of the amounts entered for each period is displayed.

  • Outputting the Annual Budget
    Select the accounting year as the Period. The saved annual budget is displayed. The following data is output:
    -

    When [Total budget from opening] is selected

    When [Period budget] is selected

    Row for Opening Balance

    If it is saved when the budget for the final term is not consistent with the [Annual budget], the following message is displayed: There is a row where the entered budget amt and the annual budget do not match. Is it OK to save?

    If it is saved when the budget for the start term is not consistent with the [Annual budget], the following message is displayed: There is a row where the entered budget amt and the annual budget do not match. Is it OK to save?

    Row for Dr side/Cr side/ Fluctuation

    Same as above

    If it is saved where the total is not consistent with the [Annual budget], the following message is displayed: There is a row where the entered budget amt and annual budget do not match. Is it OK to save?

    Row for Closing Balance

    Same as above

    If it is saved where the final term budget is not consistent with the [Annual budget], the following message is displayed: There is a row where the entered budget amt and annual budget do not match. Is it OK to save?

[Auto-Generation and Processing on Creation of the Cashflow Budget]

When creating a cashflow budget, select [Create from B/S budget and P/L budget] and click the "Refer" button. The system automatically totals the amount of the cashflow budget from the designated B/S budget and P/L budget. However, note that the subjects for automatic summary are only the rows for the [Opening balance], [Closing balance] and [fluctuation]. The rows for [PS year net profit], [Summary A/C], [Dr side] and [Cr side] are not subjects for summary. The row for [Summary A/C] is automatically calculated following the equation.

  •   Mechanism of summary

    A/C

    Summary Item

    Comments

    B/S A/C

    [Opening balance], [Closing balance] and [Fluctuation] are totaled.

    Only the B/S budget is the subject for summary. Even where the B/S A/C is specified in the P/L budget, that row in the P/L budget is excluded from the subject for summary.

    P/L A/C

    Only [Fluctuation] is totaled.

    If the P/L A/C is set as the [Opening balance] and [Closing balance] in the C/F budget, these rows are excluded from the subject for summary. Only the P/L budget is the subject for summary. Even where the P/L A/C is designated in the B/S budget, that row in the B/S budget is excluded from the subject for summary.

    The cashflow budget is created automatically based on the B/S budget and the P/L budget in the same period. For example, when a quarterly cashflow budget is created automatically, the amount is automatically totaled and processed from the quarterly B/S budget and the quarterly P/S budget. Where more than two identical accounts are specified in the B/S budget or in the P/L budget, that total is calculated. Note that the tabulation method differs between [Total budget from opening] and [Period budget].
  •   Summary of the B/S a/c ([PS year net profit], [summary A/C], {Dr side} and [Cr side] are not the subject for summary.)

    Budget type

    Opening balance

    Fluctuation

    Closing balance

    Total budget from opening

    [The budget of end of month of the previous year] is always set.

    [n-(n-1) term budget] from the beginning of the term (2000/January term) in the B/S budget is totaled and output.

    The B/S budget for the current month (term) is set as it is.

    Period budget

    The [n-1 term budget] is always set.

    The [n-(n-1) term budget] in the B/S budget is output.

    The B/S budget in the current month (term) is set as it is.

  • Summary of the P/L A/C (Accounts other than [Fluctuation] are not the subject for summary.)

    Budget type

    Fluctuation

    Total budget from opening

    [Term budget] from the beginning of the term (2000/January term) in the P/S budget is totaled.

    Period budget

    [Term budget] in the P/L budget is output.

 

Back  Top

Copyright © 2019 Business Engineering Corp.