Work support device, work support method, and work support program

Abstract

To reduce the burden of a person in charge due to the preparation work of a settlement report.SOLUTION: A data generation part refers to an output format setting master table in which desired headings and items to be described in an account settlement report are stored, and generates work data for output including the input headings and items and including an input column of the amount of each item. The update processing unit refers to the journal detail data including the amount of each item, and updates the input field of the amount of the work data for output with the amount of the corresponding item. A deletion processing part refers to an item integrated master table in which a 0 yen printing classification being information showing whether or not the item of the amount of 0 yen is to be described in the settlement report is stored for each item, and performs deletion processing of data related to the item whose amount is 0 yen corresponding to the 0 yen printing classification showing that it is not to be described in the settlement report from the work data for output. Thus, since the model of the settlement report suitable for the item or the like is automatically generated, the load of the preparation work of the settlement report is remarkably reduced.SELECTED DRAWING: Figure 2

Description

[Technical Field]

[0001] The present invention relates to a business support device, a business support method, and a business support program. [Background technology]

[0002] Patent Document 1 (JP Patent Publication No. 2020-166869) discloses an accounting processing system that aims to achieve integrated financial and tax processing by creating a menu and integrating practical tasks such as data import, auditing, accounting statement creation, financial settlement and reporting processing, and tax reporting.

[0003] Paragraph 0160 of Patent Document 1 discloses a technology in which a control unit launches a "financial statement creation" app, imports accounting data from a memory unit, and a person in charge generates ledger data, which is a financial statement, based on the accounting data.

[0004] Furthermore, paragraphs 0162 and 0163 of Patent Document 1 disclose a technology in which a control unit launches apps for "depreciation input," "business overview explanation creation," "account item breakdown creation," and "corporate tax return creation," and a person in charge generates depreciation data. Furthermore, paragraph 0165 of Patent Document 1 discloses a technology in which an app for "account item breakdown creation" is launched, and a person in charge generates account item breakdown data. [Prior art documents] [Patent documents]

[0005] [Patent Document 1] Japanese Patent Application Publication No. 2020-166869 Summary of the Invention [Problem to be solved by the invention]

[0006] However, in the past, the task of preparing financial statements such as balance sheets and income statements was a burden for the person in charge.

[0007] The present invention has been made in view of the above-mentioned problems, and aims to provide a business support device, a business support method, and a business support program that can reduce the burden on a person in charge of creating a financial statement. [Means for solving the problem]

[0008] In order to solve the above-mentioned problems and achieve the objectives, the business support device of the present invention has a data generation unit that references an output format setting master table in which the desired headings and items to be included in the financial statement are stored, and generates output work data that includes the input headings and items and an input field for the amount of each item; an update processing unit that references journal entry detail data including the amount of each item and updates the amount input field of the output work data with the amount of the corresponding item; a deletion processing unit that references a comprehensive item master table stored for each item and deletes data related to items with an amount of 0 yen from the output work data, where the 0 yen printing category, which is information indicating whether an item with an amount of 0 yen should be included in the financial statement, corresponds to the 0 yen printing category indicating that the item will not be included in the financial statement; and an output control unit that outputs the deleted output work data to the output target device.

[0009] In addition, in order to solve the above-mentioned problems and achieve the objectives, the business support method of the present invention includes a data generation step in which a data generation unit references an output format setting master table in which the desired headings and items to be included in the financial statement are stored, and generates output work data that includes the input headings and items and an input field for the amount of each item; an update processing step in which an update processing unit references journal entry detail data including the amount of each item and updates the amount input field of the output work data with the amount of the corresponding item; a deletion processing step in which a deletion processing unit references a comprehensive item master table stored for each item, and deletes data related to items with an amount of 0 yen that corresponds to the 0 yen printing category, which is information indicating whether an item with an amount of 0 yen should be included in the financial statement, from the output work data; and an output control step in which an output control unit outputs the output work data that has been deleted to an output target device.

[0010] In addition, in order to solve the above-mentioned problems and achieve the objective, the business support program of the present invention causes a computer to function as a data generation unit that references an output format setting master table in which the desired headings and items to be included in the financial statement are stored, and generates output work data that includes the input headings and items and includes an input field for the amount of each item; an update processing unit that references journal entry detail data including the amount of each item and updates the amount input field of the output work data with the amount of the corresponding item; a deletion processing unit that references a comprehensive item master table stored for each item and deletes data related to items with an amount of 0 yen from the output work data, where the 0 yen printing category, which is information indicating whether an item with an amount of 0 yen should be included in the financial statement, corresponds to the 0 yen printing category indicating that the item should not be included in the financial statement; and an output control unit that outputs the deleted output work data to an output target device. [Effects of the Invention]

