JP7260590B2 - Financial Accounting Management Device, Financial Accounting Management Method, and Financial Accounting Management Program - Google Patents

Description

The present invention relates to a financial accounting management device, a financial accounting management method, and a financial accounting management program.

There is an accounting task for confirming whether or not the content of journal entries linked from a front system such as a sales system is correct by matching the output content from the front system with the output content from the financial accounting system such as form data.

However, the management items (customer information, project information, product information, segment information, etc.) in the front system vary depending on how the company operates the system and the data structure of the front system. In the construction industry in particular, there is a tendency for the data structure of the front system to become complicated because there are multiple business partners in one project. On the other hand, the financial accounting system can only output the total value for each management item determined by various forms. Therefore, when reconciling various transaction amounts between the financial accounting system side and the front system side, it is necessary to trace the linked data from the front system and aggregate it, and the accounting work for reconciliation and confirmation puts a heavy burden on the person in charge. was

For this reason, there is a demand for a system capable of outputting information, such as form data, from a financial accounting system that can output information organized by combination of classifications of a plurality of accounting management items in addition to account titles. Such a system has not been known so far (Patent Document 1).

JP 2017-72957 A

SUMMARY OF THE INVENTION Accordingly, it is an object of the present invention to provide a system capable of outputting, from a financial accounting system such as form data, information organized by combination of classifications of a plurality of specified accounting management items in addition to account titles.

In order to solve the above-described problems and achieve the object, a financial accounting management device according to the present invention is a financial accounting management device comprising a control unit, wherein the control unit identifies a period to be aggregated and a receiving means for accepting a condition including a plurality of tally identification items different from account items as accounting management items; obtaining form data including amount information corresponding to the tally identification items, account items, dates, and From the form data, for each combination of categories of account items and multiple aggregated identification items, the total amount of previous balance, which is the sum of the amounts up to the day before the target period, and the total accrued amount, which is the sum of the amounts within the target period and a tallying means for tallying the above.

Further, in the financial accounting management device according to the present invention, the control unit displays the previous balance total amount and the accrued total amount for each combination of account items and divisions of each of the plurality of aggregation identification items. It is characterized by further comprising tabulation means for creating a table.

Further, in the financial accounting management device according to the present invention, the conditions to be received by the receiving means further include a priority order of the account items and the tabulation identification items, and the tabulation means selects the account items and the tabulation identification items as the It is characterized by creating a summary table hierarchized in order of priority.

Further, in the financial accounting management apparatus according to the present invention, the conditions received by the receiving means further include an extraction classification range as a range of categories of account items and/or accounting management items that limit a range to be aggregated, and the aggregating means After acquiring the form data, extracts information within the extracted classification range from the form data, and based on the extracted information, the previous balance total amount within the extracted classification range and the extracted classification range and the total amount of money generated.

Further, in the financial accounting management apparatus according to the present invention, the receiving means calls up a list of conditions received by the receiving means in the past and/or conditions specified in advance, and receives specified conditions from the list. It is characterized by

Further, in the financial accounting management apparatus according to the present invention, the totalizing means includes balance data including amount information corresponding to the total identification item, the account item, the balance date, and the total identification item and the account, among the form data. Acquisition of journal data including account items, journal dates, and corresponding amount information, and for classification of account items of assets, liabilities, and net assets, for each combination of account items and categories of each of the plurality of aggregated identification items, the balance Out of the data, extract the balance information including the latest balance date that is closest to the aggregation reference date that is the basis for aggregation, and extract the balance information that is after the latest balance date and the day before the target period from the journal data journal information before the target period including the journal dates up to and including the journal dates within the target period and journal information within the target period including the journal dates within the target period are extracted; The amount of the journal entry information before the target period is added and aggregated, and the total accrued amount is aggregated by adding the amount of the extracted journal entry information within the target period, and the classification of the account items of income and expenses is as follows: Pre-target period journal information including journal dates on or after the aggregation reference date and up to the day before the target period, from the journal data for each combination of account items and categories of each of the plurality of aggregation identification items, and within the target period and the journal information within the target period including the journal date of the target It is characterized by summing up the amount of the journal entry information within the period.

Moreover, the financial accounting management apparatus according to the present invention is characterized in that the conditions to be received by the receiving means further include designation of a totaling reference date as a basis for totaling.

In addition, a financial accounting management method according to the present invention is a financial accounting management method executed in a financial accounting management device having a control unit, wherein a target period to be aggregated and a period to be aggregated executed by the control unit are identified at the time of aggregation. a receiving step for receiving a condition including a plurality of aggregation identification items different from account items as accounting management items; From the data, for each combination of account items and categories of each of the plurality of aggregated identification items, the total amount of the previous balance, which is the total amount up to the day before the target period, and the total accrued amount, which is the total amount within the target period and an aggregating step of aggregating .

Further, a financial accounting management program according to the present invention is a financial accounting management program to be executed by a financial accounting management apparatus having a control unit, and comprises a period to be aggregated and a time of aggregation, which is to be executed by the control unit. a receiving step for accepting a condition including a plurality of tally identification items different from account items as accounting management items to be identified; obtaining form data including amount information corresponding to the tally identification items, account items, dates, and; From the form data, for each combination of categories of the account item and each of the plurality of aggregated identification items, the previous balance total amount, which is the total amount up to the day before the target period, and the accrual total, which is the total amount within the target period and a tallying step of tallying an amount of money.

According to the present invention, it is possible to output, from a financial accounting system such as form data, information that is organized by combination of categories of a plurality of designated accounting management items in addition to account items.

