Prediction device, prediction method, and prediction program

Abstract

To easily predict a predicted fund balance.SOLUTION: A prediction device 100 comprises a storage unit 106 and a control unit 102. The control unit 102 includes a reception unit 102a, a first obtaining unit 102b, a second obtaining unit 102c, a calculation unit 102d, and a display control unit 102e. The reception unit 102a receives input of a prediction target period of cash management. The first obtaining unit 102b obtains an opening balance, which is an actual value of a cash and deposit item before the prediction target period, from a journal detail table 106b managed by an accounting system 102f. The second obtaining unit 102c obtains expected deposit and withdrawal amounts for the prediction target period from a selling system table 106c managed by a selling system 102g. The calculation unit 102d calculates a predicted fund balance for the prediction target period based on the opening balance and the expected deposit and withdrawal amounts. The display control unit 102e displays the predicted fund balance.SELECTED DRAWING: Figure 1

Description

Technical Field

[0001] The present invention relates to a prediction device, a prediction method, and a prediction program.

Background Art

[0002] Cash flow prediction is performed from a management perspective (see, for example, Patent Document 1). For example, it is performed to predict the predicted cash balance for a specific future period using actual values and planned cash inflows and outflows.

Prior Art Documents

Patent Documents

[0003]

Patent Document 1

Summary of the Invention

Problems to be Solved by the Invention

[0004] Actual values and planned cash inflows and outflows are generally managed in separate systems, and in each system, the purpose of the system and the granularity of the data to be managed are different. For this reason, it has been difficult in the prior art to easily predict cash flow within one mechanism.

[0005] The present invention has been made in view of the above problems, and an object thereof is to provide a prediction device, a prediction method, and a prediction program capable of easily predicting a predicted cash balance.

Means for Solving the Problems

[0006] In order to solve the above-described problems and achieve the object, a prediction device according to the present invention is a prediction device including a control unit, and the control unit includes a reception unit that receives an input of a prediction target period of cash flow, and the settlement account to be predicted a first acquisition unit that acquires a journal entry table managed by an accounting system Read the account number, accounting item, accounting subsidiary item, and accounting subsidiary breakdown item corresponding to the received settlement account from the settlement account master, before the prediction target period, in and a second acquisition unit that acquires As the starting balance, which is the actual value of the cash account corresponding to the received settlement account, the total value of the amounts corresponding to each of the read accounting item, the accounting subsidiary item, and the accounting subsidiary breakdown item for the voucher dates up to the prediction target periodand the settlement account A second acquisition unit that acquires the planned amount of deposits and withdrawals from a sales system table managed by the sales system, and the predicted available balance and display the deposit / withdrawal planned amount in the first display column on the display screen, and display the starting balance in the second display column on the display screen And a display control unit for displaying.

[0007] The reception unit of the prediction device according to the present invention receives an input of an additional planned amount of deposits and withdrawals not managed by the sales system, and the calculation unit calculates the predicted available balance for the prediction target period based on the starting balance, the planned amount of deposits and withdrawals, and the additional planned amount of deposits and withdrawals.

[0009] The reception unit of the prediction device according to the present invention receives an input of the prediction target period via a display screen, and the display control unit displays the predicted available balance on the display screen.

[0010] The prediction method according to the present invention is a prediction method for causing an information processing device including a control unit to execute, and includes steps of receiving an input of a prediction target period of cash flow executed by the control unit and the settlement account to be predicted And steps of acquiring a journal entry table managed by an accounting system Read the account number, accounting item, accounting subsidiary item, and accounting subsidiary breakdown item corresponding to the received settlement account from the settlement account master, Before the prediction target period in And steps of acquiring the planned amount of deposits and withdrawals for the prediction target period from a sales system table managed by the sales system, and steps of displaying the predicted available balance. As the starting balance, which is the actual value of the cash account corresponding to the received settlement account, the total value of the amounts corresponding to each of the read accounting item, the accounting subsidiary item, and the accounting subsidiary breakdown item for the voucher dates up to and the settlement account and display the deposit / withdrawal planned amount in the first display column on the display screen, and display the starting balance in the second display column on the display screen And steps of acquiring the planned amount of deposits and withdrawals for the prediction target period from a sales system table managed by the sales system, and steps of displaying the predicted available balance. and display the deposit / withdrawal planned amount in the first display column on the display screen, and display the starting balance in the second display column on the display screen And steps of displaying.

[0011] The prediction program according to the present invention is a prediction program for causing an information processing device including a control unit to execute, and includes steps of receiving an input of a prediction target period of cash flow in the control unit and the settlement account to be predicted And steps of acquiring a journal entry table managed by an accounting system Read the account number, accounting item, accounting subsidiary item, and accounting subsidiary breakdown item corresponding to the received settlement account from the settlement account master, Before the prediction target period in And steps of acquiring the planned amount of deposits and withdrawals for the prediction target period from a sales system table managed by the sales system, and steps of displaying the predicted available balance. As the starting balance, which is the actual value of the cash account corresponding to the received settlement account, the total value of the amounts corresponding to each of the read accounting item, the accounting subsidiary item, and the accounting subsidiary breakdown item for the voucher dates up to And steps of acquiring the planned amount of deposits and withdrawals for the prediction target period from a sales system table managed by the sales system, and steps of displaying the predicted available balance. and the settlement accountStep of obtaining the expected deposit and withdrawal amount from the sales system table managed by the sales system, step of calculating the predicted remaining funds for the prediction target period based on the starting balance and the expected deposit and withdrawal amount, and the predicted remaining funds and display the deposit / withdrawal planned amount in the first display column on the display screen, and display the starting balance in the second display column on the display screen Step of displaying, and is a prediction program for causing the steps to be executed.

