Add Workpaper References to workpapers in Word or Excel
You'll need:
- A client with an engagement that includes a trial balance and workpapers inEngagement Manager.
- The Engagement Manager Excel and Word Add-Ins.
- In Engagement Manager, open the engagement, then select theWorkpaperstab.
- Choose the workpaper you want to add a Workpaper Reference to.
- SelectManage, thenEdit.
- In theMicrosoft WordorExceldocument, select the field or cell you want to add a Workpaper Reference to.
- SelectEngagement Manager, thenWorkpaper Referencefrom the toolbar.
- Use the search bar to find the workpaper, then select it.
- SelectOK.noteWorkpaper Reference Roll Forward Issues in DOC FilesIf your Word document is inDOCformat (97-2003) and you insert a workpaper reference using the Engagement Manager toolbar, references won't roll forward correctly.Follow these steps to work around this issue.
- Open up the original source engagement before the roll forward.
- Save a copy or export the document to your local computer. Then, selectSave Asto save it as aDOCXfile.
- Delete theDOCword document from your engagement and insert theDOCXfile in its place.
- Roll forward the engagement again to the new year.