Spectrum Products                   

Account Bar Code—FlexiBill™—Utility Billing Subsystem

Payment entry is one of the most time consuming and accuracy critical tasks of a utility company.  Spectrum's Account Bar Coding provides a utility with the fastest, most accurate method of payment entry possible.  With this subsystem, a bar code is printed on the upper right hand corner of the utility bill stub, which is returned with payment.

Payments are entered electronically using a bar code reader by scanning the bar code on the utility bill stub instead of entering an account number manually.  The bar code reader, which is installed between the keyboard and the terminal, allows the computer operator to use both the keyboard and the bar code reader.  Returned payments are split into two groups: payments which match the amount due on the bill, and those which differ from the amount due.

Benefits & Advantages:

• Virtually eliminates the possibility of incorrect account numbers.  This, in turn, means that payments will not be posted to the wrong account. 
• Bar-coding saves time and eliminates errors, increasing customer satisfaction. 

Scanner
MCS supports the Symbol LS 4006i D/PDF PS2 direct cable scanner with the optional # LS 400x intellistand.  Scanners and stands can be purchased directly from Spectrum.

AsseTrax™—Asset Management

The AsseTrax, fixed asset management system is designed to meet the needs of public sector organizations and utilities. The AsseTrax system improves management control over critical fixed assets. The system helps ensure proper custody and use of assets. AsseTrax tracks the replacement and market value of each asset. This information is needed for insurance purposes and for recovery of maximum value after a loss. System information also assists the user in performing better cost analysis. AsseTrax meets the requirements for the Government Finance Officers Association (GFOA) Certificate of Conformance. The system will simplify your organization's implementation of GASB 34 requirements in the future.

Benefits & Advantages:

• Provides fixed asset file building and maintenance
• Maintains records of original assets, as well as improvements to those assets
• Allows online transfer of fixed assets between locations and general ledger accounting codes
• Lists fixed assets by number categories
• Includes SL, DDB, MACRS, and SYD depreciation methods
• Can automatically create depreciation Journal Entries in MicroFund fund accounting system
• Can automatically import assets created from Purchasing Agent Subsystem.

Reports & Output:

• Fixed asset master list
• Description file list
• Depreciation schedules for any period
• Fixed asset inventory worksheet
• Sorted fixed asset report
• Deleted fixed asset list
• Fixed asset replacement report
• Insurance report
• Changes in fixed assets by asset type
• Changes in fixed assets by function & activity

Bad Debt/Tax Levy™—FlexiBill™ Utility Billing Subsystem

&The Bad Debt/Tax Levy subsystem is designed to enable you to establish criteria for bad debts or tax levy write offs,maintain Bad Debt/Tax Levy maintenance inquiry and create a selection of Bad Debt/Tax Levy. The primary purpose of the system is to maintain and track customer accounts previously or currently being levied or written off due to non-payment of monies owed. The subsystem can operate as a stand alone or interfaced with FlexiBill utility billing for Windows.

Interfacing with FlexiBill allows operators to levy or a write-off customer balances and transfer the information from FlexiBill to Bad Debt/Tax Levy files where the customer's name, address and outstanding balance is maintained.

Benefits & Advantages:

• Provides a centralized location of bad debt/tax levy records
• Maintains records of bad debt assessments/tax levies, as well as credits/debits made to the account
• Integrates into the FlexiBill, utility billing software, providing an automated process to write off customer balances while maintaining the write off figures for further processing

Reports & Output:

• Account List
• Transaction List
• Tax Levy Report
• Purge Report

Budget Billing™—FlexiBill™ Utility Billing Subsystem

With Budget Billing, your customers can now choose to pay a flat rate (the same bill each month) instead of a bill based on consumption. Since the usage of some services is greater during certain seasons (for example, natural gas or electric during the winter months), some customers prefer to pay a constant budget amount instead of the actual amount.  This function applies only to services defined as metered services.

Benefits & Advantages:

• Calculates budget bill amounts per service
• Reports variances between budget bills and actual billing amount
• Allows for summary or detailed inquiry in actual amounts owe
• Allows users to selected when to reconcile each account
• Permits adjustments to be made during the year
• Prints current period actual consumption charges and the variance from the budget amount on the bills
• Allows budgeted and non-budgeted services on the same bill

Reports & Output:

• Budget Billing Variance Report

Cash Receipts™—Cash Drawer Management

Cash Receipts allows the collection of payments related to the FlexiBill, utility billing and MicroFund, fund accounting software. Utilizing an optional cash drawer and receipt printer, the system functions as a single repository for the initial intake of funds and then allocates the funds to the appropriate function. The system will accommodate payments taken in cash, check, credit card or coupon. Sales tax can be included where appropriate and receipts and be printed and numbered.

Benefits & Advantages:

• Allows the user to handle the collection of money for an unlimited number of transaction types
• Fast & Easy Setup
• Hot Keys & quick keys are available for ease of use and access
• View Archived Reports
• Advanced Interfacing features to assist technical support
• Allows a default entry for standard payment amounts
• Accommodates multiple cash drawers and receipt printers
• Includes user security features
• Balances cash in drawer indicating the transaction, amount tendered and change provided as often as desired
• Prints different transactions per customer on one receipt
• Displays on-screen calculation of receipt totals and change due
• Allows adjustment, no sale and refund transactions
• Allows ability to handle multiple transactions and prints one receipt
• Allows ability to handle multiple payments for a single transaction on one receipt
• Keeps running balance of each cash drawer
• Can be used with touch screen.
• Allows user to edit receipts

Reports & Output:

• Cash Receipt Totals by Batch
• Cash drawer status report
• Cash drawer history report
• Master File reports
• Running totals report by cash drawer
• Interface report

Cemetery Module™—iHelper™ Infrastructure Management Module

The Cemetery Module provides an integrated records management system that makes it easy to create a permanent, centralized set of records of your cemetery's burial sites. The Cemetery Module lets you add, modify or delete records, it also features user-definable codes that make data entry and retrieval fast and easy. Lookup tables are provided to help you find the code you need quickly. Data and reports can be displayed on screen, written to a disc file or sent to a printer.

As part of the iHelper infrastructure management software, the Cemetery Module can be integrated with your existing iHelper modules or be purchased on its own. You may, however, want to keep track of complaints, equipment or even keep a daily workers log. Spectrum even makes it easy to map your cemetery with a mapping module. You can now print directions for visitors that require help finding sites. For more information on available iHelper modules or to discuss pricing, please call Spectrum at 1.800.879.3225.

Record Capabilities:

• Space ID
• Interred 
• Date of Birth 
• Cause of Death
• Age-Sex-SSN
• Maintenance 
• Lot 
• Maiden Name
• Place of Death
• Nearest Relative 
• Social State
• Price paid 
• Section
• Place of Birth
• Last residence
• Undertaker
• Monument
• Owner

Court Management™

The Court Management software uses state of the art technology to provide the most comprehensive and versatile system available. The system handles motor vehicle, criminal, civil, small claims and local law dockets. From initial entry to final disposition, each docket type is easy to enter and edit. Full tracking abilities include entire case from witnesses to exhibits, trial notes and jurors.

The system also contains a full text processor for issuing and merging letters with docket information. Handles all fines and bail monies by Judge and account. Prints court schedules and Judges schedules and payment receipts.

Benefits & Advantages:

• Allows for partial payment
• Unlimited adjournment tracking
• Allows for sealed dockets
• Copy mode for docket duplication
• Track multiple Judges
• Build quick lists for offers and attorneys
• Tracking of all docket transactions
• Full selection of reports

Reports & Output:

• Disbursements Report
• Monthly State Report
• Detailed Attorney List
• Officers List
• Officers Locations Report
• Laws List
• Docket Cards
• Warrants List
• Calendar Schedule Report
• Cash Receipts Report
• Bail Journal
• Scoff Law
• Analysis of Cash
• Docket Report
• Adjustments Report
• Bank Deposits Report
• ACD Report
• Non-Appear / unscoff Report

