KR20090002167A - System and method for automatically preparing accounting-book - Google Patents

Abstract

An automatic tax accounting book writing system and method are provided to automatically input details of income and expenses with respect to a plurality of financial transactions to an accounting book when a user personally write the accounting book by using a tax accounting program. An automatic tax accounting book writing system includes a main server(100) which has a data receiving module(110) for receiving transaction data, a data mapping module(120) for extracting details of transaction from the received transaction data and mapping the extracted details of transaction to a standardized account subject, a journalizing process module(130) for journalizing the details of transaction by using the title of the standardized account subject, and a tax accounting book forming module(140) for forming a predetermined tax accounting book by using the journalized data, and a database server(200) storing at least one of the transaction data, the journalized data and the tax accounting book.

Description

System and method for automatically preparing tax accounting books {System and method for automatically preparing accounting-book}

1 is a diagram schematically showing a system for automatically creating a tax accounting book according to a preferred embodiment of the present invention.

FIG. 2 is a block diagram specifically illustrating a configuration of a terminal for a tax accounting management system according to FIG. 1.

3 is a flow diagram schematically showing a part of a method for automatically creating a tax accounting book according to a preferred embodiment of the present invention.

4 is a flow diagram schematically showing another part of the method for automatically creating a tax accounting book according to a preferred embodiment of the present invention.

The present invention provides a system and method for automatically preparing accounting books and tax returns, and more specifically, automatic preparation of accounting books and tax returns automatically applying transaction details used in financial transactions using banks or the like to accounting books or tax returns. The invention relates to a system and method.

Many companies, notably individual business owners or small- and medium-sized corporations, lack the expertise in accounting and taxation, so they are completely entrusted to bookkeeping, calculating tax amounts, and preparing financial statements. Typically, business operators provide such receipts to tax accounting offices that deal with one-month or three-month periods of data required for accounting management, such as receipts and tax invoices related to various payments, in order of date. do. Based on the receipt and tax invoice, the tax accounting office arranges the deposit and withdrawal details of each company in accordance with the prescribed accounting standards set by law. Report various taxes, such as VAT.

However, in the position of the tax accounting office, all sorts of receipts, etc. which are provided from each operator are booked, and all of the information recorded in the tax invoice is stored manually by a computer. For these manual inputs, operators pay a large amount to the tax accounting office, which is often a heavy burden on the operators. In addition, due to the fierce competition among tax accounting offices, the tax accounting office's price competition does not earn profits by listing the transaction details of the operators, but rather the salary and various incidental expenses of the employees who book them in terms of service to the operators. In most cases, only the actual expenses, such as rent, etc., are made for the captain. In this case, it is an unfavorable business model for the tax accounting office to carry out the bookkeeping manually without burdening the company with the burden of reimbursement and credit downgrade due to incorrect bookkeeping without making any special profit.

On the other hand, in order to reduce the cost burden, some operators may purchase various tax accounting programs and directly carry out the preparation of the book of accounts. However, various tax accounting programs make a lot of errors such as missing financial transaction details or entering transaction details in other account subjects instead of the correct account subjects. .

In addition, it was inconvenient to input the transaction history of the account account for each income and expenses by searching the transaction history or internet banking of the bookbook in the tax accounting program.

The present invention is an invention for solving such a conventional tax accounting problem, when the operator directly writes the accounting book for the income and expenditure history using the tax accounting program, the income and expenditure history for a number of financial transactions It is an object of the present invention to provide a system and method for automatically performing specific account subject input.

In addition, an object of the present invention is to provide a system and method for automatically guiding the correct account subject name for a specific transaction even if the operator does not know the exact account subject name for a specific transaction.

In addition, the present invention induces proper matching of transaction details and accounting subjects of financial institutions, and in particular, when a business operator or the like compares the transaction details of an accounting book with a financial institution, specific transaction details of accounting accounts in the accounting book and transaction details of the financial institution. It is an object of the present invention to provide a system and method capable of preventing the confusion caused by the contents described in the above.