FIG. 1 is a block diagram showing an example of the configuration of the PC 100. As shown in FIG. FIG. 2 is a diagram showing an example of the flow of information processing by the reception unit 102a, totalization unit 102b, and tabulation unit 102c in one embodiment. FIG. 3A is a diagram illustrating an example of a condition input screen for inputting conditions accepted by the accepting unit 102a in one embodiment. The condition input screen in FIG. 3A is an example of an uninput condition input screen. FIG. 3B is a diagram illustrating an example of a condition input screen for inputting conditions accepted by the accepting unit 102a in one embodiment. The condition input screen in FIG. 3B is an example of the condition input screen after partial input. FIG. 3C is a diagram illustrating an example of a condition input screen for inputting conditions accepted by the accepting unit 102a in one embodiment. The condition input screen in FIG. 3C is an example of the condition input screen after partial input. FIG. 3D is a diagram illustrating an example of a condition input screen for inputting conditions accepted by the accepting unit 102a in one embodiment. The condition input screen in FIG. 3D is an example of the condition input screen after partial input. FIG. 4 is a diagram showing an example of a condition calling screen displaying a list of conditions stored in the condition storage unit 106b in one embodiment. FIG. 5 is a diagram showing an example of a condition selection screen for selecting tally identification items and their priority order in the conditions accepted by the accepting unit 102a in one embodiment. FIG. 6 is a diagram showing an example of balance data in one embodiment. FIG. 7 is a diagram showing an example of journal data in one embodiment. FIG. 8 is a diagram illustrating an example of set balance work in one embodiment. FIG. 9 is a diagram showing an example of journal entry detail work in one embodiment. FIG. 10 is a diagram illustrating an example of aggregation work in one embodiment. FIG. 11A is a diagram showing an example of a summary table created by the tabulation unit 102c in one embodiment. FIG. 11B is a diagram illustrating an example of a summary table created by the tabulation unit 102c in one embodiment.

An embodiment of the present invention will be described in detail based on the drawings. In addition, this invention is not limited by this embodiment.

[1. composition]
Here, an example of the configuration of a PC (personal computer) 100 according to this embodiment including the financial accounting management apparatus of the present invention will be described with reference to FIG. The configuration of this embodiment is merely an example, and the present invention is not limited to the configuration of this embodiment. Also, in the following description of the configuration, redundant description may be omitted.

FIG. 1 is a block diagram showing an example of the configuration of the PC 100. As shown in FIG. The PC 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input/output interface unit 108, and is a server 200 that stores various data (for example, data stored in the storage unit 106, which will be described later). (for example, a Web server, etc.) and a network 300 (for example, the Internet, an intranet, a LAN (Local Area Network), etc.) are communicably connected.

Each unit included in the PC 100 is communicably connected via an arbitrary communication path.

Note that the PC 100 may be, for example, a stationary type such as a desktop personal computer, or a portable type such as a notebook personal computer, a PDA (Personal Digital Assistant), a smartphone, or a tablet personal computer. may be

A control unit 102 is a CPU or the like that controls the PC 100 in an integrated manner. The control unit 102 has an internal memory for storing a control program such as an OS, a program defining various processing procedures, required data, and the like, and performs various information processing based on these stored programs. Execute.

The control unit 102 functionally and conceptually includes a reception unit 102a, a tabulation unit 102b, a tabulation unit 102c, and the like.

The receiving unit 102a receives conditions including a target period for aggregation and a plurality of aggregation identification items different from account items as accounting management items to be identified at the time of aggregation. The account item is an accounting management item that is always identified at the time of aggregation. The target period can be a specified period for aggregation, and is accepted in units of days, months, years (fiscal years), etc., for example. Accounting management items can be management items in a general financial accounting management system, for example, in addition to account items, items such as office, department, department, employee, business partner, project, partner system, etc. can be mentioned. .

The conditions accepted by the accepting unit 102a further include the order of priority of account items and total identification items. The order of priority is the order of priority of account items and a plurality of tally identification items for hierarchization in the hierarchized summary table created by the table creation unit 102c described below. In addition, it may be set in advance that the account item is given the highest priority in the priority order of the account item and the total identification item. In this case, the order of priority is the order of priority after the account items. Also, the order of priority of account items and total identification items may be preset and fixed.

The conditions accepted by the accepting unit 102a further include an extraction category range as a category range of account items and/or accounting management items that limits the range of aggregation. The extracted segment range can be the range of items aggregated by the aggregation unit 102b described below, or the range of items displayed in the aggregation table created by the tabulation unit 102c described below. The extraction segment range is not limited to one continuous range, and may be a plurality of discontinuous ranges. Also, the extraction segment range may be a single segment. It should be noted that the specification of the extraction segment range is optional, and in cases such as when it is desired to aggregate the entire range without limiting the extraction segment range, it is not necessary to specify the extraction segment range without including it in the extraction segment range in the conditions received by the reception unit 102a. Alternatively, instead of the extraction segment range, a designation of the total range as the entire range may be included. Moreover, a specific extraction segment range may be set in advance and fixed.

The conditions accepted by the accepting unit 102a further include designation of a tallying reference date as a standard for tallying. The aggregation reference date is, for example, the date of the beginning of the aggregation (tabulation) that serves as the basis for aggregation (or tabulation). The counting reference date may be the same day as the beginning of the accounting period, or may be a different day. A specific date may be preset and fixed as the aggregation reference date.

The accepting unit 102a calls up a list of conditions accepted in the past by the accepting unit 102a and/or conditions specified in advance, and accepts conditions specified from the list. The list may include conditions such as target period, aggregation identification item, priority order, extraction category range, and the like.

The tallying unit 102b acquires form data including tally identification items, account items, dates, and corresponding amount information (information on credit amounts or debit amounts corresponding to the account items for each date), and from the form data, the account items And for each combination of categories of each of the plurality of aggregated identification items, the total amount of money remaining before the target period, which is the total amount up to the day before the target period, and the total accrued amount, which is the total amount of money within the target period, are aggregated.

