Real estate rental management device, real estate rental management method, and real estate rental management program

Abstract

To provide a real estate rental management device capable of accurately performing journal entry processing by separately managing security deposits and non-refundable amounts, taking into account their respective characteristics, a real estate rental management method, and a real estate rental management program.SOLUTION: A real estate rental management device acquires payment data in which a payment date and a payment amount are set in association with each other, and creates move-in security deposit revenue journal entry data and move-in non-refundable deposit revenue journal entry data corresponding to a consignment format on the basis of a journal entry pattern master, move-in recovery schedule data, and payment data.SELECTED DRAWING: Figure 1

Description

[Technical Field]

[0001] The present invention relates to a real estate rental management device, a real estate rental management method, and a real estate rental management program. [Background technology]

[0002] Patent Document 1 discloses a configuration for creating accounting data in which a security deposit paid by a real estate tenant is recorded as a deposit for other owners and as income for the company. [Prior art documents] [Patent documents]

[0003] [Patent Document 1] Japanese Patent Application Publication No. 2019-160144 Summary of the Invention [Problem to be solved by the invention]

[0004] However, the invention described in Patent Document 1 above has a problem in that the deposit and the deposit deduction are managed as separate items, making it impossible to perform accounting entries correctly.

[0005] The present invention has been made in consideration of the above-mentioned problems, and aims to provide a real estate rental management device, a real estate rental management method, and a real estate rental management program that can perform correct accounting by taking into account the characteristics of the deposit and the deposit deduction and managing them as separate items. [Means for solving the problem]

[0006] In order to solve the above-mentioned problems and achieve the objectives, the real estate rental management device of the present invention is a real estate rental management device equipped with a memory unit and a control unit, wherein the memory unit is equipped with a rental management memory means for storing the billing year and month of rent at the time of occupancy in the rental contract, rent items including security deposit and security deduction, and scheduled collection data at the time of occupancy linked to the billing amount, and an accounting pattern master set by linking the consignment type in the rental contract, the rent items, and account items, and the control unit is characterized by being equipped with a deposit acquisition means for acquiring deposit data set by linking the deposit date and deposit amount, and an accounting creation means for creating journal entry data for security deposit sales at the time of occupancy and journal entry data for security deduction sales at the time of occupancy corresponding to the consignment type based on the accounting pattern master, the scheduled collection data at the time of occupancy, and the deposit data.

[0007] In addition, in the real estate rental management device of the present invention, the control unit is characterized in that it further comprises an occupancy statement issuing means for creating occupancy statement data for the initial contract, in which the rent items and the billing amount are set based on the data on the planned collection at the time of occupancy, and printing out the occupancy statement data.

[0008] In addition, in the real estate rental management device of the present invention, the rental management storage means further stores summary items that aggregate multiple rent items and an output setting master that is linked to documents to be output, and the occupancy statement issuance means creates the occupancy statement data that sets the summary items that aggregate the security deposit and the security deduction, and the total amount of the invoice amount for the security deposit and the security deduction, based on the output setting master and the data scheduled for collection at the time of occupancy, and prints out the occupancy statement data.

[0009] In addition, in the real estate rental management device of the present invention, the rental management storage means further stores monthly rental contract data in which the monthly rent, the security deposit, and the security deduction are set, and the control unit is further equipped with a move-out acquisition means which, when a cancellation date for the rental contract is set, calculates the number of days prorated by the cancellation date, acquires move-out data in which the cancellation date and the number of days prorated by the cancellation date are set, and acquires scheduled collection data at the time of cancellation in which the cancellation month's rent amount is set based on the monthly rental contract data and the move-out data, and a move-out settlement statement issuance means which calculates the settlement amount based on the monthly rental contract data and the scheduled collection data at the time of cancellation, creates move-in settlement statement data in which the initial deposit amount, the cancellation month's rent amount, the security deduction amount, and the settlement amount are set, and prints out the move-out settlement statement data.

[0010] In addition, in the real estate rental management device of the present invention, the journal entry creation means is further characterized in that it creates departure settlement security deposit journal entry data and departure settlement rent journal entry data corresponding to the entrustment type based on the journal entry pattern master and the departure settlement statement data.

[0011] In the real estate rental management device according to the present invention, the journal entry creating means further creates deposit journal entry data based on the journal entry pattern master and the deposit data.

[0012] Furthermore, in the real estate rental management device of the present invention, the deposit acquisition means further acquires deposit reconciliation data that sets the deposit reconciliation date and the reconciled deposit amount based on the deposit data and the scheduled collection data at the time of occupancy, and the journal entry creation means further creates security deposit reconciliation journal entry data and security deduction reconciliation journal entry data based on the journal entry pattern master, the deposit data, and the deposit reconciliation data.

[0013] In addition, in the real estate rental management device of the present invention, the journal entry creation means is further characterized in that it creates journal entry data for rent sales at the time of cancellation corresponding to the entrustment type based on the journal entry pattern master and the data on planned collection at the time of cancellation.

[0014] In addition, in the real estate rental management device of the present invention, the control unit is characterized in that it further comprises a contract acquisition means for, when the contract date of the rental contract and the amount to be charged for each rent item are set, calculating the number of days to be calculated on a per-day basis for the contract month, acquiring contract data setting the contract date and the number of days to be calculated on a per-day basis for the contract month, and monthly rental contract data setting the amount to be charged for each rent item, and acquiring the scheduled collection data at the time of occupancy based on the monthly rental contract data and the contract data.

[0015] In addition, in the real estate rental management device according to the present invention, the entrustment form is a guarantee of arrears or a company property.

