Net indexed claim lines
$463.3M$472.6M gross before 2,172 credits
Source-linked County finance ledger
The County financial record.
Connected and navigable.
Follow what the County expects to collect, what it audited as revenue, what moved through each fund, and every indexed claim line back to its official source.
Indexed transaction ledger 13/13 checks
Published claim lines · 2020–2026$463.3M$472.6M gross · 2,172 credits · 86,075 rows
Evidence228 packets
Structure124 funds
Transactions86,075 linked
Extraction catch-up queue36 published 2026 packets are not fully indexed yet.
Verify the index The County index reaches Oct 15, 2026. Fully indexed current-year packets reach Jan 8, 2026. 1 additional packet has a reconciled section included below; the rest of that packet remains incomplete.
Jan 15, 2026 partial import: 231 Regular Claims rows, $1,238,303.60 net, are included in the ledger. The $12,386,958.64 EFT cover total has no verified itemization here and is not added to transaction totals. This is historical catch-up, not current-week spending.
Searchable transactions
86,075Source linked Every exposed claim row is retained in the public ledger
Payees
3,316Every normalized payee opens to an over-time profile and complete transaction filter
Budgeted inflows
$157.6MFY2026 12/12 Treasury reports tracked · refreshed Oct 20, 2026, 11:42 AM
Money coming into County funds
12/12 monthly reports indexedRevenue plans, audited results, and current cash activity
Three official records answer three different questions. Keeping them separate prevents an internal transfer from being presented as new County revenue.
FY2026 adopted plan$157.6MBudgeted revenue across 22 published fund linesOpen adopted budget FY2025 audited actual$172.2MGovernmental-fund revenue in the latest ACFROpen audited report December 2025 Treasury report$171.7MEnding cash across 105 reconciled rowsOpen monthly report
Adopted revenue mix
$157.6MWhere FY2026 revenue is expected
Adopted budget, not money already collected.
Current cash movement
-$3.8MVerified fund-account activity by month
Cash in / debits Cash out / credits
Totals include only fund rows that pass the cash equation; internal transfers may appear on both sides.
Fund-level inflows
Track each published fund across the three records
105 scanned December 2025 fund rows reconcile exactly; 12 OCR rows remain excluded.
A missing comparison is not a $0 budget or $0 revenue finding. It means that source does not list the fund as its own line; the amount may be consolidated or reported elsewhere.
Cash in · verified rows$31,327,037.90Cash out · verified rows$35,163,652.35Net cash movement-$3,836,614.45Ending balance · verified rows$171,747,279.88
| Fund | FY2026 adopted revenue line | FY2025 ACFR revenue line | December 2025 cash in | Cash out | Ending balance | Evidence |
|---|---|---|---|---|---|---|
| General FundFund 010 | $114,975,617.00 | $114,796,346.00 | $11,038,714.39 | $13,801,638.95 | $81,488,365.95 | p. 10 |
| Payroll FundFund 400 | Not listed as its own line | Not listed as its own line | $6,749,043.19 | $6,704,921.13 | $1,203,041.65 | p. 31 |
| American Rescue Plan ActFund 189 | Not listed as its own line | $18,763,297.00 | $4,706,947.38 | $5,027,891.02 | $17,268,096.63 | p. 28 |
| 00____ 696,000.09 42,072,000.00Fund 000 | Not listed as its own line | Not listed as its own line | $2,250,693.55 | $3,169,182.19 | $13,030,928.38 | p. 10 |
| Road and Bridge FundFund 075 | $18,778,608.00 | $19,640,239.00 | $2,250,693.55 | $3,169,182.19 | $13,030,928.38 | p. 10 |
| Comal County Health InsuranceFund 410 | Not listed as its own line | Not listed as its own line | $1,652,759.97 | $1,551,999.67 | $5,345,866.56 | p. 31 |
| Debt ServiceFund 099 | $16,574,392.00 | $10,713,328.00 | $929,464.23 | $485,500.00 | $2,705,366.44 | p. 12 |
| TJJD Financial Assistance "A"Fund 158 | Not listed as its own line | Not listed as its own line | $339,461.53 | $43,110.25 | $222,776.60 | p. 23 |
| C.D.A. Hot Check FundFund 112 | Not listed as its own line | Not listed as its own line | $262,716.50 | $232,106.95 | $7,903,172.22 | p. 15 |
| SB22 -Fund 196 | Not listed as its own line | Not listed as its own line | $162,503.68 | $190,197.61 | $31,783.08 | p. 30 |
| SB22 - SheriffFund 195 | Not listed as its own line | Not listed as its own line | $115,557.12 | $160,334.04 | $54,702.00 | p. 29 |
| Seizures Fund (CDA & Constables)Fund 131 | Not listed as its own line | Not listed as its own line | $96,888.94 | $40,843.81 | $601,333.58 | p. 18 |
| TJD 2024 Salary Adjust GrantFund 194 | Not listed as its own line | Not listed as its own line | $86,286.28 | $6,579.94 | $61,727.06 | p. 29 |
| EscrowFund 105 | Not listed as its own line | Not listed as its own line | $73,918.66 | $71,582.25 | $1,946,690.11 | p. 13 |
| Jury FundFund 081 | $950,596.00 | Not listed as its own line | $73,402.55 | $137,295.86 | $2,263,500.10 | p. 10 |
| TJJDFund 159 | Not listed as its own line | Not listed as its own line | $73,218.00 | $0.00 | $73,218.00 | p. 23 |
| Jail CommissaryFund 122 | Not listed as its own line | Not listed as its own line | $64,038.22 | $119,630.48 | $1,317,247.07 | p. 17 |
| Fire Code EnforcementFund 110 | Not listed as its own line | Not listed as its own line | $51,836.13 | $32,906.95 | $1,456,712.70 | p. 14 |
| County Clerk's Archives FundFund 134 | $500,000.00 | Not listed as its own line | $49,429.57 | $3,660.00 | $4,132,426.01 | p. 19 |
| TX Historical Commission GrantFund 147 | Not listed as its own line | Not listed as its own line | $30,000.00 | $3,598.00 | $24,826.30 | p. 21 |
| C.D.A. ForfeituresFund 141 | $33,500.00 | Not listed as its own line | $28,810.29 | $23,248.07 | $177,613.68 | p. 20 |
| Child Safety FundFund 123 | $340,000.00 | Not listed as its own line | $25,485.73 | $0.00 | $1,693,236.64 | p. 17 |
| DSHS Immunization GrantFund 165 | Not listed as its own line | Not listed as its own line | $24,522.71 | $17,801.81 | $5,416.41 | p. 24 |
| Juvenile Case ManagerFund 103 | $107,700.00 | Not listed as its own line | $21,238.92 | $25,443.44 | $39,689.78 | p. 13 |
| DSHS Emergency PreparednessFund 173 | Not listed as its own line | Not listed as its own line | $20,343.26 | $9,176.54 | $11,259.20 | p. 26 |
| TJJD RDA Program "R"Fund 160 | Not listed as its own line | Not listed as its own line | $19,175.00 | $24,702.10 | $95,466.19 | p. 24 |
| Land AcquisitionFund 087 | $2,150,000.00 | Not listed as its own line | $16,341.65 | $2,409.50 | $5,210,038.34 | p. 11 |
| Flood Control OperatingFund 088 | $514,758.00 | Not listed as its own line | $14,926.53 | $0.00 | $4,733,893.29 | p. 11 |
| Special Drug Court ProgramFund 107 | Not listed as its own line | Not listed as its own line | $14,359.79 | $15,400.00 | $105,507.69 | p. 14 |
| Law LibraryFund 101 | $120,000.00 | Not listed as its own line | $12,012.86 | $11,876.41 | $715,707.46 | p. 13 |
| TCLEOSE Training FundFund 120 | Not listed as its own line | Not listed as its own line | $11,272.47 | $13,780.00 | $79,394.90 | p. 16 |
| Election ServicesFund 127 | Not listed as its own line | Not listed as its own line | $8,246.24 | $0.00 | $246,479.06 | p. 17 |
| Veterans Treatment CourtFund 102 | Not listed as its own line | Not listed as its own line | $7,827.10 | $19,890.51 | $72,707.06 | p. 13 |
| Court Reporter Service FundFund 203 | Not listed as its own line | Not listed as its own line | $7,798.49 | $2,040.24 | $272,650.87 | p. 30 |
| Court Facility Fee FundFund 201 | Not listed as its own line | Not listed as its own line | $6,371.21 | $140.00 | $269,521.70 | p. 30 |
| Alternative Dispute ResolutionFund 104 | Not listed as its own line | Not listed as its own line | $6,336.19 | $4,965.00 | $47,135.84 | p. 13 |
| Justice Court Technology FundFund 130 | Not listed as its own line | Not listed as its own line | $3,566.78 | $0.00 | $361,075.39 | p. 18 |
| CJD Challenge Felony Drug CourtFund 151 | Not listed as its own line | Not listed as its own line | $2,650.39 | $24,289.41 | -$36,721.23 | p. 22 |
| Language Access FundFund 202 | Not listed as its own line | Not listed as its own line | $2,252.68 | $21.00 | $78,509.18 | p. 30 |
| Health Department ServicesFund 111 | Not listed as its own line | Not listed as its own line | $1,822.42 | $3,023.75 | $182,927.94 | p. 15 |
| 0.00 209,144.49Fund 005 | Not listed as its own line | Not listed as its own line | $1,303.00 | $111.98 | $215,612.36 | p. 14 |
| So Federal Asset Sharing FundFund 117 | Not listed as its own line | Not listed as its own line | $1,294.38 | $0.00 | $413,806.80 | p. 16 |
| Habitat Conservation ProjectsFund 181 | Not listed as its own line | Not listed as its own line | $1,278.12 | $0.00 | $408,111.42 | p. 27 |
| Judicial Education&Support FundFund 135 | Not listed as its own line | Not listed as its own line | $1,190.22 | $0.00 | $329,730.89 | p. 19 |
| mares 07275049Fund 025 | Not listed as its own line | Not listed as its own line | $1,159.54 | $0.00 | $79,285.97 | p. 31 |
| County Specialty Court FundFund 204 | Not listed as its own line | Not listed as its own line | $1,159.54 | $0.00 | $79,285.97 | p. 31 |
| SS SSFund 055 | Not listed as its own line | Not listed as its own line | $927.07 | $8.00 | $278,650.39 | p. 18 |
| Juvenile Probation Special FeesFund 128 | Not listed as its own line | Not listed as its own line | $927.07 | $8.00 | $278,650.39 | p. 18 |
| Opioid SetttementFund 191 | Not listed as its own line | Not listed as its own line | $904.23 | $0.00 | $289,301.87 | p. 29 |
| Vital Records Preservation FundFund 136 | $7,150.00 | Not listed as its own line | $847.06 | $42.00 | $11,214.11 | p. 19 |
| SCAAPFund 182 | Not listed as its own line | Not listed as its own line | $699.76 | $0.00 | $223,864.91 | p. 27 |
| J.P. Security FundFund 142 | Not listed as its own line | Not listed as its own line | $666.81 | $0.00 | $26,760.48 | p. 20 |
| LATCF -Fund 188 | Not listed as its own line | Not listed as its own line | $350.47 | $0.00 | $112,906.40 | p. 28 |
| CDA Pre-Trial Diversion FundFund 183 | Not listed as its own line | Not listed as its own line | $292.33 | $0.00 | $31,779.97 | p. 27 |
| C.C.A.L. Records Mgmt FundFund 137 | Not listed as its own line | Not listed as its own line | $236.65 | $0.00 | $76,466.28 | p. 19 |
| TX Transportation InfrastructureFund 148 | Not listed as its own line | Not listed as its own line | $215.54 | $0.00 | $69,566.46 | p. 21 |
| Constable #4 Chapter 59 FundFund 132 | $3,000.00 | Not listed as its own line | $167.81 | $0.00 | $53,882.86 | p. 18 |
| Sheriff Bail Bond FundFund 084 | Not listed as its own line | Not listed as its own line | $142.10 | $0.00 | $50,000.70 | p. 10 |
| Constable #3 Chapter 59 FundFund 198 | $5,000.00 | Not listed as its own line | $102.47 | $0.00 | $32,740.24 | p. 30 |
| S.O SeizuresFund 121 | Not listed as its own line | Not listed as its own line | $83.86 | $0.00 | $26,874.67 | p. 16 |
| District Court Archive FundFund 138 | $1,500.00 | Not listed as its own line | $78.07 | $10.00 | $3,468.68 | p. 20 |
| Elections Chapter 19 FundFund 140 | Not listed as its own line | Not listed as its own line | $44.27 | $0.00 | $14,190.67 | p. 20 |
| Constable #4Fund 144 | Not listed as its own line | Not listed as its own line | $25.57 | $0.00 | $8,517.86 | p. 21 |
| Constable #3Fund 193 | Not listed as its own line | Not listed as its own line | $7.81 | $0.00 | $2,522.17 | p. 29 |
| PCA County Cash 0.00 0.00 0.00 0.00Fund 001 | Not listed as its own line | Not listed as its own line | $0.00 | $0.00 | $0.00 | p. 25 |
| 9 0000Fund 002 | Not listed as its own line | Not listed as its own line | $0.00 | $0.00 | $0.00 | p. 25 |
| 00 000.00Fund 008 | Not listed as its own line | Not listed as its own line | $0.00 | $3,000.00 | $20,520.21 | p. 29 |
| Courthouse Restoration GrantFund 033 | Not listed as its own line | Not listed as its own line | $0.00 | $0.00 | $0.00 | p. 12 |
| SO GONE Ch. 59 ForfeituresFund 083 | $0.00 | Not listed as its own line | $0.00 | $0.00 | $0.00 | p. 10 |
| Capital Projects FundFund 091 | Not listed as its own line | Not listed as its own line | $0.00 | $0.00 | $0.00 | p. 12 |
| Flood Control StructuresFund 092 | Not listed as its own line | Not listed as its own line | $0.00 | $0.00 | $0.00 | p. 11 |
| Courthouse Restoration GrantFund 093 | Not listed as its own line | Not listed as its own line | $0.00 | $0.00 | $0.00 | p. 12 |
| 2016 Capital ProjectFund 096 | Not listed as its own line | Not listed as its own line | $0.00 | $0.00 | $0.00 | p. 12 |
| Tax CollectionsFund 100 | Not listed as its own line | Not listed as its own line | $0.00 | $0.00 | $0.00 | p. 12 |
| Family Protection FundFund 106 | Not listed as its own line | Not listed as its own line | $0.00 | $0.00 | $58.90 | p. 14 |
| Public Improvement DistrictsFund 118 | Not listed as its own line | Not listed as its own line | $0.00 | $0.00 | $16.66 | p. 16 |
| Records PreservationFund 125 | $625,000.00 | Not listed as its own line | $0.00 | $0.00 | $0.00 | p. 20 |
| County Records Preservation FundFund 126 | $0.00 | Not listed as its own line | $0.00 | $0.00 | $0.00 | p. 17 |
| Disaster RecoveryFund 145 | Not listed as its own line | Not listed as its own line | $0.00 | $0.00 | $19,039.12 | p. 21 |
| AACOG Recycling GrantsFund 146 | Not listed as its own line | Not listed as its own line | $0.00 | $0.00 | $10,237.32 | p. 21 |
| Protective Order ProsecutorFund 152 | Not listed as its own line | Not listed as its own line | $0.00 | $0.00 | $2,164.55 | p. 22 |
| OAG SAVNS GrantFund 154 | Not listed as its own line | Not listed as its own line | $0.00 | $0.00 | $0.00 | p. 25 |
| DSHS COVID-19 CrisisFund 155 | Not listed as its own line | Not listed as its own line | $0.00 | $0.00 | $0.00 | p. 23 |
| TJJD Grant SFund 156 | Not listed as its own line | Not listed as its own line | $0.00 | $0.00 | $3,202.30 | p. 23 |
| TJJD Detention ReimbursementFund 161 | Not listed as its own line | Not listed as its own line | $0.00 | $0.00 | $0.00 | p. 24 |
| SAFE ProgramFund 163 | Not listed as its own line | Not listed as its own line | $0.00 | $5,270.00 | -$7,527.50 | p. 24 |
| Protect. Order Victim Assist.Fund 164 | Not listed as its own line | Not listed as its own line | $0.00 | $0.00 | $4,989.30 | p. 24 |
| Rifle-Resistant Body Armor GrantFund 168 | Not listed as its own line | Not listed as its own line | $0.00 | $0.00 | $0.00 | p. 25 |
| OJP JAG GrantFund 169 | Not listed as its own line | Not listed as its own line | $0.00 | $0.00 | $3.48 | p. 25 |
| CJD Sexual Assault Domestic ViolFund 170 | Not listed as its own line | Not listed as its own line | $0.00 | $0.00 | $0.00 | p. 25 |
| TIDCFund 171 | Not listed as its own line | Not listed as its own line | $0.00 | $0.00 | $0.00 | p. 25 |
| VAW ProsecutorFund 172 | Not listed as its own line | Not listed as its own line | $0.00 | $0.00 | $0.00 | p. 26 |
| DOJ BJA Edward Bryne JAG GrantFund 174 | Not listed as its own line | Not listed as its own line | $0.00 | $0.00 | $0.00 | p. 26 |
| VAW Victims Assistance CoordFund 175 | Not listed as its own line | Not listed as its own line | $0.00 | $0.00 | $0.00 | p. 26 |
| VAW Victims Assistance CoordFund 176 | Not listed as its own line | Not listed as its own line | $0.00 | $0.00 | $0.00 | p. 26 |
| BVP GrantFund 178 | Not listed as its own line | Not listed as its own line | $0.00 | $0.00 | $0.00 | p. 27 |
| CJD Crime Victim Liasion GrantFund 179 | Not listed as its own line | Not listed as its own line | $0.00 | $0.00 | $0.00 | p. 27 |
| Regional Habitat ConservationFund 180 | Not listed as its own line | Not listed as its own line | $0.00 | $0.00 | $18,049.11 | p. 27 |
| DSHS Covid-19 Immunization GrantFund 184 | Not listed as its own line | Not listed as its own line | $0.00 | $22.14 | $24,245.61 | p. 28 |
| DSHS Public Health WorkforceFund 185 | Not listed as its own line | Not listed as its own line | $0.00 | $0.00 | $0.00 | p. 28 |
| DSHS Covid-19 Health DisparitiesFund 186 | Not listed as its own line | Not listed as its own line | $0.00 | $0.00 | $26,501.35 | p. 28 |
| OOG Forensic Testing ProgramFund 187 | Not listed as its own line | Not listed as its own line | $0.00 | $0.00 | $0.00 | p. 28 |
| TVC General Assistance ProgramFund 192 | Not listed as its own line | Not listed as its own line | $0.00 | $0.00 | $0.13 | p. 29 |
| County Cash (Frost) (10,820.23) 0.00 4,811.16 (15,631.39)Fund 401 | Not listed as its own line | Not listed as its own line | $0.00 | $4,811.16 | -$15,631.39 | p. 23 |
| 0 00.00Fund 900 | Not listed as its own line | Not listed as its own line | $0.00 | $0.00 | $0.00 | p. 26 |
| Indigent Health CareFund 113 | $1,748,135.00 | Not listed as its own line | OCR row excluded / absent | — | — | — |
| Sheriff's Chapter 59 ForfeitureFund 116 | $38,000.00 | Not listed as its own line | OCR row excluded / absent | — | — | — |
| District Clerk Records PreservatFund 133 | $77,000.00 | Not listed as its own line | OCR row excluded / absent | — | — | — |
| CDA Bond CommissionFund 149 | $11,500.00 | Not listed as its own line | OCR row excluded / absent | — | — | — |
| Capital ProjectsFund capital-projects | Not listed as its own line | $27,818.00 | OCR row excluded / absent | — | — | — |
| Other Governmental FundsFund other-governmental | Not listed as its own line | $8,281,324.00 | OCR row excluded / absent | — | — | — |
Accounting boundary: Treasury “cash in” means debits to cash and investment accounts, not necessarily outside revenue. The FY2025 ACFR source components also carry a published $1.00 presentation difference from its official total; the official total and fund columns agree.
Aggregated County ledger
Open transactions Net claim-line activity by packet year
Indexed transaction amounts after credit rows, grouped by the date of the official weekly claims packet.
County weekly financial-claims packets. Includes indexed sections of partial packets; excludes unitemized cover amounts and missing transaction rows.
Freshness & proof
Verify sources What the ledger is telling you
01102 packets need further extraction1 partly indexed; missing sections are excluded from totals0213 of 13 data gates passRows, totals, sources, payees, and flow paths reconcile0386,075 rows retain evidenceOpen the official packet from any visible transaction
Freshness gaps stay visible and are never filled with estimates.
Accounting structure
Explore funds Largest County funds
Claim-line totals grouped by the County fund identifiers in the audit database.
General FundFund · 49,474 claims$206.8M2016 Capital ProjectFund · 769 claims$61.4MRoad and Bridge FundFund · 15,336 claims$54.1MDebt ServiceFund · 99 claims$45.9MFund Fund · 2,811 claims$27.6MAmerican Rescue Plan ActFund · 186 claims$16.2M
The ten largest funds shown above account for $443.1M in gross indexed claim lines.
Money received
Explore payees Largest County payees
Gross indexed claim lines across all retained packet years, including indexed sections; payee histories apply credits to annual net amounts.
1Amegy Bank of Texas50 claims$38.9MOpen history2SPAWGLASS CONTRACTORS, INC.64 claims$34.8MOpen history3TEXAS ASSOC OF COUNTIES459 claims$22.7MOpen history4YATES/SUNDT JOINT VENTURE26 claims$22.5MOpen history5Vining Sparks74 claims$22.4MOpen history6TEXAS MATERIALS GROUP, INC. dba GULF COAST1,006 claims$16MOpen history
Follow the County ledger
Live RPC snapshotSee how claim dollars move through the accounting structure
These maps reuse the working flow queries from the original Comal audit dashboard. Line width represents the relative claim-line amount.
Mapped amount$405.3MLeading sources5Leading destinations6Coverage2020–present
01General FundAdministrative Costs$92.3M
02Road and Bridge FundMaintenance & Operations$47.9M
03Debt ServiceGeneral$42.1M
04General FundSheriff$27.6M
05General FundJail$27.5M
062016 Capital ProjectAdministrative Costs$24.6M
072016 Capital ProjectJail$20.2M
08Comal County Health InsuranceCCHI$15.2M
The maps show the largest retained links from the County reporting functions. They are directional groupings of claim lines, not transfers between bank accounts.
Complete indexed transaction ledger
Every Comal County claim line available in the database
This is the full 86,075-row ledger—not a top-payee list or a recent-transaction sample. Each row retains its accounting codes and official claims packet; click any transaction to open its source detail and related payee history.
Indexed claim lines86,075$463,283,776.01 net after 2,172 credits · $472,628,201.73 gross
Loading all indexed ledger years…
Explore the live County snapshot
Search the actual Comal County records
Every row below comes from the existing Supabase-backed County project, refreshed into this site with its original identifiers and source links.
Loading County records…
Upstream record
Download snapshot Official County sources remain one click away
Supabase is the working index; the County PDFs remain the evidence.
Budgeted revenue, audited revenue, Treasury cash activity, claim lines, and issued checks remain separate. Adding them together would double-count unlike accounting records.
Every row is traceable
Transactions retain the County packet, date, payee, invoice context, and accounting path available in the database.
Freshness is visible
Published packets waiting for extraction remain an explicit queue instead of disappearing behind an “updated” label.
Claims are not checks
Approved claim lines and issued-check records stay separate so overlapping amounts are not quietly counted twice.