The tabulation unit 102b further calculates the total balance amount as the sum of the previous balance total amount and the accrued total amount tabulated by the tabulation unit 102b for each combination of categories of account items and a plurality of tabulation identification items.

When the condition received by the receiving unit 102a includes the extraction classification range (when the extraction classification range is set in advance), the aggregating unit 102b obtains the information within the extraction classification range from the form data (extraction classification range) after obtaining the form data. information) is extracted, and based on the extracted information (extracted category information), the total amount of money remaining in the extracted category range and the total amount of accrued money within the extracted category range are aggregated. If the condition received by the receiving unit 102a does not include the extracted segment range, the totalizing unit 102b counts the entire segment range of the information of the form data.

The tallying unit 102b
Of the form data,
balance data including summary identification items, accounts, balance dates and corresponding amount information;
journal data including summary identification items, account titles, journal dates and corresponding amount information;
and get
For the classification of assets (e.g. accounts receivable), liabilities (e.g. accounts payable) and net assets (e.g. capital),
For each combination of categories of accounts and multiple aggregate identification items,
From the balance data, extract the balance information including the latest balance date that is closest to the aggregation reference date that is used as the aggregation reference date,
Extracting journal information before the target period including journal dates after the latest balance date and up to the day before the target period and journal information within the target period including journal dates within the target period from the journal data;
Aggregate the previous balance total amount by adding the extracted amount of balance information and the extracted amount of journal entry information before the target period,
Aggregate the total amount of money generated by summing the amount of the extracted journal information within the target period,
Regarding the classification of accounts for income (e.g. sales) and expenses (e.g. purchases),
For each combination of categories of accounts and multiple aggregate identification items,
Among the journal data, pre-target period journal information including journal dates after the collection reference date (that is, acquisition period start date) and up to the day before the target period, journal information within the target period including journal dates within the target period, and and extract
Aggregate the previous balance total amount by adding up the amount of the extracted journal entry information before the target period,
Aggregate the total amount of money generated by summing the amount of extracted journal entry information within the target period.

The tallying unit 102b
When the condition received by the receiving unit 102a includes an extraction segment range (when the extraction segment range is set in advance),
After obtaining journal data and balance data out of the form data,
extracting balance data information (balance data extraction classification information) within the extraction classification range accepted by the reception unit 102a from the balance data;
From the journal data, extract the information of the journal data (extraction classification information of the journal data) within the extraction classification range accepted by the reception unit 102a,
For the classification of assets (e.g. accounts receivable), liabilities (e.g. accounts payable) and net assets (e.g. capital),
For each combination of categories of accounts and multiple aggregate identification items,
From the balance data extraction category information, extract the extraction category balance information that includes the latest balance date that is closest to the aggregation reference date that is used as the basis for aggregation,
From the extracted classification information of the journal data, the extracted classification before the target period journal information including the journal dates after the latest balance date and up to the day before the target period, and the extracted classification within the target period journal information including the journal dates within the target period , and
Aggregate the previous balance total amount by adding the extracted amount of the extracted classification balance information and the extracted amount of the extracted classification target period previous journal information,
Aggregate the total amount incurred by adding the amount of journal information within the extracted classification target period,
Regarding the classification of accounts for income (e.g. sales) and expenses (e.g. purchases),
For each combination of categories of accounts and multiple aggregate identification items,
From the extracted classification information of the journal data, the extraction classification including the journal entry date after the aggregation base date (that is, the acquisition period start date) and up to the day before the target period, and the journal entry information including the journal entry date within the target period Extract the journal entry information within the target period,
Aggregate the previous balance total amount by adding up the amount of journal entry information before the extracted classification target period,
Aggregate the total amount of money generated by summing the amount of journal entry information within the extracted segment target period.

The tabulation unit 102c creates a tabulation table that displays the previous balance total amount and the accrued total amount for each combination of categories of account items and a plurality of tabulation identification items.

The tabulation table created by the tabulation unit 102c further displays the balance total amount as the sum of the previous balance total amount and the accrued total amount for each combination of categories of account items and a plurality of tabulation identification items.

When the conditions received by the receiving unit 102a include the order of priority (when the order of priority is set in advance), the tabulation unit 102c creates a tabulation table in which account items and tabulation identification items are layered in order of priority.

The summary table created by the tabulation unit 102c is first divided into 1 or 2 or more categories belonging to the highest priority item, and each of the 1 or 2 or more divided categories belongs to the next priority item. It may be divided into one or more divisions, and may be further divided into smaller divisions in accordance with the order of priority. As an example, there are two types of tally identification items received by the receiving unit 102a aside from account items, and the order of priority is the account item, the first priority item, and the second priority item. If there are only categories, three categories of category A, category B, and category C as the first priority items, and three categories of category a, category b, and category c as the second priority items, the summary table created by the tabulation unit 102c First, division α is divided into division A, division B, and division C, and each of the divisions is further subdivided into division a, division b, and division c as long as combinations exist. can be in a specified format. Also, the hierarchical structure is not limited to three layers, and if there are three types, four types, or more of total identification items received, they can be divided into four layers, five layers, or more.

The hierarchical summary table created by the tabulation unit 102c may display the sum of the previous balance total amount, accrued total amount, and balance total amount for each category of the highest priority item. In addition, the hierarchical summary table created by the table creation unit 102c includes the previous balance total amount, the accrued total amount, and the balance total for each category of intermediate priority items (items that are neither the highest priority items nor the lowest priority items). The sum of each amount may be displayed.

The tabulation table created by the tabulation unit 102c can be output by being visualized by, for example, display by a display device such as a display or a projector, or printing on paper by a printing device such as a printer.

The communication interface unit 104 communicably connects the PC 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with another device via a communication line.

