KR101270492B1 - System and method for managing sales and uncollected amount - Google Patents

Abstract

A sales and receivable management system and method are disclosed. The sales and receivable management system for efficiently managing sales and receivables by interconnecting bankbook information and tax invoice information includes a tax invoice database, bank account database, account information generation unit, business number input unit, and account information integration unit. The tax invoice database stores tax invoice information issued to a customer, and the bankbook database stores bankbook information indicating details of deposit and withdrawal transactions for preset account numbers received from a plurality of bank servers. In addition, the account information generation unit generates account information in accordance with a preset form using the bankbook information and the pre-stored tax invoice information, and the business number input unit is a business number corresponding to the account information of the account information to the account information The account information integration unit integrates the bankbook information and the tax invoice information using at least one of a business number and a client name. This configuration can reduce the time spent on sales and accounts receivables, reduce errors such as data omission or data duplication, and ensure accurate data, and easily issue tax invoices and accruals from accurate data. It can be identified immediately, allowing the user to take the corresponding action.

Description

System and method for managing sales and uncollected amount}

The present invention relates to a sales and receivable management system and method, and more particularly, to a system and method for providing a service for efficiently managing sales and receivables by interconnecting bankbook information and tax invoice information.

In the case of a transaction of most business services or services, when the contract is concluded, the contract is paid first, the balance is settled, the balance is settled, the tax invoice is issued, and the tax invoice is issued first. The main case is payment.

According to the recently announced national policy, these tax invoices are optional from 2010, and from 2011 all corporations are obliged to send them in the form of electronic tax invoices to the IRS. It's going on.

In other words, the tax invoice issued by hand should be changed to an electronic tax invoice in the future, but small and medium companies such as shopping malls, retail and retail distribution, and knowledge transfer service industry are not easy to issue the tax invoice as electronic tax invoice. The sales tax invoice is issued.

In addition, it is not easy to manage sales tax invoices and deposit and withdrawal accounts automatically at once, so most of them are managed manually.

However, if you manually issue tax invoices and manage your tax invoices and bank accounts, you can spend a lot of time managing them, and there is a high probability of missing or overlapping data. There is a problem that a loss of trust from a customer occurs.

Therefore, there is a need for a system that can easily issue an electronic tax invoice according to the policy, and can be easily managed by linking the tax invoice with the bank account management.

The present invention has been made to solve such a conventional problem, to reduce the time spent for sales and accounts receivable management, to ensure accurate data by reducing mistakes such as data missing or data duplication, and to easily tax from accurate data The purpose is to immediately identify the issue of the bill and the occurrence of the failure so that the user can take the corresponding action.

In order to achieve the above object, the sales and accounts receivable management system according to the present invention includes a tax invoice database, bank account database, account information generation unit, business number input unit, and account information integration unit.

The tax invoice database stores tax invoice information issued to a customer, and the bankbook database stores bankbook information indicating details of deposit and withdrawal transactions for preset account numbers received from a plurality of bank servers.

In addition, the account information generation unit generates account information in accordance with a preset form using the bankbook information and the pre-stored tax invoice information, and the business number input unit is a business number corresponding to the account information of the account information to the account information The account information integration unit integrates the bankbook information and the tax invoice information using at least one of a business number and a client name.

This configuration can reduce the time spent on sales and accounts receivables, reduce errors such as data omission or data duplication, and ensure accurate data, and easily issue tax invoices and accruals from accurate data. It can be identified immediately, allowing the user to take the corresponding action.

The business number input unit may search for and display account information corresponding to the client name in the account information, and then input the business number of the account information selected by the user to the account information corresponding to the client name. Alternatively, if it is not the representative name, an additional item may input a business name corresponding to the client name.

In addition, the account information integration unit retrieves and displays the tax invoice information corresponding to at least one of the business number and the client name of the account information selected by the user, the account information selected from the user to the tax invoice number of the tax invoice information selected by the user By entering in, you can integrate bankbook information and tax invoice information.

In addition, the sales and accounts receivable management system according to the present invention may further include an account information output unit for outputting the account information according to the output conditions set by the user.

In addition, the sales and receivables management system according to the present invention may further include a tax invoice issuing unit for issuing a tax invoice with a client name corresponding to the client name of the account information is not entered tax invoice number.

