Exchange reservation management device, exchange reservation management method, and exchange reservation management program

Abstract

To provide an exchange reservation management device capable of easily performing end-of-term processing for exchange reservations, an exchange reservation management method, and an exchange reservation management program.SOLUTION: An exchange reservation management device in an embodiment acquires futures rate data from outside that corresponds to the reservation amount and the specific date futures rate for each bank exchange reservation number, and acquires specific day futures rates in the futures rate data linked to the bank exchange reservation number of the exchange reservation data based on futures rate data and exchange contract data and calculates the deferred hedge profit and loss amount for each exchange reservation sequence number.SELECTED DRAWING: Figure 1

Description

Technical Field

[0001] The present invention relates to a foreign exchange reservation management device, a foreign exchange reservation management method, and a foreign exchange reservation management program.

Background Art

[0002] Patent Document 1 discloses a technique for automatically determining what rules are attached to the transaction results between each individual company and the affiliated company, and collecting transaction data between the affiliated companies.

Prior Art Documents

Patent Documents

[0003]

Patent Document 1

Summary of the Invention

Problems to be Solved by the Invention

[0004] By the way, in a company, it is common in the closing process to compare the unallocated balance of foreign exchange reservations with the rate at the time of making a foreign exchange reservation at the end of the period, and to generate a journal entry for the difference as the deferred hedge profit or loss.

[0005] However, conventionally, after an operator extracts the unallocated reservations of foreign exchange reservations managed by the company itself, the operator manually associates the rate of foreign exchange reservations on a specific date managed by the bank with the rate of the company's foreign exchange reservations and calculates the rate difference. Therefore, there is a problem that the work of the end-of-period process in foreign exchange reservations becomes extremely large and very complicated.

[0006] The present invention has been made in view of the above, and an object thereof is to provide a foreign exchange reservation management device, a foreign exchange reservation management method, and a foreign exchange reservation management program capable of performing end-of-period processing in foreign exchange reservations with a simple operation.

Means for Solving the Problems

[0007] In order to solve the above-described problems and achieve the object, a foreign exchange reservation management apparatus according to the present invention is a foreign exchange reservation management apparatus including a control unit, and for each foreign exchange reservation serial number, it can access foreign exchange reservation data in which a reservation classification, a currency, a contracting bank, a reservation rate, a bank foreign exchange reservation number, a reservation amount, a reserved amount for contract, and a settled purchase amount are associated. The control unit includes an acquisition unit that acquires from the outside futures rate data in which a reservation amount and a specific date futures rate are associated for each bank foreign exchange reservation number, and a journal entry creation processing unit that calculates a deferred hedge profit and loss amount for each foreign exchange reservation serial number by acquiring the specific date futures rate in the futures rate data associated with the bank foreign exchange reservation number of the foreign exchange reservation data based on the futures rate data and the foreign exchange reservation data. It is characterized by this.

[0008] Further, a foreign exchange reservation management method according to the present invention is a foreign exchange reservation management method executed by a foreign exchange reservation management apparatus including a control unit. The foreign exchange reservation management apparatus can access foreign exchange reservation data in which a reservation classification, a currency, a contracting bank, a reservation rate, a bank foreign exchange reservation number, a reservation amount, a reserved amount for contract, and a settled purchase amount are associated for each foreign exchange reservation serial number. The method includes an acquisition step of acquiring from the outside futures rate data in which a reservation amount and a specific date futures rate are associated for each bank foreign exchange reservation number, which is executed by the control unit, and a journal entry creation processing step of calculating a deferred hedge profit and loss amount for each foreign exchange reservation serial number by acquiring the specific date futures rate in the futures rate data associated with the bank foreign exchange reservation number of the foreign exchange reservation data based on the futures rate data and the foreign exchange reservation data. It is characterized by including this.

[0009] The foreign exchange reservation management program according to the present invention is a foreign exchange reservation management program for causing a foreign exchange reservation management device including a control unit to execute. The foreign exchange reservation management device can access foreign exchange reservation data in which a reservation classification, a currency, a closing bank, a reservation rate, a bank foreign exchange reservation number, a reservation amount, a reserved contract amount, and a settled purchase amount are associated for each foreign exchange reservation serial number. The control unit has an acquisition step of externally acquiring futures rate data in which a reservation amount and a specific date futures rate are associated for each bank foreign exchange reservation number, and based on the futures rate data and the foreign exchange reservation data, acquiring the specific date futures rate in the futures rate data associated with the bank foreign exchange reservation number of the foreign exchange reservation data, and performing a journal entry creation process step of calculating a carryover hedging profit and loss amount for each foreign exchange reservation serial number.

