JPH04157564A - Automatic accounting journalization system - Google Patents

Abstract

PURPOSE:To eliminate a load on an operator by acquiring corresponding account item code and auxiliary account item code on a debit side and the ones on a credit side by searching a journalizing table at every journalizing type at a time to perform processing to generate journalizing, and automatically preparing journalizing data. CONSTITUTION:This system is comprised of a bill issuance program 1, a journalizing subroutine 2, a sale data file 3, a customer master file 4, a merchandise master file 5, the journalizing table 6, an accounting master film 7, a journalizing data file 8, and bill 9. At the time, when the processing to generate the journalizing is performed, the corresponding account item code and auxiliary account item code on the debit side and the ones on the credit side area acquired by searching the journalizing table 6, and the journalizing data can be automatically prepared. Thereby, it is possible to dispense with specific assistance by another's hand for the journalizing, and to eliminate the load on the operator.

Description

DETAILED DESCRIPTION OF THE INVENTION [Field of Industrial Application] The present invention relates to an automatic accounting journal entry system, and particularly to an automatic accounting journal entry system that automatically generates journal entries in an accounting system that journalizes debits and credits of account items.

[Conventional technology]

In conventional accounting systems, it was necessary to specify the debit account code and subaccount code and the credit account code and subaccount code for each journal entry type and input them from the screen. In other words, the operator had to check and input the debit account code and subaccount code, as well as the credit account code and subaccount code, which are set for each of the numerous journal entry types.

[K problem that the invention attempts to solve]

In the conventional accounting system described above, it was necessary to specify the debit account code and subaccount code and the credit account code and subaccount code for each type of journal entry and input them from the screen. ,
The task of determining and entering the debit account code and subaccount code and the credit account code and subaccount code is burdensome on the operator, and the task of determining and inputting the debit account code and subaccount code and the credit account code is burdensome. A drawback is that journal entries cannot be made in the accounting system until the account code and sub-account code are entered.

In view of the above-mentioned points, an object of the present invention is to search the journal table for each journal type at the time of each process of journal generation, and to search the corresponding debit account code and sub-account code and credit account code and sub-account code. The object of the present invention is to provide an automatic accounting journal entry method that obtains account item codes and automatically creates journal data.

[Means to solve the problem]

The accounting automatic journal entry method of the present invention is applicable to each journal entry type that stores the debit account code and subaccount code and the credit account code and subaccount code in an accounting system that journalizes the debit and credit sides of accounts. The journal table and the journal table for each journal type at the time the journal entry is generated are searched, and the debit account code and subaccount code and the credit account code and subaccount code are imported and the journal is automatically created. have a journal entry means for

[Effect]

In the accounting automatic journal entry system of the present invention, the journal table for each journal type stores the debit account code and subaccount 18 code, and the credit account code and subaccount code, and the journal entry means at the time when the journal entry occurs. Search the journal table for each journal type, import the debit account code and subaccount code, and the credit account code and subaccount code, and automatically create a journal entry.

〔Example〕

Next, the present invention will be explained in detail with reference to the drawings.

FIG. 1 is a block diagram showing the configuration of an automatic accounting journal entry system according to an embodiment of the present invention. and a journal entry subroutine 2 that is called from the invoice issuing program 1 and performs journal entry.
A sales data file 3 storing sales data, a customer mask file 4 including customer type codes, a product mask file 5 including product type codes, a journal table 6 provided for each journal type, and account items. It consists of an accounting mask file 7 containing codes and sub-account item codes, a journal data file 8 storing journal data, and an invoice 9.

Next, the operation of the automatic accounting system of this embodiment configured as described above will be explained.

■ When the invoice issue program 1 is started, the invoice issue program 1 first inputs sales data from the sales data file 3, and then inputs sales data from the customer mask file 4 using the customer code in the input sales data as a key. Get the destination type code.

(2) Next, the invoice issuing program 1 obtains the product type code from the product mask file 5 using the product code in the sales data as a key.

■ Next, the invoice issuing program 1 generates a journal entry type identifier that specifies the journal entry type of sales.

Journal subroutine 2 is called with the customer type code and product type code as parameters.

■ Journal subroutine 2 is a journal type identifier.

The journal table 6 of the corresponding journal type is searched using the customer type code and product type code as a composite key, and the debit account code and sub-account code and the credit account code and sub-account code are obtained.

(2) Next, the journal subroutine 2 checks whether the obtained debit account code and subaccount code and credit account code and subaccount code exist in the accounting mask file 7.

■ If the debit account code and subaccount code and the credit account code and subaccount code exist in the accounting mask file 7, the journal entry subroutine 2 uses the debit account code and subaccount code. It also determines that the credit account code and subaccount code are correct and returns them to the billing program l.

■ Invoicing program 1 uses the debit account code and subaccount code and credit account code and subaccount code returned from journal subroutine 2 and the amount in the sales data to generate an invoice. 9 is issued, and journal data is created and output to the journal data file 8. The journal data in the journal data file 8 is passed to the accounting system.

In this way, in the accounting automatic journal entry system of this embodiment, journal entry data is automatically created from sales data and journal entry is performed.

In the above embodiment, the case where the application program that performs journal entry is the invoice issuing program 1 is explained as an example, but the application program that performs journal entry may be other programs such as a deposit program, payment program, ordering program, cost amortization program, etc. Of course, it may also be an application program that creates a journal entry when it is of the journal entry type.

〔Effect of the invention〕

As explained above, the present invention searches the journal table for each journal type at the time of each process of journal generation, and searches the corresponding debit account code and subaccount code, as well as the credit account code and subaccount code. By obtaining the data and automatically creating journal entry data, there is no need for special manual intervention for journal entry, which has the effect of eliminating the burden on the operator and enabling quick journal processing.

[Brief explanation of the drawing]

FIG. 1 is a block diagram showing the configuration of an automatic accounting journal entry system according to an embodiment of the present invention. In the figure, l...Invoice issuing program, 2...Journal subroutine, 3...Sales data file, 4...Customer mask file, 5...Product mask file, 6...Journal table , 7...Accounting mask file, 8...Journal data file, 9...Invoice.

Claims (1)

[Claims] In an accounting system that journalizes debits and credits of accounts, there is provided a journal table for each journal type that stores debit account codes and subaccount codes, and credit account codes and subaccount codes. and a journal entry means that automatically generates a journal entry by searching the journal table for each journal type and fetching the debit account code and sub-account code and the credit account code and sub-account code at the time a journal entry is generated. An automatic accounting journal entry method characterized by having the following.