JP7445713B2 - Allocation work support device, allocation work support method, and allocation work support program - Google Patents

Description

The present invention relates to an allocation task support device, an allocation task support method, and an allocation task support program.

Patent Document 1 discloses a new management accounting system and a new management accounting implementation method that can accurately grasp the profit and loss situation of each business division in a company (see paragraph 0001 of Patent Document 1), In addition, regarding the calculation of sales, with regard to transactions denominated in foreign currencies, depending on the timing of exchange transactions and allocation rules, there may be a biased impact on specific units, so in order to eliminate the influence of exchange rates, It is disclosed that by storing the management accounting exchange rate in the exchange information storage unit 22 for converting foreign currency-denominated transactions and reflecting it in the JVA calculation, it is possible to reduce such influence and grasp operating profit and loss closer to the actual situation. (See paragraph 0059 of Patent Document 1).

JP2006-107227A

In the field of foreign currency transactions like this, the desired amount of foreign currency is purchased in advance at the desired reservation rate (so-called foreign exchange contract), and when entering sales in foreign currency later, the entered sales amount is exchanged. It is common practice to allocate money to the amount reserved.

However, in the past, although it was possible to allocate the sales amount to one exchange reservation amount, it was not possible to allocate the sales amount to multiple exchange reservation amounts. For example, if you have made separate foreign exchange reservations for $10,000 and $20,000 in advance, you may want to allocate the sales amount of $10,000 only to the foreign exchange reservation of $10,000, or allocate the sales amount of $10,000 only to the foreign exchange reservation of $20,000. Previously, it was possible to allocate the sales amount to $10,000, but now $6,000 of the $10,000 sales amount will be allocated to the $10,000 foreign exchange forwarded amount, and the remaining sales amount of $4,000 will be allocated to the foreign exchange forwarded amount of $20,000. I couldn't. For this reason, there was a problem in that the allocation work lacked flexibility.

The present invention has been made in view of the above-mentioned problems, and includes an allocation operation support device, an allocation operation support method, and an allocation operation support device capable of supporting allocation operation so as to allocate a foreign currency amount to a plurality of exchange reservation amounts. The purpose is to provide an allocation business support program.

In order to solve the above-mentioned problems and achieve the purpose, an allocation business support device according to the present invention is an allocation business support device that includes a control section and a display section, and wherein the control section controls foreign currency exchange reservations. an acquisition means for acquiring exchange reservation detail data that matches an acquisition condition for acquiring the exchange reservation detail data from exchange reservation data including a plurality of exchange reservation detail data having a foreign exchange reservation amount that is an amount; display execution means for displaying on the display section the exchange reservation amount that the acquired exchange reservation detail data has and an allocation area that is an area for allocating the input foreign currency amount to the exchange reservation amount; It is characterized by comprising the following.

Further, in the allocation business support device according to the present invention, the foreign exchange reservation detail data further includes a rate at the time of reservation, which is a rate used for converting foreign currency into Japanese currency, and is the rate at the time of the foreign currency reservation, and the The present invention is characterized in that the display execution means further displays the reservation rate included in the foreign exchange reservation details data acquired by the acquisition means on the display section.

Further, in the allocation business support device according to the present invention, the exchange reservation detail data includes currency identification data for identifying the type of currency for the foreign currency amount and a period during which the input foreign currency amount is to be collected. The acquisition means includes currency identification data input as the acquisition condition from the foreign exchange reservation data, and the collection period is the scheduled collection date input as the acquisition condition. The present invention is characterized in that exchange reservation detail data including the collection target period to which a certain scheduled collection date belongs is acquired.

Further, in the allocation business support device according to the present invention, the control unit calculates a Japanese currency amount calculated by multiplying the foreign currency amount allocated to the rate at the time of reservation included in the foreign exchange reservation details data acquired by the acquisition means. The present invention is characterized by further comprising average rate calculation means for calculating an average rate by dividing the total amount by the input foreign currency amount.

Further, in the allocation business support device according to the present invention, the control unit calculates a Japanese currency amount calculated by multiplying the foreign currency amount allocated to the rate at the time of reservation included in the foreign exchange reservation detail data acquired by the acquisition means. , the spot rate, which is the rate used to convert foreign currency into Japanese currency and is used for spot transactions, is multiplied by the foreign currency amount obtained by subtracting the total amount of the allocated foreign currency amount from the foreign currency amount inputted above. The apparatus is characterized by further comprising an average rate calculation means for calculating an average rate by dividing the total amount of the Japanese currency amount calculated by the input foreign currency amount.

Further, in the allocation business support device according to the present invention, the exchange reservation details data further includes an allocated amount of the exchange reservation that is the exchange reservation amount for which the allocation has been completed, and the control unit It further comprises updating means for updating the foreign exchange reservation detail data as the foreign exchange reservation allocated amount with the cumulative amount of the foreign currency amount allocated to the foreign exchange reservation as the foreign exchange reservation allocated amount, and the display execution means updates the foreign exchange reservation allocated amount updated by the updating means. It is characterized by displaying on the display section.

Further, in the allocation business support device according to the present invention, the control unit outputs a warning when the allocated foreign currency amount is larger than the amount obtained by subtracting the exchange reservation allocated amount from the exchange reservation amount. The present invention is characterized by further comprising a warning output means.

