JP2005084915A - Information processing apparatus, information processing method and program - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide an information processing apparatus that easily achieves journalization even if journalization parameters are varied. <P>SOLUTION: The information processing apparatus includes a journalization parameter setting means 24 by which the journalization parameters for journalizing accounting management data are stored, in association with journalization numbers for identifying the journalization parameters; and a journalization means 22, by which the accounting management data associated with slip numbers for identifying the accounting management data are journalized, in accordance with the journalization parameters for creation of journalization data associated with the slip numbers and the journalization numbers of the journalization parameters journalizing the accounting management data are stored in association with the slip numbers. The information processor may further include a re-journalization means 23, by which when the journalization parameters are varied by the journalization parameter setting means 24, the accounting management data associated with the journalization numbers of the journalization parameters varied are extracted and the accounting management data extracted are re-journalized by the journalization parameters, to replace the data with journalization data associated with the slip numbers of the accounting management data extracted. <P>COPYRIGHT: (C)2005,JPO&NCIPI

Description

  The present invention relates to an information processing apparatus, an information processing method, and an information processing program for journaling accounting management data, particularly accounting management data related to the construction industry.

  Today, it is common for economic management of companies and organizations to perform accounting processing and financial management including journalization by an accounting system using a computer. In this case, create accounting management data to manage the handling of expenses within the organization, and based on the accounting management data, determine the debit items and credit items for the receipt and withdrawal data with business partners, product cost data, etc. Journal data that can be used in the accounting system is created and accounted for.

  In the case of the construction industry, this cost data includes the delivery data of the trader, the volume data of the trader, the actual performance data by construction related to the employee's attendance and leaving work, the employee's business trip / temporary payment / advancement settlement data, and the like. Here, the delivery data of the supplier is the data that is input the contents of the delivery note of materials etc. purchased from the supplier, and the output data of the supplier is the work volume within one month of the work ordered outsourced to the supplier (construction work) Progress)), the actual performance data by construction means the man-hour data required for the construction work by the employee, and the employee's business trip / provisional payment / advancement settlement data means the employee's business trip settlement, provisional payment settlement, Refers to data for advanced payment.

  The creation of this journal data requires knowledge that is familiar with accounting, so even if it is computerized by business software, journaling work is difficult.

  In addition, there is a system in which an icon indicating transaction contents is prepared, and even a user who has no knowledge of bookkeeping automatically calls a journal by clicking the icon, processes the journal, and registers it in a database (for example, Patent Document 1). ). In this method, journal entries can be automatically made from the transaction contents of the designated icon, so that journal entries can be made without knowledge of accounting.

  Furthermore, there is a system for automatically journaling by extracting journal data for the same month of the same year from journal data generated in the past and correcting the difference in the amount (for example, Patent Document 2).

  However, in this patent document 1, the process which a user selects an icon from business content arises, and it does not perform journalizing automatically. In addition, Patent Document 2 is suitable for an accounting system with a lot of annual regular work, but when there are many annual exception work, new journal data must be created, which requires time and effort. Was.

