Skip to main content

Using Inter-Entity Reconciliation Worksheets

Hannah Olsson avatar
Written by Hannah Olsson
Updated over a week ago

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

  1. Open the workpaper for the relevant entity.

  2. From the trial balance, select the worksheet for an account that has been included in a reconciliation.

  3. A banner will appear: “Inter-entity worksheet available for this account.”

Step 2: Convert to an Inter-Entity Worksheet

  1. Select Convert in the banner.

  2. The worksheet will change from a standard worksheet to an Inter-Entity Worksheet.

  3. 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.

Did this answer your question?