The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 stores a computer program for performing various processes by giving commands to a CPU (Central Processing Unit) in cooperation with an OS (Operating System). As the storage unit 106, for example, memory devices such as RAM (Random Access Memory) and ROM (Read Only Memory), fixed disk devices such as hard disks, flexible disks, and optical disks can be used.

The storage unit 106 conceptually includes a form data storage unit 106a, a condition storage unit 106b, and the like.

The form data storage unit 106a stores form data including total identification items, account items, dates, and corresponding amount information. The form data includes balance data including total identification items, account items, balance dates, and corresponding amount information, and journal data including total identification items, account items, journal dates, and corresponding amount information.

The condition storage unit 106b stores a list of conditions accepted in the past by the acceptance unit 102a and/or conditions specified in advance.

An input device 400 and an output device 500 are connected to the input/output interface unit 108 . The output device 400 includes a display device such as a display and a projector, a sound device such as a speaker, a printing device such as a printer, and a device capable of being downloaded in a data file format. As the data file format, a file format known in the art such as PDF, CSV, document file, spreadsheet software file, text file, etc. can be adopted. The input device 500 can use a keyboard, a mouse, a microphone, and a monitor that realizes a pointing device function in cooperation with the mouse.

[2. Concrete example]
Here, using a specific example, the information processing by the reception unit 102a, totalization unit 102b, and tabulation unit 102c in the financial accounting management apparatus according to the present invention will be described with reference to FIGS. 2 to 11B.

FIG. 2 is a diagram showing an example of the flow of information processing by the reception unit 102a, totalization unit 102b, and tabulation unit 102c in this specific example.

As shown in FIG. 2, in this specific example, first, the reception unit 102a receives conditions including a target period for aggregation, aggregation identification items, and the like, together with a calculation instruction, via a condition input screen (S01). Next, the tallying unit 102b acquires the form data including the tallying identification item, the account item, the date, and the corresponding amount information from the form data storage unit 106a (S02). Next, when the condition received by the receiving unit 102a includes an extracted segment range, information (extracted segment information) within the extracted segment range is extracted from the form data (S03). Next, the previous balance total amount and the accrued total amount are totaled (S04). The tabulation unit 102c creates a tabulation table displaying the previous balance total amount and the accrued total amount by hierarchizing the tabulation identification items in order of priority for each combination of categories of each of the plurality of tabulation identification items (S05). .

3A to 3D are diagrams showing examples of condition input screens (condition input screens for creating an integrated summary table) for inputting conditions accepted by the accepting unit 102a in this specific example. FIG. 3A is an example of a condition input screen with no input, and FIGS. 3B and 3D are examples of a condition input screen after partial input.

In the condition input screens 10 to 13 shown in FIGS. 3A to 3D, as mandatory acceptance items, the aggregation reference date (beginning of the tabulation) 1a as the basis for aggregation, as mandatory acceptance items, the target period 1b to be aggregated, optional Specified range (extraction category range) 1c for limiting the category to be aggregated for the accounting management item "office" as a reception item, extraction category range 1d for the accounting management item "department" as an optional reception item, optional reception item as an extraction category range 1e for the accounting control item "account", an extraction category range 1f for the accounting control item "business partner" as an optional acceptance item, an extraction category for the accounting control item "project" as an optional acceptance item Range 1g, as an optional reception item, an extraction classification range 1h for the accounting management item "collaborating source system", as a mandatory reception item, as an accounting management item to be identified at the time of aggregation, specify multiple aggregation identification items different from account items It is possible to accept a condition consisting of specification of the order of priority of the aggregation identification items (aggregation condition specification) 1i.

When the "call condition" button 1j below the condition input screens 10-13 shown in FIGS. 3A-3D is pressed, the reception unit 102a outputs the condition call screen. When the "save conditions" button 1k is pressed, the reception unit 102a receives the conditions input on the condition input screen and the instruction to save the conditions, and stores the conditions in the condition storage unit 106b. It should be noted that the "Condition Save" button 1k cannot be pressed if neither the mandatory reception item nor the optional reception item is entered. When the "calculate" button 1l is pressed, the reception unit 102a receives the conditions and calculation instructions input to the condition input screen. It should be noted that the "calculate" button 1l cannot be pressed if all of the required reception items have not been entered. When the "cancel" button 1m is pressed, the condition input screens 10-13 are closed and the acceptance is cancelled.

FIG. 4 is a diagram showing an example of a condition calling screen displaying a list of conditions stored in the condition storage unit 106b in this specific example. When the "call" button 2c at the bottom of the condition call screen 20 shown in FIG. Based on this, a condition input screen in which the conditions have been input is output to a condition input screen in which the conditions have not been input. The "call" button 2c cannot be pressed if no conditions are specified. When the "Cancel" button 2d is pressed, the condition call screen 20 is closed and the condition call is cancelled.

FIG. 5 is a diagram showing an example of a condition selection screen for selecting aggregate identification items of conditions to be accepted by the accepting unit 102a in this specific example and their priority order. In the condition selection screen 30 shown in FIG. 5, the list 3a on the left is a list displaying the accounting management items of the candidates for the total identification item, and the list 3b on the right displays the selected total identification items in order of priority from the top. Here is a list. Select an accounting management item from the list 3a on the left and operate the selection operation button 3c to display the identification items in order of priority in the list 3b on the right, or conversely, aggregate from the list 3b on the right. Select an accounting management item that is not to be used as an identification item, and operate the selection operation button 3c to delete it. After selecting a tabulation identification item in the list 3b on the right side and displaying the tabulation identification items in order of priority from the top, when the "Select" button 3d is pressed, the reception unit 102a selects the tabulation identification item based on the selected tabulation identification item and its priority order. to output a condition input screen in which the total identification item and the priority order are input for the uninput condition input screen. When the "close" button 3e is pressed, the condition selection screen 30 is closed and the selection of the total identification items and their priority order is cancelled.

