Business support device, business support method, and business support program

Abstract

To provide a business support device capable of simplifying the transfer process to custodial accounts and reducing the workload of banking staff, a business support method, and a business support program.SOLUTION: A business support method includes the steps of: referencing computation data of fund transfer data storing data including balance information of a prescribed real estate, subtracts other balances other than an end-of-last-moth balance from the end-of-last-month balance, and determining whether the calculation amount obtained by the subtraction is higher than or equal to the other balances; when determining that the calculation amount is higher than or equal to the other balances, it references monthly account balance data for managing the account titles and amount of the prescribed real estate and acquiring real estate-related amounts other than the administrative fee of the real estate; referencing a property passbook master for managing passbook information of the prescribed real estate and acquiring transfer destination bank information associated with the attributes of the acquired amount; and storing the acquired amount and transfer destination bank information in fund transfer data for managing transfer fund.SELECTED DRAWING: Figure 2

Description

[Technical Field]

[0001] The present invention relates to a business support device, a business support method, and a business support program. [Background technology]

[0002] Patent Document 1 discloses a method and system for using the condominium management association's current bank account as is to collect funds in the condominium management company's account and transfer them to the payment request agent's account. [Prior art documents] [Patent documents]

[0003] [Patent Document 1] Japanese Patent Application Laid-Open No. 2015-125452 Summary of the Invention [Problem to be solved by the invention]

[0004] In accounting for real estate management, there are situations where management fees are received and transferred from the account under management to a savings account. Condominium management companies, in particular, are entrusted by condominium management associations and handle accounting within the scope of their management contract. Condominium management companies are required to perform management operations in accordance with the Condominium Management Optimization Act. Therefore, in accordance with Article 87, Paragraph 2, Item 1, (i) and (ii) of the Condominium Management Optimization Act's Enforcement Regulations, they are required to transfer the collected management fees, excluding the management contract fee for the current month, from the collection account to the custody account by the end of the following month. Deposits into the collection account include monthly direct debits and daily transfers of management fees and reserve funds from condominium unit owners, and payments from the account include payments of commission fees to the condominium management company. Because the amount transferred to the custody account fluctuates depending on monthly collection status and payment schedules, the process of transferring funds to the custody account is prone to errors and places an increased burden on staff.

[0005] The present invention has been made in consideration of the above, and aims to provide a business support device, a business support method, and a business support program that can simplify the transfer process to a custody account and reduce the workload of business personnel. [Means for solving the problem]

[0006] In order to solve the above-mentioned problems and achieve the object, the business support device of the present invention is characterized by comprising: a first balance determination unit that refers to first data storing data including balance information of a specified real estate, subtracts other balances other than the balance at the end of the previous month from the balance at the end of the previous month, and determines whether the calculated amount obtained by the subtraction is equal to or greater than the other balance; an amount acquisition unit that, if the first balance determination unit determines that the calculated amount is equal to or greater than the other balance, refers to second data managing the account items and amounts of the specified real estate, and acquires amounts related to the real estate other than real estate management fees; a bank information acquisition unit that refers to a third master that manages the passbook information of the specified real estate, and acquires destination bank information linked to the attributes of the amount acquired by the amount acquisition unit; and a funds transfer data generation unit that stores the acquired amount and the acquired destination bank information in funds transfer data managing the funds to be transferred.

[0007] Furthermore, in the business support device according to the present invention, the first balance determination unit refers to the first data and subtracts the unpaid balance and the deposit balance as the other balance from the balance at the end of the previous month, and determines whether the calculated amount obtained by the subtraction is equal to or greater than the separate attribute account balance which is the sum of the reserve amount and the income amount, and when the first balance determination unit determines that the calculated amount is equal to or greater than the separate attribute account balance, the amount acquisition unit refers to a fourth master that manages accounting categories that classify accounts and transfer accounts, and acquires the reserve fund accounting category related to the reserve and the special account category related to the income, and further acquires the reserve fund accounting transfer identification information and and special account transfer identification information linked to the special accounting category, and by referring to the second data, acquires the reserve amount linked to the reserve account transfer identification information and the revenue amount linked to the special account transfer identification information, the bank information acquisition unit by referring to the third master acquires reserve fund destination bank information linked to the reserve fund accounting category acquired by the amount acquisition unit and revenue destination bank information linked to the reserve fund accounting category acquired by the amount acquisition unit, and the funds transfer data generation unit stores the reserve amount, the reserve fund destination bank information, the revenue amount and the revenue destination bank information in the funds transfer data.

[0008] Furthermore, the business support device according to the present invention further comprises a second balance determination unit that refers to the first data, subtracts other balances other than the balance at the end of the previous month from the balance at the end of the previous month, and determines whether the calculated amount obtained by the subtraction is greater than 0; the bank information acquisition unit refers to the third master, and acquires destination bank information for the calculated amount that is linked to the attributes of the calculated amount calculated by the second balance determination unit; and the funds transfer data generation unit stores the calculated amount calculated by the second balance determination unit and the destination bank information acquired by the bank information acquisition unit in the funds transfer data.

