JP2022155226A - Accounting processing apparatus, accounting processing method and accounting processing program - Google Patents

Abstract

To reduce a workload and a transfer error of a person in charge in a case where dividends are allocated to a plurality of beneficiaries of real estate trust.SOLUTION: An accounting processing apparatus according to the present embodiment comprises: journal input means that inputs journal detail information which includes a slip number, trust contract identification information, an occurrence date, a debit side, a credit side, and a money amount; dividend automated journal creation means that acquires trust contract identification information at a designated closing date referring to trust contract information, acquires a beneficiary and its beneficial interest rate from beneficiary information using the acquired trust contract identification information as a key, and automatically creates journal detail information proportionally divided according to the beneficial interest rate of the acquired beneficiary for undivided money of the journal detail information for the acquired trust contract identification information; and transfer data creation means that creates transfer data on the basis of the proportionally divided journal detail information.SELECTED DRAWING: Figure 3

Description

The present invention relates to an accounting processing device, an accounting processing method, and an accounting processing program.

For example, property management by real estate trust is widely practiced. Such a real estate trust entrusts its own (settlor) important property to a reliable trustee (for example, a trust bank). It is a mechanism to pass to the beneficiary specified by the person. As a system related to the real estate trust business, for example, there is Patent Document 1.

Japanese Patent Application Laid-Open No. 2003-345979

However, in the above Patent Document 1, a dividend journal is automatically created according to the beneficiary right ratio of multiple beneficiaries of the real estate trust, and the transfer data is automatically created, thereby distributing the dividend to multiple beneficiaries of the real estate trust. However, there is no mention of reducing the workload of the person in charge and making mistakes in payment.

The present invention has been made in view of the above. and to provide an accounting program.

In order to solve the above-described problems and achieve the object, the present invention is an accounting processing device comprising a control unit for distributing dividends to multiple beneficiaries of a real estate trust, wherein the control unit comprises a trust contract Identification information, settlement date designation information for designating settlement date, trust contract information including transfer date, and beneficiary information including trust contract identification information, beneficiary, beneficiary right ratio, and account information are configured to be accessible. journal input means for entering journal entry detail information including slip number, trust contract identification information, date of occurrence, debit, credit, and amount; Acquiring identification information, using the acquired trust contract identification information as a key, acquiring the beneficiary and its beneficiary right ratio from the said beneficiary information, Dividend automatic journal creation means for automatically creating journal details information proportionally divided according to the acquired beneficiary right ratio; and transfer data creation means for creating transfer data based on the proportionally divided journal details information. characterized by

Further, according to one aspect of the present invention, the control unit may further include transfer means for transferring funds via Internet banking based on the transfer data.

Further, according to one aspect of the present invention, the settlement date designation information may include an initial settlement date, a final settlement date, and the number of months in a settlement cycle.

Further, according to one aspect of the present invention, the journal detailed information includes a flag indicating whether or not the transfer is to be made, and the transfer data creating means, based on the journal detailed information for which the flag is to be transferred, You may decide to create transfer data.

Further, in order to solve the above-mentioned problems and achieve the object, the present invention provides an accounting processing method for distributing dividends to multiple beneficiaries of a real estate trust, which is executed by an information processing device having a control unit. The control unit controls trust contract identification information, settlement date designation information for designating the settlement date, trust contract information including the transfer date, trust contract identification information, beneficiary, beneficiary right ratio, and beneficiary including account information. a journal entry step of entering journal detail information including a slip number, trust contract identification information, date of occurrence, debit, credit, and amount, executed in the control unit; By referring to the trust contract information, acquiring the trust contract identification information for the designated closing date, using the acquired trust contract identification information as a key, acquiring the beneficiary and its beneficiary right ratio from the beneficiary information, and acquiring a dividend automatic journal entry creation step for automatically creating journal entry detail information proportionally divided according to the beneficiary's beneficiary right ratio acquired, with respect to undivided money in the journal entry details information for the trust contract identification information obtained; and a transfer data creating step of creating transfer data based on.