[0016] In addition, the real estate rental management method of the present invention is a real estate rental management method to be executed by a real estate rental management device equipped with a memory unit and a control unit, wherein the memory unit is equipped with a rental management memory means for storing the billing year and month of rent at the time of occupancy in the rental contract, rent items including security deposit and security deduction, and scheduled collection data at the time of occupancy linked to the billing amount, and an accounting pattern master set by linking the consignment type in the rental contract, the rent items, and account items, and is characterized by including: a deposit acquisition step executed in the control unit for acquiring deposit data set by linking the deposit date and deposit amount, and an accounting creation step for creating journal entry data for security deposit sales at the time of occupancy and journal entry data for security deduction sales at the time of occupancy corresponding to the consignment type based on the accounting pattern master, the scheduled collection data at the time of occupancy, and the deposit data.

[0017] In addition, the real estate rental management program of the present invention is a real estate rental management program to be executed by a real estate rental management device having a memory unit and a control unit, and the memory unit has a rental management memory means for storing the billing year and month of rent at the time of occupancy in the rental contract, rent items including security deposit and security deduction, and scheduled collection data at the time of occupancy linked to the billing amount, and an accounting pattern master linked to the consignment type in the rental contract, the rent items, and account items, and the control unit is characterized by executing a deposit acquisition step for acquiring deposit data linked to the deposit date and deposit amount, and an accounting creation step for creating journal entry data for security deposit sales at the time of occupancy and journal entry data for security deduction sales at the time of occupancy corresponding to the consignment type based on the accounting pattern master, the scheduled collection data at the time of occupancy, and the deposit data. [Effects of the Invention]

[0018] According to the present invention, by taking into account the characteristics of security deposits and security deductions, report output and journal entries are correctly performed, thereby achieving the effect of streamlining the work of coordinating contracts, moves out, and accounting. Furthermore, according to the present invention, it is possible to automatically determine which items to record, thereby achieving the effect of streamlining accounting work in the real estate rental industry. While security deposits are mainstream in some areas, such as Kyushu, in recent years, a similar process called amortization has been adopted by an increasing number of management companies. Therefore, according to the present invention, it is possible to distinguish between security deposits and security deductions and automatically select which items to record, thereby preventing accounting errors and reducing accounting work. Furthermore, according to the present invention, it is possible to perform accounting processing for security deposits in accordance with the property management contract, and to calculate the settlement amount for the move-out settlement upon termination by deducting the security deposit. [Brief explanation of the drawings]

[0019] [Figure 1] FIG. 1 is a block diagram showing an example of the configuration of a real estate rental management device according to this embodiment. [Figure 2] FIG. 2 is a diagram showing an example of master settings in this embodiment. [Figure 3] FIG. 3 is a flowchart showing an example of processing performed by the real estate rental management device according to this embodiment. [Figure 4] FIG. 4 is a diagram showing an example of real estate rental management processing in this embodiment. [Figure 5] FIG. 5 is a diagram showing an example of real estate rental management processing in this embodiment. [Figure 6] FIG. 6 is a diagram showing an example of real estate rental management processing in this embodiment. [Figure 7] FIG. 7 is a diagram showing an example of real estate rental management processing in this embodiment. [Figure 8] FIG. 8 is a diagram showing an example of real estate rental management processing in this embodiment. [Figure 9] FIG. 9 is a diagram showing an example of real estate rental management processing in this embodiment. [Figure 10] FIG. 10 is a diagram showing an example of real estate rental management processing in this embodiment. [Figure 11] FIG. 11 is a diagram showing an example of real estate rental management processing in this embodiment. [Figure 12] FIG. 12 is a diagram showing an example of real estate rental management processing in this embodiment. [Figure 13] FIG. 13 is a diagram showing an example of real estate rental management processing in this embodiment. [Figure 14] FIG. 14 is a diagram showing an example of real estate rental management processing in this embodiment. [Figure 15] FIG. 15 is a diagram showing an example of real estate rental management processing in this embodiment. [Figure 16] FIG. 16 is a diagram showing an example of real estate rental management processing in this embodiment. DETAILED DESCRIPTION OF THE INVENTION

[0020] DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of the present invention will be described in detail with reference to the accompanying drawings. However, the present invention is not limited to this embodiment.

[0021] [1. Overview] First, an outline of the present invention will be described.

[0022] A security deposit is an amount deducted from the security deposit (or guarantee money) when signing a lease for a rental property, mainly to cover the cost of restoring the property to its original condition when the tenant moves out.In rental agreements, it is written as "3 months' security deposit, 1 month's security deposit."

[0023] Here, in the past, when accounting for the party receiving the security deposit or security deposit when a tenant signs a contract, the security deposit is assumed to be refunded when the tenant moves out, so it is recorded as a liability such as a deposit. However, unlike the security deposit, it is clear that the security deposit will not be refunded at the time of the lease agreement, so it must be recorded as revenue. Therefore, the amount of the security deposit when the tenant moves out was presented on the settlement statement presented to the tenant, but no journal entry was made in the accounting process.

[0024] Furthermore, in the past, when billing tenants at the time of signing a contract, settling accounts when they move out, and performing accounting coordination tasks, it was necessary to be aware of the business practice of depositing a deposit when signing a contract, but because the way it was handled and the timing of processing differed between the contract, the invoices and settlement documents with tenants, and the accounting tasks, accounting tasks were difficult for anyone who was not familiar with both the real estate rental business and accounting tasks.

