JP7121490B2 - Deposit management device, deposit management method, and deposit management program - Google Patents

Description

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

For example, in real estate leasing, the lessee generally deposits various expenses into the account of the lessor's financial institution (see Patent Document 1, for example). In addition, the lessor may maintain separate accounts with financial institutions for multiple items billed to the lessee (eg, rent, contract fee, renewal fee, etc.). In that case, the lessee is required to deposit the total billing amount of the corresponding billing items for each account.

JP 2016-146166 A

However, in the case of the above-described prior art, the lessor could not easily check whether or not the sum of the billing amounts of the corresponding billing items had been properly credited for each account.

Accordingly, the present invention has been made in view of the above problems, and provides a deposit management device, a deposit management method, and a deposit management method capable of checking the correctness of deposit amounts for each of a plurality of accounts that accept deposits related to rental. The purpose is to provide a management program.

In order to solve the above-described problems and achieve the object, a deposit management device according to the present invention is a deposit management device comprising a storage unit and a control unit, wherein the storage unit stores a first correspondence relationship for storing first correspondence information indicating a correspondence relationship between a plurality of billing items indicating the type of lease of the billed amount to be billed by the lessor and a plurality of accounts of the financial institution held by the lessor; information storage means; second correspondence information storage means for storing second correspondence information indicating a correspondence relationship between the amount billed by the lessor to the lessee and the billing item; wherein the control unit includes acquisition means for acquiring deposit information including information on the account into which the deposit was made by the lessee and the deposit amount, and depositing the same account indicated by the second correspondence information The acquiring means acquires whether or not the total amount of the billing amount of each of the billing items as an account has been deposited into the deposit account of each of the billing items indicated by the first correspondence information. Judgment means for judging based on the account to which the lessee made the deposit and the amount of deposit, which are included in the deposit information, and if the judgment means determines that the deposit amount does not match, a predetermined message and output means for outputting the deposit information.

Further, in the deposit management apparatus according to the present invention, the acquisition means acquires the deposit information via an EB service, and before the deposit information is captured by the receipt processing in the deposit management apparatus, the determination means performs the above determination.

In addition, the deposit management method according to the present invention comprises: a plurality of billing items indicating the type of the amount billed by the lessor to the lessee in the lease; and a plurality of financial institution accounts held by the lessor. A first correspondence information storage unit for storing first correspondence information indicating a correspondence relationship; and a second correspondence relationship information storage means for storing correspondence relationship information of No. 2, wherein the deposit management method is executed by a deposit management device having a storage unit, wherein the account into which the lessee deposits money and an acquisition step of acquiring payment information including payment amount information; The account to which the lessee made the payment and the amount of the payment, included in the payment information acquired in the acquisition step, to determine whether or not the payment was made to the payment account for each of the billing items indicated by the relevant information. and an output step of outputting a predetermined message and the deposit information when the determination step determines that the deposit amounts do not match.

In addition, the deposit management program according to the present invention includes a plurality of billing items indicating the type of the amount billed by the lessor to the lessee in the lease, and a plurality of financial institution accounts held by the lessor. A first correspondence information storage unit for storing first correspondence information indicating a correspondence relationship; Acquiring payment information including information on the account and the amount of payment made by the lessee to a computer provided with a storage unit having a second correspondence information storage means for storing the correspondence information of 2. and obtaining the sum of the amounts charged for each of the billing items indicated by the second correspondence information and having the same account as the deposit account of each of the billing items indicated by the first correspondence information. a determination step of determining whether or not the deposit has been made to the deposit account based on the account into which the deposit was made by the lessee and the amount of deposit, which are included in the deposit information acquired in the acquisition step; If the step determines that the deposit amounts do not match, an output step of outputting a predetermined message and the deposit information is executed.

ADVANTAGE OF THE INVENTION According to this invention, it is effective in being able to check the correctness of the payment amount for every several account which receives the payment regarding rental.

FIG. 1 is a block diagram showing an example of the configuration of a deposit management device according to an embodiment. FIG. 2 is a diagram showing an example of an account master in the embodiment. FIG. 3 is a diagram showing an example of a code name master in the embodiment. FIG. 4 is a diagram showing examples of collection schedule data, deposit data, and error check worktables in the embodiment. FIG. 5 is a diagram showing another example of collection schedule data, deposit data, and error check worktables in the embodiment. FIG. 6 is a flow chart showing an example of processing by the deposit management device in the embodiment. FIG. 7 is a diagram showing an example of an EB deposit data capture error list in the embodiment.

