JP7702372B2 - PROGRAM, BILLING MANAGEMENT DEVICE, BILLING MANAGEMENT METHOD, AND SERVER - Google Patents

Description

The present invention relates to a program, a billing management device, a billing management method, and a server.

In commercial transactions, payment is sometimes made by bank transfer. For example, in business-to-business transactions, there is a payment method called deferred payment, in which the seller issues an invoice after a product or service has been provided, and the buyer makes a payment to settle the payment. The payment is made through an institution that transfers funds, such as a bank. As part of its accounting work, the seller matches the billing data with the payment data that corresponds to that billing data, and performs a reconciliation work in which the matched payment data and billing data are treated as data indicating that the billing and payment have been completed.

In commercial transactions, the same seller may issue multiple invoices to the same buyer. The buyer may settle the payment by transferring the total amount of the multiple invoices into the seller's bank account or the like. In such cases, Patent Document 1 shows a data matching program that accurately matches invoice data with deposit data and enables reconciliation processing.

Patent No. 6144812

In the data matching program described in Patent Document 1, consumption tax errors resulting from differences in how the seller and buyer handle consumption tax and fee errors resulting from bank fees and the like are preset. In this program, when matching invoice data with deposit data, an error adjustment process is performed, and if the error is within a preset range, the total invoice amount and the total deposit amount are treated as the same amount and a reconciliation process is performed.

However, even if the consumption tax error and fee error are set in advance, for example, if the error settings are inappropriate, the process of matching the billing data with the payment data will not be performed appropriately. An inappropriate setting of the error means that a common error is set for all buyers and cannot be applied to each individual buyer. In this case, the user must review the consumption tax error and fee error set for all buyers, and then have the program execute the process of matching the data again. Because such a review procedure is necessary, it is possible that a combination of multiple billing data that corresponds to the payment data cannot be found appropriately enough, and furthermore, user convenience may be slightly reduced.

The present invention aims to provide a program, a billing management device, a billing management method, and a server that can appropriately find a combination of multiple billing information that corresponds to deposit information.

A program according to one aspect of the present invention causes a computer to execute a billing data acquisition process that acquires billing data including a billing amount, a deposit data acquisition process that acquires deposit data including a deposit amount, a search request acquisition process that acquires a search request for corresponding billing data that is billing data corresponding to the deposit data, a threshold acquisition process that acquires from a user a threshold set for the difference between a total billing amount obtained by summing up the billing amounts of the corresponding billing data and a total deposit amount obtained by summing up the deposit amounts of the deposit data in response to the search request, and a search process that searches the billing data for corresponding billing data whose difference satisfies the threshold based on the billing data, the deposit data, and the threshold.

According to this aspect, when the computer acquires a search request, a threshold is acquired by a threshold acquisition process to set a threshold for the difference between the total billing amount and the total deposit amount. Since the threshold is acquired after the search request, if, for example, an appropriate combination of corresponding billing data, which is billing data corresponding to deposit data, and the deposit data is not found in a single search process, it is possible to acquire a search request again and acquire a new threshold. This makes it possible to change the threshold and to adequately find a combination of multiple billing data corresponding to the deposit data.

The program in the above aspect may further cause the computer to execute a selection information acquisition process that acquires first selection information indicating billing data to be used in the search process from among the billing data, and second selection information indicating deposit data to be used in the search process from among the deposit data.

According to this aspect, the user can preselect the billing data and deposit data required when searching for corresponding billing data. This makes it possible to exclude billing data or deposit data that is, for example, a specific amount during the search, making it possible to appropriately search for corresponding billing data.

In the above aspect, the search process searches for at least one or more candidates of corresponding billing data as corresponding billing data that satisfies a threshold value, and the program may further cause the computer to execute a result screen generation process for generating screen information of a search result screen in which at least one or more candidates of corresponding billing data are displayed in a differentiated manner, and a designation process for acquiring, from a user, information designating one of the at least one or more candidates of corresponding billing data through the search result screen.

This allows the user to identify candidates when at least one corresponding billing data candidate is found in the search process. The user can select an appropriate combination from among the candidates, making it possible to appropriately search for combinations.

In the above aspect, the computer may further execute an extraction process to extract repetitive billing data from the billing data, each of which has the same billing amount, and the search process may search for corresponding billing data that includes the repetitive billing data.

As a result, when billing data with the same billing amount is repeatedly included in the billing data, the billing data is extracted as repeated billing data. Since there is a high possibility that buyers will make lump-sum payments for repeated billing data, by searching for the repeated billing data as included in the corresponding billing data, it becomes possible to appropriately search for combinations.

In the above aspect, the computer may further execute a fee acquisition process to acquire from the user the amount of the deposit fee associated with each deposit source from which the deposit is made, and the search process may search for the corresponding billing data based on a threshold value that includes the amount of the deposit fee associated with the deposit source.

According to this aspect, it is possible to obtain the commission for each buyer, and by performing a search based on the obtained commission, it is possible to appropriately search for combinations.

In addition, a billing management method according to another aspect of the present invention includes obtaining billing data including a billing amount, obtaining deposit data including a deposit amount, obtaining a search request for corresponding billing data which is billing data corresponding to the deposit data, obtaining from a user a threshold value set for the difference between a total billing amount obtained by summing up the billing amounts of the corresponding billing data and a total deposit amount obtained by summing up the deposit amounts of the deposit data in response to the search request, and searching for corresponding billing data whose difference satisfies the threshold value based on the billing data, the deposit data, and the threshold value from the billing data.