[0025] Therefore, in this embodiment, by managing the security deposit and security deduction internally as separate items, the security deposit is charged to the tenant, but the security deposit amount is held internally and the security deduction amount is recorded as sales.In addition, the settlement statement presented to the tenant when they move out also shows the security deposit and security deduction in the amounts that are consistent with the data at the time of the contract.This provides a system that allows operators to adapt to the business practice of security deduction in the rental management industry without being aware of it when charging the tenant at the time of signing the contract, settling the account when they move out, and in accounting coordination work.

[0026] [2. Configuration] An example of the configuration of a real estate rental management device 100 according to this embodiment will be described with reference to Fig. 1 and Fig. 2. Fig. 1 is a block diagram showing an example of the configuration of a real estate rental management device 100 according to this embodiment.

[0027] 1, real estate rental management device 100 is a commercially available desktop personal computer. Note that real estate rental management device 100 is not limited to a stationary information processing device such as a desktop personal computer, and may be a portable information processing device such as a commercially available notebook personal computer, PDA (Personal Digital Assistant), smartphone, or tablet personal computer.

[0028] Real estate rental management device 100 comprises a control unit 102, a communication interface unit 104, a memory unit 106, and an input / output interface unit 108. The units comprised in real estate rental management device 100 are connected to each other so as to be able to communicate with each other via any communication path.

[0029] Communication interface unit 104 communicatively connects real estate rental management apparatus 100 to network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. Communication interface unit 104 has a function of communicating data with other devices via the communication line. Here, network 300 has a function of connecting real estate rental management apparatus 100 and server 200 so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network).

[0030] An input device 112 and an output device 114 are connected to the input / output interface unit 108. The output device 114 may be a monitor (including a touch panel), a speaker, or a printer. The input device 112 may be a keyboard, a mouse, a microphone, or a monitor that cooperates with a mouse to achieve a pointing device function. In the following, the output device 114 may be referred to as the monitor 114 or the printer 114, and the input device 112 may be referred to as the keyboard 112 or the mouse 112.

[0031] The storage unit 106 stores various databases, tables, files, etc. The storage unit 106 stores computer programs that work in conjunction with the OS (Operating System) to issue commands to the CPU (Central Processing Unit) to perform various processes. The storage unit 106 can be, for example, a memory device such as RAM (Random Access Memory) or ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, or an optical disk. The storage unit 106 includes a rental management database 106a.

[0032] The rental management database 106a stores rental management data for real estate. The rental management database 106a may store rental items, including the billing year and month for rent at the time of move-in, rent, security deposit, and security deduction, as well as scheduled collection data at the time of move-in linked to the billing amount in the rental contract, and an accounting pattern master linked to the consignment type, rent items, and / or account items in the rental contract. The rental management database 106a may also store summary items that aggregate multiple rent items and / or an output setting master linked to documents to be output. The rental management database 106a may also store monthly rental contract data that sets the monthly rent, security deposit, and / or security deduction. The consignment type may be a delinquent guarantee or a company-owned property. In addition, the rental management database 106a may store contract data, contract customer data, monthly contract rent data, collection schedule data, output pattern master, output pattern summary item master, output pattern summary item breakdown master, deposit data, deposit reconciliation data, departure data, journal data, security deposit advance settlement work, deposit reconciliation work, security deposit advance settlement work, payment request work, departure settlement deposit data, departure settlement outstanding item data, payment request data, control master, rent item master, property master, management contract master, room master, room rent master, business partner master, and / or account master.

[0033] An example of master settings in this embodiment will now be described with reference to Fig. 2. Fig. 2 is a diagram showing an example of master settings in this embodiment.

[0034] As shown in Figure 2, in this embodiment, the following may be stored: a control master that manages system settings and / or company data, a rent item master that manages items to be billed to tenants, a property master that manages building data, a management contract master that manages management contracts with landlords, a room master that manages the rooms in the property, a room rent master that sets the amount to be billed for each rent item in each room, a business partner master that manages billing destinations and payees, an accounting pattern master that sets the accounting items to be used when accounting is linked for each type of outsourcing, and / or an account master that manages the company's bank accounts.

[0035] Returning to Figure 1, the control unit 102 is a CPU or the like that comprehensively controls the real estate rental management device 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs that define various processing procedures, required data, etc., and executes various information processing based on these stored programs. Functionally, the control unit 102 conceptually includes a contract acquisition unit 102a, a move-in statement issuance unit 102b, a deposit acquisition unit 102c, a move-out acquisition unit 102d, a move-out settlement statement issuance unit 102e, and a journal entry creation unit 102f.

[0036] The contract acquisition unit 102a acquires contract data for a rental contract. When the contract date of a rental contract and the amount to be charged for each rent item are set, the contract acquisition unit 102a may calculate the number of days in the contract month, acquire contract data setting the contract date and the number of days in the contract month, and monthly rental contract data setting the amount to be charged for each rent item, and acquire move-in collection schedule data based on the monthly rental contract data and the contract data.

[0037] The occupancy statement issuing unit 102b prints out (issues) occupancy statement data for rental contracts. Here, the occupancy statement issuing unit 102b may create occupancy statement data for an initial contract, in which rent items and billing amounts are set based on the data on scheduled collection at time of occupancy, and print out the occupancy statement data. The occupancy statement issuing unit 102b may also create occupancy statement data in which summary items for aggregating security deposits and security deductions, and the total amounts billed for security deposits and security deductions, are set based on the output setting master and the data on scheduled collection at time of occupancy, and print out the occupancy statement data.

[0038] The deposit acquisition unit 102c acquires deposit data linked to the deposit amount. Here, the deposit acquisition unit 102c may acquire deposit data linked to the deposit date and the deposit amount. Furthermore, the deposit acquisition unit 102c may acquire deposit reconciliation data in which the deposit reconciliation date and the reconciled deposit amount are set based on the deposit data and the move-in collection schedule data.

