How_do_I_update_transactions_to_General_Ledger_

How do I update transactions to General Ledger?

Updating transactions to the General Ledger transfers financial transaction information from Business Tax Collection into your organization’s accounting records. This helps ensure that collected taxes, payments, fees, and adjustments are accurately reflected in the General Ledger.

You might update transactions to support financial reconciliation, maintain accurate accounting records, prepare financial statements, streamline reporting, or ensure consistency between tax collection and accounting systems. This process also helps support audits and financial compliance requirements.

 

Updating General Ledger

Post transactions that are created in the Business Tax Collection application to an interfaced General Ledger application.


Do this...

1. Open Connect Business Tax Collection > Organization > Update General Ledger.

2. Enter the Beginning Date and Ending Date.

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

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

4. Set up the option to Print GL Update Report.

The GL update report prints all of the transactions that will be updated to the General Ledger based on the current date range. None of the transactions will be updated to the General Ledger by printing the GL update report.

Do you want to print a GL update report?

  • Yes, I want to print a GL update report. Select the Print GL Update Report checkbox. The system will print the update report. None of the transactions will be updated to the General Ledger by printing the GL update report.

  • No, I do not print a GL update report. Deselect the Print GL Update Report checkbox.

5. Set up the option to Update Caselle General Ledger.

If the interface to the Caselle General Ledger is turned on, you can use Update Caselle General Ledger to post transactions directly to a posting period in the General Ledger.

Do you want to post transactions to the Caselle General Ledger?

  • Yes, I want to post transactions to the Caselle General Ledger. Select the Update Caselle General Ledger checkbox. The system will post transactions to the Caselle General Ledger, and the system will change the status on the exported transactions to updated.

  • No, I do not want to post transactions the Caselle General Ledger. Clear the Update Caselle General Ledger checkbox.

6. Set up the option to Create GL Update Export File.

If the interface is set to update transactions to a Caselle General Ledger, use the option to create an export file to post transactions to a non-Caselle General Ledger.

Do you want to export transactions to a non-Caselle General Ledger?

  • Yes, I want to export transactions. If you aren't using the Caselle General Ledger yet, select the Create GL Update Export File checkbox. The system will create an export file that can then be used to post transactions in the non-Caselle General Ledger, and the system will change the status on the exported transactions to updated.

  • No, I do not want to export transactions. Clear the Create GL Update Export File checkbox.

7. Select the GL Posting Journal.

The GL posting period is the period in the General Ledger that the system will create amounts in the selected journal.

Do you want to post transactions to the default posting period?

  • Yes, I want to post transactions to the default period. This option is recommended.

  • No, I want to post transactions to a different period. Use the GL Posting Period drop-down list to select a posting period.

8. Click GO (CTRL+G).

The routine runs.

 

Updating transactions that have already been updated

When you use this routine to post transactions to the General Ledger application, the system flags the transactions as updated, which prevents the transactions from being posted more than once. In the event that the transactions were posted incorrectly, you can use Update Transactions that have already been Updated to reset the updated flag so you can post the transactions again.  

Step 1: Remove transactions that have already been updated

First, remove the transactions that have already been updated to the General Ledger application. Then, run the Update General Ledger routine with the option to Update Transactions That Have Already Been Updated checkbox selected.


Do this...

1. Open Connect General Ledger > Journals > Enter Journal Amounts.

The Options form appears.

2. Enter the journal name and period.

Use the journal name and period of the transactions to delete. 

3. Click OK.

4. Click Delete (CTRL+D).

The Delete form appears.

5. Set up the options on the Delete form to delete the transactions that were updated to the General Ledger from the last time the Update to General Ledger routine was run.

6. Click OK.

The transactions have been deleted from the journal in the General Ledger.

 

Step 2: Re-update transactions

Run the Update General Ledger routine again with the Update Transactions That Have Already Been Updated checkbox selected. If you do not remove the transactions that were updated from the General Ledger, you may create duplicate transactions. Make sure you complete the previous step before continuing.


Do this...

1. Open Connect Business Tax Collection > Organization > Update General Ledger.