In addition, a billing management device according to another aspect of the present invention includes a billing data acquisition unit that acquires billing data including a billing amount, a deposit data acquisition unit that acquires deposit data including a deposit amount, a search request acquisition unit that acquires a search request for corresponding billing data which is billing data corresponding to the deposit data, a threshold acquisition unit that acquires from a user a threshold set for the difference between a total billing amount obtained by summing up the billing amounts of the corresponding billing data and a total deposit amount obtained by summing up the deposit amounts of the deposit data in response to the search request, and a search unit that searches the billing data for corresponding billing data whose difference satisfies the threshold based on the billing data, the deposit data, and the threshold.

In addition, a server according to another aspect of the present invention includes a data transmission unit that transmits billing data including a billing amount and deposit data including a deposit amount to a terminal capable of communicating with the server, and a program transmission unit that transmits to the terminal a program that causes the terminal to execute the following: a search request acquisition process that acquires a search request for corresponding billing data, which is billing data corresponding to the deposit data; a threshold acquisition process that acquires from the user a threshold set for the difference between a total billing amount obtained by summing up the billing amounts of the corresponding billing data and a total deposit amount obtained by summing up the deposit amounts of the deposit data in response to the search request; and a search process that searches the billing data for corresponding billing data whose difference satisfies the threshold based on the billing data, the deposit data, and the threshold.

According to this aspect, the terminal performs the search process based on the program that the server transmits to the terminal. This allows the terminal to appropriately search for corresponding billing data while reducing the burden on the server due to the search process.

The present invention provides a program, a billing management device, a billing management method, and a server that enable appropriate discovery of a combination of multiple billing information items that correspond to deposit information.

1 is a schematic diagram of a billing management system according to an embodiment of the present invention. FIG. 2 is a block diagram of a billing management device according to the present embodiment. 4 is an example of customer data according to the embodiment. 4 is an example of billing data according to the embodiment. 4 is an example of deposit data according to the embodiment. FIG. 2 is a block diagram of a user terminal according to the present embodiment. 1 is a diagram illustrating the procedure of a settlement process using the billing management system according to this embodiment. FIG. 13 is an example of a batch deletion screen according to the embodiment. 13 is an example of a batch deletion screen according to the embodiment. 13 is an example of an individual clearing screen according to the embodiment. 13 is an example of an individual clearing screen according to the embodiment. 13 is an example of an individual clearing screen according to the embodiment. 13 is a diagram illustrating another procedure of the clearing process according to the present embodiment. FIG. 13 is another example of an individual clearing screen according to the embodiment. 13 is a diagram illustrating another procedure of the clearing process according to the present embodiment. FIG. 13 is another example of an individual clearing screen according to the embodiment. 13 is another example of an individual clearing screen according to the embodiment. 13 is a diagram illustrating another procedure of the clearing process according to the present embodiment. FIG. 13 is another example of an individual clearing screen according to the embodiment. 13 is another example of an individual clearing screen according to the embodiment. 13 is another example of an individual clearing screen according to the embodiment. 13 is a diagram illustrating another procedure of the cancellation process in this embodiment. FIG.

A preferred embodiment of the present invention will be described with reference to the attached drawings. In each drawing, the same reference numerals are used to denote the same or similar configurations.

The first embodiment will be described. FIG. 1 shows a schematic diagram of a billing management system 10 according to the first embodiment. The billing management system 10 includes a billing management device 100 and user terminals 200a, 200b, and 200c. The billing management device 100 and the user terminals 200a, 200b, and 200c can communicate with a bank system 300 via a network N. The number of user terminals may be greater than or equal to that shown in FIG. 1. In the following description, the individual user terminals 200a, 200b, and 200c will not be distinguished from one another and will be described as user terminal 200.

The billing management device 100 is a device that provides a service for managing a user's billing information by allowing the user to access the device from a user terminal 200 via a web browser or the like and sending and receiving information. The billing management device 100 is an information processing device having a computer that performs a specified process by executing a specified program, such as a server device.

Information for operating the billing management device 100 on a web browser is sent from the billing management device 100 to the user terminal 200. The information for operation is, for example, information about a program that runs on the web browser and information about a screen that is displayed on the web browser.

The user terminal 200 is an electronic device used by a user, and is assumed to be a personal computer here. The user terminal 200 may also be a tablet terminal or a smartphone.

The bank system 300 is a bank system that manages deposits to users. The billing management device 100 obtains deposit data indicating deposits to users' accounts through the bank system 300. Note that although only one bank system 300 is shown in FIG. 1, this does not mean that there is only one bank system that can be connected to the billing management device 100. There may be a bank system that manages each account for each user of the billing management device 100. Furthermore, the entity that manages the deposit data is not limited to a bank, but may be any entity that transfers funds.

In the billing management system 10, the billing management device 100 acquires billing data from the user terminal 200 and acquires deposit data from the bank system 300. The user performs billing management based on this billing data and deposit data. The billing management device 100 may also acquire deposit data for the user through a system other than the bank system 300. For example, when deposits are made with electronic money, the billing management device 100 may acquire deposit data in electronic money through a system that manages the electronic money. The deposit data may be acquired by the user terminal 200 and transmitted to the billing management device 100.

