KR101026158B1 - Pasting inputable accounting processing system and the method - Google Patents

Abstract

The present invention relates to an accounting processing system and method, and more specifically, to an accounting processing system and method capable of automatically accounting for transaction information generated in a company's business activities and inputting by pasting.

The accounting processing system of the present invention comprises an input device, a display device, a database (DB), and a central processing unit. The database includes a transaction information table, a management information table, an accounting information table, an accounting table, And an item table and a basic mapping table. The central processing unit includes a design processing unit, a transaction processing unit, a data extracting unit, a management processing unit, a journal entry processing unit, and a control unit. When entering transaction information through the input device, a single batch of transaction information including entry / exit division, transaction date, customer, transaction summary, payment method, payment method, account subject, amount and management items Create an input screen in the form of a table structure in which rows and columns cross each other so that they can be inputted through the display device. Input by pasting, characterized in that the user can enter the transaction information collectively through a simple input process through a single paste without having to individually enter all the transaction information by providing a separate input screen Provide this possible accounting system.

Accounting, Automatic Journals, Paste

Description

Pasting inputable accounting processing system and the method

The present invention relates to an accounting processing system and method, and more specifically, to an accounting processing system and method capable of automatically accounting for transaction information generated in a company's business activities and inputting by pasting.

In general, an entity prepares journal entries consisting of debits, credits, account subjects, and amounts due to double entry bookkeeping in accordance with generally accepted accounting practices. Calculating The accounting processing by the double bookkeeping is a complicated and time-consuming task such as debiting transaction information into debit and credit, setting an account subject, and then recording an amount.

In the accounting processing by the double bookkeeping, as the company's business is computerized, the conventional technology that enables the above accounting processing is possible even though the transaction information is prepared in the form of computer media and provided to the accounting person. The accounting manager using the accounting system is performing repetitive tasks of manually inputting transaction information written in a computerized format one by one.In addition, the accounting system according to the prior art provides an existing journal entry to the inputter during journal entry processing. Present the data to select the appropriate account subjects, or present the data that classified the transaction type corresponding to the account subjects into large items and small items to the inputter so that the inputter selects the account subjects through a gradual selection process. There was a treatment.

However, the accounting system according to the related art has a problem in that it is not possible to input and process only transaction information because it is necessary to directly or indirectly select account information as well as transaction information in a related data input process, and also in a computerized media format. There was a problem that it takes a lot of input time because the transaction information must be entered manually one by one, in particular, there was a problem that the transaction information is not input by pasting.

Therefore, an object of the present invention is to increase the productivity of the input by enabling the input by pasting the transaction information in the form of a computer medium during the accounting processing of the conventional company.

In addition, it is an object to automatically proceed to the journal entry without the input of the subject when the input by the paste.

As a technical idea for achieving the above object, the present invention comprises an input device, a display device, a database (DB) and a central processing unit, wherein the database, transaction identification number, entry and exit, trading date, trading partner, type of evidence Transaction information table configured to store payment method, payment method, account subject and management item, and management unique number, management item, quantity, unit price, amount, account subject and transaction unique number Accounting information table configured to store information table, account, management item, account subject, amount, transaction unique number and management unique number, account unique number, account name, account classification, document type, payment method, original Account table that stores account unique number, account subject, purchase subject, sales subject, item name, item classification, account subject, cost subject, sales subject And a basic mapping table in which the configured item table and transaction segment, account subject, purchase subject, and sales subject are stored. The central processing unit generates an input screen for the user to input transaction information through the input device. A design processing unit for providing an input screen generated through the display device, receiving transaction information through the design processing unit, generating a transaction unique number corresponding thereto, and generating the generated transaction unique number and the input transaction information of the DB; A transaction processing unit for storing in the transaction information table, a data extracting unit for extracting data corresponding to the account using the account, account subject and management items among the input transaction information from the account table, the item table and the basic mapping table of the DB; Each management unique number corresponding to the data extracted through the data extraction unit And a management processor for storing the generated management unique number and the data transmitted through the data extractor in the management information table of the DB to match the transaction unique number, the data stored in the transaction information table and the management information table. The journal entry processing unit automatically generates a journal voucher and stores it in the accounting information table of the DB, and receives transaction information according to the paste function of the input device through the design processing unit from the journal processing unit, and the transaction received through the transaction processing unit. Store information in the transaction information table, generate a plurality of management information according to the transaction information through the data extraction unit and the management processing unit, and store it in the management information table, and use the journal processing unit to process the transaction information table and management information Automatically create journal documents by combining data stored in tables Is configured to include a control unit, the design processing unit of the central processing unit, when the user inputs the transaction information through the input device, entry and exit classification, transaction date, customer, transaction summary, payment method, payment means, account subjects, Create an input screen in the form of a table structure where rows and columns intersect so that transaction information including amounts and management items can be entered at once through a single paste, and provide an input screen generated through the display device. The accounting processing system capable of input by paste, which provides the user to input the transaction information collectively through a simple input process through one paste without having to input all the transaction information individually. To provide.
In addition, the present invention generates an input screen for the user to input the transaction information through the input device, and receiving the transaction information according to this, including the transaction date, trading partner, amount information of the received transaction information Outputting a message requesting re-entry to the user if the essential information is missing, re-entering the required information, generating a transaction unique number according to the received transaction information, and matching the received transaction information; Extracting the data from the DB to generate management information corresponding to the transaction information; and if the corresponding transaction information is not present in the DB, the account name, transaction classification, proof type, payment method in the DB. And automatically generate new account information including the original account unique number, account subject, purchase subject, and sales subject. And the step of assigning a transaction destination unique number, the automatic journal processing by combining the transaction information and the management information, and outputting the result through a display device, wherein the step of receiving the transaction information comprises: When the transaction information is input through the input device, the transaction information including the entry / exit division, the transaction date, the customer, the transaction summary, the payment method, the payment method, the account subject, the amount, and the management item is pasted at once. Creates an input screen in the form of a table structure where rows and columns intersect so that they can be entered through, and provides an input screen generated through the display device so that the user can paste one time without having to individually enter all the transaction information. Characterized in that to provide a batch input through the transaction information through a simple input process Provides a method of accounting that can be entered by pasting.

