JP2022104542A - Fee processing apparatus, fee processing method and fee processing program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To reduce human errors and a workload when a rental guarantee company remits an administrative fee of a guarantee fee to a plurality of remittance destinations.

SOLUTION: A fee processing apparatus according the present embodiment includes: a master for registering service identification information for identifying types of rent guarantee, one or a plurality of remittance destinations of administrative fees of guarantee fees, and shares of the respective remittance destinations, contract input means for inputting contract data including contract identification information, names of customers, service identification information, rents, and the guarantee fees, and remittance processing means acquiring the share of each remittance destination from the master, with the service identification information of the contract data used as a key, calculating the amount of remittance of each remittance destination based on the contract data and acquired share of each remittance destination and creating remittance data including the amount of remittance of each remittance destination for every contract.

SELECTED DRAWING: Figure 1

COPYRIGHT: (C)2022,JPO&INPIT

Description

The present invention relates to a fee processing device, a fee processing method, and a fee processing program.

For example, in the rent guarantee industry, the real estate management company does not conclude a lease contract directly with the lessee, but concludes a guarantee contract in the form of introducing the rent guarantee company to the lessee, so an administrative fee is charged as a referral fee. Occurs. Conventionally, as a system related to rent guarantee, for example, there is Patent Document 1.

Japanese Unexamined Patent Publication No. 2017-123111

However, Patent Document 1 does not describe anything about reducing human error and work burden when the rent guarantee company distributes and remits the administrative fee of the guarantee fee to a plurality of remittance destinations.

The present invention has been made in view of the above, and is a fee processing device capable of reducing human error and business burden when a rent guarantee company remits an administrative fee for a guarantee fee to a plurality of remittance destinations. The purpose is to provide a fee processing method and a fee processing program.

In order to solve the above-mentioned problems and achieve the object, the present invention is a fee processing device including a storage unit and a control unit for the rent guarantee company to calculate the administrative fee of the guarantee fee, and the storage unit. A master that registers service identification information for identifying the type of rent guarantee, one or more remittance destinations of the administrative fee of the guarantee fee, and the share of each remittance destination is stored in the control. The department uses the contract input means for inputting contract data including contract identification information, customer name, service identification information, rent, and guarantee fee as a key, and the service identification information of the contract data as a key, and the share of each remittance destination from the master. With a remittance processing means that calculates the remittance amount of each remittance destination based on the contract data and the acquired share of each remittance destination, and creates remittance data including the remittance amount of each remittance destination for each contract. It is characterized by having.

Further, according to one aspect of the present invention, the control unit may further include a payment processing means for creating payment data in which the remittance amount is aggregated for each remittance destination based on the remittance data.

Further, according to one aspect of the present invention, the share of the master may be set at a fixed rate or a ratio.

Further, according to one aspect of the present invention, the remittance destination may include a real estate management company and an intermediary company.

Further, in order to solve the above-mentioned problems and achieve the object, the present invention is a fee processing method executed by an information processing apparatus provided with a storage unit and a control unit, and the storage unit is provided with a rent guarantee. A master that registers service identification information for identifying the type of contract, one or more remittance destinations of the administrative fee of the guarantee fee, and the share of each remittance destination is stored, and is executed by the control unit. , Contract input process for inputting contract data including contract identification information, customer name, service identification information, rent, and guarantee fee, and acquisition of each remittance destination's share from the master using the service identification information of the contract data as a key. Then, based on the contract data and the acquired share of each remittance destination, the remittance amount of each remittance destination is calculated, and the remittance processing process of creating the remittance data including the remittance amount of each remittance destination for each contract is performed. It is characterized by including.

Further, in order to solve the above-mentioned problems and achieve the object, the present invention is a fee processing program for causing an information processing apparatus provided with a storage unit and a control unit to execute the data, and the storage unit is charged with rent. A master that registers service identification information for identifying the type of guarantee, one or more remittance destinations of the administrative fee of the guarantee fee, and a share of each remittance destination is stored, and the contract is made in the control unit. Using the contract input process for inputting contract data including identification information, customer name, service identification information, rent, and guarantee fee, and the service identification information of the contract data as keys, the share of each remittance destination is acquired from the master. , Calculate the remittance amount of each remittance destination based on the contract data and the acquired share of each remittance destination, and execute the remittance processing process to create the remittance data including the remittance amount of each remittance destination for each contract. It is characterized by being a fee processing program for.