The components of the billing management device 100 will be described with reference to FIG. 2. The billing management device 100 has a communication unit 101, a storage unit 102, and a control unit 103. The functions of the components of the billing management device 100 can be realized by using a storage area such as a memory in the billing management device 100, or by having a processor execute a program stored in the storage area.

The communication unit 101 controls communication between the billing management device 100 and the outside, including the user terminal 200 and the bank system 300, via the network N.

The memory unit 102 stores various information used for processing in the billing management device 100. The memory unit 102 has a user DB (database) 1021, a customer DB 1022, a billing DB 1023, and a deposit DB 1024. The memory unit 102 also stores a program that enables the user terminal 200 to operate the processing of the billing management device 100 through the user terminal 200, and a program that causes the user terminal 200 to execute processing on a web browser.

The data in customer DB 1022, billing DB 1023, and deposit DB 1024 will be described with reference to Figures 3 to 5. The customer data, billing data, and deposit data described below are all data for one user. Each piece of data in customer DB 1022, billing DB 1023, and deposit DB 1024 is stored in user DB 1021 in association with individual users managed by, for example, user name and user ID.

With reference to Figure 3, the customer data stored in customer DB 1022 will be described. The customer information shown in Figure 3 has the fields "customer code", "customer name", "fee payer", and "fee amount". The "customer code" field stores an identification code that identifies the customer. The "customer name" field stores the name of the customer. The "fee payer" field stores the payer of the fee at the time of deposit, for example, "our company" or "customer".
In the "fee amount" field, the fee is stored when the fee bearer is "our company."
If the fee bearer is a "customer," no fee is stored, as shown by the blank in Fig. 3. Alternatively, 0 may be stored as the fee.

The items of customer data stored in customer DB1022 may include items other than those shown here. For example, the customer's corporate number or information on the customer's person in charge may be stored.

The billing data stored in billing DB 1023 will be described with reference to Figure 4. The customer information shown in Figure 4 has the fields "customer code", "customer name", "billing date", and "billing amount". The "billing date" field stores the date when the bill was made. The "billing amount" field stores the billing amount. The fields of the billing data stored in billing DB 1023 may include other fields in addition to those shown here. The billing data may include data for fields such as "sales date", "planned date", "billing category", and "balance billed amount", for example.

The deposit data stored in deposit DB 1024 will be explained with reference to Figure 5. The customer information shown in Figure 5 has the fields "Name of person requesting transfer", "Deposit date", and "Deposit amount". The "Name of person requesting transfer" field stores the name of the person stored in bank system 300 as the transfer requester. The "Deposit date" field stores the date on which the deposit was made. The "Deposit amount" field stores the deposit amount. The items of deposit data stored in deposit DB 1024 may include other items in addition to the items shown here. The deposit data may include data for fields such as "Deposit category", "Bank code", "Bank name", and "Deposit balance", for example.

The control unit 103 controls the acquisition of data from the bank system 300 and the transmission of data to the user terminal 200. The control unit 103 has a data acquisition unit 1031, a data transmission unit 1032, a program transmission unit 1033, a matching processing unit 1034, and a screen information generation unit 1035.

The data acquisition unit 1031 acquires billing data for each user from the user terminal 200. The acquired billing data is stored in the billing DB 1023 for each user. The data acquisition unit 1031 acquires the billing data, for example, by acquiring the billing data from the user's core system or by acquiring a file containing the billing data from the user terminal 200. The data acquisition unit 1031 may also acquire the billing data by acquiring the billing data included, for example, as an attachment in an email sent by the user.

The data acquisition unit 1031 also acquires deposit data for each user from the bank system 300. The data acquisition unit 1031 acquires user account information from the bank system 300, for example, using a reference API. The acquired deposit data is stored in the deposit DB 1024 for each user. The data acquisition unit 1031 may also acquire the deposit data from the user terminal 200.

The data transmission unit 1032 transmits the user's billing data and payment data to the user terminal 200 in response to operations from the user terminal 200.

The program transmission unit 1033 transmits to the user terminal 200 a program that enables the user terminal 200 to execute processing by the control unit 204 described below. The program is transmitted, for example, as a script that runs on a web browser.

The matching processing unit 1034 performs the bulk clearing process described below based on the billing data in the billing DB 1023 and the deposit data in the deposit DB 1024. The matching processing unit 1034 searches for billing data that corresponds to the deposit data, for example, by a search method using a genetic algorithm.

The screen information generating unit 1035 generates information for a screen to be displayed on the user terminal 200. The generated screen information is transmitted to the user terminal 200 and displayed on the user terminal 200. Note that the screen information is information used when displaying a screen on the user terminal 200, and any format can be adopted, such as HTML format, XML format, text format, etc.

The components of the user terminal 200 will be described with reference to FIG. 6. The user terminal 200 has a communication unit 201, a storage unit 202, a display unit 203, and a control unit 204. The functions of the components of the user terminal 200 can be realized in the user terminal 200 by using a storage area such as a memory, or by a processor executing a program stored in the storage area.