Further, in order to solve the above-described problems and achieve the object, the present invention provides an accounting processing program for distributing dividends to multiple beneficiaries of a real estate trust, which is executed by an information processing device having a control unit. The control unit controls trust contract identification information, settlement date designation information for designating the settlement date, trust contract information including the transfer date, trust contract identification information, beneficiary, beneficiary right ratio, and beneficiary including account information. a journal entry step of entering journal detail information including a slip number, trust contract identification information, date of occurrence, debit, credit, and amount in the control unit; Refers to the information to acquire the trust contract identification information for the specified settlement date, acquires the beneficiary and its beneficiary right ratio from the beneficiary information using the acquired trust contract identification information as a key, and acquires the acquired trust contract Dividend automatic journal entry creation process for automatically creating journal entry detail information proportionally divided according to the beneficiary's beneficiary right ratio obtained for undivided money in the journal entry detail information for the identification information, and based on the proportionally divided journal entry detail information , a transfer data creation step of creating transfer data, and an accounting processing program for executing .

Advantageous Effects of Invention According to the present invention, it is possible to reduce the workload of the person in charge and transfer mistakes when distributing a dividend to multiple beneficiaries of a real estate trust.

FIG. 1 is a diagram for explaining the background of the present invention. FIG. 2 is a diagram for explaining the background of the present invention. FIG. 3 is a block diagram showing an example of the configuration of the accounting processing device according to this embodiment. FIG. 4 is a diagram showing a flow for explaining an overview of the overall processing of the control unit of the accounting processing apparatus according to this embodiment. FIG. 5 is a diagram showing sample data for explaining a specific example of processing of the control unit of the accounting processing apparatus according to the present embodiment. FIG. 6 is a diagram showing an example of a screen image for explaining a specific example of processing of the control unit of the accounting processing apparatus according to the present embodiment.

BEST MODE FOR CARRYING OUT THE INVENTION An embodiment of an accounting processing device, an accounting processing method, and an accounting processing program according to the present invention will be described below in detail based on the drawings. In addition, this invention is not limited by this embodiment.

[1. Overview]
For example, property management by real estate trust is widely practiced. The background of the present invention will be described with reference to FIGS. A real estate trust entrusts the important property of the settlor (owner) to a reliable trustee (for example, XX trust company). Alternatively, it is a mechanism to pass it to a beneficiary designated by the consignor.

In FIGS. 1 and 2, in the real estate trust business, there is a settlement operation in which the trustee transfers the trust dividend to the beneficiary account (T1). In the case of a large-scale trust contract, it becomes complicated because dividends are distributed to multiple beneficiaries according to the ratio of beneficiary rights (T2). Settlement of accounts for trust agreements comes in a cycle of several months, and with the increase in contracts, settlements become monthly, numerous, and complicated (T3).

In the past, settlement work was done using an accounting system (T4). The settlement unit was the entire trust contract, and the dividend journal entry was also one item, not the beneficiary unit. As a result, the distribution of dividends to beneficiaries had to be calculated individually, and the transfer work was done manually via Internet banking. Automation and systemization are required due to the aging of society and the booming real estate industry.

In this way, conventionally, settlement operations were performed using an accounting system, dividend operations were calculated individually, and transfers were performed manually through Internet banking, which placed a heavy workload on the person in charge. In addition, there is a problem that the proportional division calculation according to the dividend ratio is a heavy load, and there is a large risk of customer impact due to a mistake in the transfer operation.

Therefore, in this embodiment, the accounting system has the dividend journal details for the entire settlement, and the information system has the dividend ratio information for each beneficiary. Equipped with a function that can be automatically transferred to the details. In addition, it has a function that automatically creates the JBA transfer format from the dividend journal details and links the information system and accounting system (payment system). That is, in FIGS. 1 and 2, T1 is automatically journalized according to the number of people in T2, and repetition of the number of contracts in T3 is automated by collective execution.

According to the present embodiment, the dividend journal entry is automatically generated according to the beneficiary right ratio, the JBA transfer data is created to the designated account, and the payment operation is automated based on the journal entry details of the accounting system. By centrally managing and automating with , it is possible to reduce the workload and reduce the customer risk due to transfer mistakes. As a result, it is possible to obtain an effect as a business base for the business expansion plan.

[2. Constitution]
The configuration of the accounting processing device 100 according to this embodiment will be described with reference to FIG. FIG. 3 is a block diagram showing an example of the configuration of the accounting processing device 100 according to this embodiment.

Accounting processing device 100 is a commercially available desktop personal computer. Note that the accounting processing device 100 is not limited to a stationary information processing device such as a desktop personal computer, and may be a portable type such as a commercially available notebook personal computer, PDA (Personal Digital Assistant), smart phone, or tablet personal computer. It may be an information processing device.

