EN
e-Invoice and Tax

How to Issue a Foreign Currency Sales Invoice and Calculate the Exchange Rate Difference? Training on Currency, Invoice Rate, Partial Collection, Period-End Valuation and Currency Risk

How do you issue a foreign currency sales invoice and calculate the exchange rate difference? Currency, invoice rate, partial collection and period-end valuation: an 8-lesson guide with examples.

Contents 14 sections
  1. What will you be able to do by the end of this training?
  2. Lesson 1: What is a foreign currency sale, and why does an exchange rate difference arise?
  3. Lesson 2: How do you choose the currency and the rate?
  4. Lesson 3: How do you issue a foreign currency invoice step by step?
  5. Lesson 4: How is the exchange rate difference calculated?
  6. Lesson 5: How is the exchange rate difference calculated on a partial collection?
  7. Lesson 6: How is an open foreign currency receivable valued at the end of the period?
  8. Lesson 7: How is currency risk reflected in the price?
  9. Lesson 8: How do you set up a period-end routine for foreign currency sales?
  10. What are the most common mistakes in foreign currency sales?
  11. How does NetKasam make tracking foreign currency sales easier?
  12. Mini quiz: Test what you have learned
  13. Conclusion: List your open foreign currency receivables this week
  14. Frequently Asked Questions About Foreign Currency Sales Invoices and Exchange Rate Differences

You sold goods worth 5,000 euros to a buyer abroad, and on the day you issued the invoice the rate was 36.00. The money reached your account three weeks later, by which time the rate had become 37.50. Your books showed a receivable of ₺180,000, but ₺187,500 came into the bank. What is the ₺7,500 in between? Is it income from the sale or a separate item? If the rate had moved the other way, would the same amount have shown up as a loss? The account balances, cash and profit calculation of a business that sells in foreign currency depend on the answers to these questions.

This article is not a narrative but an 8-lesson hands-on training. We will answer the question how to issue a foreign currency sales invoice and calculate the exchange rate difference with numbers: choosing the currency and rate, the steps of a foreign currency invoice, the exchange rate difference on a single payment and on partial payments, valuing the open balance at period end, reflecting currency risk in the price, and the period-end routine. At the end there is a mini quiz with an answer key. The rates and amounts in this article are example values; consult your certified public accountant (mali müşavir) for tax consequences.

What will you be able to do by the end of this training?

In short: You will choose the currency and rate correctly on a foreign currency invoice, calculate the exchange rate difference on single and partial collections, value the open foreign currency receivable at period end, and reflect currency risk in your price.

Training mapThe six steps of a foreign currency sale
  1. 01
    Rate selectionSet the currency and the invoice rate.
  2. 02
    InvoiceIssue the foreign currency invoice and state its TL equivalent.
  3. 03
    AccountThe receivable is tracked in both foreign currency and TL.
  4. 04
    CollectionRecord the rate of each payment.
  5. 05
    Exchange rate differenceCalculate the difference between the invoice rate and the collection rate.
  6. 06
    Period endValue the open balance at the period-end rate.

The 8 lessons of the training: (1) foreign currency sales and the exchange rate difference, (2) choosing the currency and rate, (3) foreign currency invoice steps, (4) calculating the exchange rate difference, (5) partial collection, (6) period-end valuation, (7) currency risk and price, (8) period-end routine.

Lesson 1: What is a foreign currency sale, and why does an exchange rate difference arise?

In short: A foreign currency sale is one where the invoice is issued in a currency other than TL. Because the rate changes during the time between the invoice and the collection, the TL value of the receivable also changes; this change is the exchange rate difference.

ConceptMeaningExample
Foreign currency amountThe foreign currency amount on the invoice5,000 EUR
Invoice rateThe rate on the day the invoice is issued36,00
TL equivalentForeign currency amount × invoice rate180.000 ₺
Collection rateThe rate on the day the money arrives37,50
Exchange rate differenceCollection TL amount − invoice TL amount+7.500 ₺