The communication unit 201 controls communication between the user terminal 200 and the outside, including the billing management device 100 and the bank system 300, via the network N. The memory unit 202 stores various information used for processing in the user terminal 200. The display unit 203 is a device that displays information processed by the user terminal 200 so that the user can recognize it. The display unit 203 is a display of a computer or a tablet terminal. Note that the display unit 203 may be provided as a separate device that can be connected to the user terminal 200.

The control unit 204 has a data acquisition unit 2041, a search request acquisition unit 2042, a threshold acquisition unit 2043, a search unit 2044, a selection information acquisition unit 2045, a result screen generation unit 2046, a designation unit 2047, an extraction unit 2048, and a fee acquisition unit 2049. Each unit of the control unit 204 is realized, for example, by a program transmitted from the billing management device 100 and executed in a web browser of the user terminal 200. The processing of the control unit 204 is executed using the processor of the user terminal 200. Note that each unit of the control unit 204 may be realized by a dedicated application program instead of a general-purpose web browser.

The data acquisition unit 2041 acquires billing data and deposit data associated with the user from the billing management device 100.

The search request acquisition unit 2042 acquires a search request input by the user through a screen displayed on the display unit 203. For example, the search request acquisition unit 2042 acquires a search request when a button on the screen is selected by the user. Here, a search request is information instructed by the user to search for corresponding billing data, which is billing data that corresponds to the deposit data, from the billing data. By identifying the corresponding billing data for the deposit data, it becomes possible to clear the corresponding billing data.

The threshold acquisition unit 2043 acquires a threshold set for the difference between the total billing amount obtained by adding up the billing amounts of the corresponding billing data and the total deposit amount obtained by adding up the deposit amounts of the deposit data. When a search request is acquired, the threshold acquisition unit 2043 causes the display unit 203 to display a screen for acquiring the threshold. The threshold acquisition unit 2043 acquires the threshold by accepting input from the user through the screen.

The difference arises, for example, from a consumption tax error resulting from differences in how the user and the customer handle consumption tax, or a fee error resulting from fees charged by banks, etc. The threshold may be obtained by obtaining a threshold for each of the consumption tax error and the fee error. The threshold may also be obtained as a single threshold that encompasses the consumption tax error and the fee error, or other errors.

The search unit 2044 searches for corresponding billing data, based on the billing data, the deposit data, and a threshold value, for billing data in which the difference between the total billing amount and the total deposit amount satisfies the threshold value. The search unit 2044 searches for corresponding billing data, for example, by a search method using a genetic algorithm.

The selection information acquisition unit 2045 acquires from the user first selection information indicating which billing data is to be used in the search process from among the billing data, and second selection information indicating which deposit data is to be used in the search process from among the deposit data. The selection information acquisition unit 2045, for example, causes the display unit 203 to display a screen including a check box for each piece of data along with the deposit data and billing data. The selection information acquisition unit 2045 acquires the first selection information or the second selection information based on the input into the check box for each piece of data.

When multiple candidates for a set of corresponding billing data are found, the result screen generation unit 2046 displays a screen on the display unit 203 that allows the user to review the multiple candidates and select one of them.

The designation unit 2047 accepts input from the user to select a candidate via a screen on which the user can confirm multiple candidates for the corresponding billing data set.

The extraction unit 2048 extracts repetitive billing data in which the billing amount for each piece of billing data is the same. For example, the extraction unit 2048 extracts repetitive billing data when the search request acquisition unit 2042 receives input from the user indicating that repetitive billing data is to be extracted.

The fee acquisition unit 2049 acquires from the user the amount of the deposit fee associated with each customer. The fee acquisition unit 2049 causes the user to display the management screen of customer DB 1022 and accepts the input of the fee through the management screen. The input fee is stored in customer DB 1022 in association with the customer.

The settlement process in the billing management system 10 will be described with reference to Figure 7. At the same time, explanations will be given with reference to Figures 8 to 12 as appropriate. It is assumed that the user is logged in to the cloud service provided by the billing management device 100 via the user terminal 200, and that the billing management device 100 is displaying an operation screen.

In step S701, a request for a bulk deletion screen is sent from the user terminal 200 to the billing management device 100 in response to a user operation.

In step S702, the screen information generating unit 1035 generates information for the lump sum clearing screen 800 shown in FIG. 8. In generating the lump sum clearing screen 800, the screen information generating unit 1035 refers to the billing DB 1023 and the deposit DB 1024 to obtain the billing data and deposit data associated with the user. The screen information generating unit 1035 also refers to the customer DB 1022 to obtain the fees associated with the customer.

The bulk clearing screen 800 displays a bulk clearing button 801 and a matching result field 802. In the matching result field 802, billing data by customer is shown as billing information, and deposit data by customer is shown as deposit information. The "number of items" field in the billing information and deposit information stores the number of bills and deposits for each customer, respectively.

The matching result column 802 has an item called "Match". The "Match" item displays information indicating whether the invoice amount and the deposit amount are matched through a matching process by the matching processing unit 1034 and whether the two amounts match. In the example of Figure 8, the invoice data with "customer names" of Company B, Company C, and Company D is matched with the corresponding deposit data and it is determined that the two amounts match. When the user selects the Bulk Clear button 801, a request for clearing the matching invoice data and deposit data is sent to the invoice management device 100.

In step S703, the screen information generation unit 1035 transmits information about the batch deletion screen 800 to the user terminal 200.