[0011] The present invention can reduce the burden on the person in charge of preparing financial statements. [Brief explanation of the drawings]

[0012] [Figure 1] Figure 1 is a diagram for explaining a corporate structure consisting of a parent company and multiple special purpose companies (SPCs). [Figure 2] FIG. 2 is a block diagram illustrating a hardware configuration of the task assistance device according to the embodiment. [Figure 3] FIG. 3 is a diagram illustrating an example of the SPC master table. [Figure 4] FIG. 4 is a diagram illustrating an example of the accounting period master table. [Figure 5] FIG. 5 is a diagram showing an example of a subject general master table. [Figure 6] FIG. 6 is a diagram illustrating an example of the total subject range specification master table. [Figure 7] FIG. 7 is a diagram illustrating an example of a profit and loss item master table. [Figure 8] FIG. 8 is a diagram showing an example of the output format setting master table. [Figure 9] FIG. 9 is a diagram showing an example of the financial statement screen. [Figure 10] FIG. 10 is a diagram showing an example of the journalization data acquired from the SPC terminal device. [Figure 11] FIG. 11 is a diagram illustrating an example of output work data before update processing. [Figure 12] FIG. 12 is a diagram showing output work data in which the amount of each item has been input based on the journalization data. [Figure 13] FIG. 13 is a diagram showing output work data in a state in which the amount of gross profit on sales has been updated based on the journal data. [Figure 14] FIG. 14 shows output work data in which an update process has been performed to delete records (rows) of subjects whose amount is "0 yen" and whose 0 yen print category is "0: not to be printed." [Figure 15] FIG. 15 shows output work data that has been updated by deleting all records in a group in which the amount of all records with the same group number is "0 yen." [Figure 16] Figure 16 shows output work data updated by deleting records (rows) of profit items when loss items are to be printed, and deleting records (rows) of loss items when profit items are to be printed. [Figure 17] FIG. 17 shows output work data that has been updated by deleting the record of a subject when the 0 yen printing category in the subject general master table is "0: Not to be printed" and the amount is 0 yen. [Figure 18] Figure 18 shows the income statement that is displayed or printed using the output work data that has been updated by deleting the record for that subject when the 0 yen printing category in the subject general master table is "0: Not printed" and the amount is 0 yen. [Figure 19]FIG. 19 shows output work data that has been updated by deleting all records (rows) of the heading and subject of a group when the amount is "0 yen" for that group. [Figure 20] FIG. 20 shows an income statement that is displayed or printed using output work data that has been updated by deleting all the records (rows) of the headings and subjects of a group when the amount is "0 yen" for that group. [Figure 21] Figure 21 shows output work data that has been updated based on the profit and loss item master table by deleting the profit item record if a loss item record exists, and deleting the loss item record if a profit item record exists. [Figure 22] Figure 22 shows an income statement that is displayed or printed using output work data that has been updated based on the income item master table, by deleting the record for the profit item if a record for the loss item exists, or deleting the record for the loss item if a record for the profit item exists. [Figure 23] FIG. 23 is a diagram showing output work data that is finally generated by updating the template output work data, including deleted records. [Figure 24] FIG. 24 is a diagram showing the income statement that is displayed or printed in the output work data that is finally generated, including headings and items that are not displayed or printed. [Figure 25] FIG. 25 is a diagram showing the output work data that is finally generated by updating the template output work data, excluding deleted records. [Figure 26] FIG. 26 is a diagram showing the income statement that is displayed or printed in the output work data that is finally generated, excluding the headings and items that are not displayed or printed. DETAILED DESCRIPTION OF THE INVENTION

[0013] DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS A task support device according to an embodiment of the present invention will be described in detail below with reference to the accompanying drawings. However, the present invention is not limited to the following embodiment.

[0014] (overview) Today, a common corporate structure is one that consists of a parent company and multiple special purpose companies (SPCs), as shown in Figure 1. In such a corporate structure, a management company must prepare financial statements for the multiple companies at the end of each fiscal year, such as every month.

[0015] The layout of the printed items on financial statements varies depending on the start, middle, and end of an SPC project. Furthermore, the printed items on financial statements vary depending on the project's content (for example, aircraft leasing, shipping containers, solar power generation, etc.), which makes creating financial statement templates cumbersome and increases the workload of those responsible for preparing the financial statements. This problem becomes more pronounced when the number of companies that need to prepare financial statements increases, as in the case of corporate structures that include SPCs mentioned above.