The accounting processing device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input/output interface unit 108, as shown in FIG. Each unit included in accounting processing apparatus 100 is communicably connected via an arbitrary communication path.

The communication interface unit 104 communicably connects the accounting processing 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 another device via a communication line. Here, the network 300 has a function of communicably connecting the accounting processing apparatus 100, the server 200, the bank website 400, and the like, and is, for example, the Internet or a LAN (Local Area Network). Note that data stored in the storage unit 106 to be described later may be stored in the server 200 .

An input device 112 and an output device 114 are connected to the input/output interface section 108 . The output device 114 can be a monitor (including a home television), a speaker, or a printer. The input device 112 can be a keyboard, a mouse, a microphone, or a monitor that cooperates with the mouse to provide a pointing device function. Note that, hereinafter, 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 . Also, “output” includes displaying on the monitor of the output device 114 and printing with the printer of the output device 114 . Further, a user's operation or the like on information displayed on the monitor 114 using the input device 112 or the like may be described as "user operation via the UI".

The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 stores a computer program for performing various processes by giving commands to a CPU (Central Processing Unit) in cooperation with an OS (Operating System). As 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. The storage unit 106 also has a data file 106a.

The data file 106a is a file for storing various data such as trust agreement information, beneficiary information, journal entry details information, and transfer data.

The trust contract information includes trust contract identification information (for example, trust contract number and/or trust contract name), settlement date specification information for specifying the settlement date (eg, initial settlement date, final settlement date, number of months in the settlement cycle). , and the transfer date (see FIG. 5). Beneficiary information may include trust agreement number, beneficiary number, beneficiary name, beneficiary interest ratio, and account information (see FIG. 5). The journal entry detail information may include slip number, trust contract number, date of occurrence, debit, credit, amount, business partner, optional flg (for example, transfer target: "1", transfer non-target: "0"). (See Figure 5). The transfer data may include transfer date, transfer requester, transfer account name, transfer account information, and amount (see FIG. 5).

The control unit 102 is a CPU or the like that controls the accounting processing apparatus 100 in an integrated manner. The control unit 102 has an internal memory for storing a control program such as an OS, a program defining various processing procedures, required data, and the like, and performs various information processing based on these stored programs. Run.

The control unit 102 is configured to be able to access a data file 106 a stored in the storage unit 106 . Note that the data file 106a may be provided in another location (for example, the server 200) as long as the control unit 102 can access it. The control unit 102 functionally conceptually includes a trust contract registration unit 102a, a beneficiary registration unit 102b, a journal input unit 102c, a dividend automatic journal creation unit 102d, a transfer data creation unit 102e, a transfer unit 102f, and a screen display control unit 102g.

The trust contract registration unit 102a registers, for example, a trust contract number, a trust contract name, an initial closing date, a final closing date, Enter the trust contract information including the number of months in the settlement cycle and the transfer date, and register it in the data file 106a.

The beneficiary registration unit 102b, for example, according to the operator's operation on the beneficiary registration screen (see FIG. 6) displayed on the monitor 114, the trust contract number, beneficiary number, beneficiary name, beneficiary right Beneficiary information including account information is entered and registered in the data file 106a.

The journal entry unit 102c includes, for example, slip number, trust contract identification information, date of occurrence, debit, credit, and amount in response to the operator's operation on the journal entry screen (see FIG. 6) displayed on the monitor 114. Enter the journal details information and register it in the data file 106a.

The dividend automatic journal creation unit 102d acquires the trust contract identification information for the designated closing date by referring to the settlement date designation information in the trust contract information, and uses the acquired trust contract identification information as a key to obtain the beneficiary information. acquire the beneficiary and its beneficiary right ratio, and automatically create journal details information proportionally divided according to the acquired beneficiary’s beneficiary right ratio for undivided money in the journal details information about the acquired trust contract identification information, and data Register in file 106a.

