Treasury Reporting Rates of Exchange
Exchange rate information for foreign currencies and their U.S. dollar equivalents, updated quarterly.
About This Dataset
Description:
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 disbursements, 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.
| Data Table Name | Field Name | Display Name | Description | Data Type | Is Required |
|---|
| Table Name | Description | Row Description | File Sizes | Row Count |
|---|
| Name | Definition |
|---|
Notes & Known Limitations
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.
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 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.
To find a specific exchange rate perform the following actions: 1. Within the Preview and Download section select the date range that meets your needs 2. Click the Download CSV file to the right and open the file 3. Within the CSV file you can perform the following actions. Filter by the Country or Currency field, Filter by Record Date or Effective Date, and Save as an Excel file as well to increase functionality.
You can also use the API to find exchange rate data. This is an easy way to extract specific exchange rate data. For example:
Type the name of the country or currency in the links below by replacing the XXXX and copy and paste into your browser. It will then download a CSV file.
Preview
API Quick Guide
https://api.fiscaldata.treasury.gov/services/api/fiscal_service/https://api.fiscaldata.treasury.gov/services/api/fiscal_service/| Field Name | Display Name | Data Type |
|---|
- 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.
?fields=- Parameter:
filter= - Definition: Filters are used to view a subset of the data based on specific criteria. For example, you may want to find data that falls within a certain date range, or only show records which contain a value larger than a certain threshold.
- Accepts: The filter parameter
filter=accepts filters from the list below, as well as specified filter criteria. Use a colon at the end of a filter parameter to pass a value or list of values. For lists passed as filter criteria, use a comma-separated list within parentheses. Filter for specific dates using the formatYYYY-MM-DD. - Required: No, filters are not required to make an API request.
- Default: When no filters are provided, the default response will return all fields and all data.
lt= Less thanlte= Less than or equal togt= Greater thangte= Greater than or equal toeq= Equal toin= Contained in a given set
?filter=undefined:eq:2020-05-31https://api.fiscaldata.treasury.gov/services/api/fiscal_service/undefined?filter=undefined:eq:2020-05-31- Parameter:
sort= - Definition: The sort parameter allows a user to sort a field in ascending (least to greatest) or descending (greatest to least) order.
- Accepts: The sort parameter
sort=accepts a comma-separated list of field names. - Required: No, sorting is not required to make an API request.
- Default: When no sort parameter is specified, the default is to sort by the first column listed. Most API endpoints are thus sorted by date in ascending order (historical to most current).
- Notes: You can nest sorting by passing the
sort=parameter a comma-separated list.
?sort=-undefinedhttps://api.fiscaldata.treasury.gov/services/api/fiscal_service/undefined?sort=-undefined- Parameter:
format= - Definition: The format parameter allows a user to define the output method of the response (CSV, JSON, XML).
- Accepts: The
format=parameter acceptsxml,json, orcsvas an input. - Required: No, the format parameter is not required to make an API request.
- Default: When no format is specified, the default response format is JSON.
?format=csv- Parameter:
page[size]=andpage[number]= - Definition: The page size will set the number of rows that are returned on a request, and page number will set the index for the pagination, starting at 1. This allows the user to paginate through the records returned from an API request.
- Accepts: The
page[number]=andpage[size]=parameters both accept integers. - Required: No, neither pagination parameters are required to make an API request.
- Default: When no page number or page size parameter is specified, the default response is
- Page number: 1
- Page size: 100
- Specifying the endpoint
- Requesting the JSON response format
- Sorting the data by
in descending order - Setting pagination parameters
https://api.fiscaldata.treasury.gov/services/api/fiscal_service/undefined?sort=-undefined&format=json&page[number]=1&page[size]=1Loading...For More API Information
- Aggregation and sums
- Pivoting
- Response codes
- Meta object
- ...and more!