Effect of the Invention

[0010] According to the present invention, there is an effect that the end-of-period processing in foreign exchange reservations can be performed with a simple operation.

Brief Description of the Drawings

[0011]

Figure 1

Figure 2

Figure 3

Figure 4

Figure 5

Figure 6

Figure 7

Figure 8

Figure 9

Figure 10

Figure 11

Figure 12

Figure 13

Figure 14

Figure 15

Figure 16

Figure 17

Figure 18

Figure 19

Figure 20

Figure 21

Figure 22

Figure 23

[0012] Hereinafter, embodiments of the foreign exchange reservation management apparatus, foreign exchange reservation management method, and foreign exchange reservation management program according to the present invention will be described in detail with reference to the drawings. Note that the present invention is not limited to the present embodiment.

[0013] [1. Configuration] An example of the configuration of the foreign exchange reservation management apparatus according to the present embodiment will be described with reference to FIGS. 1 and the like. FIG. 1 is a block diagram showing an example of the configuration of the foreign exchange reservation management apparatus.

[0014] The foreign exchange reservation management device 100 shown in FIG. 1 is a commercially available desktop personal computer. Note that the foreign exchange reservation management device 100 is not limited to a stationary information processing device such as a desktop personal computer, and may be a portable information processing device such as a commercially available notebook personal computer, PDA (Personal Digital Assistants), smartphone, or tablet personal computer.

[0015] The foreign exchange reservation management 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 foreign exchange reservation management device 100 is communicably connected via an arbitrary communication path.

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

[0017] An input device 112 and an output device 114 are connected to the input / output interface unit 108. As the output device 114, in addition to a monitor (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 monitor that cooperates with the mouse to realize a pointing device function can be used. In the following, the output device 114 may be described as the monitor 114, and the input device 112 may be described as the keyboard 112 or the mouse 112.

[0018] The storage unit 106 stores various databases, tables, files, etc. The storage unit 106 records a computer program for giving instructions 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)·ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, and an optical disk can be used. The storage unit 106 stores a basic information master 106a, a corporate tax setting master 106b, a bank master 106c, a currency master 106d, an account master 106e, a journal entry setting master 106f, and a journal entry pattern master 106g.

[0019] The basic information master 106a stores the corporate tax calculation classification associated with the calculation range classification. FIG. 2 is a diagram showing an example of the basic information master table in the basic information master 106a. As shown in FIG. 2, in the first row of the basic information master table T1, the calculation range classification "Exclude sales amount or purchase amount" is associated with the corporate tax calculation classification "Do".

[0020] The corporate tax setting master 106b stores the corporate tax rate. FIG. 3 is a diagram showing an example of the corporate tax setting master table in the corporate tax setting master 106b. As shown in FIG. 3, the corporate tax setting master table T2 stores the corporate tax rate "AA%".

[0021] The bank master 106c stores the bank name associated with the bank code. FIG. 4 is a diagram showing an example of the bank master table in the bank master 106c. As shown in FIG. 4, in the first row of the bank master table T3, the bank code "1" is associated with the bank name "Bank A" and stored.

[0022] The currency master 106d stores the currency name in association with the code. FIG. 5 is a diagram showing an example of the currency master table in the currency master 106d. As shown in FIG. 5, in the first row of the currency master table T4, the currency name "dollar" is recorded in association with the code "1".

[0023] The account master 106e stores the account in association with the code. FIG. 6 is a diagram showing an example of the account master table in the account master 106e. As shown in FIG. 6, in the first row of the account master table T5, the account name "deferred hedge profit and loss" is stored in association with the code "1".

[0024] The journal entry setting master 106f stores the sales / purchase classification and the pattern code in association with the classification. FIG. 7 is a diagram showing an example of the journal entry setting master table in the journal entry setting master 106f. As shown in FIG. 7, in the first row of the journal entry setting master table T6, the sales / purchase classification "sales reservation" and the pattern code "1" are stored in association with the classification "at settlement".

[0025] The journal entry pattern master 106g stores the debit account code and the credit account code in association with the journal entry pattern. FIG. 8 is a diagram showing an example of the journal entry pattern master table in the journal entry pattern master 106g. As shown in FIG. 8, in the first row of the journal entry pattern master table T7, the debit account code "3" and the credit account code "1" are stored in association with the journal entry pattern "1".

[0026] Returning to FIG. 1, the description of the configuration of the foreign exchange reservation management device 100 will be continued. The control unit 102 is a CPU or the like that comprehensively controls the foreign exchange reservation management device 100. The control unit 102 has an internal memory for storing control programs such as the OS, programs defining various processing procedures, and required data, and executes various information processes based on these stored programs. The control unit 102 includes a basic information input unit 102a, a foreign exchange reservation input unit 102b, a contract input unit 102c, an input reception unit 102d, an acquisition unit 102e, and a journal entry creation processing unit 102f.