Credit History™—FlexiBill™ Utility Billing Subsystem

The first priority when using the Credit History Subsystem for the first time is to establish the criteria for determining credit ratings. This task is handled through the Credit Criteria Maintenance function. The criteria is based on user-defined events. For each of these events, you can designate the number of occurrences and the order, consecutive or nonconsecutive, these occurrences should appear before influencing consumer credit ratings. As a final criterion, you will need to indicate the number of billings before the system checks Credit Criteria and calculates credit ratings. Once both sets of criteria are entered, credit ratings for individual consumers will change depending on whether the consumer fits the established criteria.

If you wish to revise individual credit history information, you can manually post the occurrence of the credit related event through Credit History Maintenance. Whenever it becomes necessary for you to view an individual customers credit history, you can do so using Credit History Maintenance. This permits you to see not only the customers most recent credit ratings but also the latest credit history involving the current billing period and past billing periods.

Benefits & Advantages:

• Utilizes user-defined criteria & occurrence frequency to determine credit rating.
• Maintains a credit profile for each customer.
• Profile variables may be weighed for value in addition to frequency.
• Draws information from FlexiBill utility billing, for minimum data entry

Reports & Output:

• Credit History Report
• Credit history on-screen inquiry

Daily Log Module™—iHelper™ Infrastructure Management Module

The Daily Log Module provides an integrated records management system that makes it easy to create and maintain a personal diary about your activities.  The Daily Log Module lets you add, modify or delete records, it also features user-definable codes that make data entry and retrieval fast and easy. Lookup tables are provided to help you find the code you need quickly. Data and reports can be displayed on screen, written to a disc file or sent to a printer.

As part of the iHelper, infrastructure management software, the Daily Log Module can be integrated with your existing iHelper modules or be purchased on its own. You may, however, want to keep track of complaints, equipment or even keep a daily workers log. For more information on available iHelper modules or to discuss pricing, please call Spectrum at 1.800.879.3225.

Record Capabilities:

• Date
• Time
• Activity Code
• Department
• Time Spent
• Notes

Employee Module—iHelper™ Infrastructure Management Module

The Employee module provides an integrated a management system that makes it easy to create a permanent, centralized set of records of your personnel information.  The Employee Module lets you add, modify or delete records, it also features Special Time Management module that tracks shift and labor hour information. Lookup tables are provided to help you find the code you need quickly. Data and reports can be displayed on screen, written to a disc file or sent to a printer.

As part of the iHelper, infrastructure management software, the Employee module is integrated with your existing iHelper modules or be purchased on its own. You may, however, want to keep track of complaints, equipment or even keep a daily workers log.  For more information on available iHelper modules or to discuss pricing, please call Spectrum at 1.800.879.3225.

• Employee Name 
• Social Security No.
• Address
• Phone No.
• Date of Hire
• Seniority
• Last Review Title
• StatuActive—Inactive, FT, PT
• Employee Number
• Emergency Information
• Blood Type
• Vacation Hours-used / available
• Sick Time-used / available Pay Status
• Pay Rate
• Salary paid to date
• Taxes paid to date
• FICA paid to date
• Medicare paid to date

Equipment Module—iHelper™ Infrastructure Management Module

The Equipment Module provides an integrated records management system that makes it easy to create a permanent, centralized set of records of your equipment. The Equipment Module lets you add, modify or delete records, it also features user-definable codes that make data entry and retrieval fast and easy. Lookup tables are provided to help you find the code you need quickly. Data and reports can be displayed on screen, written to a disc file or sent to a printer.

As part of the iHelper, infrastructure management software, the Employee module is integrated with your existing iHelper modules or be purchased on its own. You may, however, want to keep track of complaints, equipment or even keep a daily workers log.  For more information on available iHelper modules or to discuss pricing, please call Spectrum at 1.800.879.3225

Record Capabilities:

• Equipment Number
• Equipment ID
• Equipment Description
• Equipment Purchase Code
• Manufacturer
• Serial Number Model Number
• Condition at Purchase
• Condition at Present
• Estimated Repair Cost
• Year Purchased
• Year Manufactured

