JP2001306993A - Comprehensive accounting processing system using information system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a comprehensive accounting processing system using information system by which the accounting processing can be performed by mutually connecting a financial institute and an accounting office and the customers of the accounting office through a computer network (Internet), and automatically generating classification data necessary for the accounting office from the money payment and reception data of each customer in the financial institute. SOLUTION: The terminal of a financial institute, the terminal of an accounting office, and the terminals of the customers of the accounting office are connected to an accounting control center being the server of a computer network, and money payment and reception information in the financial institute of the customers is transmitted to the accounting control center. The accounting control center automatically prepares classification data from the transmitted money payment and reception information, and converts the classification data into slip data, and transmits the slip data to the terminal of the accounting office and the terminals of the customers.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION The present invention relates to a personal computer connected to an accounting management center, which is a server, via a computer network such as the Internet.
Financial institutions such as credit unions and post offices (hereinafter simply referred to as “financial institutions”), tax accountants and certified public accountants' tax accounting offices (hereinafter simply referred to as “accounting offices”), and accounting firms Accounting system by automatically transmitting and receiving data to and from clients (businesses, offices, and individuals) by using an information system that dramatically improves work efficiency. About the system.

[0002]

2. Description of the Related Art A general accounting process has a form as shown in FIG. That is, the accounting firm 300 has a large number of customers (company, office, group, etc.) 3011 to 301N. are doing. Then, each of the customers 3011 to 301N attaches a book based on the deposit / withdrawal data (passbook) at each financial institution 302 or cash withdrawal / payment (small cash) data, and inputs data to a personal computer equipped with accounting software. Accounting Office 3
At 00, the customer data is received as a copy of a book, or the data output of the personal computer is received at the FD, and the same data is again input to the personal computer of the accounting office 300 for offline work. Customers 301-301
The data entered into the personal computer at N is transferred to the accounting firm 300
What is input again is that the accounting software popularized in the accounting firm 300 is special, and the OS used by general companies is
Or because it is different from accounting software. In addition, there are many types of OSs of accounting software widely used in accounting firms, and this is the reason why it is not possible to combine the OSs and software of the accounting firm 300 into one and increase the efficiency.

[0003]

As described above, each customer 3
Due to differences in OS and software of 01-301N, accounting firm 300 must individually visit each customer to receive accounting data, return to the office, and repeat data entry. The input work was going to take a lot of effort and time in accounting.

As a solution to such a problem, there has been proposed a system in which an accounting firm and each customer are interconnected by a host computer of a center, and accounting operations are centrally managed through the host computer. However, there is a disadvantage that the cost of system construction is high. There is also a system in which a dedicated accounting device is provided to each customer as a stand-alone system, and accounting is performed using data from the dedicated accounting device. However, since it is necessary to install a dedicated accounting machine for each customer, there is a problem that it takes time and effort and costs increase.

SUMMARY OF THE INVENTION The present invention has been made in view of the above circumstances, and an object of the present invention is to interconnect financial institutions, accounting firms and customers by a computer network (Internet), and to provide each customer at a financial institution. It is an object of the present invention to provide a comprehensive accounting processing system using an information system that can automatically generate journal data required by an accounting office from deposit / withdrawal or transfer data, omit journal entry work, and efficiently perform accounting processing. .

[0006]

SUMMARY OF THE INVENTION The present invention relates to a comprehensive accounting system using an information system using a computer network such as the Internet. The object of the present invention is to provide a terminal of a financial institution, a terminal of an accounting office, A terminal of the customer of the accounting office is interconnected with an accounting management center which is a server of a computer network, and the customer's deposit / withdrawal information at the financial institution is transmitted to the accounting management center. This is achieved by automatically creating journal data from the deposit / withdrawal information, converting the journal data into form data, and transmitting the data to the accounting office terminal and the customer terminal.