In step S704, a request for bulk cancellation is sent to the billing management device 100 when the user selects the bulk cancellation button 801.

In step S705, the matching processing unit 1034 adds information indicating that the reconciliation has been completed to the billing data and deposit data in the billing DB 1023 and deposit DB 1024. This records that the corresponding billing data and deposit data have been reconciled.

In step S706, the screen information generating unit 1035 generates information for the batch clearing screen 800 after the batch clearing. As shown in FIG. 9, the batch clearing screen 800 after the batch clearing displays information including billing information and deposit information for which clearing has not been completed.

In step S707, the screen information generating unit 1035 transmits information about the bulk deletion screen 800 after the bulk deletion to the user terminal 200.

In step S708, a request for the individual clearing screen is sent to the billing management device 100 by selecting the individual selection button 901 on the user terminal 200 on which the bulk clearing screen 800 after bulk clearing is displayed.

In step S709, the screen information generation unit 1035 generates information for the individual clearing screen 1000 shown in FIG. 10. The individual clearing screen 1000 is a screen that displays more detailed billing data and deposit data for the customer with which the individual selection button 901 is associated.

When generating the individual clearing screen 1000, the screen information generating unit 1035 obtains the billing data and deposit data associated with the user from the billing DB 1023 and deposit DB 1024.

The individual clearing screen 1000 displays an individual clearing button 1001, a billing total display field 1002, a billing information display field 1003, and a deposit total display field 1004.

The billing total display field 1002 shows information about each billing data as a whole. The billing information display field 1003 shows each billing data. The "Select" item in the billing information display field 1003 shows a box for selecting whether or not each billing data is to be cleared. In FIG. 10, the data in the first to third lines and the fifth and subsequent lines in the billing information display field 1003 are selected as the data to be cleared. The data in the fourth line in the billing information display field 1003 is selected and excluded from the data to be cleared. The status of each box is selected by the user, and information indicating the selection status is acquired by the selection information acquisition unit 2045.

The deposit total display field 1004 shows information about each deposit data as a whole. The deposit information display field 1005 shows each deposit data. The "selection" items in the deposit total display field 1004 are the same as those in the billing information display field 1003.

A simulation button 10041 is located in the total deposit display field 1004. When the user selects the simulation button 10041, a search request to search for combinations of billing data and deposit data is acquired by the user terminal 200.

In step S710, the program transmission unit 1033 obtains a program for individual clearing processing from the storage unit 102. The program for individual clearing processing specifies the processing of each part of the control unit 204 in the user terminal 200.

In step S711, the screen information generation unit 1035 and the program transmission unit 1033 transmit the screen information and program of the individual deletion screen 1000 to the user terminal 200.

In step S712, the user terminal 200 accepts a request to search for corresponding billing data, which is billing data that corresponds to the deposit data, via the individual remittance screen 1000. Specifically, the search request acquisition unit 2042 of the user terminal 200 acquires a search request made by the user through the individual remittance screen 1000 displayed on the display unit 203 by selecting the simulation button 10041.

In step S713, the threshold acquisition unit 2043 pops up a threshold input screen 1100 on the individual clearing screen 1000, as shown in FIG. 11. The threshold input screen 1100 has a check button 1101 for the fee error, a fee error input field 1102, and a check button 1103 for the consumption tax error, and a consumption tax error input field 1104.

The user operates the user terminal 200 to select the check buttons 1101 and 1103 and input numerical values into the fee error input field 1102 and the consumption tax error input field 1104. When the user selects the "Execute" button on the threshold input screen 1100, the threshold acquisition unit 2043 acquires the input fee error and consumption tax error according to the selection state of the check button 1101. The threshold acquisition unit 2043 acquires the sum of the acquired fee error and consumption tax error as the threshold. In FIG. 11, the threshold is 1,050 yen. Note that the check button 1101 may be displayed by screen transitions rather than in a pop-up format. Also, the fee error input field 1102 may be configured to display information on the amount set in common for all customers in advance. This fee error information is included in the screen information sent from the billing management device 100, for example.

In step S714, the search unit 2044 searches for corresponding billing data based on the billing data, deposit data, and threshold value selected as the search targets.

In step S715, the search unit 2044 displays the search results on the individual clearing screen 1000, as shown in FIG. 12.

The series of search processes and the display of the results will be explained with reference to Figures 10 to 12. Figure 10 shows that a customer with the "Remittance Requester Name" of "Company A" made a deposit of "9,560" yen on "2020/11/02" and a deposit of "7,559" on "2020/11/09". Both of these deposits are the deposit data to be searched. Also, in Figure 10, the data on lines 1 to 3 and lines 5 and after in the billing information display field 1003 have been selected as the search targets.

The search process searches for billing data corresponding to the total deposit amount of 17,119 yen. At this time, the search unit 2044 searches for billing data where the error between the corresponding billing data and the deposit amount is within 1,050 yen. As a result of the search, the billing data in the first and fifth lines of the billing information display field 1003 is found as corresponding billing data that satisfies the conditions. For example, the total of the billing data in the third and fifth lines of the billing information display field 1003 is 15,000 yen, which does not satisfy the threshold value and therefore these billing data are not corresponding billing data.

