Exhibit F - Dental Claims Incurred and Claims Paid.xlsx
XLSX spreadsheet 23 KB Posted
- Attached to
- Dental Benefits Program
- Solicitation number
- RFP AABA 2027000021 2
- Issued by
- Denver County, Denver City, Colorado
About this file
Exhibit F is a dental claims data file for the Colorado Dental Benefits Program, documenting claims incurred and paid by Master Account ID 00000007649 across two benefit plan categories: Basic and Basic Plus. The file contains detailed records of dental claims spanning from May 2025 through June 2026, with incurrence months ranging from May 2025 back to June 2025 and payment months occurring between May 2025 and June 2026. The data is organized by incurrence month, payment month, and corresponding paid amounts for each claim record, enabling tracking of claim processing timelines and payment patterns across the dental benefits portfolio.
The Basic plan category generated total dental claims paid of $7,768,453.16, while the Basic Plus plan category produced significantly higher claims of $21,035,815.22, reflecting substantially greater utilization or claim values under the enhanced plan option. The data demonstrates typical dental claim payment patterns with claims incurred in earlier months often paid in subsequent months, indicating standard claims processing lag times. The largest single monthly payments occur in months where claims incurred in the immediate prior month are processed, with notable payments in April 2026 ($510,774.18 for Basic and $1,229,849.58 for Basic Plus for April incurrence), indicating consistent claim volume and processing activity throughout the contract period.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Exhibit C - Cost Exhibit.xlsx | XLSX spreadsheet | |
| Exhibit B - Offeror Questionnaire.xlsx | XLSX spreadsheet | |
| Administrative Information for RFP AABA 2027-0021.pdf | ||
| Exhibit D - Information Technology Contract.docx | DOCX document | |
| Exhibit A - Specifications and Requirements for RFP AABA 2027-0021.pdf | ||
| Exhibit E - W-9 - Fillable.pdf |
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
Basic
| Master Account ID | IncurMonth | PaidMonth | Paid Amount |
| Totals | $7,768,453.16 | ||
| 00000007649 | Apr 2026 | Jun 2026 | $7,405.60 |
| 00000007649 | Mar 2026 | Jun 2026 | $4,568.72 |
| 00000007649 | Feb 2026 | Jun 2026 | $1,157.70 |
| 00000007649 | Jan 2026 | Jun 2026 | $2,448.70 |
| 00000007649 | Dec 2025 | Jun 2026 | $570.50 |
| 00000007649 | Nov 2025 | Jun 2026 | $357.60 |
| 00000007649 | Oct 2025 | Jun 2026 | $1,119.00 |
| 00000007649 | Sep 2025 | Jun 2026 | $308.50 |
| 00000007649 | Aug 2025 | Jun 2026 | $406.00 |
| 00000007649 | Jul 2025 | Jun 2026 | $165.60 |
| 00000007649 | Jun 2025 | Jun 2026 | $457.00 |
| 00000007649 | Apr 2026 | May 2026 | $144,397.06 |
| 00000007649 | Mar 2026 | May 2026 | $9,100.63 |
| 00000007649 | Feb 2026 | May 2026 | $1,887.24 |
| 00000007649 | Jan 2026 | May 2026 | $1,850.81 |
| 00000007649 | Dec 2025 | May 2026 | $1,938.10 |
| 00000007649 | Nov 2025 | May 2026 | $428.12 |
| 00000007649 | Oct 2025 | May 2026 | $153.00 |
| 00000007649 | Sep 2025 | May 2026 | $626.00 |
| 00000007649 | Aug 2025 | May 2026 | $312.50 |
| 00000007649 | Jul 2025 | May 2026 | $141.40 |
| 00000007649 | Jun 2025 | May 2026 | $106.00 |
| 00000007649 | May 2025 | May 2026 | $116.00 |
| 00000007649 | Apr 2026 | Apr 2026 | $510,774.18 |
| 00000007649 | Mar 2026 | Apr 2026 | $144,465.16 |
| 00000007649 | Feb 2026 | Apr 2026 | $9,829.31 |
| 00000007649 | Jan 2026 | Apr 2026 | $4,608.76 |
| 00000007649 | Dec 2025 | Apr 2026 | $1,982.14 |
| 00000007649 | Nov 2025 | Apr 2026 | $609.00 |
| 00000007649 | Oct 2025 | Apr 2026 | $104.21 |
| 00000007649 | Sep 2025 | Apr 2026 | $911.67 |
| 00000007649 | Aug 2025 | Apr 2026 | $400.79 |
| 00000007649 | Jul 2025 | Apr 2026 | $247.70 |
| 00000007649 | Jun 2025 | Apr 2026 | $544.48 |
| 00000007649 | May 2025 | Apr 2026 | $166.00 |
| 00000007649 | Mar 2026 | Mar 2026 | $543,099.25 |
| 00000007649 | Feb 2026 | Mar 2026 | $127,186.98 |
| 00000007649 | Jan 2026 | Mar 2026 | $8,516.30 |
| 00000007649 | Dec 2025 | Mar 2026 | $4,636.52 |
| 00000007649 | Nov 2025 | Mar 2026 | $794.00 |
| 00000007649 | Oct 2025 | Mar 2026 | $3,391.50 |
| 00000007649 | Sep 2025 | Mar 2026 | $488.00 |
| 00000007649 | Aug 2025 | Mar 2026 | $1,829.80 |
| 00000007649 | Jul 2025 | Mar 2026 | $1,158.00 |
| 00000007649 | Jun 2025 | Mar 2026 | $381.81 |
| 00000007649 | May 2025 | Mar 2026 | $538.00 |
| 00000007649 | Feb 2026 | Feb 2026 | $495,428.45 |
| 00000007649 | Jan 2026 | Feb 2026 | $119,973.01 |
| 00000007649 | Dec 2025 | Feb 2026 | $9,058.30 |
| 00000007649 | Nov 2025 | Feb 2026 | $3,159.96 |
| 00000007649 | Oct 2025 | Feb 2026 | $4,778.91 |
| 00000007649 | Sep 2025 | Feb 2026 | $437.10 |
| 00000007649 | Aug 2025 | Feb 2026 | $563.41 |
| 00000007649 | Jul 2025 | Feb 2026 | $1,266.70 |
| 00000007649 | Jun 2025 | Feb 2026 | $285.28 |
| 00000007649 | May 2025 | Feb 2026 | $409.19 |
| 00000007649 | Jan 2026 | Jan 2026 | $503,918.43 |
| 00000007649 | Dec 2025 | Jan 2026 | $132,518.18 |
| 00000007649 | Nov 2025 | Jan 2026 | $5,283.61 |
| 00000007649 | Oct 2025 | Jan 2026 | $6,031.54 |
| 00000007649 | Sep 2025 | Jan 2026 | $4,919.93 |
| 00000007649 | Aug 2025 | Jan 2026 | $654.16 |
| 00000007649 | Jul 2025 | Jan 2026 | $532.80 |
| 00000007649 | Jun 2025 | Jan 2026 | $1,113.70 |
| 00000007649 | May 2025 | Jan 2026 | $347.50 |
| 00000007649 | Dec 2025 | Dec 2025 | $460,140.46 |
| 00000007649 | Nov 2025 | Dec 2025 | $141,964.22 |
| 00000007649 | Oct 2025 | Dec 2025 | $17,908.18 |
| 00000007649 | Sep 2025 | Dec 2025 | $13,008.96 |
| 00000007649 | Aug 2025 | Dec 2025 | $6,911.42 |
| 00000007649 | Jul 2025 | Dec 2025 | $4,258.57 |
| 00000007649 | Jun 2025 | Dec 2025 | $551.30 |
| 00000007649 | May 2025 | Dec 2025 | $1,633.46 |
| 00000007649 | Nov 2025 | Nov 2025 | $393,930.90 |
| 00000007649 | Oct 2025 | Nov 2025 | $91,390.20 |
| 00000007649 | Sep 2025 | Nov 2025 | $6,068.07 |
| 00000007649 | Aug 2025 | Nov 2025 | $3,823.60 |
| 00000007649 | Jul 2025 | Nov 2025 | $3,239.69 |
| 00000007649 | Jun 2025 | Nov 2025 | $604.40 |
| 00000007649 | May 2025 | Nov 2025 | $418.30 |
| 00000007649 | Oct 2025 | Oct 2025 | $565,618.57 |
| 00000007649 | Sep 2025 | Oct 2025 | $112,006.29 |
| 00000007649 | Aug 2025 | Oct 2025 | $9,499.30 |
| 00000007649 | Jul 2025 | Oct 2025 | $4,407.80 |
| 00000007649 | Jun 2025 | Oct 2025 | $1,664.60 |
| 00000007649 | May 2025 | Oct 2025 | $1,821.90 |
| 00000007649 | Sep 2025 | Sep 2025 | $520,304.24 |
| 00000007649 | Aug 2025 | Sep 2025 | $131,535.28 |
| 00000007649 | Jul 2025 | Sep 2025 | $11,043.71 |
| 00000007649 | Jun 2025 | Sep 2025 | $7,573.10 |
| 00000007649 | May 2025 | Sep 2025 | $1,184.10 |
| 00000007649 | Aug 2025 | Aug 2025 | $462,244.07 |
| 00000007649 | Jul 2025 | Aug 2025 | $132,900.02 |
| 00000007649 | Jun 2025 | Aug 2025 | $12,628.92 |
| 00000007649 | May 2025 | Aug 2025 | $4,913.59 |
| 00000007649 | Jul 2025 | Jul 2025 | $538,645.90 |
| 00000007649 | Jun 2025 | Jul 2025 | $133,948.46 |
| 00000007649 | May 2025 | Jul 2025 | $8,532.80 |
| 00000007649 | Jun 2025 | Jun 2025 | $491,252.17 |
| 00000007649 | May 2025 | Jun 2025 | $110,490.67 |
| 00000007649 | May 2025 | May 2025 | $523,020.44 |
Basic Plus
| Master Account ID | IncurMonth | PaidMonth | Paid Amount |
| Totals | $21,035,815.22 | ||
| 00000007649 | Apr 2026 | Jun 2026 | $54,408.41 |
| 00000007649 | Mar 2026 | Jun 2026 | $12,051.50 |
| 00000007649 | Feb 2026 | Jun 2026 | $5,131.60 |
| 00000007649 | Jan 2026 | Jun 2026 | $10,671.85 |
| 00000007649 | Dec 2025 | Jun 2026 | $4,263.20 |
| 00000007649 | Nov 2025 | Jun 2026 | $3,536.40 |
| 00000007649 | Oct 2025 | Jun 2026 | $3,032.80 |
| 00000007649 | Sep 2025 | Jun 2026 | $4,100.73 |
| 00000007649 | Aug 2025 | Jun 2026 | $2,131.00 |
| 00000007649 | Jul 2025 | Jun 2026 | $1,207.20 |
| 00000007649 | Jun 2025 | Jun 2026 | $2,869.00 |
| 00000007649 | May 2025 | Jun 2026 | $1,738.80 |
| 00000007649 | Apr 2026 | May 2026 | $430,007.72 |
| 00000007649 | Mar 2026 | May 2026 | $50,761.68 |
| 00000007649 | Feb 2026 | May 2026 | $15,400.29 |
| 00000007649 | Jan 2026 | May 2026 | $12,320.28 |
| 00000007649 | Dec 2025 | May 2026 | $6,093.77 |
| 00000007649 | Nov 2025 | May 2026 | $6,802.17 |
| 00000007649 | Oct 2025 | May 2026 | $2,003.69 |
| 00000007649 | Sep 2025 | May 2026 | $4,475.57 |
| 00000007649 | Aug 2025 | May 2026 | $213.67 |
| 00000007649 | Jul 2025 | May 2026 | $2,119.77 |
| 00000007649 | Jun 2025 | May 2026 | $794.37 |
| 00000007649 | May 2025 | May 2026 | $2,116.00 |
| 00000007649 | Apr 2026 | Apr 2026 | $1,229,849.58 |
| 00000007649 | Mar 2026 | Apr 2026 | $460,450.17 |
| 00000007649 | Feb 2026 | Apr 2026 | $58,532.59 |
| 00000007649 | Jan 2026 | Apr 2026 | $20,089.44 |
| 00000007649 | Dec 2025 | Apr 2026 | $16,388.00 |
| 00000007649 | Nov 2025 | Apr 2026 | $9,245.14 |
| 00000007649 | Oct 2025 | Apr 2026 | $4,634.18 |
| 00000007649 | Sep 2025 | Apr 2026 | $4,815.76 |
| 00000007649 | Aug 2025 | Apr 2026 | $26.54 |
| 00000007649 | Jul 2025 | Apr 2026 | $4,529.37 |
| 00000007649 | Jun 2025 | Apr 2026 | $2,348.97 |
| 00000007649 | May 2025 | Apr 2026 | $2,747.96 |
| 00000007649 | Mar 2026 | Mar 2026 | $1,289,933.03 |
| 00000007649 | Feb 2026 | Mar 2026 | $410,622.56 |
| 00000007649 | Jan 2026 | Mar 2026 | $38,849.54 |
| 00000007649 | Dec 2025 | Mar 2026 | $20,650.73 |
| 00000007649 | Nov 2025 | Mar 2026 | $10,746.97 |
| 00000007649 | Oct 2025 | Mar 2026 | $9,265.49 |
| 00000007649 | Sep 2025 | Mar 2026 | $2,426.40 |
| 00000007649 | Aug 2025 | Mar 2026 | $1,278.92 |
| 00000007649 | Jul 2025 | Mar 2026 | $3,249.40 |
| 00000007649 | Jun 2025 | Mar 2026 | $717.22 |
| 00000007649 | May 2025 | Mar 2026 | $711.63 |
| 00000007649 | Feb 2026 | Feb 2026 | $1,213,534.70 |
| 00000007649 | Jan 2026 | Feb 2026 | $374,090.53 |
| 00000007649 | Dec 2025 | Feb 2026 | $52,310.01 |
| 00000007649 | Nov 2025 | Feb 2026 | $17,246.81 |
| 00000007649 | Oct 2025 | Feb 2026 | $12,732.14 |
| 00000007649 | Sep 2025 | Feb 2026 | $5,412.20 |
| 00000007649 | Aug 2025 | Feb 2026 | $7,420.00 |
| 00000007649 | Jul 2025 | Feb 2026 | $4,882.60 |
| 00000007649 | Jun 2025 | Feb 2026 | $3,467.80 |
| 00000007649 | May 2025 | Feb 2026 | $2,985.90 |
| 00000007649 | Jan 2026 | Jan 2026 | $1,240,035.87 |
| 00000007649 | Dec 2025 | Jan 2026 | $412,938.54 |
| 00000007649 | Nov 2025 | Jan 2026 | $42,414.07 |
| 00000007649 | Oct 2025 | Jan 2026 | $23,995.46 |
| 00000007649 | Sep 2025 | Jan 2026 | $20,007.55 |
| 00000007649 | Aug 2025 | Jan 2026 | $6,006.30 |
| 00000007649 | Jul 2025 | Jan 2026 | $6,127.18 |
| 00000007649 | Jun 2025 | Jan 2026 | $2,168.00 |
| 00000007649 | May 2025 | Jan 2026 | $134.00 |
| 00000007649 | Dec 2025 | Dec 2025 | $1,186,817.27 |
| 00000007649 | Nov 2025 | Dec 2025 | $461,079.40 |
| 00000007649 | Oct 2025 | Dec 2025 | $61,911.71 |
| 00000007649 | Sep 2025 | Dec 2025 | $29,943.65 |
| 00000007649 | Aug 2025 | Dec 2025 | $13,429.01 |
| 00000007649 | Jul 2025 | Dec 2025 | $16,085.24 |
| 00000007649 | Jun 2025 | Dec 2025 | $5,362.20 |
| 00000007649 | May 2025 | Dec 2025 | $4,642.32 |
| 00000007649 | Nov 2025 | Nov 2025 | $1,005,747.98 |
| 00000007649 | Oct 2025 | Nov 2025 | $272,510.50 |
| 00000007649 | Sep 2025 | Nov 2025 | $26,801.93 |
| 00000007649 | Aug 2025 | Nov 2025 | $22,519.05 |
| 00000007649 | Jul 2025 | Nov 2025 | $24,428.50 |
| 00000007649 | Jun 2025 | Nov 2025 | $2,680.10 |
| 00000007649 | May 2025 | Nov 2025 | $674.90 |
| 00000007649 | Oct 2025 | Oct 2025 | $1,463,333.90 |
| 00000007649 | Sep 2025 | Oct 2025 | $328,756.99 |
| 00000007649 | Aug 2025 | Oct 2025 | $47,348.90 |
| 00000007649 | Jul 2025 | Oct 2025 | $24,128.40 |
| 00000007649 | Jun 2025 | Oct 2025 | $7,690.53 |
| 00000007649 | May 2025 | Oct 2025 | $4,241.20 |
| 00000007649 | Sep 2025 | Sep 2025 | $1,315,024.97 |
| 00000007649 | Aug 2025 | Sep 2025 | $420,102.73 |
| 00000007649 | Jul 2025 | Sep 2025 | $65,835.63 |
| 00000007649 | Jun 2025 | Sep 2025 | $18,158.92 |
| 00000007649 | May 2025 | Sep 2025 | $6,841.11 |
| 00000007649 | Aug 2025 | Aug 2025 | $1,282,712.93 |
| 00000007649 | Jul 2025 | Aug 2025 | $521,965.23 |
| 00000007649 | Jun 2025 | Aug 2025 | $37,190.10 |
| 00000007649 | May 2025 | Aug 2025 | $16,167.93 |
| 00000007649 | Jul 2025 | Jul 2025 | $1,511,656.93 |
| 00000007649 | Jun 2025 | Jul 2025 | $406,360.05 |
| 00000007649 | May 2025 | Jul 2025 | $39,447.08 |
| 00000007649 | Jun 2025 | Jun 2025 | $1,237,738.08 |
| 00000007649 | May 2025 | Jun 2025 | $314,478.09 |
| 00000007649 | May 2025 | May 2025 | $1,143,731.04 |
File details come from the government source that posted it. Updated .