TRANXACT.AI 帮助

Utilities: municipal billing

These features extend CRM › Utilities. Every new screen sits in an existing Utilities section.

These features extend CRM › Utilities. Every new screen sits in an existing Utilities section.

Budget billing

CRM › Utilities › Utility Billing › Budget Billing

  • Enrol an account to bill it a levelized amount each month. The amount is the average of its actual charges over the last N months (Utility Settings › Budget: months averaged), plus a share of its budget balance (Budget: % of the balance in each amount).
  • Each bill gets a Budget billing line that brings the bill to the installment. The difference goes into the account's budget balance, which posts to the budget balance account. The bill prints the installment and the balance.
  • Override amount bills a fixed amount until cleared; a reason is required.
  • Recalculate or Recalculate all redoes the average; overrides are kept.
  • An adjustment recalculates the plan automatically.
  • Apply budget balance bills what is owed, or credits what was paid ahead. Use it on request, or tick *Settle up and end the plan*.
  • Budget: largest balance carried caps the balance. Anything beyond the cap is billed or credited on that bill.
  • Budget Balance Movements lists every change.

Sewer (winter) averaging

CRM › Utilities › Utility Billing › Sewer Averages, and Service Agreements › Sewer billed on

  1. Set the window (MM-DD), the method (average / lowest / median), the read periods used, the cap and the effective date in Utility Settings.
  2. Compute averages for one account or for every account on the winter average. Read periods that cross the window are prorated by day.
  3. A sewer agreement *on the winter average* bills the lesser of the average for the period's days and the water used. *Deduct* bills water less a deduct (irrigation) meter. A sewer service with no meter bills on the water used.
  4. Override sets an account's average, with a reason code. Every change is in the audit trail.

调整

CRM › Utilities › Utility Billing › Adjustments and Adjustment Reasons

  • New adjustment makes a credit or a debit with a Town reason code: dollar only, consumption only, or both. With *both* and no amount, the consumption is priced at the account's first block.
  • Transfer balance moves part or all of one account's debt to another account.
  • Transfer payment moves part or all of a payment to another account.
  • Approval: above the reason's limit (or the company's limit, Utility Settings), a second person approves with Approve or Reject. The person who asked cannot approve.
  • Posting: a credit comes off the open bills as credit memos, and any rest becomes a credit balance. A debit is a charge bill.
  • Posted adjustments are itemized on the account's next bill.

Interdepartmental billing

CRM › Utilities › Service Accounts: tick *Interdepartmental*, and give the department cost center and expense account.

The account is billed like any other. When the bill posts, it is paid at once by interfund journal: the department's expense account is charged under its cost center (its fund), and due-to / due-from settles the funds. No receivable is left.

Collections

  • Cash only: a cash-only account refuses checks and bank drafts. An account becomes cash only automatically after the number of delinquencies set in Utility Settings.
  • Payment history rating (Service Accounts › Payment history rating): counts late fees in the window that were not reversed. It gives the rating and the deposit the rating calls for.
  • Late fee exemption: once, until a date, or permanent, with a reason. When an *until* exemption runs out with the account past due, an alert is sent and late fees apply again.
  • Late Fee Rules (Utility Collections): rules by jurisdiction or rate plan, each with a flat fee, a percentage, monthly interest, grace days and a minimum and maximum fee.
  • Lien: a liened account is never written off and is not placed with the agency.
  • Reconnect: a disconnected account that pays what is past due gets a reconnect order automatically.
  • Cutoff Packets (Utility Collections); New cutoff packet chooses accounts by amount and days past due, cycle, route and class; Add a note to all of them, or to one with Note one account; Issue makes a disconnect order for each account; Door hangers prints them in route order.
  • Collection Agency (Utility Collections); Place qualifying accounts places final and closed accounts past the settings' days and minimum balance, and produces the placement file; Record agency payments one by one, or Import agency payments from the agency's file; Payments made at the Town are recorded against the placement; Recall takes the account back from the agency.

Bill print files

CRM › Utilities › Utility Billing › Bill Print Files › Make print files for a posted bill run.

  • Produces two CSV files in route order: normal bills and delinquent bills.
  • Each file lists, for every bill: the legacy account number, amount due, past due and disconnect date, budget figures, usage, line items and the bill message.
  • Legacy account numbers: set *Legacy account number* on the account. They print where the account says so, or for every account until *Print legacy account numbers until* (Utility Settings).
  • With an outbound folder set in Utility Settings, each file is also written there for the SFTP transfer.

Bank draft (ACH) autopay

  • Service Accounts › Bank draft autopay records the routing number, the account and the customer's authorization. The account number is stored sealed and shown masked. Autopay › Show bank account reveals it to a supervisor, with a reason, and is logged.
  • Bank Draft Files (Utility Cashiering & Payments) › Make draft file makes a NACHA PPD debit file. Each draft is what the account owes when the file is made, so an adjustment since the bill is included.
  • Record settlement posts the payments; list any returned accounts there.

存款

Service Accounts › Deposit interest and refunds does two things:

  • accrues interest at the deposit interest rate;
  • refunds deposits held longer than the refund months with no more delinquencies than allowed, to the open bills and then to a credit.

仪表

  • Meter Statuses (Utility Meters & Reads): the Town's own statuses under the four lifecycle states.
  • A meter has a *Location* (warehouse or truck), a *Town status* and a GPS position.
  • Attached Devices: MEUs, backflow preventers and regulators, with their identifiers and history.
  • Meter Counts: physical inventory by location. Scan serials, Compare, then Reconcile.
  • Compound meters: make each register a meter with *Register of meter* set; its use bills with the main meter.
  • Read checks: stuck meters, use against the same season last year and recent change-outs are weighted (Utility Settings). A read is held when the score reaches the threshold.
  • Do not estimate: an account flagged this way gets a re-read order instead of an estimate.
  • Read Imports › Check the meter roster: compares the AMI/MDM system's meter list with the installed meters before billing, and lists missing, unknown, duplicated, unread and rejected meters.
  • Routes › Suggest walk order: orders a route's premises nearest-next from their positions.

