External Standard Report Generator
DW Audit Report
Click to Enlarge
Report Options
Select As Of Date:
1 - LoanRepaymentSummary
2 - LoanAccountStatement
4 - LoanActivity
5 - ProjectedActivity
6 - InterestRateCalculation
7 - MichiganBonding
8 - DebtServiceRequirements
9 - GeneralObligationPayments
10 - GeneralObligationPaymentSchedule
11 - BondsAndNotesPayable
12 - SpecialRevenuePayments
13 - ExistingDebtServiceScheduleOfGOBonds
14 - MichiganGeneralObligationBonds
16 - DistrictSummary
17 - SBLFDetailLedger
19 - LoansReceivableDetail
20 - SBLFWireTransfer
21 - Outstanding Balances By District
22 - Sufficiency Analysis
23 - Wire Transfer Maintenance
24 - Main Loan Entry
25 - Assignment Report
As of date:
First year ending:
One year after "as of" date, above
Last year ending:
As far out as available data exists
to
Although you can enter any time range, this report is intended to be run over a five year period. Entering a smaller time range is fine, but entering a longer time range will result in an error.
to
All
C-51 Reservoir
Clean Water ARRA Grant
Clean Water ASADRA Grant
Clean Water EC Grant
Clean Water State Revolving Fund
Clean Water Supplemental Appropriation for Hurricanes Fiona & Ian SAHFI
Drinking Water ARRA Grant
Drinking Water ASADRA Grant
Drinking Water EC Grant
Drinking Water LSL Grant
Drinking Water Reservoir
Drinking Water State Revolving Fund
Drinking Water Supplemental Appropriation for Hurricanes Fiona & Ian SAHFI
Program Support
Sewer Overflow and Stormwater Reuse Municipal Grant
Small and Disadvantaged Communities Drinking Water Grant
Small Community Wastewater Construction Grant
Water Pollution Control Financing Corporation
Water Protection & Sustainability Program Trust Fund
Water Supply Restoration
WIIN Drinking Water Grant
?????
Year:
Term:
All
Settlement Date:
You may enter the settlement date manually, or calculate it automatically: 6 business days before May 1 or Nov. 1, according to the term.
Generate Report Based On:
Principal
Interest
Principal & Interest
and for Bond Type:
All
Refunding
Mode:
All
Borrowing
Repaying
Paid
Assignment Status:
All
Assigned Only
Unassigned Only
Pledge Status:
All
Pledged Only
Unpledged Only
All
Balance
No Balance
Require transaction activity
within date range:
_
Calculate Cumulative Totals Every nth Line: n=
Assumed Interest Thereafter:
Assumed Principal Thereafter:
Rate Calculation Reason:
Rate Date Range:
to
List Details for:
Payments Received
Draws Processed
Voucher Number
Include SBLF?
_
Include SLRF?
_
Assumed Interest Rate:
Interest Rate:
Borrower:
All
2019A
All
2017 F Program Management
2018 F Program Management
2019 E Technical Assistance
2019 F Program Management
2019 G Local Assistance
2020 E Technical Assistance
2020 F Program Management
2020 G Local Assistance
2021 CW Cap Grant
2021 DW Cap Grant
2022 CW BIL Cap Grant
2022 CW Cap Grant
2022 CW Emerging Contaminants
2022 DW BIL Cap Grant
2022 DW Cap Grant
2022 DW Emerging Contaminants
2022 DW Lead Service Line Replacement
2023 CW BIL Cap Grant
2023 CW Cap Grant
2023 CW Emerging Contaminants
2023 DW BIL Cap Grant
2023 DW Cap Grant
2023 DW Emerging Contaminants
2023 DW Lead Service Line Replacement
2024 CW SAHFI
2024 DW Cap Grant
2024 DW SAHFI
Acme Funds
Bond 2019-A
Bond Bank Restricted (Revenue Account)
Bond Bank Unrestricted (Loan Account)
C-51 Reservoir
CARRA
CW ASADRA
CW Cap Grant 2020
CW Trust Fund
DARRA
DW ASADRA
DW Cap Grant 2020
DW Set-Aside Funding
DW Trust Fund
DW WIIN Grant
FGTF - GAA
FGTF - SF
GAA Funding
Hardship Grant
Loan Account PrePayments
Loan Account Repayments
Revenue Account
SDCDW
SRF Account
Test Account
Undesignated Funding Source
Water Supply Reservoir
Water Supply Restoration
WPSPTF
WPCFC-Taxable Series 2019
All
Disbursable
None
Operations
Recoverable
Regular
Transferable
Florida Department of Environmental Protection
All
Alachua County
Baker County
Bay County
Bradford County
Brevard County
Broward County
Calhoun County
Charlotte County
Citrus County
Clay County
Collier County
Columbia County
DeSoto County
Dixie County
Duval County
Escambia County
Flagler County
Franklin County
Gadsden County
Gilchrist County
Glades County
Gulf County
Hamilton County
Hardee County
Hendry County
Hernando County
Highlands County
Hillsborough County
Holmes County
Indian River County
Jackson County
Jefferson County
Lafayette County
Lake County
Lee County
Leon County
Levy County
Liberty County
Madison County
Manatee County
Marion County
Martin County
Miami-Dade County
Monroe County
Nassau County
Okaloosa County
Okeechobee County
Orange County
Osceola County
Palm Beach County
Pasco County
Pinellas County
Polk County
Putnam County
Santa Rosa County
Sarasota County
Seminole County
St. Johns County
St. Lucie County
Sumter County
Suwannee County
Taylor County
Union County
Volusia County
Wakulla County
Walton County
Washington County
(None)
CWSRF Request for Funding
CWSRF Request for Inclusion
DWSRF Request for Funding
DWSRF Request for Inclusion-OLD
Facility Planning Review Checklist
Final Inspection
Interim Inspection
SRF/DSCG Disbursement Review Checklist-CW
SRF/DSCG Disbursement Review Checklist-DW
All
Closed
Disbursable
Fully Disbursed
Pre Award
All
Closed
Disbursable
Fully Disbursed
Pre Award
Select Loan Number:
(Select)
Alligator Park, Inc. - DW-080400
American Beach Water and Sewer District - DW-450511
Arcadia - DW-140131
Arcadia - DW-140100
Arcadia - DW-140130
Bay County - DW-030200
Belleview - DW-420701
Belleview - DW-420700
Belleview - DW-420750
Belleview - DW-420770
Big Bend Water Authority - DW-620001
Big Bend Water Authority - DW-620002
Big Bend Water Authority - DW-150520
Big Bend Water Authority - DW-150521
Bonifay - DW-300111
Bonifay - DW-300110
Bonifay - DW-300140
Bonifay - DW-300141
Bonifay - DW-300142
Bonita Springs Utilities, Inc. - DW-360710
Bowling Green - DW-250250
Bunnell - DW-180540
Bushnell - DW-600410
Bushnell - DW-600400
Bushnell - DW-600430
Bushnell - DW-600431
Callahan - DW-450200
Callahan - DW-450201
Campbellton - DW-320301
Cape Coral - DW-360103
Cape Coral - DW-360130
Carrabelle - DW-190300
Carrabelle - DW-190301
Carrabelle - DW-190420
Carrabelle - DW-190421
Casselberry - DW-590301
Century - DW-170311
Century - DW-170310
Charlotte County - DW-081704
Charlotte County - DW-080270
Charlotte County - DW-0802B0
Charlotte County - DW-080290
Charlotte County - DW-080260
Chiefland - DW-380300
Citrus County - DW-090101
Citrus County - DW-090140
Colonial Estates Mobile Home Park - DW-502600
Columbia County - DW-120101
Columbia County - DW-120400
Coral Springs - DW-061630
Coral Springs - DW-060301
Coral Springs - DW-060302
Coral Springs - DW-060303
Coral Springs - DW-061620
Cottondale - DW-320370
Crestview - DW-460740
Cross City - DW-150101
Crystal River - DW-090241
Dade City - DW-510411
Dade City - DW-510412
Dade City - DW-510400
Dania Beach - DW-060401
Dania Beach - DW-060406
Dania Beach - DW-060405
Dania Beach - DW-061230
Dania Beach - DW-060402
Dania Beach - DW-060403
Dania Beach - DW-060404
Davenport - DW-531201
Davenport - DW-531202
Davenport - DW-530730
Davenport - DW-530700
Davenport - DW-530701
Daytona Beach - DW-640920
Daytona Beach - DW-640990
DeFuniak Springs - DW-660250
Destin Water Users, Inc. - DW-460101
Destin Water Users, Inc. - DW-460120
Destin Water Users, Inc. - DW-460121
Dunedin - DW-520260
Dunedin - DW-520261
Eagle Lake - DW-530911
El Jobean Water Association - DW-080600
Everglades City - DW-110910
Fair Winds Condominium Village Association, Inc. - DW-580720
Fairpoint Regional Utility System, Inc. - DW-570202
Fairpoint Regional Utility System, Inc. - DW-570200
Fairpoint Regional Utility System, Inc. - DW-570210
Fellsmere - DW-310301
Fellsmere - DW-310300
Flagler Beach - DW-180101
Florida City - DW-131050
Florida Governmental Utility Authority (Flagler County) - DW-180810
Florida Governmental Utility Authority (Arredondo Estates) - DW-590340
Florida Governmental Utility Authority (Arredondo Estates) - DW-590341
Florida Governmental Utility Authority (Lehigh Acres) - DW-360720
Florida Governmental Utility Authority (Plantation Bay) - DW-181000
Fort Myers - DW-360480
Fort Myers Beach - DW-360800
Fort Myers Beach - DW-360801
Freeport - DW-660330
Gasparilla Island Water Association, Inc - DW-360810
Glades Utility Authority - DW-500100
Glen St. Mary - DW-020100
Green Cove Springs - DW-100102
Green Cove Springs - DW-100440
Gretna - DW-202101
Groveland - DW-350620
Groveland - DW-350621
Gulf County - DW-230220
Haines City - DW-530411
Haines City - DW-530410
Haines City - DW-530450
Haines City - DW-530451
Havana - DW-200500
Havana - DW-200501
Hawthorne - DW-010410
Hawthorne - DW-010411
Highland Beach - DW-500201
Highland Beach - DW-500200
Highland Beach - DW-500210
Hillsboro Beach - DW-062600
Hillsboro Beach - DW-062610
Hollywood - DW-0604B0
Hollywood - DW-060470
Hollywood - DW-0604D0
Hollywood - DW-060490
Hollywood - DW-060460
Hollywood - DW-060410
Hollywood - DW-060440
Holt Water Works, Inc. - DW-460320
Homosassa Special Water District - DW-090202
Horseshoe Beach - DW-150001
Howey-in-the-Hills - DW-350401
Immokalee W/S District - DW-110121
Immokalee W/S District - DW-110120
Indiantown - DW-430320
Indiantown - DW-430350
Indiantown - DW-430340
Jackson County - DW-320350
Jackson County - DW-320380
Jackson County - DW-320381
Jennings - DW-240210
Jennings - DW-240200
LaBelle - DW-260300
Lake Alfred - DW-530510
Lake Butler - DW-630110
Lake Butler - DW-630111
Lake Hamilton - DW-531610
Lake Hamilton - DW-531650
Lake Helen - DW-640602
Lake Helen - DW-640610
Lake Helen - DW-640310
Lake Wales - DW-530390
Lake Wales - DW-5303B0
Lake Wales - DW-531301
Lake Wales - DW-530370
Lake Wales - DW-530320
Lake Worth Beach - DW-501701
Lake Worth Beach - DW-501700
Lake Worth Beach - DW-501720
Lake Worth Beach - DW-501730
Lake Worth Beach - DW-501731
Lake Worth Beach - DW-501750
Lake Worth Beach - DW-501710
Lake Worth Beach - DW-501740
Lakeland - DW-530660
Lakeland - DW-530661
Lauderhill - DW-060701
Lauderhill - DW-060700
Lawtey - DW-040100
Lee County - DW-3602A0
Lemon Bluff Water Association - DW-640001
Lemon Bluff Water Association - DW-640200
Live Oak - DW-610211
Live Oak - DW-610210
Lynn Haven - DW-030290
Madison - DW-400410
Madison - DW-400411
Maitland - DW-480250
Maitland - DW-480251
Manalapan - DW-500501
Marco Island - DW-110301
Marianna - DW-320260
Marianna - DW-320220
Marianna - DW-320210
Martin County - DW-430240
Mary Esther - DW-460210
Mary Esther - DW-460211
Mary Esther - DW-460212
Mascotte - DW-351210
Mascotte - DW-351211
Melbourne - DW-050950
Miami-Dade Water and Sewer Authority - DW-130201
Miami-Dade Water and Sewer Authority - DW-130200
Miami-Dade Water and Sewer Authority - DW-130230
Miami-Dade Water and Sewer Authority - DW-130260
Micanopy - DW-010600
Midway Water System, Inc. - DW-570201
Miramar - DW-060820
Mobile Manor, Inc - DW-360870
Montverde - DW-351300
Moore Creek-Mt. Carmel Utilities, Inc. - DW-571001
Mount Dora - DW-351450
Mount Dora - DW-3514A0
Mulberry - DW-531200
Mulberry - DW-531220
Mysterious Waters - DW-652001
Natura, Inc. - DW-063501
Newberry - DW-010810
North Bay Village - DW-130400
North Bay Village - DW-130420
North Miami - DW-131820
North Miami - DW-131831
North Miami Beach - DW-130103
North Miami Beach - DW-130102
North Miami Beach - DW-130130
Oakland - DW-4803C0
Oakland - DW-4803R0
Orange City - DW-642000
Orange City - DW-642040
Orange City - DW-642041
Orange City - DW-642050
Orange County - DW-4803B0
Orange County - DW-4803A0
Ozello Water Association - DW-090700
Ozello Water Association - DW-090701
Palatka - DW-541901
Palatka - DW-540250
Palatka - DW-540220
Panama City - DW-0302G0
Panama City - DW-0302G1
Parker - DW-030720
Paxton - DW-660340
Paxton - DW-660341
Perry - DW-620201
Perry - DW-620250
Perry - DW-620260
Perry - DW-620261
Polk Regional Water Cooperative - DW-532000
Polk Regional Water Cooperative - DW-532001
Polk Regional Water Cooperative - DW-532002
Pompano Beach - DW-062450
Pompano Beach - DW-062480
Ponce Inlet - DW-641400
Port Orange - DW-641303
Port St. Joe - DW-230111
Port St. Joe - DW-230160
Punta Gorda - DW-080310
Putnam County - DW-540101
Sanford - DW-590110
Sanford - DW-590191
Sanford - DW-590192
Sanford - DW-590120
Sarasota - DW-580240
Sebring - DW-280310
Sebring - DW-280320
Sebring - DW-280330
Shady Oaks Mobile Home Park - DW-4803P0
Spring Lake Improvement District - DW-280530
Spring Lake Improvement District - DW-280531
Springfield - DW-030801
Springfield - DW-030513
St. Augustine - DW-550410
St. Johns County - DW-550110
St. Johns County - DW-550130
St. Johns County - DW-550140
Starke - DW-040210
Stuart - DW-430410
Stuart - DW-430430
Stuart - DW-430431
Stuart - DW-430420
Stuart - DW-430450
Tampa - DW-290202
Tampa - DW-290200
Tampa - DW-290290
Tampa - DW-2902E0
Tavares - DW-350301
Tavares - DW-350960
Tavares - DW-350961
Tavares - DW-350930
Tavares - DW-350980
Tavares - DW-350981
Taylor Coastal Water & Sewer District - DW-620301
The Springs Park Area, Inc. - DW-351600
Titusville - DW-050200
Titusville - DW-050201
Titusville - DW-050300
Titusville - DW-050330
Titusville - DW-050331
Trenton - DW-210110
Trenton - DW-210111
Trenton - DW-210112
Venice - DW-580430
Venice - DW-580480
Vero Beach - DW-310221
Vero Beach - DW-310220
Village of Tequesta - DW-502700
Wahneta Water System, Inc. - DW-532110
Wauchula - DW-250200
Wauchula - DW-250201
Wauchula - DW-250150
Wauchula - DW-250151
White Springs - DW-240100
Wildwood - DW-600231
Winter Haven - DW-531340
Winter Springs - DW-590610
WRP Inc - DW-460300
Yankeetown - DW-380601
(Select)
Big Bend Water Authority - SG-150532
Chipley - SG-670112
Clewiston - SG-260441
Davenport - SG-530711
Everglades City - SG-110921
Fort White - SG-120611
Freeport - SG-660322
Fruitland Park - SG-350822
Green Cove Springs - SG-100421
Gretna - SG-200301
Groveland - SG-350611
Inglis - SG-380411
Jennings - SG-240221
Lake Butler - SG-630101
Lake Placid - SG-280221
Marianna - SG-320251
Marianna - SG-320253
Mascotte - SG-351201
Milton - SG-570302
Monticello - SG-330223
Mulberry - SG-770064
Pierson - SG-642101
Pierson - SG-642103
Port St. Joe - SG-230141
Springfield - SG-030531
Umatilla - SG-350751
White Springs - SG-229042
None
ABriscoe
Administrator
adouglas
AKnecht
amayungbe
ANolan
ARobinson
AutomationUser
BBechtel
bharris
Brandon.Shinkle@FloridaDEP.gov
CChitty
cdavis
CFukushima
CHudson
cminskey
cmurray
crichards
CSchell
DAmuso
emeyers
EMorrow
esuarez
ExternalReport
fjuman
galfsen
gcaro
HRivera
IWalker
jennifer.vickers@floridadep.gov
JGergen
jkahn
jkarozos
JLiboy
jmckean
jmlee
jshea
KColvinReece
klewis
kslack
LColeman
lwidener
lwright
mandrews
MCaron
mchase
MIsaacson
MLopezCalleja
mmarine
mmassoudi
mmaxwell
pbrandl
pshah
pthompson
rherndon
rscott
sdropati
skanten
slarose
smcarthur
SOConnellRichards
srfreporting
SSpeasFrost
SWaters
SWeeks
SWilliams
TBanks
TEdwards
testclient
testpartner
THarmon
THodapp
tklepper
tmontgomery
TRobson
vpanchakarla
WSUser
ysoloff
None
Alternate Reviewer
Automated Adjustment Approval
Bank Account Review
Bond Bank Draw Complete-Post FA and Sign Letter
Bond Verify-Enter Reimbursement Date
CWSRF RFI Approval-Email Sponsor
CWSRF RFI Review
DWSRF RFI Approval-Email Sponsor
DWSRF RFI Review
Facility Planning Review-Program Administrators
Form Submission Reviewers
Loan Agreement Writers
Loan Application Final Approval
Loan Application Initial Review
Project Managers
Reimbursement Complete-Post FA
Reimbursement Disbursement Lead Review
Reimbursement Enter into ELFF
Reimbursement Initial Review
Reimbursement Team Full Review
Request for Funding Awarded
Request for Funding Review
Request for Funding-Project Agreement Executed
RFI Approved-Begin PPL Process
Routing Sheet for Agreements and Amendments
Test User Group
User Account Locked
None
Activity - Organizer
Activity - Owner
Activity - Participant
Administrative Assistant
Authorized Delegate
Authorized Rep
Carbon Copy
Chief Operating Officer
City Manager
Compliance Notification
Consultant, Other
Consulting Engineer
Disbursement Contact
Disbursement Email
Dynamic Forms Submitter
Escrow Agent
Financial Authorized Rep (FIN)
Inspector-External
Inspector-Internal
Loan Statement
Mayor
Primary Contact
Priority List
Project Manager
Submitter
_
PDF
Excel
to report
to excel