GL Analysis Routine

Overview

The GL Analysis Routine compares the GL Entry table with the GL Summary table to verify that both contain identical balances by:

• GL Account
• GL Ledger
• Accounting Period

GoldFinch Accounting uses the GL Summary table to generate financial reports. Although GoldFinch automatically keeps the GL Entry and GL Summary tables synchronized during normal processing, you should periodically verify that they remain in sync, especially before month-end closing or before compressing GL Entries.

When to Run GL Analysis

Run the GL Analysis Routine when:

• Preparing to close an accounting period.
• You suspect the GL Entry and GL Summary tables are out of sync.
• Before running the GL Entry Compression routine.
• After restoring data or performing large data imports.
• Anytime you want to verify that all GL Entries have been correctly summarized.

Running the GL Analysis Routine

1. Open GL Analysis

Navigate to:

GL Analysis → Run GL Analysis

2. Select the Accounting Period Range

Specify the Accounting Periods to analyze.

By default:

• From Accounting Period = Current Accounting Period
• To Accounting Period = One year earlier

Adjust the period range as needed.

Recommendation

If you are investigating a reconciliation issue, begin with the earliest Accounting Period where the discrepancy was first identified.

3. Run the Analysis

Click Run GL Analysis.

GoldFinch submits a background batch job that compares the GL Entry and GL Summary tables by:

• GL Account
• GL Ledger
• Accounting Period

When the batch job completes, the results are written to the GL Analysis table.

Reviewing the Results

Open the xDifferent list view.

This view displays only records where:

GL Entry Total ≠ GL Summary Total

If no records appear, the GL Entry and GL Summary tables are fully synchronized.

Resolving Differences

If differences are found:

Step 1 — Run the Daily Adjust Cost Routine

Some General Ledger entries may not yet have been summarized because the Daily Adjust Cost Routine has not completed.

Run the Daily Adjust Cost Routine, then wait for it to finish.

Step 2 — Run GL Analysis Again

After the Daily Adjust Cost Routine completes, rerun the GL Analysis Routine.

Review the xDifferent list view again.

Step 3 — Contact GoldFinch Support

If differences still exist after rerunning both routines, contact GoldFinch Support for assistance.

Best Practices

• Run GL Analysis before every month-end close.
• Run GL Analysis before compressing GL Entries.
• Always resolve differences before generating financial statements or performing year-end procedures.
• In multi-ledger environments, verify results separately for each GL Ledger, since the analysis compares balances by both GL Ledger and Accounting Period.