Summary
Learn how to export a Caseware classified trial balance so you can create an account grouping in MindBridge.
Export the trial balance
- Open your working papers and go to the Trial Balance tab.
- Click on any field, then use Ctrl+A to select all of the document's contents.
- Use Ctrl+C to copy the content.
- Open a new Excel file.
- Select column 1, row 2, then use Ctrl+V to paste in the contents.
- Delete all columns other than:
- Account Number
- Name
- Map Number
- Leadsheet
- Various Closing Balances
- Match the headers in the Excel document to the working paper columns.
- Zero out revenues and expenses, then roll the net income into retained earnings.
- Save the document.
You can import this file as your opening balance file.
Anything else on your mind? Chat with us or submit a request for further assistance.