In addition, the sales and accounts receivable management system according to the present invention may further include an attempted information transmission unit for transmitting the unreceived information to the contact means corresponding to the client name of the account information for which the deposit amount is not input.

In addition, an invention is disclosed in which the system is implemented in the form of a method.

In the sales and receivables management method according to the present invention, the tax invoice information issued to the customer is stored in step (a), and the bankbook information indicating the deposit and withdrawal transaction details for the predetermined account numbers received from the plurality of bank servers is stored (b). Step (c) of generating account information according to a preset form using the step, the bankbook information and the pre-stored tax invoice information, and the business number corresponding to the account information of the account information is entered in the account information ( d) and (e) integrating the bankbook information and the tax invoice information using at least one of a business number and a client name.

In this case, in step (d), after the account information corresponding to the client name is searched and displayed in the account information, the business number of the account information selected by the user may be input to the account information corresponding to the client name.

In addition, the sales and receivables management method according to the present invention may further include a step of inputting a business name corresponding to the client name as an additional item between (d) and (e) if the client name is not a business name or representative name. Can be.

In this case, in step (e), after the tax invoice information corresponding to at least one of the business number and the client name of the account information selected by the user is searched and displayed, the tax invoice number of the tax invoice information selected by the user is selected by the user. Entered into the information, the bankbook information and tax invoice information can be integrated.

After step (e), the method may further include step (f) of outputting account information according to an output condition set by a user.

In addition, after step (f), the method may further include the step (g) of issuing a tax invoice with a client name corresponding to the client name of the account information for which the tax invoice number is not input.

In addition, after step (f), the method may further include step (h) of transmitting the non-acquisition information to the contact means corresponding to the client name of the account information for which the deposit amount is not input.

According to the present invention, it is possible to reduce the time spent for sales and accounts receivable management by linking bank account information and tax invoice information, and to secure accurate data by reducing mistakes such as data omission or data duplication, and accounting from accurate data. The details and the occurrence of the failure can be immediately identified, allowing the user to take the corresponding action.

In addition, the electronic tax invoice can be easily issued with a simple operation.

In addition, no separate work is required for debt management, and the information of the bank account can be primarily resented.

1 is a block diagram schematically showing an embodiment of a sales and receivables management system configuration according to the present invention.
Figure 2 is a flow chart showing an embodiment of the sales and receivables management method according to the present invention.
3 is a diagram illustrating an embodiment in which a business number is input from account information.
4 is a diagram illustrating an embodiment in which a tax invoice number is input into account information and thus account information is integrated.
5 is a view showing account information in which bankbook information and tax invoice information are integrated.
6 illustrates an embodiment of the receivables management window.

Hereinafter, preferred embodiments of the present invention will be described with reference to the accompanying drawings. In order to make the understanding of the invention clearer, the same reference numerals are used for the same components in different drawings.

Figure 1 is a block diagram schematically showing an embodiment of the sales and receivables management system configuration according to the present invention.

Revenue and receivable management system for providing a service to efficiently manage sales and receivables by interconnecting the bankbook information and tax invoice information according to the present invention, the account information generation unit 100, business number input unit 110, account Information integration unit 120, account information output unit 200, bank account database 310, tax invoice database 320, account database 330, account database 340, tax invoice issuing unit 400, unpaid information It includes a transmitter 500.

The bankbook database 310 stores bankbook information indicating deposit and withdrawal transaction details for a predetermined account number received from the plurality of bank servers 10.

That is, the bank account information may include the name of the client (bank name), transaction date, dealer, deposit amount, withdrawal amount, account balance, and the bank account information may vary depending on the bank.

The tax invoice database 320 stores the issued tax invoice information. The tax invoice information includes tax invoice number, issuer information (trade name, business address, business status, business number, representative name, etc.), and part of the customer information (trade name, business place). Address, business type, business number, representative name, etc.), issue date, supply price, and tax amount.

The account database 330 stores information about a user's account. The account information may include a business name, a business address, a business number, a business status, a representative name, a contact information, an e-mail address, a fax number, a name of an accountant, and the like.

The account database 340 stores account information generated by the account information generator 100.

The account information generating unit 100 generates account information according to a preset form using the bankbook information stored in the bankbook database 310 and the tax bill information stored in the tax invoice database 320.

