JP4974830B2 - Checklist creation method, checklist creation device, checklist creation system, and checklist creation program - Google Patents

Description

  The present invention relates to a checklist creation method for supporting determination of authenticity of data created by various application systems.

  Conventionally, when determining the authenticity of application data created by various application systems, first start the application system that created the data to be judged, and specify the data for the relevant year or previous year in the system. The data is output to the screen or to paper. Then, comparisons with previous years data and related systems were made visually to find out abnormal values and items to be confirmed, and they were confirmed and checked.

  Also disclosed is a technique for confirming errors and inconsistencies in application data on a computer. For example, Patent Document 1 below discloses an accounting processing system that detects an error in an electronic book table, operates accounting data to match the erroneous record, and creates correction instruction data so as to correct the error caused by the operation. Has been. Patent Document 2 below discloses an accounting system that detects an inconsistency based on an alignment rule when there is an inconsistency between accounting data and receivables and payables data.

Japanese Patent Laid-Open No. 11-306247 JP 2000-148872 A

  However, in the conventional credibility judgment method, confirmation and checking are performed visually. For this reason, there is a problem that a lot of labor and man-hours are required and oversight is likely to occur.

  In addition, the technique described in Patent Document 1 has a problem in that it is possible to maintain consistency between the electronic book table and the accounting data, but it is not possible to compare the previous year data with the data of the current year. In addition, there is a problem that comparison between the electronic book table and data created by a system other than accounting data cannot be performed.

  Further, the technique described in Patent Document 2 has a problem that inconsistency can be confirmed between the accounting data and the claim data, but the inconsistency between the previous year data and the data of the current year cannot be confirmed. In addition, there is a problem that it is not possible to confirm inconsistencies between data other than accounting data and claims and debts data.

  The present invention has been made in view of the above, and in the determination of the authenticity of the created application data, it is possible to prevent omission of confirmation and efficiently check the data including past year data and consistency with other systems. It is an object to obtain a checklist creation method, a checklist creation device, a checklist creation system, and a checklist creation program that can create a checklist for performing the checklist.

  In order to solve the above-described problems and achieve the object, a checklist creation method according to the present invention is a checklist for creating a checklist for checking the authenticity of data created by an application system for each company. A check content data storing step for storing check content data including a definition of a check item in a storage unit and a data selection unit for creating a check list for each check content that is a type of check for application data. The selection of the company to be accepted is received, the “correspondence between the company and the client code” stored in the storage unit is read, and based on the correspondence, the client code corresponding to the selected company is selected as the selected client code. Company selection step Application system extraction step in which the data selection unit reads “correspondence between client code and application system” stored in the storage unit, and extracts an application system corresponding to the selected client code based on the correspondence And the data selection unit reads “correspondence between the application system and the check content applied to the application data created by the application system” stored in the storage unit, and the extracted application system based on the correspondence A check content acquisition step for selecting check content corresponding to the check content, and a check list creation unit reads check content data corresponding to the selected check content from the storage unit, Characterized in that it comprises a and a checklist step of creating a checklist based on checking the contents data.

  The check list creation method according to the next invention is characterized in that the check item definition includes comparison with previous year data.

  The check list creation method according to the next invention is characterized in that the definition of the check item includes a comparison with application data created in another application system.

  In the check list creation method according to the next invention, the check content data further includes a determination condition for determining whether or not each check item is a confirmation item, and the check list further includes: It is assumed that a column indicating a determination result is included, and the check execution unit reads out the application data created by the extracted application system from the storage unit, and whether or not each check item is a confirmation item based on the determination condition A determination step for storing a determination result indicating that the item is a confirmation required item in association with a field indicating the determination result of the check list for the item determined as the confirmation required item. Features.

  In the checklist creation method according to the next invention, the checklist further includes a confirmation column indicating whether or not the confirmation has been made, and the checklist output unit displays the checklist on the display unit. A checklist display step for performing control, and an input indicating that the checklist output unit has confirmed by the operator for each check item determined to be the confirmation required item, and the item that has received this input Includes a confirmed setting step for performing control for setting a value indicating confirmation in the confirmation column.

  The check list creation method according to the next invention is further characterized in that the data selection unit assigns a check identifier for identifying a check list group reflecting a confirmed flag of a past check list, and The check execution unit associates the check list after the confirmed setting step with the check identifier and stores them in the storage unit, and stores the stored check list and check identifier as a check list log table after the check list creation processing ends. Checklist log table holding step held in the storage unit, and the check execution unit refers to the checklist log table in the storage unit for the items determined as the confirmation required items in the determination step, and the checklist log table has been confirmed. Flag set If the record has the same check identifier and the same item value as the record being checked, a confirmation determination step for performing control to set the confirmation column corresponding to that item in the check list to a value indicating confirmation , Including.

  The checklist creation method according to the next invention further includes a user setting information setting step in which the data selection unit receives a change request from the operator for the determination condition and stores the received content in the storage unit as user setting information. In the determination step, it is further characterized in that it is determined whether the item is a confirmation required item based on the user setting information.

  The check list creation method according to the next invention is characterized in that the application system is a financial or tax application.

  A check list creation apparatus according to the next invention is a check list creation apparatus that creates a check list for checking the authenticity of data created by an application system for each company, and is a check type for application data. For each check content, a storage unit for storing check content data including definitions of check items, and a selection of a company that creates a check list are accepted, and the “company and client code” stored in advance in the storage unit Data selection unit that obtains the client code corresponding to the selected company as the selected client code based on the correspondence, and “client code and application stored in advance in the storage unit” Pair with system ”Is extracted, and an application system corresponding to the selected client code is extracted based on the correspondence, and“ application system and application data created by the application system stored in advance in the storage unit ”are applied. "Check content corresponding to the check content to be read out", and based on the correspondence, a check content acquisition unit that acquires the check content corresponding to the extracted application system, and check content data corresponding to the acquired check content are stored in the storage unit And a check list creation unit that creates a check list based on the check content data.

  The check list creating apparatus according to the next invention is characterized in that the check item definition includes a comparison with previous year data.

  The check list creating apparatus according to the next invention is characterized in that the check item definition includes a comparison with application data created in another application system.

  The check list creation apparatus according to the next invention further includes a determination condition for determining whether or not each check item is a required confirmation item in the check content data, and the check list further includes: Whether to include a column indicating a determination result, and further read out the application data created by the extracted application system stored in advance in the storage unit, and whether the check item is a confirmation item for each check item based on the determination condition. A check execution unit for storing a determination result indicating that the item is a confirmation required item in association with a field indicating the determination result of the check list for the item determined as the confirmation required item. It is characterized by providing.

  The check list creating apparatus according to the next invention further includes a confirmation column indicating whether or not the check list is confirmed in the check list, and further performs control for displaying the check list on a display unit. For each check item that is determined to be a required confirmation item, an input indicating that the operator has confirmed is received, and for the item that has received this input, a value indicating that the input has been confirmed is set in the confirmation column. And a check list output unit that performs control to perform the above.

  In the checklist creation device according to the next invention, the data selection unit further assigns a check identifier for identifying a checklist group reflecting a confirmed flag of a past checklist, and the check execution unit includes: Further, the check list and the check identifier after completion of the confirmation column setting control by the check list output unit are stored in the storage unit in association with each other, and after the check list creation process is completed, the stored check list and check identifier are stored. The check list log table is stored in the storage unit, and the check execution unit further refers to the check list log table of the storage unit for items determined as the confirmation required items, and confirms the check list log table confirmed flag. The same check identifier as the record for which is set One if the value of the same item, the confirmation column corresponding to the checklist, and performs control to set to a value indicating that a verified.

  In the check list creation device according to the next invention, the data selection unit further accepts a change request by the operator for the determination condition, stores the accepted content in the storage unit as user setting information, and the check execution unit Further, it is characterized in that it is determined whether or not the item is a confirmation required item based on the user setting information.

  The check list creation apparatus according to the next invention is characterized in that the application system is a financial or tax application.

  The checklist creation system according to the next invention is composed of a server and a terminal connected to the server via a network, and creates a checklist for checking the authenticity of data created by an application system for each company. The terminal includes an instruction unit that accepts selection of a company that creates a check list, and a first communication unit that transmits a result received by the instruction unit to a server as input data. The server includes a storage unit for storing check content data including a definition of a check item for each check content that is a type of check for application data, and a second communication unit that receives the input data from the terminal And the input data received by the second communication unit. A data management unit that distributes the data to each unit, and the input data is received from the data management unit, “correspondence between company and client code” stored in advance in the storage unit is read, and based on the correspondence, the input data The data selection unit for obtaining the client code corresponding to the selected client code and the “correspondence between the client code and the application system” stored in advance in the storage unit are read, and the selected based on the correspondence is read. The application system corresponding to the client code is extracted, and “correspondence between application system and check content applied to application data created by the application system” stored in the storage unit is read and Based on A check content acquisition unit that acquires check content corresponding to the extracted application system, and check content data corresponding to the acquired check content are read from the storage unit, and a check list is created based on the check content data And a checklist creation unit.

  The check list creation system according to the next invention is characterized in that the check item definition includes a comparison with previous year data.

  The check list creation system according to the next invention is characterized in that the definition of the check item includes a comparison with application data created by another application system.

  In the check list creation system according to the next invention, the check content data further includes a determination condition for determining whether or not each check item is a confirmation item, and the check list further includes: Whether to include a column indicating a determination result, and further read out the application data created by the extracted application system stored in advance in the storage unit, and whether the check item is a confirmation item for each check item based on the determination condition. A check execution unit for storing a determination result indicating that the item is a confirmation required item in association with a field indicating the determination result of the check list for the item determined as the confirmation required item. It is characterized by providing.

  In the check list creation system according to the next invention, the check list further includes a confirmation column indicating whether or not confirmation has been performed, and the first communication unit receives data transmitted from the server, The server further includes a check list output unit that transmits display data for displaying the check list to the terminal via a data management unit and a communication unit, and the second communication unit transmits the display data to the terminal. The terminal further includes a terminal-side data management unit that performs control for receiving the display data from the first communication unit and displaying the display data on the display unit, and the instruction unit includes: For each check item determined as the confirmation required item, an input indicating that the operator has confirmed is received, and the item having received this input is sent to the first communication unit. And the second communication unit receives the item that has received the input, the data management unit sends the item that has received the input to the check list output unit, and the check list. The output unit performs control to set a value indicating that the input has been confirmed in the confirmation column of the check list based on the item that has received the input.

  In the checklist creation system according to the next invention, the data selection unit further assigns a check identifier for identifying a checklist group reflecting a confirmed flag of a past checklist, and the check execution unit includes: Further, the check list and the check identifier after completion of the confirmation column setting control by the check list output unit are stored in the storage unit in association with each other, and after the check list creation process is completed, the stored check list and check identifier are stored. The check list log table is stored in the storage unit, and the check execution unit further refers to the check list log table of the storage unit for items determined as the confirmation required items, and confirms the check list log table confirmed flag. Is the same check as the record for which If a child and the value of the same item, the confirmation column corresponding to the checklist, and performs control to set to a value indicating that a verified.

  In the checklist creation system according to the next invention, the instruction unit further accepts a change request by the operator for the determination condition, transmits the change request to the server via the first communication unit, and the second communication unit The change request is received, the data management unit sends the change request to the data selection unit, the data selection unit stores the content of the change request as user setting information in the storage unit, and the check The execution unit further determines whether the item is a confirmation required item based on the user setting information.

  The check list creation system according to the next invention is characterized in that the application system is a financial or tax application.

  A check list program according to the next invention causes a computer to execute the check list creation method according to any one of claims 1 to 8.

  A checklist creation method, a checklist creation apparatus, and a checklist creation program according to the present invention automatically evaluate the authenticity of application data based on related application data created in various application systems and application data of previous years. Since the checklist for the system is created, it is possible to prevent omission of confirmation and perform the check efficiently.

  Embodiments of a checklist creation method, a checklist creation device, and a checklist creation program according to the present invention will be described below in detail with reference to the drawings. Note that the present invention is not limited to the embodiments.

  FIG. 1 shows the configuration of a computer system that has a function as a check list creation device for realizing the check list creation method of the first embodiment according to the present invention and can execute the check list creation program of the embodiment according to the present invention. It is a figure which shows an example. This computer system includes, for example, a control unit 1, an input unit 2, a storage unit 3, a display unit 4, a communication unit 5, and an output unit 6, which are connected via a system bus 7.

  In FIG. 1, the control unit 1 executes a check list creation program according to the present invention. The input unit 2 is composed of, for example, a keyboard and a mouse, and is used by a computer system user to input various information. The storage unit 3 includes various memories such as a RAM and a ROM and a storage device such as a hard disk, and stores programs to be executed by the control unit 1 and necessary data obtained in the course of processing. The storage unit 3 is also used as a temporary storage area for programs. The display unit 4 is composed of a CRT, LCD (liquid crystal display panel), etc., and displays various screens for the user of the computer system. The communication unit 5 has a function of connecting to a network such as a LAN (Local Area Network) and a function of connecting to the Internet. The output unit 6 is composed of a printer or the like and has a function for outputting the processing result to the outside.

  Here, an example of the operation of the computer system until the check list creation program according to the present invention becomes executable will be described. In the computer system having the above-described configuration, for example, a check list creation program is installed in the storage unit 3 from a CD-ROM set in a CD-ROM drive (not shown). Then, when the check list creation program is executed, the check list creation program read from the storage unit 3 is stored in a predetermined location in the storage unit 3. In this state, the control unit 1 executes a check list creation process according to a program stored in the storage unit 3.

  In the present embodiment, a program describing the checklist creation processing is provided using a CD-ROM as a recording medium. However, the present invention is not limited to this, and it depends on the configuration of the computer system, the capacity of the provided program, and the like. For example, it is also possible to use a recording medium such as a magnetic disk such as a floppy (registered trademark) disk, a magneto-optical disk, or a magnetic tape. Moreover, it is good also as using the program provided by transmission media, such as an email and the internet.

  FIG. 2 is a block diagram illustrating a functional configuration example of the check list creation apparatus according to the present embodiment. As shown in FIG. 2, the check list creation apparatus of the present embodiment includes a data selection unit 11, a check content selection unit 12, a check content data reading unit 13, a check list creation unit 14, a check execution unit 15, The check result creation unit 16, the check result output unit 17, the input unit 2, the storage unit 3, the display unit 4, and the output unit 6 are configured. The control unit 1 includes a data selection unit 11, a check content selection unit 12, a check content data reading unit 13, a check list creation unit 14, a check execution unit 15, a check result creation unit 16, and a check result output unit 17.

  The storage unit 3 of the present embodiment includes a database (DB), and stores application data created by a financial / tax / accounting application and an application data management table for managing information related to the application data. Has been.

  Specifically, for example, as application data, accounting data created by an accounting application, corporate tax data created by a corporate tax application, and the like are stored.

  FIG. 3A is a diagram illustrating an example of an accounting data table in which accounting data, which is an example of application data, is shown in a table format. As shown in FIG. 3A, for example, the accounting data is managed for each year, and the accounting data for each year stores the amount of money for each item for each month. FIG. 3-2 is a diagram illustrating an example of a corporate tax data table in which corporate tax data, which is an example of application data, is shown in a table format. As shown in FIG. 3-2, for example, the corporate tax data is managed for each fiscal year, and the corporate tax data for each fiscal year stores the sales amount, the corporate tax amount, and the like. Note that FIGS. 3A and 3B are examples, and the present invention is not limited to this, and may be stored in any format and item.

  FIG. 4 is a diagram illustrating an example of the application data management table stored in the database. As shown in FIG. 4, the application data management table of this embodiment includes a client code for identifying a company (client), a company name, a system code indicating the type of application that generated the data, and an application system that generated the data. The name, the year that is the target year of the application data, and the registration destination that is the storage location of the application data are included. In the application data management table, the application that created the application data registers information about each piece of data. The application data management table is not limited to this, as long as it includes the client code, system code, year, and registration destination.

  In this embodiment, it is assumed that an accounting office or the like creates application data, and it is assumed that data of a plurality of clients (company) is managed. If it is not necessary to identify (company), the client code may not be included. In this case, the processing of this embodiment may be applied as it is, assuming that there is one client code.

  The storage unit 3 also stores checklist data generated by the checklist generation process of this embodiment as a database. Further, the storage unit 3 stores a check company table, a check ID (IDentifier) table, system management information, check data, user setting information, and display setting information used in the check list creation processing of this embodiment.

  FIG. 5 is a diagram illustrating an example of system management information according to the present embodiment. As shown in FIG. 5, the system management information of this embodiment includes a system code and a content number (number) for identifying the check content. The check content represents the type of check. In the present embodiment, for example, a check of content ratio, character check, creation date check, etc. is used as the check content. The system management information is information indicating what kind of check content is to be checked for application data created by the system for each system code (for each application), and is stored in the storage unit 3 in advance. It can be rewritten accordingly.

  FIG. 6 is a diagram illustrating an example of a check content management table according to the present embodiment. As shown in FIG. 6, the check content management table of the present embodiment includes a content No, a check content, and a start program (name of the start program) that is a program for creating a check list corresponding to the check content. , Including. The activation program (check program) is stored as an executable file in the storage unit 3 and operates as a part of the check execution unit 15 of the control unit 1 when loaded. The check content management table is stored in advance in the storage unit 3 and can be rewritten as necessary.

  Next, application data check processing according to the present embodiment will be described. FIG. 7 is a flowchart illustrating an example of a procedure of application data check processing according to the present exemplary embodiment. The check list creation process of the present embodiment is started when the operator operates the input unit 2. First, the data selection unit 11 reads the application management table from the storage unit 3 (step S11).

  Next, the data selection unit 11 displays a screen for prompting selection of the company name (or client code) on the display unit 4 and accepts selection of the company name (or client code) by the operation of the input unit 2 by the operator. The selected company name is converted into the corresponding client code to obtain the selected client code, the system code of the row corresponding to the selected client code is obtained from the application data management table, and the selected client code is obtained. The system code is stored in the storage unit 3 as a check company table (step S12). As a company name (or client code) selection method, direct input of the company name (or client code) may be accepted, or selectable items (company names included in the application management table) on the display unit 4 It may be displayed and a selection from the displayed company name (or client code) may be accepted. The conversion from the client code to the company name may be performed by referring to the application management table, or the correspondence information between the client code and the company name is stored separately in the storage unit 3 and the correspondence information is referred to. You may do it. When the client code is directly selected, conversion from the company name to the client code is not necessary.

  FIG. 8 is a diagram showing an example of the check company table stored at this time. In this example, a company whose client code is “1” is selected, and the system code corresponding to the case where the client code is “1” is “1” and “2”.

  Next, the data selection unit 11 sets a check ID, and stores the set information in the storage unit 3 as a check ID table (step S13). Specifically, an arbitrary number is assigned as a check ID for identifying the check process corresponding to the client code. FIG. 9 is a diagram showing an example of the check ID table stored at this time. Thus, the client code corresponding to the check ID is stored in the check ID table. As will be described later, the check ID is an ID used to reflect information that has been confirmed with respect to the confirmation items that need to be confirmed in the check list table created in the past with the matching check ID. Here, the client code and the check ID are assigned so as to be in a one-to-one relationship. However, the present invention is not limited to this, and a unit that refers to information that has been confirmed in a checklist table created in the past (for example, For the application data of the same client code, the applications may be classified into a plurality of groups, and a check ID may be assigned for each group).

  Next, the data selection unit 11 sets items to be displayed as a check list (step S14). Specifically, the data selection unit 11 first displays a setting item input screen on the display unit 4. An example of the screen displayed at this time is shown in FIG. And the data selection part 11 receives the input by an operator's operation of the input part 2, and updates the display setting information of the memory | storage part 3 based on the input content. FIG. 10B is a diagram of an example of display setting information. It is assumed that a default value is stored in advance in the display setting information, and the content is updated in step S14. As shown in FIGS. 10A and 10B, as the display setting information, for example, “output check result”, “output all items”, “output only“ required ”items” For each of the above, information on whether to “Yes” or “No”, and the number of output periods in the previous year (how many previous data are to be output) are included. The display setting information in FIGS. 10A and 10B is merely an example, and is not limited thereto, and may include other setting items, or need not include all these items.

  Next, the data selection unit 11 performs setting for a check execution process described later (step S15). Specifically, an item to be a check criterion is set in a check execution process described later. As a check criterion, a default value is stored in the storage unit 3 in advance as a criterion that is part of the check content data. Accordingly, in step S15, the setting information change is accepted for an item that the operator wants to change from the default value. For example, the contents of the user setting information table as default values may be displayed on the display unit 4, and changes may be accepted for the respective items by operating the input unit 2. FIG. 11 is a diagram illustrating an example of the user setting information table. As shown in FIG. 11, a user set value is stored for each content No. and item No. (identification number of an item of determination information of check content data described later).

  Instead of performing the above steps S12 to S15, the check company table, the check ID table, the display setting information, and the user setting information table in the storage unit 3 are created by the operator by operating the input unit 2, respectively. They may be edited and the data selection unit 11 may read them from the storage unit 3.

  Next, the check list creation unit 14, the check execution unit 15, and the check result creation unit 16 perform a check list creation process to be described later and store the check list in the storage unit 3 (step S16). FIG. 12 is a diagram illustrating an example of the check list table. As described above, the check list stores the check result and the determination result for each check item corresponding to the system code and the content No. In the example of FIG. 12, the current period data and the previous period data are included as the check result. In addition, the checklist table includes an item “confirmed” indicating whether or not confirmation by the operator is confirmed. At the time of creating the checklist table, the “confirmed” field is blank (or indicates unconfirmed). Value).

  Next, the check result creation unit 16 determines whether there is still content to be checked based on the system management information (step S17). Specifically, the check result creation unit 16 reads the check company table in the storage unit 3, acquires the system code included in the check company table, and obtains the check content corresponding to the acquired system code from the system information in the storage unit 3. get. Then, for each acquired system code, it is determined whether or not there is a check content corresponding to the system code for which the check creation processing has not yet been executed.

  If it is determined in step S17 that there is still content to be checked (Yes in step S17), the process returns to step S16, and checklist creation processing is performed for combinations of system code and check content for which checklist creation processing has not yet been executed. . If it is determined in step S17 that there is no content to be checked (No in step S17), the check result creation unit 16 reads the display setting information and determines the display items of the check list based on the read information (step S18). ). Then, the check result output unit 17 reads the check list table stored in step S16, and displays the contents of the read table on the display unit 4 based on the display items determined in step S18 (step S19). At this time, a paper medium or the like may be output via the output unit 6 at the same time. FIG. 13 is a diagram showing an example of the screen displayed in step S19. At this point, the confirmed column is displayed as a blank column as shown in FIG. It should be noted that any display may be used as long as it is not blank, but may indicate that it has not been confirmed.

  Then, the check result output unit 17 accepts the input by the operation of the input unit 2 of the operator for the items that need confirmation in the displayed check list, and for the items that are input “confirmed”, The confirmed column in the check list table is set to a value representing “confirmed” (step S20), and the process is terminated. In step S20, the operator inputs “confirmed” when it is determined that there is no problem by confirming the values of the items that require confirmation. FIG. 14 is a diagram illustrating an example of a screen displayed on the display unit 4 after receiving an input of “confirmed”. FIG. 14 shows an example in which a check mark is added by an operation of the input unit 2 by the operator. FIG. 15 is a diagram illustrating an example of the check list table updated in response to the input of “confirmed” in step S20. In this embodiment, “confirmed” is represented by “1”.

  Next, the check list creation process (step S16 in FIG. 7) of this embodiment will be described. FIG. 16 is a flowchart illustrating an example of a check list creation process procedure according to the present embodiment. After step S15 of FIG. 7, the check content selection unit 12 reads the check company table and the system management information from the storage unit 3, selects one of the system codes included in the check company table, and selects the selected system code The check content corresponding to is searched from the system management information, and one is selected from the search results (step S21). In the case of the second and subsequent processing via step S17, the system code and check content are selected from a combination of content and system code that has not yet undergone check list creation processing.

  Next, the check content data reading unit 13 reads the check content data in the storage unit 3, and acquires data corresponding to the check content selected in step S21 from the read data (step S22). In the check content data, for each check content, setting information used for checking the check content such as determination information including a determination target item and comment data is stored in advance.

  Then, the check list creation unit 14 creates a check list table based on the data acquired in step S22 (step S23). However, at this time, the fields other than the three columns of system code, check content code, and item (for example, current period data, determination result column, etc.) are blank.

  Next, the check list creation unit 14 sets the number of checks of the check list log table management information stored in the storage unit 3 (step S24). FIG. 17A is a diagram of an example of checklist log table management information. As illustrated in FIG. 17A, the check list log table management information includes a check ID, the number of checks, and an execution date and time when the corresponding check list creation process is performed. The execution date may not be included. For the number of checks, the check list creation unit 14 refers to the check list log table, and if there is information on a check ID that matches the check ID stored in the check ID table, the check list creation unit 14 corresponds to the check ID. A numerical value obtained by adding “1” to the stored numerical value is calculated as the number of checks. If there is no check ID information that matches the check ID stored in the check ID table, the number of checks is calculated as “1”. Then, information such as the check ID stored in the check ID table and the calculated number of checks is written as a new row in the check list log table management information.

  Next, the check execution unit 15 displays a screen prompting the user to select whether or not to check the check list on the display unit 4, accepts the selection made by the operator's operation of the input unit 2, and is selected when the check is performed. It is determined whether or not (step S25). When it is determined that the check is selected (Yes in step S25), the check execution unit 15 refers to the check content management table and starts the check program corresponding to the check content selected in step S21 (the activation program). Name) is acquired, and the acquired program is loaded (step S26).

  Then, the loaded program reads determination information corresponding to the check content selected in step S21 from the check content data in the storage unit 3 (step S27).

  Next, the loaded program performs a check execution process (step S28). At this time, for items that are not set in the user setting information, determination conditions are determined based on the determination information included in the check content data, and items set in the user setting information are determined based on the user setting information. To decide.

  Next, the check execution unit 15 performs a confirmed data automatic check process to be described later using the check list log table (step S29). The check list log table is a table stored on the DB in the same manner as the check list data in the storage unit 3 updated in the next step S30, and the contents of the check list table are stored every time the check list table is created. Log table. At the time of step S29, the check list log table includes contents updated up to the previous check list creation process.

  Next, the check execution unit 15 updates the check list table on the DB of the storage unit 3 to reflect the result of the automatic check in step S29, and adds the contents of the check list table to the check list log table ( Register: Step S30), the check list creation process is terminated. FIG. 17B is a diagram of an example of the check list log table. Thus, the check list log table is a table in which the contents of the check list table are stored as a history together with the check ID. When the check list is updated at step 20 in FIG. 7 (when the confirmed column is updated), the check result output unit 17 also checks the confirmed column of the check list table for the check list log table. The same content as the update will be updated.

  If it is determined in step S25 that the check list is not checked (No in step S25), the process proceeds to step S30. However, in this case, since automatic check is not performed, the updated check list table is the check list table created in step S23.

  Next, the confirmed data automatic check process (step S29 in FIG. 16) will be described. In the confirmed automatic data check process of the present embodiment, the same content has already been checked, and the operator automatically confirms the items that have been determined to be OK after confirming the check results (confirmed). It is a process of setting as completed. FIG. 18 is a flowchart illustrating an example of the procedure of the confirmed automatic data check process according to this embodiment.

  First, the check execution unit 15 determines whether there is information of the same check ID as the check ID stored in the check ID table (hereinafter referred to as “check target check ID”) from the check list table management information in the storage unit 3. Is determined (step S31). When it is determined that there is information of the same check ID as the check target check ID (Yes in step S31), the check ID is the same as the check target check ID from the check list log table of the storage unit 3, and the number of checks is the same as described above. The data is extracted (step S32), which is smaller than the number of checks set in step S24, and the confirmed column is a value indicating confirmed ("1" in this embodiment).

  Then, if the check list table in the storage unit 3 includes data that matches the extracted data and the item and the check result (current data, previous data, etc.), the check execution unit 15 confirms the confirmed column of the data. Is set to a value indicating completion (step S33), and the confirmed automatic data check process is terminated.

  If it is determined in step S31 that there is no information of the same check ID as the check target check ID (No in step S31), the confirmed automatic data check process is terminated.

  Next, a specific example of the check execution process for each check content according to this embodiment will be described. FIG. 19 is a diagram illustrating an example of the procedure of the check execution process when the check content is an amount ratio check. The process shown in FIG. 19 is a specific example of steps S26 to S28 in FIG.

  Assume that the money amount ratio check is selected as the check content in step S21 of FIG. The check execution unit 15 loads a monetary ratio check program as the process of step S26 (step S41). Then, as the processing of step S27, the money amount ratio check program reads the determination information of the money content ratio check of the check content data from the storage unit 3, creates a temporary determination information table having the same contents as the determination information, and stores the storage unit 3 (step S42).

  FIG. 20 is a diagram illustrating an example of determination information for the ratio check of the amount of check content data. As shown in FIG. 20, the determination information of the amount ratio check of this embodiment sets No (identification number of the item of determination information), a setting item indicating a determination target, and a range that is not determined as a confirmation required item. A setting range and a comment number for setting a comment to be displayed for each determination result are included. For example, in the judgment information of the first line (No is “1”) in FIG. 20, if the ratio of the current period to the previous period (ratio of current period data to previous period data) is 80% or more and 120% or less, confirmation is required. Not determined as an item. When the ratio between the current period and the previous period is less than 80%, the comment number “2” is selected as the comment data to be displayed, and when it exceeds 120%, the comment with the comment number “1” is selected. In FIG. 20, the comment number “0” is described in the case of 80% or more and 120% or less (within range), but here, the comment number “0” indicates that no comment is displayed.

  Then, the money ratio check program reads the application data of the system (application system) corresponding to the system code included in the check company table, and checks the money ratio check table based on the read data and the determination information (hereinafter referred to as the check table). , An amount ratio check table) is created and stored in the storage unit 3 (step S43). Specifically, for example, data used for determination in the determination information of the amount ratio check is extracted from the read data, and an amount ratio check table is created. At this time, the application data for the previous system of the same system is also read. FIG. 21A is a diagram illustrating an example of an amount ratio check table. As shown in FIG. 21A, in the check table, data indicating the amount of money among the application data is stored for the current period (the year in which the checklist is created) and the previous year. The amount ratio check table also includes columns for items set in the determination information (for example, the ratio between the current period and the previous period). At the time of step S43, the column of items (for example, the ratio between the current period and the previous period) set in the determination information is blank.

  Regarding items other than the determination result (current data, previous term data, etc.) in the money amount ratio check table, the content of the check list table is the same as the content of the money amount ratio check table in step S43. And

  Hereinafter, a case will be described in which the ratio between the current period and the previous period of item No. “1” in FIG. 20 is checked. After step S43, the monetary ratio check program reads the data stored in the monetary ratio check table, calculates the ratio between the current period and the previous period based on the read data, and calculates the ratio between the current period and the previous period in the monetary ratio check table. The calculated numerical value is written in the ratio column (step S44). Specifically, calculation is performed as current period data / previous period data × 100. FIG. 21B is a diagram illustrating an example of a check table for checking the amount ratio after writing in the ratio column for the current period and the previous period in step S44.

  Next, the money amount ratio check program reads the user setting information from the storage unit 3, and updates the temporary determination information table in the storage unit 3 based on the user setting information (step S45). Specifically, the temporary determination information table is updated to the value set in the user setting information for the item with the same item No (No) in the user setting information. FIG. 22 is a diagram illustrating an example of a temporary determination information table updated based on user setting information. FIG. 22 shows an example in which 70% is set as the minimum setting range for the item number “1” as the user setting information as shown in FIG.

  Next, the money amount ratio check program refers to the money amount ratio check table, and determines whether there is a record in the money amount ratio check table that has not been determined (the processing after step S47 is not performed). (Step S46). If it is determined that there is a record in the ratio check table for the amount not determined (Yes in step S46), the ratio check program for the amount acquires information for one record from among the records for which the determination result is not set. (Step S47).

  Then, the money amount ratio check program determines whether or not the ratio of the current period and the previous period included in the acquired information is smaller than the minimum setting range of the temporary determination information table (step S48). When it is determined that it is smaller than the minimum setting range of the temporary determination information table (Yes in step S48), the comment data of the comment number “2” is acquired from the comment data table of the storage unit 3, and the check list table of the storage unit 3 is acquired. The comment data is written in the determination result of the corresponding record (step S50), and the process returns to step S46. FIG. 23 is a diagram illustrating an example of the comment data table stored in the storage unit 3. As shown in FIG. 23, the comment data table stores comment data corresponding to the content No. and the comment number, respectively.

  If it is determined in step S48 that it is not smaller than the minimum setting range of the temporary determination information table (No in step S48), the ratio between the current period and the previous period included in the acquired information is the maximum setting range of the temporary determination information table. It is determined whether it is larger (step S49). When it is determined that the setting range of the temporary determination information table is greater than the maximum (Yes in step S49), the comment data with the comment number “1” is acquired from the comment data table in the storage unit 3, and the check list table in the storage unit 3 is acquired. The comment data is written in the determination result of the corresponding record (step S51), and the process returns to step S46.

  If it is determined in step S49 that the setting range of the temporary determination information table is not greater than the maximum (No in step S49), the process returns to step S46. If it is determined in step S46 that there is no record in the ratio check table for the amount that has not been determined (determination has been performed for all records) (No in step S46), the process ends. The above steps S43 to S51 correspond to the above-described processing of step S28.

  In addition, although the case where the ratio of the amount of the current period and the previous period is checked is explained here, even when comparing the data of other years such as when checking the ratio of the amount of the current period and the previous period, the comparison target data is The same processing may be performed only by different. In addition, when other numerical data comparison processing is performed, for example, when the difference between the amounts is used as the determination condition instead of the amount ratio, the calculation formula in step S44 and the contents of the determinations in steps S48 and S49 correspond to the conditions. And change it. In addition, when comparing the data of the current period and the previous period rather than the data of another system, it is only necessary to read the data of the system to be compared in step S43 and perform the process according to the determination condition.

  Next, a case where the check content is a character check will be described. FIG. 24 is a diagram illustrating an example of the procedure of character check check execution processing.

  It is assumed that the character check is selected as the check content in step S21 in FIG. The check execution unit 15 loads a character check program as the process of step S26 (step S61). Then, as the processing of step S27, the money amount ratio check program reads the character check determination information of the check content data from the storage unit 3 (step S62).

  FIG. 25 is a diagram illustrating an example of determination information for character check of check content data. As shown in FIG. 25, the determination information of the amount ratio check in this embodiment sets No (identification number of the item of determination information), a setting item indicating a determination target, and a range that is not determined as a confirmation required item. Setting information and a comment number for setting a comment to be displayed for each determination result are included. For example, in the determination information on the first line (No is “1”) in FIG. 25, if the result of comparison between the current period and the previous period (comparison between the current period character data and the previous period character data) is equal, it is not determined that the item needs to be confirmed. . If the comparison result between the current period and the previous period is not equal (NG), the comment number “3” is selected, and if equal (OK), the comment number “0” is selected as comment data to be displayed. (No comment display).

  Then, the character check program reads application data of a system (application system) corresponding to the system code included in the check company table, and a character check check table (hereinafter referred to as a character check table) based on the read data and determination information. Is created and stored in the storage unit 3 (step S63). Specifically, for example, data used for determination of character check determination information is extracted from the read data to create a character check table. At this time, the application data for the previous system of the same system is also read. FIG. 26 is a diagram illustrating an example of a character check table. In the character check table, items other than the determination result (character data of the current period, character data of the previous period, etc.) are stored in step S63 with the same contents of the check list table as the contents of the character check table. And

  Next, the character check program refers to the character check table, and determines whether there is a character check table record that has not been determined (the processing after step S65 is not performed) (step S64). If it is determined that there is a character check table record for which no determination result is set (step S64 Yes), the character check program acquires information for one record from among the records that have not been determined (step S65). ).

  Then, the character check program determines whether or not the character data of the current period and the previous period included in the acquired information is the same (step S66). When it is determined that the character data of the current period and the previous period included in the acquired information is not the same (No in step S66), the character check program retrieves the comment data of the comment number “3” from the comment data table of the storage unit 3. The comment data is acquired, and the comment data is written in the determination result of the corresponding record in the check list table of the storage unit 3 (step S67), and the process returns to step S64.

  If it is determined that the character data in the current period and the previous period included in the acquired information are the same (Yes in step S65), the process returns to step S64. If it is determined in step S64 that there is no character check table record that has not been determined (No in step S64), the process ends.

  In this example, a flowchart is shown in which it is assumed that only character determination is performed for character check, and there is no change in the settings related to character check in the user setting information. If the setting can be set, considering the change in the settings related to the character check in the user setting information, the process for reflecting the user setting information using the temporary judgment information table is included, as in the case of the amount ratio check. You may make it.

  In addition, the case of comparing character data of the current period and the previous period has been explained, but even when comparing data of other years, such as when comparing character data of the current period and the previous period, only the data to be compared is different. A similar process may be performed. When conditions other than equal are set for character data comparison, the processing in steps S66 and S67 may be changed accordingly.

  FIG. 27A to FIG. 27C show specific examples of check results when a check is performed by the check list creation processing of this embodiment. FIG. 27-1 shows an example of the determination result of the credibility evaluation processing for the address, FIG. 27-2 shows an example of the determination result of the compensatory expenses, and FIG. The example of the judgment result about the amount of tax generated in the current period of the corporate tax finalization of the statement regarding the payment status etc. is shown.

  FIGS. 28A and 28B show examples of checklists displayed or output in the checklist creation processing of this embodiment. FIG. 28A is an example of a state in which only the check list is created (when the check list is not checked in step S25 in FIG. 16). FIG. 28B shows the check execution process. FIG. 16 is an example of a check list when it is performed (when a check list check is selected in step S25 in FIG. 16); The check list example in FIG. 28A can be used when items to be checked need to be listed. Also, in the check list example of FIG. 28-2, a comment is described in the determination reason column for items to be confirmed, and the items to be confirmed can be narrowed down.

  As described above, in this embodiment, when determining the credibility of the application data, if a company that performs processing is selected, application data corresponding to the selected company and data related to the application data (previous year data, etc. Data created by the system) is read out, and items to be checked based on the judgment information are automatically extracted to create a check list. For this reason, it is possible to prevent omission of confirmation and perform the check efficiently. In addition, when selecting to automatically compare with data related to the application to be judged, a checklist is created in which the confirmation items are extracted. Checks can be performed efficiently. In addition, when the confirmed data automatic check process is performed, the same data that has already been confirmed is displayed as confirmed, so that the time for confirmation can be saved and the check can be performed more efficiently. .

  FIG. 29 shows a client in a computer system having a function as a check list creation system for realizing the check list creation method of the second embodiment according to the present invention and capable of executing the check list creation program of the embodiment according to the present invention. 3 is a diagram illustrating a configuration example of a (terminal) 30. FIG. FIG. 30 is a diagram illustrating a configuration example of the server 50 in the computer system according to the second embodiment of the present invention. In the first embodiment, an example in which the checklist creation method is realized by one computer system has been described. However, in the present embodiment, the checklist creation method is realized by a client server system. As shown in FIGS. 29 and 30, the client 30 and the server 50 of this embodiment are connected to a network 40. There are no particular restrictions on the number of clients 30 and servers 50 that make up the checklist creation system of this embodiment.

  The configuration of the client 30 and the server 50 of this embodiment as a computer system is the same as in FIG. The client 30 according to the present embodiment includes a control unit 1a, an input unit 2a, and a storage unit having functions similar to those of the control unit 1, the input unit 2, the storage unit 3, the display unit 4, the communication unit 5, and the output unit 6, respectively. A unit 3a, a display unit 4a, a communication unit 5a, and an output unit 6a are provided. The storage unit 3a is not shown because the client 30 of this embodiment uses it as a primary storage area as needed during operation, but does not have a function specific to this embodiment. The server 50 includes a control unit 1b, a storage unit 3b, and a communication unit 5b having functions similar to those of the control unit 1, the storage unit 3, and the communication unit 5 in FIG.

  As shown in FIG. 29, the client 30 of this embodiment includes an instruction unit 21 and a data management unit 22 on the control unit 1a. Further, as shown in FIG. 30, the components on the control unit 1b of the server 50 of this embodiment are the same as the components of the control unit 1 of the check list creation apparatus of the first embodiment. ) Except for adding 23, it is the same as the constituent elements of the control unit 1 of the check list creation apparatus of the first embodiment. The data and information stored in the storage unit 3b of the server 50 of the present embodiment are the same as the data and information stored in the control unit 3 of the check list creation device of the first embodiment. Components having the same functions as those in the first embodiment are denoted by the same reference numerals as those in the first embodiment, and description thereof is omitted.

  In the present embodiment, the server 50 performs the processing described in the first embodiment, and the client 30 receives, displays, and outputs an operator's input. Hereinafter, the operation of the present embodiment will be described only for parts different from the first embodiment. First, the check list creation processing of the present embodiment is started when the operator operates the input unit 2a of the client 30. Then, the instruction unit 21 receives the selection of the company name (or client code) by the operation of the operator's input unit 2a, and transmits the selected company name (or client code) to the server 50 via the communication unit 5a. At this time, the instruction unit 21 acquires a selectable company name from the server 50 via the communication unit 5a based on the application data management table, and the data management unit 22 displays the company name on the display unit 4a. Then, selection may be prompted from among them.

  On the other hand, in the server 50, the data management unit 23 receives the selected company name (or client code) via the communication unit 5 b and outputs it to the data selection unit 11. Then, the server 50 performs steps S11 to S13 of the first embodiment. In step S14 and step S15, since an input by the operator is required, the data selection unit 11 transmits display data for prompting the input to the client 30 via the data management unit 23 and the communication unit 5b. In the client 30, the data management unit 22 receives the display data via the communication unit 5a and displays it on the display unit 4a. Then, the instruction unit 21 receives an input from the operator input unit 2a and transmits the input result to the server 50 via the communication unit 5a. In the server 50, the data selection unit 11 via the communication unit 5b and the data management unit 23 is transmitted. Receives the input result and performs the same processing as in the first embodiment.

  Similarly, in the subsequent checklist creation process, in the step that requires display, data is transmitted from the server 50 to the client 30 via the data management unit 23 and the communication unit 5b, and the client 30 manages data via the communication unit 5a. The unit 22 receives the data and displays it on the display unit 4a. Further, in a process that requires input by the operator, the instruction unit 21 receives input from the operator via the input unit 2a, transmits the input result to the server 50 via the communication unit 5a, and the data management unit 23 of the server 50 The input result is received via the communication unit 5b, and the input result is sent to the component that processes the input result. The component performs the same processing as in the first embodiment based on the input result. Processing other than the display processing of this embodiment and the reception of input by the operator is the same as that of the first embodiment.

  As described above, in the present embodiment, since the server client system performs the same processing as in the first embodiment, even when there are a plurality of operators, it is possible to perform processing that maintains data consistency. In addition, data can be managed more easily than when these data are held for each computer system.

  As described above, the checklist creation method, the checklist creation apparatus, the checklist creation system, and the checklist creation program according to the present invention create a checklist that supports the determination of the authenticity of data created by various application systems. Suitable for equipment and system.

