How_do_I_delete_billing_transactions_

How do I delete billing transactions?

Use this routine to delete billings, including penalty billings, and contract billings in the current period. This routine will not delete final bill or manual bill transactions.


Before you get started

Deleting billing transactions

1. Open Connect Utility Management > Organization > Delete Billing Transactions.

2. Select the District and Cycle.

Filter billing transactions by district and cycle. These fields are only available when the organization is using districts and cycles.


3. Select the Services.

Filter billing transactions by service. Press and hold CTRL to select multiple services.


4. Set up the checkbox titled Delete Metered Transactions.

A metered transaction records amounts used for metered services, such as water or electricity, that only require a consumer to pay for the portion used.

Do you want to delete transactions for metered services?

  • Yes, I want to delete transactions for metered services. Click to select Delete Metered Transactions.

  • No, I do not want to delete transactions for metered services. Click to deselect Delete Metered Transactions.


5. Set up the checkbox titled Delete Automatic Transactions.

An automatic transaction is a transaction that is created by the Calculate Automatic Billings routine. Use Delete Automatic Transactions to permanently remove transactions for auto-billings from the database.

Do you want to delete transactions for auto-billings?

  • Yes, I want to delete transactions for auto-billings. Click to select Delete Automatic Transactions.

  • No, I do not want to delete transactions for auto-billings. Click to deselect Delete Automatic Transactions.


6. Enter the Beginning/Ending Billing Date.

Use the Beginning/Ending Billing Date to define the date range. Only transactions with billing dates that occur within the date range will be included. Use the Beginning Billing Date field to enter the first date in the date range. Then, use the Ending Billing Date field to enter the last date in the date range.

7. Click GO (CTRL+G).

The billing transactions are deleted.

Updated on 21Jun2017.

Deleting contract billings

Use this option to delete contract billings.

Do this...

1. Open Connect Utility Management > Organization > Delete Billing Transactions.

2. Click to select the checkbox titled Delete Contract Billings.

Delete contract billings

3. Click GO (CTRL+G).

The billing transactions from the current period for contracted billings are deleted.

Updated 21Aug2018

Deleting billings

Use this option to delete service billings.

Do this...

1. Open Connect Utility Management > Organization > Delete Billing Transactions.

2. Click to select the checkbox titled Delete Billings.

Delete billings

3. Use the section titled Services to select a service.

For example, City XYZ creates penalty billings. After a quick review, City XYZ sees an error in the penalty calculation. City XYZ uses the Delete Billing Transactions routine to delete the penalty billings from the current period. City XYZ fixes the penalty billing calculation and calculates penalty billings again.

Services

4. Click GO (CTRL+G).

The billing transactions from the current period for the selected service are deleted.

Updated 21Aug2018

Deleting automatic billings

Use these instructions to delete automatic billings and metered billings. You can set up the selection criteria to filter by transaction description for automatic billings, metered billings, or both automatic and metered billings.  

Do this...

1. Open Connect Utility Management > Organization > Delete Billing Transactions.

2. Find the Transaction.Description in the Selection Criteria.

3. Double-click ALL.

Transaction.Description ALL

The Enter Values form displays on the screen.

4. Click Search.

Enter Value

The Search form displays on the screen.

5. Set up the Search form.

To delete automatic billings, select Automatic Billing. To select metered billings, select Metered Entry. To select both options, press and hold the CTRL key and then click each item.

Search form

5. Click OK.

The Transaction.Description value shows the updated search criteria.

Selection criteria

6. Set up the remaining options.

7. Click GO (CTRL+G).

The routine deletes automatic billings, metered billings, or both automatic and metered billings depending on how you set up the selection criteria.

Updated 21Aug2018

 

 

Copyright © 2025 Caselle, Incorporated. All rights reserved.

    • Related Articles

    • Error: Customer missing a billing service for transactions

      Issue A customer is missing a billing service for transactions. Explanation A customer should have a billing service for each service in their transaction history. Solution Add the service to the customer (Modify Existing Customers). The error report ...
    • How do I delete a rate?

      Has the rate been used to create billing transactions? If the answer is yes, then the rate cannot be deleted from the Rates table. You can prevent other users and services from using the rate by changing the rate to stop allowing new billings. [More] ...
    • How do I modify transactions?

      A transaction is any entry that records an exchange or transfer of goods, services, or funds. Use Modify Transactions to make changes to entries that cannot be made using the other routines in Connect Utility Management. Warning! Contact Customer ...
    • How do I delete and repost transactions to the UM journal? (2024.08)

      Issue I posted transactions to the UM journal that I need to replace. How do I get rid of the existing transactions so I can post the new transactions without creating duplicate transactions? Solution 202408, 2024Nov05 Copyright © 2025 Caselle, ...
    • How do I delete and repost transactions to the UM journal? (2024.08)

      Issue I posted transactions to the UM journal that I need to replace. How do I get rid of the existing transactions so I can post the new transactions without creating duplicate transactions? Solution Copyright © 2025 Caselle, Incorporated. All ...