[0007] In addition, by extracting a summary code from the deposit / withdrawal information and extracting a journal pattern code to create the journal data, or performing a journalizing process based on the knowledge of the journal pattern code. By using the first automatic journal knowledge base of the common knowledge, the second automatic journal knowledge base of the customer individual knowledge and the journal performance frequency table in the journal processing based on the knowledge, The above-mentioned object is achieved more effectively by including the customer's transfer information and small cash information.

[0008]

DESCRIPTION OF THE PREFERRED EMBODIMENTS According to the present invention, journal data (forms) are automatically created from deposit / withdrawal information, transfer information, and small-lot cash information at a financial institution to dramatically improve the efficiency of the work of an accounting office. The terminal of a financial institution (PC), the terminal of an accounting office (PC), and the terminal of an accounting office customer (PC) are interconnected to an accounting management center which is a server of a computer network such as the Internet. Then, the deposit / withdrawal information, transfer information, and small cash information at the customer's financial institution are transmitted to the accounting management center, and the journal entry data creation unit of the accounting management center uses the transmitted deposit / withdrawal information, transfer information, and small cash information to enter the journal data. Is automatically created, and the journal data is converted into form data and transmitted to the accounting office terminal and the customer terminal. Therefore, it is easy for customers to input only financial institution accounts and financial institution transfer information other than their own financial institution accounts. Is automatically taken as transfer information as it is, which is convenient. In addition, if an accounting firm is used, it is sufficient to review only the daily input contents of the customer every day and only a part of the amortization cost, it is possible to break away from inefficient business of bookkeeping agency business, and easily add added value such as management guidance Can be provided.

An embodiment of the present invention (a bank as an example of a financial institution) will be described in detail with reference to the drawings.

FIG. 1 shows an example of the overall configuration of the present invention.
Bank 1 (PC) 2 (21,
, 2n) are connected, the terminal (PC) 3 of the accounting office is connected, and the terminal (PC) 4 (41, 42,..., 4m) of the customer of the accounting office is connected. ing. The Internet 1 is further connected to a server 101 forming a website 100 of an accounting management center (operation manager of the present system), and various databases 110 are connected to the server 101.

The terminal 2 of the bank, accounting office and customer is shown in FIG.
As shown in FIG. 2, a CPU unit 20 having a copy function of a CD or FD, a drive function, and performing data processing.
1, a display unit 202 composed of a CRT or a liquid crystal and displaying images and characters, and a keyboard 203 and a mouse 204 for inputting data, commands and the like.

FIG. 3 shows an accounting management center 100, a bank 2,
FIG. 2 is a block diagram showing the input / output relationship of information between the accounting office 3 and the customer 4. The account management center 100 and the bank 2 transmit and receive the bank information D1 and the customer 4 with respect to the customer 4. Money information D2 is transmitted and received. In addition, between the accounting management center 100 and the accounting office 3, daily processing contents D3, monthly accounting journals D4 such as depreciation expenses, reserves, deposits, etc. not related to cash flows, search instructions and search results D5, various The information of the standard form output D6 is transmitted and received, and the accounting office 3 sends the information to the accounting management center 10.
A correction input D7 is input for 0. Further, between the accounting management center 100 and the customer 4, a content check D10 for referring to the deposit and withdrawal content, a correction input D11 for correcting data, a small cash input D12 indicating cash deposit and withdrawal data, a transfer information creation. D13, search instructions and search results D14, and various standard form output D15 information are transmitted and received.

FIG. 4 shows the detailed configuration of FIG. 3. The bank 2 has a bank deposit / withdrawal information database 21 for each customer and a transfer database 22 for each customer, and the account management center 100 has a deposit / withdrawal database 111. , Customer bank transfer information database 112, master file 11
3. A customer-specific transfer database 114 and an accounting information data warehouse 115 are installed, and a journal data creation unit 120 that automatically creates journal data, and based on the journal data created by the journal data creation unit 120. A form creation unit 130 for creating form data is provided. The data of the form creation unit 130 can be modified by the accounting office 3 and the customer 4, and the form data is sent to the accounting office 3 via the accounting information data warehouse 115.
And from the customer 4.