[0039] The move-out acquisition unit 102d acquires move-out data for a rental contract. Here, when a cancellation date for a rental contract is set, the move-out acquisition unit 102d may calculate the number of days calculated on a pro-rata basis for the cancellation month, acquire move-out data in which the cancellation date and the number of days calculated on a pro-rata basis for the cancellation month are set, and acquire cancellation collection schedule data in which the rent amount for the cancellation month is set based on the rental contract monthly data and the move-out data.

[0040] The move-out settlement statement issuing unit 102e prints out (issues) move-out settlement statement data for the rental contract. Here, the move-out settlement statement issuing unit 102e may calculate the settlement amount based on the rental contract monthly data and the cancellation collection schedule data, create move-out settlement statement data that sets the deposit amount at the time of moving in, the cancellation month's rent amount, the security deposit amount, and the settlement amount, and print out the move-out settlement statement data.

[0041] The journal entry preparation unit 102f prepares journal entry data. Here, the journal entry preparation unit 102f may prepare journal entry data for security deposit sales at move-in and journal entry data for security deposit deduction sales at move-in, corresponding to the type of consignment, based on the journal entry pattern master, the data on expected collection at move-in, and the deposit data. The journal entry preparation unit 102f may also prepare journal entry data for security deposit settlement at move-in and journal entry data for rent settlement at move-in, corresponding to the type of consignment, based on the journal entry pattern master and the data on the move-out settlement statement. The journal entry preparation unit 102f may also prepare journal entry data for deposit payments, based on the journal entry pattern master and the deposit data. The journal entry preparation unit 102f may also prepare journal entry data for security deposit payment reconciliation and journal entry data for security deposit deduction reconciliation, based on the journal entry pattern master, the deposit data, and the deposit reconciliation data. The journal entry preparation unit 102f may also prepare journal entry data for rent sales at contract termination, corresponding to the type of consignment, based on the journal entry pattern master and the data on expected collection at contract termination.

[0042] [3. Specific Examples] A specific example of this embodiment will be described with reference to FIGS.

[0043] [Real estate rental management processing] An example of real estate rental management processing in this embodiment will now be described with reference to Fig. 3. Fig. 3 is a flowchart showing an example of processing by the real estate rental management apparatus 100 in this embodiment.

[0044] As shown in Figure 3, when the user sets the rental contract date and the amount to be charged for each rent item via the input device 112, the contract acquisition unit 102a calculates the number of days in the contract month, acquires contract data that sets the contract date and the number of days in the contract month, and monthly rental contract data that sets the amount to be charged for each rent item, and acquires scheduled collection data at the time of move-in based on the monthly rental contract data and the contract data (step SA-1).

[0045] Then, the occupancy statement issuing unit 102b creates occupancy statement data that includes summary items for aggregating the security deposit and security deduction, as well as the total amount to be claimed for the security deposit and security deduction, based on the output setting master and the data scheduled to be collected at the time of occupancy, and causes the output device 114 to print out the occupancy statement data (step SA-2).

[0046] Then, the deposit acquisition unit 102c acquires the deposit data that is set in association with the deposit date and the deposit amount (step SA-3).

[0047] Then, the journal entry creation unit 102f creates journal entry data for security deposit sales at the time of occupancy and journal entry data for security deposit sales at the time of occupancy corresponding to the type of entrustment based on the journal entry pattern master, the data for scheduled collection at the time of occupancy, and the deposit data (step SA-4).

[0048] When the user sets the rental contract termination date via the input device 112, the departure acquisition unit 102d calculates the number of days calculated on a pro-rata basis for the cancellation month, acquires departure data that sets the termination date and the number of days calculated on a pro-rata basis for the cancellation month, and acquires scheduled collection data at the time of cancellation that sets the rent amount for the cancellation month based on the rental contract monthly data and the departure data (step SA-5).

[0049] The move-out settlement statement issuing unit 102e then calculates the settlement amount based on the monthly rental contract data and the scheduled collection data at the time of cancellation, creates move-out settlement statement data that sets the deposit amount at the time of moving in, the rent amount for the month of cancellation, the security deposit amount, and the settlement amount, and prints out the move-out settlement statement data on the output device 114 (step SA-6).

[0050] Then, the journal entry creation unit 102f creates the departure settlement security deposit journal entry data and the departure settlement rent journal entry data corresponding to the type of consignment based on the journal entry pattern master and the departure settlement statement data (step SA-7), and ends the process.

[0051] An example of real estate rental management processing in this embodiment will now be described with reference to Fig. 4 to Fig. 16. Fig. 4 to Fig. 16 are diagrams showing an example of real estate rental management processing in this embodiment.

[0052] As shown in FIG. 4, in this embodiment, when a new contract with a tenant is entered into the contract input screen, scheduled collection data to be billed to the tenant at the time of the initial contract is created. Here, as shown in FIG. 4, in this embodiment, when a property code and room number are entered into the contract input screen, the contract data displays the rent items, number of months, and billing amount obtained from the room rent master, and the rent item classification category from the item master is displayed as "Content." Also, as shown in FIG. 4, in this embodiment, when the initial contract date is entered into the contract input screen, the prorated number of days and sales recording date are automatically set. Here, the prorated number of days is set to 21 days from the initial contract date (November 10, 2023) to the last day of the month of the initial contract date (November 30, 2023), and the sales recording date is set to the same day as the initial contract date. Also, as shown in FIG. 4, in this embodiment, the rent items and amount to be billed at the time of the initial contract are automatically displayed in the contract billing data based on the contract data and prorated number of days. As shown in FIG. 4, in this embodiment, when the amount is a monthly item, the result of a pro rata calculation based on the billing amount in the contract data is displayed. Here, the pro rata calculation is the monthly billing amount divided by the pro rata denominator in the room master data multiplied by the number of days (100,000 divided by 30 x 21 = 70,000). Also, as shown in FIG. 4, in this embodiment, the contract fee is displayed directly from the billing data. Also, as shown in FIG. 4, in this embodiment, the contract number is automatically assigned when a new contract is registered. Also, as shown in FIG. 4, in this embodiment, the landlord code in the management contract master data is obtained from the entered property code, and the landlord code and landlord name are displayed.

