JP3482628B2 - Billing data processing system - Google Patents

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to charge billing data for collectively processing billing data including contractor information issued by a billing institution and a billing amount for each account of a paying institution on a payment date basis. Regarding processing system.

[0002]

Prior Art and Problems to be Solved by the Invention FIG.
FIG. 4 is a diagram for explaining an example of a conventional utility bill payment system. With cashless and automated payment of fees,
For individuals, payment of utility bills such as electricity, telephone, gas, water, and TV reception fee by automatic deduction from a bank account is widely used. These utility bills are sent to the bank by each business office of the billing organization (service supply company), and the debit data is sent to the bank. At the same time, a statement of usage is issued to the user, and the user uses the debit account of the bank. By providing the funds, the payment is made from a specific debit account.

However, although the automatic transfer of public utility charges as described above is prevalent in individuals, it is the fact that it is rarely used by corporations. In particular, it is not adopted by large-scale corporations that have many business bases such as stores, sales offices, branch offices, etc. nationwide, and as shown in FIG. 16, the payment procedure is performed by a payment statement issued by the service supply company. Payment payments are becoming the mainstream. The reason is that the company receives the invoice, pays after confirming the content and amount of the invoice, and the pre-payment approval is the principle of corporate accounting.Therefore, the debit of the account, which is the post-approval of the payment, is not familiar to the company. Furthermore, as for the direct debit, the debit date and the debit amount are not fixed, so it is not possible for the company to manage the funds, and there is a loss of funds that causes the funds to be laid down on a regular basis.

Therefore, for example, even if there is an average of four companies paying for one business office, there are 35 payments nationwide.
For corporations with 00 bases (business offices), 1680 per year
The procedure for payment of 00 sheets is executed. In addition, even if one office supplies 2 sheets of high voltage and low voltage every month, 3 to 5 telephones including facsimile, mobile phone, second electric power, etc. It only takes 6 to 8 payment slips. In addition, public utilities alone will make a total of 921 electric power companies, 12 telephone companies, 100 gas companies, and 800 water companies nationwide, including local governments (property tax, city planning tax, automobile tax), If you include payments for broadcasting stations, newspapers, leasing fees, land rent, and various membership fees, the amount of work will be enormous.

On the other hand, in the case of a mobile industry in which a construction site is set up only until the construction is completed, the consolidation of transactions is intense and the management seems to be complicated, so the local clearing principle is adopted. There is. For this reason, there are many billing institutions and their types, and even if these are centralized, the management is not well done, and the work of matching the burdened account after being debited is no different from the case of payment payment payment. There is also. In addition, the post-processing automatic transfer system for bank service products has a limited capacity. Due to such circumstances and the fact that the automatic withdrawal procedure may take a long time, a mixture of automatic withdrawal and payment payment may occur.
Generally, large-scale corporations process payment of public utility charges, etc.
It's getting complicated.

[0006]

[Means for Solving the Problems] The present invention is to solve the above-mentioned problems, and a corporation having many bases and offices can simplify the transfer processing of public utility charges and the like, thereby eliminating waste of fund operation and clerical work. This enables labor saving.

[0007]

Therefore, the present invention is a billing data processing system which receives billing data of various fees including a contractor code from a billing organization of various fees, and transfers and bills the billing data. Then, the contractor code extraction in which the contractor code position information and unnecessary data position information are set as extraction information for extracting the contractor code from the billing data in a format unique to the billing institution that includes the contractor code A filter means for extracting the contractor code from the billing data received by the billing data receiving means by referring to the contractor code extraction table, and a burden including an account item for each contractor code. Matching contractor code extracted by the filter means with burden account master And the matching processing means for creating a transfer list and transfer documents required for the accounting treatment of the claim data by performing a grayed processing, to pay daily, the type of fee, each contractor,
The data file has a data file for storing and accumulating the billing amount, and based on the billing data received by the billing data receiving unit and the contractor code extracted by the filtering unit, the type of charge in each data file and each contractor A billing data creating means for storing billing amount and creating billing data for each payment date, and as the accounting processing data for transferring various charges from the billing data, the transfer list or transfer slip, and the payment date It is characterized in that it is configured to output billing data.

