JP2022140619A - Appropriation operation support device, appropriation operation support method, and appropriation operation support program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide an appropriation operation support device capable of supporting appropriation operation so as to make it possible to appropriate foreign money for a plurality of exchange reservation money, an appropriation operation support method, and an appropriation operation support program.

SOLUTION: In this embodiment, (1) from exchange reservation data including a plurality of exchange reservation detail data having exchange reservation money, the exchange reservation detail data matching acquisition conditions for acquiring the exchange reservation detail data is obtained, and (2) a display unit displays the exchange reservation money owned by the acquired exchange reservation detail data and an appropriate area that is an area for appropriating check money for the exchange reservation money.

SELECTED DRAWING: Figure 4

COPYRIGHT: (C)2022,JPO&INPIT

Description

The present invention relates to an allocation business support device, an allocation business support method, and an allocation business 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, transactions denominated in foreign currencies may have a disproportionate impact on specific units depending on the timing of exchange transactions and allocation rules. It is disclosed that by storing the management accounting exchange rate for conversion of foreign currency transactions in the exchange information storage unit 22 and reflecting it in the JVA calculation, it is possible to reduce such influence and grasp the operating profit and loss that is closer to the actual situation. (see paragraph 0059 of Patent Document 1).

JP 2006-107227 A

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

However, in the past, although the sales amount could be allocated to one exchange contract amount, the sales amount could not be allocated to a plurality of exchange contract amounts. For example, if $10,000 and $20,000 are separately reserved in advance, the sales amount of $10,000 is allocated only to the forward exchange contract of $10,000, or the sales amount of $10,000 is allocated only to the forward exchange contract of $20,000. In the past, it was possible to allocate $6,000 of the $10,000 sales amount to the forward exchange contract of $10,000, and the remaining sales amount of $4,000 to the forward exchange contract of $20,000. I couldn't. Therefore, there is a problem that the apportioning work lacks flexibility.

SUMMARY OF THE INVENTION The present invention has been made in view of the above problems. The purpose is to provide an allotment business support program.

In order to solve the above-described problems and achieve the object, an appropriation business support device according to the present invention is an appropriation business support device comprising a control unit and a display unit, wherein an acquisition means for acquiring, from exchange contract data including a plurality of exchange contract detail data having a exchange contract amount that is an amount, exchange contract detail data that meets an acquisition condition for acquiring said exchange contract detail data; display execution means for displaying on the display unit the exchange contract amount included in the acquired exchange contract detail data and an allocation area for allocating the input foreign currency amount to the exchange contract amount; .

Further, in the appropriation work support device according to the present invention, the exchange contract detail data further includes a reservation rate that is a rate used to convert a foreign currency into Japanese currency and is a rate at the time of the exchange contract, The display execution means is characterized in that the rate at the time of reservation included in the exchange contract detail data acquired by the acquisition means is further displayed on the display section.

Further, in the appropriation business support device according to the present invention, the forward exchange contract detail data includes currency identification data for identifying the type of currency for the foreign currency amount and the period during which the input foreign currency amount is to be collected. and the acquisition means includes the currency identification data input as the acquisition condition from the exchange contract data, and at the scheduled collection date input as the acquisition condition It is characterized by acquiring forward exchange contract detail data including the collection target period to which a certain scheduled collection date belongs.

Further, in the appropriation work support device according to the present invention, the control unit multiplies the rate at the time of reservation held in the exchange contract detail data acquired by the acquisition means by the allocated foreign currency amount. It 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 appropriation work support device according to the present invention, the control unit multiplies the rate at the time of reservation included in the foreign exchange contract detail data acquired by the acquisition means by the allotted foreign currency amount. , the foreign currency amount obtained by subtracting the total amount of the allocated foreign currency amount from the foreign currency amount entered above is multiplied by the spot rate, which is the rate used to convert foreign currency into Japanese currency and is used for spot transactions. and an average rate calculation means for calculating an average rate by dividing the total amount of the foreign currency amount calculated by the input foreign currency amount.

Further, in the appropriation work support device according to the present invention, the exchange contract detail data further includes an allocated exchange contract amount, which is the amount of the exchange contract that has been allocated, and the control unit updating means for updating the forward exchange contract detail data with the cumulative amount of the foreign currency amounts that have been allocated as the forward exchange contract allocation amount; It is characterized by displaying on the display unit.

