Create Filtered GL Report Date Adjustment

Use this task for a Processed GL Batch that has been filtered down to the portion that you want to change the GL Report Date for.  This task is used to handle situations where part of a GL Batch has been posted to the wrong GL Report Month in your General Ledger, The task is available when in the Processed GL Batches GL Batch Option view.

Prerequisites to complete task correctly.

• GL Batch has been processed without error to your general ledger and is in the Processed GL Batches GL Batch Option view.

• The contents of the selected GL Batch is displayed in Detail.  The task will not be available if the Batch Contents is displayed in Summary.

How do you get here?

Accounting Detail General Ledger Tab Create Filtered GL Report Date Adjustment

To create a Filtered GL Report Date Adjustment:

1. Select the GL batches you want to process by checking the boxes in the Select column next to the batches.

2. Display the contents of the selected GL Batch in Detail.

3. If you wish to change the GL Report Date for only part of the selected GL Batch, click the Filter link and the detailed batch contents as necessary.  If you want to change the GL Report Date for the entire GL Batch, skip to the next step.

   • This allows you to filter the entries in the selected batch based on criteria you select.  This option will only appear if you have chosen to view the Detail of the selected GL Batch Contents.

4. Click the Tasks button and select Create Filtered GL Report Date Adjustment

5. The New GL Report Date will default to today’s date, but can be changed.

   • The date entered must between the latest effective date in the selected GL Batches and today’s date.

   • If the GL Report Date does not meet that condition, you will get the following error:

   • • "Please enter a valid GL Report Date.  A valid GL Report Date is between the latest Effective Date in the batch (mm/dd/yy) and the current date."

   • The GL Report Date for all GL Entries and Events in the selected GL Batch in Property Manager will be updated to match this date.

6. Click Finished to create the GL Report Date Adjustment.

   • After this task has been run, 2 new Transaction Rows will have been created for this GL Batch that will be located in the Process With Errors GL Batch Option view:

   • • One Transaction with the original GL Report Date used that reverses the GL Entry in that GL Report Month.

     • One Transaction with the new GL Report Date posting the GL Entry to the correct GL Report Month.

     • Both of these new transactions will be visible on the Accounting Detail > General Ledger tab and on the GL History Report (Reports) showing the GL Entries being reclassed from one GL Report Date to another.

     • • But neither of these transactions will display in a household’s event history found on the Household Detail > Accounting tab.

   • These Transactions/GL Entries can processed to your General Ledger from the Processed with Errors GL Batch Option view (Process Selected Batches) or just Mark as Processed with No Export if you have already made the change directly to your general ledger.

Frequently Asked Questions

• What is the difference between Effective Date and GL Report Date?

Related Topics:

Process Selected Batches

Mark as Processed with No Export