[0009] Furthermore, in the business support device according to the present invention, the second balance determination unit refers to the first data and subtracts the separate attribute balance, which is the sum of the unpaid balance, deposit balance, savings amount, and revenue amount as the other balance, from the balance at the end of the previous month, and determines whether the calculated amount obtained by the subtraction is greater than 0; if the second balance determination unit determines that the calculated amount is greater than 0, the bank information acquisition unit refers to the third master and acquires destination bank information for storing management fees, which is an attribute of the calculated amount calculated by the second balance determination unit; and the funds transfer data generation unit stores the calculated amount calculated by the second balance determination unit and the destination bank information acquired by the bank information acquisition unit in the funds transfer data.

[0010] Furthermore, in the business support device according to the present invention, the second data stores the amount collected for real estate, the amount outstanding for real estate, the amount on deposit for real estate, the amount of savings for real estate, and the amount of revenue from real estate, and the first data stores the amount collected as the balance at the end of the previous month, the amount of savings and the amount of revenue as the separate attribute account balance, the amount outstanding is aggregated as the outstanding balance, and the amount on deposit is aggregated as the remaining deposit balance.

[0011] The business support device according to the present invention is characterized by further comprising a journal data generation unit that generates journal data based on the fund transfer data.

[0012] The real estate in the business support device according to the present invention is characterized in that it is a building that is solely owned or jointly owned, or a building that is subject to compartmentalized ownership.

[0013] Furthermore, the business support method according to the present invention includes a first balance determination step in which a first balance determination unit refers to first data storing data including balance information for a specified real estate, subtracts other balances other than the balance at the end of the previous month from the balance at the end of the previous month, and determines whether the calculated amount obtained by the subtraction is equal to or greater than the other balance; an amount acquisition step in which, if the first balance determination unit determines that the calculated amount is equal to or greater than the other balance, the amount acquisition unit refers to second data managing the account items and amounts of the specified real estate and acquires amounts related to the real estate other than real estate management fees; a bank information acquisition step in which a bank information acquisition unit refers to a third master managing passbook information for the specified real estate, and acquires destination bank information linked to attributes of the amount acquired by the amount acquisition unit; and a funds transfer data generation step in which a funds transfer data generation unit stores the acquired amount and the acquired destination bank information in funds transfer data managing funds to be transferred.

[0014] In addition, the business support program of the present invention causes an information processing device to function as: a first balance determination means that refers to first data storing data including balance information for a specified real estate, subtracts other balances other than the balance at the end of the previous month from the balance at the end of the previous month, and determines whether the calculated amount obtained by the subtraction is equal to or greater than the other balance; an amount acquisition means that, if the first balance determination means determines that the calculated amount is equal to or greater than the other balance, refers to second data managing the account items and amounts of the specified real estate, and acquires amounts related to the real estate other than real estate management fees; a bank information acquisition means that refers to a third master that manages the bankbook information of the specified real estate, and acquires destination bank information linked to the attributes of the amount acquired by the amount acquisition means; and a funds transfer data generation means that stores the acquired amount and the acquired destination bank information in funds transfer data that manages the funds to be transferred. [Effects of the Invention]

[0015] The present invention has the effect of simplifying the transfer process to a custody account and reducing the workload of the person in charge. [Brief explanation of the drawings]

[0016] [Figure 1] FIG. 1 is a diagram showing an example of the configuration of a business support device according to this embodiment. [Figure 2] FIG. 2 is a diagram showing an example of an outline of a data flow according to this embodiment. [Figure 3] FIG. 3 is a diagram showing an example of a property accounting category master maintenance screen and a property accounting category master according to this embodiment. [Figure 4] FIG. 4 is a diagram showing an example of an account item master maintenance screen and an account item master according to this embodiment. [Figure 5] FIG. 5 is a diagram showing an example of a property passbook master maintenance screen and a property passbook master according to this embodiment. [Figure 6] FIG. 6 is a diagram showing an example of monthly account balance data according to this embodiment. [Figure 7] FIG. 7 is a diagram showing an example of a funds transfer data creation processing screen and processing according to this embodiment. [Figure 8] FIG. 8 is a diagram showing an example of the funds transfer data creation process according to this embodiment. [Figure 9] FIG. 9 is a diagram showing an example of the funds transfer data creation process according to this embodiment. [Figure 10] FIG. 10 is a diagram showing an example of the funds transfer data creation process according to this embodiment. [Figure 11] FIG. 11 is a diagram showing an example of the funds transfer data creation process according to this embodiment. [Figure 12] FIG. 12 is a diagram showing an example of the funds transfer data creation process according to this embodiment. [Figure 13] FIG. 13 is a diagram showing an example of the funds transfer data creation process according to this embodiment. [Figure 14] FIG. 14 is a diagram showing an example of the journal data creation process according to this embodiment. DETAILED DESCRIPTION OF THE INVENTION

[0017] DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS Preferred embodiments of a business support device, a business support method, and a business support program according to the present invention will be described in detail below with reference to the accompanying drawings. However, the present invention is not limited to the preferred embodiments.

[0018] [1. Configuration] An example of the configuration of a task assistance device 100 according to this embodiment will be described with reference to Fig. 1 etc. Fig. 1 is a block diagram showing an example of the configuration of the task assistance device 100.

[0019] The business support device 100 is constructed based on a commercially available desktop personal computer. Note that the business support device 100 is not limited to being constructed based on a stationary information processing device such as a desktop personal computer, but may also be constructed based on a portable information processing device such as a commercially available notebook personal computer, a PDA (Personal Digital Assistant), a smartphone, or a tablet personal computer.

