Once reconciliations are defined at the group or entity level, they can be applied within workpapers. This is done by converting a default worksheet into an Inter-Entity Worksheet (IEW).
Inter-Entity Worksheets let you see both sides of a reconciliation side by side, making it easy to confirm that balances match before progressing the workpaper.
➡️ If you haven’t already created reconciliations, first read Setting up Inter-Entity Reconciliations.
➡️ For an overview of how the feature works, see Inter-Entity Reconciliations Explained.
Step 1: Open the worksheet
Open the workpaper for the relevant entity.
From the trial balance, select the worksheet for an account that has been included in a reconciliation.
A banner will appear: “Inter-entity worksheet available for this account.”
Step 2: Convert to an Inter-Entity Worksheet
Select Convert in the banner.
The worksheet will change from a standard worksheet to an Inter-Entity Worksheet.
The Entries tab will be replaced by an Inter-entity tab.
Step 3: Check dependencies
If the corresponding workpaper for the other entity doesn’t exist, you’ll be prompted to create it.
Workpapers must have the same end date for balances to flow correctly.
Step 4: Review the Inter-Entity tab
The Inter-Entity tab displays:
Reconciliation name
Reconciliation status (Reconciled or Unreconciled)
Accounts list - each account’s name, balance, and worksheet status (e.g. In Progress, Reviewed), laid out exactly as the original reconciliation was set up
💡 Tip: Account names can be selected to open that account's worksheet directly.
Step 5: Progress and manage the worksheet
An Inter-Entity Worksheet can only move to Awaiting Review when the balances reconcile exactly.
If balances change and the reconciliation breaks, the worksheet automatically returns to In Progress.