In the case of using the accounting processing system and method according to the present invention, the accounting manager of each company can enter the accounting targets that can be pasted at once and make automatic journals, and the appropriate account subjects are provided according to the counterparties. It can save you a lot of time and money.

For example, a tax accounting office may receive accounting data including a tax invoice, etc., along with a document from a client who has requested a book. If the file is copyable, it can be pasted into the accounting processing system according to the present invention. have. According to an exemplary embodiment of the present invention, the number of data items is 2000, but it takes about 1.5 days when the accounting experience person inputs the normal work posture. Accounting may be completed within one hour, including the time of reviewing whether it has been processed. Since the accounting experience knows accounting well, the input time required for about 1.5 days is a simple input time through a keyboard.

In addition, most accounting processes including complex compound transactions can be performed without the need for debit or credit, without accounting, so that users can perform accounting without knowing accounting.

The present invention is an invention based on this point, and the accounting processing method according to the present invention for achieving the above object comprises: (I) receiving transaction information including a customer keyword; Searching for data matching the provided keyword and extracting the searched data; Automatically generating management information on the transaction information (III); Storing the transaction information and management information (IV); (V) automatically combining and storing the transaction information and management information.

In addition, the accounting processing system according to the first embodiment of the present invention for achieving the above object is a display in which an input device for inputting the keyword information and a space for pasting a large amount of transaction information including a customer keyword are displayed. An accounting processing system comprising an auxiliary memory device for storing an accounting processing program for performing an accounting process, comprising: a data extracting unit for extracting data corresponding to the keyword from a DB, a transaction processing unit for recording the transaction information; Management processing unit for recording the management information connected to the transaction information in one-to-many, the transaction information and one-to-one connection with the management information, journal entry processing unit for automatically creating a journal, can paste a large amount of transaction information, including the keyword of the customer Design processing unit and the data extraction unit, transaction processing unit, the pipe to create a space provided A central processing unit including a processor, a journal processing unit, a control unit for controlling the operation of the processor design, and provides a temporary storage; It is preferable to include a DB for storing the transaction information, management information, journal entry information and account information, item information, basic mapping information.

Further, in the accounting processing system according to the present invention, the transaction information is stored in a transaction information table, the management information is stored in a management information table, the journal information is stored in an accounting information table, and the account information is stored in an account table. Preferably, the item information is stored in an item table, and the base mapping information is stored in a base mapping table.

In addition, the data stored in the transaction information table, management information table, accounting information table, account table, item table, basic mapping table is preferably assigned a unique number.

In addition, the transaction information table preferably includes a transaction unique number, entry and exit, transaction date, account, document type, payment method, payment means, account subjects, management items, etc., which are objects applied to various accounting processes. Do.

The management information table preferably includes a management unique number, a management item, a quantity, a unit price, an amount of money, an account subject and a transaction unique number of the transaction information table, which are various objects applied to various accounting processes. .

The accounting information table may include a customer, a management item, an account subject, an amount of money, a transaction unique number of the transaction information table, and a management unique number of the management information table, which are various objects applied to various accounting processes. It is preferable.

