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 task support device, a task support method, and a task support program. [Background technology]

[0002] Patent Document 1 discloses a method and system that utilizes the condominium management association's current bank account to collect funds in the condominium management company's account and transfer them to the payment requester's account. [Prior art documents] [Patent documents]

[0003] [Patent Document 1] JP 2015-125452 A Summary of the Invention [Problem to be solved by the invention]

[0004] In the accounting process for real estate management, there is a situation where the management fee is received and transferred from the account that manages it to an account for managing it as a deposit. In particular, condominium management companies are entrusted by condominium management associations and perform accounting within the management entrustment business. Since condominium management companies must carry out management work based on the Condominium Management Optimization Act, they must transfer the management fees collected from the collection account, excluding the management entrustment fee for the month, to the custody account by the end of the following month, based on "Article 87, Paragraph 2, Item 1, (i) and (ii) of the Enforcement Regulations of the Condominium Management Optimization Act." The deposits into the collection account are the management fees and reserve funds from the condominium unit owners, which are paid by monthly direct debit or daily transfer, and the payments from the account include the payment of entrustment fees to the condominium management company. Since the amount transferred to the custody account varies depending on the monthly collection situation and payment schedule, the transfer work to the custody account is prone to errors and increases the workload of the 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 work burden on business staff. [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 in that it comprises a first balance determination unit that refers to first data storing data including balance information of a specific 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 specific 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 specific 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 transferred funds.

[0007] Furthermore, in the business support device according to the present invention, the first balance determination unit refers to the first data, 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 accounting balance which is the sum of the savings 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 accounting balance, the amount acquisition unit refers to a fourth master which manages accounting categories which classify accounts and transfer accounts, and 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 and and special accounting transfer identification information linked to the special accounting category, and by referring to the second data, acquires the savings amount linked to the reserve fund accounting transfer identification information and the revenue amount linked to the special accounting 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 savings amount, the reserve fund destination bank information, the revenue amount and the revenue destination bank information in the funds transfer data.

[0008] In addition, the business support device of the present invention further includes 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, and the bank information acquisition unit refers to the third master and acquires destination bank information for the calculated amount linked to 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.

[0009] In addition, in the business support device of the present invention, the second balance determination unit refers to the first data and subtracts a separate attribute balance, which is the sum of the unpaid balance, the deposit balance, the savings amount and the 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 or not; 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 are 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 of the present invention, the second data stores the amount collected for real estate, the amount unpaid for real estate, the amount deposited for real estate, the amount saved 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 sum of the save amount and the amount of revenue as the separate attribute accounting balance, the amount unpaid is aggregated as the unpaid balance, and the amount deposited is aggregated as the 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 individually owned or jointly owned, or a building that is condominium owned.

[0013] Furthermore, in the business support method according to the present invention, the method includes a first balance determination step in which a first balance determination unit refers to first data in which data including balance information of a specific real estate is stored, 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 specific real estate, and acquires amounts related to the real estate other than management fees for the real estate; a bank information acquisition step in which the bank information acquisition unit refers to a third master that manages passbook information of the specific real estate, and acquires destination bank information linked to an attribute of the amount acquired by the amount acquisition unit; and a funds transfer data generation step in which the funds transfer data managing the funds to be transferred stores the acquired amount and the acquired destination bank information.

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

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

[0016] [Figure 1] FIG. 1 is a diagram showing an example of the configuration of a task support device according to the present embodiment. [Diagram 2] FIG. 2 is a diagram showing an example of an outline of a data flow according to the present embodiment. [Diagram 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 the present 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 the present embodiment. [Diagram 5] FIG. 5 is a diagram showing an example of a property passbook master maintenance screen and a property passbook master according to the present embodiment. [Figure 6] FIG. 6 is a diagram showing an example of monthly account balance data according to the present 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 PREFERRED EMBODIMENTS

[0017] DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS Hereinafter, preferred embodiments of a task support device, a task support method, and a task support program according to the present invention will be described in detail with reference to the accompanying drawings. Note that 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. 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 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 support 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 support 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 communicatively connects the task 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 task 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). 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 realize 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 for cooperating with an OS (Operating System) to give instructions to a CPU (Central Processing Unit) to perform various processes are recorded in the storage unit 106. For example, memory devices such as RAM (Random Access Memory) and ROM (Read Only Memory), fixed disk devices such as hard disks, flexible disks, and optical disks can be used as the storage unit 106.

[0024] The memory unit 106 stores a property accounting category 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), funds transfer data calculation data 106e (included in the first data of the present invention), and funds transfer data 106f (corresponding to the funds 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 Fig. 4. The account item master 106b is for managing account classifications such as the account code, account name, and unpaid amount set on the account item master maintenance screen MB. As shown in Fig. 4, the account item master 106b stores account identification information (e.g., account code, account name, etc.) and account classifications, etc.

[0027] An example of information stored in the property passbook master 106c is shown in Fig. 5. The property passbook master 106c is used to manage bank accounts by purpose for each property set on the property passbook master maintenance screen MC. As shown in Fig. 5, the property passbook master 106c stores property identification information, passbook identification information (e.g., passbook code, passbook name, etc.), account classification distinguishing whether the account is a receiving account or a custodial account, accounting classification and subject identification information distinguishing whether the account is a general account (management fees, etc.), reserve fund account (repair reserve, etc.), or special account (profits from an apartment, 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 for managing amounts tallied for each item by 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] An example of information stored in the funds transfer data calculation data 106e is shown in Fig. 8. The funds transfer data calculation data 106e is for managing 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, etc.), the total 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, etc.), the total amount of the account classification of unpaid money 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 unpaid money, etc.), the total amount of the account classification 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.), etc.

