KR101892671B1 - System for automatic classification of account code - Google Patents

Abstract

The present invention relates to an account title classification system for automatically classifying account titles of expenses written in an income statement. More specifically, the account title classification system (1) for automatically classifying account titles of expenses written in an income statement comprises: a database manager unit (100) to input a company name and account titles of expenses corresponding to a company by a database manager to store the company name and the account titles of expenses; and a database user unit (200) to use data stored by the database manger unit to classify the account titles of expenses. Account titles of expenses written in an income statement are systematically managed. Accordingly, the present invention removes inconvenience of individually writing or correcting account titles of expenses written in an income statement and automatically classifies account titles corresponding to a customer name based on data previously stored by a responsible worker to easily manage expenses.

Description

A systematic classification of accounts that automatically classifies account items for expenses incurred in the income statement.

More particularly, the present invention relates to a system and method for automatically classifying account items to be created in a profit and loss account, more specifically, If the stored information is the same as the information in the tax invoice, the account subject corresponding to the customer is automatically changed and classified, so that it is easy to classify the account subject to the expense to be written in the income statement showing the dynamic state of the company The system automatically classifies account items of expenses to be incurred in profit and loss accounts that are managed systematically.

The profit and loss statement is a financial report that provides information on the performance of a company for a certain period of time. It not only represents the performance of the accounting period but also provides information useful for predicting the company's future cash flow and profitability.

In other words, the profit and loss statement is a financial statement that shows the profit and loss of the company during that period, that is, the business performance, by correlating the cost and profit of the fiscal year.

While the balance sheet shows the static status of the firm at a certain point in time, the profit and loss statement is a financial statement showing the dynamic status of the company for a certain period.

In the method of recording the income statement, there are two types of business performance measures, which describe only the ordinary profit and loss that occur continuously in the company's original term management, and those that occur and are found in the first fiscal year, Theoretically.

The profit and loss statement is a key component of financial reporting, which is a key component of revenue, expenses, and profits generated over a period of time and can show management activities and business results to external parties.

Such a statement of income is necessary for every industry that runs a business or where costs are incurred, and a system is needed to make it more accurate and easy to organize.

As a prior art relating to an account classification system for automatically classifying account items of expenses to be made in the profit and loss statement, as shown in Fig. 7 (a) (Hereinafter referred to as " Prior Art 1 ") is used to select and input deposits and withdrawals from a general store or a company that has to process tax accounting offices and accounting books And an input unit for inputting a deposit and withdrawal history, an account subject database unit configured such that an item to be input to the input unit and an account subject are matched in a 1: 1 manner, and an input unit An input unit for inputting the input item and an account subject database; And an output unit for outputting the contents recorded in the storage unit. The accounting processing method using the system is characterized in that the accounting processing method includes the steps of: depositing and withdrawing money, issuing and receiving a bill, Selecting and inputting the details of the selected item; matching the selected or inputted item with the bookkeeping item; comparing the selected bookkeeping item with the bookkeeping item; Debit and credit. Thus, the general user who is not familiar with accounting can easily create an account book with only the effort of creating a money account.

