JPH0721261A - Device for checking compatibility of management control data - Google Patents

Abstract

PURPOSE:To easily, speedily and appropriately check the compatibility of various kinds of management control data even by a person with little management knowledge in a management control system. CONSTITUTION:This device is constituted of an input part 3 which inputs instruction information for processing data of a management control database where various kinds of management control data in an optical period are time- sequentially stored with an input device 2 so as to store it in an account title information table 7, a compatibility checking part 4 which retrieves the management control database 1 in accordance with processing instruction information stored in the account title information table 7, respectively sums-up financial system data and sales system data and executes the comparison of an item with which a value has to be coincident so as to detects data contradiction, a check result output part 5 which executes the edition of a compatibility judgement result being the processing result of the compatibility checking part 4 and data concerning compatibility into an output form and an output device 8 which outputs data edited by the check result output part 5.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention holds a financial database and a sales database in chronological order in the same system, and judges the consistency of various business management data at each point in time and detailed information on the consistency. The present invention relates to a business management data consistency check device that provides

[0002]

2. Description of the Related Art In general corporate management, since a department that performs financial management is different from a department that performs sales management, financial data and sales data are often EDP managed by different business systems. Nevertheless, there are many common data items in financial databases and sales databases, and they must be consistent.
However, as mentioned above, since the financial database and the sales database are managed by different systems, data inconsistency may occur, and it is necessary to check the consistency between the databases.

As described in the "In-Store Registration Handbook" (edited by Deloitte Touche Tohmatsu, Chuo Keizai), a sales management system usually focuses on ordering, allocation, shipping instructions, sales, etc. Since the management of collection / accounts receivable is not linked to the sales / collection / accounts receivable of the financial management system, the account items set in the financial management system often do not match the account items set in the sales management system. At that time, the correspondence between the financial management account item and the sales management account item is very complicated. In addition, the financial management system and the sales management system may have different periods and timings for recording various data. Furthermore, since a large amount of financial information and sales information is generated in corporate activities, the scale of the financial database and the sales database is extremely large.

Conventionally, in order to check the consistency between the financial data and the sales data having such a property, not the individual account items but the total sum of the amounts of the account items is manually calculated, It was common to compare them and check for consistency.

[0005]

In the consistency check for calculating the balance by summing the amounts of the account items by the above-mentioned manual work, the amount of data to be checked is large and the positioning of the data to be checked is complicated. Not only does it require an enormous number of man-hours, but oversights and calculation errors are likely to occur, so it is extremely difficult to completely detect data inconsistencies. In addition, there is a problem that it is a work that can only be done by a person who is familiar with both the financial management account item and the sales management account item.

[0006]

A business management data consistency check apparatus according to the first aspect of the present invention comprises a business management database for time-sequentially storing financial data and sales data as business management data for a given period. , Input device with a keyboard and display for inputting consistency check account item information and editing output designation information for processing this business management data, and consistency check account item information and editing via this input device According to the input section that inputs the output specification information, the account information table that stores the consistency check account information that is input by this input section, and the consistency check account information that is stored in this account information table, A balance obtained by searching the management database and summing up the amounts of account items of financial data and sales data, for example, Calculate the values of the balance of accounts payable, the balance of accounts payable, the balance of notes receivable, etc., and detect the data inconsistency of the consistency by comparing the values of the items that should match, and attach the judgment result of the consistency to the value of the item. A consistency check unit, a summary information output area in which summary information of data that is a processing result of the consistency check unit and a determination result of the consistency is stored, and a consistency of data that is a processing result of the consistency check unit And a second detailed information output area in which detailed information of the judgment result of the consistency with the data as the processing result of the consistency check unit is stored. And editing the data stored in the summary information output area, the first detailed information output area, and the second detailed information output area into an output format according to the edit output designation information input by the input unit. check A result output unit is configured by an output device having a display or printer for outputting the check result output unit has edited data.