Tax accounting book automatic filling system according to the present invention for achieving the above object:

A transaction specification data receiving module that receives transaction specification data for a predetermined financial transaction from a server of a financial institution, and extracts transaction details from the received transaction specification data, and maps the extracted transaction details and a standardized account subject. Tax mapping module, journal entry processing for journaling the transaction history mapped to the standardized account subjects using the standardized account subject name, and taxation to form a predetermined tax accounting book using the journaled data A main server including an accounting book forming module;

And a DB server for storing at least one of a tax accounting book of a predetermined form including the transaction specification data, the journalized data, and the journalized data.

The system may further include a display device for displaying a tax account book including the journalized transaction details.

The system may further include an input device capable of inputting predetermined data from the outside.

In addition, the transaction specification data preferably includes transaction details, transaction date, transaction party, transaction amount and transaction type information.

In addition, the tax accounting book preferably includes an accounting book and a tax return.

The data mapping module may further include a function of mapping an account number or a trading party with an account subject. In addition, the data mapping module preferably further includes a function for mapping the tax code and the account subject.

In addition, the journal entry processing module is an automatic journal processing module for journalizing the transaction history mapped to the standardized account subject using the standardized account subject name, and adds the journal entry transaction history through the input device It is preferable to include a manual journal processing module for changing, deleting, and deleting.

The DB server may further store mapping data defining account subjects mapped to the transaction details or transaction codes.

In addition, the tax accounting book automatic creation method according to the present invention for achieving the above object:

Receiving transaction specification data for a predetermined financial transaction from a financial institution server;

Extracting a transaction history from the received transaction specification data and mapping the extracted transaction history and a standardized account subject;

Journaling the transaction history mapped to the standardized account subject using the standardized account subject name; And

And forming a predetermined tax accounting book using the journalized data.

In addition, the method for automatically creating a tax account book further comprises the step of performing a predetermined financial transaction by the server of the financial institution.

In addition, the predetermined financial transaction is preferably carried out using the Internet banking, phone banking, ATM and financial transaction slip.

The performing of the predetermined financial transaction may further include receiving a transaction specification, and the received transaction specification may include a predetermined code.

In addition, the transaction specification may be previously designated by the server of the financial institution, or may be arbitrarily designated by the user.

In addition, the transaction specification data for a given financial transaction provided from the financial institution side server preferably further includes a code included in the transaction specification.

In addition, it is preferable that the method for automatically creating a tax account book further includes adding, changing, and deleting the journalized transaction details through a predetermined input means.

In addition, it is preferable that the method for automatically creating a tax account book further comprises displaying a tax account book including the journalized transaction details.

In addition, it is preferable that the method for automatically creating a tax account book further includes specifying and changing an account subject corresponding to the code or transaction specification in advance.

Meanwhile, in the present specification, the tax accounting book or the accounting book includes various accounting books such as financial statements, general journals, etc., tax and accounting books and various declarations generated in a general tax accounting program such as various tax return forms.

Next, the accounting book automatic generation system and method according to a preferred embodiment of the present invention will be described in detail with reference to the accompanying drawings. On the other hand, in order to more effectively represent the contents to be protected by the present invention, the components and functions commonly used in the conventional accounting book preparation system and method will not be described in detail.

1 is a diagram schematically showing an automatic account book creation system according to a preferred embodiment of the present invention.