Further, the billing data processing means collects billing data for each paying date one business day before the paying date based on the data file and the calendar storing the charge type, each contractor, and the billing amount for each paying date. It is characterized in that the contractor code extraction table is
The billing data format is registered for each financial institution.

[0009]

BEST MODE FOR CARRYING OUT THE INVENTION Embodiments of the present invention will be described below with reference to the drawings. FIG. 1 is a diagram showing an embodiment of a billing data processing system according to the present invention, FIG. 2 is a diagram for explaining a billing data filtering process and a matching process, and 1 is a billing data creation processing unit, 2 Is a billing notification issuance processing unit, 3 is a billing data receiving unit, 4 is a debiting processing unit, 5 is a filtering processing unit, 6 is a billing data receiving processing unit, 7 is a matching processing unit, 8 is a burden account master, and 9 is accounting. Processing, 10 is a financial allowance, 11 is accounting data, and 12 is a transfer slip.

In FIG. 1, a billing data receiving unit 3 receives billing data from a billing institution (service supply company), and sorts by type of electricity, gas telephone, water supply, etc. TEPCO, Chuden, KANDEN, etc.), which is processed by the contractor. The billing data includes, for example, a contractor code registered by the company, such as a meter number or a telephone number, but the billing data processed by the filter processing unit 5 includes a contractor code registered by the company. It includes additional management information (for example, billing date and number of bills, ledger number / page number, district, address, sales office information, etc.) of unrelated service supply companies (billing institutions) and banks (financial institutions). Their position depends on the service provider and bank. That is, the format of the data including the contractor code differs depending on the service provider and the bank. The filter processing unit 5 reads the contractor code necessary for the company (burdening agency) from the billing data including the contractor code in a format unique to the service supply company and the bank. The bearer account master 8 is a bearer account in accounting processing of a bearer organization (payment company), for example, an account item, a oral account, a cost code, etc., stored for each contractor code, and is registered in advance by, for example, the accounting department. It The matching processing unit 7 performs a matching process between the contractor code of the billing data and the burden account master 8 to create a transfer list or a transfer slip necessary for accounting processing of each billing data.

Next, the overall flow will be described. First, in the service supply company, the usage amount is grasped by meter reading or the like, the billing data creation processing unit 1 creates billing data, and the billing notification issuance processing unit 2 issues a billing notification. This billing data is brought to the bank's office center by magnetic data, for example.

The bank accepts the billing data brought in by the billing data receiving unit 3, extracts the billing data for each company, and collects the billing data (payment date) in units of the payment date before the payment date (1 business day before). Unit billing data).
In the filter organization, the filter processing unit 5 reads the contractor code from the billing data including the contractor code in a specific format of the billing data in payment date units and converts it into the registered contractor code of the company.

In the company, the matching processing unit 7 performs matching processing with the burden account master using the contractor code of the billing data, and creates a transfer list and a transfer slip.
Perform accounting process 9 and fund allowance 10. On the other hand, in banks,
The amount of billing data for each payment date is deducted from the debit account of the company on the payment date, and the payment is made to the service supply company. In addition, at the company's base office, when creating the billing data of the fee from the service supply company, the billing notice is issued, so check the usage amount and amount, and if there is an abnormal value, contact the service supply company. By contacting us, the billing data will be corrected.

FIG. 2 shows a concrete example of the filtering process and the matching process of the billing data. First, in the filter processing section 5, the second and fifth digits from the uppermost are unnecessary data as the format of the data including the contractor number, and the remaining data is preset to be read as the contractor number. On the other hand, the burden account master 8
Account covered by contractor number "12345" (accounting unit)
Is registered as “69050-1”. Therefore,
As shown in FIG. 2, for example, from the billing amount "18233945" in which unnecessary data irrelevant to the subscriber number such as the billing date "8" and the billing number "7" is mixed in the contractor number "12345". When the billing data is input, the filter processing unit 5 reads the contractor number “12345” from the data “1823934” by the filtering process and sends the contractor number and the billing amount to the matching processing unit 7. As described above, the contractor number has no information value for the company and is exclusive of information unique to the service supply company and the bank, and is information corresponding to an identification number used for processing in the company. In the matching processing unit 7, “12
By performing matching processing with the burden account master 8 using the contractor number of “345”, the burden account (accounting unit) “6
“9050-1” is read out, accounting data 11 including a contractor number, a billing amount, and a burden account is generated, and a desired transfer slip 12 is output by performing slip processing based on these.