Further, the management information table and the accounting information table having a one-to-many relationship with the transaction information table store a transaction unique number of the transaction information table, and the accounting information table having a one-to-many relationship with the management information table is a management-unique of the management information table. It is desirable to further store and maintain the number.

In addition, the account table includes a customer object number, account name, account classification, document type, payment method, original account number, account subjects, cost subjects, sales subjects, etc., which are objects applied to various accounting processes. It is desirable to.

In addition, the item table preferably includes item names, item classifications, accounting subjects, cost subjects, sales subjects, and the like, which are objects applied to various accounting processes.

In addition, the basic mapping table is preferably characterized in that it includes a variety of objects that are applied to the accounting processing, such as transaction classification, account subjects, purchase subjects, sales subjects.

In addition, it is preferable that the entry / exit division includes one of a list consisting of deposits, withdrawals, purchases, sales, etc. (hereinafter referred to as an "entry entry and exit list").

 In addition, the payment method preferably includes one of a list (hereinafter referred to as "payment method list") consisting of cash, bank account, card, bill, credit, substitute, and the like.

In addition, it is preferable that the transaction segment includes one of a list (hereinafter referred to as "trade segment list") consisting of a purchase destination, a sales source, a bank account, a sales card, a purchase card, a paper bill, and a pay bill.

In addition, the item classification preferably includes one of a list consisting of an account subject, inventory name, management items, etc. (hereinafter referred to as "item classification list"). In the above list, the account subject is the delimiter that represents the normal account subject, the inventory item name is the delimiter that indicates the item name related to the normal inventory asset, and the management item indicates the subject that the user has arbitrarily created for use instead of the account subject. Is a delimiter.

The entry / exit division list, payment method list, account classification list, and item classification list may be arbitrarily adjusted to have a larger number or a smaller number.

In addition, it is preferable that the account keyword includes the account name among the objects of the account table.

Hereinafter, exemplary embodiments of the present invention will be described with reference to the accompanying drawings. For reference, this embodiment is only one of the best forms constituting the present invention, the scope of the present invention is not limited by the following embodiments.

1 is a block diagram showing a configuration of an accounting processing system according to a first embodiment of the present invention, Figure 2 is a block diagram illustrating in detail the configuration of a table constituting the DB 200 shown in FIG. .

In addition, as shown in FIG. 1, the central processing unit 100 retrieves various types of accounting data stored in the DB 200 according to a command of the control unit 110, and extracts the retrieved data. The transaction processing unit 130 generates a transaction file stored in the transaction information table 230 when the predetermined data is provided from the control unit 110 and records the provided data. When predetermined data is provided from the control unit 110, a management file stored in the management information table 240 is generated, and when the predetermined data is provided from the control unit 140 and the control unit 110 for recording the provided data, A journal entry processing unit 150 for automatically creating and recording a journal slip by combining the data stored in the information table 230 and the management information table 240, and then storing the data in the accounting information table 250. Design processing unit 160, the data extraction unit 120, the transaction processing unit 130, the management processing unit 140, the journal processing unit 150, the design processing unit to create and provide a space for pasting a large amount of transaction information, including The controller 110 controls an operation of the 160.

Also, as shown in FIG. 2, the DB 200 includes an account table 211, an item table 212, a basic mapping table 213, a transaction information table 230, a management information table 240, and an accounting information table 250. ).

In detail, the basic mapping table 213 preferably stores various types of objects that are applied to various accounting processes, such as transaction classification, account subject, purchase subject, and sales subject. Preferably, the account segment includes one of the account segment lists. The account subject stores one of ordinary account subjects representing trade payables, such as accounts receivables and accounts payable, in the case of a purchaser in accordance with the transaction segment, and one of the normal account subjects representing trade receivables, such as accounts receivables and receivables, in the case of a customer. In the case of a bank account, it stores one of the normal account subjects representing the deposit such as ordinary deposit, periodic deposit, and savings.In the case of a sales card, it stores one of the common account subjects representing the receivables such as card receivables and receivables. In the case of a card, one of the normal account subjects representing unpaid payments, such as unpaid cards and unpaid payments, is stored.In the case of notes, one of the normal account subjects representing notes received, such as notes received, is stored. Stores one of the common accounting subjects of notes payable. The purchase subject of the basic mapping table 213 stores one of ordinary account subjects representing asset subjects or expense subjects, such as operating expenses, products, products, securities, entertainment, interest expenses, etc. do. The sales subject of the basic mapping table 213 may store one of ordinary account subjects representing profit subjects such as product sales, product sales, and interest income according to the customer segment.

