To calculate foreign currency exchange rates for tax reporting, visit the Currency Exchange Rates Converter page.
Introduction
03/31/2001 — 03/31/2024Released QuarterlyLast Updated 06/14/2024
The Treasury Reporting Rates of Exchange dataset provides the U.S. government's authoritative exchange rates to ensure consistency for foreign currency units and U.S. dollar equivalents across all reporting done by agencies of the government. This report covers any foreign currencies in which the U.S. government has an interest, including: receipts and disbursem*nts, accrued revenues and expenditures, authorizations, obligations, receivables and payables, refunds, and similar reverse transaction items. The Secretary of the Treasury has the sole authority to establish the exchange rates for all foreign currencies or credits reported by government agencies under federal law.For pulling specific exchange rates based on country or currency please see the Notes and Known Limitations below.
Preview & Download
Date Range
Data Table:
N/A
Date Range:
Dataset Properties
Data Table Name | Field Name | Display Name | Description | Data Type | Is Required |
|---|---|---|---|---|---|
| Treasury Reporting Rates of Exchange | record_date | Record Date | The date that data was published. | DATE | 1 |
| Treasury Reporting Rates of Exchange | country | Country | Country associated with a given exchange rate. | STRING | 1 |
| Treasury Reporting Rates of Exchange | currency | Currency | Currency associated with a given exchange rate. | STRING | 1 |
| Treasury Reporting Rates of Exchange | country_currency_desc | Country - Currency Description | Country and currency associated with a given exchange rate. | STRING | 1 |
| Treasury Reporting Rates of Exchange | exchange_rate | Exchange Rate | Exchange rate at which any foreign currency unit will be valued, and reported at, against the U.S. Dollar. | NUMBER | 1 |
Showing 1 - 5
rows
of
rows
| Table Name | Description | Row Description | Row Count |
|---|
| Name | Definition |
|---|
Notes & Known Limitations
Overview:This quarterly report reflects exchange rates at which the U.S. government can acquire foreign currencies for official expenditures as reported by disbursing officers for each post on the last business day of the month prior to the date of the published report.
Amendments:If current rates deviate from the published rates by 10% or more, Treasury will issue amendments to this quarterly report. An amendment to a currency exchange rate for the quarter will appear on the report as a separate line with a new effective date. Amendments made at the end of a month can be used for reporting purposes for transactions occurring during the remaining month(s) in the quarter. Example: A currency amended on April 30th will appear on two lines of the report. One line for the original March 31st published rate and another line for the amended rate effective April 30th which would be valid for reporting purposes for May and June transactions. Amendments will also be issued to reflect the establishment of new foreign currencies. Amendments are included in this dataset beginning March 2021.
Exceptions:Exceptions to using the reporting rates as shown in the report are: collections and refunds to be valued at specified rates set by international agreements, conversions of one foreign currency into another, foreign currencies sold for dollars, and other types of transactions affecting dollar appropriations. See Volume I Treasury Financial Manual 2-3200 for further details.
To ensure all reports are translated at uniform exchange rates, all U.S. government agencies should use these rates, except as noted above, to convert foreign currency balances and reported transactions to U.S. dollar equivalents as of the date of this report and for the ensuing three months. Since the exchange rates in this report are not current rates of exchange, they should not be used to value transactions affecting dollar appropriations. For exchange rates for years before 2001, visit the gov.info website. This website has individual reports for years going back to 1963 and a consolidated report that goes back to 1956.
Published Reports:The quarterly published PDF report does not contain amended rates, which are only made available within the raw data. No PDF reports will be published for amended rates.
API Quick Guide
Check out our more detailed API Documentation.
API Documentation
Endpoint
BASE URL:
https://api.fiscaldata.treasury.gov/services/api/fiscal_service/
ENDPOINT:
FULL URL:
https://api.fiscaldata.treasury.gov/services/api/fiscal_service/
Fields
Refer to
Dataset Properties
above for a data dictionary with field names and descriptions, as well as notes and known limitations. known limitations.
| Field Name | Display Name | Data Type |
|---|
Showing 1 - 5 rows of 13 rows
Data Types
All data is returned as a string, including nulls. Refer to the chart above for the intended data type of each field.
Parameters
Refer to
Dataset Properties
above for a data dictionary with field names and descriptions as well as notes and known limitations
Fields
toggle contents
- Parameter:
fields= - Definition: The fields parameter allows you to select which field(s) should be included in the response.
- Accepts: The
fields=parameter accepts a comma-separated list of field names (no parentheses). - Required: No, specifying fields is not required to make an API request.
- Default: If desired fields are not specified, all fields will be returned.
- Notes: When a field named passed to the
fields=parameter is not available for the endpoint accessed, an error will occur. Note that omitting fields can result in automatically aggregated and summed data results. For more information, view the full documentation on Aggregation and Sums.
EXAMPLE
?fields=
Filters
toggle contents
Sorting
toggle contents
Format
toggle contents
Pagination
toggle contents
Methods
Our APIs accept the GET method, one of the most common HTTP methods.
Example Request & Response
In this example, we are...
- Specifying the endpoint
- Requesting the JSON response format
- Sorting the data by
in descending order - Setting pagination parameters
EXAMPLE REQUEST
https://api.fiscaldata.treasury.gov/services/api/fiscal_service/undefined?sort=-undefined&format=json&page[number]=1&page[size]=1
EXPECTED RESPONSE
Loading...
For More API Information
Visit our full API documentation to find out more about:
- Aggregation and sums
- Pivoting
- Response codes
- Meta object
- ...and more!
API Documentation
