Inserting a Trial Balance or any of the financial views like Profit & Loss (P&L) or Balance Sheet into your binder can be streamlined using the Export to Worksheet function.
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, 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. You can select from:All (Which is the full Trial Balance view inc. 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.
This will automatically insert the selected financial view into your binder as an Excel sheet.
Optional: Rename the Excel Sheet
Once the Excel sheet is inserted, you can double click it at the bottom and rename it to match your preferred naming convention.
Follow the steps in the video (attached below) to easily rename the sheet.
Refresh the Add-in
After renaming the sheet, refresh/reload the add-in as demonstrated in the video below by right clicking into an empty space in the add-in. This step ensures the newly inserted sheet is recognized 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, P&L, or Balance Sheet into your binders. Please see the video attached below for a demonstration.