In FIG. 12, the individual reconciliation screen 1000 is updated so that the searched corresponding billing data is selected. Specifically, the individual reconciliation screen 1000 is updated so that billing data other than the corresponding billing data is deselected. In addition, the difference amount that was within the error range is displayed in the consumption tax error column of the billing total display column 1002 and the consumption tax error and fee column of the payment total display column 1004, respectively.

In step S716, in response to the user's selection of the individual clearing button 1001, the user terminal 200 sends an individual clearing request to the billing management device 100. This request includes information indicating the corresponding billing data and the deposit data.

In step S717, the matching processing unit 1034 adds information indicating that the corresponding billing data and deposit data in the billing DB 1023 and the deposit DB 1024 have been settled based on the acquired corresponding billing data and deposit data.

By following the above steps, it is possible to carry out individual clearing processing for billing data that could not be cleared using the bulk clearing processing, and clearing based on partial payment data.

Another example of the clearing process in the billing management device 100 will be described with reference to Figures 13 and 14. Figure 13 is a diagram showing another procedure for the clearing process in the billing management device 100. Figure 13 shows the process after sending a request on the individual clearing screen. The processes in steps S1301, S1302, S1304, and S1306 to S1311 are the same as the processes described from S708 onwards in Figure 7.

The cancellation process in FIG. 13 differs from the cancellation process in FIG. 7 in that it includes steps S1303 and S1305.

In step S1303, the screen information generating unit 1035 acquires information regarding fees from the customer DB 1022. For example, if Company A is a customer (the source of payment), information regarding fees is acquired based on the customer data in FIG. 3, indicating that the company will pay a fee of 440 yen.

In step S1305, the screen information generation unit 1035 and the program transmission unit 1033 transmit the screen information of the individual settlement screen 1000, information regarding fees, and the program to the user terminal 200.

Figure 14 shows the individual reconciliation screen 1000 and threshold input screen 1100 when information regarding fees is sent. In this case, the registered fee display field 1402 of the threshold input screen 1100 displays the fees set for each customer pre-entered based on the information regarding fees. In Figure 14, the registered fee for Company A, "440", is displayed in the registered fee display field 1402.

When the check button 1401 is selected, the search unit 2044 searches for billing data while taking into account the registered fees. For example, in FIG. 14, the search unit 2044 searches for a combination of billing data that matches "9,560 + 7,559 + 440 = 17,559 yen."

In addition, by displaying the fees for each customer in advance in the registered fee display field 1402, the input burden on the user can be reduced when fees are stored for each customer. The user can change the value in the fee error input field 1102 as necessary. When the user changes the value, the user terminal 200 may transmit information on the changed value to the billing management device 100. Based on the information from the user terminal 200, the billing management device 100 may update the information on fees in the customer DB 1022.

Also, in FIG. 14, a check box 1403 corresponding to the display "Quick Search" is provided. When the check box 1403 is selected, the search unit 2044 sorts the billing data by billing date and selects initial candidates for corresponding billing data based on the billing date. The search unit 2044 performs a search process using the selected initial candidates. In this case, the corresponding billing data can be found in a shorter time.

Another example of the clearing process in the billing management device 100 will be described with reference to Figures 15 to 17. Figure 15 is a diagram showing another procedure for the clearing process in the billing management device 100. Figure 15 shows the processing after the request for the individual clearing screen is sent. The processing from steps S1501 to S1507, S1510, and S1511 is the same as the processing described from S708 onwards in Figure 7.

The cancellation process in FIG. 15 differs from the cancellation process in FIG. 7 in that it includes steps S1508 and S1509.

In step S1508, if there are multiple sets of corresponding billing data, the result screen generation unit 2046 displays the search results on the individual settlement screen 1000 so that the user can select them.

For example, in the billing information display field 1003 of the individual settlement screen 1000 shown in FIG. 16, there are two sets of billing data with a total amount of "18,000" yen: a set of the first and fifth lines, and a set of the first, sixth, and seventh lines.

In this case, when a search process is performed, the above two pairs can become the corresponding billing data. In this case, the result screen generation unit 2046 displays a screen including a combination candidate display screen 1700 as the search result screen on the individual clearing screen 1000, as shown in FIG. 17.

On the combination candidate display screen 1700, the corresponding billing data are displayed in a differentiated state. On the combination candidate display screen 1700, selection buttons 1701 and 1702 are provided so as to be capable of receiving input from the user. The user selects the selection button 1701 or 1702 to specify the set of corresponding billing data that the user considers appropriate from the multiple sets of corresponding billing data displayed in a differentiated state.

In step S1509, the designation unit 2047 acquires the user's selection result based on the input to either of the selection buttons 1701, 1702. When either of the selection buttons 1701, 1702 is selected and the Confirm button at the bottom of the combination candidate display screen 1700 is selected, the designation unit 2047 acquires the billing data corresponding to the selection button selected at that time as the selection result. For example, the designation unit 2047 acquires information that, by selecting and confirming the selection button 1701, the set of the first and fifth lines of the billing data has been designated by the user as the corresponding billing data. Subsequent individual settlement processing is performed for the designated corresponding billing data.

Another example of the clearing process in the billing management device 100 will be described with reference to Figures 18 to 21. Figure 18 is a diagram showing another procedure for the clearing process in the billing management device 100. Figure 18 shows the process after sending a request on the individual clearing screen. The processes from steps S1801 to S1807 and S1810 to S1812 are the same as the processes described from S708 onwards in Figure 7.