In such a configuration, the service during operation will be described with reference to the flowchart of FIG. 5 and the automatic journal flow of FIG. Here, the bank deposit / withdrawal data will be described, but the same applies to small cash deposit / withdrawal data.

Deposit and withdrawal data as a transaction at bank 2 (for example, “March 7, XYZ Corporation, deposit amount 1,000,00
"0") is stored in the bank deposit / withdrawal database 21 of the bank 2 and online at the accounting management center 100.
Is input to and stored in the bank deposit / withdrawal database 112 (step S1). FIG. 7 shows an example of the deposit data in the transaction data, and FIG. 8 shows an example of the withdrawal data.
It is shown as follows. Bank deposit and withdrawal database 11
2 is input to and stored in the journal data creation unit 120 via the deposit / withdrawal database 111.
It is extracted as payment data and payment data (step S2). Deposit data includes date, deposit amount, other store ticket, summary, and withdrawal data, date, withdrawal amount,
The journal data creation unit 120 matches the customer name registered in the business partner master 113A in the master file 113 with the payment source or payment destination (step S3). Of the relevant customer from the description master 113B of the
13B to obtain the corresponding summary code (step S
4). If there are multiple abstract codes, all of them are acquired.

XYZ Corporation, description code (sales, down payment), and customer type (customer) are registered in the supplier master 113A. For example, the description code (sales), journal entry, and the like are registered in the description master 113C. Pattern code (U0
001), a summary code (down payment), and a journal pattern code (M0001). Transaction master 113
An example of the registered content of A is shown in FIG.

When the summary code is obtained, a journal pattern code is extracted from the journal pattern code table 113C in the master file 113 based on the summary code (step S5). In the journal pattern code table 113C, for example, the journal pattern code (U0001), debit (cash and deposit), credit (sales), journal pattern code (M
0001), debit (cash and deposit), and credit (deposit). FIG. 10 shows an example of registration in the journal pattern code table 113C.

When the journal pattern code is obtained in this way, a journal entry process based on knowledge is executed (step S1).
0). This journal processing is performed by the automatic journal knowledge base (common knowledge) 131, the automatic journal knowledge base (customer individual knowledge) 132, and the journal actual frequency table 13 in the master file 113.
Automatic journal knowledge base (common knowledge) 1
31 is an automatic journal knowledge base (customer-specific knowledge) 1 when it is determined that the customer is a customer and has received a deposit, and it is a sales or advance receipt.
32 judges that XYZ Corporation is a customer. Further, the journal performance frequency table 123 includes, for example, a destination (XYZ Corporation), a deposit / withdrawal category (payment), a required dry code (sales), a frequency (30 times), a destination (XYZ Corporation), a deposit / withdrawal category. (Deposit), required code (advance payment),
Frequency (twice) is registered. The automatic journal knowledge base 131 of common knowledge is actually a predicate sentence (clause-type rule) including a predicate variable using the KAUS language. However, if an example of the rule is described in a Japanese sentence, it is as shown in FIG. In addition, the automatic journal knowledge base 132 of customer individual knowledge is actually a database (customer master 113A, journal actual frequency table 133, journal pattern code table 113).
C) are stored in the form of a table, and are items using the KAUS language at the time of inference. When an example of a rule is described in a Japanese sentence, the rule is as shown in FIG. Furthermore, the journal performance frequency table 13
The registration content of No. 3 is as shown in FIG.

After such a journalizing process, a bank account database is created (step S11), and a journal database is created (step S12). The journal result is, for example, “Cash (1,000,000) / XYZ Corporation sales (1,000,
000) ". As shown in FIG. 14, the attributes of the cash deposit transaction include a transaction number, a debit account, a credit account, a partner code, a partner name, a description code, a description name, and a transaction date. FIG. 15 shows an example of the journalizing result.