Generally, journal data is converted into journal data according to the rules of the journal data automatic generation parameter for automatically creating journal data from cost data and deposit / withdrawal data.
JP 2002-230255 A JP 2002-99696 A

  However, even if journals are automatically entered using journal parameters, if journal parameters change, such as when the system is installed, it is necessary to investigate cost data and deposit / withdrawal data that have already been created, and re-create journal data. was there.

  Accordingly, an object of the present invention is to provide an information processing apparatus, an information processing method, and an information processing program that easily perform a journal entry even when a journal entry parameter is changed.

  In order to solve the above-described problem, an information processing apparatus according to the first feature of the present invention includes a journal parameter setting unit that stores journal parameters that journal accounting data in association with journal numbers that identify journal parameters; The accounting data associated with the slip number identifying the accounting data is journalized according to the journal parameters to create the journal data associated with the slip number, and the journal number journal number that journaled the accounting data is entered into the slip. Journalizing means for storing in association with the number.

  As described above, according to the present invention, the journal number and the voucher number are associated with the accounting data before the journal, and the voucher number before the journal is associated with the journal data after the journal. It is easy to track journal data.

  If the journal parameter is changed by the journal parameter setting means, the accounting management data associated with the journal number of the changed journal parameter is extracted, and the extracted accounting management data is journalized again with the changed journal parameter. It is preferable to further include a re-journal unit that replaces the journal data associated with the slip number of the extracted accounting management data.

  In this case, even if the journal parameter is changed by the journal parameter setting means, the change slip can be easily extracted or replaced.

  In addition, when the accounting management data relates to the construction industry, the accounting management data includes cost data related to the cost of construction and deposit / withdrawal data related to deposit / withdrawal, and the journal parameters of the cost data include any of slip type, element and construction information. Preferably, the journal parameter of the deposit / withdrawal data is set for any one or more items of the denomination, account, and construction information.

  In this case, it is possible to accurately determine the journal entry pattern for the accounting data related to the construction industry.

  According to a second aspect of the present invention, there is provided an information processing method comprising: a journal parameter setting unit storing a journal parameter for journal accounting data in association with a journal number for identifying a journal parameter; The accounting data associated with the slip number identifying the management data is journalized according to the journal entry parameter to create the journal data associated with the slip number, and the journal entry journal number for which the accounting data is journaled is entered as the slip number. And storing the information in association with each other.

  Further, when the journal parameter is changed by the journal parameter setting means, the accounting data associated with the journal number of the changed journal parameter is extracted by the re-journal means, and the extracted accounting management data is changed. It is preferable that the method further includes a step of journalizing again with the parameters and replacing the journal data associated with the slip number of the extracted accounting management data.

  In addition, when the accounting management data relates to the construction industry, the accounting management data includes cost data related to the cost of construction and deposit / withdrawal data related to deposit / withdrawal, and the journal parameters of the cost data include any of slip type, element and construction information. Preferably, the journal parameter of the deposit / withdrawal data is set for any one or more items of the denomination, account, and construction information.

  An information processing program according to a third aspect of the present invention includes a journal parameter setting step for storing a journal parameter for journalizing accounting management data in association with a journal number for identifying the journal parameter, and a slip number for identifying the accounting management data. Journal entry step that creates the journal data associated with the document number by journaling the accounting data associated with the document according to the journal parameter, and further stores the journal parameter journal number associated with the accounting data in association with the document number And let the computer run.

  Therefore, according to the present invention, it is possible to provide an information processing apparatus, an information processing method, and an information processing program that easily perform a journal entry even when a journal entry parameter is changed.

  Next, embodiments of the present invention will be described with reference to the drawings. In the following description of the drawings, the same or similar parts are denoted by the same or similar reference numerals.

  With reference to FIG. 1, the journalizing apparatus 1 which concerns on the best embodiment of this invention, and the journalizing system 2 using the journalizing apparatus 1 are demonstrated. The journalizing device (information processing device) 1 is realized by installing a software program for executing a predetermined process in a general computer including a central processing control device and a memory.

  The journalizing device 1 according to the preferred embodiment of the present invention includes a construction data storage device 11, a journal parameter storage device 12, a cost data storage device 13, a deposit / withdrawal data storage device 14, a journal data storage device 15, and a data acquisition means 21. , Journalizing means 22, re-journaling means 23, journalizing parameter setting means 24, form creation means 25, communication control device 31, input device 32, display device 33, and input / output control device 34.

  The construction data storage device 11 is a storage device that stores data related to construction managed by the journalizing device 1, and has a data structure and an example of data as shown in FIG. That is, the construction data storage device 11 stores construction information such as a construction code for identifying a construction, a construction name, a construction type, a construction state indicating completion or incomplete, a site address, and a person in charge.

  The journal parameter storage device 12 is a storage device that stores journal parameters that journal accounting management data in the journal device 1 according to the preferred embodiment of the present invention in association with journal numbers that identify the journal parameters. An example of data structure and data as shown is provided. That is, the journal parameter storage device 12 stores the slip type of data to be journalized, construction status, elements (material cost, subcontracting cost, labor cost, communication cost, power utility cost, etc.), denomination (cash, bill, check, etc.) Parameters such as accounts to be traded and debit items and credit items determined by these items are stored in association with journal numbers that uniquely identify journal parameters. The slip types here are slip types such as cost data and deposit / withdrawal data for journalizing, such as supplier delivery data, exit data, provisional payment settlement data, business trip settlement data, deposit data, and payment data.

  The cost data storage device 13 is a storage device that stores the cost data of the accounting management data. As shown in FIG. 4A, the supplier delivery data, the supplier volume data, the employee actual results data, and the employee business trips. It is subdivided into provisional payment settlement data, etc., and is associated with a slip number that uniquely identifies the data. When journalizing cost data, the slip type, element, and construction information are used as the journal key. The journal number of the journal parameter is associated with the journalized cost data.

  The deposit / withdrawal data storage device 14 is a storage device that stores the deposit / withdrawal data of the accounting management data. As shown in FIG. 4B, the deposit / withdrawal data storage device 14 is subdivided into deposit / withdrawal data and uniquely identifies the data. Associated with the slip number. When journalizing deposit / withdrawal data, the slip type, denomination, account, and construction information are used as the journal key. The journal entry number of the journal parameter is associated with the journalized deposit / withdrawal data.

  The journal data storage device 15 is a storage device for storing the data of the cost data storage device 13 and the deposit / withdrawal data storage device 14 journalized by the journalizing means 22.

  The data acquisition means 21 is means for acquiring data input from the client terminals 4a, 4b, 4c,... And storing it in the cost data storage device 13 and the deposit / withdrawal data storage device. The data acquisition means 21 may acquire data from the client terminals 4a, 4b, 4c... Via the in-house communication network 3.

  The journalizing unit 22 journalizes the accounting management data stored in the cost data storage device 13 and the deposit / withdrawal data storage device 14 in accordance with the journal parameters stored in the journal parameter storage device 12, and generates journal data associated with the slip number. This is means for storing the journal number of the journal parameter created and further journalizing the accounting management data in the journal data storage device 15 in association with the slip number.

  When the journal parameter stored in the journal parameter storage device 12 is changed by the journal parameter setting unit 24, the re-journal means 23 and the cost data storage device 13 and the deposit / withdrawal data associated with the journal number of the changed journal parameter. Means for extracting the accounting management data stored in the storage device 14, re-registering the extracted accounting management data with the changed journal parameters, and replacing the journal data associated with the slip number of the extracted accounting management data; is there.

  The journal parameter setting means 24 is a means for storing the journal parameter for journalizing accounting management data in the journal parameter storage device 12 in association with the journal number for identifying the journal parameter.

  The form creation unit 25 is a unit that creates a financial statement with reference to the journal data storage device 15 and creates a cost management table with reference to the cost data storage device 13.

  The communication control device 31 is a device serving as an interface for the journalizing device 1 to connect to the in-house communication network 3, and is a LAN card, a LAN board, or the like. The input device 32 is a device that inputs data to the journalizing device 1 and includes a keyboard and a mouse. The display device 33 is a device that displays a screen presented by the journalizing device 1, and is a liquid crystal display, a CRT display, or the like. The input / output control device 34 is a device that controls input and output of the journalizing device 1 and transmits it to the central processing control device.

  Next, the journalizing means 22 and the re-journaling means 23 will be described in detail with reference to FIGS.

  The journalizing means 22 will be described with reference to FIG. First, the case where the accounting management data to be journalized is the cost data D1 will be described. Since the cost data D1 has not been journalized yet, no journal number is set. When the slip type, element, and construction information data that are the journal data key of the cost data are acquired with reference to the cost data D1, it can be seen that the slip type and the element are “delivered by supplier” and “material”, respectively. Although construction data is not described, it is assumed that it is “unfinished”.

  The journal entry means 22 refers to these data and detects a matching record from the journal parameter storage device 12a. Here, since the journal number “001” is applicable, the journal data D2 is created in which the slip number “00001”, “unfinished material cost” as the debit item, and “construction payable” as the credit item are set. At this time, the journal number “001” obtained by journalizing the cost data D1 is set in the journal number field of the cost data D1, and the cost data D3 is created.

  The re-journaling means 23 will be described with reference to FIG. For the journal number “001”, the journal parameter storage device 12a shown in FIG. 5 has the credit item “Construction Payable”, whereas the journal parameter storage device 12b shown in FIG. It has been changed to.

  The re-journaling means 23 searches the cost data, extracts the record with the journal number “001”, and acquires the slip number “00001”. The re-journal means 23 creates journal data D4 in which the new journal parameter, that is, the credit item “accrued” is set from the journal data D2 of the journal data storage device 15 slip number “00001”. When journalizing is performed using a newly established journal number, the journal number item of the cost data D3 is also updated.

  Next, with reference to FIGS. 7 and 8, the journalizing method according to the best mode of the present invention will be described.

  First, in step S101, the data acquisition means 21 acquires accounting management data including cost data and deposit / withdrawal data input from the client terminals 4a to 4c, and stores them in the cost data storage device 13 and the deposit / withdrawal data storage device 14. To do.

  Next, in step S102, the journalizing means 22 acquires slip type, element, and construction information data for cost data, and acquires slip type, denomination, account, and construction information data for deposit / withdrawal data. . In step S103, the construction data storage device 11 is referred to from the construction information to determine whether the construction is completed or not completed.

  Next, in step S104, using the information acquired in steps S101 to S103, the slip type is determined and the journal pattern is searched.

  That is, in step S105, the debit / credit item is specified from the journal entry pattern of the supplier delivery data for the accounting delivery data. In step S106, a debit / credit item is specified from the journal pattern of the trader volume data for the trader volume data. In step S107, the debit / credit item is specified from the journal pattern of the actual record data for the actual record data. About step S108, about a business trip temporary payment advance payment adjustment data, a debit and a credit item are specified from the journal entry pattern of business trip temporary payment advance payment adjustment data. In step S109, a debit / credit item is specified for the deposit data from the journal entry pattern of the deposit data. In step S110, a debit / credit item is specified for the withdrawal data from the journal entry pattern of the withdrawal data.

  In step S111, journal data is created with the debit / credit items specified in steps S105 to S110 and stored in the journal data storage device 15.

  Next, in step S111, the journal number obtained by journalizing the respective data is set in the cost data storage device 13 and the deposit / withdrawal data storage device.

  Here, it is assumed that the journal parameter setting unit 24 changes the journal parameter in the journal parameter storage device 12.

  When the journal parameter is changed, the re-journal means 23 extracts the changed journal number from the journal parameter storage device 12 in step S113. In step S114, the cost data storage device 13 and the deposit / withdrawal data storage device 14 are extracted. To search for and extract the data with the changed journal number.

  In step S 115, journal data is re-created for the extracted data and stored in the journal data storage device 15.

  Next, examples of screens presented by the journalizing device 1 according to the preferred embodiment of the present invention will be described with reference to FIGS.

  First, FIG. 9 shows an example of a journal pattern setting screen P101 when journal parameters are set in the journal parameter setting means 24. In the journal pattern presentation unit 111, a journal number (journal pattern) is designated. In the journal pattern list section 112, a slip classification, a department code, a construction code, a person in charge code, a purpose code, a contractor code, a bank code, a contractor code, an element code, etc. are designated, and a slip pattern corresponding to this journal number Register. In the journal entry pattern setting unit 116, the elements, denominations, departments, and the like set in the delivery data and receipt data are specified. The journal pattern output setting unit 113 sets a subject corresponding to the information specified by the journal pattern setting unit 116. The application editing unit 114 sets application information to be set in the journal. In the comment section 115, the setter enters a comment for the journal number. The journal pattern set on the journal pattern setting screen P101 is stored in the journal parameter storage device 12 by the journal parameter setting means 24.

  FIG. 10 is an example of a delivery input screen P102 for registering supplier delivery data by the data acquisition means 21. In the delivery data input unit 121, the department, slip date, order number, trader name, slip form, etc. of the delivery data are registered, and the details of the delivery are entered in the detail input unit 122. The information registered on the delivery input screen P102 is stored in the cost data storage device 13 by the data acquisition means 21.

  FIG. 11 shows an example of a journal entry slip display screen P103, which is a journal entry slip created from delivery data. The cost item (varies depending on the elements set in the delivery slip) is set for the debit, and the construction payable is set for the credit.

  According to the preferred embodiment of the present invention, by adding the journal number journal number to the data before journal entry, even if the journal parameter is changed, the change record can be easily identified. It can be done easily.

  Further, by associating the data before the journal and the data after the journal with the slip number, it is possible to easily track the data after the journal even when the journal parameter is changed.

  As described above, the present invention has been described according to the best mode for carrying out the invention. However, it should not be understood that the description and drawings constituting a part of this disclosure limit the present invention. From this disclosure, various alternative embodiments, examples, and operational techniques will be apparent to those skilled in the art.

  It goes without saying that the present invention includes various embodiments not described herein. Therefore, the technical scope of the present invention is defined only by the invention specifying matters according to the scope of claims reasonable from the above description.

