AugustaUtilities
Reports
Reports
RFP #26-275 required reports (26–46), generated on demand from this project's synthetic database. No live Augusta production data is used.
Required reports (RFP 26–46)
21
Demo ready now
19
Billed on file (synthetic)
$74,047.17
Collected on file (synthetic)
$50,221.15
Billed revenue by service line
Aggregated from synthetic bill lines by bill issue month
Required report catalog
21 of 21 RFP #26-275 required reports
Account Status Counts
Total number of accounts broken down by status: Active, Inactive.
Accounts by Service Combination
Accounts broken down by service: Water only; Sewer only; Water and Sewer; Stormwater only; Water, Sewer and Stormwater; Other.
Accounts by Type
Total number of accounts broken down by type (account class).
Top Accounts by Usage or Billing
Top N accounts for usage or billing over a user-entered date range.
Final Billed Accounts with Consumption
Final billed accounts that show consumption.
Billing Accounts Register
Billing Accounts Register available for each billing cycle.
FY Closing Deposit Balance Sheet
Fiscal Year Closing Deposit Balance Sheet — deposits held as of fiscal year end.
Accounts with Deposits (Date Range)
Accounts with a deposit received within a given date range.
Final Bill Credit Report
Final-billed accounts with credits remaining on account.
Phone Match — Active vs Final Billed
Report matching phone numbers on accounts that are active as well as final billed.
Pull Totals
Payments, adjustments, and late fees with subtotals and a grand total.
City of Augusta Accounts
Identification of City of Augusta accounts.
High Consumption Report
Accounts whose metered consumption exceeds a user/Augusta-defined threshold.
FY Closing Accounts Receivable
Fiscal Year Closing Accounts Receivable report.
Unpaid Stormwater — Final Billed
Outstanding balance report of final-billed accounts showing unpaid stormwater balance.
Aging Accounts Receivable
Aging accounts receivable report as of a selected date.
New Accounts Since Date
New accounts added since a user-defined date.
New Services & Disconnects
Number of new services and disconnects for a user-defined date range.
Calculation Audit Report
Line-level audit of bill calculations: quantities, rates, amounts, and the calculation source recorded on each line.
IAS World Ownership Discrepancy
Discrepancy report comparing IAS World ownership data to water/sewer accounts designated as owner.
Ad-hoc Custom Report Writer
Safe synthetic ad-hoc report builder over whitelisted data sources — no arbitrary SQL.