Accounts and premises

  • Responsible Parties and Premise Contacts (Utilities): co-responsible parties, guarantors, owners, occupants, landlords, construction and fire services contacts.
  • Landlord master account: tick *Landlord master account* on the landlord's account and choose it on the premise. When a tenant moves out, service goes back to the landlord the next day. Transfer service (move in) moves it to the next tenant.
  • Combine duplicate customers (Service Accounts) and Combine duplicate premises (Premises).
  • Bill now (off cycle): bills one account outside its cycle, as a draft to review and post.
  • Auto-activation: completing a meter install order puts the pending service at that premise live.
  • Rate Plans › What if: re-rates the plan's bills of the last months with draft blocks and a draft customer charge, by class.
  • Stormwater: set *Stormwater ERUs* (or the impervious area) on the premise, and add a *per_eru* fee to the stormwater plan.

Part 2 (release 20261115)

Rate changes, proration, demand and net metering

*CRM › Utilities › Utility Billing › Rate Plans*

  • Rate change in a period; Give the old plan an Effective to date; Set Replaced by to the new plan.

A bill whose period spans the change is split by days: the old plan's rates apply to the change date, the new plan's after. The use read for the period is shared by days.

  • Proration basis: set per plan: *days* (the default) bills a short period's share of the period's days: *month_30* bills a share of a 30-day month: *none* bills the whole customer charge however short the period.

Tick Prorate the usage blocks too to shrink the block sizes for a short period as well.

  • Demand: set a Demand rate, unit and thresholds on the plan: Reads can carry the peak demand, either typed or from the Harmony Encore *Peak Flow* column: The bill charges the period's peak at the demand rate: When the peak or the use passes the threshold, the service moves to demand billing and the customer is emailed: After the plan's number of bills under the threshold, it is reset automatically.
  • Net metering: on the service agreement, choose the Export meter: What the export meter reads comes off the use billed: When more went back than came in, no use is billed and the difference is banked for the next bill. It shows as *Banked* on the agreement.

Reads

*CRM › Utilities › Utility Meters & Reads*

  • Read Comment Codes: each code says what a reader's comment orders: *STUCK*, *BOXWATER* and *NOACCESS* order a re-read: *LEAK* and *DAMAGED* order a service order: *OK* orders nothing.
  • Read Imports: choose the Harmony Encore format for the vendor's CSV export. It reads the meter, read time, reading, read code and peak flow.
  • Ready to Bill (*Utility Billing*): each completed re-read raises a flag naming the account and any bill held for it. Clear it once the account is billed.

付款

*CRM › Utilities › Utility Cashiering & Payments*

  • Payment Distribution Order; The order in which a payment pays a bill's parts: late fees, reconnect fees, deposits, taxes, each service; Payment Distributions shows how each payment was spread; Override a distribution is available only to roles granted *change* on Payment Distributions, needs a reason, and must add up.
  • History Payment Codes: payments received outside the counter (for example a tap fee paid with the permit): Post a history payment applies it to the bills: It debits the code's adjusting account instead of cash.
  • Receipts: enter the amount Tendered when taking cash, and the change is worked out: *Payments › Receipt* prints the receipt from the template under *Utility Settings › Receipt template*: The template fields are date, time, operator, account, amount paid and posted, tendered, change, balance and a free-text message.
  • Check Images › Scan a check; Scan the stub's OCR scanline or barcode (account and amount) and the check's MICR line (routing, account, check number); Attach the front and back images.

The payment is taken, the images are kept with it, and the endorsement line is printed.

  • Remote Deposits › Build a deposit: gathers the scanned checks not yet deposited into a manifest for the bank's remote deposit upload. The upload itself is set up with the Town's bank.
  • Counter Receipts: money for something other than a utility bill, such as a permit or rental: Each type is set up under Counter Receipt Types with its revenue account: It is taken at the same drawer and counted in the session.

Municipalities

*CRM › Utilities › Utility Billing*

  • Municipalities & Providers: the governments and providers whose charges are on the bill, and the Due-to account where another government's share is kept.
  • Allocation Rules: percent splits by service, line type and jurisdiction, used where a rate plan does not name its municipality (*Rate Plans › Charges belong to*).
  • Bills › By municipality: the consolidated statement.
  • Intergovernmental Balances: what was billed for others and remitted.
  • Remit (on the municipality): pays it.

账户

*CRM › Utilities*

  • Accounts › Set payment PIN: a 4-8 digit PIN that guards the account's banking details. Adding or changing a bank draft needs it, and five wrong tries lock it.
  • Sensitive Customer Data; Driver's licence, SSN and tax id numbers are sealed and listed by their last four digits only; Reveal needs the grant and a reason; Export gives the last four only; Sensitive Data Log lists every view, export, change and refused attempt. Nobody can edit or delete it.

Field service and solid waste

*CRM › Utilities › Utility Field Service*

  • Service Order Costs: labor, material, equipment and contractor costs on an order. The order shows its total.
  • Solid Waste Containers: carts, dumpsters and roll-offs, with type, size, status, account, route and pickup day.
  • Solid Waste Pickups: regular, additional, special and bulk pickups, with containers, tons and landfill charges: Extra pickups with a charge are billed to the account: Solid waste report totals the pickups by route, date and kind.

<!-- from help-fvhr.md -→