[0020] The business assistance device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. The units included in the business assistance device 100 are connected to each other so as to be able to communicate with each other via any communication path.

[0021] The communication interface unit 104 communicably connects the business assistance device 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with other devices via the communication line. Here, the network 300 has a function of connecting the business assistance device 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 the data stored in the memory unit 106 may be stored in the server 200, for example.

[0022] 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 home television), 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, and the input device 112 may be referred to as the keyboard 112 or the mouse 112.

[0023] Various databases, tables, files, etc. are stored in the storage unit 106. Computer programs that work in conjunction with the OS (Operating System) to issue commands to the CPU (Central Processing Unit) to perform various processes are recorded in the storage unit 106. 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, an optical disk, etc.

[0024] The memory unit 106 stores a property accounting classification master 106a (included in the fourth master of the present invention), an account item master 106b, a property passbook master 106c (included in the third master of the present invention), monthly account balance data 106d (included in the second data of the present invention), fund transfer data calculation data 106e (included in the first data of the present invention), and fund transfer data 106f (corresponding to the fund transfer data of the present invention), etc.

[0025] An example of information stored in the property accounting category master 106a is shown in Figure 3. The property accounting category master 106a is used to manage the accounting category and transfer account for each property set on the property accounting category master maintenance screen MA. As shown in Figure 3, the property accounting category master 106a stores property identification information (e.g., property code, etc.), accounting category, property accounting name, transfer account identification information (e.g., transfer account code, transfer account name, etc.), etc.

[0026] An example of information stored in the account item master 106b is shown in Figure 4. The account item master 106b is used to manage account classifications such as account codes, account names, and accounts payable, which are set on the account item master maintenance screen MB. As shown in Figure 4, the account item master 106b stores account identification information (e.g., account codes, account names, etc.) and account classifications, etc.

[0027] An example of information stored in the property passbook master 106c is shown in Figure 5. The property passbook master 106c is used to manage bank accounts for each property according to the purpose set on the property passbook master maintenance screen MC. As shown in Figure 5, the property passbook master 106c stores property identification information, passbook identification information (e.g., passbook code, passbook name, etc.), account classification distinguishing between a receiving account and a custodial account, accounting classification and subject identification information distinguishing between general accounting (management fees, etc.), reserve fund accounting (repair reserves, etc.), and special accounting (profits from condominiums, etc.), etc.

[0028] An example of information stored in the monthly account balance data 106d is shown in Figure 6. The monthly account balance data 106d is used to manage the amounts tallied for each item for each target year and month. As shown in Figure 6, the monthly account balance data 106d stores item identification information, accounting classification, target year and month, amount, etc.

[0029] 8 shows an example of information stored in the funds transfer data calculation data 106e. The funds transfer data calculation data 106e is used to manage the balance by bankbook for each property. As shown in FIG. 8, the funds transfer data calculation data 106e stores property identification information, bankbook identification information, the balance at the end of the month preceding the processing month specified on the funds transfer data creation processing screen MD (e.g., the balance at the end of the month preceding the processing month), the aggregate amount of categories other than the general account category at the end of the month preceding the processing month specified on the funds transfer data creation processing screen MD (e.g., the balance of other accounts), the aggregate amount of the account category of accounts payable at the end of the month preceding the processing month specified on the funds transfer data creation processing screen MD (e.g., the balance of accounts payable), the aggregate amount of the account category of deposits at the end of the month preceding the processing month specified on the funds transfer data creation processing screen MD (e.g., the balance of deposits), etc.

[0030] An example of information stored in the funds transfer data 106f is shown in Figure 12. The funds transfer data 106f is used to manage the transfer of funds for each property. As shown in Figure 12, the funds transfer data 106f stores property identification information, bankbook identification information of the source of the funds transfer (e.g., source bankbook code, etc.), bankbook identification information of the destination of the funds transfer (e.g., destination bankbook code, etc.), transfer date, transfer amount, etc.

[0031] 2, the control unit 102 is a CPU or the like that performs overall control of the business support 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 operations based on these stored programs.

[0032] In terms of functional concept, the control unit 102 comprises a property accounting classification master maintenance unit 102a, an account item master maintenance unit 102b, a property passbook master maintenance unit 102c, a funds transfer data creation processing unit 102d (including the first balance determination unit, second balance determination unit, amount acquisition unit, bank information acquisition unit and funds transfer data generation unit of the present invention), and a journal data creation processing unit 102e (including the journal data generation unit of the present invention).

[0033] The property accounting category master maintenance unit 102a displays the property accounting category master maintenance screen MA on the monitor 114, and has the operator or the like set the property code in area MA2, the accounting category in area MA3, the property accounting name in area MA4, and the transfer account in area MA5, and then press the register button MA1. The property accounting category master maintenance unit 102a then stores the set information in the property accounting category master 106a and generates the property accounting category master 106a (see Figure 3).

[0034] The account item master maintenance unit 102b displays the account item master maintenance screen MB on the monitor 114, and has the operator or the like set the account code in area MB2, the account name in area MB3, and the account classification in area MB4, and then press the register button MB1. The account item master maintenance unit 102b then stores the information set by the operator or the like in the account item master 106b, and generates the account item master 106b (see FIG. 4).