The account table 211 is a variety of objects that are applied to various accounting processes, such as account unique number, account name, account classification, proof type, payment method, original account unique number, account subject, purchase subject, sales subject, etc. Is preferably stored. Preferably, the account segment includes one of the account segment lists. The payment method preferably includes one of the payment method list. If the original account unique number is to be stored under a different account name (derivative account) even if there is an original account, it is preferable to store the unique number of the original account in the original account unique number of the derivative account. The account subject stores one of ordinary account subjects representing trade payables, such as accounts receivables and accounts payable, in the case of a purchaser in accordance with the transaction segment, and one of the normal account subjects representing trade receivables, such as accounts receivables and receivables, in the case of a customer. In the case of a bank account, it stores one of the normal account subjects representing the deposit such as ordinary deposit, periodic deposit, and savings.In the case of a sales card, it stores one of the common account subjects representing the receivables such as card receivables and receivables. In the case of a card, one of the normal account subjects representing unpaid payments, such as unpaid card and unpaid payment, is stored.In the case of a paper note, one of the normal account subjects showing the notes receivable, such as a paper note, is stored. Stores one of the common accounting subjects of notes payable. The purchase subject of the account table 211 stores one of ordinary account subjects representing asset subjects or expense subjects, such as operating expenses, products, products, securities, entertainment, interest expenses, etc. . The sales subject of the account table 211 preferably stores one of ordinary account subjects representing profit subjects used in accounting for sales such as sales sales, merchandise sales, and interest income according to the accounts.

In addition, the item table 212 is preferably characterized in that it contains the item unique number, item name, item classification, accounting subjects, cost subjects, sales subjects, etc. which are various objects applied to various accounting processes. In addition, the item classification preferably includes one of the item classification list.

In addition, the transaction information table 230 includes transaction information (transaction unique number, entry and exit, transaction date, account, document type, payment method, payment method, account subject, management item, etc.) which are various objects applied to various accounting processes. File). The entry / exit division preferably includes one of the entry / exit division lists. The payment method preferably includes one of the payment method list. The account preferably includes one of the accounts stored in the account table 211. The payment means may include one of the accounts stored in the account table 211, or one of the items of the items stored in the item table 212 is an account subject. The account subject of the transaction information table 230 preferably includes one of the items classified among the items stored in the item table 212 is an account subject. Preferably, the management item includes one of items stored in the item table 212.

In addition, the management information table 240 includes management information including a management unique number, a management item, a quantity, a unit price, an amount, an account subject, and a transaction unique number of the transaction information table 230, which are various objects applied to various accounting processes. It is preferable to save the (management file). The management item preferably includes one of items stored in the item table 212. The accounting subject preferably includes one of the item classification among the items stored in the item table 212.

In addition, the accounting information table 250 includes a unique number, a customer, a management item, an account subject, an amount, a transaction unique number of the transaction information table 230, and the management information table 240 which are various objects applied to various accounting processes. It is preferable to store the journal information (journal file) including the management unique number and the like. The account preferably includes one of the accounts stored in the account table 211. The management item preferably includes one of items stored in the item table 212. The accounting subject preferably includes one of the item classification among the items stored in the item table 212.

In addition, the amount is preferably divided into a debit amount, a credit amount, and the like.

In addition, the management information table 240 and the accounting information table 250 having a one-to-many relationship with the transaction information table 230 store a transaction unique number of the transaction information table 230 and the management information table 240. The accounting information table 250 having a one-to-many relationship may further store and maintain a management unique number of the management information table 240.

Next, the accounting processing method by the system having the above configuration will be described in detail with reference to FIGS. 3 to 4.

As shown in FIG. 3, the accounting processing method according to the first embodiment includes receiving transaction information including a customer keyword using a predetermined input means (S110); Searching for data matching the provided keyword and extracting the retrieved data (S120); Automatically generating management information on the transaction information (S130); Storing the transaction information and management information (S140); Combining the transaction information and management information is configured to store the automatic journal processing and automatic journal processing results (S150).

First, when a predetermined input signal including the entry / exit division is received by the control unit 110 through the input device 400, the control unit 110 provides the entry / exit classification information to the transaction processing unit 130. At this time, the entry and exit information is preferably included one of the entry and exit classification list.

Subsequently, the transaction processing unit 130 sorts the items classified by various objects that are applied to various accounting processes, such as account unique number, entrance and exit classification, transaction date, customer, transaction summary, payment method, payment method, account subject, amount, and management items. Create a transaction file provided. At this time, a transaction unique number is assigned to the transaction file, and the received entry / exit information is recorded as an entry / exit entry of the transaction file. If the entry / exit division is a deposit or withdrawal in the entry / exit division list, the cash of the payment method list is recorded in the payment method of the transaction file, and in the item table 212 in the data extraction unit 120 through the control unit 110. Extract the cash of the account subject (item file) and then provide it to the transaction processing unit (130). The transaction processor 130 records an account subject, which is one of the objects provided by the provided item file, in the payment means and the account subject of the transaction file. The transaction processor 130 provides the transaction file to the design processor 160 through the controller 110.

