The URL can be used to link to this page

Home My WebLink About26 - Instructions - Bozeman Utility Billing Software Services & Implementatiion RFP (2)Bozeman, MT Reporting Please use the descriptions below to complete columns D - H on the subsequent tab. If the Respondent recommends additional reports, please add them in the table at the bottom of the next tab and include them in the fixed fee price. Column A B C D E F G H Response Key - Column D (In Scope?) Available Response Y N RC Response Key - Column E (Report Type) Available Response Out of Box Configured Dashboard System Inquiry Functionality Other Not Provided Response Key - Column G (Type of Support) Available Response S TPS NS Indicates input cell for Respondent to supply information Header Function Report Name Report Description In Scope? Report Type Recommendation Type of Support Comments Description Report is in scope and included as part of the fixed fee price proposal Report IS NOT in scope and included as part of the fixed fee price proposal Report requires clarification to determine if report will be included in scope. Clarification must be added to Column H (Comments) Description Standard report delivered out of the box Report can be built using standard reporting tools of the system Information provided through a system dashboard Information retrieved through a system query rather than a report Information delivered by system functionality (e.g., a report is not needed due to bank reconciliation module functionality) Information accessed by other means (describe in comments) Report/information is not provided Description Report will be supported by software developer on ongoing basis Report will be supported by a third party on an ongoing basis and price is included in fixed fee proposal Report will not be supported or support provided through a separate, paid agreement (e.g., managed services) Description Current Report application Name of report Description of report, it's purpose, and / or the data fields needed in the report Respondent should indicate if the report development is in scope and included in the fixed fee price proposal Respondent should indicate the type of report or query that will achieve the City's needs Respondent should provide a recommendation on how the reporting need should be met (e.g., "use bank reconciliation module" or "met through GL inquiry with export to Excel if needed," etc.) Respondent should indicate the type of support for the report Respondent should include any comments or assumptions relevant to the answers above Reporting Requirements Function Cashiering & Payments Cashiering & Payments Cashiering & Payments General Ledger General Ledger Accounts Receivable Accounts Receivable Accounts Receivable Accounts Receivable Adjustments & Credits Customer Service Customer Service Customer Service Customer Service Customer Service Metering Metering Metering Metering Metering Field Operations Sewer Billing Billing Billing Billing Billing Billing Billing Collections Collections Collections Collections Collections Collections Stormwater Stormwater Stormwater Stormwater Assessments / SIDs Assessments / SIDs Assessments / SIDs Assessments / SIDs Respondent Suggested Reports Function Report Name Cash by User / Station / Tender Utility Payments by Date (w/ Processor Breakdown) Deposit/Bank Reconciliation GL Interface Posting Summary Unposted Batch & Exception Report Aged Accounts Receivable Customer Balance Listing Write‑Off Proposal & History Refunds & Credits Due Adjustments Audit Trail Account Master Listing New / Finaled Accounts Returned Mail / Undeliverable Deposit Analysis Payment Arrangement Status Meter Read Exception Summary Consumption Variance / Leak Detection No‑Read / No‑Communication (AMI/AMR) Meter Inventory & Serial Tracking Meter Change‑Out Register Service Order Activity Winter Average / Sewer Cap Audit Billing Register (Cycle/Month) Bill Proof / Exception Queue Rate Code Revenue Summary Tiered Usage & Revenue Proration & Catch‑Up Audit Undelivered eBill / Paper Suppression Delinquency Pre‑List (Eligibility) Final Notice / Door Hanger Listing Shutoff List & Outcomes Penalty/Late Fee Assessment NSF / Returned Payment Register Lien & Certification (Delinquents) ERU / Billing Unit Register Parcel Change Log (GIS Sync) Stormwater Revenue Summary Delinquent Stormwater Accounts Assessment Roll (Preliminary & Final) Installment Billing Register Delinquent Assessment Report Prepayment & Payoff Quotes Report Name Report Description Daily reconciliation by cashier/user, workstation, and tender type (cash, check, ACH, card, lockbox, 3rd‑party portal). Summarizes batch totals, over/short, and deposit amounts, filterable by date and office. Total payments by date with breakout by origin (cashier, lockbox, autopay/ACH, payment portal (e.g., Invoice Cloud)) and funding vs. processing date to support settlement timing reconciliation. Deposit register by bank account code with batch/date, deposit number, deposit amount, and reconciliation status. Summarizes billed revenue, adjustments, payments, deposits, penalties, write‑offs, and taxes/fees by GL account, cycle, and period. Shows posted vs. unposted batches and exceptions. Identifies any UB transactions not yet sent to/posted in the GL with error reasons (e.g., missing account mapping). Standard aging by 0–30/31–60/61–90/90+ with totals by service, rate class, and customer class. Supports collections and ACFR notes. Open receivable balances by customer/account/location with filters by period, service, and rate code. Lists accounts eligible by policy (e.g., >365 days, bankruptcy, closed/uncollectible), approval status, and journal impact; includes history for audit. Closed/Finaled accounts with credit balances: amount due, tender type, refund method, status, and aging. All manual/system adjustments with user, timestamp, reason code, pre/post balance, approval chain, and GL impact. Account/customer master data (contact info, service addresses, rate codes, customer class, deposit status, bill delivery preference). Move‑in and move‑out activity by date range with proration flags, deposit transfers/refunds, and final bill status. Accounts with returned mail; shows most recent bill/notice returned and current contact information status. Customers requiring deposits, deposit balances held, interest accrual (if applicable), deposit application/refund listing. Active, completed, and defaulted arrangements with terms, amounts due, and next due date; includes delinquency impact. High/low usage, zero reads, skipped reads, negative reads, and estimated reads by route/cycle. Flags significant variance vs. prior period, rolling average, or seasonal baselines; highlights continuous flow (AMI). Meters with consecutive no‑reads or failed communications with duration and last-good-read timestamp. Meter, size, serial, install date, location, status (active/inactive), and chain of custody (change‑out history). All meter swaps with old/new serials, read at change, billing impact, and work order linkage. Work orders generated (turn‑on/off, rereads, leaks, tamper, meter change, field collections), assigned tech, SLA, completion status. Calculations and audit trail for winter average or sewer cap logic with inputs, capped usage, and overrides. Bills issued count, usage, charges by service (water, sewer, stormwater, solid waste), fees/taxes, adjustments, and net revenue; ties to GL summary. Accounts excluded from billing due to exceptions (missing read, final bill pending, hold, unusual usage), with resolution codes. Revenue by rate code and customer class with customer counts and average bill; supports rate studies. Water usage billed by block/tier with revenue by tier, by rate area. Accounts with prorated bills or catch‑up estimates; shows calculation details for audit. eBill bounces and paper suppression statuses to ensure delivery compliance. Accounts meeting shutoff eligibility rules (days past due, balance threshold, critical care exclusion), with notice status and dates. Notice batches with delivery method, date, and content version; includes proof of notice for audit. Service disconnection list with outcomes (paid, arrangement, field collect, disconnected), timestamps, and tech notes. Late fees calculated/assessed by date range with reversal reasons and waiver policy compliance. Returned checks/ACH with reason code, reversal posting, fees applied, and customer notification. Accounts eligible for lien/certification with amount due Parcel‑level ERUs (or equivalent billing units), impervious area, land use, and billing status. Adds/changes/removals from parcel feed (ownership, impervious changes), with impact on ERUs and revenue. Revenue by ERU class and credit category with counts and average charge. Stormwater‑specific delinquency with certification/lien export if handled separately. Parcels, owner of record, assessment amount, term, rate, installments, etc. Installments billed by SID with principal/interest split, prepayments, and amortization schedule changes. Past‑due installments and lien status; export for county recorder/treasurer where applicable. Real‑time payoff with interest to date, penalties, and recording fees; quote log for audit. Report Description In Scope? In Scope? Report Type Report Type Recommendation Recommendation Type of Support Type of Support Comments Comments