Effect of the Invention

[0012] According to the present invention, there is an effect that the predicted remaining funds can be easily predicted.

Brief Description of the Drawings

[0013]

Figure 1

Figure 2

Figure 3

Figure 4

Figure 5

Figure 6

Figure 7A

Figure 7B

Figure 7C

Figure 7D

Figure 7E

Figure 7F

Figure 8

Figure 9

Figure 10

Embodiments for Carrying Out the Invention

[0014] Hereinafter, embodiments of the prediction device, prediction method, and prediction program according to the present invention will be described in detail with reference to the drawings. Note that the present invention is not limited by this embodiment.

[0015] [1. Configuration] An example of the configuration of the prediction device 100 according to this embodiment will be described with reference to FIG. 1. FIG. 1 is a block diagram showing an example of the configuration of the prediction device 100.

[0016] The prediction device 100 is an information processing device for performing a cash flow prediction for a specific future period. The prediction device 100 of this embodiment calculates a predicted cash balance for the prediction target period as the cash flow prediction.

[0017] The prediction device 100 is a commercially available desktop personal computer. Note that the prediction device 100 is not limited to a stationary information processing device such as a desktop personal computer, and may be a portable information processing device such as a commercially available notebook personal computer, PDA (Personal Digital Assistants), smartphone, or tablet personal computer.

[0018] The prediction device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each unit included in the prediction device 100 is communicably connected via an arbitrary communication path.

[0019] The communication interface unit 104 communicably connects the prediction 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 a communication line. Here, the network 300 has a function of communicably connecting the prediction device 100 and the server 200 to each other, and is, for example, the Internet or a LAN (Local Area Network). Note that various data stored in the storage unit 106 may be stored in the server 200, for example.

[0020] An input / output interface unit 108 has an input device 112 and an output device 114 connected thereto. As the output device 114, in addition to a display (including a home television), a speaker or a printer can be used. As the input device 112, in addition to a keyboard, a mouse, and a microphone, a display that cooperates with the mouse to realize a pointing device function can be used. Hereinafter, the output device 114 may be described as the display 114, and the input device 112 may be described as the keyboard 112 or the mouse 112.

[0021] The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 records a computer program for giving commands to the CPU (Central Processing Unit) in cooperation with the OS (Operating System) to perform various processes. As the storage unit 106, for example, a memory device such as a RAM (Random Access Memory) or a ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, and an optical disk can be used.

[0022] The storage unit 106 stores, for example, a settlement account master 106a, a journal detail table 106b, a sales system table 106c, and a cash flow detail table 106d. The sales system table 106c includes a collection schedule table 106c1, a deposit detail table 106c2, a billing destination master 106c3, a payment schedule table 106c4, a payment detail table 106c5, and a payee master 106c6. The data formats of these masters and tables are, for example, a database, but may also be tables or the like.

[0023] Specific examples of the data configurations of these masters and tables will be described later. In the present embodiment, the structures of the masters and tables are described in a simplified manner. The actual structures of the masters and tables used by the prediction device 100 are more complex, but parts not directly related to the present invention are shown in a more simplified manner than the actual ones.

[0024] The control unit 102 is a CPU or the like that comprehensively controls the prediction device 100. The control unit 102 has an internal memory for storing control programs such as an OS (operating system), programs defining various processing procedures, and required data, and executes various information processes based on these stored programs.

[0025] In the present embodiment, the control unit 102 includes a reception unit 102a, a first acquisition unit 102b, a second acquisition unit 102c, a calculation unit 102d, and a display control unit 102e.

[0026] Also, in the present embodiment, the control unit 102 includes an accounting system 102f and a sales system 102g.

[0027] The accounting system 102f is a system that manages the opening balance, which is the actual value of the cash and deposits account. Specifically, the accounting system 102f is a system that manages the balance at a specific date and time for each account (including subsidiary / breakdown) managed as a cash and deposits account. The accounts are accounts such as current accounts and ordinary deposits. In the accounting system 102f, when the granularity of the data to be managed is per bank account, the actual value of the balance is managed in units of bank accounts. For the accounting system 102f, a known accounting system may be used. The accounting system 102f manages the actual value of the cash and deposits account using the journal detail table 106b. That is, the journal detail table 106b is the master managed by the accounting system 102f.

[0028] The sales system 102g is a system that manages the estimated amount of receipts and payments. Specifically, the sales system 102g manages the estimated receipt amount and the estimated payment amount using the sales system table 106c. That is, the sales system table 106c is the master managed by the sales system 102g.

[0029] The estimated receipts include, for example, the estimated receipts by bank transfer and the outstanding balance of uncollected received bills.