[0027] The basic information input unit 102a executes basic information input processing for receiving the input of basic information input by the operator via the input device 112.

[0028] The foreign exchange reservation input unit 102b executes foreign exchange reservation input processing for registering foreign exchange reservation information according to the operation content input by the operator via the input device 112.

[0029] The contract input unit 102c displays a contract input screen on the monitor 114 and executes contract input processing for performing contract input according to the operation content input by the operator on the contract input screen via the input device 112.

[0030] The input reception unit 102d generates sales data by performing sales input according to the operation content input by the operator via the input device 112, and executes sales input processing for updating contract reservation data based on this sales data.

[0031] The acquisition unit 102e acquires forward rate data of the company's foreign exchange reservation at a specific date from an affiliated external bank via the communication interface unit 104, the network 300, and the server 200.

[0032] The journal entry creation processing unit 102f executes journal entry creation processing for calculating the carry - forward hedge profit and loss amount for each foreign exchange reservation number by obtaining the specific - date forward rate in the forward rate data associated with the bank foreign exchange reservation number of the foreign exchange reservation data based on the forward rate data acquired by the acquisition unit 102e and the foreign exchange reservation data.

[0033] [2. Foreign Exchange Reservation Management Processing Executed by the Foreign Exchange Reservation Management Device] Next, the foreign exchange reservation management processing executed by the foreign exchange reservation management device 100 will be described. FIG. 9 is a flowchart showing the outline of the foreign exchange reservation management processing executed by the foreign exchange reservation management device 100.

[0034] As shown in FIG. 9, first, the basic information input unit 102a executes a basic information input process for receiving the input of basic information input by the operator via the input device 112 (step S101). FIG. 10 is a diagram showing an example of the basic information received by the basic information input unit 102a in the basic information input process. As shown in the basic information table T10 shown in FIG. 10, the basic information input unit 102a performs input processing for the calculation range classification and the corporate tax calculation classification according to the input content input by the operator via the input device 112. Specifically, as shown in the first row of the basic information table T10 shown in FIG. 10, the basic information input unit 102a inputs and stores "yes" for the corporate tax calculation classification in the calculation range classification "excluding sales amount or purchase amount". Similarly, as shown in the second row of the basic information table T10 shown in FIG. 10, the basic information input unit 102a inputs and stores "no" for the corporate tax calculation classification in the calculation range classification "excluding the contracted amount".

[0035] Subsequently, the foreign exchange reservation input unit 102b executes a foreign exchange reservation input process for registering foreign exchange reservation information according to the operation content input by the operator via the input device 112 (step S102). FIG. 11 is a diagram showing an example of the foreign exchange reservation information registered by the foreign exchange reservation input unit 102b in the foreign exchange reservation input process. As shown in the foreign exchange reservation information table T11 shown in FIG. 11, the foreign exchange reservation input unit 102b generates foreign exchange reservation data in which the foreign exchange reservation serial number, reservation classification, currency, contracting bank, reservation rate, bank foreign exchange reservation number, reservation amount, contract provision made, sales / purchases completed, and specific date futures rate are associated according to the operation content input by the operator via the input device 112, and registers (stores) it in the storage unit 106. Specifically, in the first row of the foreign exchange reservation information table T11, it is generated in association with the foreign exchange reservation serial number "KW001", the reservation classification "sell reservation", the currency "dollar", the contracting bank "Bank A", the reservation rate "130", the bank foreign exchange reservation number "AA001", the reservation amount "10,000", the contract provision made "0", the sales / purchases completed "0", and the specific date futures rate "0". Hereinafter, "sales / purchases completed" refers to either sales completed or purchases completed.

[0036] After that, the contract input unit 102c displays a contract input screen on the monitor 114, and executes a contract input process for performing contract input according to the operation content input by the operator on the contract input screen via the input device 112 (step S103).