Further, in the allocation business support device according to the present invention, the input foreign currency amount is a sales amount in foreign currency, and the control section adds the average rate calculated by the average rate calculation means to the sales amount. The present invention is characterized by further comprising profit and loss calculation means for calculating foreign exchange profit and loss by subtracting from the multiplied value a value obtained by multiplying the deposit amount in foreign currency for the sales amount by the rate at the time of deposit of the deposit amount.

Further, the allocation business support method according to the present invention is an allocation business support method executed by an information processing device including a control unit and a display unit, wherein the allocation business support method is executed by the control unit in a foreign currency amount booked for exchange. an acquisition step of acquiring exchange reservation detail data that matches acquisition conditions for acquiring the exchange reservation detail data from exchange reservation data including a plurality of exchange reservation detail data having a certain exchange reservation amount; and a display execution step of displaying on the display section the exchange reservation amount included in the exchange reservation detail data and an allocation area that is an area for allocating the input foreign currency amount to the exchange reservation amount; It is characterized by including.

Further, the allocation business support program according to the present invention is an allocation business support program to be executed by an information processing device including a control unit and a display unit, and the allocation business support program is to cause the control unit to execute foreign exchange reservations. an acquisition step of acquiring exchange reservation detail data that matches an acquisition condition for acquiring the exchange reservation detail data from exchange reservation data including a plurality of exchange reservation detail data having an exchange reservation amount that is an amount; a display execution step of displaying on the display section the exchange reservation amount that the acquired exchange reservation detail data has and an allocation area that is an area for allocating the input foreign currency amount to the exchange reservation amount; It is characterized by including.

According to the present invention, it is possible to support an allocation operation so that a foreign currency amount can be allocated to a plurality of exchange reservation amounts.

FIG. 1 is a block diagram showing an example of the configuration of an allocation task support device. FIG. 2 is a diagram showing an example of exchange reservation data. FIG. 3 is a diagram showing an example of a sales input screen before the allocation of foreign exchange contracts. FIG. 4 is a diagram showing an example of a foreign exchange reservation allocation screen. FIG. 5 is a diagram showing an example of a sales input screen after allocating foreign exchange contracts. FIG. 6 is a diagram showing an example of sales data, collection schedule data, and updated exchange reservation data. FIG. 7 is a diagram showing an example of allocation of foreign exchange reservation 1:account slip N. FIG. 8 is a diagram showing an example of allocation of foreign exchange reservation N:accounting slip 1. FIG. 9 is a diagram showing an example of allocation of foreign exchange reservation N:accounting slip M. FIG. 10 is a diagram showing an example of a currency master, a rate classification master, and a rate master.

Embodiments of an allocation work support device, an allocation work support method, and an allocation work support program will be described in detail below based on the drawings. Note that the present invention is not limited to this embodiment.

[1. overview]
In the field of foreign currency transactions, the method of managing foreign exchange contracts differs depending on the company, and foreign exchange contracts are not always managed for each transaction, and the amount of a foreign exchange contract does not necessarily match the transaction amount.

Here, in the past, it was necessary to register separate slips so that the exchange contract and transaction had a 1:1 relationship, so the exchange contract amount and transaction amount did not match as described in the previous paragraph. There was a problem that it was not possible to respond to the situation.

Furthermore, in the past, calculating the average rate of multiple exchange rates with different exchange rates and converting into Japanese currency had to be done outside the system, resulting in high calculation costs and problems in reducing payment risk. .

Therefore, in this embodiment, a function is implemented in which, for example, a plurality of foreign exchange reservations with different rates are allocated to each transaction, and the average rate can be calculated and Japanese currency conversion can be performed within the system. Furthermore, in this embodiment, a function is implemented in which, for example, if the transaction amount is not full even after the exchange reservation is allocated, the balance of the transaction amount can be converted into Japanese currency using the spot rate. The average rate can be calculated by also taking the spot rate into consideration.

By implementing the above functions, in this embodiment, for example, it is possible to use a mixture of multiple exchange rates and spot rates, which makes the conversion of transactions into Japanese currency more accurate and the numerical reflection in accounting. Accuracy can be improved. In addition, the above functions are more suitable for on-site practice and have high versatility, so that, for example, management outside the system can be reduced and business efficiency can be improved. The specific configuration and operation will be described below.

[2. composition]
An example of the configuration of the allocation work support device 100 according to the present embodiment will be described with reference to FIG. 1. FIG. 1 is a block diagram showing an example of the configuration of the allocation work support device 100.

The allocation work support device 100 is a commercially available desktop personal computer. Note that the allocation work support device 100 is not limited to a stationary information processing device such as a desktop personal computer, but can also be used for commercially available notebook personal computers, PDAs (Personal Digital Assistants), smartphones, tablet personal computers, etc. It may also be a portable information processing device.

The allocation work support device 100 includes a control section 102, a communication interface section 104, a storage section 106, and an input/output interface section 108. Each unit included in the allocation work support device 100 is communicably connected via an arbitrary communication path.

The communication interface unit 104 communicably connects the allocation work support 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 connecting the allocation work support device 100 and the server 200 so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network). Note that data such as various masters, which will be described later, may be stored in the server 200, for example.

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. Note that in the following description, the output device 114 may be referred to as a monitor 114, and the input device 112 may be referred to as a keyboard 112 or a mouse 112.

The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 stores a computer program for providing instructions to a CPU (Central Processing Unit) to perform various processes in cooperation with an OS (Operating System). 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, an optical disk, etc. can be used.

The storage unit 106 includes exchange reservation data 106a, sales data 106b, collection schedule data 106c, currency master 106d, rate classification master 106e, and rate master 106f.