[0035] The property passbook master maintenance unit 102c displays the property passbook master maintenance screen MC on the monitor 114, and has the operator or the like enter the property code in area MC2, the passbook code in area MC3, the passbook name in area MC4, the account classification in area MC5, the accounting classification in area MC6, and the subject in area MC7, and then press the register button MC1. The property passbook master maintenance unit 102c then stores the information entered by the operator or the like in the property passbook master 106c, and generates the property passbook master 106c (see FIG. 5).

[0036] The funds transfer data creation processor 102d performs the following processes (11) to (20) (see FIGS. 7 to 13). (11) The funds transfer data creation processing screen MD is displayed on the monitor 114 (see FIG. 7). (12) The operator or the like sets the processing date in the area MD1, sets the fund transfer date in the area MD2, and instructs the creation of fund transfer data. (13) Refer to the property passbook master 106c, obtain the item whose account classification is "1: Receipt account" and whose accounting classification is "1: General account", refer to the monthly account balance data 106d, identify the record whose target year and month includes the obtained item name and the month before the processing year and month set in area MD1, obtain and aggregate the amount of the identified record, store it in the column name "Balance at the end of previous month" of the record containing the property code and passbook code in the funds transfer data calculation data 106e, and update the funds transfer data calculation data 106e (see Figure 8). Here, the property code and passbook code registered in the property passbook master 106c are set in the funds transfer data calculation data 106e. (14) Refer to the property accounting category master 106a to obtain the transfer account linked to an accounting category other than “1: General Accounting”, refer to the monthly account balance data 106d, identify the record that includes the obtained transfer account in the column name “Account Name” and further includes the month before the processing month set in the area MD1 in the column name “Target Month”, obtain and aggregate the amount of the identified record, store it in the column name “Other Account Balance” of the record that includes the property code and passbook code of the funds transfer data calculation data 106e, and update the funds transfer data calculation data 106e (see Figure 9). (15) By referring to the account item master 106b, the account associated with the account classification “1: Accounts Payable” is acquired, and by referring to the monthly account balance data 106d, a record is identified in which the acquired account name and the month before the processing month set in the area MD1 are included in the target month, and the amount of the identified record is acquired and totaled, and stored in the column name “Accounts Payable Balance” of the record including the property code and bankbook code in the funds transfer data calculation data 106e, thereby updating the funds transfer data calculation data 106e (see Figure 10). (16) By referring to the account item master 106b, the account associated with the account classification "2: Deposit" is acquired, and by referring to the monthly account balance data 106d, a record is identified in which the acquired account name and the month before the processing month set in the area MD1 are included in the target month, and the amount of the identified record is acquired and aggregated, and stored in the column name "Deposit Balance" of the record including the property code and passbook code in the funds transfer data calculation data 106e, and the funds transfer data calculation data 106e is updated (see Figure 11). (17) If the value calculated by subtracting the combined amount of the “unpaid balance” and the “deposit balance” from the “previous month end balance” in the updated fund transfer data calculation data 106e is equal to or greater than the amount of the “other account balance,” the process proceeds to (18); if the calculated value is less than the amount of the “other account balance,” the process proceeds to (19). (18-1) Refer to the property accounting classification master 106a to obtain an accounting classification other than "1: General Accounting", obtain an accounting classification linked to an accounting classification other than "1: General Accounting" and a transfer account linked to the accounting classification, refer to the monthly account balance data 106d, identify a record that includes the obtained transfer account in the column name "Account Name" and further includes the month before the processing month set in area MD1 in the column name "Target Year and Month", and obtain the amount. Furthermore, refer to the property bankbook master 106c to obtain the bankbook code and bankbook name linked to the obtained accounting classification (see Figure 12). (18-2) Enter the property code and property name of the fund transfer data calculation data 106e into the column name “Property Code” of the fund transfer data 106f. The column name "Source bankbook code" of the fund transfer data 106f is set to the bankbook code of the fund transfer data calculation data 106e linked with the property code. Enter the bankbook code and bankbook name corresponding to the acquired accounting classification in the column name "Destination bankbook code" of the fund transfer data 106f. The column name "Transfer Date" of the fund transfer data 106f is the transfer date set on the fund transfer data creation processing screen MD. The acquired amount corresponding to the bankbook code stored in the destination bankbook code is entered in the column name "Amount" of the fund transfer data 106f. The data is stored, the data of the fund transfer data 106f is created, and the fund transfer data 106f is updated (see FIG. 12). (19) If the value calculated by subtracting the total amount of the “unpaid balance,” “deposit balance,” and “other account balance” from the “previous month end balance” in the updated fund transfer data calculation data 106e is greater than “0,” proceed to processing (20); if the calculated value is “0” or less, determine to end the processing. (20-1) The property passbook master 106c is referenced, and the passbook code and passbook name for which the accounting category is "1: general accounting" and the account category is "custody account" are acquired (see FIG. 13). (20-2) Enter the property code and property name of the fund transfer data calculation data 106e into the column name “Property Code” of the fund transfer data 106f. The column name "Source bankbook code" of the fund transfer data 106f is set to the bankbook code of the fund transfer data calculation data 106e linked with the property code. Enter the acquired passbook code and passbook name in the column name "Destination passbook code" of the fund transfer data 106f. The column name "Transfer Date" of the fund transfer data 106f is the transfer date set on the fund transfer data creation processing screen MD. The value calculated by subtracting the total amount of "unpaid balance", "deposit balance" and "other account balance" from the "previous month end balance" of the updated fund transfer data calculation data 106e is set in the column name "amount" of the fund transfer data 106f. The data is stored, the data of the fund transfer data 106f is created, and the fund transfer data 106f is updated (see FIG. 13).

