JP5282219B2 - Journal data creation device - Google Patents

Description

  The present invention relates to a journal data creation device, a journal data creation method, a journal data creation program, and a journal data creation program storage medium in which a journal data creation program is stored. .

In recent years, a lot of accounting software that can cope with remarkable progress in peripheral technology has been developed and spread, and the central function of this accounting software is a function for creating journal data.
When creating journal data, input the elements such as the date, debit, credit account, sub-account, department, amount, tax classification, etc. Input a summary word explaining the contents of the transaction, such as “From (To)”, “Other”, and its composition editing work (hereinafter, basic input means for inputting the above-mentioned journal elements one by one) Are sometimes referred to as “normal input.”) Conventional accounting software incorporates various functions designed to simplify the work process for creating journal data.
If this function is broadly classified, “Journal pattern” is registered in advance as “Journaling pattern” with “High-speed input” to fix specific journal elements such as accounts, and to input the description and the accompanying account items. , There are those that select and input this.
In “Fast entry”, the previous journal element is output as the cursor moves, and the correction entry is entered as necessary, or the account item / subsidiary subject can be selected by selecting the ledger or subledger (subledger). Instead of the journal entry screen with the name of “Journal element” such as “Book entry” or “Debit (credit) account” that directly inputs journal data to these books. Entry is done from a business-specific input screen with a name such as "Transaction Category" such as "On", and journal elements such as account items and auxiliary items are limited to a small number related to the business by selecting the business, and the selection is made There is also a “Journal-less input” that facilitates input.
In addition to “Journal pattern”, “Category elements” such as account items and “Fixed description” are registered in advance, and these are selected and entered, as well as selection of account items, account items and description phrases Enter part or all of them and select "Fixed description" or "Journal pattern", or select "Associative input" or "Journal pattern" hierarchically to limit the selection range and make the selection input easier There are input and collective selection input of “journal pattern”, and various details are devised.
However, even when an input means having the above-described functions is selected instead of “normal input”, for (partial) transactions that satisfy the constraint conditions for these means to exert their effects, etc. , Can exert the effect, usually, transaction volume, transaction pattern (standard / non-standard transaction), transaction type (direct debit, periodic payment, etc.), journal type (single / multiple journal), assistance If there is a discrepancy between the conditions given to the transaction subject to processing, such as the organization of the book (internal management by department or main branch account), and the constraint conditions, Or little or no. It is very difficult to explain all of these because the conditions are multidimensional and diverse.
Here, an essential problem included in the conventional technology is extracted and described while exemplifying main functions of the input means described above.
First of all, with regard to “high-speed input”, “book entry”, and “journal-less input”, compared with “normal input”, some classification elements such as the relevant account items are fixed. The selection range of journal elements is limited by the selection of the type of business, and the selection input becomes easy. Regardless of which input method is selected, even in transactions that occur regularly such as monthly, each transaction In addition, it is necessary to repeat repetitive operations such as (selection) input of segment elements that are not fixed, (selection) input of description words and phrases, and composition editing work of the description. In addition, when these input means are selected, it is usually not possible to select and input journal patterns, so the purpose is to create journal data, which is the basis for preparing financial statements. When necessary elements are acquired from “other elements” and journal data is used in other business, there is a problem that it is not an appropriate means.
As described later, regarding the selection input of “fixed summary”, there are innumerable number of summary words representing 1 “what”, and if a large number of summary words are registered, the selection input becomes difficult. In addition, for each transaction, the description must be composed and edited by inputting (directly) a description word representing 2 “where (from)” and, if necessary, 3 “other”.
In addition, regarding the selection entry of “journal pattern”, for example, the components of the summary are 1 “○ month”, 2 “◎◎ fee” (determination of account item), 3 “△△ number” (determination of department) ) When considering the number of combinations of components 1 to 4 in a transaction involving 4 “partner names”, even when taking into account supplementary input by selecting a fixed description or direct input of a character string, If compound journals are added to the increase in the transaction volume and the number of departments, it becomes extremely difficult or practically impossible to register the journal pattern and select and input it. For this reason, various studies and improvements have been made on registration and selection input means such as “associative input” and hierarchical selection input of “journal pattern”. However, in the conventional technology, in transactions that occur atypically like cash transactions, the frequency of occurrence is high in practice. For example, the combination of “what” and “from (to)” is fixed. Other than such transactions, “normal input” is also used (the reason will be described later), and even in transactions that occur regularly, such as monthly, the entry pattern selection input or insufficient for each transaction There is a problem in that it is necessary to repeat repetitive operations such as (selection) input of various classification elements, supplementation of summary words, correction input, and composition editing work.
In addition, with regard to the collective selection input of journal patterns, manual input such as correction input of variable elements included in the description, creation of new journals for changes in monthly journal pattern combinations, and summation of the amount by destination There is a problem such as having to do in.
Also, since individual transaction classifications such as taxable classification and funding classification are managed by account items and sub-accounts in the master, the transaction classification cannot be fixed, and it is necessary to check for each individual transaction and enter the correction There is a problem that it may be.
There is also a problem that the quality tends to be deteriorated because the summary input operation and the configuration editing operation are complicated.

The present invention solves the above-described problems and can easily create journal data including a summary of appropriate contents, journal data creating method, journal data creating method, journal data creating program, and journal data creating program storage medium The purpose is to provide.
In this specification, transactions for which journal data is to be created are classified into two patterns. The first pattern of transactions is basically a specific transaction such as account transfer such as electricity charges and telephone charges. Since the transaction is performed on a predetermined date with a specific trading partner, the transaction can be automatically selected and input as a “journal pattern” and is referred to as a “standard transaction”. Since the transaction of the second pattern is a transaction that is performed on an unspecified date with an unspecified trading partner for an unspecified transaction target, it is a transaction that requires manual input of the “journal pattern”. Referred to as a “trade transaction”.
Further, in this specification, the elements used for creating the journal data are classified into three types, and the first type element is an element that is fixed when the journal is created, and is referred to as a “fixed element”. The second type of element is an element that is unavoidable to be input to a computer through human resources, such as a sales amount that occurs irregularly in the creation of a journal, or a numerical value indicating “current month”. It is called “independent variable”. The third type of element is an element that can be automatically created based on a “fixed element” or an “independent variable element” when creating a journal, and is referred to as a “dependent variable element”.
Further, in this specification, data relating to a transaction prepared in advance in the “summary template” as shown in FIG. 7 is referred to as “candidate data”, and data relating to the generated transaction is referred to as “actual data”. .
Next, the means of the present invention for achieving the above object will be described.
The journal data creating apparatus according to claim 1 of the present invention is
A first journal storage unit comprising a journal number, a classification element, an auxiliary element, a summary element, and a combined summary element;
A first summary template storage unit comprising a summary number, a summary element, an auxiliary element, and a division element;
A first sub summary template storage unit comprising a sub summary number and a journal element;
Means for editing the summary element of the first summary template storage unit based on data input to the auxiliary element of the first summary template storage unit;
Means for editing the summary element of the first summary template storage unit based on the data input to the data obtaining unit, means for setting the segment element,
Means for extracting actual data from candidate data in the first summary template storage unit and transferring it to the first journal storage unit;
Means for configuring the summary element of the actual data transferred to the first journal storage unit and editing the combined summary element.
The means described above include an automatic editing function for summary elements, an automatic setting function for classification elements, an automatic extraction and transfer function for generated transactions, and an automatic configuration editing function for combined summary elements.
These functions are the minimum necessary for transactions that occur regularly, such as electricity / water charges, telephone charges, newspaper subscription charges, social insurance premiums, withholding tax / city prefectural tax account transfers, etc. When you enter the transfer date of the limit independent variable element, the amount of each transaction, etc., the description element is automatically edited, the classification element is automatically set, and the `` actual data '' generated from the `` candidate data '' of the `` summary template '' this month ”Is automatically extracted and transferred, the description elements are automatically configured, the description of the appropriate content that is well-formed is edited, and journal data is automatically created in a batch without human intervention. A transaction such as accruing unpaid expenses shown in a processing example 2 described later is similarly processed.
In addition, the automatic editing function for summary elements includes a search function, a calculation function, a function for converting numeric values into character strings, a function for setting a format by combining predefined character strings with input data, etc. The automatic setting function of the classification element includes a search function and a hierarchical calculation function, and can be expected to be used in a wide range of transactions.
In addition, the journal data creation device according to claim 2 of the present invention includes:
The transaction data receiving unit is provided with means for receiving the transaction data and transferring the transaction data to a journal element of the first summary template storage unit designated by the summary number.
The above-described means includes a journal pattern automatic selection function and an independent variable element automatic input function.
By adding these functions, as shown in Process Example 3 described later, a large amount occurs regularly, accounting for a large number of annual transactions such as sales recording, accounts receivable collection, purchase accounting, salary payments, settlement of accounts, etc. When the application department creates the application data by entering the minimum necessary independent variable data in the applicable business department, the transaction data necessary for creating the journal is fetched from the application data, and the description number is specified. `` Summary template '' is automatically selected, transaction data is automatically entered in the corresponding `` journal element '' based on the column-corresponding definition, and the journal data is automatically batched without any human intervention in the same manner as described above. Is created.
In addition, the journal data creation device according to claim 3 of the present invention includes:
Means for extracting identification data and amount data from the journal elements in the first journal storage unit, summing up the amounts of the same identification data, assigning a description number, and transferring to the journal processing unit;
Means for transferring the aggregated data transferred to the journal processing unit to the sorting element of the first summary template storage unit designated by the summary number.
The above-described means includes a summation function for the amount of money for each identification data, an automatic setting function for designated data, an automatic selection function for a journal pattern, and an automatic input function for an independent variable element.
With the addition of these functions, it is possible to automatically respond to changes in journal pattern combinations such as monthly, and it is also possible to automatically sum up the amount by identification data without human intervention, accrued expenses and accounts payable If you enter the debit data of the minimum necessary independent variable elements such as the amount of each transaction to account for the transaction and the summary phrase of some transactions, as shown in Process Example 2 below, Debit / Credit journal data is automatically created, and as shown in Process Example 4 below, a periodic payment bank transfer request form requires only a few manual inputs such as payment date and deduction amount. The journal data for debits and credits for periodic payments are automatically created all at once without any human intervention.
In addition, the journal data creating apparatus according to claim 4 of the present invention includes:
A second journal storage unit comprising a journal number, a classification element, an auxiliary element, an edited summary element, and a combined summary element;
A second summary template storage unit comprising a description number, a description element, and a segment element;
A second sub summary template storage unit comprising a sub summary number and a summary element;
The pre-edit summary element specified by the description number and the classification element, which are input to the auxiliary element of the second journal storage unit, are acquired, the pre-edit summary element specified by the secondary description number is acquired, and the pre-edit summary element that is acquired And a means for editing the post-edit summary element based on the data entered in the auxiliary element,
And a means for configuring the summary element after editing and editing the combined summary element.
The above-described means includes a function for simultaneously selecting and inputting a plurality of designated data, an automatic editing function for post-editing summary elements, and an automatic configuration editing function for combined summary elements.
In an atypical transaction such as a cash transaction, it is not possible to automatically select and enter a "journal pattern", so select and input multiple specified data for "summary template" and "sub-summary template" Set a fixed category element along with the selection of multiple description words such as “From (To)”, arrange the basic pattern of journals, and easily add supplementary description words, transaction date of receipts, number of transactions, etc. When a numerical value is input, the numerical value is converted into a character string, the summary element is edited in a format based on a predetermined definition, and the summary element is automatically configured to edit an appropriate summary with a good shape.
Further, the journal data creating apparatus according to claim 5 of the present invention is
A means for editing a summary element obtained by dividing a journal summary based on data input to a journal data creation unit according to a predefined algorithm;
A summary element is provided, and means for editing the combined summary element is provided.
In addition to the basic types shown in claims 1 and 4, the above-described summary configuration editing means performs configuration editing of the combined summary element performed in the first journal processing unit in the first summary template processing unit, Various implementations such as inputting the basic data in the journal data creation section including the application department, etc., implementing the two-step editing means in the application department, and receiving the edited summary at the transaction data receiving department Can be considered.
In addition, by automating the summary composition editing work, it is possible to select and input “summary template” for all transactions in the year, and for routine transactions, it is possible to automate repetitive work and create batch data automatically. Become.
As described above, the journal data creation device of the present invention automates the most complicated summary configuration editing work in the journal data creation work process in all transactions of the year, and is a typical transaction that accounts for the majority of transactions. With the automatic input of repetitive operations such as selecting and inputting “journal pattern” that is repeated regularly every month, etc., when the data of the minimum independent variable element is received or received by the transaction data receiving unit, etc. It is automatically created all at once without human intervention.
In addition, when creating journal data, it is possible to select “summary template” for all transactions, so by registering “other elements” in advance, it becomes possible to manage classification elements such as tax classifications for each transaction. Furthermore, it becomes possible to use the journal data for other business.
Moreover, the journal data creation method according to claim 6 of the present invention includes:
A first journal storage unit comprising a journal number, a classification element, an auxiliary element, a summary element, and a combined summary element;
A first summary template storage unit comprising a summary number, a summary element, an auxiliary element, and a division element;
In the journal data creating apparatus, comprising a first sub summary template storage unit comprising a sub summary number and a journal element,
Editing a summary element of the first summary model storage unit based on data input to the auxiliary elements of the first summary template storage unit, setting a segment element;
Editing the summary elements of the first summary model storage unit based on the data input to the data acquisition unit, setting the segment elements,
Extracting actual data from the candidate data in the first summary template storage unit and transferring it to the first journal storage unit;
Forming a summary element of the actual data transferred to the first journal storage unit, and editing the combined summary element.
Moreover, the journal data creation method according to claim 7 of the present invention includes:
The transaction data receiving unit receives the transaction data, and includes a step of transferring the transaction data to a journal element of the first summary template storage unit designated by the summary number.
Moreover, the journal data creation method according to claim 8 of the present invention includes:
Extracting identification data and amount data from the journal elements in the first journal storage unit, summing up the amounts of the same identification data, attaching a description number, and transferring to the journal processing unit;
And transferring the aggregated data transferred to the journal processing unit to the division element of the first summary template storage unit designated by the summary number.
Moreover, the journal data creation method according to claim 9 of the present invention includes:
A second journal storage unit comprising a journal number, a classification element, an auxiliary element, an edited summary element, and a combined summary element;
A second summary template storage unit comprising a description number, a description element, and a segment element;
In the journal data creation device, comprising a second sub summary template storage unit comprising a sub summary number and a summary element,
The pre-edit summary element specified by the description number and the classification element, which are input to the auxiliary element of the second journal storage unit, are acquired, the pre-edit summary element specified by the secondary description number is acquired, and the pre-edit summary element that is acquired Editing the summary element after editing based on the data entered in the auxiliary element,
And a step of configuring a summary element after editing and editing the combined summary element.
Moreover, the journal data creation method according to claim 10 of the present invention includes:
In the journal data creation device that creates journal data,
Editing a summary element obtained by dividing the summary of the journal based on data input to the journal data creation unit according to a predefined algorithm;
Forming a summary element and editing the combined summary element.
Moreover, the journal data creation program according to claim 11 of the present invention includes:
A first journal storage unit comprising a journal number, a classification element, an auxiliary element, a summary element, and a combined summary element;
A first summary template storage unit comprising a summary number, a summary element, an auxiliary element, and a division element;
In the journal data creating apparatus, comprising a first sub summary template storage unit comprising a sub summary number and a journal element,
Means for editing the summary element of the first summary template storage unit based on data input to the auxiliary element of the first summary template storage unit;
Means for editing the summary element of the first summary template storage unit based on the data input to the data obtaining unit, means for setting the segment element,
Means for extracting actual data from candidate data in the first summary template storage unit and transferring it to the first journal storage unit;
A summary element of actual data transferred to the first journal storage unit is configured, and the computer functions as means for editing the combined summary element.
Moreover, the journal data creation program according to claim 12 of the present invention includes:
The transaction data receiving unit receives the transaction data, and causes the computer to function as means for transferring the transaction data to the journal element of the first summary template storage unit designated by the summary number.
Moreover, the journal data creation program according to claim 13 of the present invention includes:
Means for extracting identification data and amount data from the journal elements in the first journal storage unit, summing up the amounts of the same identification data, assigning a description number, and transferring to the journal processing unit;
The computer is caused to function as a means for transferring the total data transferred to the journal processing unit to the sorting element of the first summary template storage unit designated by the summary number.
Moreover, the journal data creation program according to claim 14 of the present invention includes:
A second journal storage unit comprising a journal number, a classification element, an auxiliary element, an edited summary element, and a combined summary element;
A second summary template storage unit comprising a description number, a description element, and a segment element;
In the journal data creation device, comprising a second sub summary template storage unit comprising a sub summary number and a summary element,
The pre-edit summary element specified by the description number and the classification element, which are input to the auxiliary element of the second journal storage unit, are acquired, the pre-edit summary element specified by the secondary description number is acquired, and the pre-edit summary element that is acquired And a means for editing the post-edit summary element based on the data entered in the auxiliary element,
A summary element after editing is configured, and the computer functions as means for editing the combined summary element.
Moreover, the journal data creation program according to claim 15 of the present invention includes:
In the journal data creation device that creates journal data,
A means for editing a summary element obtained by dividing a journal summary based on data input to a journal data creation unit according to a predefined algorithm;
The summary element is configured, and the computer is caused to function as means for editing the combined summary element.
A computer-readable storage medium storing the journal data creation program according to claim 16 of the present invention is provided.
A first journal storage unit comprising a journal number, a classification element, an auxiliary element, a summary element, and a combined summary element;
A first summary template storage unit comprising a summary number, a summary element, an auxiliary element, and a division element;
In the journal data creating apparatus, comprising a first sub summary template storage unit comprising a sub summary number and a journal element,
Means for editing the summary element of the first summary template storage unit based on data input to the auxiliary element of the first summary template storage unit;
Means for editing the summary element of the first summary template storage unit based on the data input to the data obtaining unit, means for setting the segment element,
Means for extracting actual data from candidate data in the first summary template storage unit and transferring it to the first journal storage unit;
A summary element of actual data transferred to the first journal storage unit is configured, and the computer functions as means for editing the combined summary element.
A computer-readable storage medium storing the journal data creation program according to claim 17 of the present invention is provided.
The transaction data receiving unit receives the transaction data, and causes the computer to function as means for transferring the transaction data to the journal element of the first summary template storage unit designated by the summary number.
A computer-readable storage medium storing a journal data creation program according to claim 18 of the present invention is provided.
Means for extracting identification data and amount data from the journal elements in the first journal storage unit, summing up the amounts of the same identification data, assigning a description number, and transferring to the journal processing unit;
The computer is caused to function as a means for transferring the total data transferred to the journal processing unit to the sorting element of the first summary template storage unit designated by the summary number.
A computer-readable storage medium storing the journal data creation program according to claim 19 of the present invention is provided.
A second journal storage unit comprising a journal number, a classification element, an auxiliary element, an edited summary element, and a combined summary element;
A second summary template storage unit comprising a description number, a description element, and a segment element;
In the journal data creation device, comprising a second sub summary template storage unit comprising a sub summary number and a summary element,
The pre-edit summary element specified by the description number and the classification element, which are input to the auxiliary element of the second journal storage unit, are acquired, the pre-edit summary element specified by the secondary description number is acquired, and the pre-edit summary element that is acquired And a means for editing the post-edit summary element based on the data entered in the auxiliary element,
A summary element after editing is configured, and the computer functions as means for editing the combined summary element.
A computer-readable storage medium storing the journal data creation program according to claim 20 of the present invention is provided.
In the journal data creation device that creates journal data,
A means for editing a summary element obtained by dividing a journal summary based on data input to a journal data creation unit according to a predefined algorithm;
The summary element is configured, and the computer is caused to function as means for editing the combined summary element.