[0030] An example of information stored in the funds transfer data 106f is shown in Fig. 12. The funds transfer data 106f is for managing the transfer of funds for each property. As shown in Fig. 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, and the like, and executes various information processing 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 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 FIG. 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 item code in area MB2, the item name in area MB3, and the account classification in area MB4, and 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 a property passbook master maintenance screen MC on the monitor 114, and has the operator or the like enter a property code in area MC2, a passbook code in area MC3, a passbook name in area MC4, an account classification in area MC5, an accounting classification in area MC6, and a subject in area MC7, and then presses a 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) Display the funds transfer data creation processing screen MD on the monitor 114 (see FIG. 7). (12) Have the operator or the like enter the processing date in field MD1, enter the fund transfer date in field MD2, and give an instruction to create fund transfer data. (13) Refer to the property passbook master 106c, obtain the item whose account type is "1: Receipt account" and whose accounting type is "1: General accounting", refer to the monthly account balance data 106d, identify the record whose target month includes the obtained account name and the month before the processing month set in the area MD1, obtain and aggregate the amount of the identified record, and store it in the column name "Previous month end balance" 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 FIG. 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) With reference to the property accounting category master 106a, obtain a transfer account linked to an accounting category other than "1: General accounting", with reference 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 Month", obtain and aggregate the amounts of the identified records, store them in the column name "Other Account Balance" of the record including 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) With reference to the account item master 106b, obtain the item associated with the account classification "1: Unpaid". With reference to the monthly account balance data 106d, identify the record in which the obtained account name and the month prior to the processing month set in the area MD1 are included in the target month. Obtain and aggregate the amounts of the identified records. Store the amounts in the "Unpaid Balance" column of the record in the funds transfer data calculation data 106e that includes the property code and passbook code, and update the funds transfer data calculation data 106e (see Figure 10). (16) With reference to the account item master 106b, obtain the item associated with the account classification "2: Deposit", with reference to the monthly account balance data 106d, identify the record in which the obtained account name and the month prior to the processing month set in the area MD1 are included in the target month, obtain and aggregate the amount of the identified record, store it in the column name "Deposit Balance" of the record in the funds transfer data calculation data 106e that includes the property code and passbook code, and update the funds transfer data calculation data 106e (see Figure 11). (17) If the value calculated by subtracting the combined amount of the “Unpaid balance” and the “Deposit balance” from the “Balance at the end of previous month” in the updated funds 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 category master 106a to obtain an accounting category other than "1: General Accounting", obtain an accounting category linked to the accounting category other than "1: General Accounting" and a transfer account linked to the accounting category, refer to the monthly account balance data 106d, identify a record that includes the obtained transfer account in the column name "Subject 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 passbook master 106c to obtain the passbook code and passbook name linked to the obtained accounting category (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 of the fund transfer data 106f is "source bankbook code", and the bankbook code of the fund transfer data calculation data 106e linked with the property code is entered. In the column name "Destination passbook code" of the funds transfer data 106f, enter the passbook code and passbook name corresponding to the acquired accounting classification. The column name "Transfer Date" of the funds transfer data 106f is set to the transfer date set on the funds 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 funds transfer data 106f is created, and the funds transfer data 106f is updated (see FIG. 12). (19) If the value calculated by subtracting the combined amount of the “Unpaid balance”, “Deposit balance” and “Other account balance” from the “Balance at the end of previous month” in the updated funds transfer data calculation data 106e is greater than “0”, proceed to processing in (20); if the calculated value is equal to or less than “0”, determine to end the processing. (20-1) With reference to the property passbook master 106c, the passbook code and passbook name for which the accounting category is "1: general accounting" and the account category is "custody account" are obtained (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 of the fund transfer data 106f is "source bankbook code", and the bankbook code of the fund transfer data calculation data 106e linked with the property code is entered. Enter the acquired passbook code and passbook name in the column name "Destination passbook code" of the funds transfer data 106f. The column name "Transfer Date" of the funds transfer data 106f is set to the transfer date set on the funds 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" in the updated fund transfer data calculation data 106e is entered in the column name "amount" in the fund transfer data 106f. The data is stored, the data of the funds transfer data 106f is created, and the funds 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, and has the operator or the like set the processing date in the area ME1 and instruct the execution of the journal creation processing. Then, the journal data creation processing unit 102e creates journal data based on the funds transfer data 106f (see FIG. 14).

[0038] [2. Processing Overview] The outline will be 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 etc. is carried out from the condominium unit owners, and payment settlement processing is 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, the property accounting category master, account item master, and property passbook master are used to re-aggregate and create fund transfer data. 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 process 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 FIG. 3 to FIG. 14 and so on.

[0042] [1: Master setting (Step S1 to Step 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 etc. 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 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 together with the preset property code, and generates the property accounting category master 106a (step S1, see Fig. 3).The operator or the like performs registration processing for the general account into which management fees and repair reserve fees, etc. are transferred from the condominium owners of Kyobashi Condominium, the reserve fund account which manages the amount of the transferred amount that corresponds to the reserve fund for repair reserves, etc., and the special account which manages the amount related to the condominium's revenue, such as parking lots, and generates the property accounting category master 106a in Fig. 3.

[0047] Next, the operator etc. issues an instruction to display 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 etc. sets the account code "3500" in area MB2, the account name "Unpaid Commission Fees" in area MB3, and the account classification "1" in area MB4, and 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 that manages the account items (step S2, see FIG. 4). The operator or the like repeats the registration process to set the necessary account classifications and generate the account item master 106b, as shown in FIG.

[0051] Next, the operator etc. issues an instruction to display the property passbook master maintenance section 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 (Deposit / 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 then presses the register button MC1 (see Figure 5).

[0054] Then, the property passbook master maintenance unit 102c stores the information set by the operator, etc. in the property passbook master 106c, and generates the account item master 106b (step S3, see FIG. 5). The operator, etc. 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 with the property accounting classification master 106a, the account subject master 106b, and the property passbook master 106c 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 the processing date in area MD1 to "2023 / 5" and the funds transfer date in area MD2 to "2023 / 5 / 20", 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: Regular deposit (collection / general)" which has an account classification of "1: Receipt account" and an accounting classification of "1: General accounting", refers to the monthly account balance data 106d, identifies a record including the acquired item name "1000: Regular 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 "Previous month end balance" of the record of the property code "0001: Kyobashi Mansion" and 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 "Subject name", and further include the previous month "2023 / 4" of the processing month and year "2023 / 5" set in area MD1 in the column name "Target month and year", obtains and aggregates the amounts "200,000" and "45,000" of the identified records, and stores the aggregated result of "245,000" in the column name "Other account 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 9).

[0061] (4-3) Next, the funds transfer data creation processing unit 102d refers to the account item master 106b, obtains the item codes "3500" and "3600" associated with the account classification "1: Accounts Payable", refers to the monthly account balance data 106d, identifies a record whose target month includes the obtained item code "3500" or "3600" and the target month "2023 / 4", the month before the processing 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 and obtains the item code "4500" associated with the account classification "2: Deposit", refers to the monthly account balance data 106d, identifies a record whose target month includes the obtained item code "4500" and the month before the processing month "2023 / 5" set in the area MD1, "2023 / 4", 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". Since this is greater than the value of 4-2 (other account balance) "245,000", it proceeds to process (4-6) (funds transfer data creation process for each custodial account other than the general account). If the calculated value is less than the value of 4-2 (other account balance) "245,000", it 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 accounting category "2: Reserve fund accounting" and accounting category "3: Special accounting" other than accounting category "1: General accounting", and acquires transfer account "8100: Reserve fund accounting transfer" linked to accounting category "2: Reserve fund accounting" and transfer account "8300: Special accounting transfer" linked to 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 date "2023 / 5" set in area MD1, "2023 / 4", in the column name "Target 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", 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: Deposit fund 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", 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 ledger 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 the process of (4-8) (creating funds transfer data to the general account custody account). If the amount is less than or equal to "0", the process 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 (collection, 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 (custody, 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, creates the data of the funds transfer data 106f, and updates the funds transfer data 106f (see Figure 13).

[0069] [3: Journal entry 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 the processing year and month in the field ME1 to "2023 / 5" and issues an instruction to create journal entry 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 in 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 goals 8 and 9 of the SDGs.

[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, making it possible to contribute to Goal 16 of the SDGs.

[0076] 5. Other embodiments The present invention may be embodied 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] In addition, 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 may be changed as desired unless otherwise specified.

[0079] Moreover, with regard to the task support device 100, each of the components shown in the figures is a functional concept, and does not necessarily have to be physically configured as shown in the figures.

[0080] For example, the processing functions of the business support device 100, particularly the processing functions performed by the control unit, may be realized in whole or in part by a CPU and a program interpreted and executed by the CPU, or may be realized as hardware using wired logic. The program is recorded in a non-transient computer-readable recording medium including programmed instructions for causing the information processing device to execute the processes described in the present embodiment, and is mechanically read by the business support device 100 as necessary. That is, a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive). This computer program is executed by being loaded into a RAM, and cooperates with the CPU to form a control unit.

[0081] In addition, this computer program may be stored in an application program server connected to the task support device 100 via any network, and it is also possible to download all or a part of it as necessary.

[0082] In addition, the program for executing the process described in this embodiment may be stored in a non-transient computer-readable recording medium, or may be configured as a program product. Here, the "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] Moreover, a "program" is a data processing method written in any language or description method, and may be in any form, such as source code or binary code. Note that a "program" is not necessarily limited to a single configuration, but also includes a distributed configuration as multiple modules or libraries, and a program that works with a separate program, such as an OS, to achieve its function. 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, may use well-known configurations and procedures.

[0084] The various databases etc. 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 etc. 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 a 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 or data) that causes the device to realize the processing 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 functionally or physically distributed and integrated in any unit according to various additions or functional loads. In other words, the above-mentioned embodiments can be implemented in any combination, or the embodiments can be implemented selectively. [Industrial Applicability]

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

[0088] 100 Business support equipment 102 Control section 102a Property Accounting Division 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 section 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 Devices 114 Output Device 200 Servers 300 Network

Claims

1. a first balance determination unit that refers to first data in which data including balance information of a specific real estate is stored, 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 acquires an amount related to the real estate other than the management fee for the real estate by referring to second data that manages the account items and amounts of a specified real estate when the first balance determination unit determines that the calculated amount is equal to or greater than the other balance; a bank information acquisition unit that acquires destination bank information associated with the attribute of the amount acquired by the amount acquisition unit by referring to a third master that manages bankbook information of a specific real estate; a funds transfer data generating unit for storing the acquired amount and the acquired transfer destination bank information in funds transfer data for managing transferred funds; A business support device comprising:

2. the first balance determination unit, referring to the first data, 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 amount obtained by the subtraction is equal to or greater than the separate attribute account balance obtained by combining the savings amount and the earnings amount; When the first balance determination unit determines that the calculated amount is equal to or greater than the separate attribute accounting balance, the amount acquisition unit refers to 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 account transfer identification information linked to the special accounting category, and refers to the second data 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; the bank information acquisition unit refers to the third master to acquire reserve fund transfer bank information linked to the reserve fund accounting category acquired by the amount acquisition unit and profit transfer bank information linked to the reserve fund accounting category acquired by the amount acquisition unit; 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 the funds transfer data; 2. The business support device according to claim 1.

3. a second balance determination unit that refers to the first data, subtracts a balance other than the balance at the end of the previous month from the balance at the end of the previous month, and determines whether or not the calculated amount obtained by the subtraction is greater than 0; the bank information acquisition unit refers to the third master to acquire destination bank information of the calculated amount, the destination bank information being associated with an attribute 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 destination bank information acquired by the bank information acquisition unit in the funds transfer data.

3. The business support device according to claim 1 or 2.

4. the second balance determination unit, referring to the first data, subtracts a separate attribute balance, which is the sum of the unpaid balance, the deposit balance, the savings amount, and the income amount as the other balance, from the previous month end balance, and determines whether the 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 a management fee, which is an attribute 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 destination bank information acquired by the bank information acquisition unit in the funds transfer data.

4. The business support device according to claim 3.

5. The second data stores the collected amount of the real estate, the outstanding amount of the real estate, the deposit amount of the real estate, the savings amount of the real estate, and the income amount of the real estate, The first data is stored by storing 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.

6. A journal data generation unit that generates journal data based on the fund transfer data, 2. The business support device according to claim 1.

7. The real estate is a building subject to sole ownership or joint ownership, or a building subject to condominium ownership.

2. The business support device according to claim 1.

8. a first balance determination step in which the first balance determination unit refers to first data in which data including balance information of a predetermined real estate is stored, 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, when the first balance determination unit determines that the calculated amount is equal to or greater than the other balance, refers to second data that manages the account items and amounts of a specified real estate, and acquires an amount related to the real estate other than the management fee for the real estate; a bank information acquisition step of acquiring destination bank information linked to the attribute of the amount acquired by the amount acquisition step, by referring to a third master that manages bankbook information of a specific real estate; a funds transfer data generating step of storing the acquired amount and the acquired transfer destination bank information in funds transfer data managing funds to be transferred, A business support method comprising:

9. An information processing device, a first balance determination means for referencing first data in which data including balance information of a specified real estate is stored, subtracting other balances other than the balance at the end of the previous month from the balance at the end of the previous month, and determining whether the calculated amount obtained by the subtraction is equal to or greater than the other balance; an amount acquisition means for acquiring an amount related to the real estate other than the management fee for the real estate by referring to second data managing account items and amounts of a specified real estate when the first balance determination means determines that the calculated amount is equal to or greater than the other balance; a bank information acquiring means for acquiring destination bank information linked to the attribute of the amount acquired by the amount acquiring means, by referring to a third master that manages bankbook information of a specific real estate; a funds transfer data generating means for storing the acquired amount and the acquired transfer destination bank information in funds transfer data for managing transferred funds; A business support program to function as a

Images