BEST MODE FOR CARRYING OUT THE INVENTION Hereinafter, embodiments of the present invention will be described in detail with reference to the drawings. In addition, this invention is not limited by this embodiment. Also, hereinafter, the "deposit account" may be simply referred to as the "account".

[1. Overview]
In this embodiment, in real estate leasing, a lessor (e.g., a building owner company) bills a plurality of items (e.g., rent, contract fee, renewal fees, etc.) are assumed to hold separate accounts at financial institutions. In that case, the Lessee must deposit the total billed amount of the corresponding billing items for each account. Also, in recent years, EB (Electronic Banking) services, which are financial (for example, bank) transaction services via networks, have become widespread. In this embodiment, this EB service is used.

Conventionally, when using an EB service, account information is included in the EB deposit data itself, which is the data of deposit by the EB service. Regardless of the billing item, it was taken and processed (capture processing). Therefore, the lessor cannot easily check whether or not the sum of the billed amounts of the corresponding billing items has been correctly deposited for each of the multiple accounts that accept deposits related to rental.

In this embodiment, the deposit management device stores correspondence information between billing items and accounts, and correspondence information between billing amounts and billing items. It is possible to easily determine whether or not the payment amount matches the If the sum of the billed amount for each account does not match the received amount, the deposit management device outputs an error list assuming that there was an error in the deposit. Therefore, the user of the deposit management apparatus can easily and quickly recognize the deposit error.

[2. Constitution]
The configuration of the deposit management device 100 according to the embodiment will be described with reference to FIG. FIG. 1 is a block diagram showing an example of the configuration of deposit management device 100 in the embodiment. The received money management apparatus 100 includes a storage unit 106 that stores various information, a control unit 102 that controls the entire received money management apparatus 100, and a communication unit for communicating with an external device such as the server 200 via the network 300. An input/output interface unit 108 that performs interface operations between the communication interface unit 104 and various input devices 112 such as keyboards, tablets, mice, microphones, and cameras, and various output devices 114 such as printers, displays, and speakers. and have.

In this case, deposit management apparatus 100 is configured as, for example, a desktop personal computer, but is not limited to this, and is portable such as notebook personal computers, PDAs (Personal Digital Assistants), smart phones, and tablet personal computers. It is also possible to take the form of an information processing device.

The communication interface unit 104 communicably connects the deposit management apparatus 100 to the network 300 via a communication device such as a router and a wired or wireless local communication network 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 deposit management apparatus 100 and the server 200 so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network). Note that data stored in the storage unit 106 to be described later may be stored in the server 200 .

The storage unit 106 stores various databases, various tables, various files, and the like. For example, the storage unit 106 stores a computer program for cooperating with an OS (Operating System) to give instructions to an MPU (Micro Processing Unit) to perform various processes. The storage unit 106 is configured, for example, as a memory device such as a RAM (Random Access Memory) or a ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, an optical disk, or the like.

The storage unit 106 holds an account master 106a, a code name master 106b, collection schedule data 106c, deposit data 106d, and an error check worktable 106e.

FIG. 2 is a diagram showing an example of the account master 106a in the embodiment. The account master 106a associates and stores account codes and account names for multiple accounts of financial institutions held by lessors.

FIG. 3 is a diagram showing an example of the code name master 106b in the embodiment. The code name master 106b associates and stores types, code values, type names, and code names (account codes). In other words, the code name master 106b includes a plurality of billing items (rent, common service fee, security deposit, key money, renewal fee, etc. in the code value) indicating the type of the amount billed by the lessor to the lessee in the lease, and It is an example of first correspondence information storage means for storing first correspondence information indicating correspondence between a plurality of accounts (code names (account codes)) of financial institutions held by a lessor.

FIG. 4 is a diagram showing examples of collection schedule data 106c, deposit data 106d, and error check worktable 106e in the embodiment. The collection schedule data 106c stores the billing business partner, billing item, and billing amount in association with each other. In other words, the scheduled collection data 106c is a second correspondence relationship that stores second correspondence information indicating the correspondence relationship between the billing amount billed by the lessor to the lessee (billing business partner) and the billing items. It is an example of information storage means.

The deposit data 106d stores the deposit account and the deposit amount associated with the deposit from the lessee to the lessor's account. The error check worktable 106e is a table used by the determination unit 102b, and stores the billing client, billing item, billing amount, total billing amount, deposit account, and deposit amount in association with each other. FIG. 4 shows an example in which the total amount billed and the amount deposited match for each account.

On the other hand, FIG. 5 is a diagram showing another example of collection schedule data 106c, deposit data 106d, and error check worktable 106e in the embodiment. FIG. 5 shows an example in which the total billed amount and the deposited amount do not match for each account. A detailed description of FIGS. 4 and 5 will be given later.

