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 NumberGL DescriptionType
011601Absolute ReturnAssets
010701Asset and Mortgage Backed BondsAssets
011905Commingled Fixed IncomeAssets
010703Corporate BondsAssets
004001Custodial Bank CashAssets
006201Custodial Short Term FundAssets
011602Directional Hedge FundsAssets
020501Dividend ReceivableAssets
020502Dividend Tax Reclaim ReceivableAssets
011901Domestic Commingled EquityAssets
010901Domestic EquityAssets
011907Domestic Mutual FundAssets
011603Energy, Natural Resources, and InfrastructureAssets
010506Forward Contracts LongAssets
010505Forward Contracts ShortAssets
010502FX ForwardsAssets
024712Initial Margin ReceivablesAssets
011903International Commingled EquityAssets
011301International Corporate BondAssets
011101International EquityAssets
020002Investment Interest ReceivableAssets
024702Investments Sold ReceivableAssets
024704Investments Sold Receivable - STAssets
024706Investments Sold Receivable - SwapsAssets
010514Margin Variation PayableAssets
010513Margin Variation ReceivableAssets
010508OptionsAssets
020003Other ReceivablesAssets
011604Private EquityAssets
011609Privately Held DebtAssets
011608Privately Held EquityAssets
011605Real EstateAssets
001138Reverse Repurchase AgreementsAssets
010509RightsAssets
011606Risk ParityAssets
006701Securities Lending CollateralAssets
010660Securities UnallocatedAssets
006202Short Term Commingled FundsAssets
006501Short Term Foreign Currency ContractsAssets
011201Sovereign Government IssueAssets
006506Spot Contracts LongAssets
006505Spot Contracts ShortAssets
011607Stable Value Hedge FundsAssets
020503Swap Income ReceivableAssets
010510SwapsAssets
006001Treasury BillsAssets
010407U.S. Government Agency BondAssets
010401U.S. TIPSAssets
010403U.S. Treasury BondsAssets
010405U.S. Treasury STRIPSAssets
020504Unrealized G/L on Income ReceivablesAssets
024707Unrealized G/L on Swaps ReceivableAssets
024705Unrealized G/L on Trade ReceivablesAssets
010512WarrantsAssets
101102Unrealized G/L on Swap PayablesLiabilities
101103Investments Purchased Payable - SwapsLiabilities
101105Unrealized G/L on Trade PayablesLiabilities
101106Investments Purchased PayableLiabilities
101110Dividends PayableLiabilities
101111Interest PayableLiabilities
101112Swap Income PayableLiabilities
101113Swap Dividend PayableLiabilities
101114Average Short EquityLiabilities
101115Other Investment PayablesLiabilities
101116Investment External Manager Fee PayableLiabilities
101118Custodial Account Shortfall PayableLiabilities
113901Obligations Under Securities LendingLiabilities
113902Derivative Collateral Obligat.Liabilities
371401Securities LitigationRevenues
379502BreakageRevenues
382801Dividend IncomeRevenues
382802Other Misc Inv RevRevenues
382803Recallable Partnership DistributionsRevenues
382804Dividend Expense (Short)Revenues
382805Dividend Tax WithheldRevenues
385501Interest IncomeRevenues
385502Interest Income - TipsRevenues
385503Interest Income - FXRevenues
385504Interest Income - CashRevenues
385505Interest Income - STRevenues
385509Interest Tax WithheldRevenues
385601Securities Lending IncomeRevenues
386101Average Security Realized Gain/Loss - MBS PaydownsRevenues
386102Realized Gain/Loss - RE/PE Fees (Int, Legal, Admin)Revenues
386103Realized Gain/Loss - GP Carried InterestRevenues
386104Realized Gain/Loss - RE/PE MGMT Expense (Outside Commitment)Revenues
386105Average Security Realized Gain/LossRevenues
386106Realized Gain/Loss - FuturesRevenues
386107Realized Gain/Loss on Dividends ReceivedRevenues
386108Realized Gain/Loss on Interest ReceivedRevenues
386109Realized Gain/Loss on Tax Refunds ReceivedRevenues
386110Realized Gain/Loss on Security SettlementsRevenues
386112Realized Gain/Loss on Spot FX SettlementsRevenues
386114Realized Gain/Loss on Currency DisposalRevenues
386117Realized Gain/Loss on ForwardsRevenues
389901Unrealized Gain/Loss on InvestmentsRevenues
389902Unrealized Gain/Loss on Securities LendingRevenues
389903Unrealized Gain/Loss on FuturesRevenues
389904Unrealized Gain/Loss on Receivables and PayablesRevenues
724501Custodial Flat FeeExpenditures
725301Investment FeesExpenditures
725302External Manager FeesExpenditures
725303Custodial Bank Out of Pocket FeesExpenditures
725304Investment Research FeesExpenditures
725801Investment Legal FeesExpenditures
774001Borrower Rebates On Securities LendingExpenditures
774101Agent Fees On Securities LendingExpenditures

File details come from the government source that posted it. Updated .