According to the allocation business support device 100 according to the present embodiment, the exchange reservation amount is the foreign currency amount for which the exchange reservation has been made, and the allocation area is an area for allocating the input foreign currency amount to the exchange reservation amount. By displaying , on the display unit, it is possible to support the allocation work performed by the operator. The input foreign currency amount is, for example, the sales amount in foreign currency or the purchase amount in foreign currency, but in the following explanation, it is assumed that the input amount is the sales amount in foreign currency.

As shown in FIG. 2, the exchange reservation data 106a includes a plurality of exchange reservation detail data (referring to information in one horizontal line in the exchange reservation data 106a in FIG. 2). As shown in FIG. 2, the exchange reservation details data includes, for example, exchange reservation identification data (exchange reservation number) for identifying each exchange reservation, and currency identification data for identifying the type of currency for the foreign currency amount. (currency), the exchange reservation amount (exchange reservation amount), which is the foreign currency amount for which the exchange reservation was made, the rate at the time of the exchange reservation, which is the rate used to convert foreign currency into Japanese currency, and the rate at the time of the exchange reservation; The amount of foreign exchange reservation allocated (allocated amount of foreign exchange reservation), which is the amount of the foreign exchange reservation that has been won, the date of the foreign exchange reservation (reservation date), and the period during which the foreign currency amount inputted above is to be collected. This includes the collection period (period from the start date to the end date).

As shown in FIG. 6, the sales data 106b includes, for example, sales identification data (sales number) for identifying each sale, billing party identification data (billing party) for identifying a billing party, and customer identification data. customer identification data (customer), scheduled collection date (scheduled collection date) that is the scheduled date of collection of the foreign currency amount entered above, currency identification data (currency), average rate (rate), Japanese currency sales amount in foreign currency (sales amount on slips), consumption tax amount on sales amount in the relevant Japanese currency (sales amount on slips), sales amount in foreign currency (sales amount on foreign currency slips), and consumption tax amount on sales amount in the foreign currency (sales amount on foreign currency slips) tax amount), etc.

As shown in FIG. 6, the collection schedule data 106c includes, for example, collection schedule identification data (slip number) for identifying each collection schedule, the billing party identification data (billing party), and the customer identification data (customer identification data). ), the scheduled collection date (scheduled collection date), the currency identification data (currency), the average rate (rate), the scheduled collection amount in Japanese currency (scheduled collection amount), and the scheduled collection amount in foreign currency (scheduled collection amount in foreign currency) ) etc.

As shown in FIG. 10, the currency master 106d includes, for example, the currency identification data (currency code and currency name), rate identification data (initial rate classification) for identifying the type of rate, and the like.

As shown in FIG. 10, the rate classification master 106e includes, for example, the rate identification data (rate classification and rate name). As shown in FIG. 10, specific examples of the rate names include standard rate, TTB rate (Telegraphic Transfer Buying rate), TTS rate (Telegraphic Transfer Selling rate), and spot rate. The spot rate is a spot rate that is used for converting foreign currency into Japanese currency and is used for spot transactions.

As shown in FIG. 10, the rate master 106f includes, for example, the currency identification data (currency code), the rate identification data (rate classification), rates, and the like.

The control unit 102 is a CPU or the like that controls the allocation work support device 100 in an integrated manner. The control unit 102 has an internal memory for storing control programs such as an OS, programs specifying various processing procedures, required data, etc., and performs various information processing based on these stored programs. Execute.

Functionally, the control unit 102 has, for example, (1) an acquisition process for acquiring exchange reservation detail data from exchange reservation data that includes a plurality of exchange reservation detail data having exchange reservation amounts that are foreign currency amounts for which exchange reservations have been made; (2) an acquisition unit 102a as an acquisition unit that acquires exchange reservation detail data that matches the conditions; an allocation area that is an area for allocating to the reservation amount; a display execution section 102b as a display execution means for displaying on the display section; (4) a warning output unit 102c as a warning output means that outputs a warning when the amount is greater than the amount obtained by subtracting the amount that has been allocated to the foreign exchange reservation; and (4) the rate at the time of reservation that the foreign exchange reservation detail data acquired by the acquisition means has. Means for calculating an average rate by dividing the total amount of Japanese currency calculated by multiplying by the foreign currency amount allocated to the foreign currency amount by the input foreign currency amount (the foreign exchange reservation details obtained by the obtaining means) Input the Japanese currency amount calculated by multiplying the rate at the time of reservation that the data has by the allocated foreign currency amount and the spot rate, which is the rate used for converting foreign currency into Japanese currency and is used for spot transactions. the Japanese currency amount calculated by multiplying the foreign currency amount by the foreign currency amount obtained by subtracting the total amount of the allocated foreign currency amount from the foreign currency amount, and the average rate is calculated by dividing the total amount by the input foreign currency amount. (5) an updating section 102e as an updating means for updating the foreign exchange reservation detail data with the cumulative amount of the allocated foreign currency amount as the allocated amount of the foreign exchange reservation; and (6) from the value obtained by multiplying the sales amount by the average rate calculated by the average rate calculation means, subtract the value obtained by multiplying the deposit amount in foreign currency for the sales amount by the rate at the time of deposit of the deposit amount. Accordingly, a profit and loss calculating section 102f is provided as a profit and loss calculating means for calculating foreign exchange gains and losses.

The acquisition unit 102a acquires, from the exchange reservation data 106a, exchange reservation detail data that matches the acquisition conditions for acquiring the exchange reservation detail data.