[0016] The business support device 1 of the embodiment described below using Figure 2 etc. is an example in which the present invention is applied to the terminal device of the parent company shown in Figure 1, and aims to reduce the burden on the person in charge of creating financial statements by automatically creating templates for financial statements for accounting items suitable for each project and each accounting period, etc.

[0017] (Hardware configuration) That is, the business support device 1 of such an embodiment includes a storage unit 2, a control unit 3, a communication interface unit 4, and an input / output interface unit 5, as shown in Fig. 2. An input device 6 and an output device 7 are connected to the input / output interface unit 5. The output device 7 corresponds to a display unit such as a monitor device (including a home television), a printing device, or a speaker device. The input device 6 may be a keyboard device, a mouse device, a microphone device, or a monitor device that cooperates with a mouse device to realize a pointing device function.

[0018] The communication interface unit 4 is connected to a network 50, which may be a wide area network such as the Internet or a private network such as a LAN (Local Area Network). An SPC terminal device 51 of each SPC is connected to the network 50. Each SPC terminal device 51 generates detailed journal entry data for income and expenditure at the accounting period, such as every month, and transmits the data to the business support device 1. This detailed journal entry data is stored in the memory unit 2 (detailed journal entry data memory unit 17).

[0019] A storage device such as a ROM (Read Only Memory), RAM (Random Access Memory), HDD (Hard Disk Drive), or SSD (Solid State Drive) can be used as the storage unit 2. The storage unit 2 stores a business support program that automatically creates templates for financial statements for accounting items appropriate for each case and each accounting period, and supports the person in charge in creating financial statements.

[0020] In addition, this memory unit 2 is provided with an SPC master table 11, a fiscal year master table 12, a general item master table 13, a total item range designation master table 14, a profit and loss item master table 15, an output format setting master table 16, a journal entry detail data memory unit 17, an output work area 18, and a financial statement memory unit 19, each of which is a memory area.

[0021] As shown in FIG. 3, the SPC master table 11 stores an SPC number, which is a unique identification number assigned to each SPC, and an SPC name, in association with each other.

[0022] The fiscal year master table 12 stores the start and end dates of each SPC in association with the SPC number of each SPC, as shown in Figure 4. In the example of Figure 4, for an SPC with SPC number "1000001," the first half of each year runs from August 1 to January 31 of the following year, and the second half runs from February 1 to July 31.

[0023] As shown in Figure 5, the comprehensive account master table 13 stores the account code, account name, debit / credit classification, table classification, account classification, and 0 yen printing classification of each account to be included in the financial statement, each associated with the other.

[0024] The debit / credit category is information that indicates whether the item is listed on the debit side of the financial statement or on the credit side. The table category is information that indicates whether the item is listed on the balance sheet (B / S) or on the profit and loss statement (P / L). The account category is information that indicates whether the item is a general account (0: general account) or a total account (1: total account).

[0025] The 0 yen printing category is information that indicates whether or not to print on the financial statement if the amount of that item is "0 yen." For items that should be printed even if the amount is "0 yen," the 0 yen printing category "1: Print target" is set, and for items that should not be printed when the amount is "0 yen," the 0 yen printing category "0: Not print target" is set.

[0026] As shown in Figure 6, the total account range specification master table 14 stores the calculation category, first calculation element, and second calculation element that indicate the calculation method for each total account. The symbol "~" in the calculation category indicates that the calculation is performed by adding the first calculation element to the second calculation element. In other words, in the case of the "Total Deposits" account with an account code of "T100," it indicates that the calculation is performed by adding up the amounts of each account from "Cash and Deposits" with an account code of "1110" to "Term Deposits" with an account code of "1150."

[0027] The "+" symbol in the calculation section indicates that the first calculation element is added to the second calculation element, and the "-" symbol in the calculation section indicates that the second calculation element is subtracted from the first calculation element.

[0028] The profit and loss account master table 15 stores the profit account codes of profit accounts and the loss account codes of loss accounts, which are mutually associated as shown in Figure 7. In this example, the profit account code "Gross Profit" of "T520" is associated with the loss account code "Gross Loss" of "T521". Also, in this example, the profit account code "Operating Profit / Loss (Profit)" of "T710" is associated with the loss account code "Operating Profit / Loss (Loss)" of "T711".

[0029] The output format setting master table 16 stores the headings and items to be entered (printed) in the balance sheet and income statement, and the item codes (see FIG. 5) of the items whose amounts are to be printed. The output format setting master table 16 also stores the group numbers of the groups assigned to each item, and the printing order of each heading or item.