The settlement date designation information may include the first settlement date, the final settlement date, and the number of months in the settlement cycle. A method of calculating each settlement date from the settlement date designation information will be described with reference to the trust contract information in FIG. For the first settlement date, the number of months in the settlement cycle is multiplied by a numerical value from 0 to an arbitrary value, and the loop ends when the final settlement date is passed. In the case of trust contract information "STNK-1" in FIG. = 21/1/31 + (3*1), 21/7/31 = 21/1/31 + (3*2), ..., 31/10 for the 44th settlement date /31=21/1/31+(3*43), and the loop ends when the final settlement date 31/10/31 is passed. In the case of "Dummy-2" of the trust contract information in FIG. = 21/3/31 + (3*1), the 3rd settlement date is 21/9/30 = 21/3/31 + (3*2), ..., the 44th settlement date is 31/12/31 =21/3/31+(3*43), and the loop ends when the final settlement date of 31/12/31 is passed.

The transfer data creation unit 102e creates transfer data based on the proportionally divided journal details information, and registers the data in the data file 106a. The journal detail information includes a flag (for example, arbitrary flg) indicating whether or not the transfer is to be made, and the transfer data creating unit 102e creates the transfer data based on the journal detail information whose flag indicates that the transfer is to be made. good too.

The transfer unit 102f automatically transfers the money to the bank website 400, which is internet banking, based on the transfer data.

The screen display control unit 102g controls the display and input of various screens displayed on the monitor 114 (for example, a trust contract registration screen, a beneficiary registration screen, a journal input screen, a dividend automatic journal creation screen, a transfer data creation screen, etc.). do.

[3. Concrete example]
A specific example of processing in the control unit 102 of the accounting processing apparatus 100 according to the present embodiment will be described with reference to FIGS. 3 to 6. FIG. FIG. 4 is a diagram showing a flow for explaining an outline of the overall processing flow of the control unit 102 of the accounting processing apparatus 100 according to this embodiment. FIG. 5 is a diagram showing sample data for explaining a specific example of processing of the control unit 102 of the accounting processing apparatus 100 according to the present embodiment. FIG. 6 is a diagram showing an example of a screen image for explaining a specific example of processing of the control unit 102 of the accounting processing apparatus 100 according to this embodiment.

(3-1. Overall processing)
With reference to FIG. 4, an outline of the overall processing flow of the control unit 102 of the accounting processing apparatus 100 according to the present embodiment will be described.

In FIG. 4, the trust contract registration unit 102a executes trust contract registration processing (step S1). Specifically, in the trust contract registration process, for example, the trust contract registration unit 102a registers the trust contract number, the trust contract name, the initial account Enter the trust contract information including the date, the final settlement date, the number of months in the settlement cycle, and the transfer date, and register it in the data file 106a. Thus, in the trust contract registration process, the entire trust contract is registered. Also, as if registering a virtual company, the settlement cycle is defined in units of months.

The beneficiary registration unit 102b executes beneficiary registration processing (step S2). Specifically, in the beneficiary registration process, the beneficiary registration unit 102b, for example, according to the operator's operation on the beneficiary registration screen displayed on the monitor 114, the trust contract number, beneficiary number, Enter beneficiary information including name, percentage of beneficiary interest, and account information and register in data file 106a. In this way, in the beneficiary registration process, a person who receives the investment income of the trust contract is registered. In addition, the ratio of the beneficiary right to the total is defined, and the transfer account information is also defined.

The journal entry unit 102c executes journal entry processing (step S3). Specifically, in the journal entry process, the journal entry unit 102c, for example, according to the operator's operation on the journal entry screen displayed on the monitor 114, slip number, trust agreement identification number, date of occurrence, debit, Enter the journal details information including credit, amount, client, optional flg and register it in the data file 106a.

In the journal entry process, you enter the rental income and expense accounts. It becomes the same work as the so-called general account. Below is an example of a journal entry.
Debit) Ordinary deposit / Credit) Rent income 300,000 yen January 10 Debit) Management expenses / Credit) Ordinary deposit 200,000 yen January 20 We will proceed with the settlement work until the dividend account is determined.

Subtract the total cost from the total revenue to determine the current profit and determine the dividend amount.
Debit) Net profit / Credit) Trust profit 100,000 yen January 31 (settlement date)

The following is an example journal entry for dividends for the entire trust contract. For example, 100,000 yen.
Debit) Trust income / Credit) Accrued dividends 100,000 yen January 31 (settlement date)