The above-mentioned automatic journalizing operation is described in FIGS.
Is executed according to the flowchart of FIG. That is, first, it is determined whether the deposit / withdrawal data is deposit or withdrawal (step S10).
0), in the case of payment, it is determined whether or not the business partner exists in the business partner master 113A (step S101). If the business partner exists, the journal record frequency at which the business partner of the transaction matches the summary is determined. The payment record in the table 133 is searched (step S102), and it is determined whether or not the record exists (step S103). If the corresponding record exists, the most suitable journal actual frequency record is selected by referring to the frequency information (step S104), and the record in the journal pattern code table 113C corresponding to the journal actual frequency record is searched. (Step S10
5) Thereafter, journalizing in the case of matching of the business partner (counterpart) is performed, and the processing ends (step S106). Note that the above step S
If the corresponding record does not exist in 103, a journal of an unknown account is created by matching the transaction (counterpart), and the process ends (step S107).

On the other hand, if the business partner does not exist in the business partner master 113A in step S101, a payment record is searched for in the journal record frequency table 133 in which the business partner and the description match (step S110). It is determined whether the record exists (step S11).
1). If the corresponding record exists, the most suitable journal actual frequency record is selected by referring to the frequency information (step S112), and the record in the journal pattern code table 113C corresponding to the journal actual frequency record is searched. (Step S113) After that, journalizing is performed in the case where the transaction (counterpart) does not match, and the processing ends (Step S11).
4). If there is no corresponding record in the step S111, a journal of an unknown account is created due to a mismatch between the business partners (counters), and the process ends (step S115).

If the deposit / withdrawal data is determined to be a withdrawal in step S100, it is first determined whether or not the supplier exists in the supplier master 113A (step S1).
20) If there is a business partner, a withdrawal record is searched for in the journal record frequency table 133 where the business partner of the transaction matches the description (step S121), and it is determined whether or not the corresponding record exists. (Step S122). If the corresponding record exists, the most appropriate journal actual frequency record is selected by referring to the frequency information (step S1).
23), a record in the journal pattern code table 113C corresponding to the journal actual frequency record is searched (step S124), and thereafter, the journal in the case of matching of the transaction (counterpart) is completed and the process is terminated (step S125). If there is no corresponding record in the above step S122, a journal for an unknown account is created by matching the transaction (counterpart), and the process ends (step S126).

If the business partner does not exist in the business partner master 113A in step S120, a withdrawal record in the journal record frequency table 133 in which the business partner and the description match is searched (step S130). It is determined whether or not the corresponding record exists (step S13)
1). If the corresponding record exists, the most suitable journal actual frequency record is selected by referring to the frequency information (step S132), and the record in the journal pattern code table 113C corresponding to the journal actual frequency record is searched. (Step S133) After that, journalizing is performed when the transaction (counter) does not match, and the processing ends (Step S13).
4). If there is no corresponding record in the above step S131, a journal of an unknown account is created due to a mismatch of the transaction (counter) destination, and the process ends (step S135).

On the other hand, FIG. 18 shows an example of creating a deposit payment journal, in which transfer data is created from bank transaction data (step S20). FIG. 19 shows an example of a list of transfer data in the comprehensive transfer, and FIG.
Shown in FIG. 21 shows an example of a list of transfer data in the payroll bonus transfer, and FIG. 22 shows an example of a transfer specification table. FIG. 23 shows an example of the transfer transfer. The transfer destination is acquired from such transfer data, and the customer master 113
A is matched with the supplier name of A (step S21),
The supplier name in the supplier master 113A is matched with the transfer destination of the transfer data (step S22), and a description of the corresponding supplier in the supplier master 113A is acquired.
3A journal pattern code is acquired (step S2)
3).

Thereafter, the journal of the corresponding journal pattern code is acquired from the journal pattern master (step S2).
4), create a deposit and withdrawal database (step S2)
5), create a journal database (step S2)
5).

