Application design and programming Arkansas Data Services has the experience to assist you IBM Legacy Software Hosted In The Cloud DOCS/400 Medical Practice Management System Arkansas Data Services offers a wide range of software for the Distribution Industry Report Archive Service for IBM i (RASi)
  • Utility Management
  • Medical Practice Management
  • Distribution Industry
  • Financial Accounting
  • Information Archiving
  • IT Services
Innovation Quote

Jeff Roper
Professional Consulting Services

 

Utility Management Software

Arkansas Data Services' Utility Billing and Accounting System has been managing the needs of small to medium sized utilities since 1994. The software is implemented on the IBM System i family of products, and capitalizes on the legendary stability, reliability, scalability, and versatility of that architecture.  The system is comprised of:

Additional Module Details

Click on each tab for complete information on each module available in the Utility Management System

  • Utility Billing
  • Accounts Receivable
  • Customer Information
  • Service Orders
  • MUSA
  • Invoices
  • Refunds
  • Accounts Payable
  • Payroll
  • General Ledger
  • Job Scheduling
  • Cycle Billing
  • Direct Billing
  • Invoice Credit or Adjustment
  • Service Charge Billing
  • Deposit Billing
  • Bad Debt Billing
  • Past Due Processing (Shut offs)
  • Compound Meter Processing
  • Meter handheld Up/Down Loading
  • Private Fire Billing (Monthly non-metered billing)
  • Automatic Bank Draft Processing
  • Cash Receipts entry by Invoice Number, Profile or Customer
  • Cashiers Drawers with tape receipts
  • Deposit Ticket Print
  • Return Check Processing (Void Check)
  • Customer Refund thru Accounts Payable System
  • Deposit Refunds
  • Customer Aging
  • Credit/Debit Card Processing
  • Web Processing
  • Ability to E-Mail bills to customers
  • Detail Customer information such as name, address, social security number, date of birth, drivers license, billing information, employer information, spouse or roommate information, nearest relative and bank draft information
  • Service Locations used by customer with detail billing, payment and service order histories on both active and inactive accounts.
  • Credit Ratings on each account with an overall customer rating
  • Detail services at the current active service location with meter information
  • Notes for the user on the customer, their profiles, invoices and service orders
  • Payment history including number of shut off notices, door hangers, returned checks, bad debt amount and write off date
  • Customer search by name, date of birth, social security number, address, or employer
  • Detail billing of each invoice
  • Deposit tracking
  • Landlord tracking
  • Permit Orders will bill permit fees and generate inspection orders for each permit.
  • Connect Orders will connect the customer to the selected service location and ready for billing. If transferred any deposits will be transferred to the new location. It will bill any new deposits.
  • Disconnect Orders will produce a final bill and refund deposits if not a transfer. Once this is closed the service location is ready for a new connect order. You do not have to wait until the next day.
  • Transfer Order is a disconnect and connect order.
  • Problem Order - The user selects one or more events for the order. Customer charges may also be added to this type of order. The charges will be billed with the next billing cycle.
  • Inspection Orders are generated with the close of a Permit Order.
  • Additional Deposit Orders are used to bill customers an additional deposit due to poor payment history. A suggested amount is printed when shut off notices are generated.
  • Internal Orders are used to set up routine work orders required by your company.
  • Daily printing of orders to be worked that day. These orders will be printed at the corresponding work centers.
  • Daily open order reports of orders due but not closed by priority rating
  • Service Order priority rating for 1 (High), 2(Med.) or 3(Low)
  • Tracks labor hours on all orders
  • Job scheduling
  • GPS Based
  • Tablets
  • Service order routing
  • Service order note and transaction detail access
  • Job time interface
  • Service vehicle geo-tracking
  • Google Map intergration
  • IBM System i and DB2
  • IBM Websphere Application Server
  • Utility billing invoices - Will contain each detail part of the billing invoice including billing transactions, amounts, consumptions, meter numbers, meter readings, reading dates and taxes. Due dates are based on mailing date.
  • Deposit billing invoices. All deposits are billed on separate invoices.
  • Direct billing invoices - Any special billing that is not included on the customer bills. An example is for permit fees, reconnect/disconnect fees, material and/or labor fees. Fees charged thru service orders may also generate a direct bill or may be added to the next customer billing.
  • Invoices may also be corrected. If the meter reading is in error, the invoice can be credited off and the meter readings will open for changes to be made. You may also issue credit without changing the meter reading.
  • Customer refunds will be issued via the Accounts Payable system
  • Refunds are only generated if the customer overall account balance is a credit. This allows you to apply a credit from one account to another account.
  • Ability to force deposit refunds to a customer
  • Supports up to 99 different companies.
  • Provides the ability to track manual and voided checks in addition to the computer written checks.
  • Provides the ability to track refund checks written from the accounts receivable module.
  • Supports user defined term codes
  • Produces 1099's.
  • Provides cash requirement by due dates.
  • Calculates due dates based on term code.
  • Provides a check approval list before printing checks.
  • Provides a dynamic vendor name search and retrieval.
  • Provides a dynamic "remit to" name search and retrieval.
  • Supports cash or accrual base accounting.
  • Provides online display of checks issued to any selected vendor.
  • Provides online display of paid invoices for any selected vendor.
  • Provides online display of open invoices for any selected vendor.
  • Provides the online display of the general ledger expense distribution.
  • Allows suspending payment to any selected vendor.
  • Allows checks to be written from multiple bank accounts.
  • Allows database search and retrieval by check number.
  • Allows database search and retrieval by invoice number.
  • Print or display year-to-date activity for any given vendor.
  • Interacts with other Utility Management applications.
  • Pop up windows provide user assistance and data retrieval.
  • All future enhancements provided free with optional support agreement.
  • Supports up to 99 different companies.
  • Supports up to 999 deductions.
  • Allows grouping of employees by department
  • Allows 3 types of voluntary deductions (fixed amount, percentage and declining balance).
  • Allows for pre-tax deductions on all selected earnings.
  • Provides ability to override wage and deduction information for each payroll.
  • Retains complete information for each payroll processed.
  • Allows direct deposit of employee paychecks and company taxes, including Quarterly.
  • Employee inquiry allows display of current or prior year's information for each payroll. Inquiry can be on detailed checks or summarized by month, quarter and year.
  • Employee inquiry allows display of current or prior year information for each payroll or summarized by month, quarter and year.
  • Calculates and displays check information (voluntary deductions, taxes and net pay) during data entry.
  • Automatically selects employees for next payroll based on pay cycles.
  • Provides quarterly reports for unemployment and FICA.
  • Supports weekly, bi-weekly, semi-monthly and monthly pay periods.
  • Allows additional compensation to be added to any check.
  • Allows taxes on bonus pay to be calculated at a different rate than regular pay.
  • Allows payroll to be processed for the new year with prior year remaining open.
  • Tax tables can be maintained by the user without requiring program modifications.
  • Interacts with other Utility Management applications.
  • Pop up windows provide user assistance and data retrieval.
  • All future enhancements provided free with optional support agreement.
  • Supports up to 99 different sets of books.
  • Supports up to 99 companies per each set of books.
  • Supports up to 99 divisions per company.
  • Allows budgeting by each month.
  • Allows financial reports to be custom designed by the user via online report writer.
  • Allows a detail account analysis to be printed or displayed online for any selected accounting period.
  • Allows posting activity to future periods.
  • Provides bank reconciliation for each individual bank account.
  • Maintains current and prior year information.
  • Allows financial reports to be printed at anytime.
  • Allows prior financial reports to be reprinted.
  • Allows automatic posting of reoccurring journal entries.
  • Allows a detail activity report to be produced on year-to-date journals upon request.
  • Interacts with other Utility Management applications.
  • Pop up windows provide user assistance and data retrieval.
  • All future enhancements provided free with optional support agreement
  • Allows the user to schedule jobs to process based on: a specified time, specified day of the week, specified day of the month, based upon an established run schedule, specified date, specified frequency.
  • Allows scheduled jobs to bypass processing on holidays.
  • Displays scheduled jobs in sequence by run time or job name.
  • Allows the user to hold scheduled jobs from execution.
  • Allows the user to temporarily bypass scheduled jobs.
  • Maintains a log of completed jobs and abnormal terminations.
  • Allows electronic transmission of job logs to Arkansas Data Services's support line.
  • Allows conditional processing based on the completion status of previous jobs.
  • Pop up windows provide user assistance and data retrieval.
  • All future enhancements provided free with optional support agreement.