Skip to main content
Share / Export

Investigate Subledger Variances

When a Summary account shows a material variance, investigate to find when the out-of-balance condition started, then export detail for follow-up in Vista.

Where: Mission Control → Company Tools → Subledger Balancing → Variances
Route: /missioncontrol/tools/subledger-balancing

Mappings and Summary first: Balance AP, AR, and JC to the GL.

Start an investigation​

  1. On Summary, find an account row with a non-zero variance.
  2. Click Investigate for that GL account (disabled when variance is essentially zero).
  3. The workspace switches to Variances and runs a backward scan for the first out-of-balance month, then loads a comparison for that month.

Empty Variances guidance: “Choose a variance above to scan backward and determine where the issue started.”

Read the Variances result​

After the scan finishes:

  • Review the first out-of-balance month and comparison against the requested month.
  • Use Show variances to focus the investigation grid on non-zero variance rows.
  • Open drilldown on a row when you need subledger vs GL line detail.
  • Export a detail workbook for an account or batch when you need offline analysis.

If filters hide the investigated variance, clear or adjust filters so the result is visible again.

Export detail​

From Summary or Variances, use the export action on an account (or batch detail when offered). The download is a workbook for that company/bucket/account/month scope—use it to find the posting or batch that broke the tie.

Open batches related to the variance can be handled in Batch Management.

Close the loop​

  1. Fix the Vista cause (wrong posting, open batch, bad mapping, etc.).
  2. Return to Summary → Refresh Balances.
  3. Confirm the variance is gone (or reduced to an accepted reconciling item).
  4. Continue month-end only when the bucket is acceptable — Close and reopen company ledgers.