[0037] FIG. 12 is a diagram showing an example of a contract input screen displayed on the monitor 114. The contract input screen P1 shown in FIG. 12 includes an input cell O1 for inputting a contract date and a contract destination, a fee / item input cell K1 for inputting a fee / item, and a foreign exchange reservation appropriation cell K2 for inputting a foreign exchange reservation appropriation. The operator selectively inputs desired information into each of the input cell O1, the fee / item input cell K1, and the foreign exchange reservation appropriation cell K2 via the input device 112. For example, the operator inputs "2023 / 04 / 01" as the contract date and "KS001" as the contract destination into the input cell O1 via the input device 112, and inputs "HM001" as the fee, "Product A" as the product, "2,000" as the contract amount, and "Dollar" as the currency into the fee / item input cell K1. Further, the operator inputs "KW001" as the foreign exchange reservation serial number, "5,000" as the appropriation amount, and "Dollar" as the currency into the foreign exchange reservation appropriation cell K2. After that, when the operator presses a registration button (not shown) for registering the contract content input on the contract input screen P1 via the input device 112, the contract input unit 102c inputs and updates the appropriation amount in the appropriated cell of the foreign exchange contract data associated with the foreign exchange reservation serial number input in the foreign exchange reservation appropriation cell K2, and creates contract data according to the content input on the contract input screen P1.

[0038] FIG. 13 is a diagram showing an example of the foreign exchange reservation data updated by the contract input unit 102c. As shown in the first row of the foreign exchange reservation data table T12 shown in FIG. 13, the contract input unit 102c inputs and updates the appropriation amount "5,000" of the foreign exchange reservation appropriation cell K2 in the appropriated cell of the contract reservation serial number "KW001" in the foreign exchange contract data associated with the foreign exchange reservation serial number "KW001" input in the foreign exchange reservation appropriation cell K2. In FIG. 13, hatching is used to emphasize the updated part.

[0039] FIG. 14 is a diagram showing an example of contract data created by the contract input unit 102c. As shown in the contract data table T13 in FIG. 14, the contract input unit 102c creates contract data in which a contract number is associated with a contract date, a product code, a product name, a contract amount, a currency, and a foreign exchange reservation appropriation according to the input contents entered in the input cell O1 and the item / category product input cell K1. Specifically, in the first row of the contract data table T13, the contract number "KEI001" is associated with the contract date "2023 / 4 / 1", the product code "HM001", the product name "Product A", the contract amount "2,000", the currency "dollar", and the foreign exchange reservation appropriation "KW001" and stored.

[0040] Returning to FIG. 9, the description after step S104 will be continued. In step S104, the input reception unit 102d executes an input reception process of generating sales data or purchase data by receiving an input of a sales amount or a purchase amount according to the operation content input by the operator via the input device 112, and updating the contract reservation data based on this sales data or purchase data.

[0041] FIG. 15 is a diagram showing an example of sales data generated by the input reception unit 102d and associated with a foreign exchange reservation number linked from the contract number. FIG. 16 is a diagram showing an example of sales data generated by the input reception unit 102d and directly associated with a foreign exchange reservation without going through a contract.

[0042] As shown in the sales data table T14 of FIG. 15 and the sales data table T15 of FIG. 16, the input reception unit 102d generates sales data in which a row, a sales date, a billing destination, a contract number, and a sales amount are associated with a sales number according to the operation content input by the operator via the input device 112. In this case, in the first row of the sales data table T14, the sales number "UR0001" is associated with the row "1", the sales date "2023 / 05 / 01", the billing destination "KS001: □△ Industry", the contract number "KEI001", and the sales amount "5,000" and stored. Also, in the first row of the sales data table T15 of FIG. 16, the sales number "UR0002" is associated with the row "1", the sales date "2023 / 05 / 01", the billing destination "KS001: □△ Industry", and the sales amount "10,000 euros" and stored.

[0043] FIG. 17 is a diagram showing an example of the foreign exchange reservation data updated by the input reception unit 102d. As shown in the first row of the foreign exchange reservation data table T16 shown in FIG. 17, the input reception unit 102d inputs and updates the sales amount "5,000" in the sales purchase completed cell of the foreign exchange reservation data associated with the contract number of the sales data table T14. Further, as shown in the third row of the foreign exchange reservation data table T16 shown in FIG. 17, the input reception unit 102d inputs and updates the sales amount "10,000" in the sales purchase completed cell of the foreign exchange reservation data associated with the foreign exchange reservation serial number of the sales data table T15. In FIGS. 16 to 17, the input reception process of the sales data by the input reception unit 102d has been described. However, since the same process applies to the purchase data, detailed description is omitted.

[0044] Returning to FIG. 9, the description after step S105 will be continued. In step S105, the acquisition unit 102e acquires the forward rate data of the company's foreign exchange reservation at a specific date from an external bank that partners via the communication interface unit 104, the network 300, and the server 200. FIG. 18 is a diagram showing an example of a forward rate data table in the forward rate data. As shown in FIG. 18, in the forward rate data table T17, the bank foreign exchange reservation number is associated with the reserved amount and the specific date forward rate and stored. Specifically, in the first row of the forward rate data table T17, the bank foreign exchange reservation number "AA0001" is associated with the reserved amount "10,000" and the specific date forward rate "135" and stored.