FIG. 6 is a diagram showing an example of balance data in this specific example. The balance data 40 shown in FIG. Information 4a and 4b (information other than these is omitted) is included for each item of "set balance" which is amount information and "set balance date" which is date information of balance date.

FIG. 7 is a diagram showing an example of journal data in this specific example. The journal data 50 shown in FIG. 7 includes "occurrence date" which is date information of the journal date, and accounting management items such as "office", "department", "account item", "customer", "project", and "linkage source system", and each item of "amount" which is amount information corresponding to the account item, each of information 5a to 5h (information other than these is omitted) is included.

FIG. 8 is a diagram showing an example of set balance work in this specific example. The set balance work 60 shown in FIG. Set balance work information 6a and 6b (information other than these is omitted) is included for each item of "previous balance" which is money amount information.

FIG. 9 is a diagram showing an example of journal entry detail work in this specific example. The journal entry detail work 70 shown in FIG. Each journal detail work information 7a to 7d (information other than these is omitted) is included for each item of "amount accrued" which is the amount information.

FIG. 10 is a diagram showing an example of tabulation work in this specific example. The aggregation work 80 shown in FIG. 10 includes the accounting management items "office", "department", "account item", "customer", "project", and "collaborating source system", and each set balance work. The same "previous balance" as the information 6a and 6b, the same "accrued amount" as the journal entry detail work information 7a-7d, and the "balance , each item of total work information 8a to 8d (information other than these is omitted) is included.

11A and 11B are diagrams showing an example of a tabulation table created by the tabulation unit 102c in this specific example. In the summary table 90 shown in FIG. 11A, the account item 9a is given the highest priority, and the categories are hierarchized in the order of the total identification item project item 9b and the customer item 9c. The amount of the previous balance total amount (previous balance) of the tabulation work information 8a to 8d in the line of the item 9d of the previous balance, the total amount of accrued amount (amount of accrual) of the tabulation work information 8a to 8d in the line of the accrued amount item 9e, and the balance In the row of the item 9f of , the total balance amount (balance) of the total work information 8a to 8d is displayed, and further, the total for each category of the item 9b of the project is displayed. In the summary table 90' shown in FIG. 11B, the account item 9a' is given the highest priority, and the categories are hierarchized in the order of the summary identification item customer item 9b' and the project item 9c'. For each combination, the amount of the total amount of work information 8a to 8d (previous balance) in the row of the item 9d' of the previous balance, and the total amount of accrued work information 8a to 8d in the line of the item 9e' of the accrued amount (amount generated) and the total balance amount (balance) of total work information 8a to 8d are displayed in the row of item 9f of the balance, and further, the total for each category of item 9b' of the customer is displayed.

First, on the condition input screen 10 shown in FIG. 3A, the reception unit 102a selects, as mandatory reception items, the aggregation reference date (beginning of the chart) 1a, the target period 1b, and the account items as accounting management items to be identified at the time of aggregation. In addition to the specification of multiple aggregation identification items and the specification of the priority of the aggregation identification items (aggregation condition specification) 1i, the conditions of each item are accepted based on the contents entered in each item, and furthermore, optional acceptance As items, at least one of the extraction classification ranges 1c to 1h for the accounting management items "office", "department", "account item", "business partner", "project", and "collaborating source system" , the condition of the input item is accepted based on the content (S01).

An example of an input method for items on the condition input screen 10 shown in FIG. 3A will be described.

When the search button (the magnifying glass mark at the left end of the blank in the item of the aggregation condition specification 1i) on the condition input screen 10 shown in FIG. 3A is pressed, the reception unit 102a displays the condition call screen shown in FIG. 30 is output. In the list 3a on the left side of the condition selection screen 30, the accounting management items of the total identification item candidates are displayed. As an example, the list 3a on the left side displays a list similar to the conditional call screen 30 shown in FIG. When specifying that it is "business partner" and that the priority order of the aggregation identification item is "project" and then "business partner", first, select "project" from the list 3a on the left and press the selection operation button 3c. to display "1: Project" at the top of the list 3b on the right, then select "Supplier" from the list 3a on the left, operate the selection button 3c, "2: Customer" is displayed below "1: Project" in 3b to make a screen similar to the condition call screen 30 shown in FIG. After that, when the "Select" button 3d is pressed, the reception unit 102a selects "project" and "business partner" as the total identification items, and sets the priority order of the total identification items to "project" and "business partner". Receives the designation that there is, and outputs a condition input screen in which "project-client" is displayed in the tabulation condition specification 1i of the tabulation identification item that was blank on the condition input screen 10 shown in FIG. 3A (Fig. omitted).

Another example of the input method to the items of the condition input screen 10 shown in FIG. 3A will be described.

When the "call condition" button 1j on the condition input screen 10 shown in FIG. 3A is pressed, the reception unit 102a outputs the condition call screen 20 shown in FIG. The condition call screen 20 displays a list of conditions 2a and 2b that the reception unit 102a has received in the past together with a calculation instruction or a condition storage instruction and stored in the condition storage unit 106b.

Condition 2a of "[PJ management] (accounts payable) project - supplier" in the list on the condition call screen 20 shown in FIG. , the extraction classification range for the accounting management item "collaboration source system" is "PJ management", the aggregation identification items are "project" and "business partner", and the priority order of the aggregation identification items is "project", " It is a condition that specifies that the order is "customers".

Condition 2b of "[PJ management] (Accounts payable) Office-Project" in the list on the condition call screen 20 shown in FIG. The extraction classification range for the management item "collaborating source system" is "project management", the aggregation identification items are "office" and "project", and the priority order of the aggregation identification items is "office", "project " is the condition that specifies that the order is

