Overview: Inserting a trial balance or any of the available financial views (on the Trial Balance screen of your Active Workpapers binder) like Profit & Loss (P&L) or Balance Sheet views into your binder can be streamlined using the 'Export to Worksheet/TB' function.
Please refer to the Glossary for definitions of key terms used in this article.
Steps to export trial balance view to TB/worksheet
Here’s a step-by-step guide on how to use this feature effectively:
Open the binder in Excel Desktop
Start by opening your binder in the Excel Desktop program, ensuring you have the necessary Active Workpapers add-in enabled.
Navigate to the desired trial balance view
In the Active Workpapers side pane, navigate to your desired trial balance view on the Index screen. You can select from:All (this is the full trial balance view including all accounts)
Assets
Liabilities
Equity
Balance Sheet
Profit & Loss (P&L)
Export to worksheet
Right-click on any account in the desired view above and select Export to Worksheet/TB.
This will automatically insert the selected financial view into your binder as an Excel sheet.
Rename the Excel sheet (optional)
Once the Excel sheet is inserted, you can double click it at the bottom and rename it to match your preferred naming convention.
Refresh the add-in
After renaming the sheet, refresh/reload the add-in by right clicking into an empty space in the Active Workpapers taskpane and selecting Refresh. This step ensures the newly inserted sheet is recognised with its updated name.
Link the sheet to a record
To ensure the sheet is included when exporting your binder to PDF, link it to a record in your binder.
To do this, navigate to the General tab in the side pane, select Add Record, then choose Link to Existing Sheet and select the inserted sheet.
This links the inserted sheet, making sure it will appear in any PDF exports.
By following these simple steps, you’ll effectively manage and insert financial data like the Trial Balance, Profit & Loss, or Balance Sheet into your binders.