In this case, the account information refers to information in which bankbook information and tax invoice information are integrated and linked.

Therefore, even if the form of the bank account information received from the plurality of bank server 10 varies depending on the bank, only the data corresponding to the preset account information form is extracted from the bank account information and tax invoice information and reconstructed into one unified form. can do.

The form of account information includes items of bank account information (receiver name, transaction date, dealer, deposit amount, withdrawal amount, account balance, etc.), as well as items of tax invoice information (tax invoice number, account name, vendor business number, supply value, etc.). ), Accounting divisions, and additional items.

Among the account information forms (items) are items that are common to the bank account information and tax invoice information (eg, client name (account name), amount (supply value, tax), etc.). In this case, it may be determined that the corresponding bank account information and the tax invoice information correspond to each other and may be integrated into one account information.

However, before merging into one account information, the result of comparing common items may be displayed to the user, and after merging by the user, the merging may be performed.

The business number may be input from the customer information stored in the account database 330, and the tax invoice number may be input from the tax invoice information stored in the tax invoice database 320.

The generated account information may include both account information and tax invoice information, or account information in which only the account information or tax invoice information is input.

Account information in which both the bank account information and the tax invoice information are input is associated with deposit details corresponding to the issued tax invoice, and thus may be useful for managing sales.

The account information, which contains only the bank account information, may be useful for determining whether the tax invoice is issued because the amount of money is first deposited from the client before the tax invoice is issued.

Account information containing only the tax invoice information may be useful for managing accounts receivable since the tax invoice is issued, but the amount is not received from the customer.

The business number input unit 110 may search for the account information corresponding to the client name in the account information, and then input the business number of the customer information selected from the user into the account information corresponding to the client name.

The client's name may be one of the business name, representative name, or other name of the depositor (eg, accountant's name).

When the client name of the account information is selected by the user, the business number input unit 110 searches for the client name or the business number of the customer input from the user in the search field of the pop-up window that is generated, and lists the account information for the corresponding customer (the same account name). There may be multiple accounts with).

If the customer information corresponding to the account information is selected from the listed customer information, the business number of the customer included in the customer information is input to the account information.

In this case, when the client name is not a business name or a representative name, a business name corresponding to the client name may be input as an additional item.

In the additional item, a memo other than the business name may be input from the user.

The account information generator 100 updates the account database 330 by storing the additionally input information in the account information of the account database 330.

The account information integration unit 120 retrieves the tax invoice information corresponding to the client name and the business number from the bankbook information and displays it to the user, and then displays the tax invoice number of the tax invoice information selected by the user corresponding to the client name or the business number. By entering in the account information, the account information can be integrated and the bankbook information and the tax invoice information can be linked.

When the tax invoice number space of the account information is selected by the user, the account information integrator 120 searches the client name or the business number of the client input from the user in the pop-up window that is generated and lists the tax invoice information issued to the corresponding customer. (There may be multiple tax invoices issued to one account).

If the tax invoice information corresponding to the account information is selected from the user among the listed tax invoice information, the tax invoice number included in the tax invoice information is input to the account information.

In this case, when the client name and the client name coincide with each other and the bill amount and the deposit amount coincide with each other, the client may directly input and integrate the tax invoice information without listing the tax invoice information.

The account information output unit 200 outputs account information according to an output condition set by a user.

The output conditions set by the user may be a condition (eg, sorted by date, sorted by bank, sorted by client name, etc.), or a condition of selecting an item to be outputted (e.g., sorted by date). , The date, the name of the client, and the wage amount only), the condition to output only the sales, the condition to output only account information corresponding to the receivables, and the condition to output only the account information that has not been issued a tax invoice.

The tax invoice issuing unit 400 may issue a tax invoice with a client name corresponding to the client name of the account information for which the tax invoice number is not input.

As described above, the account information for which the tax invoice number is not input may be the case where the customer first deposits the tax invoice before the user issues the tax invoice to the customer.

In this case, there is no tax invoice information, but you can enter a business number from the name of the deposited client, and if the business number in the account information is selected by the user, go to the Tax Invoice Issuance page and issue a tax invoice corresponding to the selected business number. Can be.

