Search

JP-7856596-B2 - Budget creation device, budget creation method, and budget creation program

JP7856596B2JP 7856596 B2JP7856596 B2JP 7856596B2JP-7856596-B2

Inventors

  • 藤得 晃博

Assignees

  • 株式会社オービック

Dates

Publication Date
20260511
Application Date
20230217

Claims (8)

  1. A budget creation device comprising a control unit, A property code is associated with a property name, ownership ratio code, owner business partner code, owner name, and ownership ratio information showing the ownership ratio between our company and the owner, in an ownership ratio master. A management item master that associates at least the management item name, budget acquisition category, and budget acquisition category name with the management item code, The billing schedule data associates the billing number with the property code, property name, billing code, billing name, management item code, management item name, accounting date, invoice issuance date, expected payment date, billing amount, and the aforementioned ownership ratio code. Accessible, The control unit, A first creation unit that references the aforementioned ownership ratio master, the aforementioned management item master, and the aforementioned billing schedule data to create target billing schedule data corresponding to a specified aggregation period, A second creation unit creates allocation data for the target invoice schedule by referencing the aforementioned ownership ratio master and allocating sales and deposits from the target invoice schedule data, A third creation unit creates budget data for the planned invoices, including an accrual basis aggregated based on the accounting date and a deposit/expense basis aggregated based on the planned payment date, based on the aforementioned planned invoice data and the apportionment data of the planned invoices. To be equipped, A budget creation device characterized by the following:
  2. A budget creation device according to claim 1, Payment schedule data, which associates the payment number with the property code, property name, payee code, payee name, management item code, management item name, recording date, payment invoice issuance date, scheduled payment date, payment amount, and the aforementioned ownership ratio code. Further access is available, The first creation unit described above is: Referencing the aforementioned ownership ratio master, the aforementioned management item master, and the aforementioned payment schedule data, create target payment schedule data corresponding to the specified aggregation period. The second creation unit described above is: Referencing the aforementioned ownership ratio master, allocate the payments and deposits from the aforementioned target payment schedule data to create allocation data for the target payment schedule. The third creation section described above is: Based on the aforementioned target payment schedule data and the allocation data of the aforementioned target payment schedule, budget data for the payment schedule is generated, including an accrual basis aggregated based on the accounting date and a receipt/expense basis aggregated based on the payment schedule date. A budget creation device characterized by the following:
  3. A budget creation device according to claim 2, The aforementioned management item master is The aforementioned management item codes are further associated with information indicating whether or not a transaction is recorded in a journal entry, which shows whether or not the transaction is routed through the company's own account. The first creation unit described above is: Based on the journal entry status information in the management item master, the target billing schedule data or target payment schedule data is created by excluding transaction data that does not go through the company's own account from the billing schedule data or the payment schedule data. A budget creation device characterized by the following:
  4. A budget creation device according to claim 3, The control unit, The system further includes a display control unit that displays the budget data for the planned invoice or the budget data for the planned payment on a monitor. A budget creation device characterized by the following:
  5. A budget creation device according to claim 4, The display control unit, To display the accrual basis and the receipt/expense basis of the budget data for the invoiced or the budget data for the payment schedule in an identifiable manner, A budget creation device characterized by the following:
  6. A budget creation device according to claim 5, The control unit, The system further includes an ownership ratio registration unit that registers the ownership ratio information in the ownership ratio master in response to an external operation. A budget creation device characterized by the following:
  7. A budget creation method performed by a budget creation device equipped with a control unit, The budget creation device is A property code is associated with a property name, ownership ratio code, owner business partner code, owner name, and ownership ratio information showing the ownership ratio between our company and the owner, in an ownership ratio master. A management item master that associates at least the management item name, budget acquisition category, and budget acquisition category name with the management item code, The billing schedule data associates the billing number with the property code, property name, billing code, billing name, management item code, management item name, accounting date, invoice issuance date, expected payment date, billing amount, and the aforementioned ownership ratio code. Accessible, The control unit executes the following: A first creation step involves creating target billing schedule data according to a specified aggregation period by referring to the aforementioned ownership ratio master, the aforementioned management item master, and the aforementioned billing schedule data, A second creation step involves referencing the aforementioned ownership ratio master and creating allocation data for the target invoiced data by allocating sales and deposits from the target invoiced data, A third creation step involves creating budget data for the planned invoices, which includes an accrual basis aggregated based on the accounting date and a receipt/payment basis aggregated based on the expected payment date, based on the aforementioned planned invoice data and the apportionment data of the planned invoices. Including, A budget creation method characterized by the following:
  8. A budget creation program to be executed by a budget creation device equipped with a control unit, The budget creation device is A property code is associated with a property name, ownership ratio code, owner/business partner code, owner name, and ownership ratio information showing the ownership ratio between our company and the owner, in an ownership ratio master. A management item master that associates at least the management item name, budget acquisition category, and budget acquisition category name with the management item code, The billing schedule data associates the billing number with the property code, property name, billing code, billing name, management item code, management item name, accounting date, invoice issuance date, expected payment date, billing amount, and the aforementioned ownership ratio code. Accessible, To be performed by the control unit, A first creation step involves creating target billing schedule data according to a specified aggregation period by referring to the aforementioned ownership ratio master, the aforementioned management item master, and the aforementioned billing schedule data, A second creation step involves referencing the aforementioned ownership ratio master and creating allocation data for the target invoiced data by allocating sales and deposits from the target invoiced data, A third creation step involves creating budget data for the planned invoices, which includes an accrual basis aggregated based on the accounting date and a deposit/payment basis aggregated based on the expected payment date, based on the aforementioned planned invoice data and the apportionment data of the planned invoices. Including, A budget creation program characterized by the following:

Description

This invention relates to a budget creation device, a budget creation method, and a budget creation program. Patent Document 1 discloses a technology that allows not only comparison between performance data and budget data, but also comparison between different budget data sets, and enables the selection of the comparison granularity from a pre-defined set of options. Japanese Patent Publication No. 2019-219850 Figure 1 is a schematic diagram showing an overview of an example of the configuration of a budget creation device according to an embodiment.Figure 2 is a schematic diagram illustrating the overview of the aggregation content used in conventional budget preparation.Figure 3 is a flowchart showing an overview of the processes performed by the budget creation device according to this embodiment.Figure 4 shows an example of an ownership ratio master table for the budget creation device according to the embodiment.Figure 5 shows an example of a rental contract registration screen displayed on a monitor by the display control unit of the budget creation device according to the embodiment.Figure 6 shows an example of a billing schedule data table in the billing schedule data generated by the billing input unit of the budget creation device according to the embodiment.Figure 7 shows an example of a management item master table in the management item master registered by the management item master registration unit of the budget creation device according to the embodiment.Figure 8 shows the items in the management item master table indicating whether or not journal entries are recorded for management items registered by the management item master registration unit of the budget creation device according to the embodiment.Figure 9 is a diagram showing an example of a correspondence table illustrating the relationship between budget acquisition categories and acquisition methods.Figure 10 shows an example of a budget data creation screen displayed on a monitor by the display control unit of the budget creation device according to the embodiment.Figure 11 shows an example of a target billing schedule data table in the target billing schedule data created by the first creation unit of the budget creation device according to the embodiment.Figure 12 shows an example of an allocation data table for target invoices in the allocation data created by the second creation unit of the budget creation device according to the embodiment.Figure 13 shows an example of a budget data table in the budget data created by the third creation unit of the budget creation device according to the embodiment.Figure 14 is a diagram illustrating an overview of the creation method by which the third creation unit of the budget creation device according to the embodiment creates budget data 106g.Figure 15 shows an example of a target payment schedule data table in the target payment schedule data created by the first creation unit of the budget creation device according to this embodiment.Figure 16 shows an example of an allocation data table in the allocation data of target payment schedules created by the second creation unit of the budget creation device according to the embodiment.Figure 17 shows an example of a budget data table in the budget data created by the third creation unit of the budget creation device according to the embodiment.Figure 18 is a diagram illustrating an overview of the creation method by which the third creation unit of the budget creation device according to the embodiment creates budget data. The following describes in detail, with reference to the drawings, embodiments of the budget creation device, budget creation method, and budget creation program according to the present invention. However, the present invention is not limited to these embodiments. [1. Structure] An example of the configuration of the budget creation device according to this embodiment will be described with reference to Figure 1, etc. Figure 1 is a schematic diagram showing an overview of an example of the configuration of the budget creation device in a block diagram. The budget creation device 100 shown in Figure 1 is a commercially available desktop personal computer. However, the budget creation device 100 is not limited to stationary information processing devices such as desktop personal computers; it may also be a portable information processing device such as a commercially available notebook personal computer, PDA (Personal Digital Assistant), smartphone, or tablet personal computer. The budget creation device 100 comprises a control unit 102, a communication interface unit 104, a storage unit 106, and an input/output interface unit 108. Each component of the budget creation device 100 is connected via an arbitrary communication path for communication. The communication interface unit 104 connects the budget creation device 100 to the network 300 via a communication device such as a router and a wired or wireless communicatio