MicroFund™—Fund Accounting

MicroFund, fund accounting, is a powerful and comprehensive accounting tool designed to support the financial activities of public sector organizations and utilities.  The system conforms to GAAFR requirements and addresses general ledger, budgeting, purchasing, accounts payable and financial reporting regulations and desires.

The system offers built-in flexibility. Its account number design let's the user define the structure and contents of the chart of accounts, and the vendor information file can be custom-tailored.  Interim-financial statements may be produced at any time.  MicroFund also allows posting for any accounting period—past, present or future.

Benefits & Advantages:

• GAAFR financial year end reporting format
• Captures and maintains comprehensive detail for audit purposes
• User-definable setup menus to accommodate both novice and experienced users
• Program supports both cash or accrual accounting
• Includes full integration with other MCS systems; payroll, utility billing, property tax collection, cash receipts, fixed asset management etc.
• System retains detailed history for the number of fiscal years required by the user; utilizes a flexible, user-defined chart of accounts
• Offers administrative reporting by fund, department or activity
• Allows for various sorting and selecting on vendor lookups
• Offers multiple fund accounting and reporting, including inter-fund transfers
• The system will accommodate those users with a requirement for multiple checking accounts.
• Automatically creates the required inter-fund transfer journal entries necessary for use with a single checking account
• Transactions can be posted to any fiscal period that is open for posting, including past, current or future; administrative rights allow reopening of previous periods for posting
• Inquiry option allows access transactions for multiple years in the following categories:  Budget, Open A/P, A/P History, G/L and POs
• Includes a full set of budgetary and financial reports in both detail and summary formats
• Inquiry & reporting for historical budget information
• Permits automatic encumbering and liquidation of purchase orders.
• Allows users to assign specific transaction numbers or have the system numerically generate transaction numbers
• Provides online transaction balancing
• Ability to print detailed journals prior to and after posting
• Duplicate Vendor invoice number tracking
• Allows check writing from multiple checking accounts and banks 
• Provides check reconciliation assistance
• Supports all information for the 1099 Miscellaneous forms
• Allows users to change the 1099 box to update at the time of data entry
• Provides for online maintenance of historical transactions through adjustment transactions

Interfaces to additional MCS Subsystems including:  Purchasing Agent

Reports & Output:

• Complete Master File Reporting
• Edit Lists and Posting Journals for each entry type
• Detail & Summary Budget Reports
• NYS Budgetary Report
• Detail & Summary Purchase Order Reports
• Vendor Analysis Report
• Cash Requirements Report
• Accounts Payable Trial Balance
• List of Vendors to be Paid
• Check Register
• Statement of Actual & Estimated Revenues
• Statement of Expenditures, Encumbrances & Appropriations
• Balance Sheet
• Trial Balance
• General Ledger
• Selective Check Register of Outstanding, Voided & Returned Checks
• Treasurer's Report
• 1099's Printing & Reporting
  

iHelper™—Public Works / Infrastructure Management Software Solutions

iHelper software is an integrated infrastructure management tool that makes it easy to manage daily work flow, track costs and create a permanent centralized set of records. You configure the product to meet your needs. The base package includes the complaint module, plus, two other modules of your choice. You purchase only what you need. The software features user-definable codes that make data entry and retrievals fast and easy. Lookup tables are provided to help find the code you need quickly.  The work sheet feature allows for the quick entry of tasks and work performed after the fact. Data and reports can be displayed on screen, written to disk file or sent to a printer.

Benefits & Advantages:

• Centralizes logs and records
• Standardize your records
• Design an infrastructure maintenance system tailored to your needs
• Purchase only what you need when you need it
• Avoid missed maintenance tasks with PM scheduling abilities
• Automated reports to support your position or provide Municipal officials
• Inventory all materials and supplies including automated reorder reports
• Saves time and effort
• Helps evaluation of activities
• Expands management control
• Reporting is easy and fast and runs on low cost PCs
• Easy to learn and use
• Reduce paper records
• Integrates with ZMapT

