US Engagement Field Guide 6.0 - Support
Contents
1. cccceceeeececececececeees 39 Consolidating Trial Balances rrrrnrnnnnrnvrnnnnnnrnrvrnnnrnnnnne 39 Consolidating Subsidiary Trial Balances rrrrrrnrnnnrnrr 39 Write Up Trial Balances scciscasccssiectedncvssacedadscuncenndncedoadetecactes 40 Exporting to Tax Software Lrrseasnseesepd Gene 41 Sharing Workp pers Larvuarsaarssvmmmmsimmm ven 42 Shared File ROOMS Luse eanktaidadese 43 Sharing Local File ROOM aaajsserreeeesene 43 Stopping File Room Sharing ccccccsssseseeeeeeeeeseeeeess 43 Editing Workpapers in a Shared File Room 066 43 Synchronize BNGET s2ec ccasschesecvnesscseacacnesesceacctnassseatsactavasedtncesan 44 Synchronize Individual Workpapels ccccseeeeeeeeeeeeeeeees 45 Express Synchronization vass arenaene 45 Binder FIK SS acrana nke SR ETEEN OA SR EENT 46 Creating a Binder Package sscccccessseseeeeseaneeeeeeess 46 Receiving a Binder Package cccsssssecssesseeesseeseeeneees 46 Reviewing WorkpapersS r asrxurnnnnnnnennnnnnnnnnnnnnnnnnnnnnnnnnnnnennnnnnnr 47 Workpaper GO EEE NE 47 Creating a Workpaper or Workpaper Tab Note 47 Responding to Clearing or Deleting a Note 0 47 Workpaper Sign Ol sicencacssccctsnnsectesenacsssocizssadsheonedecneasestsacenensse 48 Lock Unlock Workpapers rranrrerrrannrorrnnnrrrrrnnnnennnnnnnennnnnnenn 49 Freeze Unfreeze WorkpapelrS cccccseececeeeeseee2. CCH a Wolters Kluwer business ProSystem fx Engagement Field Guide 8102 Copyright 2009 CCH INCORPORATED A Wolters Kluwer business All Rights Reserved Material in this publication may not be reproduced or transmitted in any form or by any means without prior written permission Request for that permission should be directed to CCH INCORPORATED 20101 Hamilton Ave Suite 200 Torrance CA 90502 The contents of this publication are believed to be accurate However responsibility cannot be assumed for the information contained herein and the consequences resulting from the use thereof Material in this publication is subject to change without notice This User Manual and the computer software it describes are designed to provide accurate and authoritative information in regard to the subject matter covered They are distributed with the understanding that the publisher is not engaged in rendering legal accounting or other professional services If legal advice or other expert assistance is required the services of a competent professional should be sought ProSystem fx Engagement is a registered trademark of CCH INCORPORATED Windows is a registered trademark of Microsoft Corporation All other brand product or company names are trademarks or registered trademarks of their respective owners Printed in U S A Table of Contents OVEN ae 1 Local FIE ROOM Logaseeseasen seere 2 Client Index VEN
3. a Select the title to use from the Type drop down list Select the tab containing the template Select the template to use and click OK Enter the Name required and Index Click OK ew Workpaper from Scanner 9 Z 0 2 0 8 Select your scanner from the Scanner menu and then click Scan b Adjust any settings as needed and then scan according to your scanner s user guide c Review a thumbnail image of each scanned page and then click Scan More or Finish d Enter the Name required and Index e Click OK Understanding the Trial Balance While trial balances appear to be normal Excel files they actually represent the databases that store all of your data The three types of trial balances are as follows fa Standard single company trial balance Ga Consolidated trial balance Vig Write up trial balance Trial balances created with a version of Engagement prior to 6 0 must be converted to Microsoft SQL Server database files To do this select Start Programs ProSystem fx Engagement Utilities and then click ProSystem fx Engagement Trial Balance Conversion Wizard The wizard instructions will guide you through the conversion process Page 21 Understanding the Trial Balance If you prefer trial balances can be converted when binders are synchronized in ProSystem fx Engagement Note See page 39 Advanced Trial Balance Functions for details on creating consolidated and write up trial balances
4. Opening a Trial Balance Tar Click the Open Trial Balance button from the Binder window This launches Excel allowing you to view the trial balance Note If you have more than one trial balance in your binder a window displays listing all trial balances Select the appropriate one and click OK parts of a Trial Balance There are three areas in the trial balance that allow you to change the way information is displayed E Changing the View You can switch to any view you created in your trial balance from the View drop down menu The columns to the right of the Account and Description columns change based on your settings for that view in the 7B Column Setup Examples of column descriptions are Unadjusted Balance Final Balance and Prior Period Final Balance See page 23 Setting Up Trial Balance Views Default View ki Changing the Grouping List You can switch to any grouping list you created in your trial balance from the Group drop down menu Different groups and sub groups display in the Account Group Summary and Account Sub Group Summary tabs See the following section Changing Worksheet Tabs for details on worksheet tabs Financial Statements Page 22 Using Trial Balance Functions The Account column displays the group or sub group index numbers you created The Description column displays the group or sub group descriptions The Grouping lists are created modified and deleted from the Account Grouping win
5. their underlying concepts you can refer to the following sources Tip of the Day User Guide see Help menu in Engagement Online Help see Help menu in Engagement Technical Support at https prosystemfxsupport tax cchgroup com CCH INCORPORATED a Wolters Kluwer business offers hands on detailed training on the features in this guide Consulting services are also available to assist you in the development of procedures and templates so you can fully utilize ProSystem fx Engagement For more information about Training amp Consulting Services contact our Customer Training department at 310 802 8310 Contacting ProSystem fx Engagement Technical Support Hours 6 a m 5 p m U S Pacific Time Monday through Friday Phone 800 739 9998 Fax 316 612 3405 Product Updates FAQs and more Visit http Tax CCHGroup com Training amp Consulting Call Training Coordinator at 310 802 8310 CCH a Wolters Kluwer business Customer Training Department M S 21 20101 Hamilton Ave Suite 200 Torrance CA 90502 Attention Engagement Training Coordinator Email training coordinator cch com Page 56 Appendix A TB Report Sample Settings Appendix A TB Report Sample Settings The following table includes TB Report settings for common reports used in an engagement You can also customize any report to show the information you need Report Name Account Report Type Format Group ra
6. Balance Functions If you prefer to book standard two sided entries as Client Journal Entries instead of the transaction journals see page 31 Journal Entries You can use either methods to enter Client Journal Entries The information will display in the CJE column of the write up trial balance regardless of which method you use Note See page 32 Reports for information on creating write up reports F xporting to Tax Software Before you can export trial balance data to a supported tax software package you must have grouped your accounts to one of the Account Grouping Lists See page 29 Account Groupings for instructions on grouping accounts Follow these steps to export data to tax software gE 1 Click the Tax Software Interface button in the Binder window 2 Select the software that you will be exporting to from the Tax Software list 3 Verify the appropriate tax Account Grouping List is selected in the Grouping list 4 In Configuration information enter the Tax year Grouping Balance and Employer ID 5 Select the balance you want to export from the Balance list The Export Prior Year box is always checked to export that information Note You must control the import of prior year information in the tax program 6 In Export information Engagement provides default paths and names for the information you need to export to the respective tax vendor however you may need to browse to the appropriate direct
7. Click the Contacts tab to enter contact information Click OK when finished New Binder 3 fe 2 PS 1 Click the New Binder Wizard toolbar button 2 Click Next on the Welcome dialog 3 Select the client folder and click Next 4 Selecta central file room and click Next 5 Select the source for the binder Create binder from template a Select the tab containing the template b Select a template and then click Next m Create blank binder no tabs or workpapers Click Next Create binder from existing binder in your local file room a Select client folder that contains the binder b Select the binder to use and then click Next 6 Enter the general properties of the binder and then click Next 7 Enter period information for the binder and then click Next Page 18 Adding Items Binder Window 8 If you selected a template or existing binder with Knowledge Coach workpapers the Knowledge Coach options page displays Select the needed options and then click Next 9 Assign additional teams or staff to the binder by clicking the Assign buttons 10 Click Finish 11 Review the New Binder Summary Report and click Create to create the binder Adding Items Binder Window New Tab 1 In the Binder Index right click where you want the new tab 2 Select New Tab from the list 3 Enter the Name required and Index 4 Click OK N ew Workpaper 1 Right click the tab where you want the new work
8. Journal Entries and Adjusting Journal Entries are already selected 4 Click OK The report is stored in the Unfiled Workpapers tab of your Engagement binder Note See page 39 Advanced Trial Balance Functions for instructions on creating write up trial balances Page 35 Using Trial Balance Functions Linking to the Trial Balance Name and Date Links Name and date links enable you to insert information about the client firm binder workpaper or dates related to the engagement Name information comes from the Properties window of the client firm binder or workpaper Date links are calculated from the Periods and Dates tabs in the Binder Properties window To insert name or date functions do the following 1 Open the workpaper 2 Do one of the following m In Excel click the cell where you want to insert the link m In Word insert the cursor where you want to insert the link or select the text that you want to replace with a Name or Date link 3 Click the Name Functions or Date Functions button on the Engagement toolbar A menu of name or date functions displays 4 Select the name or date option you want to insert Linking Trial Balance Data This section explains the two methods for linking trial balance data Copying and Pasting TB Links 1 Open both the trial balance and the Excel or Word workpaper you want to link 2 Activate the trial balance in Excel by selecting it from the Window menu and
9. enter information for each new account Added accounts need to be grouped To modify account information click in the cell you want to modify and enter the change m To delete an account click the account row and then click Delete Account Deleted accounts remove the prior year information Te Edit Mode Use TB Edit Mode to manually enter current period balances or to modify prior period amounts Click the TB Edit Mode button when the trial balance is open to turn this mode on or off Account Groupings 1 Select Account Groupings from the Trial Balance menu in the Binder window 2 Select the trial balance for which you want to group accounts from the Trial Balance menu 3 Select the Account Grouping List for which you would like to group the accounts from the Grouping List Page 29 Using Trial Balance Functions 4 10 Page 30 Add groups or sub groups by right clicking the Groups and Sub groups window Note You also can add groups or sub groups by clicking Advanced below the window Click Close when finished You can assign Account and Ratio Classifications when a group or sub group is created or you can click Advanced to edit the group or sub group These classifications are used to break down balances and calculate net income or loss for the period These classifications may also be used for TB Links Note If Account and Ratio Classifications are assigned the Quickview option displays the balanc
10. pane Responding to Clearing or Deleting a Note You can use the Notes pane in the Binder window or the Notes Summary View to keep track of which notes require response clearing or deletion Page 47 Reviewing Workpapers To clear delete or respond to a note do the following 1 Click the Notes Summary View tab in the Binder window 2 Right click a note and select one of the following Respond to Note allows you to reply Enter a response and then click OK to save the text Clear Note crosses out content and any replies A record of the note remains in the Binder View and Notes Summary View The status changes to cleared Delete Note erases the note Workpaper Sign Off You can sign off workpapers as the Preparer and or as a Reviewer A workpaper can have multiple Preparers and Reviewers To sign off a workpaper do the following Ei 1 Select the workpaper in the Binder window and click the Sign Off Workpaper button Select your name from the Current User menu The Date defaults to today s date Select a different date if necessary 4 Add or update your sign off signature by clicking the plus sign in the Preparer field or in one of the Reviewer fields Click the minus sign to remove your sign off 5 Click OK to save your changes You can manage the sign off status of engagement workpapers by selecting the Sign Off Summary View tab Page 48 Reviewing Workpapers ock Unlock Workpap
11. rrrrnnrrnrrvrrrnnnrrrvnvrrnnnrrnrrnnnnn 23 Converting amp Importing Trial Balance Data rrrrnnnrrrvrnnnnn 24 Converting Trial Balance Data from ProSystem fx Write Up or ProSystem fx Trial BalanCe 0ccc 0cccccesssssoceccecssneseecestenae ess 24 Converting Trial Balance Data from ATB for Windows GoSystem Audit or an ASCII Text File cee eeceecceece eee eeeeeneeneees 24 Importing Data from CaseWare rrrrrnrnnnnnrnnvnrnrnnnrrrvrnnnnn 26 Importing TB Data From an Excel File rrrrrnnrrrrnrnnrrrnnnn 27 Importing TB Data From An Engagement Trial Balance 28 Checking for Changes to the Source Trial Balance 28 Charl OF ACCOUNTS Laveste 29 PENN 29 Account Groupings ua sseserrSereNGereGNenK 29 Joumal ENVIES erasanda ienne ERARA En ED 31 Recording Transactions in Write Up Trial Balances 31 FN vr 32 JER 32 E TR DONO prere ano E EEA 32 Consolidated Reports cccccsesccccsssceeeceeeeeecseneeeeseeaees 34 Write Up REDOING sxceccu Avewencnocentenedetiseaeiesnaveiiinecsdksbuetderensaunss 35 Linking to the Trial Balance rrrrornnnnvrnrnnnornvnnnnernvnnnevnvnnnnere 36 Name and Date Links scescinsstvecssnieimassiansdctiminadaisaniestuanciess 36 Linking Trial Balance Data Luueamsansenmnesmitsunvidmsmnue 36 Analyzing a TB Link Formula siiiccicamsertsensuversdcenaasencorsanivess 38 Drill Down to Trial Balance Accounts rarrrvnnnnrrvrnrnnerennnn 38 Advanced Trial Balance Functions
12. see the CFR tab The CFR tab contains a list of all CFRs set up for the firm The Staff tab lists all staff members and the Buddy List shows the staff members you have added to your Buddy List Page 2 Local File Room F gagement Today View Note Engagement Today is not available from a shared file room Engagement Today displays user level diagnostic information that summarizes key statistics regarding the binders in your local file room Engagement Today also displays the Tip of the Day i Eile Edit View Tools Window Help ge Engageme nt Today for Admin Default Tip of the Day gt None 1 2 Changing Properties m To change the settings of most items in Engagement right click on the icon and select Properties Other Highlights gt Binders with checked out workpapers gt Audit 1 gt Bankruptcy 0 gt Business Yaluation 0 gt Collateral Review 0 gt Notice to Reader 0 gt Past due binders gt Correspondence 0 gt Binders within 15 days of doc completion date gt Litigation 0 gt Binders past doc completion date gt Other 0 gt Permanent 0 gt Review 0 gt Tax Accrual 0 I Display as the default view in the File Room gt Tax Return 0 gt Binders with open notes to me gt Binders not synchronized in a week gt Binders within 15 days of due date The Engagement Today view displays five panes 1 2 My Recent Binders Displays links to the last fou
13. vrede 2 Engagement Today VIEW saaciscicsianssinassnntanetioienavsanianiataninieneataas 3 Bind er WIN GOW oi isssieccsassscisasnsduscaavanccbaweceuiduasvesubasaceecexecansceametanions 4 Binder EEE ENE SN 4 Notes Summary VEN eiinicsececdcontarntenccsmebvoreotomarantntecmtberenaeties 7 SIGN OFF Summary VIEW Lenne 8 Current Editor VIEW veccszcsvnccosdaniaidedaresiannnddbicdiwaianectosbadbashientetiet 9 Live Editor EE 9 Engagement Toolbar File Room rrnnnnnvnnnnnnnvrnnnnnnvrnnnnnevennnnr 10 Engagement Toolbar Binder Window anrxvrvvnnnnvrnnnunvrnnnnn 11 Engagement Toolbars in Excel and Word rrrnvnnnnvrnnnvnvvnnnnnn 14 Engagement in Office 2007 vsccccsitcscidvenrdsne ninecorcacewinssatesceeadacntest 14 Engagement Toolbar Excel for Office 2003 rrrrrrrrnnrnvenn 14 Engagement Toolbar Word for Office 2003 16 Adding Items File ROOM resnnnvrnnnnnvevnnnnnernnnnnnennnnnnernnnnnnrrnnnnr 18 New Client Folder ER 18 Now BINGOT senon era aei SAER ARESA 18 Adding Items Binder Window rnaxvvvnnvnvrnnnnnnvnnnnnnvrnnnnnnvennnnr 19 NE TB enirecten r 19 NEW VVOIKD ADE occ ansees keine meier 19 Understanding the Trial Balance rrnnnnnnvrnnnnnnrnnnnnnernnnnnnvnnnnnr 21 Opening Trial Balance cccrcsscsucecscseusvancesecsesieveexestenieecarceas 22 Parts ofa Mal Balante Lue 22 Using Trial Balance FUNcCtions ccccceeseeeeeeeeeeeeeeeseeeeeeeeees 23 Setting up Trial Balance Views
14. workpaper so that links are not refreshed Unfreeze Links Unfreezes Engagement links for the selected workpaper Create Workpaper Note Creates a note for the selected workpaper Sign Off Workpaper Signs off the selected workpaper Tax Software Interface Exports data to tax packages Binder View Displays binder contents and workpaper status Notes Summary View Displays workpaper and workpaper tab notes by type Sign Off Summary View Displays workpapers sorted by level of review Current Editor View Live Editor View Displays workpapers sorted by current editor or live editor Page 13 Engagement Toolbars in Excel and Word Engagement Toolbars in Excel and Word F gagement in Office 2007 Engagement takes advantage of the new Ribbon interface in Excel and Word 2007 The Engagement tab displays all of the functions you need to complete workpaper tasks The Workflow group of the Engagement tab includes the six most recently used tickmarks F gagement Toolbar Excel for Office 2003 The Engagement toolbar that displays in Microsoft Excel for Office 2003 includes the following buttons Mame Functions Date Functions v is DAN 8 Page 14 Name Functions Inserts links to Client Engagement and Firm information Date Functions Inserts links to Current and Prior date information Refresh Refreshes all links in the workpaper including Name Date and Trial Balance Links Copy TB Link Lin
15. Journal Entries Report Yel 3220 Reclassifying Journal Entries Report g 3230 Federal Tax Journal Entries Report a 3240 State Tax Journal Entries Report v g 3250 Proposed JE Report Mal R A 74 0 Peelimeise mere Malorne e lam mb Guidance ive Editor View If you are viewing a shared local file room the Live Editor View tab is available The Live Editor View displays all the staff members who are currently working on a workpaper in the binder Under each staff member is a list of the workpapers he or she is working on Any workpapers that are not being worked on are listed in the Unassigned section Page 9 Engagement Toolbar File Room following buttons Page 10 Engagement Toolbar File Room The Engagement toolbar in the File Room window includes the Reg I Y E SG b amp b br duv gt B New Client Creates a new client folder New Binder Wizard Creates a new binder Assign Binder Staff Adds team members to a binder Open Opens the selected item Open Trial Balance Opens the trial balance in a selected binder Cut Cuts item s to the clipboard Copy Copies item s to the clipboard Paste Pastes item s from the clipboard Expand All Expands the entire tree Collapse All Collapses the entire tree Properties Displays properties of a selected item Refresh Refreshes the local file room or central file room Create Binder Package Creates a single compressed file of a bind
16. ave been set up When the team is attached to a peer to peer network in the field its members can share and distribute binders directly with each other When you log in from the Field each staff member assigned to binders in your local file room displays When you are not on a network or you need to email a binder to a staff member you do not synchronize to the central file room or to another staff member s local file room See page 46 Binder Packages for further details Page 42 Sharing Workpapers Ghared File Rooms Shared local file rooms allow multiple Engagement users to work with workpapers in the same binder without synchronizing with a central file room checking out workpapers or assigning workpapers To work with shared file rooms the option must be enabled for your firm in Administrator and you must belong to a staff group that allows sharing of local file rooms A Host selects to share his or her local file room and then other users can log in to the shared file room Users can open any workpaper in the Host s file room as long as the Host is the Current Editor Sharing a Local File Room 1 Log in to Engagement as either Office or Field 2 Right click within the file room frame 3 Select Share File Room Stopping File Room Sharing 1 Log in to Engagement as either Office or Field 2 Right click within the file room frame 3 Select Stop Sharing File Room Editing Workpapers in a Shared File Room W
17. bbreviation you want for the column heading Select a grouping from the Grouping List field Page 39 Using Trial Balance Functions 8 9 10 11 12 13 14 Select Overriding List if you want to take precedence over the trial balance s when there are conflicts with the description of the grouping basis or grouping codes Select the balance type to consolidate in the Balance field To add more subsidiaries click Add and repeat steps 5 through 9 Select the consolidation basis based on groups sub groups or account detail Select how you would like numbers to be rounded from the Rounding list Select the Number of Prior Periods you want to gather during consolidation Click OK to consolidate Note See page 32 Reports for instructions on creating consolidated reports See page 31 Journal Entries for instructions on eliminating journal entries Write Up Trial Balances Write up trial balances allow you to enter transactions into write up journals or book client journal entries To create a write up trial balance follow these steps 1 mg gt EE Ed Page 40 Select the tab to insert the trial balance into from the Binder window Click the New Trial Balance toolbar button Click the Write Up tab Select the Write Up template Click OK to display the Workpaper Properties dialog Complete the Index and Name fields Click OK to create the write up trial balance Using Trial
18. ceholder Creates a name and index number for a workpaper that will be added at a later date from a file or scanned document New Knowledge Tools Workpaper Creates a new workpaper from the Knowledge Tools Workpaper Templates Requires installation of Knowledge Tools titles New Knowledge Coach Workpaper Creates a new workpaper from the Knowledge Coach Workpaper Templates Requires installation of Knowledge Coach titles New CCH Workpaper Creates a new workpaper from the CCH Workpaper Templates New Workpaper from Scanner Creates a new workpaper from a TWAIN compliant scanner Open Opens the selected item Open Trial Balance Opens the trial balance If there is more than one trial balance a list appears for you to select from Print Prints the selected workpaper or report Cut Cuts item s to the clipboard Copy Copies item s to the clipboard Paste Pastes item s from the clipboard Properties Displays properties of a selected item be p g hi is Pi mE tE Engagement Toolbar Binder Window Expand All Expands Binder Views to show all workpapers Collapse All Collapses Binder Views to hide all workpapers Refresh Refreshes and re sorts Binder tabs and workpapers Publish Workpaper Publishes a workpaper to convert formulas to values Lock Workpaper Locks a workpaper as read only Unlock Workpaper Unlocks a workpaper Freeze Links Freezes Engagement links in the selected
19. data Note If you have previously imported data from the source file the mport status based on last binder synchronization section displays the date and time of the last import the date and time the source binder was last synchronized and the status of the source binder Click Check for Source TB Changes to determine whether any balance changes exist between the source trial balance and the target trial balance Click OK Checking for Changes to the Source Trial Balance To check for balance differences between a source Engagement trial balance and a target Engagement trial balance after importing data do the following 1 Page 28 From the Binder window select Trial Balance Check for Source TB Changes If more than one trial balance is in the binder select the target trial balance and click OK If there are differences between the source file and the target file the mport from Engagement TB Log File displays Only accounts with balance differences display in the log file Using Trial Balance Functions Chart of Accounts Use the Chart of Accounts window to add modify and delete accounts 1 Select Chart of Accounts from the Trial Balance menu in the Binder window 2 Select the trial balance from the Trial Balance field Select the balance type from the lower field of the Period and Balance type group 4 Do any of the following as needed m To add an account to a trial balance click Add Account and
20. dio columns button included Leadsheet s Include selected Detail e PY Final Check boxes as CY Unadjusted needed CY AJE CY Final Working Trial Include current Detail PY Final Balance and future Combine CY Unadjusted Classified Groups CY AJE report CY Final Preliminary Include current Summary by PY Final Analytical Review and future Group or CY Unadjusted Sub group Variance Include Net EE ER Income Final Analytical Include current Summary by e PY Final Review and future Group or CY Final Sub group Variance Include Net re Income Budget to Actual Include selected Detail e CY Budget Click Select All CY Final Variance e Variance Book to Tax Include current Detail e CY Adjusted and future Combine CY FIJE Classified Groups CY Tax report Page 57 Notes Notes Page 58
21. dow See page 29 Account Groupings for further details Changing Worksheet Tabs You can navigate among worksheets using the following tabs Account Detail Account Group Summary a Account Sub Group Summary Fi Account Detail This tab displays the trial balance by account number Subtotaling cannot be performed on this worksheet You can manually add subtotals to TB Reports generated from the trial balance Account Group Summary and Account Sub Group Summary These tabs display the totals for each group or sub group in the Account Grouping window Change the Grouping List from the Group toolbar drop down to change which groups or sub groups you want displayed Using Trial Balance Functions Setting up Trial Balance Views 1 Select TB Column Setup from the Trial Balance menu in the Binder window In the Trial Balance field select the trial balance with the columns you want to modify In the View field select the view with the column setup you want to modify Note Click Options to create a new view In the Available Columns field select the period that contains the columns you want to select from Available columns are on the left side click the right pointing arrow to add the column to your view Page 23 Using Trial Balance Functions 5 To add a variance column click Add Variance and select the appropriate information in the Column Properties section 6 Click Close to save your changes Conve
22. e columns by clicking the gray column header bar and selecting the appropriate column description from the menu that appears Do this for all columns to import Do not define the header for those you do not want to import Choose Append or Overwrite Select Append to add your current data to the existing trial balance Select Overwrite to destroy all existing account data and journal entries The accounts must be regrouped Overwrite also unassigns all previous group and sub groupings Correct duplicated account numbers invalid accounts and blank fields highlighted during import To round balances select the place to round the account balances to in the Round Balance to Nearest field and complete the Select Rounding Account field Click Next then Yes and then OK to continue Review the statistical information and click OK Page 27 Using Trial Balance Functions Importing TB Data From An Engagement Trial Balance 1 8 Open the trial balance to import data to Select Engagement Import from Engagement TB Select the client name binder and trial balance from which you want to import information If necessary check the Import current period balance box and select the current period balance type to import If necessary check the Import prior period balance box and select the prior period balance type to import If you selected to import current or prior period information select whether to append or overwrite the
23. e in the Report Name Guide field 8 Select from the following options as needed Hide empty groups and sub groups and Hide accounts with zero balances Hides indicated items m Print as Black and White Sets the default print settings to black and white Show WIP Ref Columns Displays workpaper references created in the trial balance Include sum of account groups Subtotals the groups within a classified report m Include net income Displays net income amount on an unclassified report Note Net income is always included on classified reports Page 33 Using Trial Balance Functions 9 Click Format to select which trial balance columns you want to include in the report m Drag columns from left to right to add them Drag columns from right to left to remove them m Add Variance columns as needed 10 Click OK to save your column setup 11 Click OK to create the reports The reports are stored in the Unfiled Workpapers tab in your Engagement binder Notes E See Appendix A for sample TB Report Settings E To modify an existing report setup open the report and then select Properties from the Engagement menu Make your changes to the setup and then click OK to save them Consolidated Reports 1 Open the consolidated trial balance 2 From the Engagement menu select Create Reports Consolidated Reports 3 Select report options as desired These options are the same as those for a regular trial ba
24. ed Workpapers To open a referenced workpaper do the following 1 Open the Excel Word or Adobe Acrobat workpaper 2 Click in the cell containing the reference Excel or select the workpaper reference Word or Acrobat to open 3 Click the Open WP Reference button Publishing Workpapers To send someone an electronic copy of a Word or Excel workpaper you should publish the workpaper A published workpaper is a copy of a workpaper in which the formulas i e trial balance links have been converted to values This allows you to share the workpaper with people who do not have access to the trial balance database To publish a workpaper follow these steps 1 Select the workpaper to publish in the Binder window E 2 Click the Publish Workpaper button A copy of the workpaper is filed in the Published Workpapers tab in the Binder window The original name of the workpaper now has Published appended to the end All of the formulas such as dates names and amounts have been converted to values This published workpaper will not be updated because the formulas no longer exist Page 51 Other Common Features Other Common Features Creating Templates This section includes procedures for creating the following templates E Trial Balance Workpaper Account Groupings Print Groups Tickmarks TB Links Trial Balance Templates If there is a trial balance that has a format you use frequently you can save it as a templa
25. ed file room The staff member who has this workpaper open If no staff member has the workpaper open then lt Available gt displays if the file room s host is current editor of the workpaper lt Unavailable gt displays if the host is not the current editor Assigned To The team member who the current editor has assigned the workpaper to prior to synchronizing Does not display in shared file rooms Binder Window 3 Notes Pane When a workpaper or tab with a note is selected in the Binder window information about the following displays subject number of responses who it is from and assigned to the date created who cleared the note and the date cleared Note If Knowledge Coach is installed a Diagnostic pane also displays above the Notes pane Notes Summary View The Notes Summary View displays all of the notes that exist in the binder The Notes are broken down into three types Team Notes Open Items and Notes for Next Period i File Edit View Tools Trial Balance Workpaper Help Shortcuts re Notes HEr v Status From To Team Notes 4 oae No Interest on Loan 2 Cleared All od Open Items Workpapers re Reserve for Uncollectible Accounts Open i gt RE Reserve for Uncollectible Accounts re Cash Confirmations Open Binder Sn Notes for Next Period JG ed Notes Summary View Workpaper 4515 Notes Receivable Type Team Note Date Created 3 5 200 el f From To All Subject No Interes
26. emplate and click Save Note Knowledge Coach workpapers cannot be saved as templates Instead you can copy Knowledge Coach workpapers from one binder to another Account Grouping Templates To use an account grouping in another trial balance you can follow these steps to save an account grouping as a template A gt m e p Select Trial Balance Account Groupings from the Binder window In the Trial Balance and Grouping List field click the Options button The Grouping List Options dialog displays Select a grouping from the grouping lists shown Click Export Browse for the path and enter a file name Click Save to create the template and then click Close to close the Grouping List Options dialog Page 53 Other Common Features Print Group Templates To print a group of workpapers and save a print group as a template follow these steps 1 Select File Print Group in the Binder window The Print Group dialog displays Select the workpapers in the print group from the left side Click Save Print Group 4 Enter a name in the File name field and click Save Tickmark Templates Do the following to share tickmarks with other team members and save them as templates 1 Open an Excel Word or Adobe Acrobat workpaper 2 Select Engagement Tickmark Tickmark Definition 3 Click Export 4 Browse for the path and click Save For more information see page 49 Using the Tickmark Definition List Saving TB Lin
27. er Receive Binder Package Receives a binder package Synchronize Binder Opens the Synchronize Binder Wizard ker bb All Client Groups Engagement Toolbar Binder Window Express Synchronization Automatically synchronizes the binder to the central file room without opening the Synchronize Binder Wizard Tax Software Interface Exports trial balance data to tax vendors Finalize Binder Opens the Finalize Binder Wizard for the selected binder Roll Forward Opens the Roll Forward Wizard for the selected binder Client Inquiry Opens the ProSystem fx Practice Client Inquiry Module Engagement Today Displays the Engagement Today view Client Index Displays the Client Index view Client Group Filter Filters the clients in the file room by client group Engagement Toolbar Binder Window The Engagement toolbar displayed in the Binder window has the following buttons i pe Ed New Tab Creates a new workpaper tab New Workpaper from Template Creates a new workpaper from predefined templates New Workpaper from File Inserts a new workpaper from an Excel Word or other file type into a binder New Trial Balance Creates a new trial balance Page 11 Engagement Toolbar Binder Window Page 12 y LW a GE i i oe luli Lh LI pt New Manual Workpaper Creates a workpaper to serve as a placeholder for a physical workpaper not inserted into the Binder New Pla
28. ers After the workpaper has been reviewed and signed off you may want to lock the workpaper A workpaper that is locked is read only Links will continue to update provided they are not frozen To lock or unlock a workpaper follow these steps 1 Select the workpaper you want to lock or unlock from the Binder window a 2 Click the Lock Workpaper or Unlock Workpaper button When the workpaper is locked the Lock symbol appears Ga The workpaper is now a read only file f reeze U nfreeze Workpapers There may be times when you want to freeze a workpaper Engagement links such as name and date links and TB links in a workpaper that is frozen are not updated if changes are made to the trial balance To freeze or unfreeze a workpaper follow these steps 1 Select the workpaper in the Binder window 2 Click Freeze Engagement Links represented by a broken chain or Unfreeze Engagement Links represented by a zy solid chain Note If you publish a workpaper with frozen links the published workpaper will contain the values of the links when frozen Tickmarks Using the Tickmark Definition List The tickmark definition list contains the tickmark symbols images and descriptions To use the tickmark definition list follow these steps 1 Open a report or workpaper in Excel Word or Adobe Acrobat 2 Select Engagement Tickmark Tickmark Definition Page 49 Reviewing Workpapers To add your own tickmarks to th
29. es broken down by assets liabilities and equity revenue expenses and net income Select Quickview from the Trial Balance menu in the Binder window Select the account s you want to group from the Account and Description columns displayed on the left Drag the account s to the group or sub group folders on the right Continue this process until all the accounts are grouped Note Use the Account and Description Filters fields to show only the accounts you want to group Use a question mark as a place holder and an asterisk as a wildcard For example to display all accounts with 5 as the second character such as 1500 01 1000 type 5 Click the Options button to administer your Grouping Lists You can create new groups delete or rename existing groups and export groups from this window You can also access standard Tax Line Grouping lists by clicking Import Click Close when you are finished administering your Grouping Lists Click Close when you are finished grouping accounts Using Trial Balance Functions Journal Entries 1 Select Journal Entry Summary from the Trial Balance menu in the Binder window 2 From the Trial Balance drop down list select the trial balance to which to post the journal entry In the Type pane select the type of entry 4 Click New to open the Journal Entry Detail window Enter the journal entry number description and W P reference in the appropriate fields 6 Select the accoun
30. g Open the Excel or Word workpaper 2 Do one of the following m In Excel click the cell with the linked formula m In Word select the linked field ge 3 Click the Drill Down TB Link button 4 Click Close Page 38 Using Trial Balance Functions Advanced Trial Balance Functions Consolidating Trial Balances Consolidations occur at the trial balance level within one Engagement binder You will set up a trial balance for each subsidiary and then consolidate them into a consolidated trial balance To create a consolidated trial balance do the following 1 75 7 Aa PR wn Select the tab you want to insert the trial balance into from the Binder window Click the New Trial Balance button from the Binder window Click the Consolidated tab Select the Consolidated Trial Balance 2 Year template Click OK Complete the Index and Name fields in the Workpaper Properties dialog Click OK to create the trial balance Consolidating Subsidiary Trial Balances To consolidate subsidiary trial balances into a blank consolidated trial balance do the following 1 a 2 a MR Open the consolidated trial balance Click the Consolidate button on the Engagement toolbar From the Consolidated Trial Balance list select the trial balance you want to hold the consolidated information Click the Add button to add a subsidiary trial balance Select the trial balance from the Trial Balance list Type the a
31. is list click Add 4 Type the tickmark name and description Browse to a 16 color 16 x 16 pixel bitmap picture and click Open You are returned to the Tickmark Definition dialog and your image appears in the left hand column 5 Click Close Note To delete a tickmark select the tickmark and click Delete Inserting Tickmarks To insert a tickmark symbol follow these steps 1 Open an Excel Word or Adobe Acrobat workpaper 2 Click the Tickmark Toolbar button 3 Follow these steps if you are working with Excel or Word a Click where you want the tickmark to be placed b Click the tickmark symbol in the tickmark toolbar Follow these steps if you are working with Acrobat a Click the tickmark symbol in the tickmark toolbar b Click where you want the tickmark to be placed Workpaper Reference Links Inserting Workpaper Reference Links 1 Open an Excel Word or Adobe Acrobat workpaper 2 Follow these steps if you are working with Excel or Word a Click in the cell Excel or place the cursor in the document Word where you want to insert the workpaper reference link E b Click the Insert WP Reference button Page 50 Reviewing Workpapers Follow these steps if you are working with Acrobat a Click the Insert WP Reference button b Click the location in the workpaper where you want the workpaper reference to be placed Select the workpaper to reference Click Insert Click Close Opening Referenc
32. ith the extension ac are accepted Compressed files with the extension ac_ are not accepted Select the CaseWare entity In the Chart of accounts information section select the period sequence the current CaseWare period to import into Engagement and the CaseWare current period balance type Select whether to append to or overwrite the existing data in the Engagement trial balance data Select the appropriate rounding options as necessary Select one of the following m convert all groupings m convert all and map to one Engagement grouping m map to one Engagement grouping If you are mapping groupings select the CaseWare grouping to map from on the left and select the ProSystem fx Engagement grouping to map to on the right Click Finish Using Trial Balance Functions Importing TB Data From an Excel File 1 10 11 12 Open the trial balance Open the Excel file containing your trial balance data Do the following to prepare the content for import m Organize the data so that there are no blank rows in the data range Remove any of the following characters from the account number and balance columns 342 m Verify that the total of each balance column nets to zero Select the range of data excluding any column headers or balance checks and select Edit Copy in Excel Switch to the trial balance by selecting it from the window menu in Excel Click the Paste TB Import button Define th
33. k Formulas To save TB Link formulas e g complex ratios as templates for other workpapers follow these steps To 1 Build a TB Link formula using the Insert TB Link function See page 36 Linking to the Trial Balance In the Insert TB Link window click Save Type a name and description for your saved TB Link formula 4 Click Close Page 54 Other Common Features Renaming Items Throughout the system you can rename items by selecting the items you want to rename and clicking on the Properties toolbar button Make your changes and click OK to save them Deleting Items Warning When a Knowledge Coach workpaper is deleted it is removed permanently It is not sent to the Trash folder and cannot be restored E In the File Room Select the item s to delete and press DEL These items are permanently deleted In the Binder window Select the item s to delete and press DEL The items are now in the Trash Notes mE To restore an item deleted from the Binder Window right click the Trash icon and select Restore All or right click on individual workpapers and select Restore E Depending on the settings in Administrator upon closing a binder Engagement will keep the items in the trash prompt you to delete the items in the trash or automatically delete the items in the trash Page 55 Getting More Information Getting More Information For more information on these functions and to better understand
34. ks data from your trial balance to your workpapers or financials This information updates with trial balance changes Paste TB Link Links data from your trial balance to your workpapers or financials This information updates with trial balance changes Insert TB Link Creates a link from the trial balance without opening the trial balance Drill Down TB Link Drills down to the accounts included in the linked formula Create TB Report Creates reports based on your trial balance data See APPENDIX A for sample report settings di d W i i Ruik Link Engagement Toolbars in Excel and Word JE Summary Displays current journal entries by type You can add modify or delete journal entries from this window Account Groupings Opens the Account Groupings window TB Column Setup Opens the TB Column Setup window where you can modify the columns displayed in the trial balance Paste TB Import Imports data directly from Excel into the trial balance TB Edit Mode When toggled on allows you to make changes to the trial balance directly Write Up Journal Entry Organizes the transaction data in journals Consolidate Consolidates data from single company trial balances into a consolidated trial balance Tickmark Toolbar Displays the tickmark toolbar Insert Workpaper Reference Inserts a reference link to another workpaper in the binder Open Workpaper Reference Opens the referenced workpape
35. lance 4 Click OK to create the report The report is stored in the Unfiled Workpapers tab of your Engagement binder Note See page 39 Advanced Trial Balance Functions for instructions on creating consolidated trial balances Page 34 Using Trial Balance Functions Write Up Reports Engagement provides the following three write up reports Write Up Detail Shows detailed entries from a selected journal The report columns are the same as the journal columns G L Current and G L YTD Show the accounts in the trial balance their beginning balance transaction amounts and ending balance for either the current or YTD period whichever you select Creating the Write Up Detail Report 1 Select Create Reports Write Up Reports Write Up Detail Report from the Engagement menu Select the trial balance from the list Select the specific write up journals you want to create 4 Click OK to create The report is stored in the Unfiled Workpapers tab in your Engagement binder Creating G L Current and G L YTD Reports 1 Select Create Reports Write Up Report from the Engagement menu 2 Select G L Current Report or G L YTD Report The Select Journal Entry dialog displays Important If you select G L YTD Report for a non annual binder the Select Journal Entry dialog does not display The report is created with only write up journal entries 3 Select the types of journal entries to include in the report By default Client
36. led IntelliConnect Accounting Research Manager the CCH Tax Research Network and FAQs among other links Page 4 Binder Window 2 Binder Index Pane The Binder Index Pane includes the following folders k r iy Binder The Binder name displays beside one of the following images based on the Document Completion Date tE The Document Completion Date is not approaching and is not past due kg The Document Completion Date is approaching 4 i The Document Completion Date is past due a Note If you are Current Editor of a binder a current editor designation arrow displays on top of the appropriate binder icon above Unfiled Workpapers This folder stores workpapers that have not been filed yet Reports generated by ProSystem fx Engagement originally appear here You can then move each report to the desired workpaper tab section Conflicts This folder stores workpapers in conflict after synchronization or from binder packages that have been received Incompatible Workpapers This folder displays if you have Knowledge Coach installed It stores Knowledge Coach workpapers that could not be filed in the active binder because the title version of the workpaper is not compatible with the title version of the binder Published Workpapers This folder stores copies of Word or Excel workpapers where the formulas e g trial balance links have been automatically converted to values Trash This folder con
37. m the Engagement menu select Create Reports Journal Entry Reports Select the trial balance from the Trial Balance list 4 Select the box for each type of JE Report to create Click OK The reports are placed in the Unfiled Workpapers tab in your Engagement binder You can rename them and drag them to the appropriate tabs as needed TB Reports 1 Open the trial balance Click the Create TB Report toolbar button Select the trial balance from the Trial Balance list 4 Select the Grouping List to generate the report from Page 32 Using Trial Balance Functions 5 Choose one of the following in the Account Groups section m Include selected includes only the groups you select m Include current and future includes all groups currently in the selected grouping list and automatically adds any groups that are created in the future Note If you select nclude current and future you can select Classified Report to create a report organized by the account and ratio classifications 6 In the Report Type field select the level of detail to display Summary Groups Summarizes your report at the group level Summary Sub Groups Summarizes your report at the sub group level Detail Displays all charts of accounts organized into the groups and sub groups If you select Combine Groups the information generates in one report Otherwise a separate report is generated for each selected group 7 Enter a nam
38. orking with workpapers in a shared file room is similar to working in your own local file room When you open a binder in the Host s local file room the Binder View displays The Live Editor column displays the current status of each workpaper Page 43 Sharing Workpapers The following statuses are available mE User Name The user whose name displays is currently the Live Editor of the workpaper You can view a read only copy of the workpaper until the Live Editor closes it lt Available gt The local file room s Host is the Current Editor of the workpaper and no other users are currently working on the workpaper The workpapers are available for you to open and edit E lt Unavailable gt The Host is not Current Editor of the workpaper Click on any workpaper with lt Available gt displayed in the Live Editor column to edit the workpaper Close the workpaper when you finish editing it No synchronization or check in required Synchronize Binder Synchronizing a binder update changes made to workpapers with other staff members 1 2 a 3 4 Page 44 Select the binder in the File Room window Click the Synchronize Binder toolbar button Click Next on the Synchronize Binder Wizard Welcome screen Select the Staff or Buddy List member to synchronize with If you are synchronizing the binder in the field with a staff member whose computer is not listed in the Existing Locations list browse to the appro
39. ory by clicking Browse 7 Click OK If you have any ungrouped accounts a report listing them displays You must group these accounts before you can successfully complete the export Page 41 Sharing Workpapers Tip When customizing a tax Account Grouping List you can add sub groups to groups that support detail schedules in your tax software The sub group descriptions display as the descriptions on the detail schedule You cannot add groups to a tax Account Grouping List as they will not export to your tax software You can choose groups or sub groups to export by selecting Send to Tax in the group or sub group properties Sharing Workpapers Only the Current Editor in a non shared file room or the Live Editor in a shared file room can make changes to a workpaper Other team members can view a read only copy of the workpaper When you check out unassigned workpapers from the central file room you become the Current Editor You remain the Current Editor until you check in the workpaper to the central file room or assign it to another team member There are five methods you can use to share workpapers E Shared Local File Room Synchronize Binder Synchronize Selected Workpapers Express Synchronization Binder Packages When team is attached to an office network the central file room is used to share and distribute binders When you log in to Engagement from the Office the program displays the central file rooms that h
40. paper 2 Select the item to insert New Workpaper from Template a Select the tab containing the template b Select the template to use and click OK c Enter the Name required and Index d Click OK New Workpaper from File a Choose the location in the Look in field b Select the file to insert and click OK c Enter the Name required and Index d Click OK Page 19 Adding Items Binder Window Page 20 New Trial Balance a b C d Select the tab containing the template Select the template to use and click OK Enter the Name required and Index Click OK New Manual Workpaper a b Enter the Name required and Index Click OK New Placeholder a b Enter a Name required and Index Click OK New Knowledge Tools Workpaper a b C d Select a title Select the workpapers from the title Click OK If needed you can do the following for each workpaper to be inserted Enter an index Change the workpaper name Select the roll forward options m New Knowledge Coach Workpaper a b C d Select an industry Select the workpapers from the industry Click OK If needed you can do the following for each workpaper to be inserted Enter an index Change the workpaper name Select the roll forward options Understanding the Trial Balance New CCH Workpaper or New M amp P McGladrey amp Pullen Workpaper
41. priate path in the Alternate Locations field then click Next The Synchronize Entire Binder or Selected Workpapers dialog displays Select to either synchronize the entire binder including all workpapers or to synchronize only workpapers you select Click Next If you have current editor rights for a workpaper the Assign Workpapers dialog appears Select workpapers to assign to a staff member s local file room You will no longer have current editor rights to them in your local file room Sharing Workpapers 7 Click Next If you are synchronizing selected workpapers and new workpapers exist in your local file room or the remote file room the Synchronize Workpaper from your LOCAL File Room or Synchronize Workpaper from REMOTE File Room dialog displays as appropriate Select the workpapers to synchronize 8 Click Next 9 Click Synchronize Synchronize Individual Workpapers When logged in from the Field you can synchronize selected workpapers with other staff members or a staff member in your Buddy List 1 Open the binder containing the workpapers to synchronize 2 Select workpapers to synchronize Press and hold to select contiguous workpapers or press and hold to select non contiguous workpapers Select Workpaper Synchronize Workpaper 4 Select the target to synchronize with Click OK A list of workpapers that are available for synchronization displays 6 Click Synchronize F xpress Synchronization Expres
42. r Freeze Links Freezes Engagement links for the workpaper so that links are not refreshed Unfreeze Links Unfreezes Engagement links for the workpaper Create Workpaper Note Creates a note for the workpaper QuikLink Performs a Quiklink with ProSystem fx Tax Page 15 Engagement Toolbars in Excel and Word Sew dE New Comments Adds comments in a worksheet Show Hide All Comments Toggles between showing and hiding all comments in a worksheet Edit Comment Allows you to edit the selected comment Delete Comments Removes comments from a worksheet Check Source TB for Changes Checks a source trial balance for changes if you have imported data from a source Engagement trial balance to a target Engagement trial balance F gagement Toolbar Word for Office 2003 The Engagement toolbar that displays in Microsoft Word for Office 2003 includes the following buttons Mame Functions Date Functions Page 16 bm Name Functions Inserts Client Engagement and Firm information links Date Functions Inserts Current and Prior date links Refresh Refreshes all links in the workpaper including Name Date and Trial Balance links Paste TB Link Links data from your trial balance to your workpapers or financials This information updates with trial balance changes Insert TB Link Creates links from the trial balance without having to open the trial balance Drill Down TB Link D
43. r binders used By Lead Partner Displays a list of binder links sorted by lead partner from the binder properties Other Highlights Displays a list of binder links sorted by specific criteria By Engagement Type Displays a list of binder links sorted by the categories listed Tip of the Day Displays suggestions for using the program more efficiently You can hide the Tip of the Day by clicking Hide Tips Click Previous and Next to navigate through the tips Page 3 Binder Window Binder Window To open a binder double click the binder in the file room The Binder window is made up of four views Binder View Notes Summary View Sign Off Summary View and Current Editor View or Live Editor View Binder View The Binder View displays the contents of the binder and the status of the workpapers in the binder i File Edit View Tools Trial Balance Workpaper Help ms Shortcuts Lg Binder Index 2 CB NA l ReviewedBy t Ya Sample Binder 7 0000 GENERAL 1000 PLANNING amp ANALYTICAL Workpapers f 2000 TEST OF CONTROLS 7 3000 REPORTING ff 4000 ASSETS Jf 5000 LIABILITIES J 5000 EQUITY Fr 7000 INCOME STATEMENT if 8000 TAX 29 Untiled Workpapers si s Binder View 1 Shortcut Bar The Shortcut Bar provides quick access to many Engagement functions including workpapers the Binder Snapshot and the Trial Balance Snapshot It also includes links to ProSystem fx Tax if instal
44. r into it If the client folder doesn t exist Engagement creates it m If you have the binder already Engagement compares the existing binder to the one sent to determine if there are any conflicts If different Current Editors exist for the same workpaper you are warned of this conflict when you open the binder Page 46 Reviewing Workpapers Note During synchronization a Synchronization Conflicts dialog displays when there are conflicts between a binder in the local file room and a binder in the central file room You must specify whether the Local copy or the Remote copy remote local file room central file room or binder package takes precedence You can view details of the conflict by clicking View Details Click OK to continue Reviewing Workpapers WWerkpaper Notes There are three types of workpaper review notes you can use to electronically communicate during an engagement E Open Item Team Note Note for Next Period Creating a Workpaper or Workpaper Tab Note 1 Select the workpaper or workpaper tab from the Binder window E 3 4 To address the note to an individual team member clear the All Binder Staff box and select a specific staff member de Click the Create Workpaper Note button Select the type of note from the drop down list Enter the note s subject in the Subject field Enter the note s text in the Note field Click OK to save your note The note information displays in the Notes
45. rills down to the accounts included in the linked formula bod H Be Engagement Toolbars in Excel and Word JE Summary Enables you to add modify or delete journal entries Account Groupings Opens the Account Groupings window where you group your accounts TB Column Setup Opens the TB Column Setup window where you can modify the columns displayed in your trial balance You can set up Budget Tax and Variance columns and more Write Up Journal Entry Organizes the transaction data in journals Consolidate Consolidates data from single company trial balances into a consolidated trial balance Tickmark Toolbar Displays the tickmark toolbar Insert Workpaper Reference Inserts a link to another workpaper in the binder Open Workpaper Reference Opens the referenced workpaper Freeze Links Freezes Engagement links for the workpaper so that links are not refreshed Unfreeze Links Unfreezes Engagement links for the workpaper Create Workpaper Note Creates a note for the workpaper Insert CCH Footnote Inserts a CCH footnote Toggle Field Codes View Field Codes Toggles all links in Word on off When on you can view and edit Engagement formula links directly Page 17 Adding Items File Room Adding Items File Room New Client Folder 3 Click the New Client toolbar button Enter the client s information on the Profile tab Click the Groups tab to assign the client to a client group
46. rnnrnnnnnnnrrnnnnnnn 57 NORS LL 58 Overview Overview The Field Guide is designed to be used as a quick reference for experienced users of ProSystem fx Engagement This Field Guide is ideal to use as a Supplement to our training courses It describes the most common way to perform tasks Refer to the ProSystem fx Engagement User Guide for a more exhaustive explanation of these functions and all of the ways to perform them You can access the User Guide from the Help Menu in ProSystem fx Engagement Page 1 Local File Room Local File Room There are two views for the local file room Client Index view and Engagement Today view Client Index View pey m ji Al Client Groups ID Type Status Lead Partner Year End Ya Sample Binder 9999 01 Ausdit In Process 12 31 2008 YajccH Trial 9999 02 Other In Process 12 31 2008 Ys Quarter 1 Comp 9999 03 Compilation In Process 12 31 2008 Quarter 2 Comp 9999 04 Compiation In Process 12 31 2008 1 Client Index Pane This area of the File Room displays client folder information The Client Folders hold your Engagement binders 2 Contents Pane This area displays the contents of the selected item in the Client Index Pane These could be client folders or binders You can sort items shown in this pane by clicking the column headers 3 Remote File Rooms Pane This area contains three tabs CFR Central File Room Staff and Buddy List If you have logged in from the Field you will not
47. rom and ASCII Text file select whether the source file is comma delimited or tab delimited If importing from GoSystem Audit select the balance type to convert Click Next If importing from GoSystem Audit do the following a Select whether to convert all groupings convert all and map to one Engagement grouping or map to one Engagement grouping b If you are mapping groupings select the GoSystem Audit grouping to map from on the left and select the ProSystem fx Engagement grouping to map to on the right c Select the appropriate options for converting tax codes if necessary d Click Next On the Chart of Accounts screen click the gray bar at the top of each column to select the appropriate header information You can assign only one trial balance column to each column of imported data Select either to append or overwrite the data in the existing trial balance Select the appropriate rounding options as necessary Click Next Click Yes Click OK Click Finish Page 25 Using Trial Balance Functions Importing Data from CaseWare 1 10 11 Page 26 Select Import Conversion Wizard from the Trial Balance menu in the Binder window Choose the source of your conversion file and click Next From the Select Engagement trial balance list select the ProSystem fx Engagement trial balance you want to transfer the data into Select the client file for import Note Only client files w
48. rting amp Importing Trial Balance Data You can convert trial balance data from other supported trial balance software packages into an Engagement trial balance You can also import trial balance data from another Engagement trial balance For other cases import the information using the Paste TB Import function Converting Trial Balance Data from ProSystem fx Write Up or ProSystem fx Trial Balance 1 Select Import Conversion Wizard from the Trial Balance menu in the Binder window Choose the source of your conversion file Click Next 4 Select the ProSystem fx Engagement trial balance you want to transfer the data into from the Select Trial Balance list 5 Select the ProSystem fx Trial Balance or Write Up file from the Select export file list 6 Select the appropriate current period information tax information chart of accounts settings and lead classifications options as necessary 7 Click Finish Converting Trial Balance Data from ATB for Windows GoSystem Audit or an ASCII Text File 1 Select Import Conversion Wizard from the Trial Balance menu in the Binder window Choose the source of your conversion file Click Next Page 24 11 12 13 14 15 16 17 Using Trial Balance Functions Select the ProSystem fx Engagement trial balance you want to transfer the data into from the Select Trial Balance list Select the source file for import Select the number of prior periods If importing f
49. s Synchronization automatically synchronizes changes from the local file room to the central file room and vice versa without opening the Synchronize Binder Wizard You do not have the option to check workpapers in or out To perform an express synchronization do the following 1 Select the binder in the File Room window ant 2 Click the Express Synchronization toolbar button Page 45 Sharing Workpapers Binder Packages Creating a Binder Package G From the File Room select the binder you want to package Click the Create Binder Package button Select the workpapers to include in the package ER gt Select how you want to distribute the binder package m To save the binder package as a file select Save package to a file Verify the path and file name of the binder file m To send the binder package as an email attachment select Send package via email 5 Click OK Receiving a Binder Package After a binder package is created other Engagement staff members can receive it To receive a binder package do the following 5 1 Click the Receive Binder Package button from the File Room window Note To receive a binder package via Microsoft Outlook select Engagement Receive Binder Package in Outlook Browse to the package file with an AZP extension to receive When you receive a binder one of two events will occur m f you do not have the binder Engagement locates the client folder and inserts the binde
50. seeeeeeeaaeeeees 49 MICAS EE EA 49 Using the Tickmark Definition List ranrrrernnnrnnrrnrrnrnnnnnn 49 Inserting Tickmarks wicitsviciccientanasismianeasiniantemiantantenbeiantenneld 50 Workpaper Reference Links ccccccsseceeeceeeeeseeeeeeeseeeees 50 Inserting Workpaper Reference Links rrrrnnrr rnrnnrreenen 50 Opening Referenced VWorkpapers cccceccceceeeeeeeeeeeees 51 Publishing Workpapers ccccccseeccceeeeceeseeceesesseeeeseeseeses 51 Other Common Features uuuarmmuasmmuommdeansssvniminnmnsi 52 Creating Templates cccccccccccseseeeeeesesneeeeeeessanesseseeseanees 52 Trial Balance Templates ccccccccsececssseeceseeseseeseaseeees 52 Workpaper Templates rannrnnnnnnnnnnronnnnnnnnnnnvnnnrnvannevnnnnnnn 53 Account Grouping Templates ccccccccccseeeeeeeeeeeeeeees 53 Print Group Templates uusussemesmea msamamnsj 54 Tickmark Templates sccsvececvesensescsciexcvncuticete asnattecednasiieaadtcnenss 54 Saving TB Link FONMUIAS csinacccissinctoasmeantiadcaniandaesteaeetiadengss 54 Renaming NCIS tassicetansnteireveiiinndmianhiuaeinenstinntanGdimecwernnbisionaindes 55 Deleting Items 2 cicecesssencccecsaacsseceanesancenemeectence nesateuemeasenccames 55 Getting More Information aassssssnssssnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnne 56 Contacting ProSystem fx Engagement cccccsseeseeeeeeeeeees 56 Appendix A TB Report Sample Settings
51. select the trial balance cell s you want to fa link to the workpaper Click the Copy TB Link toolbar button Switch to the workpaper you want to paste the link s to 4 Select the area you want to paste the links into Page 36 iB ri 5 6 7 Using Trial Balance Functions Do one of the following when pasting a link into one of the areas listed below Excel spreadsheet Select the cell or the first cell in the range if you are pasting multiple cells and click the Paste TB Link toolbar button Word Table Select the entire table cell and click the Paste TB Link toolbar button Word Paragraph Insert the cursor where you want the data to appear or select the text to replace and then click the Paste TB Link toolbar button Select the options to use from the window that appears Click OK Inserting TB Link 1 2 3 4 Open the Excel or Word workpaper Place the cursor where you want to insert the TB Link Click the Insert TB Link button on the Engagement toolbar Build a formula using the six parameters Trial Balance Account Grouping Type Period Balance Type and Account Index To round the amounts used in the formula select the Round box and enter the number of decimal places to round to Select Sign options in Excel or Word and select Negative style Numeric style and Zero style in Word Click the Insert button The formula displays in the TB Link Formula box You can add to the exis
52. t on Loan 2 Guidance For Help press F1 Page 7 Binder Window Sign Off Summary View The Sign Off Summary View displays the level of review for all of the workpapers that exist in the binder The level of review is in three stages In Process Ready for Review and Reviewed Team members that have signed workpapers off are listed with the sign off date under each workpaper ej Ready for Review E tal 7410 Depreciation Expense Leadsheet Manager Mary 4 7 2009 3 32 PM fa 7510 Other Income amp Expense Leadsheet amp Manager Mary 4 7 2003 3 32 PM v Reviewed 2 Engagement Letter amp Manager Mary 4 7 2009 3 31 PM 4 Sign Off Summary view F E A ree Page 8 Binder Window Current Editor View If you are viewing a non shared local file room the Current Editor View tab is available The Current Editor View displays all of the team members assigned to the binder Displayed under each team member is a list of the workpapers they have checked out Any workpaper not checked out to a team member appears in the Unassigned section i File Edit View Tools Trial Balance Workpaper Help Shortcuts sr Ej 1110 Auditing Budget Ha 1210 Preliminary Analytical Review Report Workpapers EN 1220 Ratio Analysis 12 tal 1230 Final Analytical Review Report D 2100 Control Testing Binder Snapshot 3110 Trial Balance otal 3120 Working Trial Balance Report Yel 3210 Adjusting
53. tains the workpapers you delete in ProSystem fx Engagement If you have deleted a workpaper by mistake you can restore it and it will be filed back to the appropriate tab Page 5 Binder Window The Binder folder contains tabs that organize the workpapers Workpaper properties display in columns to the right of the Binder Index column and include the following Page 6 Index Number and Name The alphanumerical index number is optional The name is required and it describes the content of the workpaper Locked A locked workpaper is read only Frozen Links If the Engagement links in the selected workpaper are frozen this icon displays Note If a note has been created for this workpaper or workpaper tab this icon displays Modified after Reviewer Sign Off If the administrator has chosen to flag workpapers that have been modified after a reviewer has signed off this icon displays as appropriate Prepared By When a workpaper is signed off by a preparer the date and preparer s initials display Reviewed By When a workpaper is signed off by a reviewer the date and reviewer s initials display 2nd Reviewed By When a workpaper is signed off by a second reviewer the date and reviewer s initials display File Modified Date The date and time the workpaper was last changed Current Editor if viewing a non shared file room The staff member who has checked out this workpaper Live Editor if viewing a shar
54. te Note Trial balance templates created with a version of Engagement prior to 6 0 must be converted to a format supported by Microsoft SQL Server database To do this select File Convert Trial Balance Templates in the ProSystem fx Engagement File Room Follow these step to save a trial balance as a template 1 Open the trial balance 2 Select Engagement Properties 3 Clear the Hide zero balance groups and sub groups and Hide zero balance accounts boxes The numbers and groups will display on the trial balance when it is created from this template 4 Click OK Close the trial balance Right click the trial balance in the Binder window and select Save as Template Select the template folder where you will save the template Type the file name for the template Page 52 Other Common Features 9 Select the Clear chart of accounts box if you do not want to save the account numbers and descriptions in the template 10 Select the Save journal entries box to save the journal entries accounts and amounts in the template 11 Click Save Workpaper Templates If there is a workpaper format you use frequently you can save it as a template Follow these steps to save a workpaper as a template 1 2 Select the workpaper in the Binder window Right click the workpaper you want to make into a template and select Save As Template Keep the default path and name or browse for the path and type a name for the t
55. ting formula by selecting the appropriate parameters again and clicking the Insert button Click Paste to insert the TB Link into the workpaper Page 37 Using Trial Balance Functions Analyzing a TB Link Formula To view a TB Link in Excel click on a cell containing the TB Link The formula displays in the formula bar In Word click the Toggle Field Codes or View Field Codes button A Word formula has several formatting parameters but within this formula you will see the same formula noted in Excel TBLink TB FINAL 7 4110 15 1 0 TB represents the name of the trial balance database you linked from FINAL 7 represents the trial balance column you linked from FINAL shows the Abbreviation you defined in the TB Column Setup window 7 is the column ID assigned by Engagement 4110 represents the index assigned to an account class ratio class account group account sub group or the account number if linked to the Account Detail 15 represents the Grouping List ID number 1 represents the trial balance tab you linked from or the account type you linked 1 Group Summary tab 2 Sub Group Summary tab and 3 Account Detail tab 1 Account Class 2 Account Type 0 Ratio Class 0 is reserved for future use Drill Down to Trial Balance Accounts To drill down to the accounts that make up the amounts calculated in a linked formula in an Excel or Word workpaper do the followin
56. ts for the entry by double clicking an account on the left side Note You can create new accounts by clicking Add Account Click Remove JE Line to take the selected account out of the journal entry field Enter the amounts in the cells Select one of the following Save and New to record another entry m Save and Close to return to the Journal Entry Summary screen Note On the Journal Entry Summary screen you can reclassify any entry to another journal entry type by dragging the journal entry to the appropriate icon in the left pane Click Close when done Recording Transactions in Write Up Trial Balances 1 Open the write up trial balance fa 2 Click the Write Up Journal Entry button 3 From the Trial Balance menu select the trial balance you want to post transactions to 4 Select the journal to use to enter the transactions Page 31 Using Trial Balance Functions Click New to start entering your transaction Enter the Date Ref Transaction Account Account Description and Debit and Credit amounts as needed Note For choices involving dates reference numbers or account numbers click Options 7 Click Close to finish entering transactions Note See page 39 Advanced Trial Balance Functions for instructions on creating write up trial balances Reports There are four types of reports created by Engagement JE TB Consolidated and Write Up JE Reports 1 Open the trial balance 2 Fro
Download Pdf Manuals
Related Search