FIG. 1 is a functional block diagram of a journalizing apparatus according to the preferred embodiment of the present invention and a system configuration diagram of a journalizing system using the journalizing apparatus. FIG. 2 is a diagram showing an example of the data structure and data of the construction data storage device according to the preferred embodiment of the present invention. FIG. 3 is a diagram showing an example of the data structure and data of the journal entry parameter storage device according to the preferred embodiment of the present invention. FIG. 4A is a diagram showing data types of the cost data storage device, and FIG. 4B is a diagram showing data types of deposit / withdrawal data. FIG. 5 is a diagram for explaining journalizing means according to the preferred embodiment of the present invention. FIG. 6 is a diagram for explaining re-journaling means according to the preferred embodiment of the present invention. FIG. 7 is a flowchart of the journalizing method according to the preferred embodiment of the present invention. (Part 1) FIG. 8 is a flowchart of the journalizing method according to the preferred embodiment of the present invention. (Part 2) FIG. 9 shows an example of a journal pattern setting screen according to the preferred embodiment of the present invention. FIG. 10 is an example of a delivery input screen according to the preferred embodiment of the present invention. FIG. 11 shows an example of a journal entry presentation screen according to the preferred embodiment of the present invention.

Explanation of symbols

DESCRIPTION OF SYMBOLS 1 ... Journal device 2 ... Journal system 3 ... In-house communication network 4a-4c ... Client terminal 11 ... Construction data storage device 12 ... Journal parameter storage device 13 ... Cost data storage device 14 ... Deposit / withdrawal data storage device 15 ... Journal data storage device DESCRIPTION OF SYMBOLS 21 ... Data acquisition means 22 ... Journal entry means 23 ... Re-journal means 24 ... Journal parameter setting means 25 ... Form preparation means 31 ... Communication control device 32 ... Input device 33 ... Display device 34 ... Input / output control device 111 ... Journal pattern presentation part DESCRIPTION OF SYMBOLS 112 ... Journal entry pattern list part 113 ... Journal entry pattern output setting part 114 ... Application edit part 115 ... Comment part 116 ... Journal entry pattern setting part 121 ... Delivery data input part 122 ... Detail input part 131 ... Journal data input part 132 ... Detail input part