As shown in FIG. 1, the system according to the present embodiment includes a terminal 10 for an accounting management system, a terminal 20 for an accounting management system, and a server 20 for a financial institution connected through a wired or wireless communication means such as an internet network. , Financial transactions such as Internet banking or phone banking terminal 31, ATM (32), financial transaction slip (33) connected to the financial institution server through the Internet, a dedicated line (not shown), and the like. Means. According to this configuration, for example, a financial transaction such as payment of a rent or a salary by a predetermined user through an Internet banking terminal 31, an ATM 32, a financial transaction slip 33, or the like. Then, the financial institution server 20 collects the transaction specification data for such a financial transaction. In addition, when there is a request for providing the data from the terminal 10 for the accounting management system, the terminal 10 provides the desired data, and the terminal 10 performs predetermined reprocessing based on the received data. After that, an account book is prepared, such as automatic journal entry processing. On the other hand, in this embodiment, the financial institution is not limited to any kind of institution that handles the normal financial business, such as banks, savings banks, post offices, securities companies.

In the system according to the preferred embodiment of the present invention, the configuration of the terminal 10 for the accounting management system may be briefly described as shown in FIG. 2. That is, as shown in Figure 2, the terminal 10 for the accounting management system according to the present embodiment is a data receiving module 110, data mapping module 120, journal entry processing module 130, accounting book forming module 140 And a DB server 200 including a main server 100 including the control unit 150, transaction specification data 210, journal processing data 220, an account book 230, and mapping data 240, and a display. The device 300 is composed of an input device 400.

In detail, the data receiving module 110 receives transaction specification data from the server 20 of the financial institution. The transaction specification data includes data related to the transaction date, the name of the trader, the type of transaction (deposit transaction, withdrawal transaction, bank transfer transaction, etc.), transaction details (rent, salary, electricity fee, etc.) and transaction amount. In particular, according to this embodiment, the transaction details, for example, rent-related transactions 1, salary-related transactions 2, utility bill-related transactions are classified and stored by a specific code, such as 3 times. . The code for classifying various transaction details may be previously designated by the server 20 or the terminal 10 of the financial institution, or may be arbitrarily formed according to a user's request.

In addition, the data mapping module 120 maps a transaction history, optionally a transaction code including a transaction code, among the transaction specification data into a standardized account subject. For example, if user A has provided a transaction specification from the financial institution-side server 20 in which a payment amount of KRW 1 million was transferred to account B on June 15, 2007, the data mapping module of user A's terminal is The account subject for the transaction specification described in the rent is mapped to the "payment rent" item, and the data mapping module of the user B terminal maps the account subject for the transaction specification described in the rent to the "rental income" item. On the other hand, the mapping of the transaction history and the account subject may be previously defined by the financial institution side server 20 or the accounting management terminal 10, or may be defined after the user by the user. In addition, such a mapping may be one-to-one mapping of one transaction history to one account subject, but may also map several transaction details to one. For example, if a business owner obtains a rental income for a plurality of real estate, the rent may be deposited in various nominal transaction details from the plurality of landlords, so a single account may be designated for the various transaction details. . Further, for convenience, the transaction details mapped to the account subjects may be provided in text characters, but the Internet banking terminal 31 shown in FIG. 1, an ATM 32, and a slip 33 for a financial transaction are provided. The predetermined code recorded in the code or a code arbitrarily arranged in the financial institution server may be directly mapped to the account subject.

In addition, automatic payment is often set so that a predetermined amount of money is automatically transferred when a predetermined expenditure occurs (for example, an electricity bill) for the same user every certain period of time. In such a case, instead of the transaction details, the account number to which the corresponding amount is transferred or the name of the transaction party and the account subject may be mapped. In addition, even when local taxes or national taxes are paid or refunded, the tax code may be mapped to the account subject.

Next, when the journal entry processing module 130 is mapped by the data mapping module 120 to classify the predetermined transaction history into a standardized account subject, the transaction including the transaction history is mapped using the mapped account subject. Use the specification to journal the transaction. For example, in the previous transaction, user A's terminal recorded a payment of 1 million won in the debit line in the journal voucher as of June 15, 2007, and user B's terminal in the journal entry's credit line reads 100 on the lease income account. The income of 10,000 won is recorded on June 15, 2007. On the other hand, the journal entry processing module 130 may automatically process the account subject before the transaction occurs in this way, like the journal entry method using a conventional program, after the transaction occurs manually the account subject for the transaction history Of course, it is possible to designate a journal entry or modify, add or delete account subjects automatically divided by the method described above. For example, the user may review the journal entry afterwards and correct the journal entry at any time if the journal entry is found to be incorrect due to an error in the system, a mistake in the depositor, or a mapping error. This modification is made using the input device 400 which will be described later.