[0030] In the case of the income statement shown in Figure 8, the heading "Sales" has no corresponding account code, so it is not added, and it belongs to the group with group number "1", and its printing order is "10". Also, the account code for "Lease Fees" is "5100", it belongs to the group with group number "1", and its printing order is "20". Also, the account code for "Commissions Received" is "5220", it belongs to the group with group number "1", and its printing order is "30".

[0031] In the case of the income statement shown in Figure 8, the heading "Cost of Sales" has no corresponding account code, so it is not added, and it belongs to the group with group number "2," and its printing order is "50." The account code for "Depreciation of Leased Assets" is "5310," it belongs to the group with group number "2," and its printing order is "60." The account code for "Gross Profit" is "T520," it belongs to the group with group number "1," and its printing order is "70." The account code for "Gross Loss" is "T521," it belongs to the group with group number "0," and its printing order is "80."

[0032] (Functional configuration of business support device) Next, the control unit 3 executes the business support program stored in the memory unit 2, and functions as a data generation unit 21, an update processing unit 22, a deletion processing unit 23, a calculation unit 24, and a display control unit 25 (an example of an output control unit), as shown in Figure 2.

[0033] In this example, the data generation unit 21 to the display control unit 25 are described as being realized by software based on a business support program. However, all or part of the data generation unit 21 to the display control unit 25 may be realized by hardware. In either case, the same effects as those described below can be obtained.

[0034] The data generating unit 21 refers to an output format setting master table 16 (see FIG. 8) that stores desired headings and items to be entered in a financial statement (profit and loss statement, balance sheet, etc.). The data generating unit 21 then generates output work data that includes the input headings and items, as well as an input field for the amount of each item (see FIG. 11).

[0035] The update processing unit 22 refers to the journal entry detail data including the amount of each item (see FIG. 10), and updates the input field for the amount of the output work data with the amount of the corresponding item (see FIG. 12).

[0036] The deletion processing unit 23 refers to the general subject master table 13 (see FIG. 5) in which the 0 yen printing category, which is information indicating whether or not subjects with an amount of 0 yen should be included in the financial statement, is stored for each subject.The deletion processing unit 23 then deletes data related to subjects with an amount of 0 yen that corresponds to the 0 yen printing category indicating that they should not be included in the financial statement from the output work data (see FIG. 14).

[0037] This makes it possible to automatically generate output work data corresponding to a template for a financial statement suited to a project, etc. The output work data that has undergone this deletion process is output to the output target device by the output control unit. As an example, the display control unit 25 can be used as the output control unit. In this case, the display control unit 25 displays the output work data that has undergone the deletion process via the output device 7.

[0038] The output target device may be a printing device to obtain a printout of the output work data. The output work data may also be stored in the storage unit 2, an external storage device, or a server device on the network 50.

[0039] Next, the calculation unit 24 refers to the total item range specification master table 14 (see FIG. 6) in which the calculation method for the amount of each item is stored, and calculates at least the profit items and loss items.

[0040] In this case, if the calculated amount of a profit item or loss item becomes a negative amount, the update processing unit 22 updates the output work data so that the profit item or loss item for which a negative amount was calculated becomes 0 yen.

[0041] In addition, if the output work data for loss items has already been deleted, the deletion processing unit 23 does not perform deletion processing on the output work data for profit items, and if the output work data for loss items has not been deleted, it deletes the output work data for profit items (see Figure 16).

[0042] Additionally, the subject general master table 13 stores a subject code, which is unique identification information, for each subject (see FIG. 5). The data generation unit 21 generates output work data including the subject code corresponding to the subject, obtained from the subject general master table 13. The update processing unit 22 then updates the amount of the subject for which no subject code has been entered to 0 yen.

[0043] The data generating unit 21 also generates output work data with the same group number assigned to each related subject (see FIGS. 8 and 11). If the amounts of all subjects in a group with the same group number assigned are 0 yen, the deletion processing unit 23 deletes all output work data of this group (see FIG. 15).

[0044] (Automatic creation of financial statements) Next, an operation of automatically creating a financial statement in the business support device 1 according to the embodiment will be described. When creating a financial statement, the person in charge specifies the display of a financial statement screen via the input device 6. As a result, the display control unit 25 displays the financial statement screen shown in FIG. 9 via the output device 7.