More specifically, the acquisition unit 102a acquires, from the exchange reservation data 106a, a period from the start date to the end date that includes the currency input as the acquisition condition and to which the scheduled collection date input as the acquisition condition belongs. You may also obtain foreign exchange reservation details data including:

The display execution unit 102b allocates the exchange reservation amount included in the exchange reservation detail data acquired by the acquisition unit 102a and the slip amount (corresponding to the "input foreign currency amount" of the present invention) to the exchange reservation amount. An allocation area, which is an area for the allocation, is displayed on the display section. As a result, it is possible to support the allocation operation so that the amount of the slip can be allocated to multiple exchange reservation amounts.

The display unit execution unit 102b may further display on the display unit the reservation rate included in the foreign exchange reservation details data acquired by the acquisition unit 102a. Thereby, for example, the operator can make an allocation that takes into consideration the rate at the time of reservation.

The display unit execution unit 102b may display the exchange reservation allocated amount updated by the update unit 102e on the display unit. As a result, for example, as will be explained in detail in [4-3] below, it becomes possible to allocate a pattern of exchange reservation N:accounting slip M.

The warning output unit 102c outputs a warning if the current allocated amount (corresponding to the "allocated foreign currency amount" of the present invention) is larger than the amount obtained by subtracting the foreign exchange reservation allocated amount from the foreign exchange reservation amount. do. Thereby, for example, it is possible to prevent allocation of an amount larger than the amount that can be allocated.

The average rate calculation unit 102d calculates the Japanese currency by multiplying the rate at the time of reservation included in the exchange reservation detail data acquired by the acquisition unit 102a by the current allocation amount (corresponding to the “allocated foreign currency amount” of the present invention). The average rate is calculated by dividing the total amount by the slip amount (corresponding to the "input foreign currency amount" of the present invention). Thereby, for example, when the entire amount of the invoice amount is allocated to a plurality of exchange reservation amounts having different rates at the time of reservation, an average rate can be calculated.

The average rate calculation unit 102d calculates the Japanese currency by multiplying the rate at the time of reservation included in the exchange reservation detail data acquired by the acquisition unit 102a by the current allocation amount (corresponding to the “allocated foreign currency amount” of the present invention). amount, the spot rate (equivalent to the "spot rate" of the present invention), the slip amount (equivalent to the "entered foreign currency amount" of the present invention), and the current allocated amount (equivalent to the "allocated foreign currency amount" of the present invention). The Japanese currency amount calculated by multiplying the total amount of the foreign currency amount (corresponding to the "foreign currency amount") by the foreign currency amount, and the average You may also calculate the rate of With this, for example, even if a part of the invoice amount is allocated to multiple exchange reservation amounts with different exchange rates at the time of reservation, and the remaining amount of the invoice amount is supplemented with the spot rate, the average rate can be calculated. Can be done.

Note that the calculated average rate can be used, for example, to calculate the exchange profit and loss performed by the profit and loss calculation unit 102f.

The updating unit 102e updates the foreign exchange reservation detail data with the cumulative amount of the allocated foreign currency amount as the allocated amount of the foreign exchange reservation. As a result, for example, as will be explained in detail in [4-3] below, it becomes possible to allocate a pattern of exchange reservation N:accounting slip M.

The profit and loss calculation unit 102f calculates a value obtained by multiplying the sales amount in foreign currency by the average rate calculated by the average rate calculation unit 102d, and multiplies the deposit amount in foreign currency for the sales amount by the rate at the time of deposit of the deposit amount. Calculate foreign exchange gains and losses by subtracting .

[3. Outline of processing]
In this item, an overview of the processing according to this embodiment will be explained.

[3-1. Process flow]
The processing according to this embodiment is generally a three-stage process as follows.

First, a selection screen for forward exchange allocation (foreign exchange allocation screen) is started from the sales or purchase accounting screen. In other words, from input jobs that record receivables (sales, etc.) and payables (purchases, etc.), or their plans to become receivables or payables in the future (estimates, orders, orders, contracts, etc.), a common foreign exchange forward transfer can be performed. By activating this screen, it becomes possible to allocate foreign exchange reservations. By passing the necessary parameters from the activation source screen, the exchange reservation allocation screen is activated with the exchange reservation detail data that can be allocated appropriately narrowed down.

Next, on the foreign exchange reservation allocation screen, a detail to be allocated is selected from a plurality of foreign exchange reservation detail data.

Finally, if multiple rates are allocated, the average rate is calculated and the calculated average rate becomes the slip rate.

[3-2. Patterns that can be allocated to foreign exchange contracts]
In this embodiment, allocation can be broadly classified into the following three patterns. Note that in the following description, both N and M are natural numbers of 2 or more.

The first allocation pattern is the allocation of "Foreign Exchange 1: Accounting Slip N" as shown in FIG. In the example of FIG. 7, the slip amounts of $5,000, $3,000, and $2,000 are allocated to the exchange reservation amount of $10,000.