FIG. 1 is an external view showing a computer system that operates as a journal data creation apparatus according to the present invention.
FIG. 2 is a hardware configuration diagram of the computer system having the appearance shown in FIG.
FIG. 3 is a diagram showing a display screen displayed on the liquid crystal display by the spreadsheet software.
FIG. 4 is a diagram showing functional blocks of the spreadsheet software.
FIG. 5 is a structural diagram of a menu for selecting a transaction or operation assistance.
FIG. 6 is a diagram illustrating an example of a column range in which “journal creation” is performed in the first journal storage unit used for a typical transaction.
FIG. 7 is a diagram illustrating an example of a column range of “summary template” in the first summary template storage unit used for a typical transaction.
FIG. 8 is a diagram illustrating an example of a column range of “sub-summary template” in the first sub-summary template storage unit used for a typical transaction.
FIG. 9 is a diagram illustrating an example of a column range in which “journal creation” is performed in the second journal storage unit used for an atypical transaction.
FIG. 10 is a diagram illustrating an example of a column range of “summary template” in the second summary template storage unit used for an atypical transaction.
FIG. 11 is a diagram illustrating an example of a column range of “sub-summary model” in the second sub-summary model storage unit used for the atypical transaction.
FIG. 12 is a functional block diagram showing a functional configuration for a typical transaction.
FIG. 13 is a functional block diagram showing a functional configuration for an atypical transaction.
FIG. 14 is a diagram showing an example of a process of account transfer that occurs in principle every month.
FIG. 15 is a diagram illustrating an example of “environment setting” for the current month.
FIG. 16 is a diagram illustrating automatic update of the dependent variable element of “summary element 1”.
FIG. 17 is a diagram for explaining a transfer date input operation.
FIG. 18 is a diagram illustrating elements transferred from the “summary template” in the first summary template storage unit 72_1 to the column range for journal creation in the first journal storage unit 71_1.
FIG. 19 is a diagram for explaining automatic configuration editing of summary elements.
FIG. 20 is a diagram showing a slip created by diverting journal data.
FIG. 21 is a diagram showing a processing example of accruing expenses that occur every month in principle.
FIG. 22 is a diagram illustrating the contents of the “environment setting” for the current month acquired by the data acquisition unit 74 in the “accrued expenses” transaction.
FIG. 23 is a diagram illustrating an auxiliary element input operation.
FIG. 24 is a diagram illustrating an example of a “sub summary model” stored in the first sub summary model storage unit 73 prepared for the process of “accrued expenses”.
FIG. 25 is a diagram illustrating journal data in the first journal storage unit 71_1 created in the transaction of “accrued expenses”.
FIG. 26 is a diagram illustrating an element counting process.
FIG. 27 is a diagram illustrating elements transferred to the “summary template” column range of the first summary template storage unit 72_1.
FIG. 28 is a diagram illustrating elements of credit data transferred to a column range for creating journals in the first journal storage unit 71_1.
FIG. 29 is a diagram illustrating an example of diversion of credit data and credit data to accounting processing.
FIG. 30 is a diagram illustrating a processing example of salary payment.
FIG. 31 is a diagram showing the transaction data received by the transaction data receiving unit 76 in the salary payment process.
FIG. 32 is a diagram illustrating a definition of an example correspondence between a transfer source and a transfer destination.
FIG. 33 is a diagram showing journal data created by the salary processing.
FIG. 34 is a diagram showing an example of diversion of journal data created by salary processing to accounting processing.
FIG. 35 is a diagram showing transaction data obtained in an application for creating a comprehensive transfer request form.
FIG. 36 is a diagram showing a payment list.
FIG. 37 is a diagram showing a general transfer request form.
FIG. 38 is a diagram showing the transaction data received by the transaction data receiving unit 76 in the periodic payment process.
FIG. 39 is a diagram illustrating a “summary template” in the first summary template storage unit 72_1 prepared for the processing of “periodic payment 1”.
FIG. 40 is a diagram illustrating an example of “summary template” in the second summary template storage unit 82.
FIG. 41 is a diagram illustrating an example of a “sub-summary model” in the second sub-summary model storage unit 83.
FIG. 42 is a diagram illustrating an example of a column range for creating journals in the second journal storage unit 81_1.
FIG. 43 is a diagram for explaining addition and editing of a character string.
FIG. 44 is a diagram showing an example of diverting journal data created in the non-standard transaction processing to accounting processing.