After the condition 2a of "[PJ management] (accounts payable) project - supplier" is specified on the condition call screen 20 shown in FIG. As shown in FIG. 3B, with respect to the condition input screen 10 shown in FIG. The condition input screen 11 is output with "project management" entered in the range 1g and "project-client" (specification of aggregation identification item and priority order) in the aggregation condition specification 1i of the aggregation identification item.

Note that, for example, at the stage where the condition 2a of "[PJ management] (accounts payable) project - supplier" is not yet stored in the condition storage unit 106b, the reception unit 102a conversely enters the condition shown in FIG. 3B. After input as shown in screen 11, when the "save condition" button 1k is pressed, the instruction to save the condition 2a is accepted, the condition 2a is stored in the condition storage unit 106b, and the condition call screen is displayed from the next time onwards. The condition 2a is displayed in the list.

In addition to the condition input screen 11 shown in FIG. 3B, the reception unit 102a sets the total reference date (beginning of the tabulation) 1a as a standard for totaling, as in the condition input screen 12 shown in FIG. 3C. Enter "2021/4/1", "2021/5/1" to "2021/5/31" in the aggregation target period 1b, and "000 Tokyo head office" in the extraction classification range 1c for the accounting management item "office" After that, when the "calculate" button 1l is pressed, the aggregation reference date (the beginning of the tabulation) that is the basis for aggregation is "April 1, 2021", and the target period for aggregation is "May 2021 1st to May 31, 2021", extraction category range is "000 Tokyo head office (office)", "accounts payable (account item)", "project management (collaboration source system)", aggregation identification item is "project ' and 'business partner', and the condition that the priority order of the aggregate identification items is 'project' and 'business partner' is received together with the calculation instruction (S01).

After the reception unit 102a receives the conditions and the calculation instruction, the totalization unit 102b converts the balance shown in FIG. The balance data 40 including the date (set balance date) and the journal data 50 including the journal date (occurrence date) shown in FIG. 7 are obtained from the form data storage unit 106a (S02).

Aggregation unit 102b next selects the division of "000 Tokyo head office" as the office within the extraction division range received by reception unit 102a from the balance data 40 shown in FIG. 6 as information within the extraction division range. Extracting the balance data extraction classification information 4a and 4b including all the classifications of "accounts payable" as the account item and "project management" as the project, and from the journal data 50 shown in FIG. Extracted classification information 5a of journal data that includes all of the classification of "000 Tokyo head office" as the office, the classification of "Accounts payable" as the account item, and the classification of "PJ management" as the project within the accepted extraction classification range. ~5h is extracted (S03).

Since the extraction classification range of the "account item" accepted by the reception unit 102a is "accounts payable" (debt), the totalization unit 102b calculates balance data 40 shown in FIG. From the extracted category information 4a and 4b, the latest balance date (set balance date) “March 31, 2021” that is closest to the aggregation reference date (beginning of the chart) “April 1, 2021” before the aggregation reference date Extract the latest extracted category balance information 4a and 4b including "day", and select the latest balance date (set balance date) "March 31, 2021" from the extracted category information 5a to 5h of the journal data 50 shown in FIG. date” and the day before the target period “April 30, 2021”, including the journal entry information 5a and 5b before the target period, and “May 1, 2021 to May 31, 2021” within the target period Extract the journal entry information 5c to 5h within the extraction classification target period including the journal entry date of "day".

Next, the tabulation unit 102b calculates the total amount of previous balance for each combination of the tabulation identification items by combining the amounts of the extracted extracted partitioned balance information 4a and 4b and the extracted extracted partition target period previous journal information 5a and 5b. , and are aggregated to form set balance work information 6a and 6b in the set balance work 60 shown in FIG. 7a to 7d in the journalizing detail work 70 shown in FIG. 9 (S04).

Aggregation unit 102b next generates set balance work information 6a and 6b in set balance work 60 shown in FIG. 8 and journal specification work information in journal specification work 70 shown in FIG. Summarize the information 7a to 7d, calculate the sum of the total amount of the previous balance (previous balance) of the set balance work information 6a and 6b and the total amount of accrued amount (amount of accrual) of the journal detail work information 7a to 7d, and calculate the total balance. Assume that total work information 8a to 8d shown in FIG. 10 are used as amounts (balances).

Based on the tabulation work information, the tabulation unit 102c creates a tabulation table that displays the total balance amount (previous balance), the total accrued amount (accrued amount), and the total balance amount (balance). are created by hierarchizing the aggregation identification items in order of priority for each combination of categories of each of the plurality of aggregation identification items (S05). In the financial accounting management apparatus of this specific example, the order of priority is set in advance so that the account items are given the highest priority with respect to the total identification items ("project" and "customer").

In this specific example, based on the condition that the priority order of the aggregate identification items is "project" and then "business partner", the tabulation unit 102c, as shown in FIG. 11A, , account item 9a, project item 9b, and client item 9c, and for each combination of item categories, the total shown in FIG. In the row of the item 9e of the total amount of money outstanding (previous balance) and the amount of money generated in the total work information 8a to 8d in the work 80 , the total balance amount (balance), which is the sum of the previous balance total amount and the accrued total amount of the total work information 8a to 8d, is displayed, and furthermore, the project item, which is the second priority item for the account item 9a, is displayed. A summary table 90 is created by displaying the total of the previous balance, accrued amount, and balance for each category of item 9b (S05).