Next, the supplier master 113A, the journal pattern code table 113C and the journal actual frequency table 1
An example of the registration operation of 33 will be described with reference to the flowchart of FIG.

Based on the journal result as shown in FIG. 15, it is first determined whether or not a record exists in the journal pattern code table 113C (step S200). If a record exists, the record is stored in the journal record frequency table 133. It is determined whether or not the record exists (step S201). If the record exists, the frequency of the journal entry frequency table 133 is set to “+1”, and the process ends (step S202). If there is no record in step S201,
It is determined whether or not a record exists in the supplier master 113A (step S203), and in any case, the data is written to the journal record frequency table 133 and the process is terminated (steps S204, S205).

If it is determined in step S210 that a record exists in the journal pattern code table 113C, it is determined whether a record exists in the journal record frequency table 133 (step S210). Further, it is determined whether or not a record exists in the supplier master 113A (step S211). In any case, data is written to the journal pattern code table 113C and the journal performance frequency table 133, and the frequency of the journal performance frequency table 133 is set to " +1 ”and the process ends (steps S212 and S213).

Further, if it is determined in step S210 that no record exists in the journal pattern code table 113C, it is determined whether a record exists in the supplier master 113A (step S214). The data is written in the pattern code table 113C and the journal entry frequency table 133, and the process ends (steps S215 and S216).

In step S204, the supplier master 113A stores
This is the case where there is a partner described in the transaction, and a record in which the field of the supplier code is filled is written in the journal record frequency table 133. On the other hand, step S205 is a case where there is no partner described in the transaction in the partner master 113A, and a record in which the field of the partner code is undefined is written in the journal record frequency table 133. Step S212 is a case where there is a partner described in the transaction in the supplier master 113A. In addition, a record is additionally written in the journal pattern code table 113C, and the corresponding record in the journal actual frequency table 133 is The record of the supplier code field and journal pattern code is updated, and the frequency count is changed to "+
1 ". On the other hand, step S213 is performed in the supplier master 113.
A shows a case in which there is no partner described in the transaction. A record is additionally written in the journal pattern code table 113C, and the corresponding journal result frequency table 13 is written.
The record in 3 is updated to a record in which the field of the supplier code is undefined and the journal pattern code is embedded, and the frequency count is set to “+1”.

In step S215, the supplier master 113A
This is a case where there is a partner described in the transaction, and a record is additionally written in the journal pattern code table 113C, and the record in the journal actual frequency table 133 in which the field of the supplier code and the journal pattern code are filled in is written. Additional writing is performed, and the frequency count is set to the initial value. On the other hand, step S216 is performed in the supplier master 113A.
In the case where there is no partner described in the transaction, a record is additionally written in the journal pattern code table 113C, and the field of the supplier code is undefined and the journal result frequency table in which the journal pattern code is embedded is written. The record in 133 is additionally written, and the frequency count is set to the initial value.

[0032]

As described above, according to the comprehensive accounting management system using the information system of the present invention, it is sufficient for the customer to input only payments other than their own financial institution accounts and financial institution transfer information. The work becomes easier, and the daily cash balance can be immediately grasped, and the input information of the bank transfer is automatically taken as the transfer information as it is, which is very convenient. In addition, it is possible to create a cash schedule for the following month and consult with various information services on the Internet.

If the accounting office is used, it is only necessary to review the daily input contents of the customer every day and only a part of the amortization cost, and it is possible to depart from the inefficient bookkeeping business from the inefficient business. This can provide an environment in which added value such as management guidance can be easily provided. With the same accounting system, daily closing of customers, and creation of a database, daily reviews can be improved by just reviewing.
Accounting firms can also receive various information services over the Internet.

[Brief description of the drawings]

FIG. 1 is a block diagram showing an example of the overall configuration of a comprehensive accounting management system according to the present invention.

FIG. 2 is a configuration diagram illustrating an example of a user terminal.