According to the present invention, when the rent guarantee company remits the administrative fee of the guarantee fee to a plurality of remittance destinations, it is possible to reduce human error and business burden.

FIG. 1 is a diagram showing an example of the configuration of the fee processing device of the present embodiment. FIG. 2 is a diagram showing a configuration example of a service master and a business partner master. FIG. 3 is a diagram showing a flow for explaining an example of the entire processing procedure of the control unit of the fee processing device according to the present embodiment. FIG. 4 is a diagram for explaining a specific example of processing of the control unit of the fee processing device according to the present embodiment.

Hereinafter, the fee processing apparatus, the fee processing method, and the embodiment of the fee processing program according to the present invention will be described in detail with reference to the drawings. The present invention is not limited to this embodiment.

[1. Overview]
For example, in the rent (rental) guarantee industry, the real estate management company does not conclude a lease contract directly with the lessee, but concludes a guarantee contract in the form of introducing the rent guarantee company to the lessee. As an administrative fee is incurred. Here, the administrative fee is an expense item of cost, and is a fee paid by the rent guarantee company to the management company from among the guarantee fees collected from the contractor.

Recently, products are diversifying as it is becoming more common to ask a rent guarantee company instead of a guarantor. Most of the cases of remittance of administrative fees for guarantee fees are for one management company, but depending on the product, the intermediary company may have a share, and remittance to the parent company of the group company is required. Since there are various patterns of products, rent guarantee companies are required to deal with them. Due to the business nature of guarantees, there are many stakeholders who appear, so there is a possibility that the number of remittance targets will increase in the future.

However, solutions for the rent guarantee industry have not been distributed in the industry so far.
Regarding remittance of administrative fees related to services that require distribution, there are problems that it is necessary to manually correct the remittance data, and because the transaction volume is large, human errors such as calculation errors occur and the work burden is heavy. there were.

Therefore, when the rent guarantee company distributes the administrative fee of the guarantee fee to multiple remittance destinations, in order to reduce human error and business burden, the share of the administrative fee of the guarantee fee is mastered for each of multiple remittance destinations. Set to.

In this way, it was necessary to correct the remittance data for the remittance of administrative fees related to services that require distribution, but human error can be prevented by mastering the share of administrative fees for each service. It will be possible. In addition, since the above contents increase the amount of work as the number of service transactions increases, it is possible to contribute to the improvement of work efficiency by being included in the system.

[2. Constitution]
The configuration of the fee processing device 100 according to the present embodiment will be described with reference to FIG. FIG. 1 is a block diagram showing an example of the configuration of the fee processing device 100 according to the present embodiment. The fee processing device 100 according to the present embodiment can be suitably used in, for example, a rent guarantee company or the like.

The fee processing device 100 is a workstation, a commercially available desktop personal computer, or the like. The fee processing device 100 is not limited to a stationary information processing device such as a desktop personal computer, but is a portable type such as a commercially available notebook personal computer, a PDA (Personal Digital Assistants), a smartphone, or a tablet personal computer. It may be an information processing device.

As shown in FIG. 1, the fee processing device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each part of the fee processing device 100 is communicably connected via an arbitrary communication path.

The communication interface unit 104 connects the fee processing device 100 to the network 300 so as to be communicable via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with another device via a communication line. Here, the network 300 has a function of connecting the fee processing device 100 and the server 200 and the like so as to be communicable with each other, and is, for example, the Internet, a LAN (Local Area Network), or the like. The data stored in the storage unit 106, which will be described later, may be stored in the server.

An input device 112 and an output device 114 are connected to the input / output interface unit 108. As the output device 114, a speaker or a printer can be used in addition to a monitor (including a home television). As the input device 112, a keyboard, a mouse, and a microphone, as well as a monitor that cooperates with the mouse to realize a pointing device function can be used. In the following, the output device 114 may be referred to as a monitor 114, and the input device 112 may be described as a keyboard 112 or a mouse 112. Further, the user displaying on the screen of the output device (monitor) 114 and operating the input device 112 may be described as "user operation via UI".