The business management data consistency check apparatus of the second invention stores a business management database for time-sequentially storing financial data and sales data as business management data for a given period, and the business management data. An input device equipped with a keyboard and display for inputting consistency check account information and editing output designation information for processing,
An input section for inputting consistency check account information and edit output specification information via this input device, an account information table for storing consistency check account information input by this input section, and this account Generate a consistency check database that integrates the financial data and sales data in the business management database by classification according to the consistency check account item information stored in the information table. Section, a first work area used by the consistency check database generation section, a second work area used by the consistency check database generation section, and a consistency check in the consistency check database. Balance that sums up the amounts of account items of financial data and sales data corresponding to the account items for For example, by calculating the values of accounts receivable balance, accounts payable balance, bills receivable balance, etc., and comparing the values of the items that should match, the data inconsistency of the consistency is detected, and the consistency judgment result is added to the value of the item And a check result output unit that edits the determination result of the consistency with the data in the consistency check database into an output format according to the edit output specification information input by the input unit, and the check result. An output data storage area for storing output data which is a processing result of the output section; and an output device having a display or a printer for outputting the data stored in the output data storage area by the check result output section. It is configured with.

[0008]

An embodiment of the present invention will be described in detail below with reference to the drawings.

Referring to FIG. 1, the business management data consistency check apparatus according to the first embodiment of the present invention accumulates time series financial data and sales data for a certain period as business management data. Database 1 for business management,
An input device 2 having a keyboard and a display for inputting consistency check account item information and edit output designation information for processing the data in the business management database 1, and a consistency check via the input device 2. Input program 3 (hereinafter referred to as input section 3), which is a program for inputting general account item information and edit output designation information, and an account item information table storing the consistency check account item information input by this input unit 3. 7 and the account item information for consistency check stored in the account item information table 7, the management management database 1 is searched, and the total amount of the account items of the financial data and the sales data is totaled. , For example, by calculating the values of accounts receivable balance, accounts payable balance, bills receivable balance, etc., and comparing the values of the items that should match, Over detects data inconsistency, the consistency check program is a program for subjecting the consistency determination result to the value of said item 4 (hereinafter referred to as the consistency check section 4)
And a summary information output area 8 in which the summary data of the data as the processing result of the consistency check unit 4 and the determination result of the consistency is stored, and the data as the processing result of the consistency check unit 4 A first detailed information output area 9 in which detailed information on the judgment result is stored, and a second detailed information output in which detailed information on the judgment result of the data and the consistency as the processing result of the consistency check unit 4 is stored. The data stored in the area 10, the summary information output area 8, the first detailed information output area 9, and the second detailed information output area 10 are processed according to the edit output designation information input by the input unit 3. Check result output program 5 (hereinafter referred to as check result output unit 5) which is a program for editing in a different output format, and a display or pre-display which outputs the data edited by the check result output unit 5. And an output device 6 for having a motor.

1 to 7 of the business management data consistency check device which is the operation of the first embodiment of the present invention.
Will be described with reference to.

When the user inputs the information of the account item to be checked for the consistency of the business management data through the input device 2, the input section 3 inputs the information into the account item information table 7.
(Step 31).

FIG. 4 shows the contents of the account item information table 7 and shows the units of account items to be checked for consistency between financial data and sales data in the business management database 1. For example, the financial data in the business management database 1 is composed of account items as shown in 7.2,
It is assumed that the sales data is composed of account items as shown in 7.3. In that case, the account items for checking the consistency between financial data and sales data are 1: 1
Not corresponding to, for example, financial management account items A1, A2,
The total of A3 corresponds to the total of A4 and A5 of the sales management account items. Therefore, in step 31, the user needs to input the information of the unit of the account item for consistency check as shown in 7.1. For example, in item 7.4, item A is set as an account item for consistency check, and item A is the sum of financial management account items A1, A2, and A3.
The information corresponds to the total of A4 and A5 of the sales management account items. Subsequently, similarly, information such as 7.5, 7.6, and 7.7 is input.

Next, the user inputs through the input device 2 a designation as to how to edit and output the result of the consistency check of the business management data, and the input unit 3 passes the information to the consistency check unit 4 ( Step 32).

The edit output designation in step 32 is a selection of whether to output the summary information or the detailed information. In the case of the summary information output, the unit of the consistency check account item designated in step 31 is selected. If there is an inconsistency, the account name for consistency check will be highlighted.
Further, in the case of detailed information output, a specific consistency check account item is output in units of months or business partners. Therefore, in addition to the specification of detailed information output, the account item name is specified.

After step 31 and step 32,
The input unit 3 activates the consistency check unit 4 (step 3
3).

The consistency check unit 4 determines what the information received from the input unit 3 in step 32 is (step 41), and if the information is a request for output of summary information,
First, the information of one account item is extracted from the information of the account item to be checked for the consistency of business management data, which is stored in the account item information table 7 (step 4).
2).

An explanation will be given below by using an example in which the subject A is taken out from the account subject information table 7 in the state of FIG.