Returning to FIG. 1, an input device 112 and an output device 114 are connected to the input/output interface section 108 . The output device 114 can be a monitor (including a home television), a speaker, or a printer. The input device 112 can be a keyboard, a mouse, a microphone, or a monitor that cooperates with the mouse to provide a pointing device function.

The control unit 102 is a CPU or the like that comprehensively controls the deposit management apparatus 100 . The control unit 102 has an internal memory for storing a control program such as an OS, a program defining various processing procedures, required data, and the like, and performs various information processing based on these stored programs. Run. The control unit 102 functionally and conceptually includes an acquisition unit 102a (acquisition means), a determination unit 102b (determination means), and an output unit 102c (output means).

The acquiring unit 102a acquires deposit data 106d (deposit information) including information on the lessor's account and the amount of deposit to which the lessee has deposited money.

The determination unit 102b refers to the account master 106a, the code name master 106b, the collection schedule data 106c, and the deposit data 106d, and also uses the error check worktable 106e to determine the billing amount for each account. It is determined whether or not the total and the deposited amount match (details will be described later).

The output unit 102c outputs a predetermined message and deposit data 106d when the determination unit 102b determines that they do not match (details will be described later).

The acquisition unit 102a acquires the deposit data 106d via the EB service. In that case, before the deposit data 106d is captured by the receipt processing in the deposit management apparatus 100, the determination unit 102b makes the determination described above.

[3. process]
Next, an example of processing by the deposit management device 100 in the embodiment will be described with reference to FIG. FIG. 6 is a flow chart showing an example of processing by the deposit management device 100 in the embodiment.

In step S1, the acquisition unit 102a acquires deposit data 106d (FIGS. 4 and 5) including information on the lessor's account and the amount of deposit to which the lessee has deposited.

Next, in steps S2 to S5, the control section 102 performs steps S3 and S4 for each account. In step S3, the determination unit 102b determines whether or not the total billed amount and the received amount match (details will be described later). If Yes, the process proceeds to step S5, and if No, the process proceeds to step S4.

In step S4, the output unit 102c outputs a predetermined message and deposit data 106d (details will be described later).

In the above-described step S3, for example, when the deposit data 106d are two cases shown in FIG. 106c (FIG. 4) and deposit data 106d (FIG. 4) are referred to create the error check worktable 106e of FIG.

In the error check worktable 106e of FIG. 4, the claim items are " The sum of the billed amount of "100,000 (yen)" for "rent" and the billed amount of "5,000 (yen)" for which the billed item is "common service fee", the total billed amount is "105,000 yen" 000 (yen)”.

Also, based on the deposit data 106d (the upper part of the two in FIG. 4), the deposit amount of the deposit account "△□ bank rent account" is "105,000 (yen)". That is, based on the account master 106a and the code name master 106b, the above-mentioned billed amount "105,000 (yen)" and the above-mentioned deposited amount "105,000 (yen)" are associated. Then, the determination unit 102b determines that the two match.

Similarly, in the error check worktable 106e of FIG. 4, based on the account master 106a, code name master 106b, and collection schedule data 106c, The total billed amount is the sum of the billed amount "100,000 (yen)" for which the billed item is "deposit" and the billed amount "100,000 (yen)" for which the billed item is "key money". It is "200,000 (yen)".

Also, based on the deposit data 106d (lower part of the two in FIG. 4), the deposit amount of the deposit account "△□ bank contract money account" is "200,000 (yen)". That is, based on the account master 106a and the code name master 106b, the above-mentioned billed total amount of "200,000 (yen)" and the above-mentioned deposited amount of "200,000 (yen)" are associated. Then, the determination unit 102b determines that the two match.

Further, in the above-described step S3, for example, when the deposit data 106d is one case shown in FIG. The error check worktable 106e of FIG. 5 is created by referring to the schedule data 106c (FIG. 5) and the deposit data 106d (FIG. 5).

In the error check worktable 106e of FIG. 5, the total charges "105,000 (yen)" and "200,000 (yen)" are the same as in FIG.

On the other hand, based on the deposit data 106d (Fig. 5), the deposit amount of the deposit account "△□ bank rent account" is "305,000 (yen)". Then, the determination unit 102b determines the total amount of money to be deposited into the "rent account" of "△□ bank", which is "305,000 (yen)", which is the amount of money deposited into the deposit account "△□ bank, rent account". "105,000 (yen)" does not match.

