An official website of the U.S. government
Topics
Tools
Resources
Federal Borrowings Program: Summary General Ledger Balances Report
Introduction
10/31/2005 — 03/31/2024Released MonthlyLast Updated 04/01/2024
The Federal Borrowings Program: Summary General Ledger Balances Report dataset provides Treasury Loans Receivable, Capitalized Interest Receivable, Interest Receivable, Interest Revenue, Gain, and Loss balances associated with every corresponding borrowing agency expenditure Treasury Account Symbol.
Preview
Dataset Properties
Data Table Name | Field Name | Display Name | Description | Data Type | Is Required |
|---|---|---|---|---|---|
| Summary General Ledger Borrowing Balances | record_date | Record Date | The date for which the data was published. | DATE | 1 |
| Summary General Ledger Borrowing Balances | account_cd | Account Code | The 2-digit Agency Identifier followed by the 4-digit Main Account Code of the applicable borrowing agency account. | STRING | 1 |
| Summary General Ledger Borrowing Balances | dept_cd | Department Code | The 3-digit Agency Identifier of the applicable borrowing agency. | STRING | |
| Summary General Ledger Borrowing Balances | loans_receivable_amt | Loans Receivable Amount | Fiscal Service's Loans Receivable Balances. | CURRENCY | |
| Summary General Ledger Borrowing Balances | capitalized_int_receivable_amt | Capitalized Interest Receivable Amount | Fiscal Service's Capitalized Interest Receivable Balances. | CURRENCY |
Showing 1 - 5 rows of rows
| Table Name | Description | Row Description | Row Count |
|---|
| Name | Definition |
|---|
Notes & Known Limitations
The Monthly Treasury Statement (MTS), Table 6, Schedule C reports the principal outstanding for agency borrowings from the Treasury. There is a variance between the MTS account balance as of the close of the month and loans receivable balance on the FBP: Summary General Ledger Balances Report. The difference is due to non-credit reform capitalized interest and rounding differences.
Account 204521, the Federal Financing Bank Revolving Fund, appears on two separate rows of the Summary General Ledger Balances Report. The two rows combined reflect the total outstanding balances for the account.
Within Repayable Advances the 0002 represents the Extended Unemployment Compensation Account within the Unemployment Trust Fund and the 0003 represents the Federal Unemployment Account within the Unemployment Trust Fund.
API Quick Guide
Check out our more detailed API Documentation.
Endpoints
BASE URL:
https://api.fiscaldata.treasury.gov/services/api/fiscal_service/| Table Name | Endpoint |
|---|
Showing 1 - 2 rows of 2 rows
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 | Data Table Name |
|---|
Showing 1 - 5 rows of 32 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 limitationsFields
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]=1EXPECTED 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!
Related Datasets
© 2020 Data Transparency