[0030] The estimated receipts by bank transfer are represented, for example, by the recovery schedule data based on the recorded data such as the outstanding order / sales amount. The recovery schedule date is, for example, the date calculated according to the closing date / settlement conditions. In the sales system 102g, for example, by setting the settlement account of the customer master 106c3, it is managed so that it is possible to grasp the estimated receipts to which bank / account.

[0031] The outstanding balance of uncollected received bills is represented, for example, by the data in which the bill is cashed based on the actual data collected by received bills and electronic claims. Therefore, the outstanding balance of uncollected received bills is managed based on the bill due date. In the sales system 102g, for example, by setting the settlement account of the customer master 106c3, it is managed so that it is possible to grasp the estimated receipts to which bank / account.

[0032] The scheduled disbursements include, for example, the scheduled payments by bank transfer and the outstanding balance of unpaid payment bills.

[0033] The scheduled payments by bank transfer are represented by, for example, the payment schedule data based on the accounting data such as the outstanding purchase / expenses. The scheduled payment date is, for example, the date calculated according to the closing date and settlement conditions. In the sales system 102g, for example, in the case of transfer payment, it is possible to manage and grasp to which bank / account the payment is scheduled based on the setting of the settlement account in the payee master 106c6.

[0034] The actual outstanding balance of payment bills is represented by, for example, the settlement schedule data of the bills based on the actual data of the bills and electronic debts issued by the company itself. Therefore, the actual outstanding balance of payment bills is managed based on the bill due date. In the sales system 102g, for example, similar to the transfer payment, it is possible to manage and grasp to which bank / account the payment is scheduled based on the setting of the payee master 106c6.

[0035] In this embodiment, the control unit 102 is described as an example in a form including both the accounting system 102f and the sales system 102g. However, at least one of the accounting system 102f and the sales system 102g may be installed in an external information processing device such as the server 200. In this case, the latest versions of the journal entry table 106b and the sales system table 106c managed by each of the accounting system 102f and the sales system 102g may be stored in the storage unit 106. For example, the control unit 102 may obtain the latest versions of the journal entry table 106b and the sales system table 106c managed by each of the accounting system 102f and the sales system 102g installed in the external information processing device and store them in the storage unit 106.

[0036] The reception unit 102a receives an input of the prediction target period for the cash flow. The reception unit 102a receives the prediction target period input by an operation instruction of the input device 112 by the user. For example, the reception unit 102a receives an input of the prediction target period via a display screen. The reception unit 102a may receive an input of the prediction target period and the settlement account of the prediction target.

[0037] In addition, the reception unit 102a receives an input of an additional deposit / withdrawal scheduled amount not managed by the sales system 102g.

[0038] The additional deposit / withdrawal scheduled amount is an amount for the user to arbitrarily add a deposit / withdrawal schedule other than the deposit / withdrawal scheduled amount managed by the sales system 102g. The additional deposit / withdrawal scheduled amount includes an additional deposit scheduled amount and an additional withdrawal scheduled amount. For example, the user inputs, as the additional deposit / withdrawal scheduled amount, increases or decreases in funds generated in selling and administrative expenses or non-operating activities.

[0039] The first acquisition unit 102b acquires, from the journal entry detail table 106b managed by the accounting system 102f, the starting balance which is the actual value of the cash-in-hand account before the prediction target period received by the reception unit 102a. When the reception unit 102a receives the prediction target period and the settlement account, the first acquisition unit 102b may acquire, from the journal entry detail table 106b, the starting balance of the settlement account before the prediction target period.

[0040] The second acquisition unit 102c acquires, from the sales system table 106c managed by the sales system 102g, the deposit / withdrawal scheduled amount for the prediction target period received by the reception unit 102a. When the reception unit 102a receives the prediction target period and the settlement account, the second acquisition unit 102c acquires, from the sales system table 106c, the deposit / withdrawal scheduled amount for the received prediction target period and settlement account.

[0041] The calculation unit 102d calculates the predicted fund balance for the prediction target period based on the starting balance acquired by the first acquisition unit 102b and the planned deposit / withdrawal amount acquired by the second acquisition unit 102c. Further, when the reception unit 102a receives the input of the additional planned deposit / withdrawal amount, the calculation unit 102d calculates the predicted fund balance for the prediction target period based on the starting balance, the planned deposit / withdrawal amount, and the additional planned deposit / withdrawal amount.

[0042] Specifically, the calculation unit 102d calculates the predicted fund balance according to the following formula (1).

[0043] Starting balance + Planned deposit amount - Planned withdrawal amount + Additional planned deposit amount - Additional planned withdrawal amount = Predicted fund balance ··· Formula (1)

[0044] The display control unit 102e displays on the display 114 a display screen including the calculated predicted fund balance.

[0045] [2. Specific example] With reference to FIGS. 2 to 10, a specific example of the processing of the prediction device 100 in the present embodiment will be described.

[0046] FIG. 2 is a flowchart showing an example of the processing flow of the prediction device 100 in the present embodiment.

[0047] The display control unit 102e displays on the display 114 the fund flow prediction display screen 30 (step S100). The reception unit 102a receives the prediction target period and the settlement account input via the display screen 30 (step S102).

