---
title: "HMRC exchange rates lookup | Clara Global"
description: "Look up HMRC monthly customs and VAT exchange rates by currency and period, then convert in your browser with the source attached."
canonical: "https://www.clara.com/global/tools/hmrc-exchange-rates"
lang: "en-US"
alternate_html: "https://www.clara.com/global/tools/hmrc-exchange-rates"
---

# HMRC exchange rate lookup

Pick a currency and a period, convert the amount, and keep the rate, the period, and the HMRC source attached to the result.

[Try the live demo (opens in a new tab)](https://global.clara.com/demo?utm%5Fsource=clara.com&utm%5Fmedium=referral&utm%5Fcampaign=global%5Ftools&utm%5Fcontent=hero%5Fdemo%5Fcta) [Register here](https://global.clara.com/signup?utm%5Fsource=clara.com&utm%5Fmedium=referral&utm%5Fcampaign=global%5Ftools&utm%5Fcontent=hero%5Fcta)

## Convert with an HMRC monthly rate

Loading HMRC rate tables…

## Look up a rate for a currency and period

- Clara Global Editorial Team
- Finance operations content
- 2026-09-11
- 16 min read

The lookup asks for three things — currency, period, and amount — and returns more than a number. Each result carries the rate, the period it applies to, the direction of the conversion, and the HMRC source for that period, because those are the fields that make the calculation defensible later.  
  
The audit line matters more than the arithmetic. A converted figure sitting alone in a spreadsheet cell is a number nobody can check. The same figure with its original amount, original currency, rate, period, and source is a record a reviewer can verify without asking you anything. That is the difference between a conversion and evidence, and it costs nothing extra at the moment you do the conversion — only afterwards, when the context is gone.  
  
HMRC publishes rates as currency units per £1, and this tool keeps that direction visible rather than silently inverting it. Converting a foreign-currency amount into GBP divides by the published rate; converting GBP into a foreign currency multiplies by it. Getting this backwards is one of the most common spreadsheet errors in expense conversion, and it is invisible in the result — which is exactly why the formula stays on screen.

## What HMRC publishes, and when

HMRC’s own guidance on converting foreign currency amounts for customs value states that “we publish these rates at the end of every month and cover the period from the first to the last day of the next calendar month.” That single sentence carries the two facts a finance team needs: the rates are published in advance of the period they govern, and each set is fixed for a calendar month.

The Trade Tariff service — where the tables themselves are published — dates the cadence precisely: “Exchange rates are published by HMRC on the penultimate Thursday of every month (as per section 18 of Notices made under the Taxation (Cross-border Trade) Act 2018). These exchange rates apply to the following calendar month, and represent rates as of midday the day before publication.”

The same guidance sets out when the published rates are mandatory rather than optional in the customs context: importers should normally use the rate specified in their contract, and where no contract rate exists they may use a fixed rate or HMRC’s published rates — but “you must use the exchange rates published by us when the entry to free circulation is accepted.” It also notes that individual rates are amended during the month when commercial rates diverge from the published rate by more than 5%, which is why a month’s table is not always frozen from the first day to the last.  
  
One piece of history saves a lot of confusion: the old GOV.UK collection of monthly rate files was withdrawn on 20 October 2023, and the rates moved to the Trade Tariff service, where monthly, average and spot rates are each published separately. Bookmarks and internal procedure documents written before that date frequently still point at the withdrawn collection. If your policy document names a URL, that is the first thing to check.

## Monthly, average and spot rates are not interchangeable

HMRC publishes three different rate sets, and they answer three different questions. Choosing between them is a policy decision, not a technical one, and this page deliberately does not tell you which is legally correct for your filing — that depends on your tax, customs, and accounting context, and it is a question for your advisers.

The three HMRC rate sets, what each one is, and the question each typically answers.

| Rate set | What it is                                                                   | Typical use                                                                     |
| -------- | ---------------------------------------------------------------------------- | ------------------------------------------------------------------------------- |
| Monthly  | A rate fixed for one calendar month, published at the end of the prior month | Converting transactions dated within that month, consistently across the period |
| Average  | An average across a longer window, published per year                        | Period-level reporting where a single representative rate is wanted             |
| Spot     | A rate for a specific point in time                                          | Cases where the exact date’s rate is the one that matters                       |

What matters operationally is that your company picks one basis, writes it into the expense policy, and applies it the same way every month. A team that uses the monthly rate for most claims, the spot rate when someone remembers, and a bank rate when the claim came from a card statement does not have a conversion policy — it has three, and the reconciliation at close is the price.  
  
The written policy should answer four questions: which rate set applies to employee expense claims; which date determines the period (the expense date, the submission date, or the approval date); when the rate is fixed and therefore stops moving; and who approves an exception when a claim genuinely needs a different basis. Those four answers are worth more than any calculator, because they are what makes every calculation reproducible.

This site tabulates the monthly rates only. Average and spot sets are published separately by HMRC through the same service and are not reproduced here.

## Convert a batch of claims

Single conversions answer one question at a time; a month of expense claims is a different job. The bulk mode takes rows of amount, currency, date, and description, matches each row to the rate for its period, and returns a table with the converted value and the source fields alongside it.  
  
The export deliberately includes the evidence columns by default. A CSV that contains only converted values recreates the original problem one step downstream: finance receives numbers whose provenance lives in whatever tool produced them, and a reviewer who wants to check one row has to reconstruct the whole calculation. Description, original currency, original amount, rate, period, converted value, and source URL together make each row self-explanatory.  
  
Two practical notes on batch work. First, rows whose date falls outside the periods published here return no rate rather than a guess — a blank you can see is safer than an interpolated number you cannot. Second, the batch uses the period that contains each row’s date, so a claim dated the last day of a month and submitted on the first of the next converts on its own date’s period, not on the date you happened to run the export.

## Keeping the rate attached after the conversion

A lookup solves a moment; the recurring cost sits in the workflow around it. The evidence a reviewer eventually asks for — original amount, currency, rate, source, who approved it, when it was paid — is cheap to capture as the claim moves and expensive to rebuild at month end from exports and memory.  
  
That is the part Clara Global is built for. Each expense claim keeps its original amount and currency, and the exchange rate applied is locked at submission: the amount an approver validates is the amount that reaches the reimbursement report, with no silent re-conversion in between. The approval rules your finance team defines — by amount, by category, by entity — are evaluated on the claim itself, and each decision is recorded with the approver’s identity and timestamp.  
  
The workflow ends in a payment-ready reimbursement report grouped by currency and bank account, which your finance team executes through its own bank. Clara Global does not execute transfers — banking controls stay exactly where they already are — and the same flow works for employees in any country and any currency. The point for this page’s reader is narrow and practical: the rate evidence you assemble by hand in a spreadsheet today is a by-product of the workflow when the workflow captures it at submission.

## Methodology

Rate tables are committed snapshots of the official monthly CSV published by HMRC through the Trade Tariff service for each period, stamped with the retrieval date shown on every page. Nothing is fetched at render time, and no rate is interpolated, averaged, or derived by this site — a period either has its published table or has no page. Conversions run entirely in your browser over that snapshot; nothing you enter is transmitted or stored.  
  
One access note for anyone verifying the source themselves: the Trade Tariff service refuses requests that do not present a browser-like User-Agent, which is why automated checks sometimes report it as unreachable. It is reachable and machine-readable — the constraint is the request header, not access.

## Frequently asked questions

### What HMRC exchange rate should I use?

Use the rate set that matches your tax, customs, accounting, or internal-policy context — and write that choice down. HMRC publishes monthly, average and spot rates separately through the Trade Tariff service, and its customs guidance states that the monthly rates it publishes “cover the period from the first to the last day of the next calendar month.” In the customs context specifically, the guidance says you must use the rates HMRC publishes when the entry to free circulation is accepted, unless a contract rate or an agreed fixed rate applies. For employee expenses the choice is usually an internal policy decision rather than a prescribed one, which is exactly why it should be written into the expense policy with the date basis attached. This page shows the rate and its source so finance can verify the choice; it does not tell you which rate is legally correct for your filing, and no calculator should.

### Are HMRC exchange rates official for every purpose?

No, and treating them that way is a real risk. HMRC publishes rate data and guidance for specific purposes — customs value, VAT, and tax contexts — and different filings and accounting standards can require different bases. The right rate for a customs entry is not automatically the right rate for a statutory account or for an employee reimbursement. Confirm the correct treatment for your specific purpose with your tax or accounting advisers, and keep the source attached to whichever rate you use. If a reviewer later disagrees with the basis, a documented rate with its source is a conversation about policy; an undocumented number is a finding.

### Can I export the conversions?

Yes. Both single and bulk conversions export a CSV containing the original amount, original currency, the rate applied, the period it covers, the converted value, and the HMRC source URL for that period. The file is generated in your browser from what you typed — nothing is uploaded, and nothing you enter here is stored or sent anywhere. Keep the export with the claim it supports rather than in a separate folder. The value of the evidence columns is that they travel with the number; separated from it, they become another file nobody opens.

### How current are the rates on this page?

Each period on this page is a snapshot of the official HMRC table for that month, taken from the Trade Tariff service, and every page states the date its snapshot was retrieved. The archive covers a fixed set of recent periods rather than the full history, and periods with no distinct published data get no page at all. Because HMRC amends individual rates during a month when commercial rates diverge by more than 5% from the published rate, a mid-month amendment made after a snapshot was taken would not appear here until the snapshot is refreshed. For anything consequential, follow the source link on the period page and confirm against HMRC directly — the link is there for exactly that reason.

### Why does the rate direction matter?

Because the published figure is currency units per £1, not pounds per unit, and both readings produce a plausible-looking number. Converting a foreign amount to GBP divides by the published rate; converting GBP to a foreign currency multiplies by it. An inverted rate is one of the few spreadsheet errors that survives review, because the result is not obviously absurd — it is simply wrong by a factor that changes with every currency. The tool keeps the direction and the formula visible on screen and in the export, so an inverted conversion is visible to the next reader rather than buried in a cell.

## Global spend management starts here

Manage your team’s expenses in any country and currency. Receipts, approvals, and bank-ready payment reports — all in one place.

[Based in Mexico, Brazil, or Colombia? Click here →](https://www.clara.com/latam)[Register here](https://global.clara.com/signup?utm%5Fsource=clara.com&utm%5Fmedium=referral&utm%5Fcampaign=global%5Ffooter&utm%5Fcontent=form%5Ffooter)
