Account item statement creation device, account item statement creation method, and account item statement creation program

The account item breakdown statement creation device addresses the challenge of varying account items and customer information management by automatically generating statements with total amount checks and alerts, enhancing efficiency and accuracy in accounting systems.

JP7583880B2Active Publication Date: 2024-11-14OBIC CO LTD
View PDF 6 Cites 0 Cited by

Patent Information

Application Number
JP2023140126
Authority / Receiving Office
JP · JP
Patent Type
Patents
Current Assignee / Owner
Filing Date
2023-08-30
Publication Date
2024-11-14
Estimated Expiration
2040-02-26

AI Technical Summary

Technical Problem

Existing accounting systems struggle to automatically create account item breakdown statements due to variations in account items and customer information management methods across different companies, making it impossible to unconditionally define which items should be recorded or aggregated.

Method used

An account item breakdown statement creation device and method that includes a storage section for journal data and a control section to manage account items and customer information, allowing automatic creation of breakdown statements by linking auxiliary classifications and using a breakdown statement target subject master to calculate totals and output alerts for discrepancies.

Benefits of technology

This solution enables efficient and accurate automatic creation of account item breakdown statements, reducing manual effort, minimizing errors, and facilitating system revisions by managing variations in account items and customer information management across companies.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure 0007583880000001
    Figure 0007583880000001
  • Figure 0007583880000002
    Figure 0007583880000002
  • Figure 0007583880000003
    Figure 0007583880000003
Patent Text Reader

Abstract

To provide a device, method, and program for generating a statement classified by account titles, which allow the statement classified by account titles to be automatically generated by acquiring data required for the statement classified by account titles from journalized data in which account titles for use and items for managing clients are different by companies.SOLUTION: A prescribed type of itemized statement data is generated from journalized data on the basis of an itemized statement object title master in which types of itemized statements included in a statement classified by account titles, journalized account titles which are to be used in the types of itemized statements and are included in the journalized data, and sub-divisions which are to be used for specifying clients of the journalized account titles and are included in the journalized data are set in association with each other.SELECTED DRAWING: Figure 3
Need to check novelty before this filing date? Find Prior Art

Description

[Technical field]

[0001] The present invention relates to an account item statement creation device, an account item statement creation method, and an account item statement creation program. [Background technology]

[0002] Patent Document 1 discloses a configuration for automatically creating more than 20 types of itemized statements by creating in advance intermediate files related to details of specified items in itemized statements for each account item and sub-item, and automatically inputting the data contained in the intermediate files in a designated format determined according to each of the more than 20 types of itemized statements. [Prior art documents] [Patent documents]

[0003] [Patent Document 1] JP 2001-142959 A Summary of the Invention [Problem to be solved by the invention]

[0004] However, in the invention described in Patent Document 1 above, the items used in the accounting system to manage information on account items and business partners vary from company to company, so when creating an account item breakdown statement from journal entry data, the system was unable to define which account item should be entered or which item to use to tally up the account amount.

[0005] The present invention has been made in consideration of the above problems, and aims to provide an account item statement creation device, an account item statement creation method, and an account item statement creation program that can obtain the data necessary for an account item statement from journal data in which the account items used and the items managing business partners differ from company to company, and automatically create each account item statement. [Means for solving the problem]

[0006] In order to solve the above-mentioned problems and achieve the object, the account item breakdown statement creation device of the present invention is an account item breakdown statement creation device equipped with a memory unit and a control unit, wherein the memory unit comprises a journal entry storage means for storing journal data, and a breakdown target item storage means for storing a breakdown target item master that links and sets the type of breakdown included in the account item breakdown statement, the journal entry account item included in the journal entry data to be used for the breakdown of that type, and the auxiliary classification included in the journal entry data to be used to identify the client of the journal entry account item, and the control unit comprises a breakdown creation means for creating breakdown data of a specified type from the journal entry data based on the breakdown target item master.

[0007] In addition, in the account item breakdown statement creation device of the present invention, the statement creation means creates revised statement data corresponding to a correction instruction for the statement data, and the control unit calculates a total amount of the details of each account item included in the revised statement data, and calculates the total amount of the details of the journal entry account item corresponding to the account item included in the journal data based on the statement target item master, and is further characterized in that it is provided with a total amount determination means for determining whether there is a difference between the total amount of the details of the account item and the total amount of the details of the journal entry account item, and an alert output means for outputting an alert when the total amount determination means determines that there is a difference.

[0008] In the account item breakdown statement preparation device according to the present invention, the correction instruction is an instruction to combine or divide the details.