[0045] This financial statement screen has an input field for the SPC number, an input field for the period for which the financial statement screen is to be created, a field for selecting the desired output format (either balance sheet or income statement), and a selection field for selecting how to handle items with an amount of 0 yen. The person in charge enters the SPC for which the financial statement is to be created and also enters the period for which the financial statement is to be created. The person in charge also selects the document to be created (either balance sheet or income statement) and the desired table type (see Figure 8). The example in Figure 9 is an example in which the creation of both a balance sheet and an income statement has been selected. The example in Figure 9 is also an example in which the creation of a balance sheet and an income statement with table type "20" has been specified.

[0046] The person in charge also selects how to handle accounts with an amount of 0 yen as desired from among "do not print" accounts with an amount of 0 yen, "print" accounts with an amount of 0 yen, and do not print if the 0 yen printing category in the account general master table 13 shown in Figure 5 is "0: Not to be printed" (do not print only if the 0 yen printing category is 0). The example in Figure 9 is an example where "do not print only if the 0 yen printing category is 0" has been selected.

[0047] After such input and selection operations have been performed, the person in charge operates the print button provided on the financial statement screen shown in FIG.

[0048] (Step S1) When the print button is operated, the data generation unit 21 refers to the output format setting master table 16 shown in Figure 8, and generates output work data corresponding to the input and selection contents on the financial statement screen, as shown in Figure 11, and stores it in the output work area 18 of the memory unit 2.

[0049] Specifically, in the example of the financial statement screen shown in Figure 9, since the table type "20" is selected for the balance sheet and income statement, the data generation unit 21 obtains the "Sales" heading, the "Lease Fees" item and its item code "5100", the "Commission Received" item and its item code "5220" of the income statement for which the table type is set to "20" from the output format setting master table 16 shown in Figure 8.

[0050] In addition, the data generation unit 21 obtains the heading of "Cost of Sales" of the income statement with the table type set to "20", the item of "Depreciation of Leased Assets" and the item code "5310", the profit item of "Gross Profit" and the item code "T520", the loss item of "Gross Loss" and the item code "T521" from the output format setting master table 16 shown in Figure 8.

[0051] Furthermore, the data generation unit 21 acquires the group number and printing order of each heading and subject from the output format setting master table 16 shown in Fig. 8. Then, the data generation unit 21 generates output work data including the acquired format, table type, table type name, title A, title B, subject code of amount A, subject code of amount B, group number, printing order, and input fields for amount A and amount B, as shown in Fig. 11, and stores this in the output work area 18.

[0052] In other words, the data generation unit 21 generates output work data by adding input fields for amount A and amount B to the data such as format, table type, table type name, etc. set in the output format setting master table 16 as a template corresponding to the table type and format specified on the financial statement screen, and stores this in the output work area 18.

[0053] (Step S2) Next, the update processing unit 22 refers to the journal data shown in Fig. 10, which is stored in the journal detail data storage unit 17 and transmitted from each SPC terminal device 51. This journal data is the amount of "lease fee" for the item code "5100" (7,589,325 yen). Therefore, the data generation unit 21 updates the output work data by inputting the amount of "7,589,325 yen" into the input field for amount A for the item code "5100", as shown in Fig. 12.

[0054] 10 does not include the amounts of "received commission" for the account code "5220" and "depreciation of leased assets" for the account code "5310." Therefore, the data generation unit 21 updates the output work data by entering "0 yen" in the input field for amount A of "received commission" for the account code "5220," and by entering "0 yen" in the input field for amount A of "depreciation of leased assets" for the account code "5310," as shown in FIG.

[0055] (Step S3) Next, the update processing unit 22 updates the amounts of the total accounts. Specifically, the calculation unit 24 references the total account range specification master table 14 shown in FIG. 6 based on the account code "T520" for gross profit and the account code "T521" for gross loss, and detects the calculation method for the amount of each account code. In the example of FIG. 6, the calculation method set for the gross profit amount for the account code "T520" is to subtract the total cost of sales for the account code "T510" from the total sales for the account code "T530." In addition, in the example of FIG. 6, the calculation method set for the gross loss amount for the account code "T521" is to subtract the total sales for the account code "T500" from the total cost of sales for the account code "T510."

[0056] Therefore, the calculation unit 24 uses the above-mentioned calculation method based on the journal data to calculate the gross profit amount of, for example, "7,589,325 yen" and the gross loss amount of "0 yen." The update processing unit 22 updates the output work data by inputting the amount of "7,589,325 yen" in the input field for the gross profit amount and the amount of "0 yen" in the input field for the gross loss amount, as shown in Figure 13.