Subsequently, the design processing unit 160 includes various objects that are applied to various types of accounting processing for the user to input transaction information including keywords such as entry / exit division, transaction date, customer, transaction summary, payment method, payment method, account subject, amount, A space (design object) is provided to provide items classified by management items, and then the object of the transaction file provided above is connected to the design object. The design processor 160 provides the design object to the display apparatus 500 through the controller 110, and when predetermined data is input, the design processor 160 provides the input data to the controller 110 (S110). In this case, it is preferable that the account subject among the design objects is not displayed on the display device 500.

And when the deposit and withdrawal classification is the deposit or withdrawal in the entry and exit classification list, the payment method provided by the transaction processing unit 130 is provided in cash in the list of payment methods as described above, but provides a payment method and an account subject accordingly, If desired by the user, it is desirable to be able to change to another payment method and payment method, and then to apply the same to the transaction information that continues to be input. When predetermined data, which is one of the payment method lists, is received from the input device 400 by the controller 110, the controller 110 provides the provided payment method to the transaction processing unit 130 as a payment method of the transaction file. Record it. In addition, the payment means is characterized in that it usually has a delimiter such as bank account, sales card, purchase card, bill received, pay bill, etc., the signal to change the payment method with a predetermined keyword from the input device 400 When received by the controller 110, the controller 110 provides the predetermined keyword to the data extractor 120, and the data extractor 120 compares the keyword with data stored in the account table 211 to input the keyword. Extract data (payment means file) matching the keyword. In this case, it is preferable that the keyword includes a trading partner name. The data extractor 120 provides the extracted data to the controller 110. Subsequently, if the provided payment means file does not exist, the controller 110 displays a signal indicating that the payment means file does not exist, allows the user to newly register separately, and repeats or terminates the above procedure. In addition, the control unit 110 provides the payment means file to the transaction processing unit 130, if there is the provided payment means file, and records the name of the transaction provided by the payment means file as the payment means of the transaction file, payment means The account subject provided by the file is recorded as the account subject of the transaction file.

On the other hand, if the control unit 110 receives a predetermined signal from the input device 400 that the user pastes the transaction information including the keyword, the control unit 110 goes through a predetermined procedure in the temporary storage place of the central processing unit 100. After the transaction information data to be pasted is found, the found data is provided to the design processor 160.

In addition, the design processing unit 160 confirms whether the structure of the provided pasted data matches the predetermined desired structure. The required data structure should be in the form of an intersection of rows and columns in the same form as a normal data table structure, and a title that can be matched with the design object generated by the design processor 160 at the top of the provided data. Should be there.

In addition, the design processing unit 160 checks whether all the necessary information is present in the data structure of the pasted data provided. The essential information should include at least a trading date, a customer used as a keyword, and an amount of money. The checking method checks whether the title of the topmost end of the provided data and the name of the design object are the same. If the essential information is missing, the control unit 110 provides a signal indicating that the essential information is missing, and the control unit 110 displays a message indicating that the essential information is missing to the display apparatus 500 to the user, and displays the title of the design object at the top of the provided data. Make the same modifications as above, and then repeat or terminate the above procedure. If there is no problem with the pasted data, if the pasted data is recorded in the same space as the title of the provided data and the name of the design object, the pasted data is automatically recorded in the object of the transaction file connected to the design object. The design processor 160 provides the keyword to the controller 110 (S110).

The controller 110 provides the predetermined keyword provided by the design processor 160 to the data extractor 120, and the data extractor 120 compares the keyword with data stored in the account table 211. Extract data that matches the entered keyword. The data extracting unit 120 provides the extracted data to the control unit 110 (S120).

The controller 110 searches for an account file corresponding to the keyword in the unsaved account file when there is no already stored account file if there is no extracted data provided above, and matches the keyword. Extract the account file. If the extracted account file does not exist, it is divided into various objects that are applied to various accounting processes, such as account unique number, account name, account classification, proof type, payment method, original account unique number, account subject, purchase subject, and sales subject. Create a new account file that provides the item, give the account unique number, and record the account unique number as the original account unique number. The keyword is recorded in the account name of the generated account file (S122), and if the entry / exit segment is a purchase or withdrawal in the account segment of the generated account file, the purchase destination is one of the list of account classifiers; If the division is sales or deposits, record the sales source which is one of the trading partner classification lists (S123). In addition, after providing the transaction segment to the data extraction unit 120 to extract the data corresponding to the transaction segment in the basic mapping table 213, and the account subject, purchase subject, sales subject of the extracted data The generated account file is recorded (S124).