Further, in the appropriation work support device according to the present invention, the control unit outputs a warning when the allocated foreign currency amount is greater than the amount obtained by subtracting the allocated amount of the forward exchange contract from the amount of the forward exchange contract. It is characterized by further comprising warning output means.

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

Further, an allocation business support method according to the present invention is a allocation business support method executed by an information processing device having a control unit and a display unit, wherein an obtaining step of obtaining, from exchange contract data including a plurality of exchange contract detail data having a certain exchange contract amount, exchange contract detail data that satisfies an acquisition condition for obtaining said exchange contract detail data; a display execution step of displaying, on the display unit, the exchange contract amount included in the exchange contract detail data and an allocation area for allocating the input foreign currency amount to the exchange contract amount; characterized by comprising:

Further, an allotment business support program according to the present invention is an allotment business support program to be executed by an information processing apparatus having a control unit and a display unit, wherein the control unit executes an allocation business support program for foreign currency exchange contracts an obtaining step of obtaining, from exchange contract data including a plurality of exchange contract detail data having a exchange contract amount that is an amount, exchange contract detail data that satisfies an acquisition condition for obtaining said exchange contract detail data; a display execution step of displaying, on the display unit, the exchange contract amount included in the acquired exchange contract detail data and an allocation area for allocating the input foreign currency amount to the exchange contract amount; , and

ADVANTAGE OF THE INVENTION According to this invention, it is effective in the ability to support allocation work so that a foreign currency amount can be allocated to several exchange contract amounts.

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

Embodiments of an allocation business support device, an allocation business support method, and an allocation business support program will be described in detail below with reference to the drawings. It should be noted that the present invention is not limited by this embodiment.

[1. Overview]
In the field of foreign currency transactions, the method of managing foreign exchange contracts differs depending on the company.

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

Furthermore, in the past, calculation of the average rate of multiple exchange rates with different rates and currency conversion had to be performed outside the system, which resulted in high calculation costs and also had issues in improving payment risks. .

Therefore, in the present embodiment, for example, a function is implemented in which a plurality of exchange contracts with different rates are assigned to each transaction, and the average rate can be calculated and currency conversion can be performed within the system. In addition, in this embodiment, for example, if the transaction amount is not fully allocated even if the foreign exchange contract is allocated, the balance of the transaction amount can be converted into Japanese currency using the spot rate. The calculation of the average rate can be performed by taking into account the spot rate as well.

By implementing the above functions, in this embodiment, for example, it is possible to use a mixture of multiple exchange rates and spot rates. Accuracy can be improved. In addition, since the above functions are more suitable for on-site work and have high versatility, for example, management outside the system can be reduced, and work efficiency can be improved. Specific configurations and operations will be described below.

[2. Constitution]
An example of the configuration of the allocation work support device 100 according to this embodiment will be described with reference to FIG. FIG. 1 is a block diagram showing an example of the configuration of the appropriation work support device 100. As shown in FIG.

The allotment business support device 100 is a commercially available desktop personal computer. In addition, the allotment business support device 100 is not limited to a stationary information processing device such as a desktop personal computer, but may be a commercially available notebook personal computer, PDA (Personal Digital Assistants), a smartphone, a tablet personal computer, etc. It may be a portable information processing device.

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

The communication interface unit 104 communicably connects the appropriation business 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 another device via a communication line. Here, the network 300 has a function of connecting the allocation business support device 100 and the server 200 so as to be able to communicate with each other, and is, for example, the Internet or a LAN (Local Area Network). Data such as various masters 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 section 108 . The output device 114 can be a monitor (including a home television), a speaker, or a printer. The input device 112 can be a keyboard, a mouse, a microphone, or a monitor that realizes a pointing device function in cooperation with a mouse. Note that, hereinafter, the output device 114 may be referred to as the monitor 114 and the input device 112 may be referred to as the keyboard 112 or the mouse 112 .

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

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

According to the appropriation business support device 100 according to the present embodiment, a foreign exchange contract amount, which is a foreign currency amount that has been exchange contracted, and an appropriation area, which is an area for allocating the entered foreign currency amount to the exchange contract amount , is displayed on the display unit, it is possible to assist 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.

As shown in FIG. 2, the exchange contract data 106a includes a plurality of exchange contract detail data (referring to the horizontal line of information in the exchange contract data 106a in FIG. 2). As shown in FIG. 2, the exchange contract detail data includes, for example, exchange contract identification data (exchange contract number) for identifying each exchange contract, and currency identification data for identifying the type of currency for the foreign currency amount. (currency), the exchange contract amount (contract exchange amount) that is the amount of the foreign currency contracted, the rate at the time of contract (rate) that is the rate used to convert the foreign currency into Japanese currency at the time of the exchange contract, the exchange contract Allotted amount of the exchange contract (allotted amount of the exchange contract), the date of the exchange contract (reservation date), and the period during which the entered foreign currency amount is to be collected including the collection target period (period from the start date to the end date), etc.

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