FIG. 3 is a diagram showing a concrete example of the configuration of the filter processing unit, FIG. 4 is a diagram showing an example of the configuration of a billing data issue processing unit for each payment date, which is performed upon receipt of billing data, and FIG. 5 is a payment date unit. It is a figure which shows the structural example of the payment date management data file used for the issuance processing of the billing data.

The filter processing section 5 can be constituted by a contractor code extraction processing section 21 and a contractor code extraction table 22 as shown in FIG. 3, for example. in this case,
A billing data format is registered in the contractor code extraction table 22 for each financial institution and billing institution. In the contractor code extraction table 22, for example, "0" is set in the unnecessary data position and "1" is set in the contractor code position.
Then, the contractor code extraction processing unit 21 uses the billing data 3
When inputting, first identify the financial institution and the billing institution, then refer to the corresponding billing data format to truncate the data at position "0" as unnecessary data, leaving only the data at position "1". Import and read contractor code.

The structure of the billing data issue processing unit for each payment date can be configured by a calendar 23, a payment date management data file 24, and a billing data processing unit 25 as shown in FIG. 4, for example. Here, the payment date management data file 24, for example, for each account number as shown in FIG.
The billing amount for each contractor code is written in payment date units. When the billing data processing unit 25 receives billing data from the service supply company (billing institution),
Write the billed amount in the payment date field, and enter the calendar 23
Based on the above, for example, when the system is started every morning, the billing amount of each contractor code is read out one business day before and the billing data in units of payment date is issued. In this case, a total column may be provided for each type and institution, and the total may be calculated, and the total amount may be calculated, or the billing amount may be cleared when the billing data for each payment date is issued. May be processed. Further, all the billing data in payment date units may be created as required by an instruction for one business day before, that is, for each day after the next business day.

FIG. 6 is a diagram showing an outline of a system comprising a plurality of billing institutions, financial institutions, and burden institutions,
31 is a billing institution, 32 is a financial institution, 33 is a filter institution, and 34 is a burden institution. In FIG. 6, the billing organization 3
1 is, for example, a power company A, ..., Telephone company M, etc., the financial institution 32 is a bank a ,. Here, the billing institution 31 brings in the billing data (transfer data) 35 including the contractor code, the billing amount, the payment date (transfer date), the additional management information, and the transfer account to the financial institution 32. The billing data 36 is managed by adding a charge type code, an institution code, a debit account, additional management information, and the like. And the filter engine 33
It is provided as a common center for the financial institutions 32, and filtering processing is performed here to notify the burdening institution 34 of the billing data 37 on a payment date basis one business day before the payment date.

Next, an example of the processing system of the burdening institution, which is performed upon receiving the notification of the billing data 37 on a payment date basis from the financial institution, will be described. In the following example, a system for performing charge transfer processing using the above billing data as transfer data will be described. FIG. 7 is a diagram showing an embodiment of the charge transfer processing system according to the present invention. In the figure, 51 is a communication control unit,
52 is an I / O control unit, 53 is a reception processing unit, 54 is a charge transfer statement history file creation processing unit, 55 is an accounting processing unit, 5
6 is a transfer request acceptance / registration processing unit, 57 is a keyboard,
Reference numeral 58 is a display, 59 is a printer, 60 is a master file, and 61 is a charge transfer statement history file.

In FIG. 7, the communication control unit 51 performs information communication with each of the business establishments of the financial institution and the burdening institution, and the charge detail data from the financial institution and the transfer request data from the burdening institution. Is received, data of a billing institution and a burdening institution registered by a transfer request form or transfer data is transmitted to a financial institution, or slip data for confirmation is transmitted to the burdening institution. Of course, these may be transmitted / received by a storage medium, or the document may be input / output via a keyboard or a printer. The I / O control unit 52 includes a pointing device such as a mouse for operation input, a keyboard 57, a display 58 for display output, a printer 59 for print output, a master file 60 for storing master data as an external storage device, and a charge transfer statement history. The input / output of the charge transfer statement history file 61 for storing data is controlled. Of course, the file may be configured to be stored in the internal storage memory.

