Why a workpaper is showing as Unreconciled

How to investigate and resolve workpapers showing the cross (Unreconciled) status indicator.

A workpaper marked Unreconciled means the variance between the Balance per Workpaper and the Balance per General Ledger (GL) exceeds your firm's variance threshold. This is not necessarily a problem, just a flag for attention.

1. Open the workpaper and identify the variance

Click into the workpaper from the Workpapers Dashboard. The variance amount will be displayed prominently. Compare the Balance per Workpaper against the Balance per GL to confirm the difference.

2. Common causes of variance

  • Missing manual journal: An adjustment or accrual has not yet been posted. Use the + Add New Journal option within the workpaper to post the missing entry.
  • Incorrect Chart of Accounts (CoA) mapping: An account has been mapped to the wrong parent. Return to CoA Mapping and review.
  • Source data missing: A supporting document has not been uploaded. Add it via Supporting Docs in the right-hand panel.
  • Manual entry required: Some workpapers (e.g. Investment Shares (IIS), Investment Fixed Interest (OIN), Hire Purchase Liability (HPL)) require manual data entry. Click Edit to enter the figures.

3. Workpapers with auto-triggered journals

If the workpaper involves an auto-triggered journal (e.g. Stock on Hand, Work in Progress, Entertainment), check that you have validated the auto-triggered figure with the client. The system uses prior-period data and may need updating.

4. Variance threshold review

If the variance is small but still flagging, review your firm's Workpaper Variance Thresholds in Firm Setup. The threshold may need adjustment for that engagement type.