Invoicing in a foreign currency: how it is reported and recorded
Invoicing in a foreign currency: how it is reported and recorded
You issued the invoice in dollars, the customer paid three weeks later, and the books showed a profit nobody sold. That is not a system error: it is the gap between the rate used to measure the revenue on the invoice date and the rate at which the cash actually arrived. Invoicing in a foreign currency does not change the tax; it changes when the tax is measured.
What can be invoiced in a foreign currency
The invoice currency is a commercial decision, not a special permit. A Colombian company may agree and invoice in dollars or in another currency as long as the document states the currency and the exchange rate applied. Three scenarios are typical: exports of goods, exports of services, and local contracts where payment was agreed in a foreign currency because the supply chain requires it.
What does change is the tax obligation. The DIAN reads pesos: tax accrues in the functional currency, which for nearly every small and medium business is the peso. The dollar invoice and the peso return are not independent documents; they are two readings of the same economic event.
Invoicing in a foreign currency is not the same as collecting in one. A contract may be stated in dollars and settled in pesos at the equivalent of the day. If that conversion clause does not exist, the customer pays what he believes he owes and the argument ends in a credit note.
The exchange rate to use, and why it is not the rate on collection day
The default reference is the official market rate (TRM), certified by the Financial Superintendency with daily validity. It is not a company average and it is not the rate printed on the bank statement: it is a single official figure, identical for every taxpayer, and the one that applies is the rate in force on the date of the economic event.
The reason is accounting before it is tax. Revenue is recognized when the right to collect arises, not when payment arrives, and it is measured at that day's rate. If payment arrives at a different rate, revenue is already closed and a new effect appears: the exchange difference. Mixing the two moments produces inflated revenue in some months and false margins in others.
| Moment | Rate applied | Accounting effect |
|---|---|---|
| Invoice issued | TRM on the invoice date | Revenue and receivable in pesos; VAT accrues in pesos |
| Payment in full or in part | TRM on the payment date | Cash comes in and the exchange difference arises |
| Period close | TRM on the closing date | Monetary items still outstanding are restated |
| Payment to a supplier in a foreign currency | TRM on the payment date | Cash goes out; the difference hits the payable |
A company that prefers an internal rate — the monthly average or the rate negotiated with its bank — may use it, but then it stops being a free practice and becomes a policy that must be documented and applied identically to every transaction of the same kind.
Initial recognition: revenue, VAT and the receivable
On a 10,000 dollar invoice at an assumed TRM of 4,000 pesos per dollar, the taxable base is 40,000,000 pesos. If the transaction is subject to 19 % VAT — a percentage used here only as an exercise assumption and one that must be verified for the specific good or service — the tax is 7,600,000.
The entry is this: debit the receivable for 47,600,000 (base plus VAT), credit revenue for 40,000,000 and credit VAT payable for 7,600,000. The dollar disappears from the ledger. What remains alive is a receivable in pesos, which is exactly why a parallel control in the foreign currency is needed: the system no longer remembers that the customer owes 10,000 dollars.
VAT does not generate an exchange difference because it was fixed in pesos on day one. It is a liability to the DIAN, not to the customer, and it is not restated.
Advances are a separate case. A down payment received before the invoice is converted at the rate in force when it arrives, and when the invoice is issued it may generate its own difference, because it is compared against the invoice rate.
A complete example: 10,000 dollars at two rates
Invoice dated March 5 for 10,000 dollars, assumed TRM of 4,000 pesos per dollar.
- Taxable base: 10,000 × 4,000 = 40,000,000 pesos.
- Assumed 19 % VAT: 40,000,000 × 0.19 = 7,600,000 pesos.
- Total invoiced: 40,000,000 + 7,600,000 = 47,600,000 pesos.
- Collected on April 5 at a TRM of 4,200: 10,000 × 4,200 = 42,000,000 pesos.
- Exchange difference: 42,000,000 − 40,000,000 = 2,000,000 of income.
Had the rate fallen to 3,900, collection would have been 39,000,000 and the difference 1,000,000 of expense. The sign is decided by which side of the balance sheet holds the item, not by the fortunes of the business.
| Scenario | TRM on collection | Pesos received | Difference | Nature |
|---|---|---|---|---|
| The rate rises | 4,200 | 42,000,000 | 2,000,000 | Income |
| The rate does not move | 4,000 | 40,000,000 | 0 | No effect |
| The rate falls | 3,900 | 39,000,000 | −1,000,000 | Expense |
| Partial collection and close | 4,200 and 4,150 | 25,200,000 + 16,600,000 | 1,800,000 | Income |
The last row is the realistic one. Of the 10,000 dollars, 6,000 are collected at 4,200: 25,200,000 pesos, a difference of 1,200,000 against a base of 24,000,000. The remaining 4,000 dollars carry a base of 16,000,000; at the close, at 4,150, they are worth 16,600,000 and add 600,000. Both differences total 1,800,000, and what was collected plus the restated balance totals 41,800,000 against the original 40,000,000.
Exchange difference: when it is income and when it is expense
The rule is mechanical: it depends on which side of the balance sheet the item sits. On an asset in a foreign currency, such as a receivable, a rising rate makes the asset worth more in pesos and produces income. On a liability in a foreign currency, a rising rate means more pesos are owed and produces expense. A falling rate reverses both.
That result is not operating revenue. Nothing extra was sold and no margin improved: the price of a currency moved. It belongs in a separate line, within non-operating or financial results, and it is disclosed in the notes when material.
| Situation | Effect | Where it is recorded | Warning sign |
|---|---|---|---|
| Receivable in a foreign currency, rate rises | Income | Period result | If recurring, the price is set wrong |
| Receivable in a foreign currency, rate falls | Expense | Same line, opposite sign | Margin erodes without volume falling |
| Payable in a foreign currency, rate rises | Expense | Period result | Supplier cost grows after negotiation |
| Payable in a foreign currency, rate falls | Income | Period result | Temporary relief that must not be budgeted |
Do not net by eye. With receivables and debt both in dollars it is tempting to offset the two effects and book only the balance, but they are items with different maturities. Netting hides the risk and complicates the audit.
Restating outstanding items at period close
At the end of the period, whatever remains outstanding in a foreign currency is measured again at the closing TRM. It applies to monetary items — rights and obligations settled in a fixed amount of money: cash held in a foreign currency, receivables, payables and loans. Inventory and machinery stay at historical cost.
If the full 10,000 dollars were still outstanding on December 31 and the closing TRM were 4,150, the receivable would move from 40,000,000 to 41,500,000 and the adjustment would be 1,500,000 of income, without a single peso coming in.
When payment comes later, avoid double counting. The difference recognized on collection runs from the last measurement to the payment rate, not from the invoice. If 1,500,000 was already recognized at the close and the payment totals 42,000,000, the difference for the new period is 500,000, not 2,000,000.
Then there is the tax question: the treatment of an unrealized difference does not always match the accounting treatment, and the conditions change. Before carrying it into the return, confirm it with your accountant and check the rules in force for the year.
Withholding when payment arrives in dollars
Withholding tax is applied to the peso value at the payment date rate, not the invoice rate. It is withheld on what is actually paid. At an assumed 3.5 % rate, the 42,000,000 in the example would carry 1,470,000 pesos of withholding. Computed at the invoice rate it would have been 1,400,000, and those 70,000 show up as a mismatch on the certificate.
VAT is withheld too, depending on the customer's regime, on the VAT accrued in pesos, which did not change with the rate. At an assumed 15 %, that is 1,140,000 pesos.
The net amount reaching the account is 42,000,000 − 1,470,000 − 1,140,000 = 39,390,000 pesos, before bank fees. If the statement shows anything else, the cause is a fee, a miscalculated difference or withholding on the wrong base.
If the customer pays from a foreign account there is no Colombian withholding: the export regime applies and the obligations are different. And the certificate must show the base and the rate used; if the customer withheld at the invoice TRM, the documents will not reconcile.
Reconciling the foreign currency invoice with the peso statement
Reconciliation is not done by comparing totals; it is done by building a bridge. Start from the peso equivalent at the payment rate, 42,000,000, and subtract the items that explain the distance to the actual deposit.
- Exchange difference: it runs from the invoiced base to the payment rate. It is not a cash outflow and must not be subtracted from the deposit.
- Withholding: it leaves the flow before the money arrives. It is supported by the certificate and cross-checked against the return.
- Bank fees: a different expense. A 60,000 peso fee is not an exchange difference.
The expected deposit is 42,000,000 − 1,470,000 − 1,140,000 − 60,000 = 39,330,000 pesos. If the statement shows something else, track it down rather than adjusting it against revenue: the statement is the source of cash, not of revenue.
How exchange risk is controlled
The risk is not in invoicing in dollars; it is in the time between invoice and collection. With 10,000 dollars outstanding and a 100 peso move, the effect is 1,000,000 pesos without anyone making a commercial decision. Multiplying the outstanding balance by the possible move gives the size of the problem.
The tools are few. Shortening collection terms narrows the window. Taking an advance shifts part of the risk to the customer. Paying suppliers in the same currency offsets the exposure. And hedging contracts with financial institutions fix a future rate, useful when the amount is large and the term long.
Improvising does not work. Repricing according to how the rate opened, with no written rule, leaves unhappy customers and a price history nobody can audit. And whoever sells should not decide the hedge: treasury manages the exposure, the commercial team sets the price.
The written rate policy: what it must say
A foreign currency forces a written decision on which rate applies at each moment. That document separates an orderly practice from a series of isolated calls. It does not need to be long; it needs to be specific and approved.
- Which rate applies on issue: the TRM on the invoice date, with no exceptions unless approved.
- Which rate applies on payment and on the closing restatement, and what cutoff time is used.
- Who may approve an exception and how it is documented.
- Which line of the income statement carries the realized and unrealized difference.
- How the foreign currency balance is controlled outside the accounting system, and who reviews it.
- How often reconciliation is done and what evidence is kept.
Without that document every invoice becomes a different criterion. Auditors and the tax administration ask the same question: at which rate was it measured, and why. The answer belongs in a file, not in the memory of the clerk who has moved on.
Frequent errors
These five errors explain almost every discrepancy found when a foreign currency receivable portfolio is reviewed. The useful part is spotting the symptom before the consequence reaches the income statement.
| Error | Symptom | Consequence | Correction |
|---|---|---|---|
| Recording revenue at the collection rate | Monthly revenue matches cash, not billings | Inflated revenue and a difference that never appears | Recognize at the issue TRM |
| Not restating the receivable at close | Foreign currency balance does not match the peso balance | Financial statements that misstate the right to collect | Restate monetary items |
| Parking the difference in other income with no detail | A residual account that grows every month | Distorted operating result | Use a dedicated line per invoice |
| Computing withholding at the invoice rate | The customer's certificate does not match the deposit | Differences in the return | Withhold at the payment rate |
| Invoicing in dollars with no rate policy | Each invoice was booked on a different basis | A history that cannot be compared | Approve the policy and keep the evidence |
There is a sixth error that is one of reading rather than recording: treating the exchange difference as business profit. A month with exchange income can be a month of weak operating margin, and whoever celebrates the first without looking at the second sets prices on bad information.
Documents that support the figure
Every foreign currency figure must be reconstructable months later. The minimum package per transaction is short: the invoice with currency and rate stated, the record of that day's TRM, the bank statement for the deposit, the withholding certificate and the difference calculation with its arithmetic in plain sight.
Add the contract where the currency was agreed, which answers the underlying question: why this transaction was set in dollars. How long these records must be kept is set by the rules and changes over time; verify the term in force for the year.
An honest closing note before you decide
Invoicing in a foreign currency is not complicated, but it demands discipline in three places: a rate defined for each moment, a separate record of the financial effect, and a reconciliation that explains every peso that comes in.
This does not apply equally to everyone. A company that invoices in a foreign currency twice a year can handle it with a spreadsheet and a one-page policy. One that invoices in dollars every week needs the system to carry the balance in both currencies. And if there are transactions with related parties abroad, additional documentation rules apply that this article does not cover.
None of this replaces the accountant: how the difference is presented and how it is treated in the return depends on the case and on the rules in force for the year. What can be automated is the record keeping: a system that stores the invoice in both currencies, applies the rate of each moment and shows the difference per transaction removes the most time-consuming part of the close. Kardex Tauro supports that invoicing and receivable control in both currencies, so the month-end discussion is about the business and not about which rate was used.