The consistency check unit 4 recognizes the financial management account items A1, A2, and A3 and the sales management account items A4 and A5 corresponding to the consistency check account item A, and performs a certain arbitrary operation. The business management database 1 in which the financial data and sales data of the period are stored is searched for each of the account items, and the corresponding data is extracted.
Financial data As a total balance at the end of the period, items A1, A2, A3
The total term-end balance of the entire data and the total term-end balance of the sales-related data are calculated as the term-end total sum of the entire data of items A4 and A5 (step 43). In step 43, the term end means that the data for all sections is extracted without specifying the period when extracting the data in the business management database 1. Next, the total balance of the end of the financial data and the total balance of the end of the sales data are compared (step 44). If they match, it is determined to be consistent, and if they do not match, it is determined to be inconsistent. The determination result is output together with A to the summary information output area 8 (step 45). When the consistency check unit 4 completes the consistency check process for one consistency check account,
It is judged whether or not there is an unconfirmed consistency check account item in the account item information table 7 (step 46),
If there is, the process returns to step 42 (step 47), and if there is no, the processing of the consistency check unit 4 is terminated and the check result output unit 5 is activated (step 48).

Regarding the processing when it is determined in step 41 that the information received from the input unit 3 in step 32 is a request for detailed information output, an example in the case where the account item information table 7 is in the state shown in FIG. This will be described below.

First, the consistency check unit 4 extracts information on one account item from the information on the account items to be subjected to the consistency check of the business management data, which is stored in the account item information table 7 (step 49). ). In this example, the consistency check account item A is extracted.

Next, the consistency check unit 4 corresponds to the consistency check account item A in the account item information table 7, and the financial management account items A1, A2 and A3 and the sales management account items A4 and A5. The financial data and the sales data in the business management database 1 are searched for each of the above-mentioned account items and by the month in which the data is stored, and the corresponding data is extracted to obtain the financial data total monthly balance. Subject A as the total monthly balance of all data that is subjects A1, A2, and A3 and the total monthly balance of sales-related data
4, the total monthly balance of the entire data of A5 is calculated (step 4A). Next, the total monthly balance of the financial data and the total monthly balance of the sales data are compared (step 4B). If they match, it is determined to be consistent, and if they do not match, it is determined to be inconsistent. , Month, total financial data monthly balance, and sales data monthly balance are output to the first detailed information output area 9 (step 4C).

Further, the consistency check unit 4 corresponds to the consistency check account item A input from the input unit 3.
The financial management account items A1, A2, A3 and the sales management account items A4, A5 are recognized, and the business management database 1
Financial data and sales data in each are searched for each of the above-mentioned account items, corresponding data is extracted, and further, those data are classified by business partner, and financial data is accounted as the total balance of each business partner, A1 and A2. , A3, the total sum of the balance of each data by supplier and the total balance of the sales-related data by supplier, which is the total of the balance of each data of all items, A4 and A5, is calculated (step 4D). Next, the total balance of each financial data supplier and the total balance of each sales data supplier are compared for each supplier (step 4E). If they match, it is determined to be consistent, and if they do not match, it is determined to be inconsistent. The check result is output to the second detailed information output area 10 together with the check account name, the supplier name, the financial data data, the total balance by supplier and the total balance by sales data partner, and the second detailed information output area 10 (step 4F). After the completion of step 4F, the consistency check unit 4
It is determined whether or not there is an undetermined consistency check account item in the account item information table 7 (step 4G),
If there is, the process returns to step 42 (step 4H), and if there is no, the process of the consistency check unit 4 is terminated and the check result output unit 5 is activated (step 4I).

The check result output unit 5 determines whether or not group data including the subject name of the consistency check account item and the determination result of the consistency check is stored in the summary information output area 8 (step 51). , If the data is stored, refer to the judgment result of each data, and for the consistency check account name for which the consistency judgment is made, leave the account name as it is and check the consistency for the consistency With respect to the check account title, an output attribute is added so that the account title is displayed in reverse video, and it is displayed on the display which is the output device 6 (step 52). FIG. 5 is an example in which the summary information of the consistency check is output to the display.