The dividend automatic journal entry creation unit 102d executes dividend automatic journal entry processing (step S4).
Specifically, in the dividend automatic journal creation process, the dividend automatic journal creation unit 102d refers to the account closing date designation information in the trust contract information, and the dividend automatic journal creation screen displayed on the monitor 114 is operated by the operator. Acquisition of trust contract identification information for the specified closing date, acquisition of beneficiary and beneficiary interest ratio from beneficiary information using the acquired trust contract identification information as a key, and journal entry detail information about the acquired trust contract identification information With respect to the undivided money, the journal details information proportionally divided according to the acquired beneficiary right ratio is automatically created and registered in the data file 106a.

In the dividend automatic journal creation process, if the account balance of unpaid dividends is not 0 yen after settlement of accounts, the book-entry transfer journal is continued by reconciling the balance. For example, if beneficiary A has a contract of 70% and beneficiary B has a contract of 30%, the dividend journal entry is as follows.

Debit) Unpaid dividends / Credit) Ordinary deposit 70,000 yen February 5 (several days after settlement) payee A
Debit) Unpaid dividends / Credit) Ordinary deposit 30,000 yen February 5 (several days after settlement) Payee B

In the past, only one item was added up without being divided into two items, so the following journal entry was created and there was no payee information.
Debit) Unpaid dividends / Credit) Ordinary deposit 100,000 yen February 5 (several days after settlement)

The transfer data creation unit 102e executes a transfer data creation process (step S5). Specifically, in the transfer data creation process, for example, the transfer data creation unit 102e makes sure that the transfer date specified by the operator's operation on the transfer data creation screen displayed on the monitor 114 matches the occurrence date, and Optional For the journal entry detail information with flg=1, transfer data for each beneficiary is created and registered in the data file 106a.

In the transfer data creation process, for example, transfer data in the Zenginkyo format is automatically created for each beneficiary.
Transfer date February 5, transfer destination A account, transfer amount 70,000 yen Transfer date February 5, transfer destination B account, transfer amount 30,000 yen

The transfer unit 102f executes automatic transfer processing (step S6). Specifically, in the automatic transfer process, the transfer unit 102f automatically transfers the money to Internet banking based on the transfer data. For example, a CSV file of automatically created transfer data is uploaded to Internet banking to complete the automatic transfer. This eliminates the need for manual input for each transfer statement.

(3-2. Sample data)
A specific example of processing of the control unit 102 of the accounting processing apparatus 100 according to the present embodiment will be described with reference to the sample data shown in FIG.

(Trust contract registration process S1)
The trust contract registration unit 102a, for example, according to the operator's operation on the trust contract registration screen displayed on the monitor 114, the trust contract number, the trust contract name, the first settlement date, the final settlement date, Enter the trust contract information including the transfer date and register it in the data file 106a.

In the example of trust contract information shown in FIG. /10/31", the number of months in the settlement cycle "3 months", the transfer date "next 5th", the second line is the trust contract number "Dummy-2", the trust contract name "dummy residence", the first settlement date "2021 /3/31", the final settlement date "2031/12/31", the number of months in the settlement cycle "3 months", and the transfer date "next 5th" are registered.

In this example, the accounts for the trust contract number "SNTK-1" are January, April, July and October every year. The settlement of accounts for the trust contract number "Dummy-2", which is a dummy for comparison, is March, June, September, and December every year.

(Beneficiary registration process S2)
The beneficiary registration unit 102b receives, for example, a trust contract number, a beneficiary number, a beneficiary name, a beneficiary right ratio, and a beneficiary account information in response to an operator's operation on a beneficiary registration screen displayed on the monitor 114. Enter the user information and register it in the data file 106a.

In the example of the beneficiary registration information shown in FIG. 5, the first line includes the trust contract number "SNTK-1", the beneficiary number "JUEK-1", the beneficiary name "Taro Yamada", and the beneficiary right ratio "70%". , account information "Bank 0001, branch 001, ordinary deposit, No. 1234567", the second line is the trust contract number "SNTK-1", the beneficiary number "JUEK-2", the beneficiary name "Hanako Yamada", and the beneficiary right ratio "30%" and account information "bank 0001, branch 002, ordinary deposit, No. 2234567" are registered.

(Purchase input processing S3)
The journal entry unit 102c, for example, according to the operator's operation on the journal entry screen displayed on the monitor 114, the slip number, trust agreement number, date of occurrence, debit, credit, amount, transaction First, input the journal details information including optional flg (“0” for not subject to transfer, “1” for subject to transfer) and register it in the data file 106a. Arbitrary flg is set to "0" for exemption from transfer.