[0048] FIG. 3 is a schematic diagram showing an example of the display screen 30. The display screen 30 includes, for example, an input field 30A for the prediction target period, an input field 30B for the settlement account of the prediction target, a display field 30C for the starting balance, and a display field 30D for the planned deposit / withdrawal and the predicted fund balance.

[0049] The user operates the input device 112 while referring to the display screen 30, enters the cash flow prediction target period in the input field 30A for the prediction target period, and enters the settlement account in the input field 30B for the settlement account to be predicted. FIG. 3 shows, as an example, a scene where the prediction target period "2021 / 7 to 2021 / 12" and the settlement account "M001" are entered. The reception unit 102a receives the prediction target period and the settlement account from the input device 112.

[0050] Note that the display control unit 102e may specify the settlement account name corresponding to the received settlement account from the settlement account master 106a and display it on the display screen 30.

[0051] FIG. 4 is a schematic diagram showing an example of the data configuration of the settlement account master 106a. The settlement account master 106a is registered with the settlement account code, the settlement account name, the bank code, the deposit type, the account number, the accounting ledger item, the accounting auxiliary item, and the accounting auxiliary breakdown item associated with each other. The settlement account code is an example of an item used as a search key on the sales system 102g side. The account number, the accounting ledger item, the accounting auxiliary item, and the accounting auxiliary breakdown item are examples of items used as search keys on the accounting system 102f side.

[0052] The display control unit 102e reads the settlement account name corresponding to the received settlement account "M001" in the settlement account master 106a and displays it on the display screen 30. In this case, as shown in FIG. 3, the settlement account name corresponding to the input settlement account is displayed.

[0053] Returning to FIG. 2, the description continues. The first acquisition unit 102b aggregates and acquires the opening balance of the settlement account received in step S102 from the journal detail table 106b before the prediction target period received in step S102 (step S104).

[0054] The first acquisition unit 102b reads the account number, accounting item, accounting subsidiary item, and accounting subsidiary breakdown item, which are the search keys of the accounting system 102f, corresponding to the settlement account received in step S102 in the settlement account master 106a. Assume that the forecast target period "2021 / 7 to 2021 / 12" was received in step S102 and the settlement account "M001" was received, and the explanation will continue. In this case, the first acquisition unit 102b acquires the account number "1234567", accounting item "1005", accounting subsidiary item "0005", and accounting subsidiary breakdown item "12345", which are the search keys of the accounting system 102f, corresponding to the settlement account "M001" in the settlement account master 106a.

[0055] Then, the first acquisition unit 102b acquires, as before the forecast target period, for example, the actual value of the cash in hand item of the settlement account "M001" in June 2021 from the journal entry details table 106b.

[0056] Figure 5 is a schematic diagram showing an example of the data structure of the journal entry details table 106b. The journal entry details table 106b is a database that associates, for example, the voucher date, voucher number, debit account item, debit subsidiary item, debit subsidiary breakdown, credit account item, credit subsidiary item, credit subsidiary breakdown, amount, and voucher summary.

[0057] The first acquisition unit 102b reads, as the actual values before the forecast target period "2021 / 7 to 2021 / 12", the "amounts" corresponding to each of the accounting item "1005", accounting subsidiary item "0005", and accounting subsidiary breakdown item "12345" in the journal entry details table 106b of the account number "1234567" corresponding to the settlement account "M001" with the voucher date up to the end of June 2021. In the case of the example shown in Figure 5, the first acquisition unit 102b reads each amount of "￥125,800", "￥43,456", "￥61,000", "￥12,000", "￥43,000", and "￥15,800". Then, the first acquisition unit 102b acquires "￥123,456", which is the total amount of these amounts, as the opening balance of the settlement account "M001".

[0058] Returning to FIG. 2, the description will be continued. The display control unit 102e displays the starting balance obtained in step S104 in the display column 30C for the starting balance on the display screen 30 (step S106).

[0059] FIG. 6 is a schematic diagram of an example of the display screen 30. By the process of step S106, the starting balance "￥123,456" is displayed in the input field 30B for the settlement account to be predicted on the display screen 30.

[0060] Returning to FIG. 2, the description will be continued. The display control unit 102e stores the values on the display screen 30 in the storage unit 106 (step S108). For example, the display control unit 102e stores in the storage unit 106 by associating the prediction target period input in the input field 30A for the prediction target period, the settlement account input in the input field 30B for the settlement account to be predicted, and the starting balance displayed in the display column 30C for the starting balance.

[0061] Next, the second acquisition unit 102c acquires from the sales system table 106c the prediction target period and the estimated amount of deposits and withdrawals for the settlement account received in step S102 (step S110).

[0062] FIGS. 7A to 7F are schematic diagrams showing an example of the data configuration of the sales system table 106c. As described above, the sales system table 106c includes a collection schedule table 106c1, a deposit details table 106c2, a billing destination master 106c3, a payment schedule table 106c4, a payment details table 106c5, and a payment destination master 106c6.

[0063] FIG. 7A is a schematic diagram showing an example of the data configuration of the collection schedule table 106c1. The collection schedule table 106c1 is a table managed by the sales system 102g and is a table for managing the estimated incoming funds by bank transfer. For example, the collection schedule table 106c1 is a table that associates a voucher number, a billing destination, a posting date, a collection schedule date, a collection scheduled amount, an amount already collected, and an uncollected amount.