As a specific example different from the above specific example, the priority order of the aggregate identification items is set to "project", "transaction In the specific example in which the receiving unit 102a receives the calculation instruction and the condition that the order of "customers" and "projects" instead of the order of "customers" is the same as the specific example described above, the totalizing unit 102b As shown in FIG. 11B, the tabulation unit 102c, as shown in FIG. The categories are hierarchized in the order of item 9c' of the project, and for each combination of categories of each item, in the row of item 9d' of the previous period's balance, before the aggregation work information 8a to 8d in the aggregation work 80 shown in FIG. Displaying the amounts of accrued amounts of total work information 8a to 8d in the row of remaining amount and accrued amount item 9e', and displaying the amount of balance of total work information 8a to 8d in the line of balance item 9f', Further, for each item 9a' of the account item 9a', the total of the previous balance, the accrued amount, and the balance are displayed for each category of the item 9b' of the customer, which is the second priority item, to create a summary table 90'. .

As described above, the financial accounting management apparatus of the present invention can output information such as form data from the financial accounting system that is organized by combination of classifications of a plurality of designated accounting management items in addition to account titles.

[3. Contribution to the Sustainable Development Goals (SDGs) led by the United Nations]
Since this embodiment can contribute to improving operational efficiency and promoting appropriate management decisions of companies, it is possible to contribute to Goals 8 and 9 of the SDGs.

In addition, the present embodiment can contribute to the reduction of disposal loss and the promotion of paperless and computerization.

In addition, since this embodiment can contribute to strengthening control and governance, it is possible to contribute to Goal 16 of the SDGs.

[4. Other embodiments]
Although the embodiments of the present invention have been described so far, the present invention may be implemented in various different embodiments other than the above-described embodiments within the scope of the technical idea described in the claims. is.

For example, among the processes described in the above embodiments, all or part of the processes described as being performed automatically can be manually performed, or the processes described as being performed manually can also be performed automatically by known methods.

In addition, unless otherwise specified, the processing procedures, control procedures, specific names, information including parameters such as registration data and search conditions for each process, screen examples, and database configurations shown in the above documents and drawings can be changed arbitrarily.

Also, with respect to the PC 100, each component shown in the drawing is functionally conceptual, and does not necessarily need to be physically configured as shown in the drawing.

For example, all or any part of the processing functions provided by each device constituting the PC 100, particularly each processing function performed by the control unit, is implemented by a CPU and a program interpreted and executed by the CPU. Alternatively, it may be implemented as hardware using wired logic. The program is recorded on a non-temporary computer-readable recording medium containing programmed instructions for causing the information processing device to execute the processing described in the present embodiment, and is stored in each device as necessary. read mechanically. That is, a storage unit such as a ROM or HDD (Hard Disk Drive) stores a computer program for giving commands to the CPU in cooperation with the OS to perform various processes. This computer program is executed by being loaded into the RAM and constitutes a control section in cooperation with the CPU.

Also, this computer program may be stored in an application program server connected to the PC 100 via any network, and it is possible to download all or part of it as required.