2. Select the GL Posting Period.

The GL posting period is the period in the General Ledger with the transactions that you want to post again.

3. Set up the options on the form.

4. Click to select Update Transactions That Have Already Been Updated checkbox.

5. Click GO (CTRL+G).

The transactions have been re-posted to the General Ledger.

 

Beginning/ending date

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

Create GL update export file

If the interface is set to update transactions to a Caselle General Ledger, use the option to create an export file to post transactions to a non-Caselle General Ledger.

Do you want to export transactions to a non-Caselle General Ledger?

  • Yes, I want to export transactions. If you aren't using the Caselle General Ledger yet, select the Create GL Update Export File checkbox. The system will create an export file that can then be used to post transactions in the non-Caselle General Ledger, and the system will change the status on the exported transactions to updated.

  • No, I do not want to export transactions. Clear the Create GL Update Export File checkbox.

GL posting journal

The GL posting journal is the name of the journal in the General Ledger where transactions will be posted to.

Do you want to post transactions to the default journal?

  • Yes, I want to post transactions to the default journal. This option is recommended.

  • No, I want to post transactions to a different journal. Use the GL Posting Journal drop-down list to select a journal name.

GL posting period

The GL posting period is the period in the General Ledger that the system will create amounts in the selected journal.

Do you want to post transactions to the default posting period?

  • Yes, I want to post transactions to the default period. This option is recommended.

  • No, I want to post transactions to a different period. Use the GL Posting Period drop-down list to select a posting period.

The GL update report prints all of the transactions that will be updated to the General Ledger based on the current date range. None of the transactions will be updated to the General Ledger by printing the GL update report.

Do you want to print a GL update report?

  • Yes, I want to print a GL update report. Select the Print GL Update Report checkbox. The system will print the update report. None of the transactions will be updated to the General Ledger by printing the GL update report.

  • No, I do not print a GL update report. Deselect the Print GL Update Report checkbox.

Update Caselle General Ledger

If the interface to the Caselle General Ledger is turned on, you can use Update Caselle General Ledger to post transactions directly to a posting period in the General Ledger.

Do you want to post transactions to the Caselle General Ledger?

  • Yes, I want to post transactions to the Caselle General Ledger. Select the Update Caselle General Ledger checkbox. The system will post transactions to the Caselle General Ledger, and the system will change the status on the exported transactions to updated.

  • No, I do not want to post transactions the Caselle General Ledger. Clear the Update Caselle General Ledger checkbox.

Update transactions that have already been updated

When you use this routine to post transactions to the General Ledger application, the system flags the transactions as updated, which prevents the transactions from being posted more than once. In the event that the transactions were posted incorrectly, you can use Update Transactions that have already been Updated to reset the updated flag so you can post the transactions again.  

Note: Usually, this option is not selected.

Do you want to update transactions that have already been updated?

  • Yes, I want to update transactions that have already been updated. If you are updating transactions that have already been updated, you will need to remove the transactions that were previously posted to the General Ledger. Then, select the Update Transactions That Have Already Been Updated checkbox.  

  • No, I only want to update transactions that have NOT been updated. Do not select the Update Transactions That Have Already Been Updated checkbox.

 

 

Copyright © 2025 Caselle, Incorporated. All rights reserved.

    • Related Articles

    • Why can't I update transactions to the General Ledger?

      Payroll can update transactions to the General Ledger if General Ledger is installed and the General Ledger interface is set up. Before you get started Install and set up General Ledger. Setting up the General Ledger interface 1. Open Connect Payroll ...
    • Update General Ledger Checklist Basics

      Use this Checklist to update transactions created in Asset Management to a Caselle General Ledger. Perform this task once a year Task General Ledger procedures Update General Ledger. Run the General Ledger Update to update transactions that have been ...
    • How do I update transactions to my General Ledger?

      Run the Update General Ledger routine to post transactions that are created in the Cemetery Management application to an interfaced General Ledger application. For payment-applied transactions, Connect will look at the GL accounts on the related ...
    • 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 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 ...