[0064] FIG. 7B is a schematic diagram showing an example of the data configuration of the deposit details table 106c2. The deposit details table 106c2 is a table managed by the sales system 102g and is a table for managing the outstanding balance of received bill payments. For example, the deposit details table 106c2 is a table that associates a voucher number, a billing destination, a deposit date, a deposit classification, a bill type, and a deposit amount.

[0065] FIG. 7C is a schematic diagram showing an example of the data configuration of the billing destination master 106c3. The billing destination master 106c3 is a table that associates a billing destination code, a billing destination name, settlement conditions, and a settlement account.

[0066] FIG. 7D is a schematic diagram showing an example of the data configuration of the payment schedule table 106c4. The payment schedule table 106c4 is a table managed by the sales system 102g and is a table for managing payment schedules by bank transfer. For example, the payment schedule table 106c4 is a table that associates a voucher number, a payee, a posting date, a payment schedule date, a payment method, a scheduled payment amount, an amount paid, and an outstanding amount.

[0067] FIG. 7E is a schematic diagram showing an example of the data configuration of the payment details table 106c5. The payment details table 106c5 is a table managed by the sales system 102g and is a table for managing the outstanding balance of payment bills. For example, the payment details table 106c5 is a table that associates a voucher number, a payee, a payment date, a payment classification, a bill type, a bill due date, and a payment amount.

[0068] FIG. 7F is a schematic diagram showing an example of the data configuration of the payee master 106c6. The payee master 106c6 is a table that associates a payee code, a payee name, settlement conditions, and a settlement account.

[0069] For example, the second acquisition unit 102c identifies the billing destination codes "SK001" and "SK002" corresponding to the settlement account "M001" received in step S102 from the billing destination master 106c3. Then, the second acquisition unit 102c sets the prediction target period "2021 / 7 to 2021 / 12" received in step S102 as the scheduled collection date, and acquires the outstanding amounts "￥500" and "￥3,500" corresponding to the identified billing destination codes "SK001" and "SK002" as the scheduled incoming funds by bank transfer.

[0070] Also, the second acquisition unit 102c identifies the billing destination codes "SK001" and "SK002" corresponding to the settlement account "M001" received in step S102 from the billing destination master 106c3. Then, the second acquisition unit 102c sets the prediction target period "2021 / 7 to 2021 / 12" received in step S102 as the bill date, and acquires the received amounts "￥1,000" and "￥5,000" corresponding to the identified billing destination codes "SK001" and "SK002" as the unsettled balance of the received bill deposits.

[0071] Also, the second acquisition unit 102c identifies the payee code "SSH100" corresponding to the settlement account "M001" received in step S102 from the payee master 106c6. Then, the second acquisition unit 102c sets the prediction target period "2021 / 7 to 2021 / 12" received in step S102 as the scheduled payment date, and acquires the outstanding amounts "￥750", "￥3,500", "￥4,500", and "￥17,800" corresponding to the identified payee code "SSH100" as the scheduled payments by bank transfer.

[0072] Also, the second acquisition unit 102c identifies the payee code "SSH100" corresponding to the settlement account "M001" received in step S102 from the payee master 106c6. Then, the second acquisition unit 102c sets the prediction target period "2021 / 7 to 2021 / 12" received in step S102 as the bill date, and acquires the payment amount "￥70,000" corresponding to the identified payee code "SSH100" as the unsettled balance of the payment bill.

[0073] Through these processes, the second acquisition unit 102c acquires, as the deposit and withdrawal scheduled amounts corresponding to the settlement account "M001" and the prediction target period "2021 / 7 to 2021 / 12", the deposit scheduled amount including the unsettled balance of the deposit by bank transfer and the uncollected check deposit corresponding to each of the year, month, and day representing the due date, and the withdrawal scheduled amount including the scheduled payment by bank transfer and the unsettled balance of the payment check.

[0074] The display control unit 102e displays the deposit and withdrawal scheduled amounts acquired in step S110 in the display column 30D for the deposit and withdrawal schedule and the predicted fund balance on the display screen 30 for each year, month, and day of the due date.

[0075] Returning to FIG. 2 and continuing the explanation. The calculation unit 102d calculates the predicted fund balance for the prediction target period based on the starting balance acquired in step S104 and the deposit and withdrawal scheduled amounts acquired in step S110 (step S112). For example, the calculation unit 102d calculates the value of "starting balance + deposit scheduled amount - withdrawal scheduled amount" for each due date for the starting balance acquired in step S104 and the deposit and withdrawal scheduled amounts acquired in step S110. Through this calculation process, the calculation unit 102d calculates the predicted fund balance for each due date.

[0076] The display control unit 102e displays the predicted fund balance calculated in step S112 in the display column 30D for the deposit and withdrawal schedule and the predicted fund balance on the display screen 30 (step S114).

