Skip to main content
All CollectionsWorkpapers & FeaturesTrial BalanceBest Practices
Using the Trial Balance for an efficient workflow
Using the Trial Balance for an efficient workflow
Hannah Olsson avatar
Written by Hannah Olsson
Updated over a week ago

The trial balance in Cimplico Workpapers is designed to help you efficiently manage accounts using features like tabs, filters, sorting and searching. By strategically applying these tools, you can focus on resolving outstanding items and progressing worksheets to their final status of Reviewed or Excluded.

Using Tabs to Manage Workflow

The tabs allow you to focus on accounts by their status: Unprepared, In Progress, Awaiting Review, Reviewed, or Excluded.

  • Goal For Preparers: The goal is to progress accounts from Unprepared or In Progress to Awaiting Review or Excluded.

  • Goal For Reviewers: The goal is to progress accounts from Awaiting Review to a final status of Reviewed or Excluded.

  • Exclude irrelevant accounts early to declutter the trial balance and streamline progress.

Considering What Hasn’t Been Started

The Unprepared tab shows accounts that haven’t been worked on yet. Consider whether these accounts need to be prepared or excluded.

  • Use filters to focus on specific account types or accounts with significant variances.

  • Assign yourself or team members to specific accounts to manage tasks efficiently.

Identifying Why Accounts Are In Progress

Accounts remain in the In Progress tab when certain tasks or issues still need to be addressed. Common reasons include:

  • Internal Comments: Comments left by team members require resolution.

  • Calculations Outstanding: Linked calculation worksheets are incomplete.

  • Client Queries: Outstanding queries with the client need a response.

  • Checklist Items Outstanding: Checklist items for the account remain incomplete.

  • Worksheet Not Reconciling: The account’s default worksheet isn’t reconciling to the ledger figure.

ℹ️ Note: These issues will need to be resolved to progress the account to the next stage.

Using Variance % Filters

The variance percentage filter is a powerful tool for identifying accounts with significant changes from the prior year.

  • Filter by variance % to highlight accounts that have experienced large value jumps.

  • Prioritise these accounts for review to understand and document the reasons behind the changes.

Tracking Assignments

  • Use the Assignee filter to view accounts assigned to you, helping you focus on your responsibilities.

  • Assign yourself specific accounts to create a personalised to-do list or batch tasks into smaller groups.

  • Managers can assign accounts in stages to team members, ensuring a structured approach to the workload.

Did this answer your question?