Exhibit 32 - Cal Yr 2023 CIty of Miami CIGNA Lag Report Incurred Date included - Monthly Healthcare Experience Lag Report by Acct Rolling 12-1.xlsx
XLSX spreadsheet 32 KB Posted
- Attached to
- RFP No. 2130386 - Employee Health Benefits Plan
- Solicitation number
- RFP No. 2130386 - Employee Health Benefits Plan
- Issued by
- Florida
About this file
The document is a Monthly Healthcare Experience Lag Report for the City of Miami's healthcare claims, covering the calendar year 2023 and prepared in conjunction with CIGNA. The report tracks paid claims across multiple years, with a comprehensive matrix detailing monthly claims data from October 2015 through December 2023, associated with a retrospective experience-rated healthcare benefits plan. The report is linked to RFP No. 2130386 for an Employee Health Benefits Plan for the State of Florida.
The total paid claims for the year amount to $41,452,000, with significant monthly variations. The claims data shows granular tracking of healthcare expenses, including adjustments and retrospective corrections across different incurred date periods. The report appears to be a critical financial document used for healthcare plan management, allowing the City of Miami to analyze healthcare spending trends, claims history, and potential cost management strategies. The document is marked as proprietary and confidential, with strict limitations on disclosure.
View the file
Other files
Show 40 more
Latest 50 of 115 listed here. See the rest on GovTribe.
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
Lag by Acct Rllg12-1
| CITY OF MIAMI | ||||||||||||||
| MONTHLY HEALTHCARE LAG REPORT | ||||||||||||||
| January 2023 thru December 2023 | ||||||||||||||
| EXHIBIT 32 | ||||||||||||||
| Incurred Date : All | ||||||||||||||
| Rating Type : RETROSPECTIVE EXPERIENCE RATED | ||||||||||||||
| Reported Claims: All Claims | ||||||||||||||
| ACCOUNT | INCURRED DATE | Jan-2023 | Feb-2023 | Mar-2023 | Apr-2023 | May-2023 | Jun-2023 | Jul-2023 | Aug-2023 | Sep-2023 | Oct-2023 | Nov-2023 | Dec-2023 | TOTAL PAID CLAIMS |
| 3202272 | Oct-15 | $0 | $0 | ($116) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ($116) |
| May-16 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $152 | $0 | $0 | $152 | |
| Jul-16 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $131 | $0 | $0 | $131 | |
| Nov-16 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $131 | $0 | $0 | $131 | |
| Feb-17 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $131 | $0 | $0 | $131 | |
| Mar-17 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $152 | $0 | $0 | $152 | |
| Apr-17 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $137 | $0 | $0 | $137 | |
| May-17 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $25 | $0 | $0 | $25 | |
| Jun-17 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $125 | $0 | $0 | $125 | |
| Jul-17 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $134 | $0 | $0 | $134 | |
| Aug-17 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $204 | $0 | $0 | $204 | |
| Sep-17 | $0 | $0 | $0 | $0 | $13 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $13 | |
| Oct-17 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $185 | $0 | $0 | $185 | |
| Nov-17 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ($706) | $125 | $0 | $0 | ($581) | |
| Feb-18 | $0 | $0 | $0 | $0 | $49 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $49 | |
| Mar-18 | $0 | $0 | $0 | $0 | $23 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $23 | |
| Apr-18 | $129 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $129 | |
| May-18 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ($3,000) | $0 | $0 | $0 | $0 | ($3,000) | |
| Jun-18 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $220 | $134 | $0 | $0 | $354 | |
| Jul-18 | $32 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $270 | $0 | $0 | $302 | |
| Aug-18 | $165 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $154 | $0 | $0 | $320 | |
| Sep-18 | $0 | $0 | $0 | $0 | $23 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $23 | |
| Dec-18 | ($27) | $0 | $0 | $0 | $92 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $65 | |
| Jan-19 | $0 | $0 | $0 | $0 | $116 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $116 | |
| Feb-19 | $395 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $395 | |
| Mar-19 | $772 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ($1,301) | $0 | ($530) | |
| Apr-19 | $0 | $0 | ($1,086) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ($1,086) | |
| May-19 | ($16) | $0 | $0 | $0 | $172 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $156 | |
| Jun-19 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ($6) | $0 | $0 | $0 | ($6) | |
| Jul-19 | $0 | ($91) | ($274) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ($365) | |
| Aug-19 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $144 | $0 | $0 | $144 | |
| Sep-19 | $0 | $0 | $0 | ($17,500) | ($523) | $0 | $0 | $0 | $0 | $0 | ($346) | $0 | ($18,369) | |
| Nov-19 | $0 | $0 | $0 | $0 | $23 | $0 | $0 | $0 | $0 | $0 | ($44) | $0 | ($21) | |
| Dec-19 | $325 | $0 | $0 | $327 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $652 | |
| Jan-20 | $0 | $0 | $0 | $0 | $49 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $49 | |
| Feb-20 | $0 | $0 | $100 | $358 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $458 | |
| Mar-20 | $0 | $0 | $500 | $0 | $11 | $0 | $0 | $107 | $0 | $0 | $0 | $0 | $618 | |
| Apr-20 | $0 | $0 | $900 | $0 | ($4,522) | $0 | $0 | ($117) | $0 | $224 | $0 | $0 | ($3,515) | |
| May-20 | $0 | $0 | ($33) | $0 | $0 | $0 | $0 | $0 | $0 | $118 | $0 | $0 | $85 | |
| Jun-20 | $0 | $0 | $0 | $0 | ($397) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ($397) | |
| Aug-20 | $42 | $41 | ($8,350) | $0 | $0 | ($320) | $0 | $0 | $0 | $117 | $0 | $0 | ($8,470) | |
| Sep-20 | $84 | $42 | $137 | $0 | ($18,482) | ($39) | $0 | $0 | $0 | $0 | $0 | $0 | ($18,258) | |
| Oct-20 | $42 | ($13,071) | ($3) | $0 | $23 | ($20) | $269 | $0 | $0 | $0 | $0 | $0 | ($12,760) | |
| Nov-20 | $42 | $42 | ($19) | ($319) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ($253) | |
| Dec-20 | $84 | ($21,417) | $84 | ($38,073) | $0 | ($21) | ($21) | ($623) | ($294) | $0 | $0 | $0 | ($60,280) | |
| Jan-21 | $84 | $7 | $84 | $0 | ($83) | $0 | $0 | $0 | $0 | $111 | $0 | $0 | $204 | |
| Feb-21 | $338 | $83 | $0 | $0 | ($18,482) | $0 | $0 | ($828) | $0 | $0 | ($29,740) | $0 | ($48,630) | |
| Mar-21 | $39 | $84 | $0 | ($1,245) | $205 | $0 | ($57) | $0 | $0 | $5 | ($225,000) | $0 | ($225,968) | |
| Apr-21 | $56 | ($178) | ($583) | ($7,995) | $25 | $145 | $82 | $445 | $0 | $0 | $0 | ($92) | ($8,094) | |
| May-21 | $251 | $42 | $76 | $0 | ($245) | $0 | $302 | $151 | $0 | $0 | $0 | $0 | $577 | |
| Jun-21 | $26 | ($577) | ($416) | $0 | $0 | $0 | $519 | $0 | $10 | $0 | ($324) | $99 | ($662) | |
| Jul-21 | $399 | $134 | ($852) | $40 | ($29,729) | $0 | $151 | $8 | $0 | $101 | ($3) | $0 | ($29,750) | |
| Aug-21 | ($14,070) | $115 | $742 | ($5) | $0 | $0 | $520 | $40 | $1,628 | $0 | ($35,126) | $31,890 | ($14,266) | |
| Sep-21 | ($4,295) | ($412) | $394 | ($31,986) | $677 | $64 | $111 | $27 | $0 | $0 | ($25) | $0 | ($35,445) | |
| Oct-21 | $944 | ($802) | $670 | $0 | $2,257 | $0 | $151 | $381 | $152 | $76 | $0 | $0 | $3,828 | |
| Nov-21 | $2,823 | $164 | $79 | $183 | $516 | $229 | ($16,841) | $0 | $0 | $4,562 | $0 | $0 | ($8,285) | |
| Dec-21 | $455 | $2,357 | $1,765 | $41 | ($230) | ($471) | ($38,859) | ($117) | ($15,015) | ($27,967) | $0 | ($20,436) | ($98,475) | |
| Jan-22 | $1,247 | $304 | ($620) | $1,655 | $195 | $0 | ($137) | $519 | $416 | $0 | $0 | $39 | $3,618 | |
| Feb-22 | $2,443 | ($4,821) | ($362) | $347 | $3,506 | $47,382 | $0 | ($407) | $366 | $0 | ($69) | ($45) | $48,340 | |
| Mar-22 | $74,668 | $427 | $13,374 | ($564) | ($16,530) | ($158) | ($19,682) | $80 | ($1,968) | $272 | ($990) | $39 | $48,966 | |
| Apr-22 | $11,704 | ($1,940) | ($913) | ($60,837) | $26,680 | $1,173 | ($3,918) | ($10,454) | $9,843 | ($340) | ($871) | $39 | ($29,834) | |
| May-22 | $45,175 | $6,620 | ($17) | $919 | $744 | $10,345 | $2,158 | ($50) | $3,505 | $818 | ($530) | $6 | $69,694 | |
| Jun-22 | $28,709 | $28,822 | $244 | $2,333 | ($492) | $33 | $59,893 | ($72) | $6,636 | ($2,677) | $103 | $18,247 | $141,779 | |
| Jul-22 | $2,331 | $37,495 | $135 | $4,587 | $247 | ($520) | $78 | $5,143 | $5,493 | $19,032 | $0 | $7,676 | $81,696 | |
| Aug-22 | $3,314 | ($5,286) | $5,935 | $8,789 | $258 | $16,507 | $97,766 | $103,410 | ($39,422) | $20,490 | $45,022 | $3,508 | $260,291 | |
| Sep-22 | $41,663 | $31,901 | $2,274 | $5,160 | ($20,734) | $1,085 | $9,276 | $15,316 | $4,417 | ($1,456) | $278 | ($64) | $89,117 | |
| Oct-22 | $164,118 | $48,566 | $19,119 | $10,159 | $60,035 | $6,450 | $24,349 | $3,556 | $3,918 | $635 | $11,008 | $537 | $352,449 | |
| Nov-22 | $130,990 | $46,457 | $268,436 | ($81,676) | $6,161 | $5,897 | $13,877 | $51,713 | $5,866 | $1,143 | ($613) | $2,453 | $450,704 | |
| Dec-22 | $1,136,141 | $433,448 | $105,511 | $58,928 | $151,461 | ($14,877) | ($803) | $5,771 | $11,343 | $658 | $20,659 | ($9,965) | $1,898,278 | |
| Jan-23 | $1,419,333 | $1,325,795 | $391,834 | $169,661 | $41,675 | $21,424 | $15,861 | $11,377 | $18,532 | $909 | $11,437 | $69,180 | $3,497,018 | |
| Feb-23 | $0 | $1,563,816 | $1,251,021 | $223,512 | $162,398 | $234,598 | $24,747 | $51,396 | $7,341 | $1,571 | $2,140 | $3,041 | $3,525,580 | |
| Mar-23 | $0 | $0 | $1,642,322 | $1,145,396 | $176,610 | $185,044 | $3,845 | ($1,439) | $8,002 | $11,017 | $5,675 | $1,192 | $3,177,663 | |
| Apr-23 | $0 | $0 | $0 | $1,494,580 | $1,389,845 | $199,605 | $25,331 | $253,387 | $19,852 | $13,491 | $35,229 | $2,189 | $3,433,509 | |
| May-23 | $0 | $0 | $0 | $0 | $1,791,831 | $1,188,554 | $269,562 | $114,286 | $12,912 | $6,759 | $9,858 | ($10,542) | $3,383,221 | |
| Jun-23 | $0 | $0 | $0 | $0 | $0 | $1,279,139 | $1,627,789 | $276,346 | $285,409 | $187,304 | $11,511 | ($1,801) | $3,665,697 | |
| Jul-23 | $0 | $0 | $0 | $0 | $0 | $0 | $1,495,587 | $1,460,893 | $206,089 | $63,980 | $35,580 | $32,038 | $3,294,167 | |
| Aug-23 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $1,562,326 | $1,267,523 | $270,678 | $91,003 | $56,611 | $3,248,141 | |
| Sep-23 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $1,492,419 | $1,318,069 | $131,878 | $74,027 | $3,016,393 | |
| Oct-23 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $1,916,113 | $1,331,154 | $258,326 | $3,505,592 | |
| Nov-23 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $1,760,190 | $1,395,811 | $3,156,001 | |
| Dec-23 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $1,721,432 | $1,721,432 | |
| ACCOUNT Total | $3,050,956 | $3,478,169 | $3,692,094 | $2,886,778 | $3,705,471 | $3,181,250 | $3,591,905 | $3,899,572 | $3,314,480 | $3,808,148 | $3,207,743 | $3,635,435 | $41,452,000 |
| INCURRED DATE Totals | Oct-15 | $0 | $0 | ($116) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ($116) |
| May-16 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $152 | $0 | $0 | $152 | |
| Jul-16 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $131 | $0 | $0 | $131 | |
| Nov-16 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $131 | $0 | $0 | $131 | |
| Feb-17 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $131 | $0 | $0 | $131 | |
| Mar-17 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $152 | $0 | $0 | $152 | |
| Apr-17 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $137 | $0 | $0 | $137 | |
| May-17 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $25 | $0 | $0 | $25 | |
| Jun-17 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $125 | $0 | $0 | $125 | |
| Jul-17 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $134 | $0 | $0 | $134 | |
| Aug-17 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $204 | $0 | $0 | $204 | |
| Sep-17 | $0 | $0 | $0 | $0 | $13 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $13 | |
| Oct-17 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $185 | $0 | $0 | $185 | |
| Nov-17 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ($706) | $125 | $0 | $0 | ($581) | |
| Feb-18 | $0 | $0 | $0 | $0 | $49 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $49 | |
| Mar-18 | $0 | $0 | $0 | $0 | $23 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $23 | |
| Apr-18 | $129 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $129 | |
| May-18 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ($3,000) | $0 | $0 | $0 | $0 | ($3,000) | |
| Jun-18 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $220 | $134 | $0 | $0 | $354 | |
| Jul-18 | $32 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $270 | $0 | $0 | $302 | |
| Aug-18 | $165 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $154 | $0 | $0 | $320 | |
| Sep-18 | $0 | $0 | $0 | $0 | $23 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $23 | |
| Dec-18 | ($27) | $0 | $0 | $0 | $92 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $65 | |
| Jan-19 | $0 | $0 | $0 | $0 | $116 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $116 | |
| Feb-19 | $395 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $395 | |
| Mar-19 | $772 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ($1,301) | $0 | ($530) | |
| Apr-19 | $0 | $0 | ($1,086) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ($1,086) | |
| May-19 | ($16) | $0 | $0 | $0 | $172 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $156 | |
| Jun-19 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ($6) | $0 | $0 | $0 | ($6) | |
| Jul-19 | $0 | ($91) | ($274) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ($365) | |
| Aug-19 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $144 | $0 | $0 | $144 | |
| Sep-19 | $0 | $0 | $0 | ($17,500) | ($523) | $0 | $0 | $0 | $0 | $0 | ($346) | $0 | ($18,369) | |
| Nov-19 | $0 | $0 | $0 | $0 | $23 | $0 | $0 | $0 | $0 | $0 | ($44) | $0 | ($21) | |
| Dec-19 | $325 | $0 | $0 | $327 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $652 | |
| Jan-20 | $0 | $0 | $0 | $0 | $49 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $49 | |
| Feb-20 | $0 | $0 | $100 | $358 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $458 | |
| Mar-20 | $0 | $0 | $500 | $0 | $11 | $0 | $0 | $107 | $0 | $0 | $0 | $0 | $618 | |
| Apr-20 | $0 | $0 | $900 | $0 | ($4,522) | $0 | $0 | ($117) | $0 | $224 | $0 | $0 | ($3,515) | |
| May-20 | $0 | $0 | ($33) | $0 | $0 | $0 | $0 | $0 | $0 | $118 | $0 | $0 | $85 | |
| Jun-20 | $0 | $0 | $0 | $0 | ($397) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ($397) | |
| Aug-20 | $42 | $41 | ($8,350) | $0 | $0 | ($320) | $0 | $0 | $0 | $117 | $0 | $0 | ($8,470) | |
| Sep-20 | $84 | $42 | $137 | $0 | ($18,482) | ($39) | $0 | $0 | $0 | $0 | $0 | $0 | ($18,258) | |
| Oct-20 | $42 | ($13,071) | ($3) | $0 | $23 | ($20) | $269 | $0 | $0 | $0 | $0 | $0 | ($12,760) | |
| Nov-20 | $42 | $42 | ($19) | ($319) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ($253) | |
| Dec-20 | $84 | ($21,417) | $84 | ($38,073) | $0 | ($21) | ($21) | ($623) | ($294) | $0 | $0 | $0 | ($60,280) | |
| Jan-21 | $84 | $7 | $84 | $0 | ($83) | $0 | $0 | $0 | $0 | $111 | $0 | $0 | $204 | |
| Feb-21 | $338 | $83 | $0 | $0 | ($18,482) | $0 | $0 | ($828) | $0 | $0 | ($29,740) | $0 | ($48,630) | |
| Mar-21 | $39 | $84 | $0 | ($1,245) | $205 | $0 | ($57) | $0 | $0 | $5 | ($225,000) | $0 | ($225,968) | |
| Apr-21 | $56 | ($178) | ($583) | ($7,995) | $25 | $145 | $82 | $445 | $0 | $0 | $0 | ($92) | ($8,094) | |
| May-21 | $251 | $42 | $76 | $0 | ($245) | $0 | $302 | $151 | $0 | $0 | $0 | $0 | $577 | |
| Jun-21 | $26 | ($577) | ($416) | $0 | $0 | $0 | $519 | $0 | $10 | $0 | ($324) | $99 | ($662) | |
| Jul-21 | $399 | $134 | ($852) | $40 | ($29,729) | $0 | $151 | $8 | $0 | $101 | ($3) | $0 | ($29,750) | |
| Aug-21 | ($14,070) | $115 | $742 | ($5) | $0 | $0 | $520 | $40 | $1,628 | $0 | ($35,126) | $31,890 | ($14,266) | |
| Sep-21 | ($4,295) | ($412) | $394 | ($31,986) | $677 | $64 | $111 | $27 | $0 | $0 | ($25) | $0 | ($35,445) | |
| Oct-21 | $944 | ($802) | $670 | $0 | $2,257 | $0 | $151 | $381 | $152 | $76 | $0 | $0 | $3,828 | |
| Nov-21 | $2,823 | $164 | $79 | $183 | $516 | $229 | ($16,841) | $0 | $0 | $4,562 | $0 | $0 | ($8,285) | |
| Dec-21 | $455 | $2,357 | $1,765 | $41 | ($230) | ($471) | ($38,859) | ($117) | ($15,015) | ($27,967) | $0 | ($20,436) | ($98,475) | |
| Jan-22 | $1,247 | $304 | ($620) | $1,655 | $195 | $0 | ($137) | $519 | $416 | $0 | $0 | $39 | $3,618 | |
| Feb-22 | $2,443 | ($4,821) | ($362) | $347 | $3,506 | $47,382 | $0 | ($407) | $366 | $0 | ($69) | ($45) | $48,340 | |
| Mar-22 | $74,668 | $427 | $13,374 | ($564) | ($16,530) | ($158) | ($19,682) | $80 | ($1,968) | $272 | ($990) | $39 | $48,966 | |
| Apr-22 | $11,704 | ($1,940) | ($913) | ($60,837) | $26,680 | $1,173 | ($3,918) | ($10,454) | $9,843 | ($340) | ($871) | $39 | ($29,834) | |
| May-22 | $45,175 | $6,620 | ($17) | $919 | $744 | $10,345 | $2,158 | ($50) | $3,505 | $818 | ($530) | $6 | $69,694 | |
| Jun-22 | $28,709 | $28,822 | $244 | $2,333 | ($492) | $33 | $59,893 | ($72) | $6,636 | ($2,677) | $103 | $18,247 | $141,779 | |
| Jul-22 | $2,331 | $37,495 | $135 | $4,587 | $247 | ($520) | $78 | $5,143 | $5,493 | $19,032 | $0 | $7,676 | $81,696 | |
| Aug-22 | $3,314 | ($5,286) | $5,935 | $8,789 | $258 | $16,507 | $97,766 | $103,410 | ($39,422) | $20,490 | $45,022 | $3,508 | $260,291 | |
| Sep-22 | $41,663 | $31,901 | $2,274 | $5,160 | ($20,734) | $1,085 | $9,276 | $15,316 | $4,417 | ($1,456) | $278 | ($64) | $89,117 | |
| Oct-22 | $164,118 | $48,566 | $19,119 | $10,159 | $60,035 | $6,450 | $24,349 | $3,556 | $3,918 | $635 | $11,008 | $537 | $352,449 | |
| Nov-22 | $130,990 | $46,457 | $268,436 | ($81,676) | $6,161 | $5,897 | $13,877 | $51,713 | $5,866 | $1,143 | ($613) | $2,453 | $450,704 | |
| Dec-22 | $1,136,141 | $433,448 | $105,511 | $58,928 | $151,461 | ($14,877) | ($803) | $5,771 | $11,343 | $658 | $20,659 | ($9,965) | $1,898,278 | |
| Jan-23 | $1,419,333 | $1,325,795 | $391,834 | $169,661 | $41,675 | $21,424 | $15,861 | $11,377 | $18,532 | $909 | $11,437 | $69,180 | $3,497,018 | |
| Feb-23 | $0 | $1,563,816 | $1,251,021 | $223,512 | $162,398 | $234,598 | $24,747 | $51,396 | $7,341 | $1,571 | $2,140 | $3,041 | $3,525,580 | |
| Mar-23 | $0 | $0 | $1,642,322 | $1,145,396 | $176,610 | $185,044 | $3,845 | ($1,439) | $8,002 | $11,017 | $5,675 | $1,192 | $3,177,663 | |
| Apr-23 | $0 | $0 | $0 | $1,494,580 | $1,389,845 | $199,605 | $25,331 | $253,387 | $19,852 | $13,491 | $35,229 | $2,189 | $3,433,509 | |
| May-23 | $0 | $0 | $0 | $0 | $1,791,831 | $1,188,554 | $269,562 | $114,286 | $12,912 | $6,759 | $9,858 | ($10,542) | $3,383,221 | |
| Jun-23 | $0 | $0 | $0 | $0 | $0 | $1,279,139 | $1,627,789 | $276,346 | $285,409 | $187,304 | $11,511 | ($1,801) | $3,665,697 | |
| Jul-23 | $0 | $0 | $0 | $0 | $0 | $0 | $1,495,587 | $1,460,893 | $206,089 | $63,980 | $35,580 | $32,038 | $3,294,167 | |
| Aug-23 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $1,562,326 | $1,267,523 | $270,678 | $91,003 | $56,611 | $3,248,141 | |
| Sep-23 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $1,492,419 | $1,318,069 | $131,878 | $74,027 | $3,016,393 | |
| Oct-23 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $1,916,113 | $1,331,154 | $258,326 | $3,505,592 | |
| Nov-23 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $1,760,190 | $1,395,811 | $3,156,001 | |
| Dec-23 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $1,721,432 | $1,721,432 | |
| Grand Total | $3,050,956 | $3,478,169 | $3,692,094 | $2,886,778 | $3,705,471 | $3,181,250 | $3,591,905 | $3,899,572 | $3,314,480 | $3,808,148 | $3,207,743 | $3,635,435 | $41,452,000 |
&G &7This report contains proprietary and/or confidential information. Disclosure is strictly prohibited except to the extent required by law. ADVICE Reporting System &8Page &P of &N Date: 1/7/2024 image1.png
File details come from the government source that posted it. Updated .