[0037] The journal data creation processing unit 102e displays the journal data creation processing screen ME on the monitor 114, prompts the operator to set the processing year and month in area ME1, and instructs the execution of the journal creation processing. The journal data creation processing unit 102e then creates journal data based on the funds transfer data 106f (see FIG. 14).

[0038] [2. Processing Overview] The outline is explained as shown in Figure 2. Regarding the journal data creation process: For example, in the case of condominium management, billing of management fees and reserve funds to condominium unit owners, and processing of payment settlements are carried out. In conjunction with this, payment schedule data, payment data, and deposit data are created through input by operators, etc., and journal data is created on a monthly basis based on each of the created data.

[0039] Regarding the fund transfer data creation process (the boxed area in Figure 2): Based on the monthly account balance data, which is one of the various detailed data generated to create journal data by the journal data creation process, fund transfer data is created by re-tallying it using the property accounting classification master, account item master, and property passbook master. Then, journal data is created based on the fund transfer data.

[0040] Regarding the FB data creation process: FB (firm banking) data is created based on fund transfer data.

[0041] [3. Specific examples of processing] A specific example of the processing executed by the task assistance device 100 configured as described above will be described in detail along with an example of the flow of a task performed using the task assistance device 100, with reference to FIGS. 3 to 14 and the like.

[0042] [1: Master setup (Steps S1 to S3)] Before starting the process, an operator or the like sets various master data.

[0043] First, the operator or the like issues an instruction to display the property accounting classification master maintenance screen MA.

[0044] Then, the property accounting division master maintenance unit 102a displays the property accounting division master maintenance screen MA on the monitor 114 (see FIG. 3).

[0045] First, the operator sets the property code "0001" in area MA2, the accounting category "1" in area MA2, the property accounting name "general accounting" in area MA4, and the transfer account code "8000" in area MA5, and then presses the register button MA1 (see Figure 3).

[0046] The property accounting category master maintenance unit 102a then stores the information set by the operator or the like on the property accounting category master maintenance screen MA in the property accounting category master 106a along with the preset property code, and generates the property accounting category master 106a (step S1, see Figure 3). The operator or the like performs registration processing for the general account into which management fees and repair reserves, etc. are transferred from the Kyobashi Condominium condominium owners, the reserve fund account that manages the amount of the transferred amount that corresponds to the reserve fund for repairs, etc., and the special account that manages the amount related to the condominium's revenue, such as parking lots, and generates the property accounting category master 106a in Figure 3.

[0047] Next, the operator or the like instructs the display of the account item master maintenance screen MB.

[0048] Then, the account item master maintenance unit 102b displays the account item master maintenance screen MB on the monitor 114 (see FIG. 4).

[0049] The operator sets the account code "3500" in area MB2, the account name "Unpaid commission fee" in area MB3, and the account classification "1" in area MB4, and then presses the register button MB1 (see Figure 4).

[0050] Then, the account item master maintenance unit 102b stores the information set by the operator or the like in the account item master 106b, and generates the account item master 106b for managing account items (step S2, see Figure 4). The operator or the like repeats the registration process to set the necessary account classifications as shown in Figure 4, and generates the account item master 106b.

[0051] Next, the operator or the like issues an instruction to display the property passbook master maintenance screen MC.

[0052] Then, the property passbook master maintenance unit 102c displays a property passbook master maintenance screen MC on the monitor 114 (see FIG. 5).

[0053] The operator etc. sets the property code "0001" in area MC2, the bankbook code "1" in area MC3, the bankbook name "AA Bank (collection / general)" in area MC4, the account category "1" in area MC5, the accounting category "1" in area MC6, and the subject "1000" in area MC7, and presses the register button MC1 (see Figure 5).

[0054] Then, the property passbook master maintenance unit 102c stores the information set by the operator or the like in the property passbook master 106c and generates the account item master 106b (step S3, see FIG. 5). The operator or the like repeats the registration process for the necessary passbooks and generates the property passbook master 106c shown in FIG. 5.

[0055] [2: Funds transfer data creation process (Step S4)] The funds transfer data creation process (step S4) is performed by the funds transfer data creation processing unit 102d. The funds transfer data creation processing unit 102d performs the process after the property accounting classification master 106a, account title master 106b, and property passbook master 106c have been generated in advance.

[0056] First, the operator or the like issues an instruction to display the funds transfer data creation processing screen MD corresponding to the registered real estate.

[0057] The funds transfer data creation processing unit 102d then displays the funds transfer data creation processing screen MD on the monitor 114 (see FIG. 7).

[0058] The operator etc. sets "2023 / 5" in the processing year and month field MD1 and "2023 / 5 / 20" in the funds transfer date field MD2, and issues an instruction to create funds transfer data (see Figure 7).