The unacknowledged information transmitting unit 500 may transmit the unacknowledged information to the contact means corresponding to the client name of the account information for which the deposit amount is not input.

As described above, account information for which no deposit amount is input (if no deposit amount is input is equivalent to no account information) may be a case where a user has issued a tax invoice to a customer but a deposit is not made due to the deposit.

In this case, since the tax invoice information exists, it is possible to send the information to the account contact (cell phone number), email address, etc. included in the tax invoice information.

Due to the structure of the sales and receivables management system, time spent for sales and receivables management can be reduced, and accurate data can be obtained by reducing mistakes such as data loss or data duplication. It is possible to immediately identify the occurrence of the attempt, so that the user can take the corresponding action.

2 is a flowchart illustrating an embodiment of a sales and receivable management method according to the present invention.

The tax invoice information issued from the user to the customer is stored to build a tax invoice database 320, and the account information for trading with the user is stored to build a customer database 330 (S100).

In addition, the bankbook database 310 may store bankbook information for a predetermined account number that is received directly from the plurality of bank servers 10 or uploaded by the user in a predetermined file format from the bank server 10. It is built (S200).

Step S100 and step S200 may be performed in any order.

Next, since the bankbook information stored in the bankbook database 310 has a separate form for each bank, account information is generated according to a predetermined account information form using the bankbook information and the tax invoice information (S310).

In the embodiment of the present invention, only the date (transaction date), the client name (same as the name of the client, the name of the depositor), the dealer, the bank name, the deposit amount, the withdrawal amount, and the balance of the account are extracted and used.

In addition, the tax invoice information is also used to extract the amount (supply value, tax amount), account name, account operator number, tax invoice number.

If the information extracted from the bank account information and the tax invoice information, respectively, the information on the items common in the account information (for example, the client name (account name) and the deposit amount (supply price, tax amount)) is the same, The tax invoice information may be determined to correspond to each other and may be integrated into one account information.

In this case, information corresponding to each item of the extracted bankbook information and tax invoice information may be input into a predetermined account information form (item) column to be integrated into one account information.

If there is no matching information for common items among the information extracted from the bankbook information and the tax invoice information (for example, there is no tax invoice information corresponding to the bankbook information, or the bankbook information corresponding to the tax invoice information is If no account is created), the account information will be maintained without any consolidation.

On the other hand, if the information on a common item is different despite the same case (for example, if the client name is the representative name in the bank account information and the business name in the tax invoice information), the account includes only the account information and the tax invoice information. Each piece of information is generated.

3 is a view illustrating an embodiment in which a business number is input from account information. Referring to FIG. 3, as described above, a client name (bank name) included in the bank account information is included in the tax invoice information. Alternatively, it can be seen that there is account information (account information consisting only of bank account information) in which the business number (business NO) and tax invoice number (sales NO) are blank because they do not match the representative name.

In order to consolidate each of these account information into one, it is necessary to compare whether the account number and the tax invoice number of each account information are the same.

First, it is compared whether the business numbers are the same. Account information consisting only of tax invoice information includes business number, but account information consisting only of bank account information does not include business number. The operator number is input in the same manner as in step S320.

(If the client name is an account name or a representative name in the account information consisting only of the account information, if the account information corresponding to the client name is stored in the account database 330, the corresponding business number may be automatically input. S320).)

Referring to FIG. 3, when a client name of account information for inputting a business number from a user is selected (①), a pop-up window appears.

If at least one of a client name (trade name (trade name), representative (account representative name), etc.), or operator NO (business number of the client) of the account information input from the user is entered as a keyword in the search field of the pop-up window, the keyword is entered. The account information corresponding to is searched (2), and the searched account information is listed.

When the customer information corresponding to the account information is selected from the listed customer information, the operator number included in the selected customer information ③ is input to the lower grid of the original window.

If the client name is an accounting manager name other than the business name or representative name, the user may enter the business name corresponding to the client name as an additional item in the grid.

In addition, the user may set the accounting division by selecting a corresponding subject (general sales, salary, card sales, etc.) in the account subjects of the grid.

Then, to consolidate the account information, the tax invoice number is compared to be the same. The account information consisting only of the tax invoice information includes the tax invoice number, but the account information consisting of the account information only does not contain the tax invoice number. Therefore, the tax invoice number is input to the account information consisting of only the account information in the following manner.