[0057] (Step S4) Next, the deletion processing unit 23 refers to the general account master table 13 shown in Fig. 5 based on the account code of the account with the amount "0 yen", and detects whether the 0 yen printing classification of the account with the amount "0 yen" is "0: Not to be printed" or "1: To be printed". In the case of the output work data shown in Fig. 13, the amounts of "Commission received" with the account code "5220", "Depreciation of leased assets" with the account code "5310", and "Total sales loss" with the account code "T521" are each "0 yen".

[0058] 5, the 0 yen printing category for "Commission received" with the account code "5220" is "1: Printable." In contrast, the 0 yen printing categories for "Lease asset depreciation" with the account code "5310" and "Total sales loss" with the account code "T521" are "0: Not printed."

[0059] Therefore, as shown in Figure 14, the deletion processing unit 23 deletes the record (=row) for "Leased Asset Depreciation Expense" with the account code "5310" for which the 0 yen printing category is "0: Not to be printed" and the record for "Total Sales Loss" with the account code "T521".

[0060] The deletion processing unit 23 does not delete the record of "Received Fee" with the account code "5220" for which the 0 yen printing classification is "1: Print target".

[0061] (Step S5) Next, the deletion processing unit 23 deletes all records (rows) of a group other than the group with the group number "0" if all amounts within the same group are 0 yen. Here, the deletion processing unit 23 recognizes a record in which no account code is entered as a record with an amount of "0 yen".

[0062] Therefore, in this example, as shown in FIG. 15, all amounts of the group with group number "2" become "0 yen", and the deletion processing unit 23 deletes the record (row) with the heading "Cost of Goods Sold".

[0063] (Step S6) Next, the deletion processing unit 23 refers to the profit and loss item master table 15 shown in Fig. 7 based on the item code "T520" of the gross profit for which the amount of "7,589,325 yen" has been input, and detects the loss item code corresponding to the item code "T520". In the example of Fig. 7, "gross loss" with the item code "T521" is detected as the loss item code corresponding to the item code "T520".

[0064] Next, the deletion processing unit 23 refers to the output work data and determines whether the record for "gross sales loss" with the detected account code "T521" has been deleted. If the record for "gross sales loss" with the account code "T521" has not been deleted, the record for "gross sales loss" with the account code "T521" is deleted and the output work data is updated. In this example, as shown in FIG. 16, the record for "gross sales loss" with the account code "T521" has already been deleted, so the deletion processing unit 23 does not perform the deletion process for the record for "gross sales loss" and leaves the record for "gross profit" as it is without deleting it.

[0065] On the other hand, if the record (row) for "gross sales loss (loss item)" has not been deleted (= if the printing category for the loss item is "0: To be printed"), the deletion processing unit 23 will delete the record (row) for "gross sales profit (profit item)".

[0066] In this way, output work data that serves as a template for the financial statement is stored in the output format setting master table, and when the financial statement is created, it is read out and expanded into the output work area, and updated based on the journal data, allowing the financial statement to be created using output work data with a layout that corresponds to the content of the case and each accounting period of the case.

[0067] (Examples of financial statements to be prepared) Next, a specific example of a financial statement created by the financial statement creation operation in the business support device 1 of this embodiment will be described. First, as shown in FIG. 17, if the 0 yen printing category in the account general master table 13 is "0: Not to be printed" and the amount is 0 yen, the record of that account is deleted and the output work data is updated. When the output work data is displayed or printed in this state, it is possible to display or print, for example, an income statement as shown in FIG. 18, in which the headings, accounts, and amounts corresponding to the records (rows) that were not deleted in the output work data shown in FIG. 17 are printed. In FIG. 18, the headings and accounts with a left diagonal line are headings and accounts that will not be printed on the income statement (= headings and accounts of deleted records).

[0068] Next, as shown in Figure 19, if the amount for each group is "0 yen," all records (rows) of the headings and items for that group are deleted and the output work data is updated. When this output work data is displayed or printed, the headings, items, and amounts corresponding to the records (rows) that were not deleted in the output work data shown in Figure 19 are printed, and an income statement such as the one shown in Figure 20 is displayed or printed. In Figure 20, the headings and items with a left diagonal line are headings and items that will not be printed on the income statement (= headings and items of deleted records).

[0069] Next, as shown in Figure 21, based on the profit and loss item master table 15, if a record for a loss item exists, the record for the profit item is deleted, and if a record for a profit item exists, the record for the loss item is deleted and the output work data is updated. When this output work data is displayed or printed, an income statement such as the one shown in Figure 22 is displayed or printed, with the headings, items, and amounts corresponding to the records (rows) that were not deleted in the output work data shown in Figure 21 printed on it. In Figure 22, the headings and items with a left diagonal line are headings and items that will not be printed on the income statement (= headings and items of deleted records).