The cancellation process in FIG. 18 differs from the cancellation process in FIG. 7 in that it includes steps S1808 and S1809.

In step S1808, the extraction unit 2048 obtains an extraction request for the repeatedly stored billing data and extracts the billing data. For example, assume that billing data for a billing amount of "2,000" yen is repeatedly stored, as shown in the individual clearing screen 1000 in FIG. 19.

In this case, as shown in FIG. 20, the extraction unit 2048 acquires a request to extract repeatedly stored billing data (repeated billing data) through the setting button 2001 corresponding to the display of "Give priority to repeated billing amounts" on the threshold input screen 1100. The extraction unit 2048 may display the setting button 2001 so that it is included in the threshold input screen 1100, or may display it as another screen.

In step S1809, the search unit 2044 searches for corresponding billing data by prioritizing billing data that is repeatedly stored. Specifically, the search unit 2044 searches for corresponding billing data such that the billing data that is repeatedly stored is included in the corresponding billing data.

Figure 21 shows the individual clearing screen 1000 after the search. In the billing information display field 1003, the groups with a billing total of 18,000 yen include the group of the first, third, and fifth lines, and the group of the first through fourth and sixth lines.

As a result of the search unit 2044 searching for corresponding billing data by prioritizing repeatedly stored billing data, the set of billing data in the first to fourth and sixth lines, which includes repeatedly stored billing data for a billing amount of "2,000" yen, is displayed as the corresponding billing data. On the other hand, the set including billing data for a billing amount of "8,000" yen is not regarded as the corresponding billing data.
This allows the corresponding billing data to be appropriately searched for by searching for repetitive billing data that is likely to be paid in one lump sum by the customer.

Another example of the clearing process in the billing management device 100 will be described with reference to FIG. 22. FIG. 22 is a diagram showing another procedure for the clearing process in the billing management device 100. FIG. 22 shows the process after sending a request on the individual clearing screen.

The processes from steps S2201 to S2206 and S2210 to S2212 are the same as the processes described from S708 onwards in FIG. 7. In step S2203, the program transmission unit 1033 acquires a program for managing the individual deletion screen in the user terminal 200, and does not necessarily need to acquire a program that enables the user terminal 200 to perform search processing.

In the process shown in FIG. 22, in step S2207, a search process request and a threshold value are sent from the user terminal 200 to the billing management device 100. In step S2208, the matching processing unit 1034 searches for corresponding billing data. In step S2209, the matching processing unit 1034 sends the search results to the user terminal 200.

In this way, the search process may be executed in the user terminal 200 or in the billing management device 100. In addition, even if it is a process other than the search process, a process that does not need to be executed by the control unit 204 in the user terminal 200 can be executed in the billing management device 100.

The above-described embodiments are intended to facilitate understanding of the present invention, and are not intended to limit the present invention. The elements and conditions of the embodiments are not limited to those exemplified, and may be modified as appropriate. In addition, configurations shown in different embodiments may be partially substituted or combined.

10... billing management system, 100... billing management device, 101... communication unit, 102... storage unit, 103... control unit, 200, 200a, 200b, 200c... user terminal, 201... communication unit, 202... storage unit, 203... display unit, 204... control unit, 300... bank system, 2041... data acquisition unit, 2042... search request acquisition unit, 2043... threshold acquisition unit, 2044... search unit, 2045... selection information acquisition unit, 2046... result screen generation unit, 2047... designation unit, 2048... extraction unit, 2049... fee acquisition unit

Claims (7)

