ESBD_File_255490_General Ledger Chart of Accounts Feeds.xlsx
XLSX spreadsheet 19 KB Posted
- Attached to
- Master Custodian and Securities Lending Services
- Solicitation number
- CC-2200001
- Issued by
- Texas
About this file
This file is an Excel spreadsheet detailing a General Ledger (GL) Chart of Accounts, which appears to be an internal financial classification system for tracking assets, liabilities, revenues, and expenditures. The spreadsheet comprehensively lists 112 unique GL account numbers across four primary categories: Assets (60 entries), Liabilities (17 entries), Revenues (25 entries), and Expenditures (10 entries). The accounts cover a wide range of financial instruments and transactions, including various investment types such as domestic and international equities, bonds, real estate, hedge funds, private equity, and derivative instruments.
The GL chart provides granular financial tracking mechanisms, with specific line items for income streams like dividend income, interest income, securities lending income, and realized/unrealized gains and losses. Expenditure categories include investment fees, external manager fees, custodial bank fees, and legal fees. The detailed categorization suggests this is likely for a sophisticated financial entity, potentially a pension fund, investment management organization, or government investment portfolio, with robust mechanisms for tracking complex financial transactions, investment performance, and associated costs.
View the file
Other files
Show all 17
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Sheet1
| GL Number | GL Description | Type |
| 011601 | Absolute Return | Assets |
| 010701 | Asset and Mortgage Backed Bonds | Assets |
| 011905 | Commingled Fixed Income | Assets |
| 010703 | Corporate Bonds | Assets |
| 004001 | Custodial Bank Cash | Assets |
| 006201 | Custodial Short Term Fund | Assets |
| 011602 | Directional Hedge Funds | Assets |
| 020501 | Dividend Receivable | Assets |
| 020502 | Dividend Tax Reclaim Receivable | Assets |
| 011901 | Domestic Commingled Equity | Assets |
| 010901 | Domestic Equity | Assets |
| 011907 | Domestic Mutual Fund | Assets |
| 011603 | Energy, Natural Resources, and Infrastructure | Assets |
| 010506 | Forward Contracts Long | Assets |
| 010505 | Forward Contracts Short | Assets |
| 010502 | FX Forwards | Assets |
| 024712 | Initial Margin Receivables | Assets |
| 011903 | International Commingled Equity | Assets |
| 011301 | International Corporate Bond | Assets |
| 011101 | International Equity | Assets |
| 020002 | Investment Interest Receivable | Assets |
| 024702 | Investments Sold Receivable | Assets |
| 024704 | Investments Sold Receivable - ST | Assets |
| 024706 | Investments Sold Receivable - Swaps | Assets |
| 010514 | Margin Variation Payable | Assets |
| 010513 | Margin Variation Receivable | Assets |
| 010508 | Options | Assets |
| 020003 | Other Receivables | Assets |
| 011604 | Private Equity | Assets |
| 011609 | Privately Held Debt | Assets |
| 011608 | Privately Held Equity | Assets |
| 011605 | Real Estate | Assets |
| 001138 | Reverse Repurchase Agreements | Assets |
| 010509 | Rights | Assets |
| 011606 | Risk Parity | Assets |
| 006701 | Securities Lending Collateral | Assets |
| 010660 | Securities Unallocated | Assets |
| 006202 | Short Term Commingled Funds | Assets |
| 006501 | Short Term Foreign Currency Contracts | Assets |
| 011201 | Sovereign Government Issue | Assets |
| 006506 | Spot Contracts Long | Assets |
| 006505 | Spot Contracts Short | Assets |
| 011607 | Stable Value Hedge Funds | Assets |
| 020503 | Swap Income Receivable | Assets |
| 010510 | Swaps | Assets |
| 006001 | Treasury Bills | Assets |
| 010407 | U.S. Government Agency Bond | Assets |
| 010401 | U.S. TIPS | Assets |
| 010403 | U.S. Treasury Bonds | Assets |
| 010405 | U.S. Treasury STRIPS | Assets |
| 020504 | Unrealized G/L on Income Receivables | Assets |
| 024707 | Unrealized G/L on Swaps Receivable | Assets |
| 024705 | Unrealized G/L on Trade Receivables | Assets |
| 010512 | Warrants | Assets |
| 101102 | Unrealized G/L on Swap Payables | Liabilities |
| 101103 | Investments Purchased Payable - Swaps | Liabilities |
| 101105 | Unrealized G/L on Trade Payables | Liabilities |
| 101106 | Investments Purchased Payable | Liabilities |
| 101110 | Dividends Payable | Liabilities |
| 101111 | Interest Payable | Liabilities |
| 101112 | Swap Income Payable | Liabilities |
| 101113 | Swap Dividend Payable | Liabilities |
| 101114 | Average Short Equity | Liabilities |
| 101115 | Other Investment Payables | Liabilities |
| 101116 | Investment External Manager Fee Payable | Liabilities |
| 101118 | Custodial Account Shortfall Payable | Liabilities |
| 113901 | Obligations Under Securities Lending | Liabilities |
| 113902 | Derivative Collateral Obligat. | Liabilities |
| 371401 | Securities Litigation | Revenues |
| 379502 | Breakage | Revenues |
| 382801 | Dividend Income | Revenues |
| 382802 | Other Misc Inv Rev | Revenues |
| 382803 | Recallable Partnership Distributions | Revenues |
| 382804 | Dividend Expense (Short) | Revenues |
| 382805 | Dividend Tax Withheld | Revenues |
| 385501 | Interest Income | Revenues |
| 385502 | Interest Income - Tips | Revenues |
| 385503 | Interest Income - FX | Revenues |
| 385504 | Interest Income - Cash | Revenues |
| 385505 | Interest Income - ST | Revenues |
| 385509 | Interest Tax Withheld | Revenues |
| 385601 | Securities Lending Income | Revenues |
| 386101 | Average Security Realized Gain/Loss - MBS Paydowns | Revenues |
| 386102 | Realized Gain/Loss - RE/PE Fees (Int, Legal, Admin) | Revenues |
| 386103 | Realized Gain/Loss - GP Carried Interest | Revenues |
| 386104 | Realized Gain/Loss - RE/PE MGMT Expense (Outside Commitment) | Revenues |
| 386105 | Average Security Realized Gain/Loss | Revenues |
| 386106 | Realized Gain/Loss - Futures | Revenues |
| 386107 | Realized Gain/Loss on Dividends Received | Revenues |
| 386108 | Realized Gain/Loss on Interest Received | Revenues |
| 386109 | Realized Gain/Loss on Tax Refunds Received | Revenues |
| 386110 | Realized Gain/Loss on Security Settlements | Revenues |
| 386112 | Realized Gain/Loss on Spot FX Settlements | Revenues |
| 386114 | Realized Gain/Loss on Currency Disposal | Revenues |
| 386117 | Realized Gain/Loss on Forwards | Revenues |
| 389901 | Unrealized Gain/Loss on Investments | Revenues |
| 389902 | Unrealized Gain/Loss on Securities Lending | Revenues |
| 389903 | Unrealized Gain/Loss on Futures | Revenues |
| 389904 | Unrealized Gain/Loss on Receivables and Payables | Revenues |
| 724501 | Custodial Flat Fee | Expenditures |
| 725301 | Investment Fees | Expenditures |
| 725302 | External Manager Fees | Expenditures |
| 725303 | Custodial Bank Out of Pocket Fees | Expenditures |
| 725304 | Investment Research Fees | Expenditures |
| 725801 | Investment Legal Fees | Expenditures |
| 774001 | Borrower Rebates On Securities Lending | Expenditures |
| 774101 | Agent Fees On Securities Lending | Expenditures |
File details come from the government source that posted it. Updated .