In that case, the output unit 102c outputs, for example, an EB deposit data import error list shown in FIG. FIG. 7 is a diagram showing an example of an EB deposit data capture error list in the embodiment. The EB deposit data import error list is a list of deposits in which an error occurred in the EB deposit data import process, and is displayed on the output device 114 by the output unit 102c.

The EB deposit data import error list consists of items of line number, account number and inquiry number, error item name and error value, error content and message number. In the example of FIG. 5 described above, the case where the total billed amount and the received amount do not match is displayed in line number "1".

As described above, according to the deposit management device 100 of the present embodiment, it is possible to check whether the deposit amount is correct for each of a plurality of accounts that accept deposits related to rental. Specifically, when there is a payment from the lessee to the account of the lessor, the determination unit 102b in the payment management device 100 determines the account master 106a, the code name master 106b, the collection schedule data 106c, and the payment data. 106d, and using the error check worktable 106e, it is determined whether or not the total billed amount and the deposited amount match for each account. Then, when the determination unit 102b determines that the data do not match, the output unit 102c outputs an EB deposit data import error list (FIG. 7). By viewing the EB deposit data import error list (FIG. 7) displayed on the output device 114, the user can easily recognize that there is an error in the deposit amount for each account.

Further, according to the deposit management device 100, the acquisition unit 102a acquires the deposit data 106d via the EB service, and before the deposit data 106d is captured by the receipt processing in the deposit management device 100, the determination unit 102b makes the above determination. By doing this, it is possible to avoid a situation in which an erroneous payment is taken in by the taking process.

[4. Other embodiments]
The present invention can be implemented in various different embodiments other than the embodiments described above 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 can be manually performed, or all of the processes described as being manually performed Alternatively, some can be done automatically by known methods.

In addition, unless otherwise specified, the processing procedures, control procedures, specific names, information including parameters such as registration data and search conditions for each process, screen examples, and database configurations shown in this specification and drawings It can be changed arbitrarily within the scope of the purpose.

Also, with respect to the deposit management apparatus 100, each illustrated component is functionally conceptual, and does not necessarily need to be physically configured as illustrated.

In addition, all or any part of the processing functions provided in the deposit management apparatus 100, particularly each processing function performed by the control unit 102, is interpreted and executed by the MPU (CPU) and the MPU (CPU). It may be implemented by a program, or may be implemented as hardware based on wired logic. The program is recorded on a non-temporary computer-readable recording medium containing programmed instructions for causing the information processing apparatus to execute the processing described in this embodiment, and is transferred to the deposit management apparatus 100 as necessary. read mechanically. That is, a storage unit such as a ROM or HDD (Hard Disk Drive) stores a computer program for performing various processes by giving commands to an MPU (CPU) in cooperation with the OS. This computer program is executed by being loaded into the RAM, and constitutes a control section in cooperation with the MPU (CPU).

Also, this computer program may be stored in an application program server connected to deposit management apparatus 100 via any network, and it is possible to download all or part of it as necessary. be.

Also, the program for executing the processing described in this embodiment may be stored in a non-temporary computer-readable recording medium, or may be configured as a program product. Here, this "recording medium" means memory card, USB (Universal Serial Bus) memory, SD (Secure Digital) card, flexible disk, magneto-optical disk, ROM, EPROM (Erasable Programmable Read Only Memory), EEPROM (registered Trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magneto-Optical disk), DVD (Digital Versatile Disk), and Blu-ray (registered trademark) Disc, etc. shall include any "portable physical medium". Therefore, a recording medium storing a program for executing the processing or processing method described in this specification also constitutes the present invention.

A "program" is a data processing method written in any language or writing method, regardless of the format such as source code or binary code. In addition, the "program" is not necessarily limited to a single configuration, but is distributed as multiple modules or libraries, or cooperates with a separate program represented by the OS to achieve its function. Including things. Well-known configurations and procedures can be used for the specific configuration and reading procedure for reading the recording medium in each device shown in the embodiments, the installation procedure after reading, and the like.

The various databases stored in the storage unit 106 are storage means such as memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks. Stores various programs, tables, databases, web page files, etc. to be used.

Also, deposit management apparatus 100 may be configured as an information processing apparatus such as a known personal computer or workstation, or may be configured as the information processing apparatus to which arbitrary peripheral devices are connected. Also, the deposit management apparatus 100 may be realized by installing software (including programs, data, etc.) for realizing the processing described in the present embodiment.

Furthermore, the specific forms of distribution and integration of devices are not limited to those shown in the figures, and all or part of them can be functionally or physically arranged in arbitrary units according to various additions or functional loads. It can be distributed and integrated. In other words, the embodiments described above may be arbitrarily combined and implemented, or the embodiments may be implemented selectively.