[0045] Subsequently, the journal entry creation processing unit 102f executes journal entry creation processing for calculating the carry - forward hedge profit and loss amount for each foreign exchange reservation number by acquiring the specific date forward rate in the forward rate data associated with the bank foreign exchange reservation number of the foreign exchange reservation data based on the forward rate data acquired by the acquisition unit 102e and the foreign exchange reservation data (step S106). After step S106, the foreign exchange reservation management device 100 ends this process.

[0046] FIG. 19 is a diagram schematically illustrating a method for calculating the carry hedge profit and loss amount in the journal entry creation process by the journal entry creation processing unit 102f. First, as shown in FIG. 19, the journal entry creation processing unit 102f, based on the forward rate data table T17 acquired by the acquisition unit 102e and the foreign exchange reservation data table T16 updated by the input reception unit 102d (see FIG. 17), acquires the specific date forward rate in the forward rate data associated with the bank foreign exchange reservation number of the foreign exchange reservation data and updates the foreign exchange reservation data table T18. Specifically, as shown in the first row of the foreign exchange reservation data table T18, the journal entry creation processing unit 102f acquires the specific date forward rate "135" in the forward rate data table T17 for the bank foreign exchange reservation number "AA001" associated with the bank foreign exchange reservation number "AA001" of the foreign exchange reservation data table T18 and inputs "135" into the specific date forward rate cell of the foreign exchange reservation data table T18 for update. Similarly, the journal entry creation processing unit 102f acquires the specific date forward rate in the forward rate data associated with the bank foreign exchange reservation number of the foreign exchange reservation data and updates the specific date forward rate for each bank foreign exchange reservation number in the foreign exchange reservation data table T18.

[0047] Next, a calculation method for the journal entry creation processing unit 102f to calculate the carry hedge profit and loss amount for each foreign exchange reservation number will be described. First, the case where "excluding sales amount or purchase amount" is set in the basic information of the basic information input process of step S101 described above will be described. In this case, when the sold and purchased cell is sales data, the journal entry creation processing unit 102f calculates the carry hedge profit and loss amount by the following formula (1). (Reserved amount - Amount already sold) × (Specific date forward rate - Reserved rate) = Carry hedge profit and loss amount ···(1) Specifically, in the case of the foreign exchange reservation serial number "KW001", the journal entry creation processing unit 102f calculates as follows because the reserved amount is "10,000", the amount already sold and purchased is "5,000", the specific date forward rate is "135", and the reserved rate is "130". (10,000 - 5,000) × (135 - 130) = 25,000 yen Also, the journal entry creation processing unit 102f calculates as follows in the case of the foreign exchange reservation serial number "KW002" as well. (20,000 - 0) × (132 - 131) = 20,000 yen Furthermore, the journal entry creation processing unit 102f calculates as follows in the case of the foreign exchange reservation serial number "KW0013" as well. (30,000 - 10,000) × (135 - 132) = 60,000 yen

[0048] In this way, when "exclude the allocated amount of sales amount or purchase amount" (exclude the sales amount or purchase amount) is set in the basic information of the basic information input processing of step S101 described above, the journal entry creation processing unit 102f uses the above (1) to calculate the deferred hedge profit and loss amount for each foreign exchange reservation number. Note that whether the amount of the calculation result of the deferred hedge profit and loss amount is positive or negative is determined by the comparison between the reserved rate and the specific date futures rate. Also, in the above description, the journal entry creation processing unit 102f explained the case where the sold and purchased cell is sales data. In the case of purchase data, the sold-out in formula (1) becomes the purchased-out. Specifically, the deferred hedge profit and loss amount is calculated by the following formula (1-1). (Reserved amount - Purchased-out) × (Specific date futures rate - Reserved rate) = Deferred hedge profit and loss amount ···(1-1)

[0049] Next, the case where "exclude the allocated amount of sales amount or purchase amount" is not set in the basic information of the basic information input processing of step S101 described above will be explained. In this case, the journal entry creation processing unit 102f calculates the deferred hedge profit and loss amount by the following formula (2). Reserved amount × (Specific date futures rate - Reserved rate) = Deferred hedge profit and loss amount ···(2)