Another prior art is disclosed in Korean Patent Registration No. 10-1026158 entitled " Accounting processing system and method capable of inputting by pasting "(hereinafter referred to as" Prior Art 2 " A database, and a central processing unit, the database including a transaction information table, a management information table, an accounting information table, a customer table, an item table, Wherein the central processing unit includes a design processing unit, a transaction processing unit, a data extraction unit, a management processing unit, an entry processing unit, and a control unit, When entering transaction information through a transaction, the transaction information including the entry / exit classification, the transaction date, the account, the transaction details, the payment method, the payment method, the account subject, The input screen is generated in the form of a table structure in which rows and columns intersect so as to be input through one paste, and the input screen generated through the display device is provided so that the user does not input all the transaction information individually The transaction information can be collectively input through a simple input process through a single paste without using the transaction information.

However, the conventional technology including the prior art 1 to the prior art 2 is a comprehensive technology related to the overall accounting processing system, and it is still difficult for self-employed persons and small business owners who do not have the knowledge of accounting and taxation, It is difficult to understand and appropriately utilize it because it is constituted by a complicated structure which is difficult to handle.

Korean Registered Patent No. 10-0458766 (November 17, 2004) Korean Registered Patent No. 10-1026158 (March 24, 2011)

SUMMARY OF THE INVENTION Accordingly, the present invention has been made keeping in mind the above problems occurring in the prior art,

The purpose of the system is to automatically classify the account items of the expenses to be written in the profit and loss statement and to provide a system in which the management of costs can be thoroughly performed.

Another object of the present invention is to improve the efficiency of the personnel in charge of the expenses processing by automatically changing the information of the electronic tax invoice obtained from the National Tax Service to the accurate and detailed information as the cost to be written in the income statement .

In order to achieve the above object, the present invention has been made to solve the above problems,

In the Account Classification System, which automatically classifies account items of costs to be incurred in the income statement,

A DB manager unit for inputting and storing an account subject of a cost corresponding to a business name and a company by a DB administrator;

And a DB user unit for classifying account items of costs by using the data stored by the DB manager unit, so that account items of expenses to be created in the profit and loss statement are systematically managed.

At this time,

A business name input unit for inputting a name of a business partner;

A business name storage unit for storing and registering business partners entered in the business name input unit;

An account item input unit for inputting an account item matching with a business partner name stored in the business name storage unit;

A business account subject storage unit for storing information by connecting account subjects entered in the account subject entry unit and accounts stored in the business name storage unit;

And a DB manager sub-control unit for collectively controlling and controlling the functions of the business name input unit, the business name storage unit, the account subject entry unit, and the business account subject storage unit,

The DB user department,

An electronic tax invoice acquisition unit that obtains a list of electronic tax invoices issued to or received by the Internal Revenue Service;

The information obtained from the electronic tax invoice acquisition unit and the information stored in the business account storage unit are compared with each other. The information acquired from the electronic tax invoice acquisition unit, Business accounts that correspond to the counterparts of the counterparts against the information of the counterparts Automatically classify the accounts that are automatically applied to account items stored in the storage unit;

An account DB DB storage unit for storing data in which account subjects are classified through the business account DB automatic classification unit;

An electronic tax invoice acquisition unit, a business account class automatic classification unit, and an account subject DB DB storage unit.

It should be understood, however, that the terminology used herein is for the purpose of describing the claimed invention in its broadest possible form and should not be construed in a limiting sense. It should be construed as meaning and concept consistent with the technical idea of the present invention.

Therefore, the embodiments described in the present specification and the configurations shown in the drawings are only the most preferred embodiments of the present invention, and not all of the technical ideas of the present invention are described. Therefore, It is to be understood that equivalents and modifications are possible.

As described above, according to the present invention,

Accounts of costs to be written in the income statement are automatically classified so that the costs are managed thoroughly.

In addition, in the past, much time was required to confirm and store the information of electronic tax invoices obtained from the Internal Revenue Service, such as changing and correcting individual information, completing the inquiry with the customer, The present invention automatically changes this, thereby enhancing the work efficiency and the accuracy of the work of the person in charge of cost processing.

In addition, the simple structure of the system facilitates the handling of the cost-related personnel so that it can be continuously used without specialization. Therefore, it can be usefully used for small self-employed and small business owners who operate on a small scale. It is a very effective invention that allows companies to operate systematically and transparently because accurate information on costs, which is part of the profit and loss statement, which is one of the forms of financial statements for betting, is stored.

FIG. 1 is a schematic diagram of an account classification system that automatically classifies account items for expenses to be created in the income statement of the present invention.
FIG. 2 is a block diagram of an account classification system for automatically classifying account items of expenses to be created in the income statement of the present invention.
FIG. 3 is a flow chart of the DB manager section among the constituent elements of the account class classification system that automatically classifies account items of costs to be created in the profit and loss statement of the present invention.
FIG. 4 is a flow chart of the DB user part among the components of the account subject classification system that automatically classifies account items of costs to be created in the profit and loss statement of the present invention.
FIG. 5 shows an example of a start screen of an account classification system that automatically classifies account items for expenses to be created in the profit and loss statement of the present invention.
FIG. 6 shows an embodiment of an execution screen of an account classification system for automatically classifying account items of expenses to be created in the profit and loss statement of the present invention.
FIG. 7 shows a representative diagram of the prior art for an account classification system that automatically classifies account items for expenses to be made in the income statement of the present invention.

Hereinafter, the function, structure, and operation of the account classification system for automatically classifying account items of costs to be created in the profit and loss statement of the present invention will be described in detail with reference to the accompanying drawings.

FIG. 1 is a schematic diagram of an account classification system that automatically classifies account items for expenses to be created in the profit and loss statement of the present invention. FIG. 2 is an explanatory diagram of an account classification system for automatically classifying account items And a classification system for the subject classification system.

As shown in Figs. 1 and 2,

In the Account Classification System (1), which automatically classifies account items for expenses incurred in the income statement,

A DB manager unit 100 for inputting and storing an account subject of a cost corresponding to a business name and a company by a DB manager;

And a DB user unit 200 for classifying account items of costs by using the data stored by the DB manager unit, so that account items of expenses to be created in the profit and loss statement are systematically managed.

At this time, the DB manager unit 100,

A business name input unit 110 for inputting a name of a business partner;

A business name storage unit 120 for storing and registering business partners entered in the business name input unit 110;

An account subject input unit 130 for inputting an account subject matched with a business partner name stored in the business name storage unit 120;

A business account subject storage unit 140 for storing information by connecting account subjects entered in the account subject input unit 130 and accounts stored in the business name storage unit 120;

A database manager control unit 150 for collectively controlling and controlling the functions of the business name input unit 110, the business name storage unit 120, the account subject input unit 130, and the business account subject storage unit 140,

The DB user unit 200,

An electronic tax invoice acquisition unit 210 for acquiring a list of electronic tax invoices issued to or received from the Internal Revenue Service;

The information obtained from the electronic tax invoice acquisition unit 210 and the information stored in the business account subject storage unit 140 are compared with each other and the information acquired from the electronic tax invoice acquisition unit 210 And a business account class automatic classification unit 220 for automatically applying the account items stored in the business account item storage unit 140 corresponding to the mutual information of the business partners stored in the business name storage unit 120, ;

An account DB DB storage unit 230 for storing data in which account subjects are classified through the business account subject classifying unit 220;

A DB user control unit 240 for collectively controlling and controlling the functions of the electronic tax calculation obtaining unit 210, the business account automatic classifying unit 220 and the account subject DB DB 230.

More specifically,

The vendor account class automatic classifier 220,

A customer mutual analysis unit 221 for analyzing whether the business partners stored in the business name storage unit 120 and the customers on the electronic tax invoice acquired from the electronic tax invoice acquisition unit 210 are the same information;

The account subject application unit 222 is adapted to apply the account subject of the accountant stored in the business account item storage unit 140 to the data acquired from the electronic tax account acquisition unit 210, .

According to the present invention, the mutual information of the business partners and information on the account subjects directly connected to the business partners are stored in this configuration, and in contrast to the information on the mutual business partners entered in the electronic tax invoice acquired from the NTS on the basis of the stored data It automatically classifies and stores account items corresponding to each customer in electronic tax invoices so that the account items of expenses can be easily managed and confirmed.

More specifically,

5, the DB manager unit 100 logs in as "administrator login" in the initial start screen of the present invention, which is output to the display device D as shown in the flowchart of FIG. And the account subject matching with the business partner are inputted and stored.

In other words, the "administrator login" stores information on account subjects that are constantly matched to each other and the new account each time the fee is incurred, so that the user logs in to the "user login" Basic data is generated so that all account data of all the data (data in the electronic tax invoice) can be automatically classified into account subjects already stored in the DB manager unit 100 without omission.

On the other hand, when the DB user unit 200 logs in as "user login" in the initial start screen of the present invention output to the display device D as shown in FIG. 5, The tax invoice is obtained and the data of the business partners in the electronic tax invoice and the information of the business partners stored in the DB manager unit 100 are compared with each other in the electronic tax invoice and the data of the business partners stored in the DB manager unit 100 The DB account manager 100 applies the account subject stored and matched with the business partner to the data in the electronic tax invoice to be automatically classified.

This is an account classification system (1) that automatically classifies account items of expenses to be created in the profit and loss statement to be achieved by the present invention, and corresponds to the first embodiment of the present invention.

That is, and the first embodiment of the DB manager unit 100, the customers name and of accounts is matched to the "one-to-one" data is stored, such customers name and account subject is matched to the "one-to-one" data Is applied to the electronic tax invoice obtained from the IRS in the DB user unit 200, and the account subject to the cost corresponding to the account entered by the person in charge and stored is automatically classified.

The second embodiment is an example,

As shown in FIG. 6, which is not a "one-to-one" match between accounts of customers according to the first embodiment, there may exist a plurality of account courses, so that a plurality of account courses can be created (1), which automatically classifies account items of expenses to be made in the "one-to-many" income statement.

To solve this problem,

A company other account subject input unit 160 for inputting an account subject other than an account subject matched to a business partner account stored in the business account subject storage unit 140 to the components of the first embodiment,

And a business type account subject storage unit 170 for storing information by connecting the account subject entered in the business account entry unit 160 to the business partners stored in the business name storage unit 120. [

At this time, the DB administrator unit 100 further includes a business account item input unit 160 and a business account item account storage unit 170, so that the DB user unit 200 can automatically classify account items A manual account selection unit 250 that can change an account item of a corresponding account automatically classified by a company account automatic classification unit 220 into another account account so as to be changed to another account account;

A company account subject modification identifying unit 260 for performing a specific display process so that the user can easily identify the corresponding column in which the manual account selection subject unit 250 is executed;

A business account subject determining unit 270 for determining an account item of a cost of a corresponding column in which the business account automatic classifying unit 220 and the business account subject selecting unit 250 are implemented;

Even if the information obtained from the electronic tax invoice acquisition unit 210 and the information stored in the business name storage unit 120 are not mismatched and the account classes can not be applied, the operation of the system is not impeded An information mismatch neglecting unit 280 for allowing the system to proceed while leaving the corresponding mismatching information unchanged;

An information mismatch identification unit (290) for performing a specific display process so that the user can identify the corresponding mismatching non-mismatching unit (280); And

A completion confirmation unit 300 for allowing the user to visually confirm the operation of the vendor account class automatic classifier 220 and the business account manual selection unit 250 and the information discrepancy disabling unit 280 by the user ); ≪ / RTI >

In addition to these components, the account subject DB DB 230 of the DB user unit 200 includes not only the data on which account subjects are classified through the business account subject classifying unit 220 but also the manual account selecting unit 250, And the information discrepancy canceling unit 280 are stored.

In addition, the DB administrator sub-control unit 150 and the DB user sub-control unit 240 respectively include a business name input unit 110, a business name storage unit 120, an account subject entry unit 130, and a business account subject storage unit 140 The electronic tax bill acquisition unit 210, the business account class automatic classification unit 220, and the business account type automatic classification unit 220 may be configured to collectively control and control the functions of the other account subject entry unit 160 and the other account subject storage unit 170, The company account subject modification identifying unit 260, the business account subject determining unit 270, the information discrepancy discard unit 280, and the information item storage unit 230, as well as the account subject confirmation DB storage unit 230, The inconsistency identification unit 290, and the completion confirmation unit 300, as shown in FIG.

Meanwhile, the information discrepancy suspending unit 280 may be configured such that the information on mutual customer place information stored in the DB manager unit 100 and the mutual information on the mutual account information recorded in the electronic tax statement obtained from the IRS 200 in the DB user unit 200 are not the same If there is no account class, it is not disturbed by the automatic classification of the account subject, and the account name corresponding to the modified information is applied and classified by inputting or modifying the business partner mutually through the DB manager unit 100. [

In addition, although not shown in the drawings, the main account subject register (R) in the system implementation of "one-to-many" as in the second embodiment is further included, Before manually selecting a separate account item for the corresponding account, a plurality of account items may be automatically classified into account items that are automatically matched with the account name "one-to-one " It is possible to register the main account subject corresponding to each business partner.

As shown in FIG. 6, the information mismatch identification unit 290 and the completion confirmation unit 300 are output to the top right of the data table to identify whether the job is completed correctly or whether there is data to be corrected, . ≪ / RTI >

For example, in FIG. 6, it is informed to the person in charge that the work is not yet finished because "4" pieces of data with inconsistent information have occurred, "unfinished"

When the information is discarded, all data are discarded and the data is changed from "unfinished" to "completed" when the inconsistent data is "0".

The third embodiment is an example,

One-to-one "in the first embodiment and the" one-to-many "in the second embodiment are organically combined so that the information left by the information inconsistency-unchanging unit 280, as shown in FIG. 6, A system capable of adding a missing business partner name, correcting an incorrect business partner name, or adding a new account subject matching to a corresponding business partner through the DB manager unit 100 can be implemented.

The purpose of the Account Classification System (1), which automatically classifies account items for expenses to be incurred in the profit and loss account carried out in the first to third embodiments, is that the account person And even those who do not have any knowledge of accounting and tax affairs, and self-employed and small business owners can easily manage the accounts of expenses using electronic tax invoices.

The fourth embodiment is an example,

In the same way as the first embodiment described above, when the information is identical to the information of the counterparts stored in the system and corresponding account subjects and the electronic tax invoice obtained from the National Tax Service, In the case where the account subject is manually changed by the person in charge according to the second embodiment after the account subject is automatically changed and classified in the first embodiment, And an item name string storing unit 223 for storing a string of the item name corresponding to the account subject changed to the next account. Information about the subject as well as information about the string of the stored item name is applied together, Reduce the number of manual selections to further improve the accuracy and efficiency of work.

For example, referring to FIG. 6, if the business partner is the "Korea Productivity Center", the account that is automatically classified is selected as the "tuition fee" or the account person is manually selected as the "lecture fee".

At this time, when the person in charge selects the item "tuition fee" manually in addition to the account subject "tuition fee" automatically classified, the item name string storage unit 223 stores the item name "T1" If the customer name entered in the electronic tax invoice is "Korea Productivity Center", the account subject is automatically classified as "tuition fee" except for the item with the item name "T1". In addition, the corresponding item with the item name "T1" "To automatically classify account subjects.

Accordingly, as described above, it is possible to make more accurate and quick data rearranging by reducing the amount of correction work for the account subject to the expense that the person in charge gradually creates in the profit and loss statement.

In reference to the present invention, "DB" applied to the name of a component means a database.

It will be apparent to those skilled in the art that various modifications and variations can be made in the present invention without departing from the spirit or scope of the invention as defined in the appended claims.

Therefore, it is to be understood that the present invention may be embodied in many other specific forms without departing from the spirit or essential characteristics thereof, and the embodiments are to be considered in all respects as illustrative and not restrictive.

The present invention relates to a system for automatically classifying accounts for expenses to be made in profit and loss accounts into account subjects registered by a user through electronic tax invoices obtained from the National Tax Service, It can be applied to contributing to the promotion of industries related to accounting and tax affairs by allowing accurate information on the bill to be stored.

1: Account Classification System that automatically classifies account items of expense to be written in income statement
100: DB manager unit 110: business name input unit
120: business name storage unit 130: account subject input unit
140: business account subject storage unit 150: DB manager subordinate fisher unit
160: Business Other Account Subjects Input Unit 170: Business Other Account Subjects Storage Unit
200: DB user unit 210: electronic tax bill acquisition unit
220: Company Account Class Automatic Classification Unit 221:
222: Account subject application unit 230: Account subject confirmation DB storage unit
240: DB user sub-control unit 250: Manual account selection unit
260: Modification of business account subject identification part 270: Business account subject confirmation part
280: information discrepancy discontinuity section 290: information discordance discrimination section
300: Completion confirmation part D: Display device
R: Registered account subject

Claims (4)

delete delete delete A DB manager unit 100 for inputting and storing account names of costs corresponding to the business name and the company by the DB administrator, a DB user unit 200 for classifying the account items of cost by using the data stored by the DB manager unit Respectively,
(1), which automatically classifies account items of expense to be incurred in the profit and loss statement that allow account items of cost to be systematically managed,
The DB manager unit 100,
A business name input unit 110 for inputting a name of a business partner;
A business name storage unit 120 for storing and registering business partners entered in the business name input unit 110;
An account subject input unit 130 for inputting an account subject matched with a business partner name stored in the business name storage unit 120;
A business account subject storage unit 140 for storing information by connecting account subjects entered in the account subject input unit 130 and accounts stored in the business name storage unit 120;
A company name input unit 110, a business name storage unit 120, an account subject entry unit 130, a business account subject storage unit 140, a business account entry unit 160, a business account storage unit 170, A DB manager sub-controller 150 for collectively controlling and controlling the functions of the subject registering unit R;
A business account entry unit 160 for entering an account account that is separately associated with a business partner other than an account subject matching with a business partner account stored in the business account subject storage unit 140;
A business entity account storage unit 170 for storing information by connecting an account subject entered in the business account input unit 160 to a business partner stored in the business name storage unit 120;
And a main account subject register (R) for registering main account subjects matched to each other among the account subjects stored by the business account account subject entry unit (160) and the business account account subject storage unit (170)
Based on the data matched one by one with each other, the DB user unit 200 applies the electronic tax invoice to the electronic tax invoice obtained from the National Tax Service, So that they can be automatically classified and matched with one another even in the case of mutual accounts and account books by the other account subject entry unit 160, the account account storage unit 170 of the business account book, The main account classes are automatically categorized, other account subjects other than the main account subjects can be selected manually by the person in charge,
The DB user unit 200,
An electronic tax invoice acquisition unit 210 for acquiring a list of electronic tax invoices issued to or received from the Internal Revenue Service;
The information obtained from the electronic tax invoice acquisition unit 210 and the information stored in the business account subject storage unit 140 are compared with each other and the information acquired from the electronic tax invoice acquisition unit 210 And a business account class automatic classification unit 220 for automatically applying the account items stored in the business account item storage unit 140 corresponding to the mutual information of the business partners stored in the business name storage unit 120, ;
A manual subject selection unit 250 for classifying account subjects through the business class subject classifying unit 220 and an account subject DB DB 220 for storing changed data due to the information discrepancy denying unit 280. [ (230);
An electronic tax bill acquisition unit 210, a business account automatic classifier 220, an account subject DB DB 230, a business account manual selection unit 250, a business account subject modification and identification unit 260, A DB user control unit 240 for collectively controlling and controlling the functions of the account subject determining unit 270, the information discrepancy cancel unit 280, the information discrepancy identification unit 290, and the completion confirmation unit 300;
A business account that can change the account of the corresponding account automatically classified by the automatic account classifier (220) into another account account so that it can be changed into a separate account account in addition to the account class that is automatically classified. (250);
A business account subject modification identifying unit 260 for performing a specific display process so that the user can easily identify the corresponding column in which the manual account selection subject unit 250 is executed;
A business account subject determiner 270 for determining an account subject of the corresponding column in which the business account subject classifying unit 220 and the business account subject selecting unit 250 are implemented;
Even if the information obtained from the electronic tax invoice acquisition unit 210 and the information stored in the business name storage unit 120 are not mismatched and the account classes can not be applied, the operation of the system is not impeded An information mismatch neglecting unit 280 for allowing the system to proceed while leaving the corresponding mismatching information column;
An information mismatch identification unit (290) for performing a specific display process so that the user can identify the corresponding mismatching non-mismatching unit (280);
A completion confirmation unit 300 for allowing the user to visually confirm the operation of the vendor account class automatic classifier 220 and the business account manual selection unit 250 and the information discrepancy disabling unit 280 by the user ),
The vendor account class automatic classifier 220,
A customer mutual analysis unit 221 for analyzing whether the business partners stored in the business name storage unit 120 and the customers on the electronic tax invoice acquired from the electronic tax invoice acquisition unit 210 are the same information;
The account subject application unit 222 is adapted to apply the account subject of the accountant stored in the business account item storage unit 140 to the data acquired from the electronic tax account acquisition unit 210, ;
If the account subject is manually changed by the person in charge, the string of the item name corresponding to the manually changed account subject will be stored and applied to the account subject of the electronic tax invoice acquired from the next time , And an item name string storing unit (223) for storing a string of the item name corresponding to the account subject,
It stores information on the mutual information of the customer and the account subject to the mutual business partner, and compares the mutual information of the customer in the electronic tax invoice with the information on the mutual account entered in the electronic tax invoice obtained from the NTS on the basis of the stored data. The system automatically classifies and records the account subject corresponding to the cost category so that the subject of the account can be easily managed and confirmed.

Images