Next, the check result output part 5 determines the consistency check account item name, month, total financial data monthly balance, total sales data monthly balance and consistency check in the first detailed information output area 9. It is determined whether or not the set data including the result is stored (step 53). If the data is stored, the determination result of each data is referred every month, and regarding the data for which the determination of the consistency is made, Edit the monthly, total financial data monthly balance, and total sales data monthly balance in the output format, and for the data for which inconsistency was determined,
“Month”, total monthly balance of financial data and monthly balance of sales data are added to the output format by adding “*” which is the determination result of inconsistency and displayed on the printer which is the output device 6 (step 54). . FIG. 6 shows an example in which detailed information of the consistency check is edited monthly and output to a printer.

Further, the check result output section 5 includes the supplier name, the total balance of financial data by business partner, the total balance of sales by data supplier and the judgment result of the consistency check in the second detailed information output area 10. It is determined whether or not the group data is stored (step 55). If the data is stored, the determination result of each data is referred to for each supplier, and the data for which the consistency is determined is determined by the supplier. Name, total balance of financial data by business partner, total balance of sales data by business partner are edited in the output format, and regarding data for which inconsistency is determined, the total name of financial partner, financial data, total balance by business partner, "*", Which is the determination result of inconsistency, is added to the total balance of sales-related data by business partner, edited in the output format, and displayed on the printer which is the output device 6 (step 56). FIG. 7 shows an example in which detailed information of the consistency check is edited for each business partner and output to a printer.

With the above, the processing of the business management data consistency check device, which is the operation of the first embodiment of the present invention, is completed.

The business management data consistency checking apparatus according to the first embodiment of the present invention enables a worker who is not familiar with business management work to easily and quickly perform a highly reliable financial management account. There is an effect that it is possible to check the consistency between the subject and the sales management account.

Referring to FIG. 8, the business management data consistency checking apparatus according to the second embodiment of the present invention time-series financial data and sales data for a certain period as business management data. A database 1 for business management to be stored, an input device 2 having a keyboard and a display for inputting consistency check account item information for processing this business management data and edit output designation information, and this input device 2 The input program 3 (hereinafter referred to as the input unit 3), which is a program for inputting the consistency check account item information and the edit output designation information, and the consistency check account item information input by the input unit 3 are stored. According to the account item information table 7 and the account item information for consistency check stored in the account item information table 7, the data for business management is classified. A consistency check database generation program 11 (hereinafter referred to as a consistency check database generation unit 11) that is a program for generating a consistency check database 12 that integrates financial data and sales data in the base 1; The first work area 13 used by the consistency check database generation unit 11
And a second work area 14 used by the consistency check database generation unit 11, and an account for each of financial data and sales data corresponding to the consistency check account item in the consistency check database 12. Calculate the balance of the sum of the items' amounts, for example, the balance of accounts receivable, the balance of accounts payable, the balance of bills receivable, etc., and detect the data contradiction of consistency by comparing the values of the items that should match,
A consistency check program 4 (hereinafter referred to as the consistency check unit 4) which is a program for adding a consistency determination result to the value of the item, and the consistency check database 1
A check result output program 5 (hereinafter referred to as a check result output unit 5) which is a program for editing the determination result of the consistency with the data in 2 into an output format according to the edit output specification information input by the input unit 3; An output data storage area 15 for storing output data which is a processing result of the check result output section 5, and a display for outputting the data stored in the output data storage area 15 by the check result output section 5. Alternatively, it is configured to include an output device 6 including a printer.

Next, a business management data consistency check device which is an operation of the second embodiment of the present invention will be described with reference to FIGS.
0, with reference to FIGS. 4 and 5.

When the user inputs the information of the account item to be checked for the consistency of the business management data through the input device 2, the input unit 3 inputs the information into the account item information table 7.
(Step 31).

FIG. 4 shows the contents of the account item information table 7 and shows the units of account items to be checked for consistency between the financial data and the sales data in the business management database 1. For example, the financial data in the business management database 1 is composed of account items as shown in 7.2,
It is assumed that the sales data is composed of account items as shown in 7.3. In that case, the account items for checking the consistency between financial data and sales data are 1: 1
Not corresponding to, for example, financial management account items A1, A2,
The total of A3 corresponds to the total of A4 and A5 of the sales management account items. Therefore, in step 31, the user needs to input the information of the unit of the account item for consistency check as shown in 7.1. For example, in item 7.4, item A is set as an account item for consistency check, and item A is the sum of financial management account items A1, A2, and A3.
The information corresponds to the total of A4 and A5 of the sales management account items. Subsequently, similarly, information such as 7.5, 7.6, and 7.7 is input.

Next, when the user inputs, through the input device 2, a designation as to how to edit and output the result of the consistency check of the business management data, the input unit 3 passes the information to the check result output unit 5 ( Step 32).