[0009] In addition, in the account item breakdown statement creation device of the present invention, the journal entry storage means stores the journal entry data for each department within a corporation, and the storage unit further includes a hierarchy storage means for storing a hierarchy master that sets an organizational hierarchy within the corporation, and the statement creation means is further characterized in that, when a hierarchical aggregation instruction for the statement data is input, it aggregates the journal entry data of the departments included in the hierarchy corresponding to the hierarchical aggregation instruction based on the hierarchy master, and creates the specified type of hierarchical statement data from the journal entry data based on the statement target item master.

[0010] In addition, in the account item breakdown statement creation device of the present invention, the control unit further includes a breakdown output means for outputting the breakdown data or the hierarchical breakdown data, and the breakdown output means is characterized in that when the hierarchical aggregation instruction is input while the breakdown data is being output, it switches to and outputs the hierarchical breakdown data.

[0011] In addition, in the account item breakdown statement creation device of the present invention, when the hierarchical aggregation instruction is input when the number of details of the breakdown data exceeds 100, the breakdown creation means aggregates the journal entry data of the departments included in the hierarchy corresponding to the hierarchical aggregation instruction based on the hierarchy master, and creates the hierarchical breakdown data of the specified type from the journal entry data based on the breakdown target item master.

[0012] In the account item item breakdown statement preparation device according to the present invention, the predetermined type is the type selected on a statement selection screen that allows the statement to be selected.

[0013] In addition, in the account item breakdown statement creation device of the present invention, when an amount check instruction is input for the total amount of the details of the account item, the total amount determination means calculates the total amount of the details of each account item included in the revised statement data, calculates the total amount of the details of the journal entry account item corresponding to the account item included in the journal data based on the statement target item master, and determines whether there is a difference between the total amount of the details of the account item and the total amount of the details of the journal entry account item.

[0014] In addition, the account item breakdown statement creation method of the present invention is a method for creating an account item breakdown statement to be executed by an account item breakdown statement creation device having a memory unit and a control unit, wherein the memory unit comprises a journal entry storage means for storing journal data, and a breakdown target item storage means for storing a breakdown target item master that links and sets the type of breakdown included in the account item breakdown statement, the journal entry account item included in the journal entry data to be used for the breakdown of that type, and the auxiliary classification included in the journal entry data to be used for the business partner of the journal entry account item, and is characterized in that the method includes a breakdown creation step, which is executed by the control unit, of creating a predetermined type of breakdown data from the journal entry data based on the breakdown target item master.

[0015] In addition, the account item breakdown statement creation program of the present invention is an account item breakdown statement creation program to be executed by an account item breakdown statement creation device having a memory unit and a control unit, wherein the memory unit comprises a journal entry storage means for storing journal data, and a breakdown target item storage means for storing a breakdown target item master that links and sets the type of breakdown included in the account item breakdown statement, the journal entry account item included in the journal entry data to be used for the breakdown of that type, and the auxiliary classification included in the journal entry data to be used to identify the client of the journal entry account item, and is characterized in that the control unit executes a breakdown creation step of creating breakdown data of a specified type from the journal entry data based on the breakdown target item master. Effect of the Invention

[0016] According to the present invention, it is possible to automatically obtain data required for an account item breakdown statement from journal data held in a financial accounting system, and to automatically create various itemized statement data. As a result, according to the present invention, it is possible to significantly reduce the effort required for creating an account item breakdown statement. In addition, according to the present invention, it is possible to automatically check whether the total amount for each account item is correct when the details are edited by manual input. As a result, according to the present invention, it is possible to efficiently check the amount, and it is possible to reduce the risk of mistakes due to human error. In addition, according to the present invention, it is possible to create an account item breakdown statement within the accounting system. In addition, according to the present invention, it is possible to easily respond to system changes by setting the master. [Brief description of the drawings]

[0017] [Figure 1] FIG. 1 is a diagram showing an example of a manual process for creating a statement of account item breakdown. [Diagram 2] FIG. 2 is a diagram showing an overview of the account item breakdown statement creation process in this embodiment. [Diagram 3] FIG. 3 is a block diagram showing an example of the configuration of an account item breakdown statement preparation device in this embodiment. [Figure 4] FIG. 4 is a flowchart showing an example of the process of the account item breakdown statement preparation device in this embodiment. [Diagram 5] FIG. 5 is a diagram showing an example of the account item breakdown statement creation process in this embodiment. [Figure 6] FIG. 6 is a diagram showing an example of the breakdown correction process in this embodiment. [Figure 7] FIG. 7 is a diagram showing an example of the breakdown correction process in this embodiment. [Figure 8] FIG. 8 is a diagram showing an example of the breakdown correction process in this embodiment. [Figure 9]FIG. 9 is a diagram illustrating an example of a hierarchy master in this embodiment. [Figure 10] FIG. 10 is a diagram showing an example of a layer selection screen in this embodiment. [Figure 11] FIG. 11 is a diagram showing an example of the establishment-specific breakdown creation process in this embodiment. [Figure 12] FIG. 12 is a diagram showing an example of a breakdown target subject master setting screen in this embodiment. [Figure 13] FIG. 13 is a diagram showing an example of the breakdown selection screen in this embodiment. [Figure 14] FIG. 14 is a diagram showing an example of the breakdown display screen in this embodiment. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS

[0018] DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of the present invention will be described in detail with reference to the drawings. However, the present invention is not limited to the embodiment.

[0019] [1. Overview] First, an overview of the present invention will be described with reference to Fig. 1 and Fig. 2. Fig. 1 is a diagram showing an example of a manual accounting item statement creation process. Fig. 2 is a diagram showing an overview of an accounting item statement creation process in this embodiment.

[0020] When filing corporate tax returns, it is necessary to prepare a statement of account item details as a type of attached document. However, in conventional general accounting systems, although the information necessary to prepare a statement of account item details was managed within the system, it was not possible to create the statement data within the system, and so it was necessary to check subsidiary ledgers and various ledgers and create each statement manually outside the system.

[0021] That is, since the account items used by each company are various, it was not possible to define which account items should be written for each itemized statement in the system in general. For example, as shown in Figure 1, Company A uses only "accounts receivable" as an account item related to accounts receivable or unpaid income, but Company C uses "installment accounts receivable" in addition to "accounts receivable", so it was not possible to define which account items should be written for each itemized statement in general. Also, since the operation methods of information management of business partners vary from company to company, it was not possible to create a statement of account item breakdown in general on the system in the past. For example, as shown in Figure 1, Company A aggregates amounts based on the "sub-account" item in the current account, but Company B aggregates amounts based on the "business partner" item, so it was not possible to create a statement of account item breakdown in general on the system. Also, since the operation methods of information management of business partners vary depending on account items within a company, it was not possible to create a statement of account item breakdown in general on the system. For example, as shown in Figure 1, in the current account, amounts are added up based on the "Subsidiary Account" item, in the accounts receivable account, the "Customer" item, and in the installment receivable account, the "Customer" item, so it was not possible for the system to simply create a detailed account item breakdown.

[0022] Therefore, in this embodiment, the account items used in each breakdown are managed in a master, and the item in which the client information is managed for each item is managed in a master. This provides a mechanism that makes it possible to automatically create breakdowns for information managed by the system, even if the items and operation methods used by each corporation are different.

[0023] For example, as shown in Figure 2, in this embodiment, the amounts required for each itemization are calculated from the journal data shown in Figure 1 based on the setting information of each company registered in the itemization target subject master, thereby absorbing the differences in operations between companies and the differences in information used for each itemization, and automatically creating each itemization data within the system.

[0024] [2. Configuration] An example of the configuration of the account item breakdown statement preparation device 100 according to this embodiment will be described with reference to Fig. 3. Fig. 3 is a block diagram showing an example of the configuration of the account item breakdown statement preparation device 100 in this embodiment.

[0025] 3, the account item item breakdown statement creation device 100 is a commercially available desktop personal computer. The account item item breakdown statement creation device 100 is not limited to a stationary information processing device such as a desktop personal computer, but may be a portable information processing device such as a commercially available notebook personal computer, a PDA (Personal Digital Assistant), a smartphone, or a tablet personal computer.

[0026] The account item item breakdown statement creation device 100 comprises a control unit 102, a communication interface unit 104, a memory unit 106, and an input / output interface unit 108. Each unit of the account item item breakdown statement creation device 100 is connected to each other so as to be able to communicate with each other via an arbitrary communication path.

[0027] The communication interface unit 104 communicably connects the account item breakdown statement creation device 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with other devices via the communication line. Here, the network 300 has a function of connecting the account item breakdown statement creation device 100 and the server 200 to each other so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network).

[0028] The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 records computer programs for cooperating with an OS (Operating System) to give instructions to a CPU (Central Processing Unit) to perform various processes. For example, memory devices such as RAM (Random Access Memory) and ROM (Read Only Memory), fixed disk devices such as hard disks, flexible disks, and optical disks can be used as the storage unit 106. The storage unit 106 includes a journal entry file 106a, a breakdown target subject master 106b, a hierarchy master 106c, and a breakdown file 106d.

[0029] The journal entry file 106a stores journal entry data. Here, the journal entry file 106a may store journal entry data for each department in a corporation.