6, the collection schedule data 106c includes, for example, collection schedule identification data (slip number) for identifying each collection schedule, the billing destination identification data (billing destination), the customer (foreign currency), 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 (foreign currency collection amount) ) etc.

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

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

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

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

The control unit 102 functionally conceptually includes, for example, (1) an acquisition function for acquiring the exchange contract detail data from the exchange contract data including a plurality of exchange contract detail data having the exchange contract amount that is the exchange contracted foreign currency amount; (2) an acquisition unit 102a as acquisition means for acquiring exchange contract detail data that meets conditions; a display execution unit 102b as display execution means for displaying on the display unit an allocation area that is an area for allocating the reserved amount; a warning output unit 102c as warning output means for outputting a warning when the amount is greater than the amount obtained by subtracting the allocated amount of the exchange contract; Average rate calculation means for calculating an average rate by dividing the total amount of the Japanese currency amount calculated by multiplying the foreign currency amount allocated to the above by the input foreign currency amount The foreign currency amount calculated by multiplying the rate at the time of reservation in the data by the allocated foreign currency amount, and the spot rate used for spot transactions, which is the rate used to convert the foreign currency into Japanese currency. The average rate is calculated by dividing the sum of the foreign currency amount obtained by subtracting the total amount of the allocated foreign currency amount from the foreign currency amount obtained by multiplying the foreign currency amount by the foreign currency amount obtained by subtracting the total amount of the allocated foreign currency amount and dividing the total amount by the input foreign currency amount. and (5) an updating unit 102e as updating means for updating the forward exchange contract detail data with the cumulative amount of allocated foreign currency amounts as the forward exchange contract allocated amount. and (6) subtracting the value obtained by multiplying the foreign currency deposit amount for the sales amount by the rate at the time of deposit from the value obtained by multiplying the sales amount by the average rate calculated by the average rate calculation means. Accordingly, the profit/loss calculation unit 102f is provided as profit/loss calculation means for calculating the foreign exchange profit/loss.

Acquisition unit 102a acquires, from exchange contract data 106a, exchange contract detail data that meets acquisition conditions for acquiring exchange contract detail data.

More specifically, the obtaining unit 102a obtains from the exchange contract data 106a the period from the start date to the end date to which the scheduled collection date input as the acquisition condition belongs, and which includes the currency input as the acquisition condition. You may acquire exchange contract detail data including.

The display executing unit 102b allocates the exchange contract amount included in the exchange contract detail data acquired by the acquisition unit 102a and the invoice amount (corresponding to the "input foreign currency amount" of the present invention) to the exchange contract amount. are displayed on the display unit. As a result, allocation work can be supported so that the slip amount can be allocated to a plurality of exchange contract amounts.

The display unit executing unit 102b may further display, on the display unit, the rate at the time of reservation included in the foreign exchange contract detail data acquired by the acquisition unit 102a. As a result, for example, the operator can perform allocation considering the rate at the time of reservation.

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

The warning output unit 102c outputs a warning when the current allocation amount (corresponding to the "allocated foreign currency amount" of the present invention) is greater than the amount obtained by subtracting the allocated amount of the exchange contract from the exchange contract amount. do. As a result, for example, it is possible to prevent allocating an amount larger than the allocatable amount.