4 is a diagram illustrating an embodiment in which tax invoice information is input to account information and thus account information is integrated. Referring to FIG. 4, a blank of a tax invoice number is selected from account information to be input from a user (①. ), A popup window will appear.

If at least one of a client name (trade name (trade name), representative (account representative name), etc.), or operator NO (business number of the client) of the account information input from the user is entered as a keyword in the search field of the pop-up window, the keyword is entered. Tax invoice information corresponding to is retrieved, the retrieved tax invoice information is listed.

If the tax invoice information corresponding to the account information is selected from the user among the tax invoice information listed, the tax invoice number included in the selected tax invoice information (②) is input to the lower grid of the original window.

The business number and tax invoice number of the account information composed only of the account information, entered in the above-described manner, are compared with the business number and tax invoice number of the account information composed only of the tax invoice information, and the account information composed only of the account information in which each number matches. And account information consisting of only the tax invoice information is integrated into one account information is linked (S330).

That is, the information corresponding to each item of the account information consisting only of the tax invoice information is input into the blank item field of the account information consisting only of the bank account information, thereby being integrated into one account information, and the account information consisting of only the tax invoice information is deleted.

When all items are input and the user clicks the save button ④ of the grid, the account information in which the information is integrated is stored in the account database 340, and the business name entered as an additional item is also stored in the account database 330. do.

5 is a diagram illustrating an embodiment of account information in which bankbook information and tax invoice information are integrated.

The account information shows tax invoice information and bank account information at the same time, so that it is easy to determine when and how much money has been deposited, and it is possible to easily identify the difference between the amount of the payment and the amount of the deposit, thereby having the effect of organizing the accounting.

Account information may be output according to the output conditions set by the user (S400). Referring to FIG. 5, since the account information is generated to be sequentially arranged for each item, the account information sequentially sorted by the desired item is output. Can be.

In addition, account information selected only with items desired by the user may be output.

In FIG. 5, it can be seen that the account information in which the bankbook information and the tax invoice information are integrated includes the account information consisting of the bank account information and the tax invoice information, the account information consisting only of the bank account information, and the account information consisting only of the tax invoice information.

In order to issue the tax invoice for the non-issued tax invoice from the account information or to transmit the unpaid information for the receivable, the account information should be checked whether all the information is entered without a blank (S500).

If there is no blank because there is no tax invoice or receivables, it is terminated as it is. If there is a blank, it is checked whether the tax invoice number is entered in the blank (S510).

In the case of account information (account information consisting only of bank account information) without a tax invoice number entered in the blank, it may be the case that the depositor made the deposit first before the user issued the tax invoice to the customer (the tax invoice was not issued). Therefore, the user is moved to the tax invoice issuing page and the tax invoice is issued (S512), and the issued tax invoice information is stored in the tax invoice database 320.

If the tax invoice number is entered in the blank, then it is checked whether the deposit amount is input (S520).

If the deposit amount is entered, the space is closed as it is an accounting item or an additional item.

In the case of account information (tax account information consisting only of tax invoice information) with the tax invoice number entered in the blank and the deposit amount not entered, it will be the case that the user issued a tax invoice to the customer but has not received the deposit (deposit). As a result, the unacknowledged information may be transmitted by the user to an account contact (mobile phone number), an e-mail address, or the like included in the tax invoice information.

6 is a diagram illustrating an embodiment of the receivables management window, and it is easy to check whether the received receivables information is received.

The present invention can also be embodied as computer-readable codes on a computer-readable recording medium. A computer-readable recording medium includes all kinds of recording apparatuses in which data that can be read by a computer system is stored. Examples of the computer-readable recording medium include a ROM, a RAM, a CD-ROM, a magnetic tape, a floppy disk, an optical data storage device, and the like, and may be implemented in the form of a carrier wave (for example, transmission via the Internet) . In addition, the computer-readable recording medium may be distributed over network-connected computer systems so that computer readable codes can be stored and executed in a distributed manner.

So far I looked at the center of the preferred embodiment for the present invention. It will be understood by those skilled in the art that various changes in form and details may be made therein without departing from the spirit and scope of the invention as defined by the appended claims. Therefore, the disclosed embodiments should be considered in an illustrative rather than a restrictive sense. The scope of the present invention is defined by the appended claims rather than by the foregoing description, and all differences within the scope of equivalents thereof should be construed as being included in the present invention.