[0030] The itemized statement target item master 106b is a master that links the type of itemized statement (account item) included in the account item breakdown statement, the journal entry account item included in the journal entry data that is used for that type of itemized statement, and the auxiliary classification included in the journal entry data that is used to identify the business partner of that journal entry account item.

[0031] The hierarchy master 106c is a master that sets organizational hierarchies within a corporation. Here, the hierarchy master 106c may be a master that sets the organization within a corporation into several hierarchies (e.g., four levels) such as companies, business establishments, departments, and sections. The hierarchy master 106c may also be a master that sets the organization within a corporate group into several hierarchies (e.g., four levels) such as groups, individual companies, business establishments, and departments.

[0032] The itemized statement file 106d stores itemized statement data of the itemized statement. Here, the itemized statement file 106d may store a predetermined type of itemized statement data. Here, the predetermined type may be deposits, etc., bills receivable, accounts receivable (uncollected income), provisional payments (advance payments), loans and interest received, inventory (goods or finished products, semi-finished products, work in progress, raw materials, and supplies), securities, fixed assets (limited to land, rights and buildings existing on land), bills payable, accounts payable (accrued amounts and unpaid expenses), provisional payments (advance payments and deposits), withholding income tax deposits, loans and interest paid, land sales, etc., (by business establishment) sales, etc., officer's remuneration allowances, etc. and personnel expenses, land rent, etc., royalties for use of industrial property rights, etc., miscellaneous profits, miscellaneous losses, etc. Also, the itemized statement file 106d may store corrected itemized statement data corresponding to a correction instruction for the itemized statement data. Furthermore, the breakdown file 106d may store hierarchical breakdown data corresponding to a hierarchical aggregation instruction for the breakdown data.

[0033] An input device 112 and an output device 114 are connected to the input / output interface unit 108. The output device 114 may be a monitor (including a touch panel), a speaker, or a printer. The input device 112 may be a keyboard, a mouse, a microphone, or a monitor that cooperates with a mouse to realize a pointing device function. In the following, the output device 114 may be referred to as the monitor 114 or the printer 114, and the input device 112 may be referred to as the keyboard 112 or the mouse 112.

[0034] The control unit 102 is a CPU or the like that comprehensively controls the account item item breakdown statement preparation device 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs that define various processing procedures, required data, etc., and executes various information processing based on these stored programs. In terms of functional concept, the control unit 102 includes an itemized statement preparation unit 102a, a data output unit 102b, and a total amount determination unit 102c.

[0035] The statement creation unit 102a creates statement data of a statement included in the account item breakdown statement. Here, the statement creation unit 102a may create a predetermined type of statement data from the journal data based on the statement target item master 106b. Here, the predetermined type may be a type (account item) selected on a statement selection screen that allows a statement to be selected. In addition, the statement creation unit 102a may create corrected statement data corresponding to a correction instruction for the statement data, corrected statement data, or hierarchical statement data. Here, the correction instruction may be a detail integration instruction or a division instruction. In addition, when a hierarchical aggregation instruction for the statement data is input, the statement creation unit 102a may aggregate the journal data of the department included in the hierarchical level corresponding to the hierarchical aggregation instruction based on the hierarchical master 106c, and create a predetermined type of hierarchical statement data from the journal data based on the statement target item master 106b. Furthermore, when a hierarchical aggregation instruction is input when the number of details in the breakdown data exceeds 100, the breakdown creation unit 102a may aggregate the journal data of departments included in the hierarchical level corresponding to the hierarchical aggregation instruction based on the hierarchical master 106c, and create a predetermined type of hierarchical breakdown data from the journal data based on the breakdown target subject master 106b. Furthermore, the breakdown creation unit 102a may register the breakdown data, the revised breakdown data, or the hierarchical breakdown data in the breakdown file 106d.

[0036] The data output unit 102b outputs data. Here, the data output unit 102b may output itemized statement data, revised itemized statement data, or hierarchical statement data. Furthermore, when a hierarchical aggregation instruction is input while the data output unit 102b is outputting itemized statement data, the data output unit 102b may switch to outputting the itemized statement data by hierarchy. Furthermore, the data output unit 102b may output an alert. Furthermore, the data output unit 102b may output an alert when the total amount determination unit 102c determines that there is a difference.

[0037] The total amount determination unit 102c determines whether there is a difference between the total amount of the details of each account item included in the corrected breakdown data and the total amount of the details of the journal account item corresponding to the account item included in the journal data. Here, the total amount determination unit 102c may calculate the total amount of the details of each account item included in the corrected breakdown data, calculate the total amount of the details of the journal account item corresponding to the account item included in the journal data based on the breakdown target item master 106b, and determine whether there is a difference between the total amount of the details of the account item and the total amount of the details of the journal account item. In addition, when an amount check instruction for the total amount of the details of the account item is input, the total amount determination unit 102c may calculate the total amount of the details of each account item included in the corrected breakdown data, calculate the total amount of the details of the journal account item corresponding to the account item included in the journal data based on the breakdown target item master 106b, and determine whether there is a difference between the total amount of the details of the account item and the total amount of the details of the journal account item.