The second allocation pattern is the allocation of "Foreign Exchange N: Accounting Slip 1" as shown in FIG. In the example (2) of FIG. 8, the slip amount of $30,000 is allocated to the exchange reservation amounts of $10,000, $10,000, and $10,000. Furthermore, in the example (2') of Figure 8, even if the slip amount of $45,000 is allocated to the exchange reservation amounts of $10,000, $10,000, and $10,000, it will take $15,000 to allocate the entire slip amount of $45,000. Due to insufficient funds, the shortfall of $15,000 cannot be allocated to the foreign exchange contract amount. In this case, by specifying the spot rate for the shortfall of $15,000, [4. As explained in [Processing Details], the average rate can be calculated.

The third allocation pattern is the allocation of "foreign exchange N:accounting slip M" as shown in FIG. In the example in Figure 9, the voucher amount of $15,000 is allocated to $10,000 of the $10,000 foreign exchange contract amount of foreign exchange reservation number KWS001-001 and $5,000 of the foreign exchange contract amount of $10,000 of foreign exchange contract number KWS001-002. , the slip amount of $3,000 is allocated to $3,000 of the $10,000 forward exchange amount of foreign exchange reservation number KWS001-002, and the slip amount of $4,000 is allocated to $2,000 of the foreign exchange reservation amount of $10,000 of foreign exchange reservation number KWS001-002. and $2,000 of the $10,000 foreign exchange contract amount for foreign exchange contract number KWS001-003.

[4. Processing details]
In this item, details of the processing according to this embodiment will be explained. In this section, the explanation will proceed on the assumption that the exchange reservation data 106a shown in FIG. 2 has been registered in advance by inputting exchange reservations.

[4-1. Sales input]
First, on the sales input screen shown in FIG. 3, the billing party "YKH002", the customer "YKH002-NY", the scheduled collection date "2018/3/10", and the currency "USD" are entered. The currency is the currency set for the billing destination. Among these input information, the expected collection date "2018/3/10" and the currency "USD" are determined by obtaining the specified exchange reservation details data from the exchange reservation data 106a in FIG. 2, as explained below. This is the acquisition condition for

Next, a description will be given of how the rate "110.05" on the sales input screen of FIG. 3 is obtained. First, when the initial rate classification "Standard Rate" associated with the input currency "USD" is obtained from the currency master 106d in FIG. 10, the input currency is obtained from the rate master 106f in FIG. Currency code 2 of "USD" and the rate "110.05" linked to the obtained "standard rate" are obtained and displayed on the sales input screen of FIG. 3. Note that if the allocation has not been made yet, the rate can be changed by inputting the rate.

Then, on the sales input screen shown in Figure 3, when the sales amount excluding tax "$10,000" is entered as the slip amount, the entered $10,000 is multiplied by the obtained rate of 110.05 and converted into Japanese currency. The net sales amount "1,100,500 yen" is calculated and displayed. Note that the exchange reservation allocation described below is made for the inputted slip amount of $10,000.

When the "allocation button" on the sales input screen of FIG. 3 is pressed after performing the above input, the acquisition unit 102a acquires the foreign exchange reservation details that match the acquisition conditions from the foreign exchange reservation data 106a of FIG. As data (specifically, as exchange contract details data that includes the currency "USD" and includes the period from the start date to the end date to which the scheduled collection date "2018/3/10" belongs), the exchange rate shown in Figure 2 Obtain the three exchange reservation details data for reservation numbers KWS001-003, KWS001-004, and KWS001-005. Although the foreign exchange contract details data for the foreign exchange contract number KWS001-002 meets the above acquisition conditions, the amount allocated to the foreign exchange contract is $10,000 for the foreign exchange contract amount of $10,000, that is, the remaining amount that can be allocated is does not exist, so it is not an acquisition target of the acquisition unit 102a.

The three acquired foreign exchange reservation details data are displayed on the foreign exchange reservation allocation screen that is activated when the "allocation button" in Figure 3 is pressed, and as explained in the next item [4-2]. , allocation is made. Note that since the foreign exchange reservation allocation screen is a common screen, it can be called up not only from sales inputs (for example, from purchase inputs).

[4-2. Foreign exchange forward allocation]
Next, the display execution unit 102b converts the exchange reservation amounts 10,000 dollars, 20,000 dollars, and 30,000 dollars included in the three foreign exchange reservation detail data acquired by the acquisition unit 102a, and the entered slip amount “10,000 dollars” into the foreign exchange reservation unit 102b. An allocation area MA1, which is an area for allocating to the reservation amount, is displayed on the exchange reservation allocation screen in FIG. The operator can make an allocation by inputting a desired current allocation amount into the displayed allocation area MA1. In the example of FIG. 4, $3,000, $2,000, and $1,000 are input as the current allocation amount for each of the three foreign exchange reservation details data. In this way, by selecting the exchange reservation details data that you want to allocate from among the available exchange reservation details data and specifying the allocation amount, you can specify it for multiple exchange reservation details data per sales slip. You can allocate that amount. Each piece of information displayed on the foreign exchange reservation allocation screen in FIG. 4 will be explained below. Note that in FIG. 4, the areas with dot hatching are areas where input is not possible.

In the foreign exchange reservation allocation screen of FIG. 4, the billing party, scheduled collection date, currency, and slip amount are passed as parameters from the sales input screen of FIG.

In the exchange reservation allocation screen of FIG. 4, the allocation reservation allocated amount is the amount that has already been allocated to other slips.

In the foreign exchange contract allocation screen of FIG. 4, the current allocation amount is the amount to be allocated this time, as described above. Note that the warning output unit 102c may display a warning such as an error message when the current allocated amount is greater than the amount obtained by subtracting the exchange reservation allocated amount from the exchange reservation amount. This makes it possible to perform control so that an amount exceeding the exchange reservation amount minus the exchange reservation allocated amount cannot be allocated.

In the foreign exchange reservation allocation screen of FIG. 4, the remaining amount after the current allocation is the amount that is obtained by subtracting the current allocation amount from the amount that can be allocated. That is, the remaining amount after current allocation is calculated using the following formula: Foreign exchange contract amount - Foreign exchange contract allocated amount - Current allocation amount.

In the foreign exchange reservation allocation screen of FIG. 4, rates 116.97, 112.10, and 112.65 are reservation rates included in the foreign exchange reservation detail data acquired by the acquisition unit 102a. In this way, the display execution unit 102b displays the rate at the time of reservation included in the foreign exchange reservation details data acquired by the acquisition unit 102a, so that the operator can make an allocation while taking the rate into consideration.

On the foreign exchange reservation allocation screen in Figure 4, the currently allocated Japanese currency amounts marked with *1 of 35,910 yen, 224,200 yen, and 112,650 yen are the Japanese currency amounts calculated by multiplying the currently allocated amount by the exchange rate at the time of reservation.

Here, the display execution unit 102b may change the display order of the exchange reservation details data in ascending or descending order of exchange reservation number, end date, and rate. This enables more effective exchange allocation.

On the foreign exchange contract allocation screen in Figure 4, the Japanese currency amount marked with *2 of 687,760 yen is the total amount of the current Japanese currency amount marked with *1.

Here, as explained at the beginning of this item [4-2], out of the $10,000 invoice amount, the amount allocated this time is $3,000 + $2,000 + $1,000 = $6,000. The remaining amount of $4,000 remains unallocated. In this case, by using the spot rate of 113.36, the $4,000 can be converted into Japanese currency as $4,000 x 113.36 = 453,440 yen, as marked *3 on the forward exchange allocation screen in Figure 4. It is assumed that the rate shown in MA2 in FIG. 4 is a value obtained from the rate master 106f in the initial display rate category set in the currency master 106d. Further, it is possible to change the rate classification shown in MA2 in FIG. 4, and when "9: Spot rate" is specified, the rate can be freely set.

On the exchange reservation allocation screen in FIG. 4, the rate 114.12 is calculated by the average rate calculation unit 102d as follows using the Japanese currency amount and the slip amount when allocated to multiple exchange reservation details data. Average rate. That is, the average rate calculation unit 102d calculates the average rate = {total amount of Japanese currency allocated this time + (remaining amount + slip standard rate)} ÷ slip amount = {350,910 yen + 224,200 yen + 112,650 yen + (4,000 dollars x 113.36 )} ÷ $10,000 = 1,141,200 yen ÷ $10,000 = 114.12. The 114.12 is the slip rate.

The calculated average rate (slip rate) of 114.12 and the total Japanese currency amount of 1,141,200 yen are then overwritten on the sales input screen, as shown in FIG. Note that the average rate (slip rate) of 114.12 cannot be changed, as shown by dotted hatching on the sales input screen in FIG. The calculated average rate (slip rate) can be used for calculating foreign exchange gains and losses, etc., as explained in [4-4] below.

[4-3. Creation of sales data and collection schedule data and update of foreign exchange reservation data]
Next, sales data 106b shown in FIG. 6 is created based on the overwritten and updated sales input screen shown in FIG.

Next, collection schedule data 106c shown in FIG. 6 is created based on the created sales data 106b.

Next, the updating unit 102e updates the amount of exchange reservation allocated in the exchange reservation data 106a as follows. In other words, as shown in the foreign exchange contract allocation screen in FIG. 4, the amount allocated to foreign exchange contract number KWS001-003 was $7,000, but this time a new amount of $3,000 was allocated, so the update unit 102e As shown in the exchange reservation data 106a in FIG. 6, updates the exchange reservation allocated amount of exchange reservation number KWS001-003 to $7,000 + $3,000 = $10,000. Similarly, as shown in the exchange reservation data 106a in FIG. 6, the update unit 102e updates the exchange reservation allocated amount of the exchange reservation number KWS001-004 to $7,000 + $2,000 = $9,000, and Update the allocated amount of foreign exchange contract for number KWS001-005 to $0 + $1,000 = $1,000.

In this way, by the update unit 102e updating the amount allocated to foreign exchange reservations as needed, it is possible to correspond to the allocation pattern of "Forex reservation N: recording slip M" explained in [3-2]. can. Specifically, the explanation will be given by taking as an example a case where it is assumed that in addition to the above-mentioned slip amount of $10,000, there is also a slip amount of $3,000 (that is, the case of exchange reservation 3: accounting slip 2). The allocated amount of the foreign exchange contract for the foreign exchange contract number KWS001-003 has been updated to $10,000 as explained in the previous paragraph, so the remaining amount that can be allocated for the foreign exchange contract detail data of the foreign exchange contract number KWS001-003 is The updated foreign exchange forward allocation amount of $10,000 will be deducted from the $10,000 amount, resulting in $0. Similarly, the remaining amount that can be allocated to the detailed foreign exchange contract data of foreign exchange reservation number KWS001-004 is $20,000 - $9,000 = $11,000, and the remaining amount that can be allocated to the detailed foreign exchange contract data of foreign exchange contract number KWS001-005 is , $30,000 - $1,000 = $29,000. Therefore, the voucher amount of $3,000 can be allocated to the remaining amount of $11,000 in the detailed exchange data of the exchange reservation number KWS001-004 or the remaining amount of $29,000 of the detailed exchange contract data of the exchange reservation number KWS001-005.

[4-4. Calculation of foreign exchange gains and losses]
Using the average rate (slip rate) calculated in [4-2], for example, when there is a partial payment on the corresponding slip (for example, a partial payment due to acceptance inspection, etc.), the profit and loss calculation unit 102f calculates the following: Foreign exchange gains and losses can be calculated using the formula. In other words, foreign exchange gain/loss = (Currently deposited cost x slip rate) - (Currently deposited foreign currency x Deposit rate).

A specific example of calculating foreign exchange profit and loss when payment is received before registering a sales slip will be explained. The conditions shall be as shown below.
(conditions)
Sales voucher amount $4,000 Voucher rate 114.12
Deposit amount: $4,000 Rate at time of deposit: 113.36

In this case, the recorded sales amount is $4,000 x 114.12 = 456,480 yen, but the actual amount received is only $4,000 x 113.36 = 453,440 yen. Calculated as

[4-5. summary]
As explained above, according to the allocation business support device 100 according to the present embodiment, the exchange reservation amount and the allocation area that is an area for allocating the input foreign currency amount to the exchange reservation amount are provided. By displaying , on the display unit, it is possible to support the allocation operation so that the foreign currency amount can be allocated to a plurality of exchange reservation amounts. This makes it possible, for example, to simplify complicated management operations and payment operations for foreign exchange reservations, and to reduce operational risks such as payment errors.

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

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

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

Further, regarding the allocation task support device 100, each illustrated component is functionally conceptual, and does not necessarily need to be physically configured as illustrated.

For example, all or any part of the processing functions provided in the allocation work support device 100, especially each processing function performed by the control unit, may be realized by a CPU and a program interpreted and executed by the CPU. Alternatively, it may be realized as hardware using wired logic. Note that the program is recorded on a non-temporary computer-readable recording medium that includes programmed instructions for causing the information processing device to execute the processing described in this embodiment. It is mechanically read by the support device 100. That is, a storage unit such as a ROM or an HDD (Hard Disk Drive) stores a computer program that cooperates with an OS to give instructions to a CPU and perform various processes. This computer program is executed by being loaded into the RAM, and constitutes a control unit in cooperation with the CPU.

Further, this computer program may be stored in an application program server connected to the allocation work support device 100 via an arbitrary network, and all or part of it may be downloaded as necessary. It is possible.

Further, a program for executing the processing described in this embodiment may be stored in a non-temporary computer-readable recording medium, or may be configured as a program product. Here, this "recording medium" includes 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), and an EEPR. OM (registration) Trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magneto-Optical disk), DVDs (Digital Versatile Discs), Blu-ray (registered trademark) Discs, etc. shall include any “portable physical medium”.