Next, the accounting book forming module 140 automatically processes the transaction specification such as forming various accounting books by using the data processed by the journaling module. Since the formation of the accounting book is substantially the same as the procedure of forming an accounting book after a user enters a journal entry by a user of the related art, detailed description thereof is omitted.

In addition, the controller 150 controls the activities of various modules constituting the main server 100 described above.

The DB server 200 stores various data processed by the main server 100 described above. The data stored in the DB server 200 includes transaction specification data 210 provided from the server 20 of the financial institution. In addition, when the journal entry processing is performed on the transaction specification data, the journaled data 220 and the accounting book 230 when a predetermined accounting book is created based on the journaled data. In addition, as described above, the DB server 200 maps data 240 for information defining the mapping rule when 1: 1 or 1: multi mapping is performed between a predetermined account subject and transaction details in advance. Also save.

In addition, the display apparatus 300 is connected to the main server 100 and displays various data processed by the main server 100 described above to the outside. Accordingly, the user can check whether the accounting processing such as various data and journal entry processing is correctly performed through the display apparatus 300. The display device 300 is not limited to such types as a printing device such as a printer and an image device such as a CRT monitor or LCD monitor.

In addition, the input device 400 performs a function of directly inputting a predetermined command or data by a user. For example, the user may have other accounting contents in addition to the transaction details provided from the financial institution-side server 20, define / modify / delete the mapping of account subjects and transaction details, or specify transaction details such as existing mapped account subjects. When you want to modify / delete, etc. can perform the necessary work using the input device 400.

Next, an automatic accounting book creation method according to a preferred embodiment of the present invention will be described in detail with reference to FIGS. 3 and 4. For reference, components that perform the same functions as described above use the same reference numerals and will not be described in detail.

First, as shown in Figure 3, as a precaution for preparing an accounting book according to the preferred embodiment, the method defines a rule for mapping a predetermined transaction history and account subjects in the terminal 10 for the accounting management system ( S101). The account subjects used in this method do not limit the types of account subjects provided in advance in predetermined accounting management software and the like, and the account subjects defined by the user according to his needs. These rules for mapping certain transaction details and account subjects are defined, for example, if transaction details are recorded as rent in withdrawal or transfer withdrawal items, or automatically recognized as "payment rent" items, or withdrawal or transfer. Define a rule for mapping the transaction details and account subjects, such as if the withdrawal item records transaction details including rent, rent, and monthly rent keywords, all of which are recognized as "payment rent" items. The method is not particularly limited. In addition or in addition to the definition of a rule for mapping transaction details and accounting subjects, the server 20 of the financial institution or the main server 10 for the accounting management system may have a single digit for the transaction details that a user particularly frequently uses. It is possible to increase the convenience of the transaction by giving a two-digit code, and to write such a code in a financial transaction to be described later (S102).