In the example of the journal details information shown in FIG. Income", Amount "300,000", Customer "Blank", Optional flg "0", The second line is slip number "DENP2", trust agreement number "SNTK-1", date of occurrence "2021/1/20" , debit "administration cost", credit "ordinary deposit", amount "200,000", customer "blank", optional flg "0". This is where you enter journal entries for rent income and miscellaneous expenses accounts. It becomes the same work as the so-called general account.

The third line contains slip number "DENP3", trust contract number "SNTK-1", date of occurrence "2021/1/31", debit "current profit", credit "trust profit", amount "100,000", Supplier "Blank" and optional flg "0" are entered. Subtract the total expenses from the total revenues to get the current profit.

The fourth line is slip number "DENP4", trust contract number "SNTK-1", date of occurrence "2021/1/31", debit "trust income", credit "unpaid dividends", amount "100,000" ”, supplier “blank”, optional flg “0” are entered. As dividends for the entire trust contract, the profit for the current period shall be the debit "trust profit" and the credit "accrued dividends."

(Dividend Automatic Journal Creation Processing S4)
The dividend automatic journal creation unit 102d acquires the trust contract number and the transfer date of the trust contract information whose closing date is the specified date designated by the operator's operation on the dividend automatic journal creation screen displayed on the monitor 114. Acquire beneficiary information using the trust agreement number as a key. Using the acquired trust contract number as a key, if the balance of unpaid dividends in the journal details information satisfies the information of "0 yen", the beneficiary information is proportionally distributed according to the beneficiary right ratio of the trustee, and the date of occurrence is acquired. Automatically create journal details information with transfer date. In this case, the arbitrary flg is set to "1".

For example, if the specified settlement date is "1/31", the trust contract number "SNTK-1" of the trust contract information whose settlement date is "1/31" and the transfer date "next 5th" are acquired, and The beneficiary information is acquired using the trust contract number "SNTK-1" as a key. Using the acquired trust contract number “SNTK-1” as a key, the balance of unpaid dividends “100,0000 yen” in the journal details information is transferred to the acquired beneficiary information trustees “JUEK-1” and “JUEK-1”. ” is divided proportionally by the beneficiary right ratio “70%” and “30%”, and the journal details information is automatically created with the date of occurrence set to the acquired transfer date “2/5”.

In the example of automatically created journal details information shown in FIG. Money", credit "ordinary deposit", amount "70,000", customer "JUEK-1", optional flg "1", second line: slip number "DENP6", trust contract number "SNTK-1", Occurrence date "2021/2/5", debit "unpaid dividend", credit "ordinary deposit", amount "30,000", client "JUEK-2", optional flg "1" are automatically created.

(Transfer data creation process S5)
The transfer data creation unit 102e extracts the journal details information whose transfer date specified by the operator's operation on the transfer data creation screen displayed on the monitor 114 matches the date of occurrence and whose optional flag is "1". , create transfer data and register it in the data file 106a. "Transfer requester" of transfer data is "our company", "transferee" is "beneficiary name of beneficiary information", "transfer date" and "transfer amount" are "occurrence date" and "amount ”.

In the example of the transfer data shown in FIG. 0001・Branch 001・Ordinary・No1234567”, Amount of money “70,000”, Transfer date “2021/2/5”, Transfer requester “Trustee Co., Ltd.”, Transfer account name “Hanako Yamada”, Transfer account information "Bank 0001/Branch 002/Ordinary/No. 2234567" and amount of money "30,000".

(Transfer processing S6)
The transfer unit 102f automatically transfers money to Internet banking based on the transfer data. For example, a CSV file of automatically created transfer data is uploaded to Internet banking to complete the automatic transfer.

(3-3. Screen image)
An example of a screen image will be described with reference to FIG. The data in the screen image of FIG. 6 correspond to the sample data of FIG.

(Trust contract registration process S1)
FIG. 6A shows a display example of the trust contract registration screen. The trust contract registration screen is a screen for registering trust contract information. The trust contract registration screen has input fields for a trust contract number, a trust contract name, an initial closing date, a final closing date, the number of months in a closing cycle, a transfer date, etc., and a registration button. When data is entered in the input fields and the registration button is pressed, the trust contract information is registered in the data file 106a.