Further, a "program" is a data processing method written in any language or writing method, and does not matter in the form of source code or binary code. Note that a "program" is not necessarily limited to a unitary structure, but may be distributed as multiple modules or libraries, or may work together with separate programs such as an OS to achieve its functions. Including things. Note that well-known configurations and procedures can be used for the specific configuration and reading procedure for reading the recording medium in each device shown in the embodiments, and the installation procedure after reading.

The various databases stored in the storage unit are storage devices such as memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks, and are used for various processing and website provision. Stores programs, tables, databases, web page files, etc.

Further, the allocation task support device 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device connected with any peripheral device. Further, the allocation task support device 100 may be realized by installing software (including programs, data, etc.) that makes the device realize the processing described in this embodiment.

Furthermore, the specific form of dispersion and integration of devices is not limited to what is shown in the diagram, and all or part of them can be functionally or physically divided into arbitrary units according to various additions or functional loads. It can be configured in a distributed/integrated manner. That is, the embodiments described above may be implemented in any combination, or the embodiments may be implemented selectively.

The present invention is useful, for example, in industries that conduct overseas transactions, and is particularly useful in industries such as trading companies.

100 Allocation work support device 102 Control unit
102a Acquisition part
102b Display execution unit
102c Warning output section
102d Average rate calculation unit
102e Update section
102f profit and loss calculation section 104 communication interface section 106 storage section
106a Exchange contract data
106b Sales data
106c Collection schedule data
106d Currency master
106e Rate classification master
106f rate master 108 input/output interface unit 112 input device 114 output device 200 server 300 network