Also, the program for executing the processing described in the present embodiment may be stored in a non-temporary computer-readable recording medium, and may be configured as a program first product. Here, the term "recording medium" refers to memory cards, USB (Universal Serial Bus) memories, SD (Secure Digital) cards, flexible disks, magneto-optical disks, ROMs, EPROMs (Erasable Programmable Read Only Memory), EEPROMs (registered (trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magneto-Optical disk), DVD (Digital Versatile Disk), and Disc (registered trademark) such as Blu- shall include any "portable physical medium".

A "program" is a data processing method written in any language or writing method, regardless of the format such as source code or binary code. In addition, the "program" is not necessarily limited to a single configuration, but is distributed as multiple modules or libraries, or cooperates with a separate program represented by the OS to achieve its function. including things. It should be noted that well-known configurations and procedures can be used for the specific configuration and reading procedure for reading the recording medium in each device shown in the embodiments, the installation procedure after reading, and the like.

The various databases stored in the storage unit are storage means such as memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks. It stores programs, tables, databases, files for web pages, and so on.

Further, the PC 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device to which arbitrary peripheral devices are connected. Also, the PC 100 may be implemented by installing software (including programs, data, etc.) that causes the PC 100 to implement the processing described in the present embodiment.

Furthermore, the specific forms of distribution and integration of devices are not limited to those shown in the figures, and all or part of them can be functionally or physically arranged in arbitrary units according to various additions or functional loads. It can be distributed and integrated. In other words, the embodiments described above may be arbitrarily combined and implemented, or the embodiments may be selectively implemented.

INDUSTRIAL APPLICABILITY The present invention is useful for financial accounting management work in the construction industry, etc., where it is necessary to rearrange financial accounting system information, such as form data, by combining complex accounting management items such as projects and business partners.

100 PCs
102 control unit 102a reception unit 102b aggregation unit 102c tabulation unit 104 communication interface unit 106 storage unit 106a form data storage unit 106b condition storage unit 108 input/output interface unit 200 server 300 network 400 input device 500 output device

Claims (7)

A financial accounting management device comprising a control unit,
The control unit
Receiving means for receiving conditions including a period to be aggregated and a plurality of aggregation identification items different from account items as accounting management items to be identified at the time of aggregation ;
obtaining form data including aggregate identification items, account items, dates, and corresponding amount information ; extracting form data corresponding to conditions accepted by said receiving means from said form data; Aggregating the previous balance total amount, which is the total amount up to the day before the target period, and the accrued total amount, which is the total amount within the target period, for each combination of account items and categories of each of the plurality of aggregation identification items aggregating means for
characterized by comprising
The counting means is
Among the extracted form data,
balance data including the aggregate identification item, account item, balance date and corresponding amount information;
Journal data including the aggregate identification item, the account item, the journal date, and the corresponding amount information;
and get
Regarding the classification of accounts for assets, liabilities and net assets,
For each combination of categories of accounts and multiple aggregate identification items,
Out of the balance data, closest to the aggregation reference date that is based on the specification of the aggregation reference date included in the condition received by the reception means or based on the aggregation reference date that is set in advance. Extract balance information including latest balance date,
Extracting journal information before the target period including journal dates after the latest balance date and up to the day before the target period and journal information within the target period including journal dates within the target period from the journal data;
Aggregating the previous balance total amount by summing the extracted amount of the balance information and the extracted amount of the journal information before the target period,
Aggregate the total amount of money generated by summing the amount of the extracted journal entry information within the target period,
Regarding the classification of accounts for income and expenses,
For each combination of account items and divisions of each of the plurality of aggregated identification items,
extracting from the journal data pre-target period journal information including journal dates after the aggregation reference date and up to the day before the target period and journal information within the target period including journal dates within the target period;
Aggregating the previous balance total amount by summing the amount of the extracted journal information before the target period,
Aggregate the total accrued amount by summing the amount of extracted journal entry information within the target period
A financial accounting management device characterized by : The control unit
The claim further comprising tabulation means for creating a tabulation table that displays the previous balance total amount and the accrued total amount for each combination of account items and divisions of each of the plurality of tabulation identification items. 2. The financial accounting management device according to 1. The conditions to be accepted by the accepting means further include the order of priority of account items and the aggregate identification items,
3. The financial accounting management apparatus according to claim 2, wherein said tabulation means prepares a tabulation table in which account items and tabulation identification items are hierarchized in the order of priority. The conditions accepted by the accepting means further include an extraction category range as a category range of account items and/or accounting management items that limits the range of aggregation,
After acquiring the form data, the totalizing means extracts information within the extracted classification range from the form data, and based on the extracted information, the previous balance total amount within the extracted classification range and the extraction 4. The financial accounting management device according to any one of claims 1 to 3, wherein the total amount of money generated within the classification range and the total amount of money generated are aggregated. 5. The method according to any one of claims 1 to 4, characterized in that said accepting means calls up a list of conditions accepted by said accepting means in the past and/or conditions specified in advance, and accepts conditions specified from the list. 1. The financial accounting management device according to 1. A financial accounting management method executed in a financial accounting management device comprising a control unit,
executed by the control unit;
a receiving step of receiving a condition including a period to be aggregated and a plurality of aggregation identification items different from account items as accounting management items to be identified at the time of aggregation ;
obtaining form data including aggregate identification items, account items, dates, and corresponding amount information , extracting form data corresponding to the conditions accepted in the receiving step from the form data, extracting form data from the extracted form data, Aggregating the previous balance total amount, which is the total amount up to the day before the target period, and the accrued total amount, which is the total amount within the target period, for each combination of account items and categories of each of the plurality of aggregation identification items an aggregation step that
characterized by comprising
The aggregation step includes:
Among the extracted form data,
balance data including the aggregate identification item, account item, balance date and corresponding amount information;
Journal data including the aggregate identification item, the account item, the journal date, and the corresponding amount information;
and get
Regarding the classification of accounts for assets, liabilities and net assets,
For each combination of categories of accounts and multiple aggregate identification items,
Out of the balance data, closest to the aggregation reference date that is based on the specification of the aggregation reference date included in the condition received in the reception step or based on the aggregation reference date that is set in advance. Extract balance information including latest balance date,
Extracting journal information before the target period including journal dates after the latest balance date and up to the day before the target period and journal information within the target period including journal dates within the target period from the journal data;
Aggregating the previous balance total amount by summing the extracted amount of the balance information and the extracted amount of the journal information before the target period,
Aggregate the total amount of money generated by summing the amount of the extracted journal entry information within the target period,
Regarding the classification of accounts for income and expenses,
For each combination of categories of accounts and multiple aggregate identification items,
extracting from the journal data pre-target period journal information including journal dates after the aggregation reference date and up to the day before the target period and journal information within the target period including journal dates within the target period;
Aggregating the previous balance total amount by summing the amount of the extracted journal information before the target period,
Aggregate the total accrued amount by summing the amount of extracted journal entry information within the target period
A financial accounting management method characterized by : A financial accounting management program to be executed by a financial accounting management device having a control unit,
for causing the control unit to execute
a receiving step of receiving a condition including a period to be aggregated and a plurality of aggregation identification items different from account items as accounting management items to be identified at the time of aggregation ;
obtaining form data including aggregate identification items, account items, dates, and corresponding amount information , extracting form data corresponding to the conditions accepted in the receiving step from the form data, extracting form data from the extracted form data, Aggregating the previous balance total amount, which is the total amount up to the day before the target period, and the accrued total amount, which is the total amount within the target period, for each combination of account items and categories of each of the plurality of aggregation identification items an aggregation step that
characterized by comprising
The aggregation step includes:
Of the extracted form data,
balance data including the aggregate identification item, account item, balance date and corresponding amount information;
Journal data including the aggregate identification item, the account item, the journal date, and the corresponding amount information;
and get
Regarding the classification of accounts for assets, liabilities and net assets,
For each combination of categories of accounts and multiple aggregate identification items,
Out of the balance data, closest to the aggregation reference date that is based on the specification of the aggregation reference date included in the condition received in the reception step or based on the aggregation reference date that is set in advance. Extract balance information including latest balance date,
Extracting journal information before the target period including journal dates after the latest balance date and up to the day before the target period and journal information within the target period including journal dates within the target period from the journal data;
Aggregating the previous balance total amount by summing the extracted amount of the balance information and the extracted amount of the journal information before the target period,
Aggregate the total amount of money generated by summing the amount of the extracted journal entry information within the target period,
Regarding the classification of accounts for income and expenses,
For each combination of categories of accounts and multiple aggregate identification items,
extracting from the journal data pre-target period journal information including journal dates after the aggregation reference date and up to the day before the target period and journal information within the target period including journal dates within the target period;
Aggregating the previous balance total amount by summing the amount of the extracted journal information before the target period,
Aggregate the total accrued amount by summing the amount of extracted journal entry information within the target period
A financial accounting management program characterized by :

Images