[0070] Figure 23 is a diagram showing the output work data finally generated by such an update process, including the deleted records. By displaying or printing this output work data, the income statement shown in Figure 24 is displayed or printed, with the headings, items, and amounts corresponding to the records (rows) that were not deleted in the output work data shown in Figure 23 printed on it. In Figure 24, the headings and items with a left diagonal line are the headings and items that will not be printed on the income statement (= the headings and items of the deleted records).

[0071] Figure 25 shows the output work data finally generated by this update process, excluding the deleted records. By displaying or printing this output work data, the income statement shown in Figure 26 is displayed or printed, with the headings, items, and amounts corresponding to the records (rows) that were not deleted in the output work data shown in Figure 25 printed.

[0072] (Effects of the embodiment) As is clear from the above explanation, the business support device 1 of the embodiment can automatically generate a template of a financial statement suitable for a case or the like, thereby significantly reducing the burden of creating a financial statement.

[0073] This reduces personnel costs and human errors during closing and other times. Furthermore, the system's automatic determination allows for early disclosure of financial results. This allows for early disclosure of financial results to customers and investors, which contributes to an increase in the number of customers and investors.

[0074] [Contribution to the United Nations-led Sustainable Development Goals (SDGs)] This invention can contribute to improving business efficiency and promoting appropriate management decisions by companies, thereby contributing to the achievement of goals "8" and "9" of the SDGs.

[0075] Furthermore, this invention can contribute to reducing waste and promoting paperless and electronic systems, thereby contributing to the achievement of SDGs goals 12, 13, and 15.

[0076] Furthermore, the present invention can contribute to strengthening control and governance, thereby contributing to the achievement of Goal 16 of the SDGs.

[0077] [Other embodiments] The present invention can be implemented in various different forms other than the above-described embodiments within the scope of the technical concept described in the claims.

[0078] For example, among the processes described in the embodiments, all or part of the processes described as being performed automatically may be performed manually, or all or part of the processes described as being performed manually may be performed automatically using a known method or the like.

[0079] Furthermore, the processing procedures, control procedures, specific names, registered data for each process, information including parameters such as search conditions, screen examples, and database configurations shown in the specification or drawings may be changed as desired unless otherwise specified.

[0080] Furthermore, the components of the business support device 1 shown in the figure are conceptual functional components and do not necessarily have to have the physical configuration shown in the figure. For example, all or any part of the processing functions of the business support device 1, particularly the processing functions performed by the control unit 3, may be realized by a program interpreted and executed by the control unit 3 (CPU: Central Processing Unit), or may be realized by hardware using wired logic.

[0081] The program is recorded on a non-transitory computer-readable recording medium containing programmed instructions for causing the information processing device to execute the processes described in the embodiments, and is mechanically read by the business support device 1 as needed. That is, a computer program is recorded in the storage unit 2, such as a ROM or HDD, for working with an OS (Operating System) to give instructions to a control unit 3 (CPU) and perform various processes. The computer program is loaded into RAM, expanded, and executed by the control unit 3 as appropriate.

[0082] In addition, the business support program of this business support device 1 may be stored in another server device connected to the business support device 1 via any network, and all or part of it may be downloaded and executed as needed.

[0083] Furthermore, the business support program for executing the processes described in the embodiments may be stored in a non-transitory computer-readable recording medium, or may be configured as a program product.

[0084] Here, the "recording medium" can be any "portable physical medium" such as a memory card, a USB (Universal Serial Bus) memory, an SD (Secure Digital) card, a flexible disk, a magneto-optical disk, a ROM, an EPROM (Erasable Programmable Read Only Memory), an EEPROM (registered trademark) (Electrically Erasable and Programmable Read Only Memory), a CD-ROM (Compact Disk Read Only Memory), an MO (Magneto-Optical Disk), a DVD (Digital Versatile Disk), and a Blu-ray (registered trademark) Disc.

[0085] Furthermore, a "program" is a data processing method written in any language or description method, regardless of the format, such as source code or binary code.

[0086] It should be noted that a "program" is not necessarily limited to a single structure, but includes a structure that is distributed as multiple modules or libraries, and a structure that achieves its function by working together with other programs, such as an OS.

[0087] Furthermore, the specific configuration for reading the recording medium in the task support device 1 of the embodiment, the reading procedure, and the installation procedure after reading can be any known configuration or procedure.