Subsequently, the controller 110 provides the extracted or newly generated trading partner file to the transaction processing unit 130.

Subsequently, the transaction processing unit 130 records the evidence type and payment method in the extracted trading partner file provided when the entry / exit division is a purchase or sale in the entry / exit classification list in the transaction file. If the payment method is a credit in the payment method list, the account subject of the extracted account file is recorded as a payment method and an account subject of the transaction file. In addition, if the deposit and withdrawal category is deposit or withdrawal, record the account subject of the extracted account file as a management item of the transaction file. If the deposit and withdrawal category is purchase, the purchase subject of the extracted account file is used as the management item of the transaction file. If the entry / exit division is sales, the sales subject of the extracted account file is recorded as a management item of the transaction file. The above management item is used to automatically generate a management file (S125).

Subsequently, the transaction processing unit 130 provides the transaction file to the control unit 110, and the control unit 110 provides the provided transaction file to the management processing unit 140 and instructs the management file generation (S120).

Subsequently, the management processing unit 140 provides the first management file that provides items classified by various objects, which are applied to various accounting processes, such as management unique number, management item, account subject, quantity, unit price, transaction summary, amount, and transaction unique number. Create At this time, the management unique number is assigned to the management file, and the transaction unique number of the provided transaction file is recorded in the transaction unique number of the management file. In addition, the management items of the transaction file received are recorded as the management items of the management file. The management unique number of the management item is provided to the data extraction unit 120 through the control unit 110, and the data extraction unit 120 compares the management unique number of the management item with the data stored in the item table 211. Extract data corresponding to the management unique number of the management item. The data extracting unit 120 provides the extracted data (item file) to the management processing unit 140 through the control unit 110. The management processor 140 records the management items of the transaction file in the account subject of the management file when the item classification of the item file is an account subject in the item classification list. In addition, when the item classification of the item file is a management item in the item classification list, the account subject of the provided item file is recorded in the account subject of the management file. In addition, when the item classification of the item file is a stock item name in the item classification list, when the entry and exit of the transaction file is a purchase in the entry and exit list, the purchase subject of the item file is entered. The sales subject is recorded as the account subject of the management file, respectively (S130).

Here, it will be apparent to those skilled in the art that the user may modify the management file initially generated in the automatic generation of the management information (S130) or additionally generate the management file and input predetermined data.

Next, when a predetermined signal for storing through the input device 400 is received by the controller 110, the controller 110 stores the transaction file generated by the transaction processor 130 in the transaction information table 230. The management file generated by the management processor 140 is stored in the management information table 240. If the account file generated by the controller 110 exists, the account file is stored in the account table 211.

Subsequently, the controller 110 provides the transaction unique number of the stored transaction file to the journal processing unit 150 and instructs automatic journaling (S140).

Journal entry processing unit 150 extracts data corresponding to the provided transaction unique number from the transaction information table 230 (transaction file), and the transaction unique number and the transaction unique number stored in the management information table 240 match with each other. Extract data from the management information table 240 (management file), and extract data from the accounting information table 250 in which the transaction unique number and the transaction unique number stored in the accounting information table 250 coincide with each other (journal file). Then, by combining the information of the extracted transaction file and the management file, the normal journal information by debit, credit, and the extracted journal file, if there is a journal file matching a predetermined keyword in the extracted journal file It is preferable to modify the journal information and generate a journal file and store it when there is no journal file matching the predetermined keyword. The journal file includes a unique number, a customer, a transaction date, a management item, an account subject, a debit amount, a credit amount, and a transaction unique number of the transaction information table 230, the management information table 240 It is preferable to provide journal entry information including a management unique number of a) and a predetermined keyword for searching for a journal entry file. In addition, it is preferable to delete the journal file which is no longer needed from the extracted journal file.

On the other hand, it is preferable that the amount of information provided by the management file be further divided into supply value, tax, and foreign exchange gain and loss.

The following describes a specific process of creating or modifying a journal file for each transaction unique number of the extracted transaction file and for each management file connected to the transaction unique number.