Various databases, tables, files, and the like are stored in the storage unit 106. In the storage unit 106, a computer program for giving an instruction to a CPU (Central Processing Unit) in cooperation with an OS (Operating System) to perform various processes is recorded. As the storage unit 106, for example, a memory device such as a RAM (Random Access Memory) / ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, an optical disk, or the like can be used.

The storage unit 106 includes a service master 106a, a business partner master 106b, a data file 106c, and the like. FIG. 2 is a diagram showing a configuration example of the service master 106a and the business partner master 106b.

The service master 106a sets the service identification information (service CD and / or service content) for identifying the type of rent guarantee, one or more remittance destinations of the administrative fee of the guarantee fee, and the share of each remittance destination. It is a master to do. As shown in FIG. 2, the service master 106a is a service CD, service content, guarantee fee rate, management company share, distribution data which is the share of each remittance destination (head office other company 1 (CD, share), other company 2 ( It can be composed of a table or the like registered in association with data of other companies 3 (CD, share), etc. The share may be fixed or may be set as a ratio to the deposit or rent. Here, the guarantee fee includes various guarantee fees such as an initial guarantee fee, a renewal guarantee fee, and an additional guarantee fee.

As shown in FIG. 3, the business partner master 106b can be configured by a table or the like in which the business partner CD and the data of the business partner name are registered in association with each other. The financial transaction master 106b is used, for example, for display, and the financial transaction name is read out and displayed using the financial transaction CD as a key.

The data file 106c is a file for storing various data such as contract data, billing data, remittance data, and payment data.

The contract data may include data such as contract CD, customer name (lessee name), service CD, service content, rent, and guarantee fee, which are contract identification information (see FIG. 4).

The billing data may include data such as a contract CD, a customer name, a billing month, and a billing amount (see FIG. 4).

The remittance data may include data such as contract CD, customer name, remittance month, and business consignment fee (breakdown: management company remittance amount, other company's 1 remittance amount, other company's 2 remittance amount, etc.) (Fig. 4). reference).

The payment data may include data on the payee CD, payee name, remittance month, and remittance amount (see FIG. 4).

Returning to FIG. 1, the control unit 102 is a CPU or the like that collectively controls the fee processing device 100. The control unit 102 has an internal memory for storing a control program such as an OS, a program that defines various processing procedures, required data, and the like, and performs various information processing based on these stored programs. Run. The control unit 102 functionally includes a master maintenance unit 102a, a contract input unit 102b, a billing processing unit 102c, a remittance processing unit 102d, a payment processing unit 102e, and a screen display control unit 102f. ..

For example, the master maintenance unit 102a edits data input / change / addition of the service master 106a and the business partner master 106b in response to an operator operation on the master maintenance screen (not shown) displayed on the monitor 114. I do.

The contract input unit 102b, for example, responds to an operator's operation on an input screen (not shown) displayed on the monitor 114, such as a contract CD, customer name, service identification information, rent, and guarantee fee, which are contract identification information. The contract data including the above is input and stored in the data file 106c.

The billing processing unit 102c creates billing data including a contract CD, a customer name, a billing month, a billing amount, and the like based on the contract data, and stores the billing data in the data file 106c.

The remittance processing unit 102d acquires the share of each remittance destination from the service master 106a using the service CD of the contract data as a key, and the remittance amount of each remittance destination based on the contract data and the acquired share of each remittance destination. Is calculated, remittance data including the remittance amount of each remittance destination for each contract is created, and stored in the data file 106c.

The payment processing unit 102e creates payment data in which the remittance amount of each remittance destination of the remittance data is aggregated, and stores it in the data file 106c. The payment processing unit 102e may, for example, remit money to each remittance destination using EB based on the created payment data.

The screen display control unit 102f controls the display of various input screens to be displayed on the monitor 114 and the reception of the input.

[3. Specific example of processing]
A specific example of the processing of the control unit 102 of the fee processing device 100 in the present embodiment will be described with reference to FIGS. 1 to 4. FIG. 3 is a diagram showing a flow for explaining an outline of the entire processing of the control unit 102 of the fee processing device 100 in the present embodiment. FIG. 4 is a diagram for explaining a specific example of processing of the control unit 102 of the fee processing device 100 in the present embodiment.

(Overall processing)
With reference to FIG. 3, the outline of the entire processing of the control unit 102 of the fee processing apparatus 100 in the present embodiment will be described. In FIG. 3, the master maintenance unit 102a executes the service master maintenance process (step S1). Specifically, in the service master maintenance process, the master maintenance unit 102a sets the data of the service master 106a according to the operation of the operator on the master maintenance screen (not shown) displayed on the monitor 114, for example. .. That is, the distribution of the administrative fee related to the deposit is set in the service master 106a.

The contract input unit 102b executes the contract input process (step S2). Specifically, in the contract input process, the contract input unit 102b receives, for example, a contract CD, a customer name, and service identification information in response to an operator's operation on an input screen (not shown) displayed on the monitor 114. The contract data including the rent and the guarantee fee is input and stored in the data file 106f.

The billing processing unit 102c executes billing processing (step S3). Specifically, in the billing process, the billing processing unit 102c creates billing data including the contract CD, customer name (lessee name), billing month, billing amount, etc. based on the contract data, and creates the billing data in the data file 106f. Store.

The remittance processing unit 102d executes the management company settlement data creation process (step S4). The management company settlement data creation process is executed after the guarantee fee is collected from the lessee. Specifically, in the management company settlement data creation process, the remittance processing unit 102d acquires the share of each remittance destination from the service master 106a using the service CD of the contract data as a key, and obtains the contract data and each remittance acquired. Based on the previous share, the remittance amount of each remittance destination is calculated, remittance data including the remittance amount of each remittance destination for each contract is created, and stored in the data file 106c.

The payment processing unit 102e executes payment processing (step S5). Specifically, in the payment process, the payment processing unit 102e creates payment data in which the remittance amount of each remittance destination of the remittance data is aggregated and stores it in the data file 106c. The payment processing unit 102e may, for example, remit money to each remittance destination using EB based on the created payment data.

A specific example of the processing of the control unit 102 of the fee processing device 100 in the present embodiment will be described with reference to FIG.

(Master maintenance processing)
The master maintenance unit 102a sets the data of the service master 106a according to the operation of the operator on the master maintenance screen (not shown) displayed on the monitor 114, for example.

FIG. 4A is a diagram showing an example of data setting of the service master 106a. In the example of the service master 106a shown in FIG. 4A, the first line is the service CD "001", the service content "OB guarantee service", the guarantee fee rate "50%", the management company share "20%", and the distribution. Ratio (Headquarters "15%", other company 1 (CD "102", share "5%")), the second line is service CD "002", service content "OB guarantee service: student", guarantee fee rate "30" % ”, Management company share“ 10% ”, distribution ratio (headquarters“ 8% ”, other company 1 (CD“ 102 ”, share“ 1% ”, other company 2 (CD“ 103 ”, share“ 1% ”” ).

FIG. 4B is a diagram showing an example of data setting of the customer master 106b. In the example of the customer master 106b shown in FIG. 4 (B), the first line is the customer CD "101", the customer name "management company", and the second line is the customer CD "102", the customer name. "Intermediary company A", the third line is the business partner CD "103", and the business partner name "intermediary company B".

(Contract input processing)
In the contract input process, the contract input unit 102b inputs contract data and stores it in the data file 106f, for example, in response to an operator's operation on an input screen (not shown) displayed on the monitor 114.

FIG. 4C is a diagram showing an example of contract data. In the example of the contract data shown in FIG. 4C, the first line is the contract CD "001", the customer name "Taro Tanaka", the service CD "001", the service content "OB guarantee service", and the rent "100,000". , Guarantee fee "50,000", the second line is contract CD "002", customer name "Yokohama Jiro", service CD "002", service content OB "guarantee service: student", rent "100,000" , The guarantee fee is "30,000".

(Billing process)
The billing processing unit 102c creates billing data based on the contract data and stores it in the data file 106f.

FIG. 4D is a diagram showing an example of billing data. In the example of billing data shown in FIG. 4 (D), the first line is the contract CD "001", the customer name "Taro Tanaka", the billing month "2020/11", and the billing amount "150,000". , Contract CD "002", customer name "Yokohama Jiro", billing month "2020/11", billing amount "130,000".

(Management company settlement data creation process)
The remittance processing unit 102d acquires the share of each remittance destination from the service master 106a using the service CD of the contract data as a key, and the remittance amount of each remittance destination based on the contract data and the acquired share of each remittance destination. Is calculated, remittance data including the remittance amount of each remittance destination for each contract is created, and registered in the data file 106c.

FIG. 4E is a diagram showing an example of remittance data. In the example of remittance data shown in FIG. 4 (E), the first line is the contract CD "001", the customer name "Taro Tanaka", the remittance month "2020/12", and the business consignment fee "20,000" (breakdown: The management company remittance is "15,000", the other company's remittance is "5,000",). Here, the business consignment fee is calculated by the business consignment fee "20,000" = rent "100,000" x management company share "20%". The management company remittance amount is calculated by the management company remittance amount "15,000" = rent "100,000" x share "15%". The amount of money sent by another company is calculated by multiplying the amount of money sent by another company "5,000" = rent "100,000" x share "15%".

The second line is the contract CD "002", customer name "Yokohama Jiro", remittance month "2020/12", business consignment fee "10,000" (breakdown: management company remittance "8,000", other company's remittance 1 remittance " "1,000", 2 remittances from other companies "1,000"). Here, the business consignment fee is calculated by the business consignment fee "10,000" = rent "100,000" x share "10%". The management company remittance amount is calculated by the management company remittance amount "8,000" = rent "100,000" x share "8%". The amount of money sent by another company is calculated by multiplying the amount of money sent by another company "1,000" = rent "100,000" x share "1%". The amount of 2 remittances of other companies is calculated by the amount of 2 remittances of other companies "1,000" = rent "100,000" x share "1%".

The total remittance amount is the management company remittance amount "23,000", the other company's 1 remittance amount "6,000", and the other company's 2 remittance amount "1,000".

(Payment processing)
The payment processing unit 102e creates payment data in which the remittance amount of each remittance destination of the remittance data is aggregated, and stores the payment data in the data file 106c.

FIG. 4F is a diagram showing an example of payment data. In the example of payment data shown in FIG. 4 (F), the first line is the payee CD "101", the payee name "management company", the remittance month "2020/12", the remittance amount "23,000", and 2 The line is the payee CD "102", the payee name "intermediary company A", the remittance month "2020/12", the remittance amount "6,000", and the third line is the payee CD "103", the payee. The name is "Intermediary Company B", the remittance month is "2020/12", and the remittance amount is "1,000".

As described above, according to the present embodiment, the service identification information for identifying the type of rent guarantee, one or more remittance destinations of the administrative fee of the guarantee fee, and the share of each remittance destination are provided. From the service master 106a using the registered service master 106a, the contract input unit 102b for inputting the contract data including the contract identification information, the customer name, the service identification information, the rent, and the guarantee fee, and the service identification information of the contract data as keys. Acquire the share of each remittance destination, calculate the remittance amount of each remittance destination based on the contract data and the acquired share of each remittance destination, and create remittance data including the remittance amount of each remittance destination for each contract. Since the rent guarantee company is provided with a remittance processing unit 102d, it is possible to reduce human error and work burden when the rent guarantee company remits the administrative fee of the guarantee fee to a plurality of remittance destinations.

[4. Contribution to the United Nations-led Sustainable Development Goals (SDGs)]
Since this embodiment can contribute to improving business efficiency and promoting appropriate management decisions of companies, it is possible to contribute to the goals 8 and 9 of the SDGs.

In addition, the present embodiment can contribute to the reduction of waste loss and the promotion of paperless and computerization, and thus can contribute to the goals 12, 13 and 15 of the SDGs.

In addition, since this embodiment can contribute to the strengthening of control and governance, it is possible to contribute to the goal 16 of the SDGs.

[5. Other embodiments]
In addition to the above-described embodiments, the present invention may be implemented in various different embodiments within the scope of the technical idea described in the claims.

For example, among the processes described in the embodiments, all or part of the processes described as being automatically performed may be manually performed, or the processes described as being manually performed may be performed. All or part of it can be done automatically by a known method.

In addition, processing procedures, control procedures, specific names, information including parameters such as registration data and search conditions for each processing, screen examples, and database configurations shown in this specification and drawings are not specified unless otherwise specified. Can be changed arbitrarily.

Further, with respect to the fee processing device 100, each component shown in the figure is a functional concept and does not necessarily have to be physically configured as shown in the figure.

For example, with respect to the processing functions included in the fee processing apparatus 100, particularly each processing function performed by the control unit 102, all or any part thereof is realized by the CPU and a program interpreted and executed by the CPU. It may be realized as hardware by wired logic. The program is recorded on a non-temporary computer-readable recording medium including a programmed instruction for causing the information processing apparatus to execute the processing described in the present embodiment, and the fee processing apparatus is required. Read mechanically to 100. That is, a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or an HDD (Hard Disk Drive). This computer program is executed by being loaded into RAM, and cooperates with the CPU to form a control unit.

Further, this computer program may be stored in an application program server connected to the fee processing device 100 via an arbitrary network, and all or part of the computer program may be downloaded as needed. be.

Further, the program for executing the process described in the present embodiment may be stored in a non-temporary computer-readable recording medium, or may be configured as a program product. Here, the "recording medium" includes a memory card, a USB (Universal Serial Bus) memory, an SD (Secure Digital) card, a flexible disk, a magneto-optical disk, a ROM, an EPROM (Erasable Programmable Read Only Memory), and an EEPROM (registration). Trademarks) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magnet-Optical Disk), MO (Magnet-Optical Disk), DVD (Digital), DVD (Digital) It shall include any "portable physical medium".

Further, the "program" is a data processing method described in any language or description method, regardless of the format such as source code or binary code. The "program" is not necessarily limited to a single program, but is distributed as multiple modules or libraries, or cooperates with a separate program represented by the OS to achieve its function. Including things. It should be noted that well-known configurations and procedures can be used for the specific configuration and reading procedure for reading the recording medium and the installation procedure after reading in each device shown in the embodiment.

Various databases and the like stored in the storage unit 106 are memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and storage means such as optical disks, and are used for various processes and website provision. Stores programs, tables, databases, files for web pages, etc.

Further, the fee processing device 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device to which an arbitrary peripheral device is connected. Further, the fee processing device 100 may be realized by mounting software (including a program or data) that realizes the processing described in the present embodiment on the device.

Furthermore, the specific form of distribution / integration of the device is not limited to that shown in the figure, and all or part of the device may be functionally or physically in any unit according to various additions or functional loads. It can be distributed and integrated. That is, the above-described embodiments may be arbitrarily combined and implemented, or the embodiments may be selectively implemented.

100 Fee processing device 102 Control unit 102a Master maintenance unit 102b Contract input unit 102c Billing processing unit 102d Remittance processing unit 102e Payment processing unit 102f Screen display control unit 104 Communication interface unit 106 Storage unit 106a Service master 106b Customer master 106c Data file 108 Input / output interface unit 112 Input device 114 Output device 300 Network

Claims (1)

It is a fee processing device equipped with a storage unit and a control unit for the rent guarantee company to calculate the administrative fee of the guarantee fee.
In the storage unit
A master that registers service identification information for identifying the type of rent guarantee, one or more remittance destinations of the administrative fee of the guarantee fee, and the share of each remittance destination is stored.
The control unit
A contract input means for inputting contract data including contract identification information, customer name, service identification information, rent, and guarantee fee,
Using the service identification information of the contract data as a key, the share of each remittance destination is acquired from the master, the remittance amount of each remittance destination is calculated based on the contract data and the acquired share of each remittance destination, and the contract is made. A remittance processing method that creates remittance data including the remittance amount of each remittance destination,
A fee processing device characterized by being equipped with.

Images