[0059] (4-1) Then, the funds transfer data creation processing unit 102d refers to the property passbook master 106c, acquires the item "1000: Current deposit (collection / general)" whose account classification is "1: Receipt account" and whose accounting classification is "1: General accounting", and refers to the monthly account balance data 106d, identifies a record that includes the acquired item name "1000: Current deposit (collection / general)" and the target month "2023 / 4" of the month before the processing month "2023 / 5" set in the area MD1, acquires the amount "400,000", and stores the acquired "400,000" in the column name "Balance at the end of the previous month" of the record of the property code "0001: Kyobashi Mansion" and the passbook code "1: AA Bank (collection / general)" in the funds transfer data calculation data 106e, thereby updating the funds transfer data calculation data 106e (see Figure 8).

[0060] (4-2) Next, the funds transfer data creation processing unit 102d refers to the property accounting category master 106a and obtains the transfer account "8100: Reserve fund accounting transfer" linked to the accounting category "2: Reserve fund accounting" other than the accounting category "1: General accounting", and the transfer account "8300: Special accounting transfer" linked to the accounting category "3: Special accounting". Furthermore, the funds transfer data creation processing unit 102d refers to the monthly account balance data 106d, identifies records that include the acquired transfer account "8100: Reserve fund account transfer" or the acquired transfer account "8300: Special account transfer" in the column name "Account name", and further include the month before the processing year and month "2023 / 5" set in area MD1, "2023 / 4", in the column name "Target year and month", acquires and aggregates the amounts "200,000" and "45,000" from the identified records, and stores the aggregated result of "245,000" in the column name "Other account balance" of the record with the property code "0001: Kyobashi Mansion" and the passbook code "1: AA Bank (Collection / General)" in the funds transfer data calculation data 106e, thereby updating the funds transfer data calculation data 106e (see Figure 9).

[0061] (4-3) Next, the funds transfer data creation processing unit 102d refers to the account item master 106b, obtains the account codes "3500" and "3600" associated with the account classification "1: Accounts Payable", refers to the monthly account balance data 106d, identifies records whose target year and month includes the obtained account code "3500" or "3600" and "2023 / 4", the month before the processing year and month "2023 / 5" set in the area MD1, obtains and aggregates the amounts "100,000" and "5,000", and stores the aggregated result "105,000" in the column name "Accounts Payable Balance" of the record of the property code "0001: Kyobashi Mansion" and the passbook code "1: AA Bank (Collection / General)" in the funds transfer data calculation data 106e, thereby updating the funds transfer data calculation data 106e (see Figure 10).

[0062] (4-4) Next, the funds transfer data creation processing unit 102d refers to the account item master 106b, obtains the account code "4500" associated with the account classification "2: Deposit", refers to the monthly account balance data 106d, identifies a record whose target year and month includes the obtained account code "4500" and "2023 / 4", the month before the processing year and month "2023 / 5" set in area MD1, obtains the amount "30,000", and stores the obtained amount "30,000" in the column name "Deposit Balance" of the record of the property code "0001: Kyobashi Mansion" and the passbook code "1: AA Bank (Collection / General)" in the funds transfer data calculation data 106e, thereby updating the funds transfer data calculation data 106e (see Figure 11).

[0063] (4-5) Next, the funds transfer data creation processing unit 102d calculates the value of 4-1 - (the value of 4-3 + the value of 4-4). Specifically, it subtracts the sum of the value of 4-3 (unpaid balance) "105,000" and the value of 4-4 (deposit balance) "30,000" from the value of 4-1 (balance at the end of the previous month) "400,000" to calculate "265,000". Because this is greater than the value of 4-2 (other account balance) "245,000", the process proceeds to process (4-6) (funds transfer data creation process for each custody account other than the general account). Note that if the calculated value is equal to or less than the value of 4-2 (other account balance) "245,000", the process proceeds to process (4-7).

[0064] (4-6) Next, the funds transfer data creation processing unit 102d refers to the property accounting category master 106a, acquires the accounting category "2: Reserve fund accounting" and the accounting category "3: Special accounting" other than the accounting category "1: General accounting", and acquires the transfer account "8100: Reserve fund accounting transfer" linked to the accounting category "2: Reserve fund accounting" and the transfer account "8300: Special accounting transfer" linked to the accounting category "3: Special accounting". Furthermore, the funds transfer data creation processing unit 102d refers to the monthly account balance data 106d, identifies records that include the acquired transfer account "8100: Reserve fund accounting transfer" or "8300: Special account transfer" in the column name "Subject" and further include the month before the processing year and month "2023 / 5" set in area MD1, "2023 / 4", in the column name "Target year and month", and acquires the amount "200,000" linked to the subject "8100: Reserve fund accounting transfer" and the amount "45,000" linked to the subject "8300: Special account transfer". Furthermore, the funds transfer data creation processing unit 102d refers to the property passbook master 106c and obtains the passbook code and passbook name "3: AA Bank (custody / savings)" linked to the acquired accounting category "2: Reserve fund accounting" and the passbook code and passbook name "4: AA Bank (custody / special)" linked to the acquired accounting category "3: Special accounting."

[0065] The funds transfer data creation processing unit 102d sets the column name "property code" of the funds transfer data 106f to "0001: Kyobashi Mansion", the column name "source bankbook code" of the funds transfer data 106f to the bankbook code "1: AA Bank (receiving / general)" of the funds transfer data calculation data 106e linked with the property code "0001: Kyobashi Mansion", and the column name "destination bankbook code" of the funds transfer data 106f to the bankbook code "2: Deposit Accounting" linked with the acquired accounting category. The ledger code and passbook name "3: AA Bank (custody / savings)" are stored, the transfer date "2023 / 5 / 20" set on the funds transfer data creation processing screen MD is stored in the column name "transfer date" of funds transfer data 106f, the amount "200,000" linked to the acquired "8100: Savings Accounting Transfer" is stored in the column name "amount" of funds transfer data 106f, data is created for funds transfer data 106f, and funds transfer data 106f is updated (see Figure 12).