[0077] FIG. 8 is a schematic diagram showing an example of the display screen 30. By the process of step S114, in the display column 30D for the planned deposits / withdrawals and predicted remaining funds of the display screen 30, for each year, month, and day of the due date, the planned deposit amount by bank transfer which is the planned deposit / withdrawal amount, the planned deposit amount including the unsettled balance of the received bill deposit, the planned payment amount by bank transfer, and the withdrawal planned amount including the unsettled balance of the payment bill, and the predicted remaining funds are displayed. In the display screen 30, "transfer deposit" corresponds to "planned deposit by bank transfer", "unsettled received" corresponds to "unsettled balance of the received bill deposit", "transfer payment" corresponds to "planned payment by bank transfer", and "unsettled payment" corresponds to "unsettled balance of the payment bill".

[0078] Returning to FIG. 2, the description continues. The display control unit 102e stores the values of the display screen 30 in the storage unit 106 (step S116). For example, the display control unit 102e associates and stores in the storage unit 106 the predicted target period input in the input column 30A for the predicted target period, the settlement account input in the input column 30B for the settlement account of the predicted target, the starting balance displayed in the display column 30C for the starting balance, and the deposit / withdrawal planned amounts and predicted remaining funds for each year, month, and day which are the due date, displayed in the display column 30D for the planned deposits / withdrawals and predicted remaining funds.

[0079] Next, the reception unit 102a receives an additional deposit / withdrawal planned amount from the input device 112 (step S118). The calculation unit 102d calculates the predicted remaining funds for the predicted target period based on the starting balance acquired in step S104, the deposit / withdrawal planned amount acquired in step S110, and the additional deposit / withdrawal planned amount received in step S118 (step S120). Then, the display control unit 102e displays the received additional deposit / withdrawal planned amount and the calculated predicted remaining funds on the display screen 30 (step S122).

[0080] Specifically, in step S118, for example, while visually recognizing the display screen 30 (see FIG. 8) displayed on the display 114 in step S114, the user inputs an additional deposit amount in the column of "other (deposit)" in the display column 30D for the planned deposits / withdrawals and predicted remaining funds, and inputs an additional withdrawal amount in the column of "other (withdrawal)".

[0081] FIG. 9 is a schematic diagram showing an example of the display screen 30. For example, it is assumed that the amounts shown in FIG. 9 are input to the additional deposit scheduled amount input field 30D1 in the display column 30D for the scheduled deposit / withdrawal and the predicted fund balance, and the additional withdrawal scheduled amount input field 30D2 in the display column 30D for the scheduled deposit / withdrawal and the predicted fund balance, respectively.

[0082] Specifically, an additional deposit scheduled amount representing that a deposit of "￥100" is scheduled as the received interest of "Other (Deposit)" on July 1, 2021 is input. Also, for example, an additional payment scheduled amount representing that a rent payment of "￥1,200" is scheduled as the "Other (Payment)" on July 1, 2021 is input. Also, for example, an additional deposit scheduled amount representing that a loan of "￥300" is scheduled as the "Other (Deposit)" on July 6, 2021 is input. Also, for example, an additional payment scheduled amount representing that a payment of "￥1,200" is scheduled for the advance settlement of expenses as the "Other (Payment)" on July 6, 2021 is input. Also, for example, an additional payment scheduled amount representing that a payment of "￥5,000" is scheduled for the advance settlement of salary as the "Other (Payment)" on July 6, 2021 is input.

[0083] The calculation unit 102d calculates the predicted fund balance for each of the year, month, and day which are the due dates, using the above formula (1). Then, the display control unit 102e displays the received additional deposit / withdrawal scheduled amount and the calculated predicted fund balance on the display screen 30. Therefore, as shown in FIG. 9, the calculation result of the predicted fund balance is displayed in the predicted fund balance display column 30D3 of the display column 30D for the scheduled deposit / withdrawal and the predicted fund balance.

[0084] Therefore, for example, by referring to the displayed predicted fund balance, the user can easily confirm the fund flow prediction and determine the timing of a fund shortage. Also, the additional deposit scheduled amount input field 30D1 and the additional withdrawal scheduled amount input field 30D2 can also be used for simulating the fund flow prediction.

[0085] Returning to FIG. 2, the description will be continued. The display control unit 102e stores the values on the display screen 30 in the storage unit 106 (step S124). Then, this routine ends. For example, the display control unit 102e associates and stores in the storage unit 106 the prediction target period input in the input field 30A for the prediction target period, the settlement account input in the input field 30B for the settlement account of the prediction target, the starting balance displayed in the display field 30C for the starting balance, and the planned deposit / withdrawal and predicted funds balance displayed in the display field 30D for the planned deposit / withdrawal amount, additional planned deposit / withdrawal amount, and predicted funds balance for each year, month, and day which are the due dates. Further, the display control unit 102e registers the additional planned deposit / withdrawal amount input in each of the additional deposit planned amount input field 30D1 and the additional withdrawal planned amount input field 30D2 in the display field 30D for the planned deposit / withdrawal and predicted funds balance in the fund flow details table 106d in association with the settlement account received in step S102.

[0086] FIG. 10 is a schematic diagram showing an example of the data configuration of the fund flow details table 106d. The fund flow details table 106d is a table for managing the additional planned deposit / withdrawal amount. For example, the fund flow details table 106d is a table that associates the year, month, and day, the settlement account, other deposits, and other payments. "Other deposits" corresponds to the additional deposit planned amount, and "other payments" corresponds to the additional withdrawal planned amount.