[0038] [3. Specific Examples] A specific example of this embodiment will be described with reference to FIGS.

[0039] [Account item breakdown statement creation process] Here, an example of an account item item breakdown statement preparation process in this embodiment will be described with reference to Fig. 4. Fig. 4 is a flowchart showing an example of the process of the account item item breakdown statement preparation device 100 in this embodiment.

[0040] As shown in FIG. 4, when a user selects a specific type of breakdown on the breakdown selection screen displayed on the output device 114 via the input device 112, the statement creation unit 102a creates the specific type of breakdown data from the company's journal data stored in the journal file 106a based on the statement target subject master 106b (step SA-1).

[0041] Then, the data output unit 102b causes the output device 114 to display a breakdown display screen including the breakdown data (step SA-2).

[0042] Then, the data output unit 102b judges whether or not the user has input an instruction to correct the breakdown data on the breakdown display screen displayed on the output device 114 via the input device 112 (step SA-3).

[0043] If the data output unit 102b determines that no correction instruction has been input (step SA-3: No), it shifts the process to step SA-4.

[0044] Then, the itemized statement preparation unit 102a registers the itemized statement data or the corrected itemized statement data in the itemized statement file 106d (step SA-4), and ends the process.

[0045] On the other hand, if the data output unit 102b determines that a correction instruction has been input (step SA-3: Yes), it shifts the process to step SA-5.

[0046] Then, the itemized statement preparation unit 102a prepares corrected itemized statement data corresponding to the correction instruction (step SA-5).

[0047] Then, the data output unit 102b causes the output device 114 to display the breakdown display screen including the corrected breakdown data (step SA-6).

[0048] Then, when the user presses the amount check button on the statement display screen displayed on the output device 114 via the input device 112, the total amount determination unit 102c calculates the total amount of the details of each account item included in the revised statement data, calculates the total amount of the details of the journal entry account item corresponding to the account item included in the journal data based on the statement target item master 106b, and determines whether there is a difference between the total amount of the details of the account item and the total amount of the details of the journal entry account item (step SA-7).

[0049] If the total amount determination unit 102c determines that there is no difference between the total amount of the details of the account item and the total amount of the details of the journalized account item (step SA-7: No), it shifts the process to step SA-4.

[0050] On the other hand, if the total amount determination unit 102c determines that there is a difference between the total amount of the details of the account item and the total amount of the details of the journalizing account item (step SA-7: Yes), it shifts the process to step SA-8.

[0051] Then, the data output unit 102b causes the output device 114 to display the alert (step SA-8).

[0052] Then, the data output unit 102b judges whether or not the user has input a correction instruction for the corrected breakdown data on the breakdown display screen displayed on the output device 114 via the input device 112 (step SA-9).

[0053] If the data output unit 102b determines that no correction instruction has been input (step SA-9: No), it shifts the process to step SA-2.

[0054] On the other hand, if the data output unit 102b determines that a correction instruction has been input (step SA-9: Yes), it shifts the process to step SA-5.

[0055] Here, a specific example of the account item item breakdown statement creation process in this embodiment will be described with reference to Fig. 5. Fig. 5 is a diagram showing an example of the account item item breakdown statement creation process in this embodiment.

[0056] As shown in FIG. 5, in this embodiment, when the user selects the types of breakdown (breakdown types) of "deposits, etc.," "notes receivable," and "accounts receivable (unpaid income)" on the breakdown selection screen, the journal amounts of each account item included in the journal data registered in the journal file 106a by the user's daily journal entry input are added up for each client based on the journal account items (items) included in the journal data to be used for the breakdown of that breakdown type, which are pre-registered in the breakdown target item master 106b, and the auxiliary classification included in the journal data to be used to identify the client of that item, to create breakdown data for "deposits, etc.," "notes receivable," and "accounts receivable (unpaid income)."

[0057] An overview of the itemized statement correction process in this embodiment will be described with reference to Fig. 6. Fig. 6 is a diagram showing an example of the itemized statement correction process in this embodiment.

[0058] As shown in Fig. 6, in this embodiment, corrected breakdown data is created in response to manual correction operations on the breakdown data automatically created from the journal data, and the amount check function checks the total amount of the corrected breakdown data against the total amount of the subject items of the journal data. As a result, in this embodiment, not only can the risk of mistakes due to human error be reduced and the risk of reporting the wrong amount to the tax office can be eliminated, but the amount checking work can also be made more efficient.