On the computer,
A data acquisition process for acquiring a plurality of billing data including a billing destination and a billing amount, and a plurality of deposit data including a deposit source and a deposit amount;
a batch clearing process for identifying a set of deposit data and billing data in which a first total billing amount, which is a total amount of billing amounts of the plurality of billing data to a first billing destination, matches a first total deposit amount, which is a total amount of deposit amounts of the plurality of deposit data from a first deposit source corresponding to the first billing destination, among the plurality of billing data and the plurality of deposit data, and clearing the sets;
a screen generation process for generating information for a screen displaying information on a plurality of billing data to a second billing destination and a plurality of deposit data from a second deposit source corresponding to the second billing destination , which have not been cleared by the bulk clearing process , among the plurality of billing data and the plurality of deposit data, based on an operation by a user after the bulk clearing process;
a search request acquisition process for acquiring, via the screen, a search request which is information instructing to search for at least one corresponding billing data to be cleared from a plurality of billing data to the second billing destination, the at least one corresponding billing data corresponding to at least one deposit data selected from a plurality of deposit data from the second deposit source;
a first threshold acquisition process for acquiring, when the search request is acquired, a first threshold for the difference between a second total billing amount obtained by summing up the billing amounts of the at least one corresponding billing data and a second total deposit amount obtained by summing up the deposit amounts of the at least one selected deposit data from a user;
An individual clearing process for identifying the at least one corresponding billing data and clearing a pair of the selected at least one deposit data and the identified at least one corresponding billing data so that the difference falls within the range of the first threshold value;
A program that executes the following. The program according to claim 1,
The program, wherein the first threshold includes a threshold for a fee and a threshold for a consumption tax. 3. The program according to claim 1 or 2,
The first threshold value acquisition process is a program for presenting predetermined threshold value candidates stored in a storage unit of the computer to the user and then acquiring the first threshold value from the user. The program according to any one of claims 1 to 3,
In the individual clearing process, if there are a plurality of combinations of the at least one corresponding billing data in which the difference falls within the range of the first threshold value,
The computer includes:
a result screen generation process for generating screen information of a search result screen on which the plurality of combinations are displayed in a differentiated manner;
and acquiring, from the user through the search result screen, information for designating one of the plurality of combinations. 1. A computer-implemented method comprising:
Acquiring a plurality of billing data including a billing destination and a billing amount, and a plurality of deposit data including a deposit source and a deposit amount;
Among the plurality of billing data and the plurality of deposit data, a first total billing amount, which is a total amount of billing amounts of the plurality of billing data to a first billing destination , matches a first total deposit amount, which is a total amount of deposit amounts of the plurality of deposit data from a first deposit source corresponding to the first billing destination, to identify a pair of deposit data and billing data in which the first total billing amount matches, and perform a lump-sum settlement;
After the bulk clearing , based on a user operation, generate information for a screen displaying information on a plurality of billing data to a second billing destination and a plurality of deposit data from a second deposit source corresponding to the second billing destination , which have not been cleared by the bulk clearing , among the plurality of billing data and the plurality of deposit data;
Acquiring, via the screen, a search request which is information instructing to search for at least one corresponding billing data to be cleared from a plurality of billing data to the second billing destination, which corresponds to at least one deposit data selected from a plurality of deposit data from the second deposit source;
When the search request is acquired, acquiring from a user a first threshold value for the difference between a second total billing amount obtained by summing up the billing amounts of the at least one corresponding billing data and a second total deposit amount obtained by summing up the deposit amounts of the at least one selected deposit data ;
A billing management method comprising: identifying the at least one corresponding billing data so that the difference is within the first threshold range; and performing individual reconciliation of the pair of the selected at least one deposit data and the identified at least one corresponding billing data . a data acquisition unit that acquires a plurality of billing data including a billing destination and a billing amount, and a plurality of deposit data including a deposit source and a deposit amount;
a lump-sum clearing unit that identifies a set of payment data and payment data in which a first total billing amount, which is a total amount of billing amounts of the plurality of payment data to a first billing destination, matches a first total deposit amount, which is a total amount of deposit amounts of the plurality of deposit data from a first deposit source corresponding to the first billing destination, among the plurality of payment data and the plurality of payment data, and performs lump-sum clearing;
a screen information generating unit that generates, based on a user's operation after the batch clearing , information on a screen that displays information on a plurality of billing data to a second billing destination and a plurality of deposit data from a second deposit source corresponding to the second billing destination that have not been cleared by the batch clearing , among the plurality of billing data and the plurality of deposit data;
a search request acquisition unit that acquires, via the screen, a search request, which is information instructing to search for at least one corresponding billing data to be cleared from a plurality of billing data to the second billing destination, corresponding to at least one deposit data selected from a plurality of deposit data from the second deposit source;
a first threshold acquisition unit that acquires, when the search request is acquired, a first threshold value for the difference between a second total billing amount obtained by summing up the billing amounts of the at least one corresponding billing data and a second total deposit amount obtained by summing up the deposit amounts of the at least one selected deposit data, from a user;
A billing management device comprising: an individual reconciliation processing unit that identifies the at least one corresponding billing data so that the difference is within the first threshold range, and performs individual reconciliation of the pair of the selected at least one deposit data and the identified at least one corresponding billing data . A server,
a data transmission unit that transmits a plurality of billing data including a billing amount and a plurality of deposit data including a deposit amount to a terminal that can communicate with the server;
A program transmitted to the terminal,
The terminal,
A data acquisition process for acquiring a plurality of billing data including a billing destination and a billing amount, and a plurality of deposit data including a deposit source and a deposit amount;
a batch clearing process for identifying a set of deposit data and billing data in which a first total billing amount, which is a total amount of billing amounts of the plurality of billing data to a first billing destination , matches a first total deposit amount, which is a total amount of deposit amounts of the plurality of deposit data from a first deposit source corresponding to the first billing destination, among the plurality of billing data and the plurality of deposit data, and clearing the data;
a screen generation process for generating information for a screen displaying information on a plurality of billing data to a second billing destination and a plurality of deposit data from a second deposit source corresponding to the second billing destination , which have not been cleared by the bulk clearing process , among the plurality of billing data and the plurality of deposit data, based on an operation by a user after the bulk clearing process;
a search request acquisition process for acquiring, via the screen, a search request which is information instructing to search for at least one corresponding billing data to be cleared from a plurality of billing data to the second billing destination, the at least one corresponding billing data corresponding to at least one deposit data selected from a plurality of deposit data from the second deposit source;
a first threshold acquisition process for acquiring, when the search request is acquired, a first threshold for the difference between a second total billing amount obtained by summing up the billing amounts of the at least one corresponding billing data and a second total deposit amount obtained by summing up the deposit amounts of the at least one selected deposit data from a user;
an individual clearing process for identifying the at least one corresponding billing data and clearing a pair of the selected at least one deposit data and the identified at least one corresponding billing data so that the difference falls within the range of the first threshold value;
a program transmission unit that transmits a program to the terminal to execute the above-mentioned program;
A server comprising:

Images