10 bank server
100 account information generator
110 business number input unit
120 Account Information Integration
200 account information display
310 Bankbook Database
320 Tax Invoice Database
330 Account Database
340 account database
400 Tax Invoice Issuance Department
500 attempts to transmit information

Claims (15)

A sales and receivables management system including a tax invoice database, bank account database, account information generation unit, business number input unit, and account information integration unit,
The tax invoice database for storing information (tax invoice information) on the tax invoices issued to the customer;
The bankbook database storing bankbook information indicating a deposit and withdrawal transaction history for pre-specified account numbers received from a plurality of bank servers;
The account information generation unit generating account information including some or all of the bankbook information and the tax invoice information using the bankbook information and the tax invoice information;
A business number input unit for inputting a business number corresponding to a bank account information item included in the account information into the account information; And
And an account information integrating unit for integrating the bankbook information and the tax invoice information into one account using at least one of the business number and the client name.
The account information integration unit,
After searching and displaying tax invoice information corresponding to at least one of the business number and the client name of the account information selected by the user, and inputting the tax invoice number of the tax invoice information selected by the user into the account information selected by the user Revenue and receivables management system, characterized in that to integrate the bankbook information and the tax invoice information. The method of claim 1,
The business number input unit,
And searching and displaying the account information corresponding to the client name in the bankbook information, and inputting the business number of the account information selected by the user into the account information corresponding to the client name. The method of claim 2,
The business number input unit,
Receiving and receivables management system characterized in that, if the client name is not a business name or a representative name, the business name corresponding to the client name as an additional item. delete The method of claim 1,
An account information output unit which selects the account information from a user and outputs the account information according to a set output condition; Revenue and receivables management system further comprising a. The method of claim 1,
A tax invoice issuing unit for issuing a tax invoice with a client name corresponding to the client name of the account information for which a tax invoice number is not entered; Revenue and receivables management system further comprising a. The method of claim 1,
An unacknowledged information transmission unit which transmits unacknowledged information to a contact means corresponding to the client name of the account information in which the deposit amount is not input; Revenue and receivables management system further comprising a. Revenue and receivables management method performed in the sales and receivables management system,
(a) storing information (tax invoice information) on the tax invoices issued to the customer;
(b) storing bankbook information indicating deposit and withdrawal transaction details for pre-specified account numbers received from a plurality of bank servers;
(c) generating account information including some or all items of the bankbook information and the tax invoice information by using the bankbook information and the tax invoice information;
(d) inputting a business number corresponding to a bank account information item included in the account information into the account information; And
(e) integrating the bankbook information and the tax invoice information into one account using at least one of the business number and the client name; Lt; / RTI >
In the step (e)
After the tax invoice information corresponding to at least one of the business number and the client name of the account information selected by the user is searched and displayed, the tax invoice number of the tax invoice information selected by the user is input to the account information selected by the user, Revenue and receivables management method characterized in that the passbook information and the tax invoice information is integrated. The method of claim 8,
In the step (d)
Receiving and receivables management method characterized in that the account information corresponding to the client name of the bank account information is retrieved and displayed, the business number of the customer information selected by the user is input to the account information corresponding to the client name. The method of claim 9,
Between step (d) and step (e),
If the client name is not a business name or a representative name, inputting a business name corresponding to the client name as an additional item; Revenue and receivables management method further comprising a. delete The method of claim 8,
After the step (e)
(f) outputting the account information according to a set output condition selected by the user; Revenue and receivables management method further comprising a. 13. The method of claim 12,
After the step (f)
(g) issuing a tax invoice with a client name corresponding to the client name of the account information for which the tax invoice number is not entered; Revenue and receivables management method further comprising a. 13. The method of claim 12,
After the step (f)
(h) transmitting unacknowledged information to a contact means corresponding to the client name of the account information for which the deposit amount has not been entered; Revenue and receivables management method further comprising a. 15. A recording medium in which the method for managing sales and accounts receivable according to any one of claims 8 to 10 and 12 to 14 is readable by a computer and recorded in executable program code.

Images