Additional Modules:

• Accidents
• Bridge
• Cemetery
• Complaint
• Daily Log
• Drainage-Culverts
• Employees
• Equipment
• Fuel
• Gas
• Poles
• Parts
• Road
• Sewer
• Sign
• Signals
• Snow & Ice
• Transformers
• Trees
• Valves
• Water
• Water Lines
• Work Orders

Meter Readers—FlexiBill™ Utility Billing Subsystem

The Meter Reader subsystem provides a utility with an efficient, reliable and accurate means of interfacing meter readings between FlexiBill and the software provided with electronic meter reading systems.  All major vendors are supported.

In addition to the standard formats, there is also a Custom Setup option that can be used to create single record type formats for import and export.  For example, this method could be used to share reads between two separate billing authorities that have overlapping customers. 

The process works as follows:  In the FlexiBill meter Reader Subsystem, the group of meters to read is selected by cycle or book.  An ASCII file is then created.  This file is read by the electronic meter reader vendor's software and then transferred to each handheld reader unit for input.  After all reads have been compiled, the electronic meter reader vendor's software creates a new ASCII read file.  This file is then read by FlexiBill Meter Reader Subsystem which attaches the reads to each account.  The meter reader report is then run and once verified, the billing process begins.

Meter Reader Subsystem supports touch pad, radio read and manual hand held data entry methods.  Each solution is solidly based on industry standards and backed by MCS total service and support.

Benefits & Advantages:

• Allows management to identify no reads, broken meters, out of range readings and much more
• Eliminates duplicate efforts in meter data collection and consolidation all data collection into one system
• Provides accurate, reliable meter readings by verifying each reading as it is entered against the user-defined "hi-low" ranges
• Reduce return trips for rereads and data entry errors
• Flexible search feature allows the readers to look for out of sequence reads, giving them the option to easily re-sequence their route when needed.
• Time stamps each meter reading to help identify poor routes and avoid "curbside" reads

Reports & Output:

• Abnormal reading report
• Meter reader activity report
• Meter reading detail report
• Meter reader notes
• Meter reading report

Parts Module—iHelper™ Infrastructure Management Module

The Parts Module provides an integrated records management system that makes it easy to create a permanent, centralized set of records of your parts in inventory. The Parts Module lets you add, modify or delete records, it also features user-definable codes that make data entry and retrieval fast and easy. Lookup tables are provided to help you find the code you need quickly. Data and reports can be displayed on screen, written to a disc file or sent to a printer.

As part of the iHelper, infrastructure management software, the Parts Module can be integrated with your existing iHelper modules or be purchased on its own. You may, however, want to keep track of complaints, equipment or even keep a daily workers log.  For more information on available iHelper modules or to discuss pricing, please call Spectrum at 1.800.879.3225.

Record Capabilities:

• Part Name
• Part Number
• Part Description
• Part Category
• Part Location
• Vendor Information
• Minimum Inventory Level
• Number On-hand
• Measure
• Quantity Used
• Minimum Order Quantity
• Costs
• Primary and Secondary Vendor Put-ups
• Receivables Including Vendor Invoice and PO

PayForce™—Payroll System

The PayForce system addresses human resources, payroll accounting and reporting, leave accounting and personnel records of public sector organizations and utilities. The system has built in flexibility with a variety of user defined fields and functional options. With the interface to MicroFund fund accounting, the system provides for distribution of pay, deductions and benefits.  It can handle tax calculations for tax deferred pay and deductions or for taxable fringe benefits. Salary amounts may be automatically distributed to different departments, based on hours worked, percentage or flat dollar amounts. And if a frequency adjustment needs to be made for a group of employees paid at the same time, the user can select the ones to pay at different times.

Benefits & Advantages:

• Provides for comprehensive payroll calculation and reporting
• Accommodates multiple types of leave accrual and tracking
• Allows mass update of pay rates, deductions and benefit amounts
• Accommodates both manual and voided checks
• Permits inquiry on checks by employee and checks by bank
• Allows for multiple payroll frequencies
• Employee personnel information is user defined
• Permits on line file maintenance, inquiry and review of master files and transactions
• Accommodates salaried, contract and hourly employees; joint processing of hourly and salaried payrolls is possible for as many as seven pay frequencies
• Permits multiple pay rates and departmental accounting distributions per employee
• Allows maintenance for current period, month to date, quarter to date, calendar year to date, fiscal year to date, fiscal year to date payrolls and life to date
• Provides for calculations and applicable deductions for federal, state, local, FICA, FUI and SUI taxes, as well as for additional employee deductions and benefits
• Permits full access to all information regarding each employee through the use of numerous on screen inquiries
• Accommodates five different payroll frequencies for each payroll cycle
• Each employee can have up to 999 individual deductions and fringe benefits.
• Each category of pay can charge up to 99 different expense centers as well as individual capital projects.
• The system allows for 12 user-defined total categories. This feature keeps separate gross pay totals for any deductions or fringe benefits that are calculated prior to deducting taxes.
• The system will allow for multiple state and local tax tables. These tables are maintained by the user and allow for changes to tax calculations without additional programming.
• Multiple types of leave accruals and categories; individual leave balances can be printed on the check stub.
• W-2 information can be transferred via magnetic media to meet new IRS MMREF requirements.
• Pay rates can be changed by different categories, such as department of job class.
• Prints a direct deposit payroll stub for employees as applicable.
• Features a timekeeping system to allow for charging time to specific cost centers or capital projects.
• Allows unlimited retention of employee payroll history; historical inquiries are available for both individual employees and each payroll checking account.
• Payroll is processed on an exception only basis, greatly reducing the amount of time required to prepare and run a payroll.

Subsystems include:  Time Clock Subsystem

Reports & Output:

• Employee leave report
• Direct deposit report
• Voided check register
• Deductions/benefit register
• Gross deduction/benefit report
• Payroll voucher journal
• Time transaction audit report
• Current earnings/benefit register
• Check register
• Employee deduction/benefit register
• Gross earnings register
• Manual check register
• Selective check list
• Interface completion report
• Payroll distribution journal
• Purged employees register

Property Tax Manager™—Property Tax Billing & Collection

Property Tax Billing and Collection provides for the ability to maintain accurate financial information on all taxable properties within the municipality. Included within this system is the ability to provide for rapid searchers of any current information to issue timely tax statements, to enable rapid updating of financial data and to track accounts by various user defined parameters. Property records may be located by statement number, name or tax number.

County/Town generated tax bills can be converted into Property Tax Manager for ease of collection. Unlimited number of user-defined alternative taxes (Sewer, sidewalk, etc.) The Spectrum Property Tax application also handles automatic electronic tax payments by banks and tax escrow agents.

Benefits & Advantages:

• Assessed valuation on land and buildings
• Unlimited special assessments
• Compute up to 6 payment installments
• Record property transfers
• Supports laser bills
• Unlimited record history
• Bar coded bills for ease of collection
• Unlimited exemption amounts
• Multiple penalty computing ability
• Supports receipt printing
• Lock boxes—other agency
• Payments
• Six line business addresses.
• Status codes
• Supports laser bills

Purchasing Agent™ —MicroFund™ Subsystem

Purchasing Agent is a MicroFund fund accounting subsystem. It automates the creation of requisitions and purchase orders. Requisitions can be prepared within each department and then converted to purchase orders by a central purchasing department without having to reenter any information. Comprehensive reporting features keep the user up to date regarding the status of requisitions and purchase orders. An online inquiry feature is a great way to view system information quickly.

Benefits & Advantages:

• Prints purchase orders and purchase order registers
• Interfaces with MicroFund
• Provides online inquiry by vendor for requisitions and purchase orders
• Maintains a record as items are received
• Assigns purchase order numbers to requisitions
• Allows for partial shipments and partial payments
• Allows separate "ship to" and "bill to" addresses