Hereinafter, embodiments of the present invention will be described.
FIG. 1 is an external view showing a computer system that operates as a journal data creation apparatus according to the present invention.
The computer system 10 is a so-called notebook personal computer, and includes a main body 11 incorporating a CPU, a RAM memory, a hard disk, a modem, and the like. A liquid crystal display 12 that displays a screen on the liquid crystal surface 12 a according to an instruction from the main body 11 is attached to the upper surface of the main body 11 so as to be freely opened and closed. On the upper surface of the main body 11, a keyboard 13 for inputting operator instructions and character information to the computer system 10 and an arbitrary position on the liquid crystal surface 12a are designated and displayed at that position. A trackball 14 for inputting an instruction corresponding to an icon or the like is provided. The main body 11 further has a CDROM loading slot 11a into which the CDROM 20 is loaded in appearance, and a CDROM drive 11_5 (see FIG. 2) for driving the loaded CDROM 20 is also incorporated therein. .
The computer system 10 also includes an FD drive 15 that is loaded with a flexible disk (FD) 22 and drives the flexible disk 22.
FIG. 2 is a hardware configuration diagram of the computer system having the appearance shown in FIG.
Shown here is a central processing unit (CPU) 11_1, RAM 11_2, hard disk controller 11_3, FD drive 15, CDROM drive 11_5, trackball controller 11_6, keyboard controller 11_7, display controller 11_8, and printer controller 11_9. They are connected to each other by a bus 11_10.
As described with reference to FIG. 1, the FD drive 15 and the CDROM drive 11_5 are loaded with the flexible disk 22 and the CDROM 20, and access the loaded flexible disk 22 and the CDROM 20.
The printer controller 11_9 causes the printer 30 to perform printing in accordance with an instruction from the CPU 11_1.
Also included here are a hard disk 21 accessed by the hard disk controller 11_3, a trackball 14 controlled by the trackball controller 11_6, a keyboard 13 controlled by the keyboard controller 11_7, and a liquid crystal display 12 controlled by the display controller 11_8. It is shown.
Here, an example of the journal data creation program according to the present invention is stored in the CDROM 20, and this CDROM 20 is loaded into the main body 11 from the CDROM loading slot 11a, and the journal data stored in the CDROM 20 by the CDROM drive 11_5. The creation program is loaded. The journal data creation program read by the CD ROM drive 11_5 is installed in the hard disk 21 by the hard disk controller 11_3 via the bus 11_10. When the journal data creation program installed in the hard disk 21 is activated, the journal data creation program is loaded onto the RAM 11_2 and executed by the CPU 11_1. When the journal data creation program is executed by the CPU 11_1, the computer system 10 operates as an embodiment of the journal data creation device of the present invention to create journal data.
The CDROM 20 storing an example of the journal data creation program according to the present invention corresponds to an embodiment of the journal data creation program storage medium of the present invention.
The hard disk 21 in which the journal data creation program is installed also corresponds to an embodiment of the journal data creation program storage medium of the present invention.
Further, when the journal data creation program is downloaded to the flexible disk 22 or the like, the flexible disk 22 or the like that stores the downloaded journal data creation program is also one of the journal data creation program storage media of the present invention. This corresponds to the embodiment.
An example of the journal data creation program according to the present invention, which will be described later, uses a function of so-called spreadsheet software described below.
FIG. 3 is a diagram showing a display screen displayed on the liquid crystal display by the spreadsheet software, and FIG. 4 is a diagram showing functional blocks of the spreadsheet software. Hereinafter, FIG. 3 and FIG. 4 will be described together.
The spreadsheet software displays a table 40 having a large number of cells 41 aligned vertically and horizontally on the liquid crystal display 12 of the computer system described above. On the liquid crystal display 12, some of the many cells of the table 40 are displayed, and the display portion can be moved by scroll bars 42 and 43 provided in the table 40.
The arrangement of the cells 41 in the horizontal direction in FIG. 3 is generally referred to as “row”, and the arrangement of the cells 41 in the vertical direction in FIG. 3 is generally referred to as “column”. This designation is also used in the following description. Also, here, sequential numbers of rows and columns are given to each row and column, and one cell is specified by a combination of the row number and the column number. A set of the row number and the column number specifying the cell in this way is hereinafter referred to as “cell address”.
In the spreadsheet software 50, a storage area 51 corresponding to each cell 41 is prepared, and an expression 52 and a value 53 are stored in the storage area 51. The formula 52 and the value 53 stored in the storage area 51 provided corresponding to each cell 41 are hereinafter simply referred to as “cell formula” and “cell value”. A numerical value and a character string are stored as the cell value 53, and an arithmetic expression that is allowed to be a simple numerical value and a character string operation expression that is allowed to be a simple character string are stored as the cell expression 52. Is done. In the formula 52, values of other cells may be referred to. Further, the spreadsheet software 50 is provided with a logical function, a search function, and the like, and the formula 52 may be configured by using these functions. The value 53 of each cell is calculated by the calculation unit 54 according to the equation 52 for each cell.
The value 53 of each cell is displayed in each cell 41 of Table 40 by the display unit 55. An expression display field 44 is provided above the table 40, and when one cell 41 is selected by operating a mouse or a cursor key, the expression of the cell 41 is displayed.
Expressions can be input on the selected cell 41 or the expression display field 44, and the input expression is accepted by the input unit 56 and stored in the storage area 51. When a new expression 52 is input and stored in the storage area 51, the calculation unit 54 updates the value 53. At this time, not only the value of the cell in which the new formula 52 is input, but also the values of other cells that refer to the value of the cell are updated.
The spreadsheet software 50 also includes a macro unit 57 that executes search, extraction, calculation, editing of a cell value 53, input of a cell formula 52, and the like in accordance with a description (macro) representing a processing procedure created in advance. Is provided.
The journal data creation device of this embodiment configured using such spreadsheet software functions implements macros that realize essential functions as journal data creation devices and basic functions that are convenient for creating journal data. A macro is provided. A set of these macros corresponds to an example of the journal data creation program referred to in the present invention, and in this embodiment, is stored in the CDROM together with the main body portion of the spreadsheet software.
In the journal data creation apparatus of the present embodiment, journals are created on a table of spreadsheet software, and numerical values and character strings used for creating journals and descriptions are listed in the table as cell values. The cell values used for creating journal entries and summaries are hereinafter referred to as elements.
Next, the menu of this embodiment will be described.
FIG. 5 is a structural diagram of a menu for selecting a transaction or operation assistance.
At the top of the menu structure is the main menu 61 of the journal data creation device. Here, transactions such as “standard transaction 1”, “standard transaction 2”, “atypical transaction”, “financial transaction”, etc. A rough classification of is selected.
When the rough classification of the transaction is selected in the main menu 61, the process then moves to the transaction selection menu, and the detailed classification of the transaction is selected. In response to the selection of “standard transaction 1”, “standard transaction 2”, “non-standard transaction”, etc. in the main menu 61, the transaction selection menu 62 of “standard transaction 1”, “standard” The transaction selection menu 63 for “transaction 2”, the transaction selection menu 64 for “atypical transaction”, and the like, and subcategory such as “account transfer 1” and “salary” are selected.
Furthermore, there are operation assistance menus 65,..., 69 for activating macros for assisting the processing operation of each transaction. These operation assistance menus 65,.
Next, the column configurations and functions of the six storage units that are classified into typical transactions and atypical transactions and are used for creating journals will be described.
FIG. 6 is a diagram illustrating an example of a column range in which “journal creation” is performed in the first journal storage unit used for a typical transaction. FIG. 7 is a diagram illustrating an example of a column range of “summary template” in the first summary template storage unit used for a typical transaction. FIG. 8 is a diagram illustrating an example of a column range of “sub-summary template” in the first sub-summary template storage unit used for a typical transaction.
In these figures, column numbers are shown in the form of Cnn (nn is an integer), and in FIG. 6, column ranges from “C11” to “C42” are shown. Further, FIG. 7 shows column ranges from “C51” to “C82”, and FIG. 8 shows column ranges from “C91” to “C96”.
Journals are created in the range of the columns shown in FIG. 6, and one journal is composed of two rows of elements. For this reason, different types of elements in the even and odd rows correspond to specific columns of the columns shown in FIG.
“C11” is the journal number,
“C12” is the slip date, “C13” is the debit item, “C14” is the debit department, “C15” is the credit item, “C16” is the credit department, “C37” “C38” stores an occurrence indicator indicating whether a transaction has occurred, “C39” stores debit tax classification, and “C40” stores credit tax classification. The columns after “C43” are omitted, but from “C38” to “C42”, in addition to the occurrence indicator, taxation classification, funding classification, date of borrowings and bills, interest payment Elements used when journal entries such as period and interest rate are used in other business can be freely set for each transaction, and these elements are referred to as “other elements”. The category items “C12” to “C16” and “C37”, which are usually essential for creating journals, and the “other elements” are collectively referred to as “classification elements”.
“C17” to “C33” store elements that play an auxiliary role in creating journals, but “C17” to “C28” are mostly used in typical transactions. Although not shown in the figure, there is a case in which a partner number or the like is stored depending on the type of transaction. Here, the elements necessary for configuring and editing the combined summary element, “C29” and “C30” numbers are the number of bytes before adjustment, “C31” number is the front and rear adjustment value, “C32” and “C33” No. stores the number of adjusted bytes. These elements are referred to as “auxiliary elements”.
In the “C34” and “C35” numbers, the divided descriptions are stored. These elements are referred to as “summary elements”.
In the upper and lower stages of “C36”, elements obtained by configuring and editing the upper and lower summary elements of “C34” and “C35”, respectively, are stored. These elements are referred to as “joining summary elements”.
The “classification element”, the “auxiliary element”, the “summary element”, and the “joining summary element” are collectively referred to as “journal element”.
In this column range of typical transactions, the “classification element” and “summary element” are transferred and stored from the first summary template storage unit described later, and the transferred “summary element” is automatically configured. Edited to store “Combined Summary Element”.
The difference from the conventional technology is that “Journal element” contains “Auxiliary element” that stores the elements necessary for editing the composition of the summary, and “Other element” for using the journal for other tasks. In addition, for the summary, the divided summary is stored in the “summary element”, the summary after the configuration editing is stored in the “combined summary element”, and the like.
In the column range shown in FIG. 7, a template for creating a journal is prepared as “candidate data” in a list format prior to the creation of the journal. Elements for one line constitute one template, and such a template is referred to as a “summary template”.
“C51” is a summary number,
From “C52” to “C55”, the divided abstract templates are arranged as cell formulas, and the values of those cells are transferred to “C34” and “C35” shown in FIG. . These elements are referred to as “summary elements”.
From “C56” to “C65”, there are pre-registration of dependent variable elements used in fixed elements and hierarchically, and acceptance of independent variable elements, which are necessary for editing summary elements and setting classification elements. Done. These elements that are used in an auxiliary manner for updating the dependent variable elements are referred to as “auxiliary elements”.
“C66” to “C71” store the category items normally required for creating journal entries, and “C72” to “C82” store “other elements” described in FIG. These elements are referred to as “division elements”.
The “summary element”, “auxiliary element”, and “classification element” are collectively referred to as “journal element”.
The difference from the conventional technology is that, in the conventional “journal pattern” corresponding to this “summary template”, the “journal element”, in principle, the summary element corresponding to “what” and the “C67” number In the journal data creation device of the present invention, since the journal data is substantially created in the first summary template storage unit in the regular transaction, the category data up to “C70” is provided. Multiple "summary elements", "auxiliary elements", and slip dates / amounts to realize functions that differ from conventional technologies, such as the automatic editing function for summary elements and the automatic setting function for classification elements And “other elements” whose main purpose is to use journal entries in other businesses.
In the range of the column shown in FIG. 8, as the above-described “summary template”, a template of elements that cause inconvenience if fixed to other elements is prepared in a list format. Such a template is referred to as a “sub-summary template”.
“C91” is the minor summary number,
From “C92” to “C96”, for example, editing of “summary element” or “classification element” described in the explanation of FIG. An arbitrary “journal element” necessary for the setting of “” is stored. A fixed element is usually prepared here, but depending on the type of transaction, a dependent variable element can be prepared and used widely.
The conventional technique is not provided with a device that corresponds to the “sub-summary model”.
FIG. 9 is a diagram illustrating an example of a column range in which “journal creation” is performed in the second journal storage unit used for an atypical transaction. FIG. 10 is a diagram illustrating an example of a column range of “summary template” in the second summary template storage unit used for an atypical transaction. FIG. 11 is a diagram illustrating an example of a column range of “sub-summary model” in the second sub-summary model storage unit used for the atypical transaction.
As in FIG. 6, a journal is created in the column range shown in FIG. 9, and one journal is composed of two rows of elements.
Since the elements from “C11” to “C16”, “C29” to “C33”, and “C36” to “C42” are the same as those in FIG. Omitted.
From “C17” to “C21”, the transaction occurrence date and the number of receipts described in the summary are described, and “C22” and “C23” are character strings obtained by editing these elements, The “C24” number has a description number that specifies “Summary Model”, the “C25” number has a secondary description number that specifies “Sub-Summary Model”, and the “C26” and “C27” numbers have been acquired. The pre-edit summary element, “C28” number includes additional characters for supplementation, and “C29” to “C33” number include elements necessary for configuring and editing the combined summary element as in FIG. Stored. These elements are referred to as “auxiliary elements”.
In the upper and lower stages of “C34”, elements obtained by editing the upper and lower character strings of “C26”, “C23”, and “C28”, respectively, are stored. In the upper and lower stages of “C35”, the upper and lower elements of “C27” are stored, respectively. These elements are called “post-edit summary elements”.
Further, the “classification element”, “auxiliary element”, “post-edit summary element”, and “joint summary element” are collectively referred to as “journal element”.
The difference from the conventional technology is that there are two types of data, such as two journal specification data, transaction occurrence date and number of transactions, additional characters, and other elements that make up a summary of the contents, and the composition of the summary. “Auxiliary elements” for storing necessary elements, etc., and “Other elements” for using journals in other tasks are newly provided. For example, the description after editing the configuration is stored in the “combined summary element” in the “edited summary element”.
In the “summary template” for the atypical transaction shown in FIG.
“C51” is a summary number,
The “C52” and “C53” numbers are different from the “summary template” for the typical transaction shown in FIG. 7, and “what” and “for what” of the four summary components. The first and third “summary elements” corresponding to the above are stored.
“C54” to “C57” store debit and credit classification items, and “C58” to “C68” store “other elements” as in FIG. Is referred to as a “division element”.
The “summary element” and the “classification element” are collectively referred to as “journal element”.
The difference from the conventional technique is that, in the conventional “journal pattern” corresponding to this “summary template”, as a “journal element”, in principle, the summary element corresponding to “what” and “C54” The category items up to “C57” are provided, but a new summary element that can store the “for what” element and a category for each transaction such as a taxation category are stored. “Other elements” are provided for use in other tasks.
In the “secondary template” for the atypical transaction shown in FIG.
“C91” is the minor summary number,
The “C92” and “C93” numbers include second and fourth corresponding to “from (from)” among the four summary components of the “summary template” for the typical transaction shown in FIG. The “summary element” is stored.
The difference from the conventional technology is that, in an atypical transaction in which all of the combinations of “what” and “from (from)” elements occur irregularly, the “from (to)” element is registered “ A new “sub-summary model” has been prepared, and an environment has been prepared that enables the selection and input of a plurality of designated data to cope with irregular combinations.
The column configuration and functions of the six storage units have been described above. In this specification, the “name” as described above is used for the elements related to the journal.
Next, the functional configuration of the journal data creation apparatus according to this embodiment will be described.
FIG. 12 is a functional block diagram showing a functional configuration for a regular transaction.
First journal storage unit 71_1 described in FIG. 6, first summary template storage unit 72_1 described in FIG. 7, first sub summary template storage unit 73 described in FIG. 8, and acquisition of environment setting data for the current month And a data acquisition unit 74 for receiving input of data such as a transfer date.
Further, based on data input to the data acquisition unit 74 and data input to the “summary template” auxiliary element of the first summary template storage unit 72_1, the first sub summary template storage unit 73 is used for necessary transactions. Is used to edit the summary element of “summary template” in the first summary template storage unit 72_1 and set the division element, and further, the actual data generated this month from the candidate data of the first summary template storage unit 72_1 Are extracted and transferred to the first journal storage unit 71_1, and the first journal processing unit 71 has a function of automatically configuring the transferred actual data summary elements and editing the combined summary elements. The identification data and the amount data are extracted from the journal data obtained in the first journal storage unit 71_1, the amounts of the same identification data are aggregated and stored with a description number, and the summary data is designated by the description number. First A journal processing unit 75 having a function of transferring to the summary template storage unit 72_1 and diverting it to creation of a new journal entry, and a function of receiving transaction data and transferring the received transaction data to the first summary template storage unit 72_1. A transaction data receiving unit 76 is provided.
In the application business unit 77, transaction data is received from the journal processing unit 75, and various application business processes such as creation of an auxiliary book, salary calculation, and expense payment are performed. The application data obtained by the application processing is input to the transaction data receiving unit 76 as transaction data.
In the accounting data creation unit 78, the journal data stored in the first journal storage unit 71_1 is diverted to form slip output data, financial accounting data, settlement and tax return data, and consolidated accounting data. Various accounting data such as, etc. are created. The master storage unit 79 stores master data used by the accounting data creation unit 78 and the like.
Conventionally, for example, the cash register has been provided with two functions, a special journal and an auxiliary book (subsidiary ledger). However, with the spread of computers, such application differentiation has further progressed and various forms have been made. The functions of the journal and ledger have been moved to the auxiliary book (application business section 77) and the like. In this specification, the application data section 70 and the application business section 77 are collectively referred to as a journal data creation section 70.
FIG. 13 is a functional block diagram showing a functional configuration for an irregular transaction.
The second journal storage unit 81_1 explained in FIG. 9, the second summary template storage unit 82 explained in FIG. 10, and the second sub summary template storage unit 83 explained in FIG. 11 are provided.
In addition, the summary element and the classification element of the second summary template storage unit 82 specified by the designation data input in the “Summary number” of the auxiliary element of the second journal storage unit 81_1 are acquired and input to the “sub summary number”. The summary element of the second sub summary template storage unit 83 designated by the designated data is acquired, and based on the acquired pre-edit summary element and other data input to the auxiliary element of the second journal storage unit 81_1 A second journal processing unit 81 having a function of editing post-edit summary elements, further automatically configuring these post-edit summary elements and editing the combined summary elements is provided.
The accounting data creation unit 84, the master storage unit 85, and the journal data creation unit 70 are the same as described above, and a description thereof is omitted.
Next, a detailed procedure for creating journal data executed by the journal data creating apparatus according to the present embodiment will be described with reference to specific transaction types.
However, the journal data creation apparatus of the present invention has a variety of embodiments including application work due to differences in industries, scales, etc., and it is difficult to explain all of them, so it is common to these. Examples of processing for explaining the main functions are illustrated, and many of the detailed functions of various transactions are omitted. Differences in these embodiments, detailed functions omitted, etc. For, supplementary explanation will be given as necessary.
The processing examples 1 to 5 will be described with reference to the functional block diagrams of FIGS. 12 and 13. However, for the sake of brevity, the description of words and phrases referring to the drawings may be omitted below.
(Processing example 1)
FIG. 14 is a diagram showing an example of a process of account transfer that occurs in principle every month.
FIG. 14 shows an example of the “summary template” shown in FIG. 7 in the first summary template storage unit 72_1. The summary numbers shown in the leftmost column 90 of the summary model are originally serial numbers, but here, for convenience of explanation, representative rows are extracted and shown. For this reason, the summary number is a skipped value. Further, the columns are appropriately omitted for the column configuration, and broken lines are shown in the omitted portions. In the following description, it is assumed that such row excerpts and column omissions are performed without particular notice.
The example shown in FIG. 14 is a processing example when “standard transaction 1” in the main menu 61 and “account transfer 1” in the transaction selection menu 62 are selected in the menu shown in FIG. In “Account Transfer 1”, a journalizing process is executed regarding a transaction in which usage fees to be paid in the month such as telephone charges and electricity charges are deducted from an account on a designated transfer date in principle.
In each transaction belonging to “standard transaction 1”, the “summary template” in the first summary template storage unit 72_1 and the transaction data input operation are performed in the data acquisition unit 74, and the journal data is automatically converted based on the transaction data. Created. The “summary template” prepared for each transaction belonging to the “standard transaction 1” is mainly composed of fixed elements, and partially includes an independent variable element and a dependent variable element.
In the “summary template” illustrated in FIG. 14, the numerical values shown in the “Amount” column 91 are independent variation elements input by the user's input operation, and are shown in the “Summary Element 1” column 92. The character string displayed, the numerical value shown in the “slip date” column 93, and the numerical value shown in the “occurrence indicator” column 94 are dependent variable elements that are automatically updated as will be described later. The remaining elements listed in the columns of “Description Element 2” to “Description Element 4”, “Debit Item” to “Credit Department”, “Debit Tax Classification”, and “Credit Tax Classification” are registered in advance. Fixed element.
When the “account transfer 1” transaction is selected via the menu shown in FIG.
FIG. 15 is a diagram illustrating an example of “environment setting” for the current month.
The upper row of FIG. 15 shows the column number of the cell address, and the lower row shows the cell value. As described above, in the spreadsheet software, addresses, formulas, and values are associated with each cell in a multiple manner. For convenience of illustration, the addresses, formulas, and the like may be divided into a plurality of stages.
In FIG. 15, cells existing in the column range after “C111” in “environment setting” are shown, and cells equivalent to these cells are provided in the data acquisition unit 74 of each transaction. Each cell shown in FIG. 15 is defined with a name such as “current year” or “current month”. When the name is used as a function name, the value of each cell is cited as a function value.
Among the cells shown in this figure, the numerical values shown in the “current year” cell 101 and the “current month” cell 102 are independent variables, and prior to the selection of the menu screen shown in FIG. The macro activated by the selection of “environment setting” automatically selects each cell 101, 102 of “current year” and “current month” sequentially and waits for an input operation by the user. FIG. 15 shows a state in which “12” and “9” are input to the cells 101 and 102 of “current year” and “current month”, respectively.
The values of each cell from the “C113” “end of current month” cell to the “C123” “next month” cell are dependent variable elements, and the values of the “current year” and “current month” cells 101 and 102 Is automatically calculated from
A cell 103 of “the current month end date” stores a numerical value derived by a known technique from the value of the cell 102 of “current month”.
Each cell in the cell range 104 from “C114” to “C116” stores a numerical value obtained from the value of the cell 102 of “current month”. Each cell in the cell range 105 from “C117” to “C119” includes “the year in which the next month belongs” obtained from the values of the cells 101 and 102 of “current year” and “current month”. The numerical value to represent is stored. Further, each cell in the cell range 106 from “C120” to “C123” includes a character string representing a numerical value such as a cell 102 of “current month” and a cell of “previous month”, and a character string “month”. A character string combined with is automatically created and stored. These character strings are prepared as materials for editing the summary character string.
By such “environment setting”, a function value of a function represented by a name such as “for the current month” is set. When the contents of “environment setting” are acquired by the data acquisition unit 74 of each transaction, the dependent variable elements defined by quoting these functions are automatically updated. For example, the dependent variation elements stored in the column 92 of “Summary Element 1” shown in FIG. 14 are automatically updated as described below.
FIG. 16 is a diagram illustrating automatic update of the dependent variable element of “summary element 1”.
FIG. 16 illustrates one representative cell among the cells constituting the column 92 of “Summary Element 1” shown in FIG. The upper row of FIG. 16 shows cell addresses (column numbers only), the middle row shows cell formulas, and the lower row shows cell values.
The cell formula shown in FIG. 16 is composed of a function named “previous month” and a fixed character string “electric charge”. Then, the function value set by the above “environment setting” is quoted, and the character string “August electricity charge” is automatically edited. The character strings “July” and “September” shown in FIG. 14 are edited by quoting the values of the function “last month” and the function “current month”. In this way, by defining functions of dependent variable elements with functions, etc., a large number of dependent variable elements are updated at once in response to a small number of input operations, greatly reducing the time and labor required to create journal entries. It will be.
When the data acquisition unit 74 acquires the contents of “environment setting” in the transaction of “account transfer 1”, the operation assistance menu 65 of “account transfer 1” shown in FIG. Is selected. In response to the selection of “input”, the journal data creation apparatus of the present embodiment activates a predetermined macro that assists the transfer date input operation and the amount input operation described below.
FIG. 17 is a diagram for explaining a transfer date input operation.
FIG. 17 shows a cell range for the transfer date input operation prepared in advance in the data acquisition unit 74. Each of the 20 cells included in this cell range includes “transfer date 1”. ”To“ transfer date 20 ”(namely, function names) are defined. FIG. 17 illustrates three cells 111, 112, and 113 extracted from the 20 cells described above. In addition, on the right side of each cell 111, 112, 113, a name that is easy for the user to represent is shown that represents the account transfer on each transfer date. These names are described together when the “summary template” shown in FIG. 14 is prepared.
When the macro is activated, each cell from “Transfer Date 1” cell 111 to “Transfer Date 20” cell 113 is automatically automatically selected as an input destination, and a numerical value is input to each cell by the user. A transfer date input operation is performed. FIG. 17 shows a state where values “9”, “10”, and “30” are input to three cells 111, 112, and 113, respectively, as an example.
When a numerical value is input to the cell 113 of “transfer date 20”, the values of the cells quoting the function values of the function “transfer date 1” to the function “transfer date 20” are automatically updated. For example, in each cell of the “slip date” column 93 shown in FIG. 14, functions selected from the functions “transfer date 1” to “transfer date 20” are stored as expressions. The function value is quoted and the value of each cell is automatically updated.
When the transfer date input operation and the automatic update of the cell value are completed, the macro selects the top row of the “Amount” column 91 shown in FIG. 14 as the input destination and starts the amount input operation. In the amount input operation, each cell in this “Amount” column 91 is automatically selected as an input destination in order from the top, and a numerical value is input by a user input operation. In addition, for example, for a transaction that is a fixed monthly amount such as a lease fee, the numerical value is stored as a default, and the default numerical value can be determined as it is.
Each cell in the “occurrence indicator” column 94 indicates “0” if the value of the cell in the “money amount” column 91 adjacent to the cell is “0”, and may be a value other than “0”. For example, a function indicating “1” is stored, and each time a numerical value is input to each cell in the “Amount” column 91 or a default numerical value is determined, the “occurrence indicator” column adjacent to that cell is stored. The value of 94 cells is automatically updated. When the numerical value is input up to the bottom of the “Amount” column 91, the amount input operation is completed.
When the input of the independent variable element by the operation procedure described above is completed, the operation assistance menu 65 of “account transfer 1” shown in FIG. 5 is displayed and “data processing” is selected by a predetermined operation by the user. In the transaction, starting from the selection of “data processing”, journal data is automatically created in a lump without manual intervention as described below.
In the first stage of the automatic creation of journal data, from the “candidate data” of the “summary template” after the input of the independent variable elements and the update of the dependent variable elements, the “actual data” of the “summary template” where the transaction occurred ”Is extracted, and the elements constituting the“ summary template ”are transferred to the journal creation column range shown in FIG. 6 in the first journal storage unit 71_1.
FIG. 18 is a diagram illustrating elements transferred from the “summary template” in the first summary template storage unit 72_1 to the column range for journal creation in the first journal storage unit 71_1.
The upper row of FIG. 18 shows cell addresses and column numbers, and the lower row shows cell values. Further, as described above, the journal is composed of one set of two rows of odd and even rows, and FIG. 18 shows “R83” and “R” as an example of the odd and even rows constituting one journal. The row of R84 "is illustrated.
The elements stored in the respective cells shown in FIG. 18 are elements transferred from the “summary template” except for the cells in the column 120 of “journal number”.
Among the cells shown in FIG. 18, the elements stored in the cells in the column range 121 from “C12” to “C16” are “slip date” to “credit department” shown in FIG. This is an element transferred from a cell included in the column range 95. Also, the elements stored in each cell in the cell range 122 of the addresses “R84C34”, “R84C35”, “R83C34”, and “R83C35” shown in FIG. 18 are “summary element 1” to “summary element 4” shown in FIG. ”Is an element transferred from a cell included in the column range 96. Furthermore, the elements stored in the cells in the column range 123 from “C37” to “C40” shown in FIG. 18 are included in the column range 97 of “Amount” to “Credit Taxation Category” shown in FIG. An element transferred from a cell. Such a correspondence relationship between the transfer source and the transfer destination is defined in a macro that performs element transfer.
The transfer procedure using this macro will be described below.
The elements are transferred sequentially from the “summary template” in the uppermost row (row) of the “summary template” shown in FIG. If the value of the element stored in the occurrence indicator column 94 among the elements constituting the “summary template” of the transfer target row is “1”, the transfer is executed, and the transfer source and transfer described above are performed. The elements are transferred according to the correspondence with the destination. When the transfer is executed, the “summary template” on the next line becomes the transfer target. If the value of the element stored in the occurrence indicator column 94 is “0”, the transfer is not performed, and the “summary template” in the next row is the transfer target.
The number of rows of “summary template” for which transfer has been executed is counted by the counter, and each time the “summary template” element for one row is transferred, the corresponding item in the column 120 of “journal number” shown in FIG. The same number as the count value is stored in the cell. As a result, serial numbers are stored in the “journal number” column 120.
When the above procedure is repeated and all the lines of the “summary template” are processed as transfer targets, the element transfer is completed.
In the second stage of automatic creation of journal data, four summary elements (summary element 1 to summary element 4) stored in the cell range 122 of the addresses “R84C34”, “R84C35”, “R83C34”, and “R83C35” It is automatically configured and the description string is edited.
FIG. 19 is a diagram for explaining automatic configuration editing of summary elements.
Also in FIG. 19, the cell address is shown in the upper part, and the cell value is shown in the lower part.
Among the cells shown in FIG. 19, the cell ranges 130 of the addresses “R84C34”, “R84C35”, “R83C34”, and “R83C35” are shown again with the same cell range as the cell range 122 shown in the center of FIG. It is. The character strings stored in each cell in this cell range are shown in FIG. 19 with some of the character strings omitted due to the space, but the character strings stored in these cells The data represents the same character string as the character string stored in each cell in the cell range 122 shown in the center of FIG.
As a procedure for configuring and editing the four summary elements, first, the number of bytes of character data representing each character string of the four summary elements (summary element 1 to summary element 4) is obtained, and the addresses “R84C29”, “ It is stored in the cell range 131 of “R84C30”, “R83C29”, and “R83C30”. The number of bytes of character data generally corresponds to the length of the character string. In the example shown in FIG. 19, “16”, “12”, “8”, and “14” are obtained as the number of bytes corresponding to each of the summary elements 1 to 4.
Next, the length of the character string of each summary element is compared with the reference length for constructing the summary character string, and the length of the character string is adjusted based on the comparison result. Here, for the description element 1 and the description element 3 corresponding to the first half of the description character string, the reference length is 14 bytes, so that the upper and lower lines of the description character string have a length of 29 bytes. For the description element 2 and the description element 4 corresponding to the latter half of the character string, the reference length is set to 15 bytes.
Based on such a reference length, an adjustment value described below is calculated and stored in the cell range 132 of the addresses “R84C31” and “R83C31”.
If the number of bytes in the first half of the character string before adjustment is a and the number of bytes in the second half of the character string is b, the adjustment value X is
(1) If a ≧ 29, X = 15,
(2) If 28 ≧ a ≧ 14, X = a + 1−14,
(3) If a ≦ 13 and b ≦ 15, X = 0,
(4) If a ≦ 13 and b ≧ 16 and b ≧ 29−a, X = a + 1−14,
(5) If a ≦ 13 and b ≧ 16 and b ≦ 28−a, X = 15−b,
Thus, it is calculated by a formula divided into cases. This case division is a case where the first character string is prioritized.
When the number of bytes illustrated in FIG. 19 is applied to the expressions classified in this way, since the lower row is a = 16 and b = 12, it corresponds to the case of (2) and X = 3 is calculated. . Further, since a = 8 and b = 14 in the upper stage, X = 0 is calculated corresponding to the case of (3).
Thus, when the adjustment value X is obtained, the number of bytes Y of the first half of the character string after adjustment and the number of bytes Z of the second half of the character string after adjustment are respectively
Y = 14 (reference number of bytes in the first half of the character string) + X
Z = 29-Y
It is calculated by the formula. When the number of bytes illustrated in FIG. 19 is applied, Y = 17 and Z = 12 in the lower stage, and Y = 14 and Z = 15 in the upper stage. These values are stored in the cell range 133 of the addresses “R84C32”, “R84C33”, “R83C32”, and “R83C33”.
When the number of bytes after these adjustments is obtained, 14 bytes of single-byte spaces are added to the end of the first half of the character string, and 15 bytes of single-byte spaces are added to the end of the second half of the character string. The character strings are cut out, and the cut out character strings are combined. As a result, the combined summary element (ie, the summary character string) of 29 bytes in total is edited and stored in the cell range 134 of the addresses “R84C36” and “R83C36”.
As a result of such automatic configuration editing, a summary of detailed transaction contents represented by an appropriate character string is obtained.
Journal data is automatically created in a batch without human intervention by the above-described element transfer and automatic composition editing of the summary.
FIG. 20 is a diagram showing a slip created by diverting journal data.
The slip shown in FIG. 20 is created based on the journal data and the master. The master used here is a master that represents a correspondence table in which numeric values representing “debit items” and “credit departments” included in journal data are associated with subject names and department names.
The date shown in the “slip date” column 140 is based on the year and month set in the “environment setting” of the current month shown in FIG. 15 and the “slip date” element included in the journal data. It has been edited.
The debit item column 141, the debit department column 142, the credit item column 143, and the credit department column 144 have "debit item", "debit department", "credit item", and "credit department" included in the journal data. The subject name corresponding to the numerical value of “” is retrieved from the master and described.
In the summary column 145 and the amount column 146, the elements of “combined summary element” and “amount” included in the journal data are described as they are.
A journal having a single “amount” for each debit and credit is called a single journal.
In the processing example 1 described above, an automatic editing function of summary elements and an automatic setting function of classification elements based on data input to the data acquisition unit, an automatic extraction and transfer function of generated transactions, an automatic configuration editing function of combined summary elements, etc. A new function that is different from the conventional technology has been described.
In the “account transfer” transaction shown in Process Example 1, if you enter the minimum required independent variable data such as “Transfer Date” and the amount of each transaction, the current month acquired by the data acquisition unit 74 The summary element is automatically edited based on the “environment setting” data, and the “slip date” of the classification element is automatically set based on the “transfer date” data input by the data acquisition unit 74, and the first summary template Of the “candidate data” in the storage unit 72_1, “actual data” generated in the current month is extracted, transferred to the first journal storage unit 71_1, the summary elements are automatically configured, the combined summary elements are edited, and the journal data is edited. It is automatically created all at once without human intervention.
Next, a supplementary explanation will be given regarding processing example 1.
First, regarding the pre-registration of the “candidate data” of the “summary template”, in the transaction such as account transfer shown in the processing example 1, for example, when “the last day of the transfer date” falls on a holiday of a financial institution The transfer date is deferred to the next month, but “candidate data” twice a month for such a case can also be registered in advance.
In addition, for example, in the case of a transaction in which “international telephone charges” with different taxation categories are included in one “phone charge” and two journals must be created at the same time, the number of telephone calls If there are not enough numbers, domestic telephone charges for all telephone numbers and international telephone charges "summary templates" are registered in advance, and if there are a large number of telephones, "phone numbers", "departments", and "tax categories" are supported. Place a “sub-summary template” and register in advance the international telephone charges for the phone numbers that are expected to be generated. Select the “sub-applicable templates” for the international telephone charges for the phone numbers that occurred exceptionally. A summary template "can also be prepared.
In addition, in transactions such as the monthly repayment of principal and interest of a loan, where a transfer date is specified by a financial institution and an automatic transfer from the counterparty's deposit account is requested, the transfer cannot be made due to a shortage of deposit balance, Monthly fluctuations occur in “○ month” for each partner, and the management becomes complicated. In such a transaction, “1” (January) to “12” (December) in the column direction, and “−12” (for 12 months ago) to “0” (for the current month) in each row in the row direction. “Subscript template” corresponding to the above is placed, “0” to “−12” are registered in the auxiliary elements of “Summary template”, and the transfer of the other party to which “0” (for the current month) is registered If there is a transfer of the other party registered with “September loan repayment” and “-2” (two months ago), the summary element will be automatically edited, such as “July loan repayment” For counterparties that cannot be transferred in the current month, a new value is added by subtracting 1 from the value registered in the supplementary element of the “Summary Template”. It is managed separately from “Environment settings”. As shown in the case described above for each transaction, the journal data creating apparatus of the present invention incorporates various functions throughout the details of the transaction.
This is the end of the description of the processing example 1. Hereinafter, the processing example 2 will be described.
(Processing example 2)
FIG. 21 is a diagram showing a processing example of accruing expenses that occur every month in principle.
The example shown in FIG. 21 is a processing example when “standard transaction 1” in the main menu 61 and “unpaid expense” in the transaction selection menu 62 are selected in the menu shown in FIG. In the “accrued expenses” recording, in principle, journal processing for transactions in which monthly accrued expenses for a specific trading partner are recorded at the end of the month is executed.
FIG. 21 shows the “summary template” of the first summary template storage unit 72_1 prepared for the process of accruing unpaid expenses.
In the “summary template” illustrated in FIG. 21, among the cells arranged in the “monetary amount” example 151, the cell 151_1 in which the address is shown has the numerical value of the independent variation element input by the user's input operation. A fixed element has already been stored in the cell 151_2 in which the numerical value is stored. This default numerical value represents that a fixed amount transaction is performed every month. The character string stored in the column 152 of “summary element 1” and the numerical value stored in the column 153 of “slip date” are dependent variable elements that are automatically updated, and among the cells of “summary element 1”, In the cell 152_1 of the “summary template” of the summary numbers “91” and “120”, the cell formula is shown. Of the cells arranged in the “occurrence indicator” column 154, the dependent variable element is stored in the cell 154_1 in which the address is shown, and the cell value is automatically updated in the cell 154_2 in which the numerical value is shown. In the “description template” of the description number “120”, the formula is shown in the cell 155 of the “description element 4” and the cell 156 of the “debit department”, and dependent change elements are stored in these cells. Of the cells shown in FIG. 21, fixed elements are registered in advance in the remaining cells.
When the “accrued expenses” transaction is selected via the menu shown in FIG. 5, “environment setting” for the current month is automatically performed as in the case of the processing example 1 described above.
FIG. 22 is a diagram illustrating the contents of the “environment setting” for the current month acquired by the data acquisition unit 74 in the “accrued expenses” transaction.
The contents of the “environment setting” for the current month obtained in the “accrued expenses” transaction are the same as those in FIG. 15, but here, for convenience of explanation, two cells 158 and 159 are extracted and shown. Yes. The “current month” cell 158 stores a numerical value “9” representing September as an example, and the “current month end” cell 159 stores a numerical value “30” representing the last day of September. Yes.
In each cell arranged in the “slip date” column 153 shown in FIG. 21, the function “end of month” is registered as a formula. When the data acquisition unit 74 obtains the contents of the “environment setting”, The value of each cell is a numerical value “30” representing the last day of September. The character string “September” of the character strings stored in the column “summary element 1” is automatically updated in the same manner as described in the processing example 1.
When the environment setting for this month and the automatic update of the dependent variable elements are completed, an operation assistance menu 66 of “accrued expenses” shown in FIG. 5 is displayed and “input” is selected by a predetermined operation by the user. In response to the selection of “input”, the journal data creation apparatus of the present embodiment activates a predetermined macro that assists the same amount input operation as described above and an auxiliary element input operation described below.
In the amount input operation, the cell 151_1 in which the address is shown among the cells arranged in the column 151 of “Amount” is sequentially automatically selected as the input destination, the transaction amount is input, and whether the transaction amount is “0” or not. In response, the value of “occurrence indicator” is updated. When the input operation for the cell 151_1 in which the address is shown is completed, the auxiliary element input operation is started.
FIG. 23 is a diagram illustrating an auxiliary element input operation.
In FIG. 23, the “summary template” shown in FIG. 21 is shown again. The columns shown in FIG. 23 include the columns omitted in FIG. 21 and the columns shown in FIG. 21, and the same elements are also shown in the columns shown in FIG. The name is given.
Further, in FIG. 23, cell addresses and column numbers are shown in the upper row, and cell values are shown in the lower row.
In the processing of “accrued expenses”, processing related to transactions such as consumables is also performed. In such transactions, the transaction target represented by “What” in the summary is often unspecified, and cannot be registered as a fixed element in the “summary template”. For this reason, for a transaction whose transaction object is unspecified, data indicating “what” of the summary is input by the auxiliary element input operation.
When this auxiliary element input operation is started, cells that require element input are automatically and sequentially selected by the macro. As a method for realizing such automatic selection, a method of registering an address of a cell that needs to be entered when registering a “summary template” or a content of each cell of the registered “summary template” is used. A method of deriving a cell that needs to be input can be adopted, but the user can arbitrarily move the cursor to input.
The cell 161 of the address “R93C56” and the cell 162 of the address “R122C56” are cells for inputting the character string “auxiliary element 1”. Here, the character strings “towel paper” and “battery exchange” are inputted. ing. When such a character string is input as “auxiliary element 1”, dependent variable elements stored in cells 163 and 164 of “summary element 1” are automatically updated as described below.
The formulas of these cells 163 and 164 are composed of the updated character string “September” of the dependent variation element and the function “auxiliary element 1” as shown in the cell 152_1 in FIG. Since the character string of “auxiliary element 1” in the “description template” of the description number “91” is “towel paper”, the character string of “summary element 1” is “9” as shown in the cell 163 of FIG. Monthly Towel Paper "is automatically edited. In addition, since the character string of “auxiliary element 1” in the “description template” of the description number “120” is “battery replacement”, the character string of “summary element 1” is as shown in a cell 164 of FIG. "September battery replacement" is automatically edited.
For the “summary template” of the summary number “120”, not only the character string “auxiliary element 1” but also the numerical value 165 of “auxiliary element 2” is required to be input. The numerical value of the “auxiliary element 2” is a numerical value that designates the “sub summary template”.
FIG. 24 is a diagram illustrating an example of a “sub summary model” stored in the first sub summary model storage unit 73 prepared for the process of “accrued expenses”.
In FIG. 24, “sub-summary template” for two lines of “sub-summary template” constituting a correspondence table defining the correspondence between the character string 171 of “vehicle number” and the numerical value 172 representing “debit department”. Is shown excerpted. The sub-summary number of the “sub-summary template” selected by the user from among the plurality of “sub-summary templates” is input as the numerical value of the “auxiliary element 2”. The numerical value input in this way is specification data, and the “sub-summary model” is specified by the numerical value itself, and the “summary template” is also specified by the address of the cell in which the numerical value is input.
As shown in FIG. 21, the formulas of the cells 155 and 156 are defined as search functions, and the search function is determined from the correspondence table as shown in FIG. Is a function for searching for a character string of “vehicle number” and a numerical value indicating “debit department”, and the character string of “vehicle number” is the value of the cell 166 of “summary element 4” shown in FIG. The numerical value indicating “debit department” is stored as the value of the cell 167 of “debit department”.
In FIG. 23, the secondary summary number “10” is input as the numerical value of the cell 165 of “auxiliary element 2”, and the character string “▽▽ 57” 7097 searched based on this secondary summary number “10”. And the numerical value “5” are stored in the cell 166 of “summary element 4” and the cell 167 of “debit department”, respectively.
In this way, by having a mechanism that is retrieved from the correspondence table prepared as “sub-summary template” and quoted, it is possible to collectively manage the assigned department of the vehicle as “sub-summary template”, Even when the department is changed, it is possible to correct only the “sub summary template” and cope with it.
When the auxiliary element input operation described above is completed and the necessary summary elements are prepared, “data processing 1” in the operation assistance menu 66 of “unpaid expense” shown in FIG. 5 is selected by the user's operation. By this selection, the elements are transferred from the “summary template” of the first summary template storage unit 72_1 to the journal creation column range of the first journal storage unit 71_1 in the same manner as the processing example 1 described above. Configured, combined description elements are edited, and debit journal data is created.
FIG. 25 is a diagram illustrating journal data in the first journal storage unit 71_1 created in the transaction of “accrued expenses”.
In FIG. 25, journal data 180 created by selecting “data processing 1” described above and “data processing 2” described later is shown. Like this “accrued expense” transaction, A journal in which one or both of a debit and a credit is represented by two or more “amounts” is referred to as a composite journal.
The journal data 180 includes “debit data” 181 and “credit data” 182 that are part of the set of journal data.
In the “summary template” shown in FIG. 21, a fixed element 157 called “destination number” is prepared, and this “destination number” element is transferred when journal data is created, and debit data shown in FIG. 181. The journal data creating apparatus of the present embodiment is provided with a processing function for creating credit data 182 from the debit data 181 with reference to the element of the “party number”, and this processing function is shown in FIG. This is activated when “data processing 2” in the operation assistance menu 66 of “accrued expenses” is selected. Hereinafter, this processing function will be described.
When this processing function is activated, the journal processing unit 75 adds up the elements of the credit data 181_2 based on the element 181_1 of the “party number”.
FIG. 26 is a diagram illustrating an element counting process.
Also in FIG. 26, cell addresses are shown in the upper stage, and cell values are shown in the lower stage. The debit data 191 shown in FIG. 26 is data created in the same column range as the debit data 181 shown in FIG. 25. In FIG. 26, only even rows are extracted and shown. ing.
The column range shown on the right side of FIG. 26 is the column range after “C151”, and is the column range set in the journal processing unit 75 for creating aggregate data that is the basis of credit data. In the description of FIG. 26, for the sake of convenience, the aggregate data that is the basis of the credit data is also referred to as “credit data”.
In the totalization process by the journalizing processing unit 75, the numerical values 191_2 of “money application” in the debit data 191 having the common “party number” element 191_1 shown in FIG. The value of the element 191_1 is transferred as the element 192 of the “destination number” of the credit data, and the number of the debit data 191 that is common to the element 191_1 is counted. It is stored as an element 193 of “total number of cases”. Furthermore, the total value of the numerical values 191 </ b> _ <b> 2 of “Amount” is stored as the “Amount accumulated” element 194 of the credit data. For example, there are two debit data 191 in which the element 191_1 of the “party number” is “1”, and the numerical values 191_2 of each “money amount” are “257,775” and “48,510”. Therefore, in the credit data in which the element 192 of “party number” is “1”, the element 193 of “cumulative number” is “2”, and the element 194 of “cumulative amount” is “306,285”.
Such aggregation for each “party number” is sequentially repeated.
In “Summary template” of “Accrued expenses”, “Summary template” corresponding to transactions classified from the creditor's viewpoint is also prepared, and the description number given to this “Summary template” is “ It is obtained by adding 300 to the numerical value of the element 192 of the “party number”. The numerical value 195 of “credit summary number” in the credit data is the summary number obtained in this way.
Further, when the data in which the elements of the debit data 191 are aggregated is transferred to the column range of the credit data, “1” is stored as the element 196 of the “occurrence indicator” in the row including the cell that has received the data transfer. .
As described above, among the elements of the credit data created by the aggregation processing by the journal processing unit 75, the “total amount” element 194 is the “summary template” of the first summary template storage unit 72_1 as new transaction data. Transferred to column range.
FIG. 27 is a diagram illustrating elements transferred to the “summary template” column range of the first summary template storage unit 72_1.
In FIG. 27, the upper row shows the column number of the cell address, and the lower row shows the cell value.
The “cumulative sum” element 194 shown in FIG. 26 is transferred to the “summary template” having the same description number as the value 195 of the “credit description number”.
FIG. 27 exemplifies a “summary template” having a summary number “301”. Of the numerical value 195 of the “credit summary number” shown in FIG. 26, the element 194 of “total amount” corresponding to the numerical value “301” is “306,285”, and this numerical value “306,285” corresponds to the numerical value “306,285”. Are transferred as the “amount” element 201 of the “summary template” shown in FIG. For the “summary template” that has received the transfer of the “money amount” element 201, the value “1” is stored as the “occurrence indicator” element 202.
Of the elements of “summary template” shown in FIG. 27, the character string 203 of “summary element 1” and the numerical value 204 of “slip date” are dependent variable elements, and are automatically updated in the same manner as described above.
As described above, the transaction amount is transferred to the “summary template”, and the dependent variable elements are updated, so that the elements of the “summary template” as the basis of the credit data (journal data) are prepared. These elements are transferred to the journal creation column range of the first journal storage section 71_1 to create journal data.
FIG. 28 is a diagram illustrating elements of credit data transferred to a column range for creating journals in the first journal storage unit 71_1.
The upper part of FIG. 28 shows cell addresses and column numbers, and the lower part shows cell values.
Since the element transfer method is the same as described above, the description thereof is omitted. The credit data (journal data) is assigned a journal number after “101”, and is distinguished from the above-described debit data. When the elements are transferred, the summary elements are automatically configured as described above, the combined summary elements (shown at 222_3 in FIG. 29) are edited, and the credit data 210 is created.
The credit data 210 shown in FIG. 28 is exactly the same as the credit data 182 shown in the lower part of FIG. 25, and as described above, the credit data from the debit data is automatically collected in a lump without manual intervention. To be created.
FIG. 29 is a diagram illustrating an example of diversion of credit data and credit data to accounting processing.
Here, as a simple example of the accounting process, a process of creating a slip-format journal (composite journal) is adopted.
When the journal slip 221 based on the debit data and the journal slip 222 based on the credit data are compared, the character strings 221_1 and 222_1 for the “debit item”, the character strings 221_2 and 222_2 for the “debit department”, and the character string 221_3 for the “description”. 222_3 and numerical values 221_4 and 222_4 of “money amount” are greatly different from each other. Thus, data that are greatly different from each other are automatically created in a lump without requiring manual summation work and journal entry work.
In the processing example 2 described above, in addition to the functions described in the processing example 1, the automatic editing function of the summary element based on the data input to the auxiliary element, the automatic setting function of the classification element, and the summation of the amount for each identification data A new function that is different from the conventional technology, such as a function, an automatic setting function of specified data, an automatic selection function of a journal pattern, and an automatic input function of independent variable elements has been described.
In transactions with “Accrued expenses” shown in Process Example 2, if you enter the debit data of the minimum independent variable elements such as the amount of each transaction and a summary of some transactions, the same as Process Example 1 The debit journal data is automatically created, and the amount for each partner number is aggregated from the debit journal data, and the credit description number is added and transferred to the journal processing section 75. “Model” is automatically selected, and the total amount is automatically entered in the corresponding “Category element”, and the credit journal data is automatically collected in a batch without any human intervention in the same manner as described in Process Example 1. Is created.
Next, a supplementary explanation will be given regarding processing examples 1 and 2.
Regarding the automatic editing function of the summary element and the automatic setting function of the classification element, for example, in the payment transaction of the short-term borrowing interest, the interest payment periods “12”, “9”, “26”, “12”, “12”, “Calculation formula of interest” with “25”, interest rate “2.3”, principal amount “100,000,000”, “search function and calculation formula” of interest payment days as auxiliary elements of “summary template” ”As a categorical element in advance as a fixed element or a dependent variable element, the total number of days from the base date for the start date and end date of the interest payment period will be calculated using the correspondence table with the“ sub-summary template ”. The interest payment days “91” are calculated, the principal “100,000,000” * the interest rate “2.3” / “100” / “365” * the interest payment days “91” are calculated and paid The interest “573, 424” is automatically set. In addition, the numerical value is converted into a character string, and “12.26.12-12.12.25 91 days 2.3%” (top), “Short-term borrowing interest rate ○○ Detailed descriptions such as “Silver ◎◎ Branch” (bottom) are edited by automatically configuring the description elements.
Also, in the automatic continuation time deposit interest receiving transaction, the interest payment periods “12”, “4”, “1”, “12”, “9”, “30”, and the interest rate “0.15” If the principal amount “1,000,000” is registered in the same manner as above, the interest payment period “183”, the interest income after tax “6,016”, the withholding income tax national tax “1” , 128 ”, withholding income tax, local tax“ 376 ”, interest income before tax“ 7,520 ”, and the journal of interest income after tax is“ date 12.9.30 ”(top),“ term deposit interest ” ○ Summary of “Silver □ △” (bottom), amount “6,016”, withholding income tax National tax entry is “Timed interest interest tax ○ Silver □ △” (bottom) and “1,128” ”, Withholding deduction income tax Local tax journals are summed up in the description and amount of“ Time Deposit Interest Local Tax ○ Silver □ △ ”(bottom) The journal of “376” and interest income before tax are as follows: “12.4.1-12.9.30 183 days 0.15%” (top), “Time deposit interest rate ○ Silver □ △” (bottom) The summary is automatically configured and edited as the amount “7,520”, and the amount of “classification element” is automatically set. By checking the contents in the interest statement or interest payment statement issued by the financial institution, reliable and highly accurate and detailed journal data is automatically created.
In addition, in the purchase transaction of “XX lottery” that requires payment by check, for example, sales unit prices “100”, “200”, “300”, “500” in the column direction, and purchase in the row direction. The unit price “93.7”, the purchase unit price is converted into a character string, and “@” and “*” character strings combined with the character string “@ 93.7 *” before and after that are added. “Summary template (1)” and the number of times “368”, “...”, “1413” in the column direction, the number of times in the row direction is converted to a character string, and the character string is combined before and after that. ◎ "Sub-summary model (2)" corresponding to "368 times", "...", "◇ Japan 1413 times", etc. are arranged, and the data acquisition unit 74 uses the purchase date "11", the number of times "1413", Entering data of independent variable factors such as unit price “100” and quantity “7000”, the unit price “100” is used as a key, The purchase unit price “93.7” and the description phrase “@ 93.7 *” are selected from the “sub-description template (1)” described above, and the purchase unit price “93.7” and the quantity “7000” are set to numerical values. Based on this, the amount “655,900” of the classification element is automatically calculated and set, the quantity “7000” is converted into a character string, “@ 93.7 * 7000” (upper row), and the number of times “1413” is keyed Then, the description phrase is selected from the above-mentioned “sub-explanation template (2)”, the description is automatically edited as “◇ Japan 1313 purchases △ silver ▽▽ branch” (lower), and the journal data is entered manually. It is automatically created instantly.
As described above, the automatic editing function for summary elements has a search function, a calculation function, a function for converting numerical values into character strings, and a format that combines pre-defined character strings with input data. The classification element automatic setting function includes a search function and a hierarchical calculation function. It is also possible to set these functions, and these functions can be widely used for the above-mentioned various kinds of small transactions, travel expenses settlement work, main branch account processing, and the like.
Even in the case of transactions such as the processing examples 1 and 2 described above, when the same type of transaction volume becomes large, the application work unit 77 performs input operations and the like, and the transaction data receiving unit 76 It is also possible to receive transaction data from the application section 77 and process it in the same manner as in Processing Example 3 described later.
This is the end of the description of the processing example 2. Hereinafter, the processing example 3 will be described.
(Processing example 3)
FIG. 30 is a diagram illustrating a processing example of salary payment.
The upper row of FIG. 30 shows the column number of the cell address, and the lower row shows the cell value.
The example shown in FIG. 30 is a processing example in the case where “standard transaction 2” in the main menu 61 and “salary” in the transaction selection menu 63 are selected in the menu shown in FIG. For each transaction belonging to “Standard transaction 2”, it is assumed that the application data has been created by the application department 77 prior to the creation of the journal, and the transaction data necessary for creating the journal is traded from the applied data. The data receiving unit 76 receives the journal data.
FIG. 30 exemplifies “summary template” of the first summary template storage unit 72_1 prepared for salary payment processing.
In the “summary template” illustrated here, the numerical value shown in the column 231 of “amount”, the character string shown in the column 232 of “auxiliary element 1”, and the column 233 of “auxiliary element 2” are shown. The obtained numerical value is an independent variable element fetched from the application business unit 77.
The numerical value shown in the column “234” of “slip date” is a dependent variation element that refers to the value of the function “supply date” to be described later. The character string shown in the column 235 of “summary element 2” is a dependent variable element, and the character string shown in the column 232 of “auxiliary element 1” and the numerical value shown in the column 233 of “auxiliary element 2” Based on the above, it is automatically updated as will be described later. The character string shown in the column 236 of “summary element 1” and the numerical value shown in the column 237 of “occurrence indicator” are dependent variable elements that are automatically updated in the same manner as in the processing example 1 described above.
The remaining elements shown in each column of “debit item” to “credit department”, “debit tax classification”, and “credit tax classification” shown in FIG. 30 are fixed elements registered in advance.
When the “salary” transaction is selected via the menu shown in FIG. 5, the “environment setting” for the current month is automatically performed as in the case of the processing example 1 described above.
Next, “data processing” in the “salary” operation assistance menu 67 shown in FIG. 5 is selected by the user's operation. By selecting this “data processing”, a predetermined macro is activated, transaction data is taken into the transaction data receiving unit 76, and journal data is automatically created based on the transaction data.
FIG. 31 is a diagram showing the transaction data received by the transaction data receiving unit 76 in the salary payment process.
Of the columns shown in FIG. 31, a “summary number” column 241 stores serial number summaries in advance. In FIG. 31, six lines are extracted and shown.
The transaction data captured here includes the elements “transaction element 1” to “transaction element 10” and a numerical value indicating the salary payment date. The column range from “C132” to “C141” In “242”, “transaction element 1” to “transaction element 10” are fetched and sequentially stored downward from the line of the summary number “1”. “Transaction element 1” is a numerical value representing an amount, and the amount may be “0”. “Transaction element 2” is a character string representing a name, and “transaction element 3” is a numerical value representing the number of people. Further, a cell 243 indicated by the number “C146” is loaded with a numerical value representing the payment date. The name “supply date” is defined in this cell 243, and the value of this cell is quoted as the value of the function “supply date”.
In the “occurrence indicator” column 244, the value “0” is stored if the amount of “transaction element 1” is “0”, and the value “1” if the amount of “transaction element 1” is other than “0”. Is stored. FIG. 31 shows an excerpt of a data portion whose amount is other than “0”.
When the transaction data is captured as described above, the element of the transaction data is then transferred to the “summary template” in the first summary template storage unit 72_1 designated by the summary number. The arrangement of the elements “transaction element 1” to “transaction element 10” included in the transaction data is different from the common column configuration of “summary template” in the journal data creation apparatus of this embodiment. For this reason, when the “summary template” is prepared, the correspondence between the transfer source and transfer destination columns is also defined, and the element transfer is executed in a macro according to the definition.
FIG. 32 is a diagram illustrating a column correspondence definition between a transfer source and a transfer destination.
The column number of the column shown in FIG. 31 is stored in the left column 245_1 of the correspondence table 245 shown in FIG. 32, and the column number of the column shown in FIG. 30 is stored in the right column 245_2 of the correspondence table 245. Has been.
By transferring the elements according to such a correspondence table, the element of “transaction element 1” is changed from the “amount” column of “C132” shown in FIG. 31 to “C71” shown in FIG. Transferred to column 231 of “Amount”. Similarly, the element “transaction element 2” is transferred from the column “name” of “C133” shown in FIG. 31 to the column 232 of “auxiliary element 1” of “C56” shown in FIG. The element of “transaction element 3” is transferred from the “number of persons” column of “C134” shown in FIG. 31 to the column 233 of “auxiliary element 2” of “C57” shown in FIG.
However, the element transfer is limited to the case where the value “1” is stored in the “occurrence indicator” column 244 shown in FIG.
As described above, when the element is transferred to the “summary template” of the first summary template storage unit 72_1, the dependent variation element shown in FIG. 30 is automatically updated.
The redundant description of the automatic update of the character string shown in the column 236 of “Summary Element 1” and the column 237 of “Generation Indicator” shown in FIG. 30 is omitted.
As described above, the numerical value shown in the column “234” of “slip date” is a dependent variable element that refers to the value of the function “supply date”, and the value “20” captured in the cell 243 shown in FIG. Is updated to the same value “20”.
The editing of the character string shown in the column 235 of “Summary Element 2” is defined according to the cell expression as follows.
(1) When the value of the auxiliary element 2 is “1”, the character string of “summary element 2” is the character string of “auxiliary element 1” and the character string obtained by converting the numerical value of “auxiliary element 2” , A character string edited with the character string "name",
(2) When the value of auxiliary element 2 is greater than “1”, the character string of “summary element 2” is the character string of “auxiliary element 1”, the character string “outside”, and “auxiliary element 2” Is a character string obtained by editing a character string obtained by converting a numerical value obtained by subtracting “1” from a value of “” and a character string “name”.
The character string shown in the column “235” of “summary element 2” is edited according to such a definition.
When the dependent variable elements are automatically updated in this way, the elements necessary for creating the journal data are prepared, so that the elements are column ranges for creating journals in the first journal storage unit 71_1, as in the processing example 1 described above. Journal data is created by transferring to.
FIG. 33 is a diagram showing journal data created by the salary processing.
Debit data 251 and credit data 252 as shown in FIG. 33 are created from the captured transaction data without human intervention as shown in FIG.
The journal data created in this way is also diverted to the accounting process in the same manner as the processing example 1 described above.
FIG. 34 is a diagram showing an example of diversion of journal data created by salary processing to accounting processing.
Here, as a simple example of the accounting process, a process for creating a voucher journal (composite journal) is adopted. In the upper part of FIG. 34, a journal voucher 261 created by diversion of debit data is shown. A journal slip 262 created by diverting credit data is shown in the lower part.
In the journal data creation apparatus of this embodiment, a description including a sufficiently detailed character string such as the description 261_1 of the journal slip 261 is automatically configured and edited from the transaction data described above.
In the processing example 3, as described above, application data is created by the application business unit 77 prior to journal entry creation. In the application of payroll calculation, if you enter the minimum necessary independent variable data such as `` payment date '' and overtime hours, in addition to functions with well-known technologies such as withholding tax and employment insurance premiums, A function to automatically calculate and extract dependent variable factors such as loan repayment amount and interest from the correspondence table using the “month” value as a key, and an automatic transfer request creation function as shown in Process Example 4 described later It has a salary schedule, a divisional social insurance premium share schedule, a salary transfer request form, and other transfer request forms such as deductions.
In the processing example 3 described above, in addition to the functions described in the processing example 1, new functions that are different from the conventional technology such as an automatic selection pattern of journal patterns and an automatic input function of independent variable elements have been described.
In the “salary payment” transaction shown in the processing example 3, the transaction data receiving unit 76 receives transaction data necessary for creating journals from the application data of the salary calculation created by the application business unit 77, and receives the description number. The “Summary Template” to be specified is automatically selected, and based on the column correspondence definition between the transfer source and transfer destination, these transaction data are automatically entered in the corresponding journal elements, and the same as described in Process Example 1 below. Thus, journal data for debits and credits is automatically created all at once without any human intervention.
Next, a supplementary explanation will be given regarding transactions processed in the same manner as in Processing Example 3.
First of all, regarding the transaction of sales recording, in the applicable business department 77, “XX sales”, “…”, “Credit not reached”, “Credit total”, “Accounts receivable”, “□□ deposit”, “Cash” The amount of each transaction / settlement category such as “Notes receivable”, “Debt not reached”, and “Debit total” is described according to the type of sales business, such as the amount by date or category, or the amount by partner. When the sales data schedule (subsidiary book) in the form of a list has been created and transaction data necessary for creating a journal is received from the application data by the transaction data receiving unit 76, the journal is processed in the same manner as described above. Data is automatically created at once without any human intervention.
With regard to this sales accounting transaction, there are various forms of schedules due to differences in the type of industry. For example, in the restaurant (retail / leisure) business, first, “date”, “restaurant sales” , Schedules with sales categories such as “take-out sales”, “store sales”, “vending machine sales”, “…” are created based on data aggregated at ticket vending machines, post offices, etc. Then, the schedules with sales categories such as “Resident Name”, “Rent Income”, “Common Income”, “Electricity Fee”, “Water Fee”, “…” are the figures for the current month of the electricity / water meter. In the construction industry, etc., schedules with sales categories such as `` construction name '', `` partner name '', `` construction number '', `` date '', `` sales amount '' Created based on manual data input.
In addition, purchase / accounting transactions are almost the same as the above-mentioned sales transaction. For example, the period of 1 to 10 days, 11 to 20 days, 21 days to the end of the month for each counterparty. A list of purchase details (subsidiary book) in which a list of sums and other information is listed has been created, and transaction data necessary for journal creation, such as partner number and amount by period, is included in the applicable data. Upon receipt, the journal data is automatically created in a lump without any human intervention in the same manner as described above. A description of cost calculation is omitted here.
In addition, with regard to the accounts receivable collection transaction, the applicable business department 77 performs “partner name”, “carry forward in the previous month”, “occurrence in the current month”, “payment date”, “payment amount”, “commission”, “…”, “ A list of accounts receivables (subsidiary) in a list format by sales industry, in which the amount by category such as “collected in the current month” and “carried over the next month” is written, is created from the application data on which this schedule is created When the transaction data receiving unit 76 receives transaction data such as a destination number, deposit date, deposit amount, and commission for each deposit account necessary for creating a journal, the journal data is collected all at once without any human intervention. Created automatically.
As for the settlement transaction, various schedules (auxiliary books) for settlement are created in the application business section 77, and the transaction data receiving section 76 receives transaction data necessary for creating journals from these application data. In the same way, journal data is automatically created in a batch without any human intervention.
Regarding the outline of transaction processing related to settlement, first, regarding “Depreciation expenses”, the application section 77 has prepared a detailed list of depreciation expenses from the acquisition of each asset to the end of depreciation. If you perform (correction) input work for acquisition or retirement for the current period, data for the current period is extracted using the current period as a key, and the depreciation expense schedule for the current period and various summary data are automatically created. Is done. From these application data, if you receive transaction data, such as the amount of depreciation expenses that are aggregated by account item / department, such as buildings, equipment attached to buildings, ... ○ Period Depreciation and amortization Building ○ ○ Journal entry data including summary is automatically created, and journal data is automatically created for “Loan allowance for loan losses”, “Accrued bonuses”, “Provision for retirement benefits”, etc. Created.
In addition, “Prepaid Expenses” are also handled by the applicable business department 77. For example, the account item “insurance premium”, insurance type “store comprehensive insurance premium”, insurance purpose “management building / hangar”, department “□ Department”, insurance Company “○ ◎ Fire and Marine”, insurance period “12” “5” “7” “-” “13” “5” “7”, insurance days “365”, insurance premium “432, 320”, prepaid period “13” ”“ 4 ”“ 1 ”“-”“ 13 ”“ 5 ”“ 7 ”, the number of advance payment days“ 37 ”, the advance payment amount“ 43,824}, etc. are prepared, Of the application data used as the basis for creating the table, the schedule is automatically created when the (independent) input of “independent variable factors” such as the insurance period and insurance premium is performed as necessary. When transaction data necessary for creating journals is received from these applicable data, “4.1-5.7 37th Management Building / Hangar” (upper row), “No. ) And journal data including the amount “43,824” are automatically created, and insurance companies that are not used to create the above-mentioned journal summary also have “other elements” in the “summary template”. It is possible to instantly create details of account items necessary as financial statements with detailed contents. In addition to the above-mentioned non-life insurance premiums, “prepaid expenses” such as automobile insurance premiums, life insurance premiums and interest expenses, “accrued expenses” such as interest income, “accrued expenses”, “accrued expenses” such as expenses and interest expenses, etc. In the same way, journal data is automatically created.
This is the end of the description of the processing example 3. Hereinafter, the processing example 4 will be described.
(Processing example 4)
This processing example 4 also presupposes that application data is created by the application business unit 77 prior to journal entry creation. This application business is an application business that creates a general transfer request form in order to request a financial institution to transfer each payment amount from its own account to each of a plurality of payee accounts on a designated “payment date”.
FIG. 35 is a diagram showing transaction data obtained in an application for creating a comprehensive transfer request form.
In this application, in the processing example 2 described above, from the “credit data” shown in FIG. 26 created by the journal processing unit 75 based on the credit data recorded as “accrued expenses”, an element of “party number” 192, the “total amount” element 194, and the “occurrence indicator” element 196 are diverted and taken in as transaction data. The fetched elements are stored as a numerical value 271 of “transaction element 1”, a numerical value 272 of “transaction element 2”, and a numerical value 273 of “occurrence indicator” shown in FIG. A numerical value 271 of “transaction element 1” is a numerical value representing the counterpart number, and a numerical value 272 of “transaction element 2” is a numerical value representing the amount of money.
As described above, when an element is taken in as transaction data from the journal processing unit 75, a numerical value 274 of “payment date” is input by a user operation.
The numerical value 272 of “money amount” and the numerical value 273 of “occurrence indicator” shown in FIG. 35 are transferred to a payment list in which transfer destinations and payment amounts are displayed in a list.
FIG. 36 is a diagram showing a payment list.
In this payment list 280, a numerical value 281 of “recipient number” is stored in advance as a serial number, and each recipient number has a transfer destination 282 composed of elements of “recipient” to “account number”. Are associated.
35 is transferred to such a payment list 280, with the value 272 of “money amount” and the value 273 of “occurrence indicator” shown in FIG. The transferred numerical values are stored as a “payment amount” value 283 and a “occurrence indicator” value 284 in the payment list 280.
In addition, the “fee” value 285 in the payment list 280 is calculated based on the “payment amount” value 283 and the bank name, branch name, bank name, branch name of the transfer source, A numerical value 286 of “transfer amount” is calculated based on a criterion for determining whether it is a burden or a partner burden. In this application, the data processing unit can also perform deduction amount processing such as offsetting the payment amount and depositing withholding tax, but the description of the content is omitted. Further, the amount of “total fee” to “total withdrawal” is totaled by the data processing unit, and the totaled data is transferred from the data processing unit and each numerical value 287 is stored.
From the payment list 280 created in this way, the elements in the row where the numerical value 284 of the “occurrence indicator” is “1” are extracted to create a comprehensive transfer request form.
FIG. 37 is a diagram showing a general transfer request form.
This general transfer request form 290 is printed by transferring the elements extracted from the payment list 280 shown in FIG. 36 to a predetermined arrangement. The description of details such as transfer is omitted.
Of the application data for request form creation created in the application business described above, data necessary for journal creation is taken in as transaction data in process example 4 described below, and journal data is created.
This processing example 4 is a processing example when “standard transaction 2” in the main menu 61 and “periodic payment 1” in the transaction selection menu 63 are selected in the menu shown in FIG. In “Periodic payment 1”, a journal process relating to a periodic payment transaction for unpaid expenses is executed. “Environment setting” for the current month is automatically performed when selecting a transaction.
FIG. 38 is a diagram showing the transaction data received by the transaction data receiving unit 76 in the periodic payment process.
When “data processing” in the operation assistance menu 68 of “periodic payment 1” shown in FIG. 5 is selected by the user's operation, application data is taken in as transaction data as shown in FIG. Journal data is automatically created in a batch without any human intervention.
As shown in FIG. 38, from the transaction data 270 of the application for creating the general transfer request form shown in FIG. 35, the “counter number” value 271, the “money amount” value 272, and the “occurrence indicator” value 273 is stored and stored as a destination number value 301_1 of "transaction element 1", an amount value 302_1 of the amount of "transaction element 2", and a value 303_1 of "occurrence indicator" and input to the cell 274 shown in FIG. The value of the “payment date” is also fetched and stored in the cell 304 in which the name “payment date” is defined.
Also, the numerical value 301_2 of the destination number of “transaction element 1” is fixed, and a numerical value 288 such as “fee meter” in the payment list shown in FIG. 36 and a numerical value 289 of “occurrence indicator” are fetched. It is stored as a numerical value 302_2 of the amount of “transaction element 2” and a numerical value 303_2 of “occurrence indicator”.
The elements of the application data thus taken in as transaction data are transferred to the “summary template” in the first summary template storage unit 72_1 prepared for the processing of “periodic payment 1”. This transfer is executed so that the numerical value 301 of “destination number” and the summary number match each other. Since the details of the transfer are the same as those in the processing example 3 described above, a duplicate description is omitted.
FIG. 39 is a diagram illustrating a “summary template” in the first summary template storage unit 72_1 prepared for the processing of “periodic payment 1”.
Among the elements stored in the “summary template” shown in FIG. 39, the numerical values stored in the “amount” column 311 are independent fluctuation elements to which the elements of the transaction data have been transferred. The numerical value stored in the column 312 of “slip date” is a dependent variation element updated by quoting the value of the function “payment date”. The character strings stored in the column 313 of “Summary Element 1” and the column 314 of “Summary Element 3” are dependent variation elements that are automatically updated by quoting a value such as the function “previous month”. The numerical values stored in the column “315” of the “occurrence indicator” are the dependent variable elements updated in the same manner as described above. The other character strings and numerical values stored in the columns of “Description element 2”, “Description element 4”, “Debit item” to “Credit department”, “Debit tax classification”, “Credit tax classification” It is a registered fixed element.
The procedure for creating the journal data from the “summary template” to which the elements of the transaction data are transferred in this way is also the same as in the processing example 1 described above, so the following description is omitted.
In the case of processing example 4 described above, in case of processing example 2, if the debit data of the minimum necessary independent variable elements such as the amount of each transaction and the summary phrase of some transactions are entered to account for accrued expenses. In the processing example 4, credit data with accrued expenses as shown in FIG. 26 is applied to the application business unit. 77, when the user inputs the data of the minimum necessary independent variable elements such as “payment date” and deduction amount, a comprehensive transfer request form as shown in FIG. The debit and credit journal data for "payment" is automatically created without any human intervention.
Further, the payment of accounts payable can be processed in exactly the same manner as in Processing Example 4. Further, in this embodiment, for the sake of brevity, the description of the processing for the main branch account is omitted, but the journal processing unit 75 has a function for summing up the amount by destination in the branch of the main branch account, In addition, there is a function for summarizing the total amount for each partner at the head office and a totaling function for the total amount for each branch. The larger the number of business partners and branches, the greater the effect that these functions can exert. It becomes.
As described above, in the processing examples 1 to 4, the embodiments of the present invention related to the routine transactions that occupy most of the transactions have been described. However, in these transactions, as described above, the conventional technology includes “high-speed input”. There are input methods with various improvements in the selection input of “Journal pattern”, etc. However, regardless of which input method is selected, “Journal pattern” or unfixed classification element for each transaction As for (selection) input and description, it is necessary to repeat repeated operations such as input (completion / correction) including the description words “from (to)” and “others” and composition editing work regularly every month. There are also many transactions that require the use of “normal input”.
On the other hand, as described above, the journal data creation device of the present invention has an automatic editing function for summary elements, an automatic setting function for classification elements, an automatic extraction and transfer function for generated transactions, an automatic configuration editing function for combined summary elements, New feature that is different from the conventional technology, such as automatic selection function of journal entry pattern, automatic input function of independent variable elements, totaling function of amount by identification data, automatic setting function of specified data, etc. In the “account transfer” transaction shown in the figure, the “transfer date” is entered in a lump sum and the amount of each transaction is entered, and in the transaction “accrued expenses” shown in the processing example 2, the amount of each transaction in the debit data In the “Salary Payment” transaction shown in Process Example 3, the “Salary Payment” transaction shown in Process Example 3, the “Payment Date” and overtime hours in the applicable business, and the “Periodic Payment” transaction shown in Process Example 4 So, in the application ”And deduction amounts, etc., and entering the data of the minimum necessary independent variable elements, including the input in the application, all repetitive operations that are repeated regularly such as monthly are automated, Journal data including a detailed and detailed summary of contents is automatically created in a batch without any human intervention.
As an embodiment of the journal data creation apparatus of the present invention having means for realizing the new function as described above, the final monthly, which requires about 3 weeks or more in the conventional technology in the settlement work, Processing and annual processing, creation of various accounting books, financial statements and supplementary schedules based on the Commercial Code, corporate tax declarations and consumption tax declarations based on tax laws, details of each account item, etc. are extremely accurate It ends within 3 hours (computer operation and processing time) after closing the final data on the closing date.
This is because, even in the conventional manual bookkeeping, due to the practical application of bookkeeping, sales books, purchase books, etc. had functions as special journals and auxiliary books. Such development has been further accelerated in various fields, and in addition to preparing salary details in application work, various auxiliary books (schedules) with clarity and accuracy for monthly and settlement work From the entry or acceptance of source data to the creation of an auxiliary book, the work process has been simplified. The financial statements prepared based on various accounting data are basically composed of dependent variable elements except fixed elements and some independent variable elements that can be input in advance (correction). In the prior art, since journal data for each transaction is created one by one manually, this journal creation work hinders the flow of a series of work processes in the settlement. By removing and automating the weirs, it is possible to automate the work process (except for menu selection operations) from the input of the source data to the creation of the financial statements.
This is the end of the description of the processing example 4. Hereinafter, the processing example 5 will be described.
(Processing example 5)
This processing example is a processing example related to a non-standard transaction, and when “non-standard transaction” in the main menu 61 and “cash business 2” in the transaction selection menu 64 are selected in the menu shown in FIG. This is an example of processing. “Environment setting” for the current month is automatically performed when selecting a transaction.
In each transaction belonging to the “non-standard transaction”, the “summary template” shown in FIG. 10 of the second summary template storage unit 82 and the “sub-summary template” shown in FIG. 11 of the second sub summary template storage unit 83. Is prepared, and the user's input operation is performed within the column range for creating journals shown in FIG. 9 in the second journal storage unit 81_1.
As described above, an atypical transaction is a transaction that takes place on an unspecified date with an unspecified trading partner for an unspecified transaction target, and it is not possible to automatically select a "journal pattern". It is a processing example that requires the most operation. In view of this, in the present embodiment, a contrivance is made to keep the input operation by the user to the minimum necessary.
FIG. 40 is a diagram illustrating an example of “summary template” in the second summary template storage unit 82.
The “summary template” prepared in the processing example 1 to processing example 4 related to the above-described typical transaction includes four summary elements, whereas the “summary template” shown in FIG. Only the element 321 of “element 1” and the element 322 of “summary element 3” are included. In these elements 321, 322, in principle, a character string corresponding to “what” representing the object of the transaction is stored. For example, when “what” is “Sake Sake”, “what” If the term for "for" is "New Year Holiday", it will be "Compensation Fee", "Sales Department Shrine Dedication" will be "Meeting Fee", "Payment" will be "Welfare Expense", etc. A summary word “for what” can be registered in the summary element 3. In this way, when “What” is “XX”, if “For what” is “□□ Committee”, “Meeting fee”, “△△ Workshop” Depending on the type of business, there are many such transactions, such as “Education and Research Expenses”, “▽▽ Visits”, “Interaction Expenses”, and “◇◇ For Exhibitions” “Advertising Expenses”. . These elements 321 and 322 are allowed to be simply blank, and the number of transactions to be registered is limited to a very small number with high occurrence frequency in order to facilitate selection of the “summary template”.
In addition, in the “summary template” shown in FIG. 40, “debit item” to “credit tax classification” are associated with the summary words represented by the element 321 of “summary element 1” and the element 322 of “summary element 3”. Although the element 323 is stored, the description of “other elements” other than the taxation category is omitted for the sake of brevity.
FIG. 41 is a diagram illustrating an example of a “sub-summary model” in the second sub-summary model storage unit 83.
41 is provided with an element 331 of “summary element 2” and an element 332 of “summary element 4”, and these elements 331 and 332 each represent “a transaction partner”. A character string corresponding to “from (to)” is stored.
In the “cash sales 2” transaction, one “summary template” and “secondary template” are selected by the user's operation from the “summary template” and “secondary template” prepared in this way. Then, a combination of a summary phrase such as “what”, “from where (to)”, and “for what” in the transaction and a fixed segment element is set. The user can arrange a basic journal pattern with a simple selection operation.
FIG. 42 is a diagram illustrating an example of a column range for creating journals in the second journal storage unit 81_1.
Also in FIG. 42, cell numbers and column numbers are shown in the upper stage, and cell values are shown in the lower stage.
When the operation assistance menu 69 of “cash business 2” shown in FIG. 5 is displayed and “input 1” is selected by the user's operation, a predetermined macro is activated and the “slip date” cell 342 is input. It is automatically selected as the destination and the date is input by the user.
Next, the “Summary Number” cell 343 is automatically selected as an input destination, and a summary number (here, “3”) specifying the “Summary Model” selected by the user is input. In response to this input, the elements of the “description template” specified by the description number are the cell range 344 of “debit item” to “credit department”, the cell 345 of “elements 1 and 3 before editing”, and the “debit tax classification”. ”And“ Credit Tax Classification ”cell range 346.
Next, a cell 347 of “sub-summary number” is automatically selected as an input destination, and a sub-summary number (“2” in this case) for designating the “sub-summary model” selected by the user is inputted. In response to this input, the element of “sub-summary template” designated by the sub-summary number is transferred to the cell 348 of “pre-editing summary elements 2, 4”.
Next, cells to which a simple blank element is transferred (here, cell 344_1 of “debit department” and cell 345_1 of “pre-editing summary element 3”) are automatically selected as input destinations, and are selected by the user as necessary. An element is entered.
Next, the “additional character” cell 349 is automatically selected as an input destination, and a character string to be added to the summary is input by the user as necessary.
Next, the “amount” cell 350 is automatically selected as the input destination, the transaction amount is input by the user, and the value of the “occurrence indicator” cell 351 is updated to “1” in response to the input of the amount. .
Next, the cell range 352 from “C17” to “C21” is automatically selected as the input destination, and the user processes the numerical value of the month and day described in the cash transaction receipt, etc., and the receipt, etc. The number of records is entered. Here, the input based on the receipts for two cases on September 2 and September 3 is performed. Note that the date can also be entered in the upper part of the cell range 352 of the “auxiliary element” in the same manner, and is used when a date such as a receipt extends over two months. When the month and day values and the number of records are entered, the character string described below is edited.
In editing the character string, the numerical values stored in the four cells from “R5C17” to “R5C20” are converted into character strings and edited in a predetermined format, and the character string is the cell 353 of “R5C22” number. Stored in Similarly, numerical values stored in four cells from “R6C17” to “R6C20” are converted into character strings, edited in a predetermined format, and the character strings are stored in cell “354” of “R6C22”. . Here, the character string “9 / 2.3” is edited based on the numeric value “9” of the month and the numeric values “2” and “3” of the date. Further, a character string obtained by further editing the character string stored in these cells 353 and 354 is stored in a cell 355 of “R5C23”. For example, if a character string “8/31” and a character string “9 / 2.3” are stored in these cells 353 and 354, a character string “8 / 31.9 / 2.3 "is edited. Further, a character string composed of the numerical value of the “number of cases” cell 352_1 and the character string “case” is stored in the cell 356 of the “R6C23” number. Here, a character string “2 cases” composed of a numerical value “2” converted into a character string and a character string “case” is stored.
Next, the character strings stored in the cells 355 and 356 for the “number of combined dates” and the cell 349 for the “additional characters” are changed to the character strings in the cells 345 of the “pre-editing summary elements 1 and 3”. Added and edited. However, the upper and lower rows are edited.
FIG. 43 is a diagram for explaining addition and editing of a character string.
In FIG. 43, the column range omitted in FIG. 42 is shown.
In the upper cell 361 of the “first half of the post-edit summary element” shown in FIG. 43, the character string “9 / 2.3 ◎◎ Mr. Pickup” is stored. This character string is a character string obtained by additionally editing the character string “9 / 2.3” and the character string “◎◎ Mr. In addition, a character string “two tolls” is stored in a lower cell 362 of “first half of post-edit summary element” shown in FIG. This character string is a character string obtained by additionally editing the character string “two charges” and a blank character string to the character string “toll”.
In addition, here, in the cell 363 of “post-edit summary element second half”, the character string “◇◇ Minami Kyushu” and the character string stored in the cell 348 of “pre-edit summary element 2, 4” shown in FIG. “Highway public corporation” is transferred and stored as it is.
Further, the number of bytes of the character string and the adjustment value are calculated for these character strings in the same manner as in the processing example 1 described above, the post-edit summary element is automatically configured, and the “joint summary element” character string 364 is edited. The
In addition, although the embodiment as described above is illustrated for the sake of brevity of explanation, as another example, auxiliary elements for inputting additional characters and edit markers for the pre-edit summary elements 1 to 4 are provided. For example, if the additional character “○ △ ◎” and the value of the edit indicator are input to the pre-edit summary element 2 “parking lot”, the character of the pre-edit summary element 2 if the edit indicator is “1” The column is overwritten and the post-edit summary element is edited as “○ △ ◎”. If the edit indicator is “2”, “○ △ ◎ Parking”, and if the edit indicator is “3”, “Parking ○○ There is also an embodiment in which additional characters are combined before and after the pre-editing summary element 2 like “◎” to edit the post-editing summary element. With this function, in addition to “Parking”, “Park”, “Oil store”, “City hall”, “Ward office”, “Post office”, “Store”, etc. It can be created easily. In addition, as will be described later, for the pre-editing summary element 1, for example, addition or overwriting of a character string such as “.garbage bag” or “other” can be easily performed on the pre-editing summary element 1 “detergent”. Can do.
In addition, in transactions such as the above-mentioned cash transactions, as the original record of the transaction, in addition to the elements of “what” and “from (to)”, the summary is essentially “what for” ”, The date when the transaction occurred, and the number of receipts pasted on the mount (number of processed items)“ how much ”should be included. When the minimum necessary simple input work is performed with reference to the above, the description character string is automatically composed and edited, and a summary is created that shows the detailed contents in a well-formed format. Therefore, the user can easily create an appropriate journal including detailed transaction contents without being aware of the summary format.
The above process is a process when the operation assistance menu 69 of “Cash Sales 2” shown in FIG. 5 is displayed and “Input 1” is selected by the user's operation. When “input 2” in the assistance menu 69 is selected, the “slip date”, “amount”, “description number”, “sub-description number”, and “department” elements for a plurality of journals A macro is executed to prompt the user for specific input. By such continuous input, elements essential for creating journals are input extremely quickly and accurately. Input of elements such as “additional characters” is optionally performed after the input of essential elements. Also, the user can arbitrarily move the cursor and input.
FIG. 44 is a diagram showing an example of diverting journal data created in the non-standard transaction processing to accounting processing.
Here, as a simple example of the accounting process, a process of creating a voucher journal (single journal) is adopted.
As described with reference to FIG. 43, the journal slip 370 including the detailed description and the character string 371 of “Summary” expressed in a well-formed format is easily created.
In the processing example 5 described above, conventional functions such as a function for simultaneously selecting and inputting a plurality of designated data of “summary template” and “sub-summary template”, an automatic editing function for post-editing summary elements, and an automatic configuration editing function for combined summary elements New features that differ from technology were described.
In atypical transactions such as cash transactions described above, journal entries can be created by combining "book entry", "fixed description" selection input, "journal pattern" selection input, and "normal input". However, for example, the product names listed on the receipt are “tissue”, “tissue pavers”, “tissue BOX”, “BOX tissue”, “dust paper”, “garbage bag”, “trash bag”, “polybag” ”,“ Plastic bags, etc. ”,“ detergents, garbage bags ”,“ garbage bags, draining bags, etc. ”, etc. There are many transactions such as existence / non-existence and combinations of multiple product names, and there are an infinite number of summary terms, so the number of “fixed descriptions” and “journal patterns” increases and is selected. Becomes difficult. For this reason, conventional techniques include “associative input” that limits the selection range to facilitate selection input and hierarchical selection input of “journal pattern”. Even if you have obtained a “Summary” or “Journal Pattern”, you can supplement or modify the “What” summary phrase, enter “Select” from the “From” (“To”) or “Other” summary phrase, and edit its configuration. In such transactions, these input means are not very practical for such transactions, and in atypical transactions such as cash transactions, the frequency of occurrence is high in practice, and “what” and “from” (to ) ”Is selected and input for“ journal pattern ”in transactions where the combination is fixed, and“ normal input ”is mainly input in other transactions.
On the other hand, in the journal data creating apparatus of the present invention, “What” and “By” are selected by the function of selecting and inputting a plurality of designated data of “summary template” and “sub-summary template” in which blanks are allowed in the summary word phrase. Set a descriptive phrase such as “From (To)” and a fixed category element, arrange basic journal patterns, add blank description phrases directly by entering a string, and the date when the transaction occurred A function to convert numeric values to character strings based on simple numeric values such as the number of checkouts and the number of payments for receipts, or a description of the phrase “Others”, or by combining a predefined character string with the input data With the ability to edit post-edit summary elements, including formatting functions, etc., and the ability to automatically configure post-edit summary elements and edit combined summary elements, all complex summary composition editing tasks are automated,
Further, as described with reference to FIG. 40, as described with reference to FIG. 40, the “summary element 1” is also used for transactions in which the relevant account item is to be determined including a summary phrase that represents “what” and a summary phrase that represents “for what”. ”And“ Description element 3 ”by registering these description words in advance,
Further, even in a transaction in which a transaction with a different taxation classification is included in one receipt, the taxation classification is registered for each transaction. For example, the “golf play cost” of the summary number “103” shown in FIG. ”And“ Golf course use tax ”of“ 104 ”can be registered and selected easily. Transactions that include “light oil transaction tax”, “gift voucher”, “stamping tax / registration license tax”, “self-responsibility insurance premium / automobile weight tax / stamping fee”, etc. can be handled easily in the same way.
Furthermore, if the number of transactions registered in the “Summary Template” is limited to a very small number, the selection can be made easier, and the selection of a blank description phrase can be supplemented by direct input of a character string. Therefore, it becomes possible to select and input “summary template” in all transactions in the year, and as described above, “other elements” including the tax classification for each transaction can be acquired.
This is the end of the explanation of processing case 5. However, in processing case 1 to processing example 5, regarding “business income and expenditure”, sales are recorded, accounts receivable are collected, purchases are recorded, accounts payable are paid, and “expenses” are paid by salary. , Direct debits, accrued expenses, accrued expenses, payment of expenses in cash, and “non-operating income / expenses”, the following are examples of the main transactions in the year, such as interest income, interest expenses, and “financial settlement”. Although it is a part outline, it explained.
The journal data creation device of the present invention provides a long-term, practical and detailed analysis result regarding the contents of a wide range of transactions, including differences in business types and scales, application operations, subsidiary books, financial statements, and the relationship between each data. On the basis of creating journal data, “transactional transactions” that allow automatic selection and input of “journal patterns” and “non-standard transactions” that require manual input of “journal patterns” The input element types are classified as “fixed elements”, “independent variable elements” that are unavoidable to be input to a computer through human resources, and “fixed elements” or “independent variable elements”. Are classified into three “dependent variable elements” that can be automatically created based on the above, and by providing six types of storage units shown in FIG. 6 to FIG. all In transactions, complicated composition editing work is automated, and in regular transactions, all repetitive operations that are repeated regularly such as every month are automated, and as shown in Process Examples 1 to 4, When data of the minimum necessary independent variable elements including input is input, journal data including a description of appropriate contents is automatically created in a lump without manual intervention. In addition, it is possible to select and input “summary template” for all transactions in the year, thereby obtaining necessary data from “other elements” and using the journal data in other business.
Although the description of the embodiment of the present invention is finished as described above, the journal data creation method of the present invention can also be implemented by an application creation apparatus, etc. This corresponds to an embodiment of the data creation method. The same applies to the journal data creation apparatus, program, and program storage medium of the present invention.
In the above-described embodiment, as the best mode, a function is defined at the address of the dependent variable element, so that the dependent variable element is updated and a part of the journal data is created. The creation device may be one in which the corresponding dependent variable element is updated by a macro or the like.