FIG. 3 is a diagram showing a relationship between an accounting management center, a bank, an accounting office, and a customer.

FIG. 4 is a block diagram illustrating a configuration example of an accounting management center.

FIG. 5 is a flowchart showing an example of creating journal data according to the present invention.

FIG. 6 is a diagram for explaining an operation of creating journal data according to the present invention.

FIG. 7 is a diagram showing an example of payment data.

FIG. 8 is a diagram showing an example of payment data.

FIG. 9 is a diagram showing an example of registration of a supplier master.

FIG. 10 is a diagram showing an example of registration of a journal pattern code table.

FIG. 11 is a diagram showing an example of rules of an automatic journal knowledge base for common knowledge.

FIG. 12 is a diagram showing an example of a rule of an automatic journal knowledge base for customer individual knowledge.

FIG. 13 is a diagram showing an example of registration of a journal performance frequency table.

FIG. 14 is a diagram showing an example of attributes of a cash deposit.

FIG. 15 is a diagram showing an example of a journalizing result.

FIG. 16 is a part of a flowchart showing an example of an automatic journalizing operation.

FIG. 17 is a part of a flowchart showing an example of an automatic journalizing operation.

FIG. 18 is a flowchart illustrating an example of creating a deposit payment journal.

FIG. 19 is a diagram showing an example of a list of transfer data in a comprehensive transfer.

FIG. 20 is a diagram illustrating an example of a transfer statement table in a comprehensive transfer.

FIG. 21 is a diagram showing an example of a list of transfer data in a salary bonus transfer.

FIG. 22 is a diagram showing an example of a payment statement table in a salary bonus transfer.

FIG. 23 is a diagram illustrating an example of a transfer transfer.

FIG. 24 is a flowchart showing an operation of registering a file.

FIG. 25 is a block diagram for explaining a work flow of a conventional accounting firm.

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 1 Internet 2 Bank terminal 3 Accounting office terminal 4 Customer terminal 21 Bank deposit / withdrawal database 22 Transfer database 100 Website 101 Server 110 Database 120 Journal data creation unit 130 Report creation unit

──────────────────────────────────────────────────の Continued on the front page (51) Int.Cl. ⁷ Identification symbol FI Theme coat ゛ (Reference) G06N 5/00 G06N 5/00 (72) Inventor Hiroaki Otsuka Axis software 3-10-3 Nagasaki, Toshima-ku, Tokyo Incorporated F term (reference) 5B049 BB46 CC21 CC36 DD01 EE01 EE05 EE11 FF03 FF04 GG04 GG07 5B055 BB20 CB01 CB03 CB09 CC06 CC10 EE02 EE05 EE21 EE27 FA01 FB03 PA05 PA34 PA36

Claims (5)

[Claims] 1. A terminal of a financial institution, a terminal of an accounting office, and a terminal of a customer of the accounting office are interconnected to an accounting management center, which is a server of a computer network, and deposit / withdrawal information of the customer at the financial institution is provided. To the accounting management center, the accounting management center automatically creates journal data from the transmitted deposit / withdrawal information, converts the journal data into form data, and converts the journal data into the accounting office terminal and the customer. A comprehensive accounting system using an information system, wherein the information is transmitted to a terminal. 2. A general accounting system using the information system according to claim 1, wherein an abstract code is extracted from the deposit / withdrawal information, and a journal pattern code is extracted to create the journal data. Processing system. 3. An integrated accounting system using an information system according to claim 2, wherein journalizing processing is performed on said journal pattern code by knowledge. 4. The first common knowledge in the journalizing process based on the knowledge.
4. A comprehensive accounting system using an information system according to claim 3, wherein the automatic journal knowledge base, the second automatic journal knowledge base of customer individual knowledge, and the journal performance frequency table are used. 5. A comprehensive accounting system using the information system according to claim 1, wherein the customer's transfer information and retail cash information are included in addition to the deposit / withdrawal information.