After this precaution or, apart from the precaution, the user performs a predetermined financial transaction (S201). The financial transaction does not limit the types of transactions such as transactions using Internet banking or phone banking, transactions using cash dispensers, etc. and transactions using financial transaction slips at the counters, and types of transactions such as cash withdrawals, bank transfers, and checking transfers. . In addition, during financial transactions, it is desirable to increase the convenience of transactions by actively using the aforementioned code. When such a financial transaction is made, the financial institution side server 20 stores a transaction specification related to the financial transaction in a DB (not shown) (S202). Stored transaction details include the name and account information of one or both parties who performed the financial transaction, transaction date, transaction amount, type of transaction (deposit transaction, withdrawal transaction, account transfer transaction, etc.), transaction details (rent, salary, posting In general, it is preferable to include all information input during a financial transaction.

Next, a detailed procedure for preparing an accounting book using the transaction history stored in the financial institution DB will be described.

First, the terminal 10 for the accounting management system in which the predetermined accounting management system is built approaches the financial institution side server 20, and proceeds with a member verification procedure (S301). Typically, the terminal 10 and the server 20 of the financial institution are connected through a web server (not shown), and the member verification procedure does not limit the type such as using an accredited certificate or inputting a member ID and password. Do not. If the member is not a member, a predetermined membership registration process is to be performed. If the membership is confirmed, the next step is performed.

That is, if it is confirmed that the membership, the financial institution server 20 is requested to provide transaction specification data related to a predetermined financial transaction from the terminal 10, and received by the data receiving module 110 of the main server 100 Provide data (S302). The transaction specification data provided is the same as when a user of a terminal directly performs a transaction, when a transaction is performed using a bank account in the user's name, or when another person provides a transaction such as transferring a certain amount to a bank account in the user's name. It may include all the financial transaction-related transaction specification data associated with the user who requested to provide the transaction specification data related to the predetermined financial transaction, and according to the request of the terminal 10, predetermined conditions, for example, transaction period, transaction The parties may be limited data.

Subsequently, the data mapping module 120 extracts the transaction details from the provided transaction specification data, and maps the transaction details extracted according to the mapping rules of the transaction details and account subjects defined above with the corresponding account subjects (S304). As described above, for example, when user A has provided a transaction specification from the financial institution-side server 20 in which a payment amount of KRW 1 million was transferred to account B in the name of rent on June 15, 2007, user A's terminal. The data mapping module of the mapping the account subjects for the transaction specification described in the rent to the "payment rent" item, the data mapping module of the terminal B user terminal "rental income" account subjects for the transaction specification described in the rent Map to item. In addition, although the transaction details mapped to the account subjects may be provided as text characters for convenience, predetermined records recorded in the Internet banking terminal 31, ATM 32, and the financial transaction slip 33 are provided. Code or code arranged at the financial institution server may be directly mapped to the account subject.

Subsequently, when the journal entry processing module 130 is mapped to a specific account subject according to the rule defined in the circumstances by the data mapping module 120, the transaction history is displayed using the mapped account subject. The transaction is processed in the journal using the included transaction specification (S304). For example, in the previous transaction, user A's terminal recorded a payment of 1 million won in the debit line in the journal voucher as of June 15, 2007, and user B's terminal in the journal entry's credit line reads 100 on the lease income account. The income of 10,000 won is recorded on June 15, 2007.

Subsequently, the journal entry contents are displayed to the outside through the display apparatus 300, and the user checks the displayed journal entry data and checks whether the journal entry process is properly performed (S305). As a result of the check, it is determined whether the journaled data needs to be corrected, and if necessary, a method of modifying the journal entry, making a new journal, or modifying the displayed journal entry using the predetermined input device 400. The data can be corrected at step S306.

When the review and correction procedure of the journalized data is completed, the accounting book forming module 140 automatically performs accounting processing such as creating an accounting book using the data journalized by the journaling processing module (S307). On the basis of the prepared accounting book, the settlement of accounts, the preparation of financial statements, and the tax return process are carried out (S308). Since the procedure after the formation of the book is substantially the same as the procedure performed by the user after directly entering an account subject, the detailed description is omitted.

The accounting management system according to the preferred embodiment of the present invention and the accounting management method using the system have been described above. However, it is obvious to those skilled in the art that the systems and methods described in the embodiments are just one example and that various modifications and changes are possible. In addition, the above-described systems and methods have been described by dividing or integrating each component and steps in order to effectively explain the present invention, but these components can be easily integrated by those skilled in the art to which the present invention pertains. Can be configured separately. Therefore, the protection scope of the present invention is limited only by the claims made later.

The present invention solves the problem of the conventional tax accounting, when the operator directly creates an accounting book for the income and expenses details using the tax accounting program, input a specific account subject of the income and expenses details for a number of transactions It provides a system and method that can automatically perform.

In addition, by using the system and method according to the present invention, even if the business operator does not know the exact account subject name for a specific transaction, the operator is automatically guided to the correct account subject name for the specific transaction, thereby making it easy to create a journal and account book. This is possible.

In addition, by using the system and method according to the present invention, when the operator or the like compares the transaction details of the accounting book and the financial institution, the contents of the accounting book of the account book and the detailed transaction details of the transaction specification of the financial institution are different from each other. The confusion that occurs can be prevented.

Claims (18)

A transaction specification data receiving module for receiving transaction specification data for a predetermined financial transaction from a server of a financial institution; A data mapping module for extracting a transaction history from the received transaction specification data and mapping the extracted transaction history with a standardized account subject; A journal entry processing module configured to process journal entries for the transaction details mapped to the standardized account subjects using the standardized account subject names; A main server including a tax accounting book forming module for forming a predetermined tax accounting book using the journalized data; A DB server for storing at least one of a tax accounting book of a predetermined form including the transaction specification data, the journalized data, and the journalized data; Tax accounting book automatic creation system comprising a. The system of claim 1, wherein the system for automatically creating a tax accounting book further comprises a display device for displaying a tax accounting book including the journalized transaction details. The system according to claim 1 or 2, wherein the system further comprises an input device capable of inputting predetermined data from the outside. The system according to claim 1 or 2, wherein the transaction specification data includes transaction history, transaction date, transaction party, transaction amount and transaction type information. The system of claim 1 or 2, wherein the tax accounting book includes an accounting book and a tax return. The system of claim 4, wherein the data mapping module further comprises a function of mapping an account number or a transaction party with an account subject. The system of claim 4, wherein the data mapping module further comprises a function of mapping a tax code and an account subject. The journal entry processing module of claim 1, wherein the journal entry processing module automatically performs journal entry processing on the transaction history mapped to the standardized account subject using the standardized account subject name and the journal entry processing through the input device. Automatic bookkeeping system for tax accounting, comprising a manual journal processing module for adding, changing and deleting transaction history. The system according to claim 1 or 8, wherein the DB server further stores mapping data defining account subjects mapped to the transaction details or transaction codes. Receiving transaction specification data for a predetermined financial transaction from a financial institution server; Extracting a transaction history from the received transaction specification data and mapping the extracted transaction history and a standardized account subject; Journaling the transaction history mapped to the standardized account subject using the standardized account subject name; And Forming a predetermined tax accounting book using the journalized data; Tax accounting book automatic creation method comprising a. The method of claim 10, wherein the method of automatically creating a tax accounting book further comprises the step of performing a predetermined financial transaction by a financial institution side server. 12. The method of claim 11, wherein the predetermined financial transaction is performed using internet banking, phone banking, ATM, and financial transaction slips. The method of claim 11, wherein the performing of the predetermined financial transaction further comprises receiving a transaction specification, wherein the received transaction specification includes a predetermined code. The method of claim 11, wherein the transaction specification is defined by a financial institution server or a user terminal. 12. The method according to claim 11, wherein the transaction specification data for a predetermined financial transaction provided from the server of the financial institution includes an arbitrary code defining a transaction history of the transaction specification. The method of claim 10, wherein the method for automatically creating a tax account book further comprises adding, changing, and deleting the journalized transaction details through a predetermined input means. 17. The method of claim 16, wherein the method for automatically creating a tax accounting book further comprises displaying a tax accounting book including the journalized transaction details. 18. The method according to any one of claims 15 to 17, wherein the method for automatically creating a tax account book further comprises the step of designating and modifying an account subject corresponding to the code or transaction specification in advance. Autofill method.

Images