The average rate calculation unit 102d calculates the Japanese currency by multiplying the rate at the time of reservation contained in the exchange contract detail data acquired by the acquisition unit 102a by the current allocation amount (equivalent to the "allocated foreign currency amount" of the present invention). The average rate is calculated by dividing the total amount of money by the slip amount (corresponding to the "input foreign currency amount" of the present invention). As a result, for example, when the total amount of the slip amount is allocated to a plurality of exchange contract amounts with 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 contained in the exchange contract detail data acquired by the acquisition unit 102a by the current allocation amount (equivalent to the "allocated foreign currency amount" of the present invention). and the spot rate (equivalent to the "spot rate" of the present invention) is converted from the slip amount (equivalent to the "input foreign currency amount" of the present invention) to the current allocated amount (equivalent to the "allocated (equivalent to the "entered foreign currency amount") is multiplied by the foreign currency amount after subtracting the total amount, and the total amount is divided by the slip amount (equivalent to the "entered foreign currency amount" of the present invention). rate may be calculated. As a result, for example, even if part of the slip amount is allocated to a plurality of exchange contract amounts with different rates at the time of reservation, and the balance of the slip 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, in the calculation of exchange gain/loss performed by the profit/loss calculation unit 102f.

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

The profit and loss calculation unit 102f multiplies the amount of sales in foreign currency by the average rate calculated by the average rate calculation unit 102d, and multiplies the amount of payment in foreign currency with respect to the sales amount by the rate at the time of payment. Calculate the exchange gain/loss by subtracting

[3. Outline of processing]
In this section, an outline of processing according to this embodiment will be described.

[3-1. Process flow]
The processing according to the present embodiment is, as an overview, the following three stages of processing.

First, a selection screen for exchange reservation allocation (exchange reservation allocation screen) is activated from the recording screen for sales or purchases. In other words, from an input job that records receivables (sales, etc.) and payables (purchase, etc.), or schedules of those that will become receivables or payables in the future (quotes, orders, orders, contracts, etc.), common forward exchange contracts By activating this screen, it becomes possible to allocate exchange contracts. By passing the necessary parameters from the activation source screen, the exchange reservation allocation screen is activated in a state in which the exchange reservation detail data that can be allocated is appropriately narrowed down.

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

Finally, when a plurality of rates are allocated, the average rate is calculated and the calculated average rate becomes the slip rate.

[3-2. Patterns that can be allocated for forward exchange contracts]
In this embodiment, the following three patterns of allocation can be roughly classified. 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 contract 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 contract amount of $10,000.

The second allocation pattern is the allocation of "foreign exchange contract N: accounting slip 1" as shown in FIG. In the example of (2) in FIG. 8, the slip amount of 30,000 dollars is allocated to the exchange contract amounts of 10,000 dollars, 10,000 dollars, and 10,000 dollars. In addition, in the example of (2') in Fig. 8, even if the slip amount of $45,000 is allocated to the forward exchange amounts of $10,000, $10,000 and $10,000, it takes $15,000 to allocate the entire slip amount of $45,000. Due to the shortfall, the shortfall of $15,000 cannot be allocated to the exchange contract amount. In this case, for the shortfall of $15,000, by specifying the spot rate, [4. Processing Details], the average rate can be calculated.

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

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

[4-1. Sales input]
First, on the sales input screen in FIG. 3, the billing destination "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 the input information, for the scheduled collection date "2018/3/10" and the currency "USD", the specified exchange contract detail data is obtained from the exchange contract data 106a in FIG. 2, as described below. It is an acquisition condition for

Next, how the rate "110.05" on the sales input screen of FIG. 3 is acquired will be described. First, from the currency master 106d of FIG. 10, when the initial rate category "standard rate" associated with the input currency "USD" is acquired, then from the rate master 106f of FIG. Currency code 2 of "USD" and the rate "110.05" associated with the acquired "standard rate" are acquired and displayed on the sales input screen in FIG. If allocation has not yet been made, the rate can be changed by input.

Then, when the tax-excluded sales amount of "10,000 dollars" is entered as the slip amount on the sales input screen of FIG. Excluded sales amount "1,100,500 yen" is calculated and displayed. It should be noted that the allocation of the forward exchange contract described below is performed for the input slip amount of 10,000 dollars.

After performing the above inputs, when the "allocation button" on the sales input screen in FIG. As data (specifically, exchange contract detail data that includes the currency "USD" and the period from the start date to the end date to which the scheduled collection date "2018/3/10" belongs), the exchange rate in Fig. 2 Acquire three forward exchange contract data with reservation numbers KWS001-003, KWS001-004 and KWS001-005. Although the exchange contract details data for exchange contract number KWS001-002 meets the acquisition conditions above, the reserved exchange contract amount is $10,000 and the allocated amount is $10,000. does not exist, it does not become an acquisition target of the acquisition unit 102a.

Then, the three acquired exchange contract detail data are displayed on the exchange contract allocation screen that is activated by pressing the "allocation button" in FIG. , apportionment is made. Since the exchange reservation allocation screen is a common screen, it can be called from other than sales input (for example, purchase input).

[4-2. Foreign exchange forward allocation]
Subsequently, the display executing unit 102b acquires the exchange contract amounts of 10,000 dollars, 20,000 dollars, and 30,000 dollars included in the three exchange contract detail data acquired by the acquisition unit 102a, and the input slip amount of "10,000 dollars". An allocation area MA1, which is an area for allocating the reserved amount, is displayed on the exchange reservation allocation screen of FIG. The operator can make an allocation by inputting the desired allocation amount in the displayed allocation area MA1. In the example of FIG. 4, 3,000 dollars, 2,000 dollars, and 1,000 dollars are entered as the current allotted amounts for each of the three exchange contract detail data. In this way, by selecting the exchange contract detail data that you want to allocate this time from the allocable exchange contract detail data and specifying the allocation amount, you can specify multiple exchange contract detail data for one sales slip. You can allocate the amount. Each piece of information displayed on the exchange reservation allocation screen of FIG. 4 will be described below. In FIG. 4, the portions hatched with dots are the portions where input is not allowed.

In the exchange reservation allocation screen of FIG. 4, the billing destination, 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 exchange contract allocation screen of FIG. 4, the amount to be allocated this time 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 allocation amount is greater than the amount obtained by subtracting the allocated amount of the exchange contract from the amount of the exchange contract. As a result, it is possible to perform control so that an amount exceeding the amount of the exchange contract - the allocated amount of the exchange contract cannot be allocated.

In the exchange contract allocation screen of FIG. 4, the balance after current allocation is the amount obtained by subtracting the current allocation amount from the allocable amount. That is, the balance after this allocation is calculated by the following formula: forward exchange contract amount - allocated amount of exchange contract - current allocated amount.

In the exchange contract allocation screen of FIG. 4, rates 116.97, 112.10 and 112.65 are the rates at the time of reservation held by the exchange contract detail data acquired by the acquiring unit 102a. In this way, the display executing unit 102b displays the rate at the time of reservation included in the forward exchange contract detail data acquired by the acquiring unit 102a, so that the operator can perform allocation while considering the rate.

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

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

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

Here, as explained at the beginning of this item [4-2], out of the slip amount of $10,000, the amount allocated this time is $3,000 + $2,000 + $1,000 = $6,000. The remaining $4,000 is unallocated. In this case, by using the spot rate of 113.36, the 4,000 dollars can be converted into Japanese currency as 4,000 dollars x 113.36 = 453,440 yen, as indicated by *3 on the exchange contract allocation screen in Fig. 4. Note that the rate shown in MA2 in FIG. 4 displays the value obtained from the rate master 106f in the initial display rate category set in the currency master 106d. Also, the rate classification shown in MA2 in FIG. 4 can be changed, and when "9: spot rate" is specified, the rate can be freely set.

On the exchange contract allocation screen in FIG. 4, the rate 114.12 is calculated by the average rate calculation unit 102d using the yen amount and the slip amount as follows when allocating a plurality of exchange contract detail data. average rate. That is, the average rate calculation unit 102d calculates the average rate = {total amount of yen allocated this time + (balance + 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 ÷ $10,000 = 114.12. The 114.12 is the bill rate.

Then, the calculated average rate (slip rate) 114.12 and the total amount in Japanese yen of 1,141,200 yen are overwritten on the sales input screen as shown in FIG. Note that the average rate (slip rate) 114.12 cannot be changed, as indicated by dotted hatching on the sales input screen in FIG. The calculated average rate (invoice rate) can be used to calculate the exchange gain/loss, etc., as described in [4-4] below.

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

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

Next, the update unit 102e updates the allocated amount of the exchange contract in the exchange contract data 106a as follows. That is, as shown in the exchange contract allocation screen in FIG. 4, the amount of the exchange contract allocated for the exchange contract number KWS001-003 was 7,000 dollars, but since 3,000 dollars has been newly allocated this time, the update unit 102e updates the allocated amount of the exchange contract with exchange contract number KWS001-003 to $7,000+$3,000=$10,000, as shown in the exchange contract data 106a in FIG. Similarly, as shown in the exchange contract data 106a in FIG. 6, the update unit 102e updates the allocated amount of the exchange contract with the exchange contract number KWS001-004 to $7,000+2,000=9,000 dollars. Update the allocated amount of forward exchange contracts for number KWS001-005 to $0 + $1,000 = $1,000.

In this way, the updating unit 102e updates the allocated amount of the exchange contract as needed, so that the allocation pattern of "Exchange contract N: Accounting slip M" described in [3-2] can also be handled. can. Specifically, an example will be described on the assumption that a slip amount of 3,000 dollars exists in addition to the slip amount of 10,000 dollars (that is, foreign exchange contract 3: accounting slip 2). Since the reserved amount of forward exchange contract number KWS001-003 has been updated to $10,000 as explained in the previous paragraph, the remaining amount that can be allocated for the forward contract detail data of forward contract number KWS001-003 is Subtract the updated reserved amount of $10,000 from the amount of $10,000, resulting in $0. Similarly, the balance that can be allocated for the exchange contract detail data of exchange contract number KWS001-004 is $20,000 - $9,000 = $11,000, and the balance that can be allocated for exchange contract detail data of exchange contract number KWS001-005 is , $30,000 - $1,000 = $29,000. Therefore, the slip amount of $3,000 can be allocated to the balance of $11,000 in the exchange contract detail data of the exchange contract number KWS001-004 or the balance of $29,000 in the exchange contract detail data of the exchange contract number KWS001-005.

[4-4. Calculation of exchange gain/loss]
Using the average rate (slip rate) calculated in [4-2], for example, when there is a partial payment in the relevant slip (for example, payment due to partial inspection), the profit and loss calculation unit 102f The exchange gain/loss can be calculated by the following formula. In other words, exchange gain/loss=(Cost of money received this time×Voucher rate)−(Foreign currency received this time×Payment rate).

A specific example of calculating the exchange profit/loss when payment is made before the sales slip is registered will be described. The conditions are as follows.
(conditions)
Sales Voucher Amount $4,000 Voucher Rate 114.12
Deposit amount $4,000 Deposit rate 113.36

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

[4-5. summary]
As described above, according to the appropriation work support device 100 according to the present embodiment, the exchange contract amount and the apportionment area for allocating the input foreign currency amount to the exchange contract amount , is displayed on the display unit, the allocation work can be supported so that the foreign currency amount can be allocated to a plurality of exchange contract amounts. As a result, for example, it is possible to simplify complicated management work and payment work for forward exchange contracts, and it is possible to reduce business risks such as payment errors.

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

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

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

In addition, regarding the allotment business support device 100, each constituent element shown in the figure is functionally conceptual, and does not necessarily need to be physically configured as shown in the figure.

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

In addition, this computer program may be stored in an application program server connected to the allotment business support device 100 via any network, and may be downloaded in whole or in part as necessary. It is possible.

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

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

The various databases stored in the storage unit are storage means such as memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks. It stores programs, tables, databases, files for web pages, and so on.

The allotment business 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 to which any peripheral device is connected. Also, the allotment business support device 100 may be realized by installing software (including programs, data, etc.) for realizing the processing described in the present embodiment.

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

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

100 Allocation work support device 102 Control unit
102a Acquisition unit
102b display execution unit
102c Warning output unit
102d average rate calculator
102e update unit
102f profit and loss calculation unit 104 communication interface unit 106 storage unit
106a Exchange contract data
106b Sales data
106c Scheduled collection data
106d Currency master
106e Rate Division Master
106f rate master 108 input/output interface unit 112 input device 114 output device 200 server 300 network

Claims (1)

An allocation work support device comprising a control unit and a display unit,
The control unit
From exchange contract data including a plurality of exchange contract detail data having the exchange contract amount, which is the amount of foreign currency contracted, and the rate at the time of reservation, which is the rate used to convert the foreign currency into Japanese currency and is the rate at the time of the exchange contract , acquisition means for acquiring exchange contract detail data that matches acquisition conditions for acquiring the exchange contract detail data;
the exchange contract amount included in the exchange contract detail data acquired by the acquisition means; display execution means for displaying on the display unit;
The average rate is calculated by dividing the sum of the Japanese currency amounts calculated by multiplying the foreign currency amount allocated to the rate at the time of reservation held by the foreign exchange contract detail data acquired by the acquiring means by the input foreign currency amount. Alternatively, the foreign currency amount calculated by multiplying the rate at the time of reservation held by the foreign exchange contract detail data acquired by the acquiring means by the allocated foreign currency amount, and the rate used to convert the foreign currency into Japanese currency. and the foreign currency amount calculated by multiplying the foreign currency amount obtained by subtracting the total amount of the allocated foreign currency amount from the foreign currency amount entered above by the spot rate to be used for the spot transaction. average rate calculation means for 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 by the average rate calculation means, the value obtained by multiplying the foreign currency deposit amount for the input foreign currency amount by the rate at the time of deposit of the said input foreign currency amount A profit and loss calculation means for calculating exchange profit and loss by subtracting;
to provide
Appropriation work support device characterized by

Images