The reception processing unit 53 receives and processes charge detail data from a financial institution, and the charge detail data has information on a transfer account, a transfer date, a billing institution, a burdening institution, and a transfer amount. Upon receiving the charge detail data, the reception processing unit 53 divides the charge detail data into individual charge transfer detail data for each billing organization and performs a check based on the data registered in the master file 60. A fee transfer detailed file is created which is composed of aggregated data in which the number of transfers and the amount of transfer are aggregated for each type.

Here, the invoicing agency is each business office of a service provider company (electricity, gas, water, telephone, broadcasting, etc.) related to public utility charges, and is a business unit for normal meter reading, issuance of transfer notices, etc. In addition, it has information that can be used to identify business offices, branch offices, etc., and is represented by, for example, a utility charge code or a storing agency code. The burdening organization is each business establishment or the like that has been supplied with services such as electricity, gas, water, telephone, broadcasting, etc., and is represented by, for example, a customer number. Therefore, the individual charge transfer detailed data is transferred to which account at what time, whether it is electricity, gas, water, telephone, broadcasting, etc. from which sales office, or which business operator received the service. Something
And, it has that amount of money as information.

The master file 60 is for registering master data including information about the billing organization and the burdening organization and a burden account, and electricity, gas, water, telephone, and telephone to search from the billing organization and the burdening organization as necessary. Information on service providers such as broadcasting, business offices such as head offices, addresses,
It is used to register information such as abbreviations and account titles, to collate billing organizations and burdening organizations registered as master data, and to create transfer slips and cost data.

Charge transfer details history file creation processing unit 54
Checks the individual charge transfer detailed data stored in the charge transfer detailed file for the existence of individual charge transfer detailed data other than the burdening organization registered in the master file 60, and unregistered data is registered data as, for example, undecided provisional payment processing. Separately, charge transfer details history file 6 based on these data
1 is created, and the totaling process is performed by the classified burdening organization or account.

The accounting processing section 55 uses the transfer slip having the charge transfer information of each billing institution for each paying institution from the charge transfer detailed history file 61, or the billing institution for each paying institution classified by the head office or business establishment. A transfer slip having charge transfer information, cost data having information necessary for accounting processing for financial accounting to be recorded in a predetermined account by accounting processing, and total charge transfer data on the transfer date are created. The transfer slip is for charge transfer detailed data, for example, for each site,
It is created to confirm and approve each branch, cost data is created to perform a predetermined process in corporate accounting, and total charge transfer data is, for example, a deposit account of the Finance Department. Transfer funds to the transfer account,
It is used to allocate funds corresponding to the transfer amount to the transfer account and is submitted to the financial institution.

The transfer request acceptance / registration processing unit 56 is for registering / deleting the master data in the master file 60 when opening / closing an account for public utility transfer in connection with the opening / closing of a business establishment. It is processed and generally processed according to the submission of a transfer request form from a business establishment or the like and notified to a financial institution. Upon receiving the transfer data from the billing institution, the financial institution creates individual charge transfer detailed data according to this information. However, if there is a discrepancy between the information of the financial institution and the master data of the master file 60, or if there is an input error, as described above, the charge transfer statement history file creation processing unit 54 makes an undecided temporary payment. Will be processed.

Explaining the whole work flow including the billing institution which is the service supply company, first, for example, when a new business establishment is established, utility charges such as electricity, telephone, etc., which bear the business establishment, will be provided. A transfer request form is created. Based on this, the master file 60 of the charge transfer processing system is provided with a billing organization or a burdening organization for utility charges such as electricity and telephone,
Information necessary for managing accounts, transfer dates, and, if necessary, addresses, names, accounts, etc. is registered as master data, and the contents are also notified to financial institutions. The billing institution periodically makes meter readings to create transfer data and send it to the financial institution, and issues a transfer notice to the burdening institution that made the meter reading. On the other hand, when the financial institution receives the transfer data from the billing institution two business days before, for example, it creates the charge detail data one business day before and sends it to the charge transfer processing system. In the charge transfer processing system,
Upon receipt of the charge detail data, a transfer slip is created to confirm and approve the charge transfer detail data, and cost data is created to perform accounting processing. Then, the comprehensive transfer data is transmitted to the financial institution to fund the funds (transfer), and a slip for collating with the transfer notice is transmitted to the burdening institution.