Journal entry processing unit 150 searches for a journal file matching the transaction unique number and a predetermined keyword among the extracted journal file if the entry and exit of the transaction file is the deposit or sales of the entry and exit classification list, and matches the search condition Extract the journal file. If there is no extracted journal file (transaction journal file), a journal file (transaction journal file) for the transaction file is generated as above and assigned a unique number. In addition, it is preferable to record the transaction unique number of the transaction file as the transaction unique number and the management unique number of the transaction journal file. In addition, it is preferable to record the account subject of the transaction file as the account subject of the transaction journal file. In addition, it is preferable to record the sum of the amounts of the management files corresponding to the transaction unique number of the transaction file in the debit amount of the transaction journal file. In addition, if the payment means of the transaction file is recorded as the trading partner of the transaction journal file, and if the payment method of the transaction file is one of the items stored in the item table 212, the trading partner of the transaction file to the trading partner of the transaction journal file. It is desirable to record. In addition, it is preferable to record the account subject of the transaction file as a management item of the transaction journal file.

Subsequently, a journal file matching the management unique number and a predetermined keyword of the management file is searched among the extracted journal files for each management file, and a journal file matching the search condition is extracted. If there is no extracted journal file (management journal file), a journal file (management journal file) for the management file is generated as above and assigned a unique number. Preferably, the transaction unique number of the transaction file is recorded as the transaction unique number of the management journal file, and the management unique number of the management file is recorded as the management unique number of the management journal file. It is preferable to record the account subject of the management file as the account subject of the management journal file. In addition, it is preferable to record a trading partner of the transaction file as a trading partner of the management journal file, and record a management item of the management file as a management item of the management journal file. When the amount of the management file and the amount of the transaction file are both positive or negative, that is, when the signs of the two amounts are the same, the amount of the management file is recorded as the credit amount of the management journal file. If the amount of money is different, it is preferable to record the amount of money of the management file as the debit amount of the management journal file. In addition, when the amount information of the management file is provided by subdividing the supply value, VAT, etc., it is preferable to further generate a journal file for each of the subdivided amounts such as the supply value, VAT. That is, it is preferable that a management file matching the transaction number generates a journal file for each of the management files and further creates a management file for each subdivided amount when the amount information provided by each management file is subdivided.

On the other hand, the journal entry processing unit 150 searches for a journal file matching the transaction unique number and a predetermined keyword in the extracted journal file when the entry and exit of the transaction file is withdrawal or purchase from the entry and exit classification list, and the search condition Extract journal files matching. If there is no extracted journal file (transaction journal file), a journal file (transaction journal file) for the transaction file is generated as above and assigned a unique number. In addition, it is preferable to record the transaction unique number of the transaction file as the transaction unique number and the management unique number of the transaction journal file. In addition, it is preferable to record the account subject of the transaction file as the account subject of the transaction journal file. In addition, it is preferable to record the sum of the amounts of the management files corresponding to the transaction unique number of the transaction file in the credit amount of the transaction journal file. In addition, if the payment means of the transaction file is recorded as the trading partner of the transaction journal file, and if the payment method of the transaction file is one of the items stored in the item table 212, the trading partner of the transaction file to the trading partner of the transaction journal file. It is desirable to record. In addition, it is preferable to record the account subject of the transaction file as a management item of the transaction journal file.

Subsequently, a journal file matching the management unique number and a predetermined keyword of the management file is searched among the extracted journal files for each management file, and a journal file matching the search condition is extracted. If there is no extracted journal file (management journal file), a journal file (management journal file) for the management file is generated as above and assigned a unique number. Preferably, the transaction unique number of the transaction file is recorded as the transaction unique number of the management journal file, and the management unique number of the management file is recorded as the management unique number of the management journal file. It is preferable to record the account subject of the management file as the account subject of the management journal file. In addition, it is preferable to record a trading partner of the transaction file as a trading partner of the management journal file, and record a management item of the management file as a management item of the management journal file. If the amount of the management file and the amount of the transaction file are both positive or negative, i.e., if the signs of the two amounts are the same, the amount of the management file is recorded as the debit amount of the management journal file. If the sign of the amount is different, it is preferable to record the amount of the management file as the credit amount of the management journal file. In addition, when the amount information of the management file is provided by subdividing the supply value, VAT, etc., it is preferable to further generate a journal file for each of the subdivided amounts such as the supply value, VAT. That is, it is preferable that a management file matching the transaction number generates a journal file for each of the management files and further creates a management file for each subdivided amount when the amount information provided by each management file is subdivided.

The accounting method and system according to the preferred embodiment of the present invention has been described in detail with reference to the accompanying drawings. However, one of ordinary skill in the art will recognize that various modifications and variations of the present embodiment are possible. Therefore, the scope of the present invention is limited only by the claims set forth below.

1 is a block diagram showing the configuration of an accounting processing system according to a first embodiment of the present invention.

       FIG. 2 is a block diagram illustrating in detail the configuration of the DB 200 shown in FIG. 1.

       3 is a flowchart schematically showing an accounting processing method according to the present invention.

4 is a flowchart for explaining in detail the step S120 shown in FIG.

Claims (7)