Claims (7)

An allocation work support device comprising a control unit and a display unit,
The control unit includes:
From exchange reservation data that includes a plurality of exchange reservation detail data having an exchange reservation amount, which is the foreign currency amount of the exchange reservation, and a rate at the time of reservation, which is the rate used to convert the foreign currency into Japanese currency, and which is the rate at the time of the exchange reservation. , an acquisition means for acquiring exchange reservation detail data that meets the acquisition conditions for acquiring the exchange reservation detail data;
the exchange reservation amount included in the exchange reservation detail data acquired by the acquisition means; and an allocation area that is an area for allocating the input foreign currency amount, which is a commercial transaction amount in foreign currency, to the exchange reservation amount. Display execution means for displaying on the display section;
The average rate is calculated by dividing the total Japanese currency amount calculated by multiplying the foreign currency amount allocated to the rate at the time of reservation included in the exchange reservation details data acquired by the acquisition means by the input foreign currency amount. or a Japanese currency amount calculated by multiplying the foreign currency amount allocated to the rate at the time of reservation included in the exchange reservation detail data acquired by the acquisition means, and the rate used to convert foreign currency into Japanese currency. and the Japanese currency amount calculated by multiplying the spot rate used for spot transactions by the foreign currency amount obtained by subtracting the total amount of the allocated foreign currency amount from the foreign currency amount inputted above. an average rate calculation means for calculating an average rate by dividing by the foreign currency amount calculated;
From the value obtained by multiplying the input foreign currency amount by the average rate calculated by the average rate calculation means, calculate the value obtained by multiplying the payment amount in foreign currency for the input foreign currency amount by the rate at the time of payment of the payment amount . A profit and loss calculation means for calculating foreign exchange profit and loss by subtraction;
to have
An allocation work support device featuring: The display execution means includes:
Further, displaying the rate at the time of reservation included in the foreign exchange reservation details data acquired by the acquisition means on the display unit;
The allocation work support device according to claim 1, characterized in that: The exchange reservation details data further includes currency identification data for identifying the type of currency for the foreign currency amount, and a settlement period that is a period for which the input foreign currency amount is to be settled;
The acquisition means is
From the exchange reservation data, exchange reservation detail data that includes the currency identification data input as the acquisition condition and that includes the payment period to which the scheduled settlement date, which is the scheduled date of the settlement input as the acquisition condition, belongs. to obtain,
The allocation work support device according to claim 1 or 2, characterized in that: The foreign exchange reservation details data further includes a foreign exchange reservation allocated amount that is the foreign exchange reservation amount for which the allocation has been completed,
The control unit includes:
updating means for updating the cumulative foreign currency amount allocated to the foreign exchange reservation detail data as the foreign exchange reservation allocated amount;
further comprising;
The display execution means includes:
displaying the exchange reservation allocated amount updated by the updating means on the display section;
The allocation work support device according to any one of claims 1 to 3, characterized in that: The control unit includes:
Warning output means for outputting a warning when the allocated foreign currency amount is greater than the amount obtained by subtracting the foreign exchange reservation allocated amount from the foreign exchange reservation amount.
further comprising;
The allocation work support device according to claim 4, characterized in that: An allocation task support method executed by an information processing device including a control unit and a display unit, the method comprising:
executed by the control unit,
From exchange reservation data that includes a plurality of exchange reservation detail data having an exchange reservation amount, which is the foreign currency amount of the exchange reservation, and a rate at the time of reservation, which is the rate used to convert the foreign currency into Japanese currency, and which is the rate at the time of the exchange reservation. , an acquisition step of acquiring foreign exchange reservation detail data that meets the acquisition conditions for acquiring the foreign exchange reservation detail data;
The exchange reservation amount included in the exchange reservation detail data acquired in the acquisition step, and an allocation area that is an area for allocating the input foreign currency amount, which is a commercial transaction amount in a foreign currency, to the exchange reservation amount. a display execution step of displaying on the display unit;
The average rate is calculated by dividing the total amount of the Japanese currency amount calculated by multiplying the foreign currency amount allocated to the rate at the time of reservation that the foreign exchange reservation details data acquired in the acquisition step has, by the input foreign currency amount. or the Japanese currency amount calculated by multiplying the foreign currency amount allocated to the rate at the time of reservation included in the exchange reservation details data acquired in the acquisition step, and the rate used to convert foreign currency into Japanese currency. and the Japanese currency amount calculated by multiplying the spot rate used for spot transactions by the foreign currency amount obtained by subtracting the total amount of the allocated foreign currency amount from the foreign currency amount inputted above. an average rate calculation step of calculating an average rate by dividing by the foreign currency amount obtained;
From the value obtained by multiplying the input foreign currency amount by the average rate calculated in the average rate calculation step, calculate the value obtained by multiplying the payment amount in foreign currency for the input foreign currency amount by the rate at the time of payment of the payment amount. a profit and loss calculation step of calculating foreign exchange profit and loss by subtraction;
including;
An allocation business support method characterized by the following. An allocation task support program to be executed by an information processing device including a control unit and a display unit,
for the control unit to execute,
From exchange reservation data that includes a plurality of exchange reservation detail data having an exchange reservation amount, which is the foreign currency amount of the exchange reservation, and a rate at the time of reservation, which is the rate used to convert the foreign currency into Japanese currency, and which is the rate at the time of the exchange reservation. , an acquisition step of acquiring foreign exchange reservation detail data that meets the acquisition conditions for acquiring the foreign exchange reservation detail data;
The exchange reservation amount included in the exchange reservation detail data acquired in the acquisition step, and an allocation area that is an area for allocating the input foreign currency amount, which is a commercial transaction amount in a foreign currency, to the exchange reservation amount. a display execution step of displaying on the display unit;
The average rate is calculated by dividing the total amount of the Japanese currency amount calculated by multiplying the foreign currency amount allocated to the rate at the time of reservation that the foreign exchange reservation details data acquired in the acquisition step has, by the input foreign currency amount. or the Japanese currency amount calculated by multiplying the foreign currency amount allocated to the rate at the time of reservation included in the exchange reservation details data acquired in the acquisition step, and the rate used to convert foreign currency into Japanese currency. and the Japanese currency amount calculated by multiplying the spot rate used for spot transactions by the foreign currency amount obtained by subtracting the total amount of the allocated foreign currency amount from the foreign currency amount inputted above. an average rate calculation step of calculating an average rate by dividing by the foreign currency amount obtained;
From the value obtained by multiplying the input foreign currency amount by the average rate calculated in the average rate calculation step, calculate the value obtained by multiplying the payment amount in foreign currency for the input foreign currency amount by the rate at the time of payment of the payment amount. a profit and loss calculation step of calculating foreign exchange profit and loss by subtraction;
including;
An allocation business support program featuring:

Images