[0053] As shown in FIG. 5, in this embodiment, contract data, contract customer data, contract rent monthly data, and collection schedule data are created by entering the contract.

[0054] In this embodiment, documents related to the initial contract are issued to the tenant, as shown in Fig. 6. Here, in this embodiment, when the contract number is specified on the screen, an occupancy statement is output, and the security deposit and security deduction are added together and presented to the tenant as "security deposit."

[0055] As shown in Fig. 7, the printing mechanism for occupancy calculations in this embodiment refers to the output setting master and sets the print content. As shown in Fig. 7, in this embodiment, when the "Details" button is pressed in the output setting master maintenance, it is launched and the content to be printed on the form can be set as the summary item title, and the items to be summarized when the form is output can be set on the screen that appears when the details button is pressed.

[0056] As shown in Figure 8, in this embodiment, when the amount billed at the time of contract is received from the borrower, a deposit process is performed. In this embodiment, since ¥370,000 was deposited into account KZ01 on November 1, 2023, a deposit reconciliation entry is performed to the contract bill (data for which the scheduled collection Guids of the scheduled collection data are KY01, KY02, and KY03), and the date "November 1, 2023" is entered on the screen as the deposit date and the deposit reconciliation date. As shown in Figure 8, deposit data and deposit reconciliation data are created, and the reconciled amount of the scheduled collection data is updated. In this embodiment, a deposit number is automatically assigned when a new deposit reconciliation entry is registered.

[0057] In this embodiment, in the case of a managed property (a property for which management is entrusted by the landlord), the 200,000 yen security deposit and 100,000 yen security deposit paid by the tenant are remitted to the landlord, and the security deposit becomes the landlord's income. The security deposit is collected from the landlord when the tenant moves out and refunded to the tenant. In the case of a company-owned property, the security deposit becomes the company's income and the security deposit is refunded to the tenant when the tenant moves out. Here, in this embodiment, whether the property is managed or owned is set in the "outsourcing type" of the management outsourcing contract data. Generally, a managed property is an outsourcing type of "guarantee for delinquency" or "collection agency," and an owned property is an outsourcing type of "company-owned property" or "sublease."

[0058] As shown in Figure 9, in this embodiment, the account is determined based on the "outsourcing type" in the management outsourcing contract master and the journal entry pattern master, and a journal entry is created. That is, as shown in Figure 9, in this embodiment, when a security deposit of 200,000 yen and a security deduction of 100,000 yen are deposited from the tenant into account KZ01, a deposit journal entry and a deposit reconciliation journal entry are created. Here, as shown in Figure 9, in this embodiment, deposit journal entry data is created from deposit data, and the "cash and deposit account" in the account master is obtained as a debit account from the deposit account code in the deposit data, and the "temporary receipt account" in the account master is obtained as a credit account from the deposit account code in the deposit data. Also, as shown in Figure 9, in this embodiment, deposit reconciliation journal data is created from deposit reconciliation data, the "temporary receipt item" in the account master is obtained as a debit account item from the deposit account code of the deposit data, the journal pattern master is referenced from the item code and consignment form of the collection schedule data linked to the collection schedule Guid of the deposit reconciliation data, and the "advance receipt item" is obtained as a credit account item because the deposit reconciliation date of the deposit reconciliation data is before the sales posting date of the collection schedule data. Also, as shown in Figure 9, in this embodiment, the "deposit date" of the deposit data is obtained as the journal entry date for the deposit journal entry, and the "deposit reconciliation date" of the deposit reconciliation data is obtained as the journal entry date for the deposit reconciliation journal entry.

[0059] As shown in Figure 9, in this embodiment, the journal entry pattern master is referenced based on the item code and outsourcing type of the collection schedule data, and the "Advance Item" is acquired as a debit account. The journal entry pattern master is referenced based on the item code and outsourcing type of the collection schedule data, and the "Revenue Item" is acquired as a credit / debit account. As shown in Figure 9, in this embodiment, the "Sales Posting Date" of the collection schedule data is acquired as the journal entry date. Furthermore, in this embodiment, journal entries are set in the journal entry pattern registration based on the outsourcing type and item code of the management outsourcing contract. This function allows the sales posting of the same item code, "security deposit," to be set as "deposit" for managed properties and "sales" for company-owned properties, enabling journal entries that match the actual situation. Since the security deposit and security deposit have different item codes, the security deposit amount can be journalized as "deposit" for company-owned properties.