In the accounting system comprising an input device, a display device, a database (DB) and a central processing unit, The database, A transaction information table configured to store a transaction unique number, an entrance / exit classification, a transaction date, a customer, an evidence type, a payment method, a payment method, an account subject, and a management item; A management information table configured to store a management unique number, a management item, a quantity, a unit price, an amount, an account subject, and the transaction unique number; An accounting information table configured to store an account, a management item, an account subject, an amount, the transaction unique number, and a management unique number; An account table that stores an account unique number, an account name, an account classification, an evidence type, a payment method, an original account unique number, an account subject, a purchased subject, and a sales subject; A configured item table in which item name, item classification, account subject, cost subject, and sales subject are stored; And Basic mapping table that stores account segment, account subject, purchase subject, sales subject; The central processing unit, A design processing unit which generates an input screen so that a user can input transaction information through the input device, and provides an input screen generated through the display device; A transaction processing unit which receives the transaction information through the design processing unit, generates a corresponding transaction unique number, and stores the generated transaction unique number and the input transaction information in the transaction information table of the DB; A data extracting unit extracting data corresponding to the same from the inputted transaction information by using a customer, an account subject, and a management item in an account table, an item table, and a basic mapping table of the DB; Receive the data extracted through the data extraction unit and generate each management unique number corresponding to the data, and the generated management unique number and the data received through the data extraction unit in the management information table of the DB and the transaction unique number A management processor that stores the matching; A journal entry processing unit for automatically generating a journal slip by combining data stored in the transaction information table and the management information table and storing the journal slip in an accounting information table of the DB; And Receives transaction information according to the pasting function of the input device from the user through the design processing unit, stores the transaction information received through the transaction processing unit in the transaction information table, transaction information through the data extraction unit and the management processing unit A control unit for generating a plurality of management information according to the present invention and storing the same in a management information table, and automatically generating a journal slip by combining data stored in the transaction information table and the management information table using the journal processing unit; Consists of including The design processing unit of the central processing unit, When the user inputs the transaction information through the input device, the transaction information including the entry / exit division, the transaction date, the customer, the transaction summary, the payment method, the payment method, the account subject, the amount, and the management items is pasted at once. By creating an input screen in the form of a table structure where rows and columns intersect so that they can be entered through input, and providing an input screen generated through the display device, the user pastes one transaction without inputting all the transaction information individually. An accounting processing system capable of inputting by pasting, characterized in that the transaction information can be collectively input through a simple inputting process. delete delete The method of claim 1, The deposit and withdrawal is any one of deposit, withdrawal, purchase and sales, The payment method includes any one of cash, bankbook, card, bill, credit and substitute, The account segment includes any one of a purchaser, a customer, a bank account, a sales card, a purchase card, a paper bill and a paper bill, Wherein the item classification is accounting processing system that can be input by pasting, characterized in that any one of the subject, inventory item name and management items. In the accounting processing method using an accounting processing system comprising an input device, a display device, a database (DB) and a central processing unit, Generating an input screen for a user to input transaction information through the input device, and receiving transaction information accordingly; Re-input of the essential information by outputting a message requesting re-entry to the user when the essential information including the transaction date, the trading partner, and the price information is missing from the received transaction information; Generating a transaction unique number according to the received transaction information; Extracting data corresponding to the input transaction information from a DB to generate management information corresponding to the transaction information; If there is no corresponding account among the inputted transaction information in the DB, a new account composed of the account name, account classification, proof type, payment method, original account number, account subject, purchase subject and sales subject in the DB. Automatically generating information and assigning a corresponding account unique number; Combining the transaction information and the management information to automatically process journal entries and outputting the results through a display device; Consists of including Receiving the transaction information, When the user inputs the transaction information through the input device, the transaction information including the entry / exit division, the transaction date, the customer, the transaction summary, the payment method, the payment method, the account subject, the amount, and the management items is pasted at once. By creating an input screen in the form of a table structure where rows and columns intersect so that they can be entered through input, and providing an input screen generated through the display device, the user pastes one transaction without inputting all the transaction information individually. An accounting processing method capable of inputting by pasting, characterized in that the transaction information can be collectively input through a simple input process through putting. delete The method of claim 5, In the step of automatically generating the new account information, and assigning the corresponding account unique number, Record the assigned trading partner unique number as the original trading partner unique number, the trading partner according to the received transaction information in the trading partner name, and the trading partner classification, if the entry and exit of the input transaction information is the purchase or withdrawal, the purchaser, sales or depositor In the case of accounting by pasting, the accounting can be entered by pasting, characterized in that the data corresponding to the accounting section is retrieved from the DB, and accounting, purchasing, and sales are recorded in the newly created accounting information. Treatment method.

Images