Next, each data structure will be described by showing a concrete configuration example. FIG. 8 is a diagram showing an example of the structure of the charge detail data, FIG. 9 is a diagram showing an example of the structure of the charge transfer detail file, FIG. 10 is a diagram for explaining the information of the billing organization and the burden organization, and FIG. 11 is the charge detail data. FIG. 12 is a diagram for explaining the flow of each file and data created from FIG. 12, and FIG. 12 is a diagram showing an example of a transfer slip.

The format of the charge detail data received from the financial institution by the reception processing unit 53 consists of a header record, a data record, a trailer record, and an end record, as shown in FIG. A plurality of pieces of data are connected to form one data group. Then, a plurality of data groups continue and end with an end record. The header record is shown in Figure 8.
As shown in (B), it has the information of the account of the following data group, and specifically, for example, type code, transfer date (from self to), bank code, bank name, branch code, branch name, deposit item, It consists of account number, account name, etc. Also, the data record is
It has information on transfer date, billing organization, burdening organization, transfer amount,
Specifically, it includes, for example, a transfer date, a utility charge code, a storing agency code, a storing agency name, a transfer amount, a customer number, and the like. The trailer record has information on the total number of transfers, the total transfer amount, the number of transfers for each type of electricity, gas, water, telephone, broadcasting, etc., and the transfer amount, which is the sum of a plurality of data records. The end record has the total number of records and the number of accounts. So basically one of the data records
One is, for example, the electricity charge (high voltage), the electricity charge (low voltage), the water charge, etc. of the business A, and the transfer charge of one business with a unified account is composed of a plurality of data records following the header record.

In the receiving process, as the editing of the received data,
The header, data, trailer, and end records are divided, and as error checks, a numeric check of the transfer date and transfer amount, a utility charge code indicating the billing organization,
The code master check of the storing organization code and the consistency check by comparing the total number of data and the total amount of money and the total number of trailers and the total amount of money are performed. And if there is an error, output the utility bill transfer details checklist,
Create a charge transfer details file.

The charge transfer detailed file is an individual charge transfer detailed data including a transfer date, a billing organization, a burden organization, and a transfer amount as shown in FIG. 9A, and electricity and gas as shown in FIG. 9B. Etc. and the aggregated data obtained by aggregating the transfer amount and the number of transfer cases for each type of billing organization. In particular,
For example, the transfer date, the utility charge code, the storing institution code, the customer number, the transfer amount, and the transfer amount and the number of transfers collected for each utility charge of gas, telephone, NHK, electricity, and water.

Further, as shown in FIG. 10, the billing organization is represented by, for example, a utility rate code or a storing agency code, which are coded according to the type of utility rate such as electricity or telephone, the business office handling the same, and the region. different. The burdening organization is represented by, for example, a customer number, and differs depending on the financial institution, account, head office, business office, region, account, and accounting information. Therefore, register this information as master data corresponding to the customer number. By doing so, it is possible to collect public utility charges by the main branch office, business establishment, and area, and create transfer slips, cost data, and general transfer data. FIG. 11 shows these relationships, and FIG. 12 shows an example of a transfer slip.

As described above, the charge specification data is received and the charge transfer specification file is created and stored in the charge transfer specification history file. The charge transfer specification history file is shown in FIG. 8 and FIG. Similar to the charge detail data and charge transfer detail file explained in step 1, transfer date, utility code,
The branch office code, the account code, the abbreviation code, etc. are added to the data of the storing organization code, the customer number, and the transfer amount by referring to the master file. Transfer slips created based on these data are, for example, as shown in FIG. 12, account items, abbreviations, cost codes, amounts, and bank account information aggregated for each transfer date and utility charge type. Is.

Next, an outline of processing by the charge transfer processing system will be described. 13 is a diagram for explaining the flow of the entire process by the charge transfer processing system, FIG. 14 is a diagram for explaining an example of transfer data matching process, and FIG. 15 is a diagram for explaining an example of transfer slip creating process. Is.