[0060] As shown in FIG. 10, in this embodiment, when a tenant requests termination and enters a contract number as a termination input on the termination input screen, the property code, room number, and contract code (tenant's code) are obtained from the contract data and displayed on the termination input screen, and the landlord code is obtained from the management contract data linked to the property code. As shown in FIG. 10, in this embodiment, when a termination date is entered on the termination input screen, the prorated number of days is automatically set. Here, the prorated number of days is set to 25 days, from the first day of the month of the termination date (2024 / 12 / 1) to the termination date (2024 / 12 / 25). Also, as shown in FIG. 10, in this embodiment, the billing data automatically displays the rent items and prorated amount to be billed in the termination month based on the monthly contract rent data and prorated number of days. Here, the items displayed are those from the monthly contract rent data that have a rent item classification category of "2: Monthly" in the item master, and the billing amount is the result of calculating the daily amount from the billing amount in the monthly contract rent data (monthly billing amount ÷ daily denominator in the room master × number of days prorated = 100,000 ÷ 30 × 25 = 83,333), and it is also possible to correct the amount (83,000).In this embodiment, as shown in Figure 10, move-out data and expected collection data (at the time of cancellation) are created.

[0061] As shown in Figure 11, in this embodiment, a sales journal entry for the cancellation month's rent is created based on the collection schedule data. Here, as shown in Figure 11, in this embodiment, the journal entry pattern master is referenced from the item code and consignment type of the collection schedule data, and since there is no payment reconciliation data, the "uncollected account" is acquired as the debit account, and the journal entry pattern master is referenced from the item code and consignment type of the collection schedule data, and the "income account" is acquired as the credit account. Also, as shown in Figure 11, in this embodiment, the journal entry date is acquired from the "sales posting date" of the collection schedule data.

[0062] 12, in this embodiment, when a tenant moves out and settles the move-out account, if the contract number is entered on the settlement input screen, the property code, room number, and contract code (tenant code) are obtained from the contract data and displayed on the settlement input screen. Here, as shown in FIG. 12, in this embodiment, the landlord code is obtained from the management contract data linked to the property code, and the cancellation date, prorated number of days, and cancellation accounting date are displayed from the move-out data. As shown in FIG. 12, in this embodiment, the amount of "security deposit" in the settlement details is calculated by aggregating the amounts of items with rent classifications of "01: Security Deposit" and "11: Security Deposit" in the item master from the monthly contract rent data, and displaying the amount of "security deposit" in the settlement details (deposit: ¥200,000 and security deposit: ¥100,000, total: ¥300,000), and by aggregating the amount of item "11: Security Deposit" from the monthly contract rent data (security deposit: ¥100,000), and displaying the amount of the deposit before the move-out settlement (security deposit The amount remaining immediately prior to the move-out settlement (prorated rent: ¥83,000) is displayed as the "total uncollected amount," and the amount remaining after deducting the uncollected amount from the deposit (¥200,000 deposit minus ¥83,000 uncollected: ¥117,000) is displayed as the "settlement amount," which is the amount to be refunded to the tenant. When the settlement accounting date is entered on the settlement input screen, the registration is performed.

[0063] 13 and 14 illustrate the data creation logic of this embodiment. As shown in FIG. 13, in this embodiment, the amount is obtained from the monthly contract rent data to create a security deposit settlement worksheet. The collection schedule data before settlement entry is obtained. Unsettled data (rent data calculated on a pro rata basis for the cancellation date) is identified and cleared from the security deposit settlement worksheet. This clears the data to create a deposit clearing worksheet. By clearing 83,000 yen, the security deposit settlement worksheet is updated. The balance in the security deposit settlement worksheet is subtracted by the transferred amount to create a payment request worksheet. As shown in FIG. 13, in this embodiment, the customer code from the contract customer data is obtained as the payee code. The management contract number from the management contract data is obtained as the management contract number from the property linked to the contract number. The item code is obtained from the security deposit settlement worksheet. The settlement entry date on the settlement entry screen is obtained as the unpaid entry date.

[0064] As shown in Figure 14, in this embodiment, actual tables are created from the created work, etc., and departure settlement deposit data is created from the security deposit advance settlement work, and based on the planned collection data before settlement input, the "deposit cleared amount" is subtracted from the "amount" to create unpaid data at the time of settlement (departure settlement unpaid item data), deposit data is created from the security deposit advance settlement work, deposit clearing data is created from the deposit clearing work, and payment request data is created from the payment request work. Here, as shown in Figure 14, the deposit amount is the "balance" in the security deposit advance settlement work, the uncollected settlement amount is the "transferred amount" in the security deposit advance settlement work, the refund amount is the "balance" - "transferred amount" in the security deposit advance settlement work, the refund payment request Guid is the same Guid as the Guid of the payment request work created from the security deposit advance work, the deposit date is the settlement recording date on the settlement input screen, the deposit account code is the "departure settlement account" in the control master, the deposit amount is the "transferred amount" in the security deposit advance settlement work, and the deposit settlement date is the settlement recording date on the settlement input screen.

[0065] Then, in this embodiment, a move-out settlement statement is issued to the tenant, as shown in Fig. 15. That is, in this embodiment, as shown in Fig. 15, when a contract number is specified on the settlement input screen, a move-out settlement statement is output, and the total amount of the security deposit and security deduction in the monthly contract rent data is printed in the security deposit section of the deposit item, and the security deduction in the monthly contract rent data is printed in the security deduction column, thereby expressing "the settlement amount obtained by deducting the security deduction of 100,000 yen from the security deposit of 300,000 yen received at the time of the initial contract." As shown in Figure 15, on the move-out settlement slip, the deposit total is the sum of the security deposit and security deduction amounts in the monthly contract rent data, referencing the rent item master using the item code of the monthly contract rent data; the billing total is the sum of the outstanding amounts in the move-out settlement outstanding item data; the security deduction is the sum of the security deposit amounts in the monthly contract rent data, referencing the rent item master using the item code of the monthly contract rent data; and the settlement amount is "deposit total - billing total - security deduction." Also, as shown in Figure 15, on the move-out settlement slip, the details (deposit items) are printed according to the settings in the output setting master, just like on the move-in calculation slip; for the security deposit, by setting the item codes for the security deposit and security deduction in the "security deposit" column in the output setting master, the sum of the security deposit (TK021) and security deduction (TK022) in the monthly contract rent data is printed as "security deposit."

[0066] As shown in Figure 16, in this embodiment, a move-out settlement journal entry is created that is settled from the security deposit of 200,000 yen. Note that in this embodiment, the security deposit of 100,000 yen is only used on the move-out settlement input screen and documents, and does not affect the journal entry, and since the subject settings in the journal entry pattern master are the same, the journal entry is the same for both managed properties and company-owned properties. Here, as shown in Figure 16, in this embodiment, the first line of journal entry is created from the deposit data, and the journal entry pattern master is referenced from the item code of the move-out settlement deposit data and the consignment type code of the collection schedule data to obtain the "payment subject" as a debit account subject, and the "suspense receipt subject" in the account master is obtained as a credit account subject from the deposit account code of the deposit data, and the second line of journal entry is created from the deposit reconciliation data, and the "suspense receipt subject" in the account master is obtained as a debit account subject from the deposit account code of the deposit ... reconciliation data. The journal entry pattern master is referenced from the item code and consignment type of the scheduled collection data linked to the fixed Guid, and because the payment settlement date in the payment settlement data is after the sales posting date in the scheduled collection data, the "uncollected account" is obtained as a credit account item, and the journal entry on the third line is created from the payment request data, the journal entry pattern master is referenced from the item code and consignment type of the payment request data, the "payment account" is obtained as a debit account item, and the journal entry pattern master is referenced from the item code and consignment type of the payment request data, and the "unpaid account" is obtained as a credit account item.

[0067] [4. Contribution to the United Nations-led Sustainable Development Goals (SDGs)] This embodiment can contribute to improving business efficiency and promoting appropriate management decisions by companies, thereby contributing to the achievement of SDGs Goals 8 and 9.

[0068] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and electronic systems, thereby contributing to the achievement of SDGs Goals 12, 13, and 15.

[0069] Furthermore, this embodiment can contribute to strengthening control and governance, which can contribute to the achievement of Goal 16 of the SDGs.

[0070] 5. Other Embodiments The present invention may be implemented in various different embodiments other than those described above within the scope of the technical concept set forth in the claims.

[0071] For example, among the processes described in the embodiments, all or part of the processes described as being performed automatically can be performed manually, or all or part of the processes described as being performed manually can be performed automatically using known methods.

[0072] Furthermore, the processing procedures, control procedures, specific names, information including parameters such as registered data and search conditions for each process, screen examples, and database configurations shown in this specification and drawings can be changed as desired unless otherwise specified.

[0073] Furthermore, with regard to real estate rental management device 100, the components shown in the figures are functional concepts, and do not necessarily have to be physically configured as shown in the figures.

[0074] For example, all or any part of the processing functions of real estate rental management device 100, particularly the processing functions performed by control unit 102, may be implemented by a CPU and a program interpreted and executed by the CPU, or may be implemented as hardware using wired logic. The program is recorded on a non-transitory, computer-readable recording medium containing programmed instructions for causing the information processing device to execute the processes described in this embodiment, and is mechanically read by real estate rental management device 100 as needed. That is, a computer program for providing instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive). This computer program is executed by being loaded into RAM, and cooperates with the CPU to form the control unit.

[0075] In addition, this computer program may be stored in an application program server connected to real estate rental management device 100 via any network, and it is also possible to download all or part of it as needed.

[0076] Furthermore, the program for executing the processes described in this embodiment may be stored in a non-transitory computer-readable recording medium or configured as a program product. Here, the term "recording medium" includes any "portable physical medium" such as a memory card, a Universal Serial Bus (USB) memory, a Secure Digital (SD) card, a flexible disk, a magneto-optical disk, a ROM, an Erasable Programmable Read Only Memory (EPROM), an Electrically Erasable and Programmable Read Only Memory (EEPROM (registered trademark)), a Compact Disk Read Only Memory (CD-ROM), a Magneto-Optical disk (MO), a Digital Versatile Disk (DVD), and a Blu-ray (registered trademark) disc.

[0077] Furthermore, a "program" is a data processing method written in any language or description method, and does not matter whether it is in the form of source code or binary code. Note that a "program" is not necessarily limited to a single structure, but also includes a structure that is distributed as multiple modules or libraries, or a structure that achieves its function by cooperating with a separate program, such as an OS. Note that the specific configuration and reading procedure for reading a recording medium in each device shown in this embodiment, as well as the installation procedure after reading, can use well-known configurations and procedures.

[0078] The various databases stored in the memory 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, and store various programs, tables, databases, and web page files used for various processes and providing websites.

[0079] Furthermore, real estate rental management 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 connected to any peripheral device. Furthermore, real estate rental management device 100 may be realized by installing software (including programs, data, etc.) that causes the device to realize the processing described in this embodiment.

[0080] Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the drawings, and all or part of them can be configured by functionally or physically distributing and integrating them in any unit depending on various additions or functional loads. In other words, the above-described embodiments can be implemented in any combination, or embodiments can be implemented selectively. [Industrial Applicability]

[0081] The present invention is useful in industries such as the real estate industry, including the rental management industry. [Explanation of symbols]

[0082] 100 Real estate rental management device 102 Control section 102a Contract Acquisition Department 102b Occupancy Statement Issuance Department 102c Deposit Acquisition Department 102d Evacuation Acquisition Department 102e Moving-out Statement Issuance Department 102f Journal Entry Preparation Department 104 Communication interface unit 106 Storage section 106a Rental Management Database 108 Input / Output Interface Section 112 Input Device 114 Output Device 200 servers 300 Network

Claims

1. A real estate rental management device comprising a memory unit and a control unit, The storage unit a rental management storage means for storing data on the scheduled collection of rent at the time of occupancy, which is set by linking the rent items including the billing year and month of rent at the time of occupancy, security deposit and security deduction, and the billing amount in the rental contract, and an accounting pattern master set by linking the consignment type in the rental contract, the rent items, and account items; Equipped with The control unit a deposit acquisition means for acquiring deposit data that is set by linking the deposit date and the deposit amount; a journal entry creation means for creating journal entry data for security deposit sales at the time of occupancy and journal entry data for security deposit sales at the time of occupancy corresponding to the type of consignment based on the journal entry pattern master, the data for scheduled collection at the time of occupancy, and the data for deposit; A real estate rental management device comprising:

2. The control unit an occupancy statement issuing means for creating occupancy statement data for an initial contract in which the rent items and the billing amount are set based on the occupancy collection schedule data, and printing out the occupancy statement data; 2. The real estate rental management device according to claim 1, further comprising:

3. The rental management storage means an output setting master that is set by linking a summary item that aggregates a plurality of the rent items and documents to be output; Further memorize, The occupancy statement issuing means The real estate rental management device described in claim 2, characterized in that it creates the occupancy statement data, which sets the summary items that consolidate the security deposit and the security deduction, and the total amount of the invoice amount for the security deposit and the security deduction, based on the output setting master and the data on the scheduled collection at the time of occupancy, and prints out the occupancy statement data.

4. The rental management storage means Monthly rental contract data setting the monthly rent, the security deposit, and the security deposit; Further memorize, The control unit a move-out acquisition means for, when a termination date of the rental contract is set, calculating the number of days pro rata for the termination month, acquiring move-out data that sets the termination date and the number of days pro rata for the termination month, and acquiring scheduled collection data at the time of termination that sets the rent amount for the termination month based on the rental contract monthly data and the move-out data; a move-out settlement statement issuing means for calculating the settlement amount based on the monthly rental contract data and the cancellation collection schedule data, creating a move-out settlement statement data that sets the deposit amount at the time of moving in, the rent amount for the cancellation month, the security deposit amount, and the settlement amount, and printing out the move-out settlement statement data; 4. The real estate rental management device according to claim 1, further comprising:

5. The journal entry creation means The real estate rental management device described in claim 4, further characterized in that it creates departure settlement security deposit journal data and departure settlement rent journal data corresponding to the entrustment type based on the journal pattern master and the departure settlement statement data.

6. The journal entry creation means 6. The real estate rental management device according to claim 5, further comprising: a step of generating deposit journal data based on the journal pattern master and the deposit data.

7. The deposit acquisition means is Furthermore, based on the deposit data and the move-in collection schedule data, deposit reconciliation data is acquired that sets the deposit reconciliation date and the reconciled deposit amount; The journal entry creation means The real estate rental management device according to claim 6, further comprising: a security deposit reconciliation journal data and a security deduction reconciliation journal data based on the journal pattern master, the deposit data, and the deposit reconciliation data.

8. The journal entry creation means 5. The real estate rental management device according to claim 4, further comprising: generating rent sales journal data at the time of cancellation corresponding to the entrustment type based on the journal pattern master and the cancellation collection schedule data.

9. The control unit a contract acquisition means for calculating the number of days in a contracted month when the contract date of the rental contract and the amount to be charged for each rent item are set, acquiring contract data in which the contract date and the number of days in a contracted month are set and monthly rental contract data in which the amount to be charged for each rent item is set, and acquiring the scheduled collection data at the time of occupancy based on the monthly rental contract data and the contract data; 4. The real estate rental management device according to claim 1, further comprising:

10. The entrustment form is:

4. The real estate rental management device according to claim 1, wherein the real estate rental management device is a guarantee for delinquent payments or a company property.

11. A real estate rental management method to be executed by a real estate rental management device having a memory unit and a control unit, The storage unit a rental management storage means for storing data on the scheduled collection of rent at the time of occupancy, which is set by linking the rent items including the billing year and month of rent at the time of occupancy, security deposit and security deduction, and the billing amount in the rental contract, and an accounting pattern master set by linking the consignment type in the rental contract, the rent items, and account items; Equipped with Executed in the control unit: a deposit acquisition step for acquiring deposit data that is set by linking the deposit date and the deposit amount; a journal entry creation step of creating journal entry data for security deposit sales at the time of occupancy and journal entry data for security deposit sales at the time of occupancy corresponding to the type of consignment based on the journal entry pattern master, the data for scheduled collection at the time of occupancy, and the data for deposit; A real estate rental management method comprising:

12. A real estate rental management program to be executed by a real estate rental management device having a storage unit and a control unit, The storage unit a rental management storage means for storing data on the scheduled collection of rent at the time of occupancy, which is set by linking the rent items including the billing year and month of rent at the time of occupancy, security deposit and security deduction, and the billing amount in the rental contract, and an accounting pattern master set by linking the consignment type in the rental contract, the rent items, and account items; Equipped with In the control unit, a deposit acquisition step for acquiring deposit data that is set by linking the deposit date and the deposit amount; a journal entry creation step of creating journal entry data for security deposit sales at the time of occupancy and journal entry data for security deposit sales at the time of occupancy corresponding to the type of consignment based on the journal entry pattern master, the data for scheduled collection at the time of occupancy, and the data for deposit; A real estate rental management program to help you achieve this.

Images