The edit output designation in step 32 is to select whether to output the summary information or the detailed information. In the case of the summary information output, the unit of the consistency check account item designated in step 31 is selected. If there is an inconsistency, the account name for consistency check will be highlighted.
Further, in the case of detailed information output, a specific consistency check account item is output in units of months or business partners. Therefore, in addition to the specification of detailed information output, the account item name is specified.

After step 31 and step 32,
The input unit 3 activates the consistency check database generation unit 11 (step 33).

Consistency check database generation unit 11
Is a classification according to the correspondence information between the account items for consistency check stored in the account item information table 7 and the account items for financial data and sales data stored in the database 1 for business management. A consistency check database 12 that integrates financial data and sales data is generated.

Consistency check database generation unit 11
The processing will be described below by using an example when the account item information table 7 is in the state shown in FIG.

Consistency check database generator 11
First, the information of one account item is extracted from the information of the account item which is the target of the consistency check of the business management data, which is stored in the account item information table 7 (step 111). In this example, the subject A is taken out first.

Consistency check database generator 11
Refers to the account item information table 7, and corresponds to the item A which is the consistency check account item, the financial management account items A1, A2, A3 and the sales management account items A4, A5.
Is obtained (step 112). From the financial data in the business management database 1, the financial management account A1,
The data of A2 and A3 are extracted and stored in the first work area 13 (step 113). Similarly, the data of the sales management account items A4 and A5 are extracted from the sales data and stored in the second work area 14 (step 114). Next, in step 113, the data stored in the first work area 13 is sorted in the order of month and supplier name, and the financial balance is calculated for each supplier name (step 115). Similarly, the data stored in the second work area 14 in step 114 is sorted in the order of month and supplier name, and the sales-related balance for each supplier name is calculated (step 116). After completion of Steps 115 and 116, the consistency checking database generation unit 11 first extracts one record from the first work area 13 and retrieves the record of the same month and the same customer as the one recorded in the record. Second work area 14
5 information of the consistency check account title, month, supplier name, financial balance, and sales balance is collected into one record and stored in the consistency check database 12 (step 117). After step 117,
It is determined whether or not there is an unprocessed record in the first work area 13 (step 118). If there is an unprocessed record, the process returns to step 117. If there is no unprocessed record, the account item information table 7 It is determined whether or not there is an unprocessed consistency check account (step 11).
9) If there is an unprocessed consistency check account item, the process returns to step 111. If there is no unprocessed consistency check account item, the consistency check unit 4 is activated and the consistency check database generation unit is started. The process 11 is terminated (step 11A).

The consistency check unit 4 refers to the consistency check database 12 record by record and determines whether or not the financial balance and the sales balance of the record match. If they do not match, As a consistency determination result, "*", which means inconsistency, is added to the record (step 41). In step 41, the information stored in each record in the consistency check database 12 is
The six items of information are the consistency check account title, month, supplier name, financial balance, sales balance, and consistency determination result. After step 41, it is judged whether or not there is a record whose consistency is undetermined in the consistency check database 12 (step 42). If there is not, the check result output unit 5 is activated, and the processing of the consistency check unit 4 ends (step 43).

The check result output unit 5 determines what the information received from the input unit 3 in step 32 is (step 51).

When the information received from the input unit 3 is an instruction to output the summary information, the check result output unit 5 determines the consistency check account title and the consistency judgment for all the records in the consistency check database 12. If only the result is referred to, and if the consistency determination result is inconsistent, that is, "*" is attached, an output attribute that the output device 6 can recognize is added so that the consistency check account item name is highlighted, The data is stored in the output data storage area 15 (step 52).

When the information received from the input unit 3 is an instruction to output detailed information, the check result output unit 5 checks the consistency check account item name, month, and transaction for all records in the consistency check database 12. First name, financial balance,
The sales balance and the consistency determination result are edited in an output format and stored in the output data storage area 15 (step 5).
3).

After completion of step 52 or step 53, the check result output section 5 outputs the data stored in the output data storage area 15 to the output device 6 (step 5).
4). FIG. 5 is an example in which the summary information of the consistency check is output. FIG. 10 is an example in which detailed information of the consistency check is output.

With the above, the processing of the business management data consistency check device, which is the operation of the second embodiment of the present invention, is completed.