[0059] A specific example of the itemized statement correction process in this embodiment will be described with reference to Fig. 7. Fig. 7 is a diagram showing an example of the itemized statement correction process in this embodiment.

[0060] As shown in Fig. 7, in this embodiment, the breakdown data of accounts receivable, etc., automatically created from journal data, had to be consolidated into one detail because the business partners, A (Stock Company) YY Division and A (Stock Company) ZZ Division, are the same company. Therefore, as shown in Fig. 7, in this embodiment, when a user inputs an instruction to delete the detail data of accounts receivable, etc. displayed on the detail display screen (step SB-1), the detail data related to A (Stock Company) ZZ Division is deleted, and when a user inputs an instruction to amend the detail data related to A (Stock Company) YY Division to the amount by adding the amount of the detail related to A (Stock Company) ZZ Division, the amount is amended (step SB-2). Then, as shown in FIG. 7, in this embodiment, when a user inputs an instruction to check the amount, the total amount of each account item is tallied, and the total amount of the details of the journal entry account item corresponding to that account item included in the journal entry data is automatically calculated (step SB-3), and the total amount of each account item is compared with the total amount of the details of the journal entry account item corresponding to that account item (step SB-4), and if the amounts match, registration is performed.

[0061] A specific example of the itemized statement correction process in this embodiment will be described with reference to Fig. 8. Fig. 8 is a diagram showing an example of the itemized statement correction process in this embodiment.

[0062] As shown in FIG. 8, in this embodiment, B (stock) actually includes two companies, B (stock) and B' (stock), and the amount of the statement related to B (stock) is the amount for two companies, so it was necessary to split it into two statements. Therefore, as shown in FIG. 8, in this embodiment, when a user inputs an instruction to copy the statement data to be split for the statement data of accounts receivable, etc. displayed on the statement display screen, the statement data related to B (stock) is copied (step SC-1). Then, as shown in FIG. 8, in this embodiment, when a user inputs an instruction to correct the statement data related to the two B (stocks) based on the transaction information with each company recorded in the accounts receivable ledger or customer ledger, the counterparty name and / or end balance of the statement data related to the two B (stocks) is corrected (step SC-2). Then, as shown in FIG. 8, in this embodiment, when a user inputs an instruction to check the amount, the total amount of each account item is tallied, and the total amount of the details of the journal entry account item corresponding to that account item included in the journal entry data is automatically calculated (step SC-3), and the total amount of each account item is compared with the total amount of the details of the journal entry account item corresponding to that account item (step SC-4), and if the amounts match, registration is performed.

[0063] A specific example of the process of creating a breakdown by establishment in this embodiment will be described with reference to Fig. 9 to Fig. 11. Fig. 9 is a diagram showing an example of the hierarchical master 106c in this embodiment. Fig. 10 is a diagram showing an example of a hierarchical selection screen in this embodiment. Fig. 11 is a diagram showing an example of the process of creating a breakdown by establishment in this embodiment.

[0064] For some types of itemized statements, if the number of details exceeds 100, it is permitted to tally and state the amounts for each organizational level, such as business establishment or base, but as with journal entry account items, the way in which the organizational levels are managed also differs from company to company. Therefore, as shown in Fig. 9, in this embodiment, a mechanism is provided that corresponds to the mode in which the amounts on the itemized statements are tallyed for each business establishment by setting the items that manage the business establishments in the master.

[0065] In this embodiment, when the business establishment tally category is selected by the user on the hierarchical selection screen shown in Fig. 10, as shown in Fig. 11, the department included in the hierarchical level within the enterprise corresponding to the business establishment tally category is identified based on the hierarchical master 106c, the journal data of the department is aggregated from the journal file 106a, and the journal account item and the auxiliary category to be used in the type of breakdown selected by the user on the breakdown selection screen and the journal account item to be aggregated are identified based on the breakdown target subject master 106b, and the hierarchy-specific breakdown data of the type can be created from the journal data. Furthermore, as shown in Fig. 11, in this embodiment, when the details by auxiliary category exceed 100, the user can select the business establishment tally category on the screen to switch between the breakdown data by auxiliary category and the breakdown data by business establishment.

[0066] Moreover, an example of a breakdown sheet target subject master setting screen in this embodiment will be described with reference to Fig. 12. Fig. 12 is a diagram showing an example of a breakdown sheet target subject master setting screen in this embodiment.

[0067] As shown in FIG. 12, in this embodiment, a journal account item and a sub-category can be set for each corporation on a breakdown statement target item master setting screen (breakdown statement target item master maintenance).