Reports & Output:

• Requisition Waiting Report
• Purchase Order Register
• Purchase Orders
• Purchase Order Purge List
• "Ship to" Address List
• Outstanding Purchase Order Items list

Service Orders™—FlexiBill™ Utility Billing Subsystem

Service Orders subsystem provides the utility company a means of entering, maintaining and printing service orders required to provide timely and accurate service to the customer base. Since Service Orders subsystem is completely interfaced to FlexiBill utility billing, existing customer data is automatically captured for the service order. Service Orders can also be printed for new accounts requesting service before they have been entered into FlexiBill.

Several features provide unique flexibility in the operation of the system. The event types are user defined. Additionally, the user can add text to be included when the service order is printed.

Benefits & Advantages:

• Maintains information on service location and services to be performed
• Service orders may be stored indefinitely
• Tracks up to 999 separate user-defined events for each service order
• Allows up to 999 lines of free form note text per service order
• Purge function allows maintenance of completed service orders
• Prints service orders on stock paper—pre printed forms not required
• Helps track productivity of service personnel
• Assists with scheduling workload, maintains service order status, assignment and completion details. 

Reports & Output:

• Service orders
• Service order reports
• Status report
• Priority report
• Service order type
• Crew report

Snow & Ice Module—iHelper™, Infrastructure Management Module

The Snow & Ice Module provides an integrated records management system that makes it easy to create a permanent, centralized set of records of snow & ice removal.  The Snow & Ice Module lets you add, modify or delete records, it also features user-definable codes that make data entry and retrieval fast and easy. Lookup tables are provided to help you find the code you need quickly. Data and reports can be displayed on screen, written to a disc file or sent to a printer.

As part of the iHelper,  infrastructure management software, the Snow & Ice Module can be integrated with your existing iHelper modules or be purchased on its own. You may, however, want to keep track of complaints, equipment or even keep a daily workers log. For more information on available iHelper modules or to discuss pricing, please call Spectrum at 1.800.879.3225.

Record Capabilities:

• Operators
• Equipment Used
• Miles Covered
• Type of Operation
• Location of  Operation
• Date
• Time
• Hours Worked
• Overtime Worked
• Material Types Used
• Material Amounts Used
• Unit Material Costs
• Composite Material Costs
• Comments

FlexiBill™ —Water, Sewer, Electric, Gas,  Sanitation, Billing Application

The FlexiBill system supports the billing, collection and accounting activities of government, special districts and utility authorities.   The system calculates and prints bills for both metered and flat rate services and provides historic information for periodic rate analysis.   In addition, FlexiBill, utility billing,  has a large selection of optional subsystems that provide users with features such Automated Meter Readings, Budget Billing, Service Orders, and Automatic Payment processing.

The user has extensive flexibility.   For example, there are user-defined fields on customer information screens and multiple cycles can be billed at one time.   For reporting, there is a wide selection of administrative reports.  The system's user-defined features may be used to tailor reports, and menu screens, which may be personalized for easy access to frequently used functions. The FlexiBill utility billing software interfaces to MicroFund, fund accounting for distribution of revenue, deposits and payments as well as interfacing from the Cash Receipts program for cash drawer processing of receipts.

Benefits & Advantages:

• Account locator provides easy customer account number "look up" through any of 12 categories (name, address, phone, social security number, etc.)
• Allows the user to enter partial information and select from a list
• Handles billing for one-time services based on user defined rate tables
• Includes user defined fields on the customer file and service files to allow custom tailoring without reprogramming
• Pop-up menus and windows permit easy access to information by providing quick paths to frequently used options
• Allows calculation of simple interest on deposits for specified services and customers
• Allows for individual or mass estimates of meter readings
• Automatically verifies meter readings for abnormal readings
• Processes meter readings in book-route sequence or account number order for ease of entry
• Processes delinquent account penalties, delinquency notices, and cutoff notices
• Prints bills in Zip Code, carrier route #, name, route # or account number order
• Provides a printer redirection option in report selection screens
• Offers accounts receivable aging as well as billing and consumption analysis by service,classification and rate
• Includes unlimited billing period customer history, limited only by user hardware
• Allows simple process for payment and credits
• Allows memo posting which gives up to the minute balances during payment entry
• Automated refund of credit balances due to disconnection or overpayment as well as refund check processing
• Handles meter change outs  
• Support for Postal Address Certification using the PACE Subsystem