The exchange rate difference is not a business error; it is the natural result of rate movements. The error is leaving this difference uncalculated or merging it with the sales profit. If you sell abroad, see the article how to set prices on international marketplaces for the pricing side. Example business: a small exporter that sells TL-cost products to four foreign buyers in euros.

The direction of the exchange rate difference works in reverse for receivables and payables. If you have a receivable in foreign currency, you gain when the rate rises and lose when it falls. If you have a payable in foreign currency (for example, you will pay a foreign supplier in euros), the TL equivalent of your payable increases when the rate rises and you lose. That is why you need to track not only sales but also foreign currency purchases with the same discipline.

Lesson 2: How do you choose the currency and the rate?

In short: Set the currency to be written on the invoice in the contract or order with the buyer; take the rate for the day the invoice is issued, from the same source every time.

DecisionHow?Risk of error
CurrencyThe currency in the order or contractChoosing a different currency on the invoice
Rate sourceAlways the same official or accepted sourceUsing a different source from day to day
Rate dateThe invoice issue dateIssuing the invoice at the order day's rate
RoundingFix how many decimal places of the rate you will useDifferent decimal places on the invoice and the statement

NetKasam's e-Invoice page also states that the rate and currency must be chosen correctly in foreign currency sales. Which rate you use (for example, which institution's rate at what time) is a matter of tax legislation; make this choice together with your accountant and set it down as a written internal rule. Once the rule is set, everyone on the team acts the same way and there is no month-end debate over "which rate was this invoice issued at."

If the order date and the invoice date differ, clarify in advance which rate applies. For example, if you fixed the rate with the buyer on the order date, keep this in writing in the contract or order; if you did not fix it, the invoice day's rate applies and an exchange rate difference arises naturally. For the invoicing deadline, see the article within how many days must an invoice be issued; issuing the invoice late also shifts the rate choice.

Product pageFree Bookkeeping Software

Lesson 3: How do you issue a foreign currency invoice step by step?

In short: Select the account, enter the currency and the rate, enter the line items at foreign currency prices, check the TL equivalent and issue the invoice as an e-Invoice or e-Archive invoice.

StepTo doControl
1Select the accountAre the company name, tax number and country correct?
2Select the currencyIs it the same as in the order?
3Enter the rateIs it the invoice day's rate from the same source?
4Enter line items at foreign currency pricesQuantity × unit price = line amount
5Check the TL equivalentForeign currency total × rate = TL total
6Issue the invoiceAre the currency and rate visible on the document?

In NetKasam you can create invoices in different currencies. After issuing the invoice, check the amount posted to the customer account; the TL equivalent you get by multiplying the foreign currency amount by the recorded rate must match the invoice. The invoice type (e-Invoice or e-Archive) depends on the buyer's status; for details, see the invoice tracking and e-Invoice pages. The type and tax framework of an invoice issued to a buyer abroad is a special case; consult your certified public accountant (mali müşavir).

Lesson 4: How is the exchange rate difference calculated?

In short: The exchange rate difference is the foreign currency amount multiplied by the difference between the collection rate and the invoice rate. On a receivable, income arises if the rate rose and an expense arises if it fell.

FormulaThe four formulas of a foreign currency sale
  1. TL equivalent = Foreign currency amount × Invoice rate
  2. Collection TL amount = Foreign currency amount × Collection rate
  3. Exchange rate difference = Foreign currency amount × (Collection rate − Invoice rate)
  4. Exchange rate difference ratio = Exchange rate difference ÷ TL equivalent × 100

Prepared with sample values.

ChartA 5,000 EUR invoice: ₺180,000 recorded, ₺187,500 collected
  1. TL equivalent on the invoice (5,000 × 36.00)₺180,000
  2. Exchange rate gain (5,000 × 1.50)₺7,500
  3. TL collected (5,000 × 37.50)₺187,500