(Beneficiary registration process S2)
FIG. 6B shows a display example of the beneficiary registration screen. The beneficiary registration screen has input fields for trust contract number, beneficiary number, beneficiary name, beneficiary right ratio, account information (bank, branch, type, account number), etc., and a registration button. When data is entered in the input fields and the registration button is pressed, the beneficiary information is registered in the data file 106a.

(Purchase input processing S3)
FIG. 6(C) shows a display example of the journal entry screen. The journal entry screen has entry fields for slip number, trust agreement number, date of occurrence, debit, credit, amount, customer, arbitrary flg, etc., and a registration button. When data is entered in the input fields and the registration button is pressed, the journal details information is registered in the data file 106a.

(Dividend Automatic Journal Creation Processing S4)
FIG. 6D shows a display example of the payout automatic journal creation screen. The dividend automatic journal creation screen has an input field for the trust closing date (specified date) and an execution button. When the trust settlement date (specified date) is entered and the execution button is pressed, dividend journal details information is automatically created and registered in the data file 106a for the trust contract whose settlement date matches the specified date. The automatically created journal detail information can be confirmed on the journal entry screen (see FIG. 6(E)).

(Transfer data creation process S5)
FIG. 6F shows a display example of the transfer data creation screen. The transfer data creation screen has a transfer date entry field and an execution button. When the transfer date is entered and the execution button is pressed, the specified transfer date matches the occurrence date, and the transfer data of the journal detail information with the optional flag "1" is automatically created and registered in the data file 106a. be done. After that, the automatically created CSV file of transfer data is uploaded to Internet banking, and automatic transfer is performed.

As described above, according to the present embodiment, the trust contract registration unit 102a for registering the trust contract identification information, the account settlement date specification information for specifying the account settlement date, and the trust contract information including the transfer date; A beneficiary registration unit 102b for registering beneficiary information including identification information, beneficiary, beneficiary right ratio, and account information, and entering journal entry detail information including slip number, trust contract identification information, date of occurrence, debit, credit, and amount. and the trust contract identification information for the specified closing date by referring to the journal entry means and the trust contract information, and using the acquired trust contract identification information as a key, the beneficiary and its beneficiary rights from the beneficiary information a dividend automatic journal creation unit 102d that acquires the ratio and automatically creates journal details information proportionally divided according to the acquired beneficial interest ratio of the beneficiary with respect to the undivided dividend of the journal details information for the acquired trust contract identification information; , and a transfer data creation unit 102e that creates transfer data based on the proportionally divided journal details information, so that the dividend journal is automatically created according to the beneficiary right ratio of multiple beneficiaries of the real estate trust, The transfer data can be automatically created, and when dividends are distributed to multiple beneficiaries of a real estate trust, it is possible to reduce the workload of the person in charge and transfer mistakes.

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

In addition, the present embodiment can contribute to the reduction of disposal loss and the promotion of paperless and computerization.

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

[5. Other embodiments]
The present invention may be implemented in various different embodiments other than the embodiments described above within the scope of the technical idea described in the claims.

For example, among the processes described in the embodiments, all or part of the processes described as being automatically performed can be manually performed, or all of the processes described as being manually performed Alternatively, some can be done automatically by known methods.

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

Also, with respect to the accounting processing device 100, each illustrated component is functionally conceptual, and does not necessarily need to be physically configured as illustrated.

For example, the processing functions of the accounting processing apparatus 100, particularly the processing functions performed by the control unit 102, are implemented in whole or in part by a CPU and a program interpreted and executed by the CPU. Alternatively, it may be implemented as hardware using wired logic. In addition, the program is recorded on a non-temporary computer-readable recording medium containing programmed instructions for causing the information processing apparatus to execute the processing described in this embodiment, and if necessary, the accounting processing apparatus 100 mechanically read. That is, a storage unit such as a ROM or HDD (Hard Disk Drive) stores a computer program for giving commands to the CPU in cooperation with the OS to perform various processes. This computer program is executed by being loaded into the RAM and constitutes a control section in cooperation with the CPU.

In addition, this computer program may be stored in an application program server connected to the accounting processing apparatus 100 via any network, and it is possible to download all or part of it as necessary. be.