As shown in FIG. 13, when the bill transfer processing system according to the present invention transmits, from a financial institution, public bill detail data (transfer data), for example, one business day before, it is fetched and received through the communication control unit. Edit the data, check for errors, create a charge transfer details file,
The charge transfer details checklist is output (charge details data reception process, step S11). Then, the transfer data matching process with the master file is performed to create a charge transfer detail history file (step S12). next,
Transfer data approval processing is performed (step S13). In this transfer data approval process, in order to confirm the transfer amount and transfer count of the transfer data for the next business day, for example, the transfer date, branch name, transfer amount, and transfer count are displayed on the screen, and the transfer date, branch name, and transfer count are displayed. A fee account fund allowance request form consisting of the amount, the number of transfers, the bank (branch name, account type, account number / name), and transfer number is printed out. This is to be sent to the finance department, for example, for funding. Next, the transfer slip creation process creates transfer slips for each business office
Cost data is created in the financial accounting system and transfer data is confirmed (step S14). Then, the transfer data transmission process extracts the data for the next day transfer from the charge transfer statement history file to create the total transfer data, and transmits it to the financial institution (step S15). General transfer data includes, for example, type code, date of engagement, destination bank (destination bank code, destination bank name, destination branch code, destination branch name, deposit item, account number), destination bank (destination bank code, destination bank). Name, destination branch code, destination branch name, deposit item, account number, transfer amount), and telegraph category.

In the transfer data matching process, for example, as shown in FIG. 14, the customer numbers of the charge transfer specification file are sorted (step S21) and the master file is matched (step S22). Then, it is checked whether or not the customer number of the charge transfer detailed file is in the master file (step S23), and if the master file has the customer number, the data is output to the charge transfer detailed history file (step S24). If there is no customer number, it is output to the charge transfer details history file as an undecided temporary payment (step S25). Then, for example, aggregated data of transfer account, branch, transfer amount, transfer count, etc. are displayed on the display screen as information for confirmation (step S26).

In the transfer slip creation process, for example, as shown in FIG.
As shown in FIG. 5, branch and next business transfer date are set as search conditions (step S31), and data is extracted from the charge transfer detail history file (step S32). Next, the utility bill code, the storing agency code, and the abbreviation code are sorted in ascending order (step S33), and a transfer slip is created (step S34). Further, cost data for the financial accounting system is created (step S35). As this transfer slip,
For example, it has items such as transfer date, accounting slip number, account item, oral account item (abbreviated name), cost classification (symbol, element, expense item), transfer amount, storage institution name, etc. Created in units of the type and head office. Also, as the cost data, head office code, trial calculation number, slip number, account item code, abbreviation code, cost classification (symbol, element, expense item),
It has items such as transfer amount and tax exemption category.

The present invention is not limited to the above embodiment, but various modifications can be made. For example, in the above-described embodiment, the description has been made with respect to the transfer processing of the public charges, but the transfer processing of other charges may be applied. Further, although the billing data for each payment date is created one business day before, all billing data for each payment date on each day after the next business day may be created and output. It goes without saying that the names, etc. are changed appropriately according to the business content, accounting system and other circumstances. Further, the processing data to be displayed and printed while receiving the charge detail data and transmitting the total transfer data are also appropriately changed according to the management system of the corporation. As a charge transfer processing system, a plurality of terminals for inputting operations, displaying processing data, and printing out may be connected to each other by a LAN or the like and provided in respective departments in charge such as an accounting department and a finance department.

[0039]

As is apparent from the above description, according to the present invention, the contractor number is extracted based on the position information of the contractor number of the billing data issued by each billing institution, and the fee type, Contractor, stores the billing amount for each payment date and stores it in a data file that stores the billing amount of the corresponding payment date when billing data is issued from the billing institution,
Since the billing data for each payment date is created one business day before the payment date based on the calendar, it is possible for a company to collectively process various charges nationwide based on the contractor number.