[0087] Therefore, the prediction device 100 can manage the additional initial deposit planned amount for each year, month, day, and settlement account.

[0088] As described above, the prediction device 100 of the present embodiment includes a storage unit 106 and a control unit 102. The control unit 102 includes a reception unit 102a, a first acquisition unit 102b, a second acquisition unit 102c, a calculation unit 102d, and a display control unit 102e. The reception unit 102a receives an input of a prediction target period for the cash flow. The first acquisition unit 102b acquires a starting balance, which is the actual value of the cash-in-hand account before the prediction target period, from the journal entry detail table 106b managed by the accounting system 102f. The second acquisition unit 102c acquires the planned amount of cash inflows and outflows during the prediction target period from the sales system table 106c managed by the sales system 102g. The calculation unit 102d calculates a predicted cash balance for the prediction target period based on the starting balance and the planned amount of cash inflows and outflows. The display control unit 102e displays the predicted cash balance.

[0089] Here, conventionally, cash flow prediction has been performed from a business management perspective. For example, in order for a company to conduct sound management, it is generally necessary for many companies to grasp the excess or deficiency of cash-in-hand according to the cash flow plan. It is necessary to predict and grasp not only the profit and loss of the business but also the funds at hand, and to plan necessary borrowings, fund transfers, and set collection / payment sites. Conventionally, the accounting cash balance and the planned cash inflows and outflows in core systems such as the sales system have been managed as separate data, and they have often been aggregated outside the system to perform cash flow prediction calculations. In addition, since there are also elements of cash inflows and outflows (fund increases and decreases) due to factors other than commercial transactions, it has been difficult to construct a cash flow prediction within a single mechanism. That is, it is common for the actual values and the planned cash inflows and outflows to be managed in separate systems, and in each system, the purpose of the system and the granularity of the data to be managed are different. For this reason, it has been difficult to easily predict the cash flow within a single mechanism in the prior art.

[0090] On the one hand, in the prediction device 100 of the present embodiment, according to the prediction target period input by the user, the starting balance, which is the actual value before the prediction target period, is acquired from the journal entry detail table 106b managed by the accounting system 102f, and the estimated amount of cash inflow and outflow for the prediction target period is acquired from the sales system table 106c managed by the sales system 102g. Then, the calculation unit 102d calculates the predicted cash balance for the prediction target period based on the starting balance and the estimated amount of cash inflow and outflow, and the display control unit 102e displays the calculated predicted cash balance.

[0091] Therefore, in the prediction device 100 of the present embodiment, the predicted cash balance can be easily predicted.

[0092] That is, in the prediction device 100 of the present embodiment, based on the balance of the cash and deposits account of the accounting system 102f at a specific point in time, the future cash balance can be calculated by taking into account the planned cash inflow and outflow for the future prediction target period from the transaction vouchers on the sales system 102g.

[0093] In addition, in the prediction device 100 of the present embodiment, it is possible to realize from the input of the prediction target period to the display of the predicted cash balance on one display screen 30.

[0094] Note that since the future planned cash inflow and outflow required for cash flow prediction may also occur outside the sales system 102g, it is necessary to take these elements into account.

[0095] The prediction device 100 of the present embodiment accepts the input of the additional estimated amount of cash inflow and outflow not managed by the sales system 102g, and the calculation unit 102d calculates the predicted cash balance for the prediction target period based on the starting balance, the estimated amount of cash inflow and outflow, and the additional estimated amount of cash inflow and outflow.

[0096] Therefore, the prediction device 100 of the present embodiment can arbitrarily take into account elements other than the vouchers of commercial transactions managed by the sales system 102g, and can predict the predicted cash balance with high accuracy.

[0097] [3. Contribution to the Sustainable Development Goals (SDGs) Led by the United Nations] According to this embodiment, it is possible to contribute to promoting business efficiency and appropriate business judgment of enterprises, and thus it is possible to contribute to Goals 8 and 9 of the SDGs.

[0098] In addition, according to this embodiment, it is possible to contribute to reducing waste loss and promoting paperless and digitalization, and thus it is possible to contribute to Goals 12, 13 and 15 of the SDGs.

[0099] In addition, according to this embodiment, it is possible to contribute to strengthening control and governance, and thus it is possible to contribute to Goal 16 of the SDGs.

[0100] [4. Other Embodiments] In addition to the above-described embodiments, the present invention may be implemented in various different embodiments within the scope of the technical idea described in the claims.

[0101] For example, among the processes described in the embodiment, all or part of the processes described as being automatically performed can be manually performed, or all or part of the processes described as being manually performed can be automatically performed by a known method.

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

[0103] In addition, regarding the prediction device 100, each component shown in the figure is a functional concept, and it is not necessarily physically configured as shown in the figure.

[0104] For example, regarding the processing functions provided in the prediction device 100, particularly each processing function performed by the control unit 102, all or any part thereof may be realized by a CPU and a program interpreted and executed by the CPU, or may be realized as hardware by wired logic. Note that the program is recorded on a non-transitory computer-readable recording medium including programmed instructions for causing the information processing device to execute the processing described in the present embodiment, and is mechanically read by the prediction device 100 as necessary. That is, in a storage unit such as a ROM or an HDD (Hard Disk Drive), a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded. This computer program is executed by being loaded into the RAM, and constitutes the control unit in cooperation with the CPU.