The business management data consistency checking apparatus according to the second embodiment of the present invention is used for consistency checking of financial data and sales data in the business management database 1 as compared with the first embodiment. By integrating with the database 12, the financial data and the sales data, which are generally separately managed, can be centrally managed, so that a more reliable consistency check can be performed, and Since the degree of freedom in editing the data is increased, it is possible to more easily grasp the actual condition of business management.

[0046]

As described above, the business management data consistency check device of the present invention allows a worker who is not familiar with the business management work to easily and quickly perform reliable financial management account items. And there is an effect that it is possible to carry out the consistency check of the sales management account.

[Brief description of drawings]

FIG. 1 is a block diagram showing a first embodiment of the present invention.

FIG. 2 is a flow chart showing processing of an input unit 3 and a consistency check unit 4 according to the first embodiment of this invention.

FIG. 3 is a flowchart showing a process of a check result output unit 5 according to the first embodiment of this invention.

FIG. 4 is an example of an account item information table 7 according to the first and second embodiments of the present invention.

FIG. 5 is an example in which the outline information of the consistency check according to the first and second embodiments of the present invention is output to the output device 6.

FIG. 6 is an example in which detailed information of the consistency check according to the first embodiment of the present invention is edited monthly and output to the output device 6.

FIG. 7 is an example in which detailed information of the consistency check according to the first embodiment of the present invention is edited for each business partner and output to the output device 6.

FIG. 8 is a block diagram showing a second embodiment of the present invention.

FIG. 9 is a flowchart showing the processing of the input unit 3, the consistency check database generation unit 11, the consistency check unit 4, and the check result output unit 5 according to the second embodiment of this invention.

FIG. 10 is an example in which detailed information of the consistency check according to the second embodiment of the present invention is edited and output to the output device 6.

[Explanation of symbols]

 1 Business management database 2 Input device 3 Input unit 4 Consistency check unit 5 Check result output unit 6 Output device 7 Account item information table 8 Summary information output area 9 First detailed information output area 10 Second detailed information output area 11 Consistency Check Database Generation Unit 12 Consistency Check Database 13 First Working Area 14 Second Working Area 15 Output Data Storage Area

Claims (2)

[Claims] 1. As business management data for a certain arbitrary period,
Business management database that accumulates financial data and sales data in time series, and input with keyboard and display for inputting consistency check account item information and edit output designation information for processing this business management data A device, an input section for inputting consistency check account item information and edit output designation information via this input device, and an account item information table for storing the consistency check account item information input by this input unit, According to the account item information for consistency check stored in this account item information table, the management database is searched to find the balance of the sums of the account items of the financial data and the sales data, for example, the accounts receivable balance, Inconsistency in data by calculating values of accounts payable balance, bills receivable balance, etc. and comparing values of items that should match And a consistency check unit that adds a consistency determination result to the value of the item, and summary information output that stores data that is the processing result of this consistency check unit and summary information of the consistency determination result. An area, a first detailed information output area for storing detailed information of a judgment result of consistency with data which is a processing result of the consistency check unit, and a consistency with data which is a processing result of the consistency check unit A second detailed information output area in which detailed information of the determination result of is stored, the summary information output area, the first detailed information output area,
And a check result output unit that edits the data stored in the second detailed information output area into an output format according to the edit output specification information input by the input unit, and outputs the data edited by the check result output unit An output device equipped with a display or a printer, and a business management data consistency check device, comprising: 2. As business management data for a certain arbitrary period,
Business management database that accumulates financial data and sales data in time series, and input with keyboard and display for inputting consistency check account item information and edit output designation information for processing this business management data A device, an input section for inputting consistency check account item information and edit output designation information via this input device, and an account item information table for storing the consistency check account item information input by this input unit, Consistency check that creates a consistency check database that integrates the financial data and sales data in the business management database by classification according to the consistency check account information stored in this account information table Database generator, a first work area used by the consistency check database generator, In the second work area used by the consistency check database generator, and in the consistency check database, the sums of the amounts of the financial data and sales data corresponding to the consistency check account items are summed up. Calculate the balance, for example, accounts receivable balance, accounts payable balance, bills receivable balance, etc.
A consistency check unit that detects a data contradiction of consistency by comparing the values of items that should match and attaches a judgment result of the consistency to the value of the item, and the data in the consistency check database. Check result output part for editing the determination result of the sex into an output format according to the edit output specification information input by the input part, and an output data storage area for storing output data which is the processing result of the check result output part And an output device provided with a display or a printer for outputting the data stored in the output data storage area by the check result output unit, the management data consistency checking device.