1 shows a configuration example of a computer system that has a function as a check list creation device for realizing the check list creation method according to the first embodiment of the present invention and can execute the check list creation program according to the first embodiment of the present invention. FIG. It is a block diagram which shows the function structural example of a check list production apparatus. It is a figure which shows an example of an accounting data table. It is a figure which shows an example of a corporate tax data table. It is a figure which shows an example of an application data management table. It is a figure which shows an example of system management information. It is a figure which shows an example of a check content management table. It is a flowchart which shows an example of the procedure of an application data check process. It is a figure which shows an example of a check company table. It is a figure which shows an example of a check ID table. It is a figure which shows an example of the input screen of a setting item. It is a figure which shows an example of display setting information. It is a figure which shows an example of a user setting information table. It is a figure which shows an example of a check list table. It is a figure which shows an example of the screen display based on a check list table. It is a figure which shows an example of the screen after input confirmation confirmed. It is a figure which shows an example of the updated check list table. It is a flowchart which shows an example of the procedure of a check list creation process. It is a figure which shows an example of check list log table management information. It is a figure which shows an example of a check list log table. It is a flowchart which shows an example of the procedure of a confirmed data automatic check process. It is a figure which shows an example of the procedure of a check execution process in case a check content is an amount ratio check. It is a figure which shows an example of the determination information of the ratio check of the amount of check content data. It is a figure which shows an example of the ratio check table of money amount. It is a figure which shows an example of the check table of the ratio check of the amount after writing the column of the ratio of the present period and the previous period. It is a figure which shows an example of the temporary determination information table updated based on user setting information. It is a figure which shows an example of a comment data table. It is a figure which shows an example of the procedure of the check execution process of a character check. It is a figure which shows an example of the determination information of the character check of check content data. It is a figure which shows an example of a character check table. It is a figure which shows the example of the determination result of the authenticity evaluation process with respect to an address. It is a figure which shows the example of the determination result of an expense expense. It is a figure which shows the example of the determination result regarding the amount of tax generated in the current period of the corporate tax finalization of the statement regarding the payment status of Attached Table 5 (2) tax and public dues. It is a figure which shows an example of the display of the state which only created the check list. It is a figure showing an example of a check list at the time of performing check execution processing. Example of client configuration in a computer system having a function as a check list creation system for realizing the check list creation method of the second embodiment according to the present invention and capable of executing the check list creation program of the embodiment according to the present invention FIG. It is a figure which shows the structural example of the server in the computer system of Example 2 concerning this invention.