[0066] The funds transfer data creation processing unit 102d sets the column name "property code" of the funds transfer data 106f to "0001: Kyobashi Mansion", the column name "source bankbook code" of the funds transfer data 106f to the bankbook code "1: AA Bank (receiving / general)" of the funds transfer data calculation data 106e linked with the property code "0001: Kyobashi Mansion", and the column name "destination bankbook code" of the funds transfer data 106f to the bankbook code "3: Special Account" linked with the acquired accounting category. The book code and passbook name "4: AA Bank (custody / special)" are stored, the transfer date "2023 / 5 / 20" set on the funds transfer data creation processing screen MD is stored in the column name "transfer date" of funds transfer data 106f, the amount "45,000" linked to the acquired "8300: Special account transfer" is stored in the column name "amount" of funds transfer data 106f, data is created for funds transfer data 106f, and funds transfer data 106f is updated (see Figure 12).

[0067] (4-7) Next, the funds transfer data creation processing unit 102d calculates the value of 4-1 - (the value of 4-3 + the value of 4-4 + the value of 4-2). Specifically, it subtracts the sum of the value of 4-3 (unpaid balance) "105,000," the value of 4-4 (deposit balance) "30,000," and the value of 4-2 (other account balance) "245,000" from the value of 4-1 (balance at the end of the previous month) "400,000," to calculate "20,000." Since the calculated amount is greater than "0," it proceeds to processing (4-8) (creating funds transfer data to the general account custody account). Note that if the calculated amount is less than or equal to "0," the processing ends.

[0068] (4-8) Next, the funds transfer data creation processing unit 102d refers to the property passbook master 106c and obtains the passbook code and passbook name “2: AA Bank (custody / general)” whose accounting category is “1: general accounting” and whose account category is “custody account.” The funds transfer data creation processing unit 102d stores "0001: Kyobashi Mansion" in the column name "Property Code" of the funds transfer data 106f, the passbook code "1: AA Bank (Deposit / General)" of the funds transfer data calculation data 106e linked by the property code "0001: Kyobashi Mansion" in the column name "Source Passbook Code" of the funds transfer data 106f, and the acquired passbook code and passbook name "2: AA Bank (Storage / General)" in the column name "Destination Passbook Code" of the funds transfer data 106f, stores the transfer date "2023 / 5 / 20" set on the funds transfer data creation processing screen MD in the column name "Transfer Date" of the funds transfer data 106f, and stores the amount "20,000" calculated in (4-7) in the column name "Amount" of the funds transfer data 106f, thereby creating the data of the funds transfer data 106f and updating the funds transfer data 106f (see Figure 13).

[0069] [3: Journal data creation process (Step S5)] The journal data creation processing unit 102e creates journal data based on the funds transfer data 106f created in step S4.

[0070] First, an operator or the like issues an instruction to display the journal data creation processing screen ME.

[0071] The operator or the like sets "2023 / 5" in the processing year and month of the area ME1 and instructs the creation of journalizing data (see FIG. 14).

[0072] Then, the journal data creation processing unit 102e creates the journal data shown in FIG. 14 based on the funds transfer data 106f of FIG.

[0073] [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.

[0074] 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.

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

[0076] 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.

[0077] 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.

[0078] 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.

[0079] Furthermore, with regard to the task support 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.

[0080] For example, all or any part of the processing functions of the business support device 100, particularly the processing functions performed by the control unit, 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 the business support 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). The computer program is executed by being loaded into RAM, and cooperates with the CPU to form the control unit.

[0081] This computer program may be stored in an application program server connected to the business support device 100 via any network, and all or part of it may be downloaded as needed.

[0082] 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.

[0083] Furthermore, a "program" is a data processing method written in any language or description method, regardless of the format, such as 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 the embodiments, as well as the installation procedure after reading, can use well-known configurations and procedures.

[0084] The various databases stored in the memory unit 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.

[0085] The business support device 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device to which any peripheral device is connected. The business support device 100 may be realized by installing software (including programs, data, etc.) that causes the device to perform the processes described in this embodiment.

[0086] 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]

[0087] The present invention is useful in the real estate industry, including the real estate management industry. [Explanation of symbols]

[0088] 100 Business support equipment 102 Control section 102a Property Accounting Classification Master Maintenance Department 102b Account Master Maintenance Department 102c Property Passbook Master Maintenance Department 102d Funds transfer data creation processing unit 102e Journal data creation processing unit 104 Communication interface unit 106 Storage section 106a Property accounting classification master 106b Account Master 106c Property passbook master 106d Monthly Account Balance Data 106e Funds Transfer Data Calculation Data 106f Funds Transfer Data 108 Input / Output Interface Section 112 Input Device 114 Output Device 200 servers 300 Network

Claims