Claims (7)

Journal parameter setting means for storing journal parameters for journal accounting data in association with journal numbers for identifying the journal parameters;
The journal parameter that journalizes the accounting management data associated with the slip number identifying the accounting management data according to the journal entry parameter to create the journal data associated with the slip number, and further journalizes the accounting management data. An information processing apparatus comprising: journalizing means for storing the journal number in association with the slip number. When the journal parameter is changed by the journal parameter setting means, the accounting management data associated with the journal number of the changed journal parameter is extracted, and the extracted accounting management data is changed to the journal parameter. 2. The information processing apparatus according to claim 1, further comprising: re-journaling means for re-journaling and replacing with the journal data associated with the slip number of the extracted accounting management data. When the accounting management data relates to the construction industry, the accounting management data includes cost data relating to the cost of construction and deposit / withdrawal data relating to deposit / withdrawal,
The journal parameter of the cost data is set for any one or more items of slip type, element, and construction information,
The information processing apparatus according to claim 1, wherein the journal entry parameter of the deposit / withdrawal data is set for one or more items of a denomination, an account, and construction information. A journal parameter setting unit for storing journal parameters for journalizing accounting data in association with a journal number for identifying the journal parameters;
The journalizing means creates the journal data associated with the slip number by journaling the accounting management data associated with the slip number for identifying the accounting management data according to the journal parameter, and further categorizing the accounting management data. And a step of storing the journal number of the journal parameter associated with the slip number. When the journal parameter is changed by the journal parameter setting means, the accounting data associated with the journal number of the changed journal parameter is extracted by the re-journal means, and the extracted accounting management data is The information processing method according to claim 4, further comprising the step of: journalizing again with the changed journal parameter and replacing the journal data associated with the slip number of the extracted accounting management data. When the accounting management data relates to the construction industry, the accounting management data includes cost data relating to the cost of construction and deposit / withdrawal data relating to deposit / withdrawal,
The journal parameter of the cost data is set for one or more items of slip type, element and construction information,
The information processing method according to claim 4 or 5, wherein the journal entry parameter of the deposit / withdrawal data is set for any one or more items of denomination, account, and construction information. Journal parameter setting step for storing journal parameters for journal accounting data in association with journal numbers for identifying the journal parameters;
The journal parameter that journalizes the accounting management data associated with the slip number identifying the accounting management data according to the journal entry parameter to create the journal data associated with the slip number, and further journalizes the accounting management data. An information processing program for causing a computer to execute a journalizing step for storing the journal number in association with the slip number.