Prepared with example values. Exchange rate difference ratio: 4.2% (7,500 ÷ 180,000).

ScenarioCollection rateTL collectedExchange rate difference
Rate rose37,50187.500 ₺+₺7,500 (income)
Rate unchanged36,00180.000 ₺0 ₺
Rate fell35,00175.000 ₺−₺5,000 (expense)

The table shows the result of the same invoice at three different collection rates. The sale itself does not change in any scenario: the goods are the same, the invoice is the same. Only the TL value of the money changes. So do not interpret the exchange rate difference as sales profit or loss; measure the success of the sale at the invoice rate.

If the exchange rate difference is calculated correctly, three amounts must reconcile: the TL equivalent on the invoice, the TL collected and the exchange rate difference between them. In the example, 180,000 + 7,500 = ₺187,500. If this equality does not hold, either the rate was entered incorrectly or part of the collection was mixed up with another item. For matching on the bank side, see the article how to do a bank reconciliation.

Lesson 5: How is the exchange rate difference calculated on a partial collection?

In short: Record each collection separately at its own rate and calculate the exchange rate difference for each part separately. The total exchange rate difference is the sum of the parts.

Example: Of a 5,000 EUR invoice, 2,000 EUR was collected at a rate of 37.00 and 3,000 EUR at a rate of 38.00. The invoice rate is 36.00.

CollectionCurrencyRateTL collectedExchange rate difference
1st collection2,000 EUR37,0074.000 ₺2.000 ₺
2nd collection3,000 EUR38,00114.000 ₺6.000 ₺
Total5,000 EUR–188.000 ₺8.000 ₺
ChartOf the 5,000 EUR receivable, 2,000 was closed in the first collection and 3,000 in the second
  • 1st collection (37.00)₺2,00040%
  • 2nd collection (38.00)₺3,00060%

Prepared with sample values.

ChartExchange rate gain: larger on the second collection because the rate is higher
  1. 1st collection (2,000 EUR)₺2,000
  2. 2nd collection (3,000 EUR)₺6,000

Prepared with example values. Total exchange rate difference: ₺8,000; check: 180,000 + 8,000 = ₺188,000.

Don't forget the check: the total TL collected (₺188,000) equals the invoice TL equivalent (₺180,000) plus the total exchange rate difference (₺8,000). The most common mistake on partial collections is multiplying the whole amount by a single rate, when each part has a different rate. If you also track the account in foreign currency, it is clear how many euros of the open balance remain (0 EUR after collection in this example). For the basics of account tracking, see the article how to track customer and supplier accounts.

Recommended ReadingHow to Set Prices on International Marketplaces?

Lesson 6: How is an open foreign currency receivable valued at the end of the period?

In short: At the end of the period, recalculate the uncollected foreign currency receivable at the period-end rate. The difference is an exchange rate difference that has not yet been realized; decide with your accountant how to record it.

Example: In December, a 1,500 EUR invoice was issued at a rate of 36.00 (₺54,000) and was not collected by the end of the period. The period-end rate is 38.40.

ItemAccountAmount
Recorded TL equivalent1.500 × 36,0054.000 ₺
Period-end TL value1.500 × 38,4057.600 ₺
Unrealized exchange rate difference57.600 − 54.000+3.600 ₺

This difference is an amount that has not yet been collected, that is, it is unrealized. The rate may change again before the money arrives. Whether and how the valuation entry is made depends on tax and accounting regulations; that is why giving your accountant a list of open foreign currency receivables (foreign currency amount, recorded rate) at period end is the safest way. For the order of the period-end close, see the article how to do a month-end close.

Three columns are enough for a period-end valuation list: account name, open foreign currency amount and the rate on the invoice. When you add the period-end rate next to them, the difference appears on its own. In NetKasam you can produce this list by filtering account statements and invoices, and export it to Excel from the reports screen.

Lesson 7: How is currency risk reflected in the price?