1. a first balance determination unit that refers to first data that stores data including balance information of a specified real estate, subtracts the unpaid balance and the deposit balance from the balance at the end of the previous month, and determines whether the calculated amount obtained by the subtraction is equal to or greater than the separate attribute account balance that is the sum of the reserve amount and the income amount; an amount acquisition unit that, when the first balance determination unit determines that the calculated amount is equal to or greater than the separate attribute account balance, references a fourth master that manages accounting categories that classify accounts and transfer accounts, acquires a reserve fund accounting category related to the reserve fund and a special accounting category related to the income, and further acquires reserve fund accounting transfer identification information linked to the reserve fund accounting category and special accounting transfer identification information linked to the special accounting category, and references second data that manages account items and amounts of specified real estate, and acquires the reserve amount linked to the reserve fund accounting transfer identification information and the income amount linked to the special account transfer identification information; a bank information acquisition unit that refers to a third master that manages bankbook information for a specified real estate property, and acquires bank information for the reserve fund transfer destination linked to the reserve fund accounting category acquired by the amount acquisition unit, and bank information for the revenue transfer destination linked to the special accounting category acquired by the amount acquisition unit; a funds transfer data generation unit that stores the deposit amount, the deposit transfer destination bank information, the earnings amount, and the earnings transfer destination bank information in funds transfer data that manages transferred funds; A business support device comprising:

2. A second balance determination unit is further provided which, by referring to the first data, subtracts a separate attribute balance, which is the sum of the unpaid balance, the deposit balance, the reserve amount, and the revenue amount, from the balance at the end of the previous month, and determines whether the calculated amount obtained by the subtraction is greater than 0; when the second balance determination unit determines that the calculated amount is greater than 0, the bank information acquisition unit refers to the third master and acquires destination bank information for storing management fees, which are attributes of the calculated amount calculated by the second balance determination unit; the funds transfer data generation unit stores the calculated amount calculated by the second balance determination unit and the transfer destination bank information acquired by the bank information acquisition unit in the funds transfer data; 2. The business support device according to claim 1.

3. The second data stores the collected amount of real estate, the outstanding amount of real estate, the deposit amount of real estate, the savings amount of real estate, and the income amount of real estate, The first data stores the collected amount as the balance at the end of the previous month, the accumulated amount and the income amount as the separate attribute account balance, the unpaid amount as the unpaid balance, and the deposited amount as the deposited balance.

2. The business support device according to claim 1.

4. Further comprising a journal data generation unit that generates journal data based on the fund transfer data.

2. The business support device according to claim 1.

5. The real estate is a building that is owned by a single person or in common, or a building that is owned by a condominium.

2. The business support device according to claim 1.

6. a first balance determination step in which the first balance determination unit refers to first data in which data including balance information of a specified real estate is stored, subtracts the unpaid balance and the deposit balance from the balance at the end of the previous month, and determines whether the calculated amount obtained by the subtraction is equal to or greater than the separate attribute account balance which is the sum of the reserve amount and the income amount; an amount acquisition step in which, when the first balance determination unit determines that the calculated amount is equal to or greater than the separate attribute account balance, the amount acquisition unit references a fourth master that manages accounting categories that classify accounts and transfer accounts to acquire a reserve fund accounting category related to the reserve fund and a special accounting category related to the income, and further acquires reserve fund accounting transfer identification information linked to the reserve fund accounting category and special accounting transfer identification information linked to the special accounting category, and references second data that manages account items and amounts of specified real estate to acquire the reserve amount linked to the reserve fund accounting transfer identification information and the income amount linked to the special account transfer identification information; a bank information acquisition step in which the bank information acquisition unit refers to a third master that manages the bankbook information of a specified real estate, and acquires bank information to which the reserve fund is to be transferred, which is linked to the reserve fund accounting category acquired by the amount acquisition unit, and bank information to which the proceeds are to be transferred, which is linked to the special accounting category acquired by the amount acquisition unit; a funds transfer data generation step in which the funds transfer data generation unit stores the deposit amount, the deposit transfer destination bank information, the earnings amount, and the earnings transfer destination bank information in funds transfer data that manages the funds to be transferred; A business support method comprising:

7. An information processing device a first balance determination means for referencing first data storing data including balance information of a specified real estate, subtracting the unpaid balance and the deposit balance from the balance at the end of the previous month, and determining whether the calculated amount obtained by said subtraction is equal to or greater than the separate attribute account balance obtained by adding up the reserve amount and the income amount; an amount acquisition means for, when the first balance determination means determines that the calculated amount is equal to or greater than the separate attribute account balance, acquiring a reserve fund accounting category related to the reserve and a special accounting category related to the income by referring to a fourth master that manages accounting categories and transfer accounts that classify accounts, and further acquiring reserve fund accounting transfer identification information linked to the reserve fund accounting category and special accounting transfer identification information linked to the special accounting category, and acquiring the reserve amount linked to the reserve fund accounting transfer identification information and the income amount linked to the special account transfer identification information by referring to second data that manages account items and amounts of specified real estate; a bank information acquisition means for acquiring, by referring to a third master that manages bankbook information of a specified real estate, bank information to which reserve funds are to be transferred, which is linked to the reserve fund accounting category acquired by the amount acquisition means, and bank information to which revenues are to be transferred, which is linked to the special accounting category acquired by the amount acquisition means; a funds transfer data generation means for storing the deposit amount, the deposit transfer destination bank information, the earnings amount, and the earnings transfer destination bank information in funds transfer data for managing transferred funds; A business support program to function as a

Images