[0105] Further, this computer program may be stored in an application program server connected to the prediction device 100 via an arbitrary network, and all or part of it can be downloaded as necessary.

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

[0107] In addition, a "program" is a data processing method described in any language or description method, regardless of the form such as source code or binary code. Note that the "program" is not necessarily limited to being configured in a single form, and includes those that are distributed as a plurality of modules or libraries, or those that achieve their functions in cooperation with other separate programs typified by an OS. Regarding the specific configuration, reading procedure, and installation procedure after reading for reading a recording medium in each device shown in this embodiment, well-known configurations and procedures can be used.

[0108] The various databases and the like stored in the storage unit 106 are storage means such as a memory device such as a RAM or a ROM, a fixed disk device such as a hard disk, a flexible disk, and an optical disk, and store various programs, tables, databases, and web page files used for various processes and website provision.

[0109] Further, the prediction device 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device to which an arbitrary peripheral device is connected. Further, the prediction device 100 may be realized by installing software (including programs or data, etc.) for realizing the processing described in this embodiment in the device.

[0110] Furthermore, the specific form of the 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 arbitrary units according to various additions or according to the function load. That is, the above-described embodiments may be arbitrarily combined and implemented, or the embodiments may be selectively implemented.

Explanation of Reference Numerals

[0111] 100 Prediction device 102 Control unit 102a Reception unit 102b First acquisition unit 102c Second acquisition unit 102d Calculation unit 102e Display control unit

Claims

1. A prediction device comprising a control unit, The control unit A reception unit that receives an input of a prediction target period for cash flow and a settlement account to be predicted; Reads the account number, accounting item, accounting subsidiary item, and accounting subsidiary breakdown item corresponding to the received settlement account from the settlement account master, and in the journal detail table managed by the accounting system, the total amount corresponding to each of the read accounting item, accounting subsidiary item, and accounting subsidiary breakdown item for the voucher date before the prediction target period is obtained as the starting balance, which is the actual value of the cash and deposit item corresponding to the received settlement account, by a first acquisition unit; A second acquisition unit that acquires the prediction target period and the estimated amount of deposits and withdrawals for the settlement account from a sales system table managed by the sales system; A calculation unit that calculates the predicted cash balance for the prediction target period based on the starting balance and the estimated amount of deposits and withdrawals; A display control unit that displays the predicted cash balance and the estimated amount of deposits and withdrawals in a first display column on a display screen, and displays the starting balance in a second display column on the display screen; A prediction device comprising the above.

2. The reception unit Receives an input of an additional estimated amount of deposits and withdrawals not managed by the sales system, The calculation unit Calculates the predicted cash balance for the prediction target period based on the starting balance, the estimated amount of deposits and withdrawals, and the additional estimated amount of deposits and withdrawals. The prediction device according to claim 1.

3. The reception unit Receives an input of the prediction target period via a display screen, The display control unit Displays the predicted cash balance on the display screen. The prediction device according to claim 1 or claim 2.

4. A prediction method for causing an information processing apparatus including a control unit to execute, executed by the control unit, a step of receiving an input of a prediction target period of cash flow and a settlement account to be predicted; reading, from a settlement account master, an account number, an accounting ledger item, an accounting auxiliary item, and an accounting auxiliary breakdown item corresponding to the received settlement account, and in a journal detail table managed by an accounting system, for the voucher dates before the prediction target period, obtaining, as a starting balance which is the actual value of the cash and deposit account corresponding to the received settlement account, the total value of the amounts corresponding to each of the read accounting ledger item, the accounting auxiliary item, and the accounting auxiliary breakdown item; a step of obtaining, from a sales system table managed by a sales system, the prediction target period and the estimated amount of deposits and withdrawals of the settlement account; a step of calculating an estimated cash balance for the prediction target period based on the starting balance and the estimated amount of deposits and withdrawals; a step of displaying the estimated cash balance and the estimated amount of deposits and withdrawals in a first display column on a display screen, and displaying the starting balance in a second display column on the display screen; A prediction method including the above.

5. A prediction program for causing an information processing apparatus including a control unit to execute, in the control unit, a step of receiving an input of a prediction target period of cash flow and a settlement account to be predicted; reading, from a settlement account master, an account number, an accounting ledger item, an accounting auxiliary item, and an accounting auxiliary breakdown item corresponding to the received settlement account, and in a journal detail table managed by an accounting system, for the voucher dates before the prediction target period, obtaining, as a starting balance which is the actual value of the cash and deposit account corresponding to the received settlement account, the total value of the amounts corresponding to each of the read accounting ledger item, the accounting auxiliary item, and the accounting auxiliary breakdown item; A step of obtaining the prediction target period and the predicted deposit and withdrawal amount of the settlement account from a sales system table managed by a sales system; A step of calculating a predicted fund balance for the prediction target period based on the starting balance and the predicted deposit and withdrawal amount; A step of displaying the predicted fund balance and the predicted deposit and withdrawal amount in a first display column on a display screen, and displaying the starting balance in a second display column on the display screen; A prediction program for causing the above to be executed.

Images