In short: If your cost is in TL and your selling price is in foreign currency, your margin shrinks when the rate falls. Know your break-even rate and set your price with a safety margin above that rate.

Example: The TL cost of a 5,000 EUR sale is ₺140,000 (including goods, shipping and commission). Break-even rate = 140,000 ÷ 5,000 = 28.00. At an invoice rate of 36.00, the margin is ₺40,000 (22.2%).

Collection rateTL collectedCostProfitMargin
36,00180.000 ₺140.000 ₺40.000 ₺%22,2
34,00170.000 ₺140.000 ₺30.000 ₺%17,6
32,00160.000 ₺140.000 ₺20.000 ₺%12,5
28,00140.000 ₺140.000 ₺0 ₺%0

When the rate falls from 36 to 32 (about 11%), the margin drops from 22.2% to 12.5%; profit is nearly halved. Knowing how far you are above the break-even rate shows how much of a rate drop you can withstand. For the basics of margin calculation, see the articles how to calculate profit margin and how to calculate the break-even point.

Here is how you apply this to your price list: calculate the foreign currency price that delivers the target margin over the TL cost, add a reasonable drop in the rate (for example 5%) to this calculation, and update the price list when the rate moves significantly. If you sell in multiple languages and currencies, the Global Plus plan includes multi-currency support and an automatic currency conversion module; for the current scope, see the pricing and multi-language pages.

Takeaways from the exampleThe example in four numbers
  • ₺180,000TL equivalent on the invoice (5,000 EUR × 36.00)
  • +₺7,500exchange rate gain on a single payment
  • +₺8,000total exchange rate difference on partial collection
  • 28.00break-even rate (140,000 ÷ 5,000)

Lesson 8: How do you set up a period-end routine for foreign currency sales?

In short: Do the same five checks every month: open foreign currency receivables list, collection rates, exchange rate difference, period-end valuation and break-even rate.

When?What to do?Who?
Every invoiceCheck the currency and rateWhoever issues the invoice
Every collectionRecord the collection rate, calculate the exchange rate differenceAccounting
End of weekReview open foreign currency receivablesAccounting
Month-endValue the open balance at the period-end rate, give the list to the accountantAccounting
Once a quarterReview the break-even rate and the price listManagement

You can use the reports screen to save reports and export them to Excel; a report saved with the same criteria is pulled under the same conditions every month. When a buyer delays payment, apply the method in the article how to track receivables to foreign currency receivables too: the longer the delay, the bigger the currency risk.

In account reconciliations with foreign currency buyers, the difference also often comes from the rate: you may see the receivable at the invoice rate, while the buyer sees it at the rate of their own recording date. That is why you should state the balance in both foreign currency and TL in the reconciliation letter and specify which date's rate it was calculated at. For how to find and close differences, see the article how to find and close account reconciliation differences.

Recommended ReadingHow to Calculate Profit Margin?

What are the most common mistakes in foreign currency sales?

  1. Issuing the invoice in the wrong currency. When the order is in euros and the invoice in dollars, the buyer objects.
  2. Issuing the invoice at the order day's rate. The invoice day's rate should be used; if you fixed the rate, keep it in writing.
  3. Using a different rate source every time. The figures become internally inconsistent.
  4. Multiplying a partial collection by a single rate. Each part has its own rate.
  5. Adding the exchange rate difference to sales profit. The success of the sale then cannot show real performance.
  6. Not valuing the open receivable at period end. The receivable on the balance sheet does not reflect its current value.
  7. Not knowing the break-even rate. When the rate falls, the moment you start losing money goes unnoticed.

