BimpBlog

Purchase in Foreign Currency: Prepayment at One Rate, the Rest at Another, One Cost

Purchase in foreign currency: a USD contract, a 50% prepayment at one rate and the rest at another. A sample USD 10,000 case with cost and rate gap tables.

DO
Dmytro ObukhovCo-Founder & CEO
Table of contents
In short
  • A purchase in foreign currency has three separate amounts in the books: the debt to the supplier in the contract currency, the cost of the goods in the accounting currency at the receipt rate, and the money actually paid at the payment rates. The gap between the last two is the exchange difference, and it is shown apart from cost.
  • In the hypothetical example a manufacturer buys 4,000 kg of granules for USD 10,000. The prepayment of USD 5,000 is at a rate of 0.9000 EUR per USD, the remaining USD 5,000 at 0.9300, and the receipt at 0.9200. The cost is €9,200 (€2.30/kg), €9,150 was paid, and the exchange difference is €50.
  • In Bimp, the contract with the supplier sets the purchase currency, and the cost is calculated at the accounting rate of the receipt document. A mistake in the rate is fixed by reposting.
  • Bimp does not forecast the exchange rate and does not hedge the risk: the accounting rate has to be checked against the actual rate on the date of the operation.

A purchase in foreign currency consists, in the books, of three amounts: the debt to the supplier in the contract currency, the cost of the goods in the accounting currency at the receipt rate, and the money actually paid at the payment rates. The gap between the second and the third amount is the exchange difference, and it is shown apart from cost.

A manufacturer of plastic products pays a Turkish supplier in dollars. It sent the prepayment on Monday and added the rest three weeks later, when the rate had risen. The accountant asks which amount to put into the cost of the granules, and the manager compares it with the price list and sees a different margin. Below is a hypothetical example with full arithmetic. The company is invented.

How do you keep accounts for a purchase in foreign currency?

In Bimp the purchase currency is set by the contract with the supplier. Create a contract in USD or EUR, choose it in the supplier order, and the prices and the “Total” will show in the contract currency. The debt to the supplier is recorded in the same currency.

The sequence is this:

  1. A contract with the supplier in the right currency. If the contract is in the local currency while you buy in dollars, the debt and the cost will be recorded wrongly.
  2. A supplier order under this contract. For a foreign-currency contract the “Price list rate” equals the “Accounting rate”.
  3. Payment to the supplier: the prepayment and the balance as separate documents, with the settlement rate.
  4. A goods receipt, which brings the raw material into stock and forms the cost.

Rates come from the “Currencies/Rates” catalog. For each currency it has an internal rate (the basis of management reporting), a commercial rate and auto-load from the NBU or the interbank market. The detailed steps are in the help articles: Purchase in foreign currency and Currencies and rates.

What is an example of a foreign-currency purchase with a prepayment?

A manufacturer orders 4,000 kg of polypropylene granules at USD 2.50 per kg. Terms: a 50% prepayment, the rest after receipt. The contract is in USD. The accounting currency is the euro, and rates are shown as euros per 1 USD.

IndicatorValue
Quantity4,000 kg
PriceUSD 2.50/kg
Order amount4,000 × 2.50 = USD 10,000
Prepayment 50%USD 5,000
BalanceUSD 5,000

Next come two payments and the receipt, each at its own rate.

EventAmount, USDRate, EUR/USDEuros
Prepayment (payment to the supplier)5,0000.90004,500
Goods receipt (accounting rate of the document)10,0000.92009,200
Payment of the balance5,0000.93004,650

Check: 5,000 × 0.90 = €4,500, 10,000 × 0.92 = €9,200, 5,000 × 0.93 = €4,650.

How is the cost of the goods formed if there were two payments?

The cost is formed by the receipt. Bimp converts the value from the document currency into the accounting currency at the accounting rate of this document, so the granules are received at 10,000 × 0.92 = €9,200. Per kilogram that is 9,200 / 4,000 = €2.30.

The payment rates do not enter this amount. If you average them, you get (4,500 + 4,650) / 4,000 = €2.2875/kg, which is the value of the euros actually spent. The difference between the two figures goes through as an exchange difference.

IndicatorAmount, EURPer kg, EUR
Cost at the receipt rate9,2002.3000
Actually paid (4,500 + 4,650)9,1502.2875
Exchange difference500.0125

Check: 9,200 - 9,150 = €50, 50 / 4,000 = €0.0125 per kg. Let us break it down by payments. The prepayment at a rate below the receipt rate gave 5,000 × (0.92 - 0.90) = €100 of savings. The balance at a higher rate gave 5,000 × (0.93 - 0.92) = €50 of overpayment. Together 100 - 50 = €50 of savings.

In the example the company paid less than the goods cost in the books, so this is exchange difference income. If the rate had risen even higher after the receipt, the result would have become a loss. The total is visible in the Non-operating income/expenses report as separate items, and the gross profit of sales does not depend on it.

What happens if the receipt is posted at the prepayment rate?

A typical mistake: the receipt is entered at the rate of the first payment, 0.9000. Then the cost looks like this:

Rate in the receiptCost, EURPer kg, EURDeviation from €2.30 per kg
0.9200 (by the receipt date)9,2002.300
0.9000 (prepayment rate)9,0002.25-0.05 (-€200 per batch)

