How_do_I_update_UM_transactions_General_Ledger_

How do I update UM transactions? (General Ledger)

Update utility transactions to a GL posting period and GL posting journal in the Connect General Ledger.

Depending on your organization's policies and job assignments, you may or may not be responsible for updating utility transactions to General Ledger. It's important that you understand how transactions are updated from Utility Management to General Ledger.

How does routine choose the period/cycle?

When you run this routine, the system will use the period/cycle that was just closed as the default setting. If a period/cycle other than the last closed period/cycle shows up as the default setting, it may indicate that the previous period/cycle was not closed correctly.

What is the purpose of the UM journal?

Updating Utility Management to the General Ledger creates a journal called UM. This journal contains the totals for billings, payments, and adjustments. In addition, a journal entry will be made in the Cash Clearing account for the amount of payments.

How does the routine store the GL credit and GL debit fields?

The routine stores the GL credit and GL debit fields for each transaction that is updated to General Ledger. The GL accounts are stored as a non-formatted number. To review the transaction details included on the GL Update report, print the Transaction Register (Reports > Transaction Register).

Before you get started

Updating transactions to Connect General Ledger

1. Open Connect Utility Management > Organization > Update General Ledger.

2. Use the Beginning Date and Ending Date boxes to enter the date range.

3. Do not select the Update Transactions That Have Already Been Updated checkbox.

4. Set up the update options.

Update tax certification transactions

Update NSF check transactions



5. Click to select the Update Caselle General Ledger checkbox.

6. Verify the GL Posting Period and GL Posting Journal box display the correct posting period and journal.

7. Click GO (CTRL+G).

The selected transactions are updated to Connect General Ledger.

Options

Update tax certification transactions

Complete this section to update transactions for tax certification that have been created in the Utility Management application to the Tax Certification application.

Do you want to update tax certification transactions to the Tax Certification application?

  • Yes, update tax certification transactions. Click to select Update Tax Certification Transactions.

  • No, do not update tax certification transactions. Click to deselect Update Tax Certification Transactions.


Update NSF check transactions

Post transactions created for NSF check transactions to Connect General Ledger. Connect will use the journal and GL account from the NSF Check Interface setting as the posting journal and GL account.

Why can't I click on the Update NSF Check Transactions checkbox? The NSF Check Transactions checkbox is only available when the NSF interface in Organization is set up. To learn more, see How do I set up the NSF check interface?

Do you want to update NSF check transactions?

  • Yes, I want to update NSF check transactions. Click to select the Update NSF Check Transactions checkbox.

  • No, I do not want to update NSF check transactions. Do not select the Update NSF Check Transactions checkbox.


 

 

Copyright © 2025 Caselle, Incorporated. All rights reserved.

    • Related Articles

    • How do I update UM transactions? (General Ledger)

      Update utility transactions to a GL posting period and GL posting journal in the Connect General Ledger. Depending on your organization's policies and job assignments, you may or may not be responsible for updating utility transactions to General ...
    • How do I update general ledger?

      Post the transactions from the Utility Management application to the general ledger. Updating the general ledger may or may not be your responsibility, depending on your organization's policies and job assignments. However, it is still important that ...
    • How do I update general ledger?

      Post the transactions from the Utility Management application to the general ledger. Updating the general ledger may or may not be your responsibility, depending on your organization's policies and job assignments. However, it is still important that ...
    • How do I update NSF check transactions? (General Ledger)

      If you're entering payment adjustments for NSF (non-sufficient funds) check transactions, you can choose to update the NSF check transactions to General Ledger. You can update NSF check transactions as a separate update or you can include NSF check ...
    • How do I update NSF check transactions? (General Ledger)

      If you're entering payment adjustments for NSF (non-sufficient funds) check transactions, you can choose to update the NSF check transactions to General Ledger. You can update NSF check transactions as a separate update or you can include NSF check ...