UB Billing Export File Formats

Updated on Dec 01, 2021

Summary

There are seven Springbrook Billing Export file formats. All files are comma-delimited and it is recommended to save them as a text file (.txt) or a comma-separated list (.csv).

Previous Article UB Bill Type Summary

Next Article UB Direct Debits Overview

Upcoming Training

Cirrus Utility Billing

Utility Billing Overview 20

UB Overview
UB Account Search
UB Where do I...
UB Bill Type Summary
UB Billing Export File Formats
UB Direct Debits Overview
UB Service Request Overview
UB Usage Periods
UB Credit History Summary
UB Final Account Wizard
UB New Account Wizard
UB Address Certification
UB Deposit Overview
UB New Account Wizard - Charge a customer a deposit
UB Deposit Setup
UB Receipt and Account Alerts
UB Net Metering Overview
UB Bill to Report
UB Assistance Program
UB Allocation Billing

Adjustment Fees 12

UB Bill a Service Request
UB Miscellaneous Billing
UB Redistribute Credit Balances
UB Remove Budget Accounts
UB Factor Interest on Deposits
UB Reset Net Meter Banks
UB Import Fee Adjustments
UB Input a Billing
UB Adjustment Input Wizard - Adjust a Payment Transaction
UB Adjustment Input Wizard - Adjust a Billing Transaction
UB Adjustment Input Wizard - Misread, Leak and Consumption
UB Contra Revenue Adjustment

Budget Billing 1

UB Process Budget Billing

Collections 2

UB Collections Setup
UB Collections

Final Billing 2

UB Final an Account Process Overview
UB Final Billing

Maintenance 31

UB Account Maintenance
UB Account History Report
UB Account Template Maintenance
UB Add Bank Account Information to a UB Account
UB Add a Comment to a UB Customer Account
UB Adjustment Type Code Maintenance
UB Bill Type Maintenance
UB Billing Calculations Maintenance
UB Category Code Maintenance
UB Class Maintenance
UB Comment Status Maintenance
UB Conservation Data Maintenance
UB Consumption Conversion Maintenance
UB Cycle Code Maintenance
UB Device Maintenance
UB Exempt Meters Overview
UB Backflow Device Type Maintenance
UB Electric Meter Device Type Maintenance
UB Gas Meter Device Type Maintenance
UB Transformer Device Type Maintenance
UB Water Meter Device Type Maintenance
UB Fee Code Maintenance
SO Form Maintenance
UB Route Maintenance
UB Service Maintenance
UB Service Group Maintenance
UB Service Rate Maintenance
UB Service Request Code Maintenance
UB Statement Maintenance
UB Tax Code Maintenance
UB Zone Maintenance

Meter Management 14

UB Input a New Meter Reading
UB Edit Meter Readings
UB Update Meter Read Dates
UB Meter Readings Proof List
UB Meter Change-out Report
UB Misread Meters Report
UB Unread Meters Report
UB Meter Sheets
UB Meter Data Export
UB Meter Change Out Import
UB Export Meter Readings
UB Import Meter Readings
UB Resequence Meters
UB Backflow Test Import

New Billing 2

UB New Billing
UB Consumption Not Billing

Past Dues 1

UB Past Dues

Refunds 2

UB Refunds Setup
UB Refunds

Reports 31

UB Account Master Report
UB Accounts by Service Report
UB Accounts by Tax Code Report
UB Aging Report
UB AR Totals by UB Cycle Code
UB Backflow Test Results Report
UB Balance by AR Account Report
UB Comments by Status Report
UB Consumption Adjustment Report
UB Consumption by Class Report
UB Consumption by Meter Size Report
UB Consumption by Service Report
UB Consumption by Type Report
UB Consumption Revenue Report
UB Credit Balance by Cycle Report
UB Deposit Balance Report
UB Deposit Transaction Report
UB Detailed Meter Information Report
UB GL Comparison Report
UB Labels by Zip Report
UB Payment Plans Report
UB Payments by Past Due Report
UB Summary by Class Report
UB Summary GL Comparison Report
UB Top Users Report
UB Transactions by Date Report
UB Trend Monitoring Report
UB Trial Balance by Date Report
UB Unpaid Deposits Report
UB Target Allocation Statement
UB Usage Statement

Reports Consumption 5

UB Consumption by Report
UB Consumption by Service Rate Report
UB Summary by Service Rate Report
UB Sub Meter Listing Report
UB Account by Service Rate Report

Service Requests 11

UB Service Request Input/View
UB Close and Commit a Service Request
UB Service Request Door Hangers
UB Service Request Report
UB Service Request Proof List
UB Add Device Service Request
UB Change-Out Device Service Request
UB New Account Service Request
UB Read Device Service Request
UB Remove A Device Service Request
UB Final Account Service Request

Transfers 1

UB Transfers

Utilities 21

UB Account Export
UB Alert Works Export
UB Allocation Statement Header
UB Add/Remove Bill Tos
UB Add/Remove Services and/or Service Rates
UB Export Assistance Accounts
UB Import Adjustments from KVS
UB Import Assistance Accounts
UB Import Comments
UB Query by Example
UB Open an Exported Access Database in MS Excel
UB Modify Account Number
UB Modify Allocation Overrides
UB Paid Meter Sequence
UB Setup
UB Statement Setup
UB Synchronize Web Payments
UB Defaults
UB Bill To Import
UB Water Allocation Import
UB Export AquaHawk

Winter Average 2

UB Winter Average Setup
UB Winter Averaging

Other Resources

Current Webinars
Calendar Year End Playbook
Fiscal Year-End Playbook
Affordable Care Act Playbook
Tableau
New Finance Director Training
Getting Started
Springbrook 101
Cirrus Overview
Cirrus Accounts Payable
Cirrus Accounts Receivable
Cirrus Bank Reconciliation
Cirrus Cash Receipts
Cirrus Clearing House
Cirrus General Ledger
Cirrus Payroll
Cirrus Project Management
Cirrus Purchase Orders
Cirrus System Setup
Cirrus Tax Collection
Account Payable
Accounts Receivable
Bank Reconciliation
Cash Receipts
Clearing House
Configurable Check Labels
Extended Budgeting
Financials
Fixed Assets
General Ledger
Inventory Control
Project Management
Purchase Orders
Washington State Audit Export
Work Orders
Payroll
Human Resources
Utility Billing
CivicPay Online
CivicPay Administration
Building Permits
Business Tax
Code and Contact Management
Licenses and Permits
Parking Tickets
Special Assessments
Online Aplications
Springbrook Analytics
Backup Services
Cloud
System Setup
Demo Recordings