Also, the program for executing the processing described in this embodiment may be stored in a non-temporary computer-readable recording medium, or may be configured as a program product. Here, the term "recording medium" refers to memory cards, USB (Universal Serial Bus) memories, SD (Secure Digital) cards, flexible disks, magneto-optical disks, ROMs, EPROMs (Erasable Programmable Read Only Memory), EEPROMs (registered (trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magneto-Optical disk), DVD (Digital Versatile Disk), and Disc (registered trademark) such as Blu- shall include any "portable physical medium".

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

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

The transaction processing apparatus 100 may be configured as an information processing apparatus such as a known personal computer or workstation, or may be configured as the information processing apparatus to which any peripheral device is connected. Also, the accounting processing device 100 may be implemented by installing software (including programs, data, etc.) that enables the device to implement the processing described in the present embodiment.

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

100 Accounting device 102 Control unit 102a Trust contract registration unit 102b Beneficiary registration unit 102c Journal input unit 102d Dividend automatic journal creation unit 102e Transfer data creation unit 102f Transfer unit 102g Screen display control unit 104 Communication interface unit 106 Storage unit 106a Data file 108 input/output interface unit 112 input device 114 output device 200 server 300 network 400 bank website

Claims (6)

An accounting processor, comprising a controller, for distributing dividends to multiple beneficiaries of a real estate trust, comprising:
The control unit
trust contract identification information, settlement date specification information for specifying the settlement date, and trust contract information including the transfer date;
beneficiary information, including trust agreement identification information, beneficiary, beneficiary interest percentage, and account information;
is configured to be accessible to
journal entry means for entering journal detail information including slip number, trust contract identification information, date of occurrence, debit, credit and amount;
By referring to the trust contract information, acquiring the trust contract identification information for the designated closing date, using the acquired trust contract identification information as a key, acquiring the beneficiary and its beneficiary right ratio from the beneficiary information, and acquiring Dividend automatic journal creation means for automatically creating journal details information proportionally divided according to the beneficiary right ratio of the acquired beneficiary with respect to the non-dividend of the journal details information for the trust contract identification information obtained;
transfer data creation means for creating transfer data based on the proportionally divided journal details information;
An accounting processing device comprising: The control unit further
2. The accounting processing apparatus according to claim 1, further comprising transfer means for transferring funds via Internet banking based on said transfer data. 3. The accounting processing apparatus according to claim 1, wherein the settlement date designation information includes an initial settlement date, a final settlement date, and the number of months in a settlement cycle. The journal details information includes a flag indicating whether or not to be transferred,
The accounting processing apparatus according to any one of claims 1 to 3, wherein said transfer data creation means creates transfer data based on said journal detail information in which said flag is a target of transfer. An accounting processing method for distributing dividends to multiple beneficiaries of a real estate trust, which is executed by an information processing device having a control unit, comprising:
The control unit
trust contract identification information, settlement date specification information for specifying the settlement date, and trust contract information including the transfer date;
beneficiary information, including trust agreement identification information, beneficiary, beneficiary interest percentage, and account information;
is configured to be accessible to
Executed in the control unit,
a journal entry step of entering journal entry detail information including a slip number, trust agreement identification information, accrual date, debit, credit and amount;
By referring to the trust contract information, acquiring the trust contract identification information for the designated closing date, using the acquired trust contract identification information as a key, acquiring the beneficiary and its beneficiary right ratio from the beneficiary information, and acquiring a dividend automatic journal creation step for automatically creating journal details information proportionally divided according to the beneficiary right ratio of the acquired beneficiary with respect to the non-dividend of the journal details information for the trust contract identification information;
a transfer data creation step of creating transfer data based on the proportionally divided journal details information;
An accounting method characterized by comprising An accounting processing program for distributing dividends to multiple beneficiaries of a real estate trust, which is executed by an information processing device having a control unit,
The control unit
trust contract identification information, settlement date specification information for specifying the settlement date, and trust contract information including the transfer date;
beneficiary information, including trust agreement identification information, beneficiary, beneficiary interest percentage, and account information;
is configured to be accessible to
In the control unit,
a journal entry step of entering journal entry detail information including a slip number, trust agreement identification information, accrual date, debit, credit and amount;
By referring to the trust contract information, acquiring the trust contract identification information for the designated closing date, using the acquired trust contract identification information as a key, acquiring the beneficiary and its beneficiary right ratio from the beneficiary information, and acquiring a dividend automatic journal creation step for automatically creating journal details information proportionally divided according to the beneficiary right ratio of the acquired beneficiary with respect to the non-dividend of the journal details information for the trust contract identification information;
a transfer data creation step of creating transfer data based on the proportionally divided journal details information;
Accounting program for executing

Images