Available Subsystems:

• Meter Readers
• Service Order 
• Account Bar Code
• Automatic Payment 
• Budget Billing
• Credit History
• PACE Certification
• Bad Debt/Tax Levy

Reports & Output:

• Account history report
• Billing analysis report
• Consumption proof list
• Delinquency report
• Consumption history
• Adjustment report
• Meter reader's list
• Mailing labels
• Rate file list
• Shutoff register
• Deposit distribution report 
• Check register
• Account master list
• Refund checks
• Rate analysis report
• Batch status report
• Cutoff notices
• Various utility bill styles
• Aged trial balance
• Consumption analysis report
• Delinquent notice
• MTD financial summary
• Payment and adjustments register
• Missing & questionable readings report
• Outstanding one-time charges
• Transaction definition list
• Deposit refund distribution report
• Outstanding deposit report
• Customer balance report
• Alternate address/owner list
• Unapplied transactions report
• Manual distribution report
• Automatic distribution report

FlexiBill™ Utility Billing Software Solution—Water, Sewer, Electric, Gas, Sanitation

The FlexiBill system supports the utility billing, collection and accounting activities of government, special districts and utility authorities.   The system calculates and prints bills for both metered and flat rate services and provides historic information for periodic rate analysis.   In addition, FlexiBill, has a large selection of optional subsystems that provide users with features such Automated Meter Readings, Budget Billing, Service Orders, and Automatic Payment processing.

The user has extensive flexibility.   For example, there are user-defined fields on customer information screens, and multiple cycles can be billed at one time.   For reporting, there is a wide selection of administrative reports.  The FlexiBill utility billing software interfaces to MicroFund, fund accounting for distribution of revenue, deposits and payments as well as interfacing from the Cash Receipts program for cash drawer processing of receipts.

Benefits & Advantages:

• Account locator provides easy customer account number "look up" through any of 12 categories (name, address, phone, social security number, etc.).
• Handles billing for one-time services based on user defined rate tables
• Includes user-defined fields on the customer file and service files to allow custom tailoring without reprogramming
• Allows calculation of simple interest on deposits for specified services and customers
• Allows for individual or mass estimates of meter readings, handles meter change-outs and verifies meter readings for abnormal readings
• Processes meter readings in book-route sequence or account number order for ease of entry
• Processes delinquent account penalties, delinquency notices, and cutoff notices
• Prints bills in Zip Code, carrier route #, name, route # or account number order
• Offers accounts receivable aging as well as billing and consumption analysis by service, classification and rate
• Includes unlimited billing period customer history, limited only by user hardware
• Automated refund of credit balances due to disconnection or overpayment as well as refund check processing
• Support for Postal Address Certification using the PACE Subsystem

Available Subsystems:

• Meter Readers
• Service Order 
• Account Bar Code
• Automatic Payment 
• Budget Billing
• Credit History

• PACE Certification

• Bad Debt

Reports & Output:

• Account history report
• Billing analysis report
• Consumption proof list
• Delinquency report
• Consumption history
• Adjustment report
• Meter reader's list
• Mailing labels
• Rate file list
• Shutoff register
• Deposit distribution report 
• Check register
• Account master list
• Refund checks
• Rate analysis report
• Batch status report
• Cutoff notices
• Various utility bill styles
• Aged trial balance
• Consumption analysis report
• Delinquent notice
• MTD financial summary
• Payment and adjustments register
• Missing & questionable readings report
• Outstanding one-time charges
• Transaction definition list
• Deposit refund distribution report
• Outstanding deposit report
• Customer balance report
• Alternate address/owner list
• Unapplied transactions report
• Manual distribution report
• Automatic distribution report