Overview: Both Active Workpapers and Active Ledger & Reporting connect to source accounting platforms (like Xero, MYOB, QBO, etc.) to import account codes.
For firms wishing to standardise their own chart of account codes, this guide outlines how to configure your Active Ledger and Active Workpapers modules to support a firm-specific chart of accounts with firm standard account codes.
Please refer to the Glossary for definitions of key terms used in this article.
Standardising account codes in Active Workpapers
While Active Workpapers supports custom account structures, it requires some upfront configuration and relies on the use of header accounts.
Create a standard chart
For information on how to do this, see the support article: How to create a standard chart of accounts.
Set up matching rules
For information on how to do this, see the support article: How to customise matching rules.
Standardising account codes in Active Ledger & Reporting
Creating your own firm account codes is easier in Active Ledger as you can set up standard accounts in your standard chart.
Create a standard chart
For information on how to do this, see the support article: How to manage the standard chart of accounts.
Set up matching rules
For information on how to do this, see the support article: How to manage firm default matching rules.
Integration with Active Workpapers
Your Active Ledger file can then serve as a source for your Active Workpapers binder, importing your firm’s master chart of accounts along with the underlying balances from the source accounting files. It also supports importing consolidated balances from multiple source files into your firm's standard account code, as shown above.
Here’s what the final product will look like — much cleaner and more streamlined:
Maintaining an Excel trial balance template
For convenience, as an alternative, you can also maintain an Excel trial balance template with firm account codes and reuse that to import a trial balance into any of the Active products for every job.
Please see the support articles below:
Active Workpapers - How to import a trial balance using Excel
Active Ledger & Reporting - How to import a trial balance in a dataset using Excel