U.S. Department of the Treasury Reference Rate API for Accounting, Invoicing & Compliance

If your business invoices, imports, or reports in a currency other than the USD, sooner or later someone will ask which rate you used — and “the one on the internet that day” is not an answer that survives an audit. For that, you want the official number: U.S. Department of the Treasury’s published Reporting Rates of Exchange.

What are the U.S. Department of the Treasury Reporting Rates of Exchange?

The U.S. Department of the Treasury publishes the Treasury Reporting Rates of Exchange each quarter, through its Bureau of the Fiscal Service. Every US government agency must use these rates to convert foreign-currency balances into dollars for official reports — and contractors, grant recipients, and auditors follow the same table. Rates are amended mid-quarter when a currency moves sharply.

It is published once a quarter, currently covering 3 currencies, and the published record runs back to 2001. Crucially it is a published figure, not a live market price — it does not move after it is set, which is exactly the property an accountant or an auditor needs.

Every US federal agency must translate foreign-currency balances at the Treasury Reporting Rates for official reporting, and contractors, grant recipients and their auditors follow the same table.

Why finance teams need the official rate

Book closing and month end

Foreign-currency balances have to be translated at a defensible rate on a specific date. Using a live market rate means the number changes depending on what minute you pulled it, and two people closing the same month can produce two different sets of books. The authority’s published rate for that date is fixed and reproducible forever.

FX gain and loss

Revaluing receivables and payables needs the rate at invoice date and the rate at settlement date. Both have to come from the same series, or the gain and loss you report is partly an artefact of switching data sources mid-stream.

Audits and compliance

An auditor does not want a screenshot. They want a rate that traces back to a named publisher and a publication date they can independently check against U.S. Department of the Treasury’s own release. That is the entire reason official rates exist.

Management reporting

Group reporting across entities only consolidates cleanly when every entity converts at the same published rate for the same date. Left to their own devices, subsidiaries will each pick a different source.

The problem with collecting the rate by hand

U.S. Department of the Treasury publishes the data — but publishing and being easy to consume are different things. In practice teams end up copying figures off the bank’s rates page into a spreadsheet every period, which creates four familiar problems:

• It is manual, so it gets skipped. Someone is on leave, a period gets missed, and the gap is only discovered at close.
• Typos are invisible. A transposed digit in a rate looks exactly like a correct rate until the variance shows up somewhere else entirely.
• History is awkward. Restating a prior period, or answering an auditor about a shipment from two years ago, means digging through archives rather than making one query.
• Non-publication days trip people up. Weekends and public holidays have no rate at all, and every team invents its own rule about what to use instead — usually without writing it down.

The U.S. Department of the Treasury rates as an API

AllRatesToday ingests U.S. Department of the Treasury’s published table shortly after each release and serves it back in a consistent shape, alongside 37 other central banks and national tax authorities on identical endpoints.

• Official figures, unmodified — served with U.S. Department of the Treasury’s own publication date on every response.
• 3 currencies against the USD.
• History back to 2001 — query any past date, or pull a full time series.
• Honest holiday handling — non-publication dates resolve to the most recent published table and say so, rather than silently interpolating.
• Formats finance actually uses — JSON, CSV, XML and genuine Excel workbooks, so it lands in a spreadsheet, Power BI or an ERP without a conversion step.
• Published vs derived is labelled — a pair U.S. Department of the Treasury did not print itself is computed from its table and flagged, never passed off as an official quote.

Who this is for

• Exporters and importers converting invoices and customs values at a rate that has to hold up later.
• Finance and accounting teams closing books across currencies.
• Auditors and advisors who need to reproduce a client’s conversion months after the fact.
• ERP, accounting and invoicing platforms that need an official rate feed their own customers can defend.
• Fintech and payments teams that price on market rates but must report on official ones.

What it actually saves

• Time — no one copies rates into a spreadsheet each period again.
• Accuracy — the figure is whatever U.S. Department of the Treasury published, with no retyping in between.
• Audit risk — every number carries its publication date, so “where did this come from?” has an answer.
• Consistency — every entity, report and invoice converts from the same series.

Getting started

1. Create a free account — 300 requests a month, no card.
2. Call /api/v1/central-bank/ustreasury/latest, or download the table as Excel from the U.S. Department of the Treasury coverage page.
3. Wire it into your close, your invoicing, or a scheduled spreadsheet refresh.

Developers who want the endpoints, SDK and code samples should read the U.S. Department of the Treasury API guide instead — this page is the business case; that one is the integration.

FAQ

Where do U.S. Department of the Treasury exchange rates come from in this API?

Directly from U.S. Department of the Treasury's own published Reporting Rates of Exchange. Rates are stored unmodified with the authority's publication date attached, so the figure in your ledger is the figure U.S. Department of the Treasury printed, going back to 2001.

Can I get the U.S. Department of the Treasury rate for a past date, like an invoice or shipment date?

Yes. Ask for any past date and you get the rate in force then, back to 2001. If the authority did not publish that day — a weekend or a public holiday — the API returns the most recent published table and flags that it did, so your audit trail stays honest instead of silently guessing.

Do I need a developer to use this?

Not necessarily. Every coverage page offers the latest published table as an Excel or CSV download, and finance teams commonly pull the API straight into Excel, Power BI or their ERP on a schedule. A developer helps if you want it wired into invoicing or your accounting system automatically.

Final thought

Official rates are not a nicer version of market rates — they answer a different question. Market data tells you what a currency is worth right now. U.S. Department of the Treasury’s published table tells you what rate your books, your customs entries and your auditor are entitled to expect for a given date. Getting that second number automatically, with its publication date attached, removes an entire category of month-end argument.