[0068] Moreover, an example of the breakdown selection screen in this embodiment will be described with reference to Fig. 13. Fig. 13 is a diagram showing an example of the breakdown selection screen in this embodiment.

[0069] As shown in FIG. 13, in this embodiment, the user can select the type of breakdown data that he or she wishes to create on the breakdown selection screen.

[0070] Moreover, an example of the breakdown display screen in this embodiment will be described with reference to Fig. 14. Fig. 14 is a diagram showing an example of the breakdown display screen in this embodiment.

[0071] As shown in FIG. 14, in this embodiment, the automatically created itemized statement data can be displayed for each detail, and instructions to correct the detail data, instructions to check the amount of the corrected itemized statement data, and instructions to register the itemized statement data can be accepted from the user.

[0072] [4. Other embodiments] The present invention may be embodied in various different embodiments other than those described above within the scope of the technical concept set forth in the claims.

[0073] For example, among the processes described in the embodiments, all or part of the processes described as being performed automatically can be performed manually, or all or part of the processes described as being performed manually can be performed automatically using known methods.

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

[0075] Moreover, with regard to the account item breakdown statement preparation device 100, the components shown in the figures are merely functional concepts, and do not necessarily have to be physically configured as shown in the figures.

[0076] For example, the processing functions of the account item breakdown statement preparation device 100, particularly the processing functions performed by the control unit 102, may be realized in whole or in part by a CPU and a program interpreted and executed by the CPU, or may be realized as hardware using wired logic. The program is recorded in a non-transient computer-readable recording medium that includes programmed instructions for causing the information processing device to execute the processing described in this embodiment, and is mechanically read by the account item breakdown statement preparation device 100 as necessary. That is, a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive). This computer program is executed by being loaded into a RAM, and cooperates with the CPU to form a control unit.

[0077] In addition, this computer program may be stored in an application program server connected to the account item breakdown statement creation device 100 via any network, and it is also possible to download all or part of it as needed.

[0078] In addition, the program for executing the process described in this embodiment may be stored in a non-transient computer-readable recording medium, or may be configured as a program product. Here, the "recording medium" includes any "portable physical medium" such as a memory card, a Universal Serial Bus (USB) memory, a Secure Digital (SD) card, a flexible disk, a magneto-optical disk, a ROM, an Erasable Programmable Read Only Memory (EPROM), an Electrically Erasable and Programmable Read Only Memory (EEPROM (registered trademark)), a Compact Disk Read Only Memory (CD-ROM), a Magneto-Optical disk (MO), a Digital Versatile Disk (DVD), and a Blu-ray (registered trademark) Disc.

[0079] Moreover, a "program" is a data processing method written in any language or description method, and may be in any form, such as source code or binary code. Note that a "program" is not necessarily limited to a single configuration, but also includes a configuration that is distributed as a plurality of modules or libraries, and a program that achieves its function by cooperating with a separate program, such as an OS. Note that the specific configuration and reading procedure for reading a recording medium in each device shown in this embodiment, as well as the installation procedure after reading, may use well-known configurations and procedures.

[0080] The various databases etc. stored in the memory unit 106 are storage means such as memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks, and store various programs, tables, databases, and web page files etc. used for various processes and providing websites.

[0081] The account item item breakdown statement creation device 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device connected to any peripheral device. The account item item breakdown statement creation device 100 may be realized by installing software (including programs or data, etc.) that causes the device to realize the processing described in this embodiment.

[0082] Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the drawings, and all or part of them can be functionally or physically distributed and integrated in any unit according to various additions or functional loads. In other words, the above-mentioned embodiments can be implemented in any combination, or the embodiments can be implemented selectively. [Industrial Applicability]

[0083] Since the present invention relates to a technology relating to corporate tax returns, it is useful in all industries regardless of the type of business or industry. [Explanation of symbols]

[0084] 100 Account item breakdown statement preparation device 102 Control section 102a Breakdown Preparation Department 102b Data output section 102c Total amount determination section 104 Communication interface section 106 Storage section 106a Journal File 106b Master of items covered by the breakdown sheet 106c Hierarchy Master 106d Breakdown File 108 Input / Output Interface Section 112 Input Devices 114 Output Device 200 Servers 300 Network

Claims

1. An account item breakdown statement creation device having a memory unit and a control unit, The storage unit is A journal entry storage means for storing journal entry data; a description target subject storage means for storing a description target subject master that is set by linking the type of description included in the account description statement, the journal entry account included in the journal data to be used for the description of the type, and a sub-category in which an aggregation item for aggregating the journal entry account is set; Equipped with The control unit is a statement creation means for calculating a total amount by adding up the journal amounts of the respective journal account items for each of the summary items from the journal data based on the statement target item master, and creating statement data of the type in which the journal account item is used, in which the total amount is set; An account item breakdown statement creation device comprising:

2. The itemized statement creation means includes: Furthermore, corrected itemized statement data corresponding to the correction instruction for the itemized statement data is generated, The control unit is a total amount determination means for calculating the total amount of the details of each account item included in the revised statement data, calculating the total amount of the details of the journal entry account item corresponding to the account item included in the journal data based on the statement target item master, and determining whether or not there is a difference between the total amount of the details of the account item and the total amount of the details of the journal entry account item; an alert output means for outputting an alert when the total amount determination means determines that there is a difference; 2. The device for creating an account item breakdown statement according to claim 1, further comprising:

3. The modification instruction is:

3. The device for creating a detailed account item breakdown statement according to claim 2, wherein the instruction is an instruction to integrate or divide the details.

4. The journal entry storage means includes: The journal entry data is stored for each division within the corporation; The storage unit is a hierarchy storage means for storing a hierarchy master that sets an organizational hierarchy within the corporation; Further comprising: The itemized statement creation means includes: The account item breakdown statement creation device of claim 1 further comprises, when a hierarchical aggregation instruction for the breakdown data is input, the journal entry data of the departments included in the hierarchy corresponding to the hierarchical aggregation instruction is aggregated based on the hierarchy master, and a specified type of hierarchical breakdown data is created from the journal entry data based on the breakdown target item master.

5. The control unit is a statement output means for outputting the statement data or the hierarchy-based statement data; Further comprising: The itemized statement output means includes: An account item breakdown statement creation device as described in claim 4, characterized in that when the hierarchical aggregation instruction is input while the breakdown data is being output, the device switches to the hierarchical breakdown data and outputs it.

6. The itemized statement creation means includes: The account item breakdown statement creation device described in claim 4 or 5, characterized in that when the hierarchical aggregation instruction is input when the number of details of the breakdown data exceeds 100, the journal entry data of the departments included in the hierarchy corresponding to the hierarchical aggregation instruction is aggregated based on the hierarchy master, and the specified type of hierarchical breakdown data is created from the journal entry data based on the breakdown target item master.

7. The predetermined type is:

6. The device for creating an account item breakdown statement according to claim 4, wherein the type is selected on a breakdown selection screen that allows the user to select the breakdown.

8. The total amount determination means The account item breakdown statement creation device of claim 2, characterized in that when an amount check instruction is input for the total amount of the details of the account item, the total amount of the details of each account item included in the revised statement data is calculated, the total amount of the details of the journal entry account item corresponding to the account item included in the journal data is calculated based on the statement target item master, and it is determined whether there is a difference between the total amount of the details of the account item and the total amount of the details of the journal entry account item.

9. The aggregation items are:

5. The device for creating an account item breakdown statement according to claim 1, wherein the item is a sub-item.

10. An account item statement preparation method to be executed by an account item statement preparation device having a storage unit and a control unit, The storage unit is A journal entry storage means for storing journal entry data; a description target subject storage means for storing a description target subject master that is set by linking the type of description included in the account description statement, the journal entry account included in the journal data to be used for the description of the type, and a sub-category in which an aggregation item for aggregating the journal entry account is set; Equipped with The control unit executes a statement creation step of calculating a total amount by adding up the journal amounts of the journal account items from the journal data based on the statement target item master, and creating statement data of the type in which the journal account item is used, in which the total amount is set; A method for preparing a statement of account item breakdown, comprising:

11. An account item item statement creation program to be executed by an account item item statement creation device having a storage unit and a control unit, The storage unit is A journal entry storage means for storing journal entry data; a description target subject storage means for storing a description target subject master that is set by linking the type of description included in the account description statement, the journal entry account included in the journal data to be used for the description of the type, and a sub-category in which an aggregation item for aggregating the journal entry account is set; Equipped with In the control unit, a statement creation step of calculating a total amount by adding up the journal amounts of the journal account items for each of the summary items from the journal data based on the statement target item master, and creating statement data of the type in which the journal account item is used, in which the total amount is set; A program for creating account item breakdown statements to execute the above.

Citation Information

Patent Citations

  • System and method for automatic journalizing processing

    JP2000222492A

  • Device for preparing account subject itemized statement and corporation business summary description for corporation tax application linked with financial account system

    JP2001142959A

  • System and program for public-service corporation accounting processing

    JP2002342547A

  • Accounting system, accounting method, and program

    JP2007122388A

  • Accounting processing system

    JP2012146158A