[0088] The memory unit 2 is a storage means such as a memory device such as RAM or ROM, a fixed disk device such as a hard disk, a flexible disk, or an optical disk, and stores various programs, tables, databases, web page files, etc. used for various processes or providing websites.

[0089] The business support device 1 may be configured as an information processing device such as a known personal computer or a workstation, or may be configured as an information processing device connected to any peripheral device. The information processing device may be implemented with software (including programs or data) that realizes the processes described in the embodiments.

[0090] Furthermore, the specific forms of distribution and integration of the devices are not limited to those shown in the drawings, and all or part of them can be functionally or physically distributed or integrated in any unit depending on various additions or functional loads. In other words, the above-mentioned embodiments can be selectively implemented by combining them in any way. [Industrial Applicability]

[0091] The present invention is suitable for application to the creation of financial statements in a variety of industries. [Explanation of symbols]

[0092] 1 Business support equipment 2 Storage section 3. Control Unit 4. Communication interface section 5 Input / output interface section 6 Input Devices 7 Output Devices 11 SPC Master Table 12 Accounting Period Master Table 13 Subject Master Table 14 Total subject range specification master table 15 Profit and Loss Master Table 16 Output Formatting Master Table 17 Journal entry detail data storage section 18 Output work area 19 Financial report storage section 21 Data Generation Unit 22 Update processing section 23 Deletion processing section 24 Calculation section 25 Display control unit

Claims

1. a data generation unit that references an output format setting master table in which desired headings and items to be included in the financial statement are stored, and generates output work data that includes the input headings and items and an input field for the amount of each item; an update processing unit that refers to journal entry detail data including the amount of each of the items and updates the input field of the amount of the output work data with the amount of the corresponding item; a deletion processing unit that refers to a general master table of items stored for each item, and deletes data related to the items with an amount of 0 yen, which corresponds to the 0 yen printing category indicating that the items with an amount of 0 yen should not be included in the financial statement, from the output work data; an output control unit that outputs the output work data that has been subjected to the deletion process to an output target device; A business support device having the above.

2. The method further comprises a calculation unit that calculates at least the profit items and the loss items by referring to a total item range designation master table in which a calculation method for the amount of each item is stored, the update processing unit updates the output work data so that, when the calculated amount of a profit item or loss item becomes a negative amount, the profit item or loss item for which a negative amount has been calculated becomes 0 yen; 2. The business support device according to claim 1, wherein:

3. the deletion processing unit does not perform a deletion process on the output work data of the profit item when the output work data of the loss item has already been deleted, and deletes the output work data of the profit item when the output work data of the loss item has not been deleted; 3. The business support device according to claim 2, wherein:

4. The subject comprehensive master table stores a subject code, which is unique identification information, for each subject, The data generation unit generates the output work data including the subject code corresponding to the subject acquired from the subject comprehensive master table, the update processing unit updates the amount of the item for which the item code has not been input to 0 yen; 4. The business support device according to claim 3, wherein:

5. the data generation unit generates the output work data to which the same group number is assigned to each of the related subjects; the deletion processing unit deletes all of the output work data of a group when the amounts of all of the items of the group assigned the same group number are 0 yen; 5. The business support device according to claim 4, wherein:

6. a data generation step in which a data generation unit refers to an output format setting master table in which desired headings and items to be included in the financial statement are stored, and generates output work data that includes the input headings and items and an input field for the amount of each item; an update processing step in which an update processing unit refers to journal entry detail data including the amount of each of the items and updates the input field for the amount of the output work data with the amount of the corresponding item; a deletion processing step in which a deletion processing unit refers to an item master table stored for each item, and deletes data related to the item with an amount of 0 yen, which corresponds to the 0 yen printing category indicating that the item with an amount of 0 yen should not be included in the financial statement, from the output work data; an output control step in which an output control unit outputs the output work data that has been subjected to the deletion process to an output target device; A business support method having the above.

7. Computer, a data generation unit that references an output format setting master table in which desired headings and items to be included in the financial statement are stored, and generates output work data that includes the input headings and items and an input field for the amount of each item; an update processing unit that refers to journal entry detail data including the amount of each of the items and updates the input field of the amount of the output work data with the amount of the corresponding item; a deletion processing unit that refers to a general master table of items stored for each item, and deletes data related to the items with an amount of 0 yen, which corresponds to the 0 yen printing category indicating that the items with an amount of 0 yen should not be included in the financial statement, from the output work data; an output control unit that outputs the output work data that has been subjected to the deletion process to an output target device; A business support program that functions as a

Images