Explanation of symbols

1, 1a, 1b Control unit 2, 2a Input unit 3, 3b Storage unit 4, 4a Display unit 5, 5a, 5b Communication unit 6, 6a Output unit 7 System bus 11 Data selection unit 12 Check content selection unit 13 Check content data Reading unit 14 Check list creation unit 15 Check execution unit 16 Check result creation unit 17 Check result output unit 21 Instruction unit 22, 23 Data management unit 30 Client 40 Network 50 Server

Claims (25)

A checklist creation method for creating a checklist for checking the authenticity of data created by an application system for each company,
For each check content that is a type of check for application data, a check content data storage step that stores check content data including a definition of a check item in the storage unit;
The data selection unit accepts the selection of the company that creates the checklist, reads “correspondence between company and client code” stored in the storage unit, and based on the correspondence, the client corresponding to the selected company A company selection step that asks for the code as the selected client code;
Application system extraction step in which the data selection unit reads “correspondence between client code and application system” stored in the storage unit, and extracts an application system corresponding to the selected client code based on the correspondence When,
The data selection unit reads “correspondence between application system and check content applied to application data created by the application system” stored in the storage unit, and corresponds to the extracted application system based on the correspondence. A check content acquisition step for selecting the check content to be performed;
A check list creation unit that reads check content data corresponding to the selected check content from the storage unit and creates a check list based on the check content data;
A checklist creation method characterized by including:   The check list creation method according to claim 1, wherein the definition of the check item includes comparison with previous year data.   The check list creation method according to claim 1, wherein the definition of the check item includes a comparison with application data created in another application system. The check content data further includes a determination condition for determining whether each check item is a confirmation required item,
The checklist further includes a column indicating a determination result,
The check execution unit reads the application data created by the extracted application system from the storage unit, determines whether each check item is a confirmation item based on the determination condition, and is determined as a confirmation item. A determination step of storing a determination result indicating that it is a confirmation required item in association with a field indicating the determination result of the check list,
The checklist creation method according to claim 1, further comprising: The checklist further includes a confirmation column indicating whether confirmation has been made,
further,
A checklist output unit that performs control for displaying the checklist on a display unit;
The check list output unit accepts an input indicating that the operator has confirmed for each check item determined as the confirmation required item, and indicates that the item that has received this input has been confirmed. A confirmed setting step for performing control for setting a value in the confirmation column;
The checklist creation method according to claim 4, further comprising: further,
A check identifier assigning step in which the data selection unit assigns a check identifier for identifying a checklist group reflecting a confirmed flag of a past checklist;
The check execution unit stores the check list and the check identifier after the confirmed setting step in association with each other in the storage unit, and after the check list creation processing is completed, the stored check list and the check identifier are used as a check list log table. A checklist log table holding step held in the storage unit;
The check execution unit refers to the check list log table of the storage unit for the items determined as the confirmation required items in the determination step, and the same check identifier as the record for which the confirmed flag of the check list log table is set; If the value is the same item, a confirmation determination step for performing control to set the confirmation column corresponding to that item in the check list to a value indicating confirmation;
The checklist creation method according to claim 5, further comprising: A user setting information setting step in which the data selection unit accepts a change request by an operator for the determination condition, and stores the received content in the storage unit as user setting information;
Further including
7. The checklist creation method according to claim 4, 5 or 6, wherein in the determination step, it is further determined whether the item is a confirmation required item based on the user setting information.   The check list creation method according to claim 1, wherein the application system is a financial or tax application. A checklist creation device for creating a checklist for checking the authenticity of data created by an application system for each company,
For each check content that is a type of check for application data, a storage unit for storing check content data including definitions of check items;
Accept the selection of the company that creates the checklist, read the "correspondence between the company and the client code" stored in advance in the storage unit, based on the correspondence, the client code corresponding to the selected company, A data selection part to be obtained as the selected client code;
The “correspondence between the client code and the application system” stored in advance in the storage unit is read, and an application system corresponding to the selected client code is extracted based on the correspondence, and is also stored in the storage unit in advance. Read stored “correspondence between application system and check content to be applied to application data created by the application system”, and obtain check content corresponding to the extracted application system based on the correspondence And
A check list creation unit that reads check content data corresponding to the acquired check content from the storage unit and creates a check list based on the check content data;
A checklist creation device comprising:   The check list creation apparatus according to claim 9, wherein the definition of the check item includes comparison with previous year data.   The check list creation apparatus according to claim 9 or 10, wherein the definition of the check item includes a comparison with application data created by another application system. The check content data further includes a determination condition for determining whether each check item is a confirmation required item,
The checklist further includes a column indicating a determination result,
further,
Read application data created by the extracted application system stored in advance in the storage unit, determine whether each check item is a confirmation item based on the determination condition, and determine as a confirmation item For the item that has been made, a check execution unit that stores a determination result indicating that it is a confirmation required item in association with a column indicating the determination result of the check list,
The check list creation device according to claim 9, 10, or 11. The checklist further includes a confirmation column indicating whether confirmation has been made,
further,
Control for displaying the check list on the display unit, and for each check item determined as the confirmation required item, an input indicating that it has been confirmed by the operator is received, and the item that has received this input For, a checklist output unit that performs control for setting a value indicating confirmation in the confirmation column,
The check list creation apparatus according to claim 12, comprising: The data selection unit further assigns a check identifier for identifying a group of checklists reflecting a confirmed flag of a past checklist;
The check execution unit further stores the check list and the check identifier after the confirmation column setting control by the check list output unit in association with each other in the storage unit, and stores the check list after the check list creation processing is completed. A check list and a check identifier are stored in the storage unit as a check list log table,
The check execution unit further refers to the check list log table of the storage unit for the items determined as the confirmation required items, and the same check identifier and the same as the record in which the confirmed flag of the check list log table is set 14. The check list creation apparatus according to claim 13, wherein if the value is an item value, control is performed to set a confirmation column corresponding to the item of the check list to a value indicating that the item has been confirmed. . The data selection unit further receives a change request by the operator for the determination condition, and stores the received content as user setting information in the storage unit,
The check list creation device according to claim 12, 13 or 14, wherein the check execution unit further determines whether or not the item is a confirmation required item based on the user setting information.   The check list creation apparatus according to claim 9, wherein the application system is a financial or tax application. A checklist creation system comprising a server and a terminal connected to the server via a network, and creating a checklist for checking the authenticity of data created by an application system for each company,
The terminal
An instruction unit that accepts the selection of the company that creates the checklist;
A first communication unit that transmits the result received by the instruction unit as input data to a server;
The server
For each check content that is a type of check for application data, a storage unit for storing check content data including definitions of check items;
A second communication unit that receives the input data from the terminal;
A data management unit that distributes the input data received by the second communication unit to each unit;
Receives the input data from the data management unit, reads "correspondence between company and client code" stored in advance in the storage unit, and based on the correspondence, a client code corresponding to the input data is selected A data selection unit required as a client code,
The “correspondence between the client code and the application system” stored in advance in the storage unit is read, and an application system corresponding to the selected client code is extracted based on the correspondence, and is also stored in the storage unit in advance. Read stored “correspondence between application system and check content to be applied to application data created by the application system”, and obtain check content corresponding to the extracted application system based on the correspondence And
A check list creation unit that reads check content data corresponding to the acquired check content from the storage unit and creates a check list based on the check content data;
A checklist creation system characterized by comprising:   18. The check list creation system according to claim 17, wherein the definition of the check item includes comparison with previous year data.   19. The check list creation system according to claim 17, wherein the definition of the check item includes a comparison with application data created by another application system. The check content data further includes a determination condition for determining whether each check item is a confirmation required item,
The checklist further includes a column indicating a determination result,
further,
Read application data created by the extracted application system stored in advance in the storage unit, determine whether each check item is a confirmation item based on the determination condition, and determine as a confirmation item For the item that has been made, a check execution unit that stores a determination result indicating that it is a confirmation required item in association with a column indicating the determination result of the check list,
The checklist creation system according to claim 17, 18, or 19. The checklist further includes a confirmation column indicating whether confirmation has been made,
The first communication unit receives data transmitted from the server;
The server
A check list output unit for transmitting display data for displaying the check list to the terminal via a data management unit and a communication unit;
Further comprising
The second communication unit transmits the display data to the terminal,
The terminal
A terminal-side data management unit that receives the display data from the first communication unit and performs control for displaying the display data on the display unit;
Further comprising
The instruction unit receives an input indicating that the operator has confirmed each check item determined to be the confirmation required item, and sends the received item to the server via the first communication unit. Send
The second communication unit receives the item that accepted the input,
The data management unit sends the item that received the input to the checklist output unit,
21. The check list according to claim 20, wherein the check list output unit performs control to set a value indicating that confirmation has been made based on an item that has received the input in a confirmation column of the check list. Creation system. The data selection unit further assigns a check identifier for identifying a group of checklists reflecting a confirmed flag of a past checklist;
The check execution unit further stores the check list and the check identifier after the confirmation column setting control by the check list output unit in association with each other in the storage unit, and stores the check list after the check list creation processing is completed. A check list and a check identifier are stored in the storage unit as a check list log table,
The check execution unit further refers to the check list log table of the storage unit for the items determined as the confirmation required items, and the same check identifier and the same as the record in which the confirmed flag of the check list log table is set The check list creation system according to claim 21, wherein when the value is an item value, control is performed to set a confirmation column corresponding to the item of the check list to a value indicating that the item has been confirmed. . The instruction unit further accepts a change request by the operator for the determination condition, and transmits the change request to the server via the first communication unit;
The second communication unit receives the change request;
The data management unit sends the change request to the data selection unit;
The data selection unit stores the contents of the change request as user setting information in the storage unit,
23. The check list creation system according to claim 20, 21 or 22, wherein the check execution unit further determines whether the item is a confirmation required item based on the user setting information.   The checklist creation system according to any one of claims 17 to 23, wherein the application system is a financial or tax application.   A check list creation program that causes a computer to execute the check list creation method according to claim 1.

Images