Check: 10,000 × 0.90 = €9,000, 9,000 / 4,000 = €2.25, 4,000 × 0.05 = €200. A product made from such raw material will come out cheaper than it should, and the margin on paper will grow. The help article advises checking the rate in the order against the actual rate on the date of the operation, and that technique works here.

If the mistake is found after sales, fix the document and repost the period. Bimp runs the mass recalculation automatically after midnight, and to update at once, open the sales document in Sales → Sales and post it again. The procedure is described in the article Cost recalculation. How the same rate affects selling prices is covered in the article about price recalculation when the exchange rate changes.

Do you need a separate contract in each currency?

Yes, for every currency of settlement with a supplier you need your own contract. The contract currency determines what Bimp keeps the debt in, what it shows the prices in the order in, and at what rate it converts the amounts for the cost. If one supplier ships in both euros and dollars, create two contracts and choose the right one in the order.

Before posting a document, the buyer checks three things: the currency of the selected contract, the currency code next to the price in the “Price” column and the “Total” in the contract currency. In the example it is USD 2.50 next to each kilogram and USD 10,000 in the total. If the price shows EUR, the contract was chosen wrongly, and the debt and the cost would be calculated incorrectly.

What should you check every month so the exchange difference is not a surprise?

The accountant reconciles the payment rates with the receipt rate for each foreign-currency purchase. The buyer looks at which orders are waiting for payment of the balance, because the result depends on the rate on the day of payment. The owner looks at the exchange difference as a separate line and does not mix it with the margin of sales.

For the USD 10,000 example the rule is this: each 0.01 EUR of rate difference on a paid USD 5,000 gives €50 on the prepayment or on the balance. If the balance is paid at 0.9400 instead of 0.9300, the difference becomes 5,000 × (0.94 - 0.92) = €100 of overpayment, and together with the prepayment the exchange result equals 100 - 100 = €0.

How do you fix the rate for a period?

If the company works at an internal rate for a year, fix it. Open the currency card, choose “No updates” in the two auto-load fields (commercial and internal rate), and on the “Exchange rates” tab set the rates and the start date. Orders, receipts and payments are then calculated at one value, and there is no extra difference between documents.

A fixed rate suits a budget and management reporting. The bank still debits money at its own rate, and the purchase of currency for a payment is recorded with the Currency exchange document: it calculates the cross rate and shows the exchange difference.

How do you account for customs duty and delivery?

The order and the payment to the supplier record only the value of the goods in foreign currency. Customs duty, import taxes, broker services and transport are added separately: additional costs are allocated to the batch and raise the cost. The full calculation with duty, a broker and delivery, using the example of film from Turkey, is in the article about the cost of imported raw materials with customs duty. This article covers only the exchange rate component.

What Bimp does and does not do

Bimp is a Ukrainian cloud ERP for manufacturers. For a foreign-currency purchase it keeps a foreign-currency contract with the supplier, shows the prices and the order amount in the contract currency, keeps the debt in that currency, lets you enter payments with a settlement rate, calculates the cost in the accounting currency at the rate of the receipt document and shows exchange differences. The currency catalog has internal and commercial rates, auto-load from the NBU or the interbank market and the option to fix a rate for a period. The procurement block is described on the Procurement and suppliers page.

The limits are these. Bimp does not forecast the exchange rate, does not hedge currency risk and does not buy currency automatically. The accounting rate in a document is set by the system from the catalog, so it has to be checked against the actual rate on the date of the operation. Changed rates apply to future operations, and posted documents of past periods are not recalculated automatically. Bimp keeps management accounting: the tax treatment of exchange differences and the reporting for the authorities are kept separately.

In the example USD 10,000 gave a cost of €9,200 (€2.30/kg) and an exchange difference of €50 outside cost. A mistake in the receipt rate shifts the cost by the rate difference multiplied by the foreign-currency amount: 0.02 EUR × USD 10,000 gave €200.

FAQ

How do you keep accounts for a purchase in foreign currency?

Make a contract with the supplier in the purchase currency, create the order and the receipt under this contract and enter payments in that currency. The system keeps the debt to the supplier in the contract currency, and the cost of the goods is calculated in the accounting currency at the receipt rate.

What is an exchange difference on an import?

It is the gap between the value of the purchase in the accounting currency at the receipt rate and the money actually paid at the payment rates. If less was paid, it is income, if more, it is an expense. It is not part of the cost of the goods.

How do you fix the rate so there is no exchange difference in documents?

In the Currencies/Rates catalog choose "No updates" for auto-load for the currency and set the internal and commercial rates for the period you need, for example a year. New rates apply to future operations, and posted documents do not change.

What if the receipt was posted at the wrong rate?

Fix the document and repost the period. Bimp recalculates the cost in outgoing documents automatically after midnight, and to see the result at once, open the sales document and post it again.

Where is the exchange difference shown?

In the Non-operating income/expenses report, exchange differences are shown as separate items, outside cost and gross profit.

We will show a foreign-currency purchase on your contract

In a Bimp ERP demo, a specialist sets up a foreign-currency contract, an order, a receipt and payments at two rates and shows how the cost and the exchange difference are formed.

Book a demo
DODmytro ObukhovCo-Founder & CEO