[0050] Furthermore, when "excluding the allocated amount of sales amount or purchase amount" is set in the basic information of the basic information input process in step S101 described above, and "excluding the contract amount" is set, it will be described. In this case, when the cell with sales / purchases completed is sales data, the journal entry creation processing unit 102f calculates the deferred hedging profit and loss amount according to the following formula (3). (Reserved amount - Completed sales - Allocated contract amount) × (Specific date futures rate - Reserved rate) = Deferred hedging profit and loss amount ···(3) Note that in the above description, the journal entry creation processing unit 102f described the case where the cell with sales / purchases completed is sales data. However, in the case of purchase data, the completed sales in formula (3) becomes completed purchases. Specifically, the deferred hedging profit and loss amount is calculated according to the following formula (3-1). (Reserved amount - Completed purchases - Allocated contract amount) × (Specific date futures rate - Reserved rate) = Deferred hedging profit and loss amount ···(3-1)

[0051] Note that the above-described journal entry creation processing unit 102f is in a form of only deducting the completed sales amount or completed purchase amount in the case of the general allocation method concept. However, considering the future potential and versatility such as the business scope of each company in the future, the operator can appropriately do so in the basic information master 106a.

[0052] Next, the content of the journal entry creation processing unit 102f creating a journal entry using the calculation result of the deferred hedging profit and loss amount will be described. Each of FIGS. 20 to 23 is a diagram showing an example of a journal entry created by the journal entry creation processing unit 102f using the calculation result of the deferred hedging profit and loss amount. The journal entry creation processing unit 102f creates journal entries D1 to D4 shown in each of FIGS. 20 to 23. Note that the debit and credit are determined by whether it is a sales reservation or a purchase reservation, and whether it is plus or minus. Furthermore, the foreign exchange reservation management device 100 links journal entries D1 to D4 to the financial system. Thereby, the operator can perform the end-of-period processing in the foreign exchange reservation with a simple operation.

[0053] Note that the journal entry creation processing unit 102f creates journal entries D1 to D in the forms shown in FIGS. 20 to 23. However, it can freely create journal entries according to the following condition settings selected according to the operation content of the input device 112 by the operator with reference to the basic information master 106a, the corporate tax setting master 106b, the bank master 106c, the currency master 106d, the account master 106e, the journal entry setting master 106f, and the journal entry pattern master 106g. Specifically, the following information is whether the foreign exchange reservation is a sell reservation or a buy reservation, and whether it is a journal entry on a specific date or a journal entry on the next day. Each of the journal entries D1 in FIG. 20 and D3 in FIG. 22 is a specific date, and each of the journal entries D2 in FIG. 21 and D4 in FIG. 23 is the day after the specific date (the reverse journal entry of each of the journal entries D1 in FIG. 20 and D3 in FIG. 22).

[0054] Also, in the basic information setting process in step S101 described above, when the basic information is that the "corporate tax calculation classification" is "do", the tax liability is calculated by multiplying the above deferred hedging profit and loss by the tax rate set in the corporate tax setting master 106b.

[0055] According to the embodiment described above, based on the forward rate data acquired by the acquisition unit 102e by the journal entry creation processing unit 102f and the foreign exchange reservation data, the specific date forward rate in the forward rate data associated with the bank foreign exchange reservation number of the foreign exchange reservation data is acquired, and the deferred hedging profit and loss amount is calculated for each foreign exchange reservation number. Therefore, the final processing at the settlement time in the foreign exchange reservation can be performed with a simple operation, and the labor saving of the search work can be achieved.

[0056] Also, according to the embodiment, since the journal entry creation processing unit 102f calculates, for each foreign exchange reservation serial number, at least the amount obtained by multiplying the reserved amount by the difference between the reserved rate and the specific date forward rate for each foreign exchange reservation serial number as the deferred hedging profit and loss amount, the accuracy of the deferred hedging profit and loss amount at the settlement time can be improved, the work at the settlement processing time can be speeded up, and the early settlement can be achieved.

[0057] Further, according to the embodiment, when the calculation range classification is set to exclude the allocated amount of sales or purchases based on the basic information input by the journal creation processing unit 102f through the basic information input unit 102a, in order to calculate, as the deferred hedge profit and loss amount, the amount obtained by multiplying the difference between the forward exchange rate and the specific date futures rate by the value obtained by subtracting the amount of sales or purchases already made from the reserved amount in the forward exchange reservation data, it is possible to calculate the deferred hedge profit and loss amount after subtracting the amount of sales and purchases already made.

[0058] Further, according to the embodiment, when the calculation range classification is not set to exclude the allocated amount of sales or purchases based on the basic information input by the journal creation processing unit 102f through the basic information input unit 102a, in order to calculate, as the deferred hedge profit and loss amount, the amount obtained by multiplying the difference between the forward exchange rate for each forward exchange serial number and the specific date futures rate by the reserved amount, it is possible to calculate the deferred hedge profit and loss amount excluding the allocated amount with a simple operation.

