JP2006318004A - Automatic journalizing processing system and automatic journalizing processing program - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To reduce a user's burden by automatically journalizing, even if only a debtor account title is inputted, journal data of a counter side. <P>SOLUTION: This system comprises an account title information storage device 2 storing debtor account titles and creditor account titles in association with each other; an input part 1 inputting data for a debtor account title and an amount of money; a first retrieval means 4a retrieving the storage device 2 using an inputted account title to acquire a counter account title; a registration means 4c storing the input data in a journalizing specification storage device 3; and a second retrieval means 4b retrieving the counter account title of former data stored in the storage device 3 and determining whether it is matched to the counter account tile by the first retrieval means 4a. When the both are matched as a result by the second retrieval means 4b, the registration means 4c adds and stores the amount inputted to the input part 1 to the amount of the former data. <P>COPYRIGHT: (C)2007,JPO&INPIT

Description

  The present invention relates to an automatic journal processing system and an automatic journal processing program, and more particularly to an automatic journal processing system and an automatic journal processing program for performing a sorting operation on a slip.

  In recent years, accounting processing by computers has been rapidly spreading. As a conventional automatic sorting system, for example, as shown in FIG. 7 (1), in order to reduce the processing of the user, the amount including the consumption tax of the product is input to the debit account, and the total is added to the credit account When an amount is input, as shown in FIG. 7 (2), there is a proposal that can automatically calculate the amount of consumption tax in the amount of the product and perform an automatic journal of consumption tax (for example, (See Patent Document 1).

  The system described in Patent Document 1 stores account item master storage device 14 that stores account item information including at least a taxation category corresponding to an account item, and information on taxation category and consumption tax rate using a tax code as a key. The taxable master storage device 15, the display unit 13 for displaying various data, and the taxable classification corresponding to the input account item are retrieved from the account item storage means, and the taxable master storage means is retrieved from the acquired taxable classification. The search means 11 for obtaining at least the taxation classification and the consumption tax rate, and the means 13 for displaying at least the taxation classification and the consumption tax rate searched by the search means in the display frame window of the display means.

JP 2000-276549 A

  In the conventional automatic journal processing system described in Patent Document 1 above, as an entry for a subject subject to consumption tax, an amount including the consumption tax is entered in a debit item, and from a taxation classification to an amount in a credit item. When journal entries are entered, the amount of consumption tax is automatically calculated as shown in Fig. 7 (2), and the amount of consumption tax and the amount not including the consumption tax of the product are each determined as one transaction. Displayed with line breaks. However, since the amount of money must be input to both the debit and the credit, there is a problem that the load on the user is large.

  The present invention has been made to solve such a problem, and even when only a debit account item (or a credit account item) is input, automatic journal data can be automatically recorded on the counterpart side. The purpose is to obtain a journal processing system.

  The present invention provides an account information storage means for storing a debit account item and a credit account item in association with each other, and an input unit for inputting either debit or credit account item and amount data. The journal item storage means for storing the data input to the input means and the data after the journal, and the account item information storage means by using the account item of the data input to the input means, A first search unit for acquiring a counterpart account item corresponding to a data account item; a first registration unit for storing the data input to the input unit in the sorting detail storage unit; The counter account item of the previous data stored in the storage unit is searched, and the counter account item of the data acquired by the first search unit matches the counter account item of the previous data. If the result of determination by the second search means and that of the second search means match, the amount input to the input means is added to the amount of the previous data Then, when the result of determination by the second search means does not match the amount addition means stored in the journal details storage means as the amount of the counterpart account item, the first search means obtains Second registration means for storing the entered account details and the amount input to the input means in the journal specification storage means, and display means for displaying the data stored in the journal specification storage means Is an automatic journal processing system.

  The present invention provides an account information storage means for storing a debit account item and a credit account item in association with each other, and an input unit for inputting either debit or credit account item and amount data. The journal item storage means for storing the data input to the input means and the data after the journal, and the account item information storage means by using the account item of the data input to the input means, A first search unit for acquiring a counterpart account item corresponding to a data account item; a first registration unit for storing the data input to the input unit in the sorting detail storage unit; The counter account item of the previous data stored in the storage unit is searched, and the counter account item of the data acquired by the first search unit matches the counter account item of the previous data. If the result of determination by the second search means and that of the second search means match, the amount input to the input means is added to the amount of the previous data Then, when the result of determination by the second search means does not match the amount addition means stored in the journal details storage means as the amount of the counterpart account item, the first search means obtains Second registration means for storing the entered account details and the amount input to the input means in the journal specification storage means, and display means for displaying the data stored in the journal specification storage means Therefore, even if only a debit account (or credit account) is entered, the journal data of the other party can be automatically journaled, and the burden on the user is reduced. It can be reduced.

Embodiment 1 FIG.
The following shows an automatic journal processing system according to an embodiment of the present invention. The automatic journal processing system according to the present embodiment is composed of a computer such as a microcomputer. As shown in FIG. 1, the automatic journal processing system according to the present embodiment includes an input unit 1 composed of a keyboard, a mouse, and the like, an account information storage device 2, a journal detail storage device 3, a control unit 4, The display unit 5 includes a display and the like. The display unit 5 may include not only a display device such as a display but also printing means such as a printer. Further, the account item information storage device 2 and the journal statement storage device 3 may be any storage means, for example, a built-in or externally connected hard disk.
In the present embodiment, the counterpart account item is a credit for a debit and a debit for a credit.

The input unit 1 inputs a date, account item, amount, loan classification, and the like. That is, the user inputs the data using a keyboard or the like while looking at the account item, description, amount, date, etc. described in the withdrawal slip as shown in FIG.
The account item information storage device 2 stores account item information including counterpart account items and the like corresponding to the account items. FIG. 5 shows an example of data in the account item information storage device 2. As shown in FIG. 5, the account item information storage device 2 stores a debit account item and a credit account item in association with each other. In addition, as shown in FIG. 5, you may make it attach | subject the code | symbol as a reference number for identifying them to each account item of a debit and a credit as needed.
The journal entry storage device 3 stores information such as an account item, an amount, a loan classification, and a date, and is configured to be able to perform a search using the account item, the loan classification, and a date as a key. FIG. 6 shows an example of data in the journal entry storage device 3. As shown in FIG. 6, the journal entry storage device 3 stores input data and data after automatic journaling created based on the input data.
The control unit 4 controls the operations of the input unit 1, account information storage device 2, journal entry storage device 3, and display unit 5.
The display device 5 displays the contents of the journal entry storage device 3.

Further, as shown in FIG. 1, the control unit 4 is provided with first search means 4a, second search means 4b, registration means 4c, pointer means 4d, and memory 4e.
The first search means 4a searches the account item information storage device 2 using the account item as a key, and acquires the counterpart account item.
The second search means 4b searches the journal entry storage device 3 using the account item, the balance class, and the date as keys, and acquires the account item and amount to be searched from the stored data. .
The registration unit 4 c stores information such as account item, amount, balance classification, and date in the journal entry storage device 3.
The pointer means 4d displays a pointer (cursor or mouse pointer) indicating an input location on the input screen in the display unit 5.
The memory 4e stores a program for executing the processing shown in the flowchart of FIG.

Next, the operation of the automatic sorting system of the present invention will be described based on the flowchart of FIG. First, a pointer for taking in input data is reset by the pointer means 4d of the control unit 4 (step S1). Next, the data acquisition point of the input unit 1 is incremented, and the input data of the corresponding account item, balance class, amount, and date are received sequentially from the top (step S2). Next, the first search means 4a searches the account item information storage device 2 based on the account item of the input data, and acquires the counterpart account item corresponding to the account item (step S3). Next, the account details (including the summary), the amount, the loan classification, and the date of the input data are stored in the journal entry storage device 3 (step S4). In the example of the journal entry storage device 3 shown in FIG. 6, since the data storage area is divided according to the balance classification, the account item (in the storage area corresponding to the input data balance classification) (Including summary), amount, and date are stored.
Next, it is determined whether the input data is debited (step S5). If it is determined that the credit is a debit, the search debit classification of the journal entry storage device 3 is credited (step S6). On the other hand, if the credit is determined to be a credit, the debit division for searching in the journal entry storage device 3 is debited (step S12). Both step S6 and step S12 proceed to step S7, and the second search is performed using the counterpart account item acquired in step S3, the search balance set in step S6 or step S12, and the date received in step S2. The journal entry storage device 3 is searched by means 4b (step S7), and it is determined whether or not the counterpart account item, the lending classification, and the date match the previous data in the journal entry storage device 3 (step S8). . If they match, the registration means 4c adds the amount of the input data to the acquired amount in the journal entry storage device 3 and updates / stores it (step S9). On the other hand, if they do not match, the registration means 4c causes the journal entry storage device 3 to store the acquisition counterpart account item, the amount, the loan classification, and the date data (step S13). Both step S9 and step S13 proceed to step S10, where it is determined whether or not all input data has been captured (step S10). If all the input data has been captured, the information in the journal entry storage device 3 is displayed on the display unit 5 (step S11). On the other hand, if it is determined in step S10 that all input data has not been captured, the process returns to step S2.

The above operation will be specifically described with reference to an example of the withdrawal slip in FIG. FIG. 4A shows an example of the input screen, and FIG. 4B shows an example of the display screen of the display unit 5. First, the pointer for capturing the input data is reset (step S1), the data capture point of the input unit 1 is incremented, and “cost, work clothes” as the account item as shown in FIG. “Debit” is entered as the loan classification, “9500 yen” as the amount, and “April 11, 2005” as the input data as input data (step S2). In the example shown in FIG. 4 (1), date data is not input from the input screen, but of course, it may be configured to input from the input screen. The input unit 1 may be configured to pass input data.
Next, “Accounts payable” is acquired as the counterpart account item corresponding to the account item that matches the account item information storage device 2 from the account item “expense, work clothes” of the input data (step S3). Next, the date of input data “April 11, 2005”, the account item “expense, work clothes”, the amount “9500 yen”, and the debit category “debit” are stored in the journal entry storage device 3 (step S4). Next, when it is determined whether or not the credit classification of the input data is a debit (step S5), in this case, since it is a debit, the credit balance for searching in the journal entry storage device 3 is credited (step S6). Next, the journal statement storage device 3 is stored with the counterpart account item “Accounts payable” acquired at Step S3, the search credit class “Credit” set at Step S6, and the date “April 11, 2005” input at Step S2. By searching (step S7), whether or not the counterpart account item “Accounts payable”, the balance class “Credit”, and the date “April 11, 2005” match the previous data registered in the journal entry storage device 3. Is determined (step S8). This entry is the first, and there is no previous data, so they do not match. Therefore, in the journal entry storage device 3, “Accounts payable” as the acquisition counterparty account item, “9500 yen” as the amount, and “Credit” as the credit category "As the date, data of" April 11, 2005 "is stored (step S13). Since all the input data has not been captured, the process returns to step S2.

  In step S2, the data acquisition point of the input unit 1 is incremented, and as the next data, “expenses, office supplies” as the account item, “debit” as the debit category, “23750 yen” as the amount, as the date “April 11, 2005” is input (step S2). Next, “Accounts payable” is acquired as the counterpart account item corresponding to the account item that matches the account item information storage device 2 from the account item “expense, office supplies” of the input data (step S3). Next, the account item “cost, office supplies”, the amount “23750 yen”, the debit category “debit”, and the date “April 11, 2005” of the input data are stored in the journal entry storage device 3 (step S4). Next, when it is determined whether or not the credit classification of the input data is a debit (step S5), in this case, since it is a debit, the credit balance for searching in the journal entry storage device 3 is credited (step S6). Next, the journal statement storage device 3 is stored with the counterpart account item “Accounts payable” acquired at Step S3, the search credit class “Credit” set at Step S6, and the date “April 11, 2005” input at Step S2. Search is performed (step S7). Next, it is determined whether or not the counterpart account item “Accounts payable”, the balance class “Credit”, and the date “April 11, 2005” match the previous data registered in the journal entry storage device 3. (Step S8). Since the data matches the previous “cost, work clothes” data, the amount “23750 yen” of the input data is added to the amount “9500 yen” of the journal entry detail storage device 3 to update the amount to “33250 yen”. (Step S9). Next, it is determined whether or not all input data has been captured (step S10). Since all input data has not been captured, the processing returns to step S2.

  Again, in step S2, the data capture point of the input unit 1 is incremented, and as the next data, “expense, copy paper” as the account item, “debit” as the debit category, “28500 yen” as the amount, As a date, “April 11, 2005” is input (step S2). Next, “Accounts payable” is acquired as the counterpart account item corresponding to the account item that matches the account item information storage device 2 from the account item “expense, copy sheet” of the input data (step S3). Next, the account item “expense, copy sheet”, the amount “28500 yen”, the debit category “debit”, and the date “April 11, 2005” of the input data are stored in the journal entry storage device 3 (step S4). Next, when it is determined whether or not the credit classification of the input data is a debit (step S5), in this case, since it is a debit, the credit balance for searching in the journal entry storage device 3 is credited (step S6). Next, the journal statement storage device 3 is stored with the counterpart account item “Accounts payable” acquired at Step S3, the search credit class “Credit” set at Step S6, and the date “April 11, 2005” input at Step S2. Search is performed (step S7). Next, it is determined whether or not the counterpart account item “Accounts payable” and the credit classification “Credit and date“ April 11, 2005 ”” match the previous data registered in the journal entry storage device 3. (Step S8). Since it matches the data of the previous “cost, work clothes” and “cost, office supplies”, the amount of money “28500 yen” of the input data is added to the amount of money “33250 yen” of the obtained journalizing item storage device 3 Is updated to "61750 yen" (step S9). Next, it is determined whether or not all the input data has been captured (step S10). Since the input data has been captured, the information in the journal entry storage device 3 is displayed on the display unit 5 as shown in FIG. The display is terminated and the process is terminated (step S11).

  As described above, according to the present embodiment, in the journalizing process, only the debit (or credit) can perform automatic journaling of the other party's credit (or debit) journal data, which greatly increases the load on the user. It can be reduced and work efficiency is improved. Even if the user is unfamiliar with the journal process, the account item of the other party is automatically generated, so that the journal process can be easily performed without making a mistake.

  In the present invention, automatic journal data for accounting is input by inputting data (text data) from peripheral systems other than accounting (for example, sales system, material system, cost system, salary system, fixed asset management system, etc.). Can be applied to create

It is the block diagram which showed the structure of the automatic journal processing system based on this invention. It is explanatory drawing which showed an example of the withdrawal slip referred at the time of data input in the automatic journal processing system concerning this invention. It is the flowchart which showed the flow of the process of the automatic journal processing system concerning this invention. It is the block diagram which showed an example of the input screen and display screen of the automatic journal processing system concerning this invention. It is explanatory drawing which showed an example of the data of the account item information storage device in the automatic journal processing system concerning this invention. It is explanatory drawing which showed an example of the data of the journal entry storage device in the automatic journal processing system concerning this invention. It is explanatory drawing which showed the input data and the data after journal entry in the conventional journal entry system.

Explanation of symbols

  DESCRIPTION OF SYMBOLS 1 Input part, 2 account item information storage device, 3 journal details storage device, 4 control part, 4a 1st search means, 4b 2nd search means, 4c registration means, 4d pointer means, 4e memory, 5 display part

Claims (2)

Account information storage means for storing a debit account and a credit account in association with each other;
An input means for entering either debit or credit account and amount data;
Journal entry detail storage means for storing data input to the input means and post-journal data;
A first search unit that searches the account item information storage unit using the account item of the data input to the input unit, and acquires a counterpart account item corresponding to the account item of the data;
First registration means for storing the data input to the input means in the sorting detail storage means;
The counterpart account item of the previous data stored in the journal entry storage unit is searched, and the counterpart account item of the data acquired by the first search unit matches the counterpart account item of the previous data. A second search means for determining whether or not
If there is a match as a result of the determination by the second search means, the amount entered in the input means is added to the amount of the previous data to obtain the journal details as the amount of the counterpart account item. An amount addition means to be stored in the storage means;
If the result of determination by the second search means does not match, the counterpart account item acquired by the first search means and the amount input to the input means are stored in the journal description storage. A second registration means to be stored in the means;
An automatic journal processing system, comprising: display means for displaying data stored in the journal detail storage means. An account information storing step for storing account information in which a debit account and a credit account are associated with each other;
An input step that accepts either debit or credit account and amount data as input data;
A first search step of searching the account item information using the account item of the data input in the input step, and acquiring a counterpart account item corresponding to the account item of the data;
A first registration step of storing the data input in the input step as journal entry information;
The counterpart account item of the previous data already stored as the journal entry information is searched, and the counterpart account item of the data acquired by the first search step matches the counterpart account item of the previous data. A second search step for determining whether or not
An amount adding step of adding the amount input to the input means to the amount of the previous data if the result of determination in the second search step is a match;
As a result of the determination in the second search step, if there is no match, the counterpart account item acquired in the first search step and the amount input in the input step are used as the journal description information. A second registration step for storing;
An automatic journal processing program for causing a computer to execute a display step of displaying data stored as the journal detail information.

Images