Claims (5)

In the journal data creation device that creates journal data representing the bookkeeping sort including the transaction amount, debit category, credit category, and also the description of the transaction content as a character string,
A transaction data acquisition unit that acquires transaction data representing transaction contents, which represents at least one of a transaction date, “what”, “from”, and “where” and a transaction amount ,
Journal creation definition part is journal creation algorithm Gajo defined to create the journal data on the basis of the transaction data,
The definition correction unit that corrects the journal creation algorithm defined in the journal creation definition unit according to the operation, the transaction data acquired by the transaction data acquisition unit, and the journal creation defined in the journal creation definition unit A journal data creation unit that creates the journal data based on an algorithm,
The journal creation defining unit defines a journal creation algorithm including an editing algorithm for editing the summary character string by combining a plurality of character strings ,
The journal data creation device, wherein the journal data creation unit creates the journal data by editing the character string of the summary according to a journal creation algorithm including the editing algorithm. In the journal data creation device that creates journal data representing the bookkeeping sort including the transaction amount, debit category, credit category, and also the description of the transaction content as a character string,
A template storage unit for storing the summary template;
A data acquisition unit for acquiring numerical data representing a numerical value used for editing the summary character string, and a character string including a numerical value represented by the numerical data obtained by the data acquisition unit or a numerical value calculated from the numerical value Create a sequence, and write the created character string to a predetermined part of the template stored in the template storage unit to edit a character string including numerical values and non-numeric values as the summary character string. Journal data creation device characterized by comprising a section. The template storage unit stores a plurality of the templates,
The data obtaining unit also obtains model designation data for designating one model out of a plurality of models stored in the model storage unit;
3. The journal data creating apparatus according to claim 2, wherein the summary editing unit edits the summary using a template designated by the template designation data. In the journal data creation program that causes the computer to create journal data that represents the sort in the bookkeeping that includes the transaction amount, debit classification, credit classification, and also the description that represents the transaction contents in character strings,
Transaction data that is incorporated in the computer and represents the contents of the transaction on the computer, and includes at least one of the date, “what”, “from”, and “to” of the transaction and the transaction amount A transaction data acquisition unit for acquiring the transaction data represented ,
Journal creation definition part is journal creation algorithm Gajo defined to create the journal data on the basis of the transaction data,
The definition correction unit that corrects the journal creation algorithm defined in the journal creation definition unit according to the operation, the transaction data acquired by the transaction data acquisition unit, and the journal creation defined in the journal creation definition unit Building a journal data creation unit that creates the journal data based on an algorithm;
The journal creation defining unit defines a journal creation algorithm including an editing algorithm for editing the summary character string by combining a plurality of character strings ,
The journal data creation program, wherein the journal data creation unit creates the journal data by editing the character string of the summary according to a journal creation algorithm including the editing algorithm. In the journal data creation program that causes the computer to create journal data that represents the sort in the bookkeeping that includes the transaction amount, debit classification, credit classification, and also the description that represents the transaction contents in character strings,
A model storage unit that is incorporated in the computer and stores the summary model on the computer;
Data acquisition unit to obtain the numerical data representing the numerical values used for editing text of the ABSTRACT, and a numerical value which is calculated from a string or numeric thereof comprising a number representing the numerical data obtained by the data acquisition unit A summary of creating a character string and editing the character string including numerical values and non-numeric values as the summary character string by writing the created character string into a predetermined portion of the template stored in the template storage unit Journal data creation program characterized by building an editorial department.

Images