[0059] Further, according to the embodiment, when the calculation range classification is set to exclude the allocated amount of sales or purchases and is also set to exclude the contract amount based on the basic information input by the journal creation processing unit 102f through the basic information input unit 102a, in order to calculate, as the deferred hedge profit and loss amount, the amount obtained by multiplying the difference between the forward exchange rate and the specific date futures rate by the value obtained by subtracting the amount of sales or purchases already made and the amount of reserved contracts already made from the reserved amount in the forward exchange reservation data, it is possible to calculate the deferred hedge profit and loss amount after subtracting the amount of sales or purchases already made and the amount of reserved contracts already made with a simple operation.

[0060] Further, according to the embodiment, since the journal creation processing unit 102f refers to the account master 106e, the journal setting master 106f, and the journal pattern master 106g and creates a journal using the deferred hedge profit and loss amount, it is possible to create a reversal journal in the carry-over method with a simple operation. The work during the closing process can be speeded up, and the closing can be advanced.

[0061] Also, according to the embodiment, when the classification for corporate tax calculation is set based on the basic information input by the basic information input unit 102a, the journal creation processing unit 102f refers to the corporate tax setting master 106b and multiplies the deferred hedge profit and loss amount by the corporate tax rate to create a journal. Therefore, a journal obtained by multiplying the deferred hedge profit and loss amount by the corporate tax rate can be created, enabling the acceleration of work during the settlement process and the early completion of the settlement.

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

[0063] Also, 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.

[0064] Also, 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.

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

[0066] 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 or part of the processes described as being manually performed can be automatically performed by a known method.

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

[0068] Further, regarding the foreign exchange reservation management device 100, each illustrated component is functionally conceptual and does not necessarily have to be physically configured as illustrated.

[0069] For example, regarding the processing functions provided by the foreign exchange reservation management device 100, particularly each processing function performed by the control unit, all or any part of them may be realized by a CPU and a program interpreted and executed by the CPU, or may be realized as hardware by wired logic. The program is recorded on a non-transitory computer-readable recording medium including programmed instructions for causing an information processing device to execute the processing described in the present embodiment, and is mechanically read by the foreign exchange reservation management 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.

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

[0071] Also, the program for executing the processes described in this 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.

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

[0073] The various databases and the like stored in the storage unit 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.

[0074] Further, the foreign exchange reservation management device 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device to which an arbitrary peripheral device is connected. Further, the foreign exchange reservation management device 100 may be realized by installing software (including a program or data, etc.) for realizing the processing described in the present embodiment in the device.

[0075] 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 functional load. That is, the above-described embodiments may be arbitrarily combined and implemented, or the embodiments may be selectively implemented.

Industrial Applicability

[0076] The present invention is useful in industries that perform foreign exchange reservations, for example, in industries of all enterprises such as trading companies that conduct trading business.

Explanation of Signs

[0077] 100 Foreign exchange reservation management device 102 Control unit 102a Basic information input unit 102b Foreign exchange reservation input unit 102c Contract input unit 102d Input reception unit 102e Acquisition unit 102f Journal creation processing unit 104 Communication interface unit 106 Storage unit 106a Basic information master 106b Corporation tax setting master 106c Bank master 106d Currency master 106e Subject master 106f Journal setting master 106g Journal pattern master 108 Input / output interface unit 112 Input device 114 Output device 200 Server 300 Network

Claims

1. A foreign exchange reservation management device including a control unit, For each foreign exchange reservation serial number, foreign exchange reservation data associating reservation category, currency, closing bank, reservation rate, bank foreign exchange reservation number, reservation amount, contract provision paid, and sales and purchases settled, Is accessible to, The control unit, An acquisition unit that acquires from the outside futures rate data associating a reservation amount and a specific date futures rate for each of the bank foreign exchange reservation numbers; Based on the futures rate data and the foreign exchange reservation data, a journal entry creation processing unit that acquires the specific date futures rate in the futures rate data associated with the bank foreign exchange reservation number of the foreign exchange reservation data and calculates the deferred hedge profit and loss amount for each foreign exchange reservation serial number; Comprising A foreign exchange reservation management device characterized by the above.

2. The foreign exchange reservation management device according to claim 1, The journal entry creation processing unit, For each foreign exchange reservation serial number, calculates, as the deferred hedge profit and loss amount, an amount obtained by multiplying at least the reservation amount by the difference between the reservation rate and the specific date futures rate for each foreign exchange reservation serial number. A foreign exchange reservation management device characterized by the above.