How does NetKasam make tracking foreign currency sales easier?

  • Invoices in different currencies. Foreign currency invoices are issued; the currency and rate are selected (invoice tracking).
  • e-Invoice and e-Archive. The invoice is issued from a single screen according to the buyer's status (e-Invoice).
  • Invoices linked to the customer account. Unpaid amounts appear in the customer's open balance and decrease as collections come in.
  • Online statement. Invoices and transactions are shared with the customer.
  • Reports and Excel. Filtered reports are saved, exported to Excel and shared with the accountant.
  • Multi-currency. The Global Plus plan includes multi-currency support and an automatic currency conversion module.
  • Bookkeeping is free. Bookkeeping, including invoice tracking and reports, is free; for the scope, see the pricing page.

Mini quiz: Test what you have learned

In short: Answer the 5 questions below, then compare with the answer key. 4 or 5 correct shows you have completed the training.

  1. A 2,000 USD invoice was issued at a rate of 30.00 and collected at 31.50. What is the exchange rate difference?
  2. An 800 EUR invoice was issued at a rate of 36.00 and collected at 35.00. What is the exchange rate difference?
  3. A 1,000 EUR receivable is recorded at a rate of 36.00, and the period-end rate is 38.00. What is the unrealized exchange rate difference?
  4. What is the break-even rate of a 3,000 EUR sale with a TL cost of ₺90,000?
  5. Why is each part calculated at a separate rate on a partial collection?

Answer key:

  1. 2,000 × (31.50 − 30.00) = ₺3,000 exchange rate gain.
  2. 800 × (35.00 − 36.00) = −₺800; exchange rate loss.
  3. 1,000 × (38.00 − 36.00) = ₺2,000 (unrealized).
  4. 90.000 ÷ 3.000 = 30,00.
  5. Each collection happens on a different day at a different rate; multiplying by a single rate misstates the exchange rate difference.

Frequently Asked Questions About Foreign Currency Sales Invoices and Exchange Rate Differences

How is the exchange rate difference calculated?

It is the foreign currency amount multiplied by the difference between the collection rate and the invoice rate: Foreign currency amount × (Collection rate − Invoice rate). On a receivable, a rise in the rate creates income and a fall creates an expense.

Can you issue an invoice in a foreign currency in NetKasam?

Yes, you can create invoices in different currencies. Take care to choose the currency and the rate correctly.

Should the exchange rate difference be tracked separately from the sales profit?

Yes. The profit on a sale is measured at the invoice rate; the exchange rate difference is a separate result that arises over time. Mixing them gives a wrong picture of performance.

Which exchange rate should be used on the invoice?

This depends on tax legislation; agree with your certified public accountant (mali müşavir) on which source and which day's rate to use, and apply the same rule consistently.

How is the exchange rate difference calculated on a partial collection?

Each collection is calculated separately at its own rate; the total exchange rate difference is the sum of the parts.

What happens to an open foreign currency receivable at the end of the period?

It is recalculated at the period-end rate to find the unrealized exchange rate difference; how it is recorded depends on accounting regulations, so consult your accountant.

How does the exchange rate difference work on a foreign currency payable?

The opposite of a receivable: if the rate rises, the TL equivalent of the payable increases and an exchange rate loss arises; if the rate falls, a gain arises.

What is the break-even exchange rate?

It is the lowest rate the sale can withstand before turning into a loss, found by dividing the TL cost by the foreign currency sales amount.

Conclusion: List your open foreign currency receivables this week

If you sell in foreign currency, do this today: list all uncollected foreign currency invoices and write the foreign currency amount, invoice rate and invoice date side by side. Add today's rate next to them; for each receivable you will see the potential exchange rate difference and how far you are from the break-even rate. This small table guides both collection follow-up and price updates at a glance. When the next invoice is issued, tie the rate and currency to an internal rule as well; most inconsistencies are prevented right at the start.

Bookkeeping Is Now Completely Free

Manage your bookkeeping and e-Invoice operations with NetKasam without paying a thing. Customer and supplier accounts, inventory, collections and more in one panel, completely free.

Start FreeFree Bookkeeping Software

Read similar articles

19 free tools

Commission, shipping, VAT and profit calculations in your browser, no sign-up needed.

All tools