Further, the charge detail data consisting of the charge transfer date, the billing institution, the burdening institution, and the transfer amount is input and the processing required for the charge transfer is executed to create the transfer slip, the cost data, and the total charge transfer data. Since this is output, it is possible to reduce the administrative burden on business sites such as on-site and on-site organizations. Moreover, because payments can be made on time, payment interest can be eliminated due to prepaid payments.
Since there is no delay in payment, overdue payments can be eliminated, and extra expenses incurred when paying fees can be saved. Furthermore, since the payment slip can be eliminated and the number of slips can be greatly reduced, it is possible to reduce the storage space by making paperless and reducing the storage documents. On the other hand, financial institutions can save clerical work and increase commission income by concentrating accounts, and service supply companies can also save clerical work.

[Brief description of drawings]

FIG. 1 is a diagram showing an embodiment of a billing data processing system according to the present invention.

FIG. 2 is a diagram for explaining a filtering process and a matching process of billing data.

FIG. 3 is a diagram illustrating a specific configuration example of a filter processing unit.

FIG. 4 is a diagram illustrating a configuration example of a billing data issuance processing unit in payment date units, which is performed when billing data is received.

FIG. 5 is a diagram showing an example of the structure of a payment date management data file used in the process of issuing billing data on a payment date basis.

FIG. 6 is a diagram showing an outline of a system including a plurality of billing institutions, financial institutions, and burden institutions.

FIG. 7 is a diagram showing an embodiment of a charge transfer processing system according to the present invention.

FIG. 8 is a diagram showing a configuration example of charge transfer detailed data.

FIG. 9 is a diagram showing a configuration example of a charge transfer detailed file.

FIG. 10 is a diagram for explaining information about a billing organization and a burden organization.

FIG. 11 is a diagram for explaining each file and data flow created from the charge detail data.

FIG. 12 is a diagram showing an example of a transfer slip.

FIG. 13 is a diagram showing a flow of overall processing by the charge transfer processing system.

FIG. 14 is a diagram for explaining an example of transfer data matching processing.

FIG. 15 is a diagram illustrating an example of a transfer slip creation process.

FIG. 16 is a diagram for explaining an example of a conventional utility bill payment system.

[Explanation of symbols]

1 ... Billing data creation processing unit, 2 ... Billing notification issuance processing unit, 3 ... Billing data receiving unit, 4 ... Deduction processing unit, 5
... Filter processing unit, 6 ... Billing data reception processing unit, 7 ...
Matching processing unit, 8 ... Burden account master, 9 ... Accounting process, 10 ... Fund allowance, 11 ... Accounting data, 12 ... Transfer slip

─────────────────────────────────────────────────── ─── Continuation of the front page (72) Inventor Toshiyuki Furuya 1-3-2 Shibaura, Minato-ku, Tokyo Shimizu Construction Co., Ltd. (56) Reference JP-A-7-325874 (JP, A) 9-504634 (JP, A) US Patent 5483445 (US, A) US Patent 5699528 (US, A) (58) Fields investigated (Int.Cl. ⁷ , DB name) G06F 17/60 G06F 19/00

Claims (3)

(57) [Claims] 1. A billing data processing system which receives billing data of various charges including a contractor code from a billing institution of various charges and performs transfer and billing processing, wherein the billing institution includes a contractor code. Specific format
A contractor code extraction table in which the contractor code position information and unnecessary data position information are set as extraction information for extracting the contractor code from the billing data of
Filter means for extracting the contractor code from the billing data received by the billing data receiving means by referring to the contractor code extraction table; and a burden storing a burden account including an account item for each contractor code. Matching processing means that has an account master and performs matching processing between the contractor code extracted by the filter means and the burden account master to create a transfer list or transfer slip necessary for accounting processing of the billing data; It has a data file for storing and accumulating the fee type, each contractor, and the billing amount for each day, and the billing data and the filtering process accepted by the billing data receiving means.
Billing data creating means for creating billing data for each payment date by storing the fee type, each subscriber, and the billing amount in the data file based on the contractor code extracted by the step, A billing data processing system, which is configured to output the billing list, billing slips, and billing data for each payment date as accounting processing data for billing. 2. The billing data creating means collects billing data for each paying date one business day before the paying date based on the data file storing the type of charge, each contractor, and the billing amount and the calendar for each paying date. The billing data processing system according to claim 1, which is created. 3. The billing data processing system according to claim 1, wherein the contractor code extraction table registers the billing data format for each billing institution and financial institution.