3. The foreign exchange reservation management device according to claim 2, The control unit, A basic information input unit that receives an input of basic information associating a calculation range classification and a corporate tax calculation classification with the deferred hedge profit and loss amount; Further comprising The journal entry creation processing unit, Based on the basic information, when the calculation range classification is set to exclude the allocated amount of sales or purchases, calculates, as the deferred hedge profit and loss amount, an amount obtained by multiplying the value obtained by subtracting the amount of sales and purchases settled from the reservation amount in the foreign exchange reservation data by the difference between the reservation rate and the specific date futures rate. A foreign exchange reservation management device characterized by the above.

4. The foreign exchange reservation management device according to claim 3, The journal entry creation processing unit, Based on the basic information, when the calculation range classification is not set to exclude the allocated amount of sales or purchases, calculates, as the deferred hedge profit and loss amount, an amount obtained by multiplying the reservation amount by the difference between the reservation rate and the specific date futures rate for each foreign exchange reservation serial number. A foreign exchange reservation management device characterized by the above.

5. The foreign exchange reservation management device according to claim 4, The journal entry creation processing unit, Based on the basic information, when the calculation range classification is set to exclude the allocated amount of sales or purchases and is also set to exclude the contract amount, for the reserved amount in the foreign exchange reservation data, the amount obtained by multiplying the difference between the reserved rate and the specific date futures rate by the value obtained by subtracting the amounts of completed sales and purchases and completed contract provisions from the reserved amount is calculated as the deferred hedge profit and loss amount. A foreign exchange reservation management device characterized by the above.

6. The foreign exchange reservation management device according to claim 5, A subject master that associates a subject name with a code, A journal entry setting master that associates a buying / selling classification and a pattern code with a classification, A journal entry pattern master that associates a debit subject code and a credit subject code with a journal entry pattern, is further accessible to, The journal entry creation processing unit, refers to the subject master, the journal entry setting master, and the journal entry pattern master, and creates a journal entry using the deferred hedge profit and loss amount. A foreign exchange reservation management device characterized by the above.

7. The foreign exchange reservation management device according to claim 6, A corporate tax setting master in which the corporate tax rate is set, is further accessible to, The journal entry creation processing unit, based on the basic information, when the corporate tax calculation classification is set, refers to the corporate tax setting master, multiplies the deferred hedge profit and loss amount by the corporate tax rate, and creates the journal entry. A foreign exchange reservation management device characterized by the above.

8. The foreign exchange reservation management device according to claim 7, Sales data that associates a sales amount with the contract number associated with the foreign exchange reservation serial number in the foreign exchange reservation data, purchase data that associates a purchase amount with the contract number associated with the foreign exchange reservation serial number in the foreign exchange reservation data, either one or more inputs of the sales data directly linked to the foreign exchange reservation serial number in the foreign exchange reservation data from the sales amount and the purchase data directly linked to the foreign exchange reservation serial number in the foreign exchange reservation data from the purchase amount, an input reception unit that receives an input, in response to an external operation. further comprising A foreign exchange reservation management device characterized by the above.

9. A foreign exchange reservation management method executed by a foreign exchange reservation management device including a control unit, The foreign exchange reservation management device, For each foreign exchange reservation serial number, foreign exchange reservation data that associates a reservation classification, currency, closing bank, reserved rate, bank foreign exchange reservation number, reserved amount, completed contract provisions, and completed sales and purchases, is accessible to, executed by the control unit, An acquisition step of acquiring from the outside futures rate data in which a reserved amount and a specific date futures rate are associated for each of the bank exchange reservation numbers; A journal entry creation processing step of calculating a carry-over hedge profit and loss amount for each exchange reservation serial number by acquiring the specific date futures rate in the futures rate data associated with the bank exchange reservation number in the exchange reservation data based on the futures rate data and the exchange reservation data; Including; An exchange reservation management method characterized by the above.

10. An exchange reservation management program for causing an exchange reservation management device including a control unit to execute, The exchange reservation management device, For each exchange reservation serial number, exchange reservation data in which a reservation classification, currency, closing bank, reservation rate, bank exchange reservation number, reserved amount, contract provision paid, and sales purchase paid are associated, Is accessible to, To the control unit, An acquisition step of acquiring from the outside futures rate data in which a reserved amount and a specific date futures rate are associated for each of the bank exchange reservation numbers; A journal entry creation processing step of calculating a carry-over hedge profit and loss amount for each exchange reservation serial number by acquiring the specific date futures rate in the futures rate data associated with the bank exchange reservation number in the exchange reservation data based on the futures rate data and the exchange reservation data; To execute, An exchange reservation management program characterized by the above.

Images