Also, in the above-described embodiments, the lessor is not limited to the owner of the real estate, and may be, for example, a management company entrusted by the owner. That is, in the above-described embodiment, the terms lessor and lessee are not limited literally, but can be broadly interpreted to mean the owner of an account for depositing money for rent and the person who deposits money into that account. Specifically, the combination of lessor and lessee in the embodiments may be property owner and lessee, property owner and management company (intermediary between property owner and lessee), management company and lessee, etc. good too.

Also, the rental object is not limited to real estate, and may be movable property, a bond, or the like.

INDUSTRIAL APPLICABILITY The present invention is useful in a computer device or the like that performs payment processing in rental.

100 deposit management device 102 control unit 102a acquisition unit 102b determination unit 102c output unit 104 communication interface unit 106 storage unit 106a account master 106b code name master 106c collection schedule data 106d deposit data 106e error check worktable 108 input/output interface unit 112 input device 114 output device 200 server 300 network

Claims (5)

A deposit management device comprising a storage unit and a control unit,
The storage unit
First correspondence information indicating correspondence between a plurality of billing items indicating the type of lease of the amount billed by the lessor to the lessee and a plurality of financial institution accounts held by the lessor a first correspondence relationship information storage means for storing;
a second correspondence information storage means for storing second correspondence information indicating a correspondence relationship between the billing amount charged by the lessor to the lessee and the billing item;
The control unit
Acquisition means for acquiring deposit information including information on the account into which the deposit was made by the lessee and the amount of deposit;
The sum of the amounts billed for each of the billing items whose deposit account is the same account, indicated by the second correspondence information, to the deposit account of each of the billing items indicated by the first correspondence information Determination means for determining whether or not payment has been made based on the account to which the lessee made payment and the amount of payment, which are included in the payment information acquired by the acquisition means;
an output means for outputting a predetermined message and the deposit information when the determination means determines that the deposit amounts do not match;
A deposit management device comprising: The acquisition means acquires the deposit information via an EB (Electronic Banking) service,
The determining means performs the determination before the deposit information is captured by the capturing process in the deposit management device;
The deposit management device according to claim 1, characterized by: The determination means, based on the deposit data including the account to which the deposit was made and the deposit amount by the lessee, the first correspondence information, and the second correspondence information, Create an error check worktable containing the total amount of money, the account to which the lessee made the payment, and the amount of payment, and the total amount of the billed amount of each of the billing items of the same payment account in the error check worktable; 3. The deposit management device according to claim 1 or 2, wherein it is determined whether or not the lessee matches the deposit amount of the account into which the deposit is made. First correspondence information indicating correspondence between a plurality of billing items indicating the type of lease of the amount billed by the lessor to the lessee and a plurality of financial institution accounts held by the lessor a first correspondence relationship information storage means for storing;
a storage unit having second correspondence relationship information storage means for storing second correspondence relationship information indicating a correspondence relationship between the billing amount charged by the lessor to the lessee and the billing item; A deposit management method executed by a deposit management device comprising:
an obtaining step of obtaining deposit information including information on the account to which the deposit was made by the lessee and the amount of deposit;
The sum of the amounts billed for each of the billing items whose deposit account is the same account, indicated by the second correspondence information, to the deposit account of each of the billing items indicated by the first correspondence information a determination step of determining whether or not the payment has been made based on the account into which the lessee made payment and the amount of payment, which are included in the payment information acquired in the acquisition step;
an output step of outputting a predetermined message and the deposit information when the determination step determines that the deposit amounts do not match;
Receipt management methods, including; First correspondence information indicating correspondence between a plurality of billing items indicating the type of lease of the amount billed by the lessor to the lessee and a plurality of financial institution accounts held by the lessor a first correspondence relationship information storage means for storing;
a storage unit having second correspondence relationship information storage means for storing second correspondence relationship information indicating a correspondence relationship between the billing amount charged by the lessor to the lessee and the billing item; on the computer equipped with
an obtaining step of obtaining deposit information including information on the account to which the deposit was made by the lessee and the amount of deposit;
The sum of the amounts billed for each of the billing items whose deposit account is the same account, indicated by the second correspondence information, to the deposit account of each of the billing items indicated by the first correspondence information a determination step of determining whether or not the payment has been made based on the account into which the lessee made payment and the amount of payment, which are included in the payment information acquired in the acquisition step;
an output step of outputting a predetermined message and the deposit information when the determination step determines that the deposit amounts do not match;
Receipt management program for executing

Images