Installing WTS Integration Manager
Contents
1. i Web TimeSheet Integration Manager for QuickBooks ITF ersion Rung Copyright O 2003 Replicon Inc All rights reserved All parts of this manual are the property of Replicon Inc No parts of this manual may be reproduced in any manner whatsoever including mechanical or electronic media such as disk or tape No part of this manual may be transmitted in any form by any means without the written permission of Replicon Inc Web TimeSheet is a registered trademark of Replicon Inc All other products are registered trademarks or trademarks of the respective companies Contact Information Replicon Inc 830 910 7th Ave S W Calgary Canada T2P 3N8 Direct 1 403 262 6519 Toll Free in North America 1 877 737 5420 Toll Free in Europe 00 800 73 75 4266 Toll Free in Australasia 011 800 7375 4266 Fax 1 403 233 8046 http www replicon com info replicon com The international toll free numbers may not work in some countries If you experience problems use the direct line to contact Replicon REEM Chapter 1 Installing the WTS Integration Manager 1 IO LEE TEN SETE eee rer lerede 1 Installing WTS Integration Manager sssssss senere 1 Chapter 2 Using the WTS Integration Manager 3 Accessing WTS Integration Manager ssssseeereee 3 Preparing to Export Data sssssssssneneeeeeennnkenrknnnee 3 TINMICSNCCL EX DOME ctinisis scsi2. Intuit QuickBooks Before exporting expense information you must set up User Defined Field 10 for clients which is mapped to the Accounts Payable Name field in Intuit QuickBooks Refer to the Web TimeSheet User Manual for further information about creating user defined fields Intuit Quick Books does not allow a name to be used in more than one list Please make sure you do not use the same name for customers client name in Web TimeSheet vendors expense description or items project name task name Map Fields You may wish to map client specific user defined fields to client information in Intuit QuickBooks You cannot repeat field mapping meaning you can map one user defined field to one field in Intuit QuickBooks 6 Click the Save button to save your settings If you made a mistake you can click the Reset button to restore the previous settings Time Off Export To export time off data 1 Click on the Reports button at the top of the screen and select Time Off Export from the list of QuickBooks Export reports in the side menu 2 Select the appropriate timesheet period and specify whether you want to include time off information for all timesheets or only those which have not yet been exported 3 Click the Settings button On the Basic Settings tab enter the correct information in the fields for CompanyName CompanyCreateTime Ver and Rel CompanyCreateTime is a unique number that identifi
3. Welcome screen is displayed wean E x Note for QuickBooks IIF Setup program This program will install Web TimeSheet Integration Manager for QuickBooks IF on your computer Make sure you install Web TimeSheet 5 1 before installing the Web TimeSheet Integration Manager for QuickBooks IIF e Welcome to Web TimeSheet Integration Manager Ps lis strongly recommended that you exit all Windows programs before running this Setup Program Click Cancel to quit Setup and close any programs you have running Click Hest to continue with the Setup program WARNING This program is protected by copyright law and International treaties Unauthorized reproduction or distribution of this program or any portion of it may result in severe civil and criminal penalties and will be prosecuted to the maximum extent possible under law Cancel Next you will need to specify the directory where the Web TimeSheet Integration Manager for QuickBooks IIF should be installed The installation wizard does not provide a default directory The Integration Manager for QuickBooks IIF must be installed in the root of the Web TimeSheet directory Use the Browse button to locate the Web TimeSheet directory JA Choose Destination Location E x Setup will install Web Timesheet Integration Manager for QuickBooks IF in the following folder To install into a different folder click Browse and select another folder Y
4. dvanced export options optional Export time to QuickBooks as Specify whether you would like to export time data to QuickBooks as QuickBooks Time default or as a client invoice If you select QuickBooks Time you can still create a client invoice manually from within Intuit QuickBooks Select Employee Types that act as vendors If you have specific Web TimeSheet employee types that should be considered vendors in Intuit QuickBooks you can select those employee types here The time data for any selected employee types will be exported to vendor bills instead of QuickBooks Time in Intuit QuickBooks If you have selected to export data as a client invoice your data will remain unaffected Specify Vendor Transaction Account These are the accounts that will be credited debited for the vendor transactions employee types selected above The credit account is the name of the liability account from Intuit QuickBooks The debit account is selected from the user defined fields for Web TimeSheet employee types To select a debit account you must set up one employee type user defined field containing this information You can then select a field from the Debit Account drop down list Note If you are exporting time off data Time Off Export report be aware that only approved timesheets will be included in the report and exported to Intuit QuickBooks Time off hours are identified as non billable when exported to
5. es your organization in your version of Intuit QuickBooks To locate this number run Export Lists for Timer in Intuit QuickBooks and open the resulting iif file by default the file name is timer iif 5 Click the Save button to save your settings If you made a mistake you can click the Reset button to restore the previous settings Expense Export For the Expense Export you must first define User Defined Field 10 for clients which is mapped to the Accounts Payable Name field in Intuit QuickBooks refer to the Web TimeSheet User Manual for instructions on setting up user defined fields To export expense data 1 Click on the Reports button at the top of the screen and select Expense Export from the list of QuickBooks Export reports in the side menu 2 Select the appropriate timesheet period and specify whether you want to include all timesheets or only those which have not yet been exported 3 Click the Settings button On the Basic Settings tab specify how the client information should be mapped to Intuit QuickBooks 4 Now select the Advanced Settings tab to set up more advanced export options optional Export expense data as specify whether you would like to export expense data to QuickBooks as a vendor bill default or as a client invoice If you select vendor bill you can still create a client invoice manually from within Intuit QuickBooks Map Fields You may wish to map client specific user de
6. et Field User Name Entry Date Client Name Client Project Project Name Billable Task Name Role Total Hours Comments User Name Entry Date Total Hours Comments Client User Defined Field 10 Expense Sheet Amount Expense Sheet Date Expense Sheet Description limited to 30 characters Expense Client Expense Code limited to 30 characters Expense Entry Amount Expense Entry Description Intuit QuickBooks Field Emp Date Job Job Item Class Billing Status Item Class Item Duration Note Emp Date Duration Note Accounts Payable Name Bill Amount Due Bill Date Vendor Name Expense Customer Expense Account Name Expense Amount Expense Memo 2003 by Replicon Inc All rights reserved
7. eteainstindiatsnanunactaenntanlstediaednndont 3 TIME OFF EXPOIN etern i 4 Expense Expof l ccc cece cece scccseccnsccnsccnecceessnesseeeseeesees 4 Exporting Data to QUICKBOOKS cccceecceeeeeeeeeeeeen eens 4 Chapter 3 Field Relationships 5 Chapter 1 Installing the WTS Integration Manager Introduction The Web TimeSheet Integration Manager for QuickBooks IIF allows you to generate a report of Web TimeSheet data and export the information to a iif file that can be opened in Intuit QuickBooks Before installing the 5 1 version of the Web TimeSheet Integration Manager for QuickBooks IIF make sure you have already installed Web TimeSheet 5 1 The Integration Manager for QuickBooks IIF will need to be installed in the Web TimeSheet 5 1 directory Installing WTS Integration Manager This section explains how to complete the installation of the Web TimeSheet Integration Manager for QuickBooks IIF You will need to purchase the Web TimeSheet Integration Manager for QuickBooks IIF and obtain the WTS51 QuickBooksLink exe from Replicon Customer Support The database version of the Integration Manager for QuickBooks IIF should be the same as your Web TimeSheet database SQL or Oracle The Installation Wizard will guide you through the installation process 1 Stop the service associated with Web TimeSheet and back up the Web TimeSheet database 2 Launch the WIS57QuickBooksLink exe file The
8. fined fields to client information in Intuit QuickBooks Select the user defined fields you would like to export and specify the Intuit QuickBooks field to which each user defined field will be mapped You can only select a QuickBooks field once no repetition 5 Click the Save button to save your settings If you made a mistake you can click the Reset button to restore the previous settings Exporting Data to QuickBooks Once you have set up your report you are ready to export the data to Intuit QuickBooks To export the data simply click the QuickBooks button at the top of the report Only data for approved timesheets expense sheets will be included in the export When you export the data Web TimeSheet will create a iif file that can be opened in Intuit QuickBooks and accessed through either the timesheets or time reports Chapter 3 Field Relationships The following table specifies which Web TimeSheet fields can be exported to Intuit QuickBooks The report name refers to the report where each field is available for export Report Name Timesheet Export Timesheet Export Timesheet Export Timesheet Export Timesheet Export Timesheet Export Timesheet Export Timesheet Export Timesheet Export Timesheet Export Time Off Export Time Off Export Time Off Export Time Off Export Expense Export Expense Export Expense Export Expense Export Expense Export Expense Export Expense Export Expense Export Web TimeShe
9. ou can choose not to install Web Times heet Integration Manager for QuickBooks IF by clicking Cancel to exit Setup Destination Folder C Program FilesYW eb TimeSheet Browse Cancel 4 Click the Next button on the Choose Destination Location screen to continue with the installation 5 Now you are ready to install the Web TimeSheet Integration Manager for QuickBooks IIF Click the Next button to start the installation J Start Installation E xi Vol are now ready to install Web TimeSheet 4 6 Quickbooks Access Press the Next button to begin the installation or the Back button to reenter the installation information 6 When the installation is complete click the Finish button to close the Installation Wizard sd Installation Complete i 3 x Web TimeSheet 4 6 Quickbooks Access has been successfully installed Press the Finish button to exit this installation Eancel 7 Restart the Web Timesheet service You are now ready to use the Web TimeSheet Integration Manager for QuickBooks IIF Chapter 2 Using the WTS Integration Manager ___ Accessing WTS Integration Manager The Web TimeSheet Integration Manager for QuickBooks IIF is accessible as a report from within Web TimeSheet You can access this report as follows 1 Log in to Web TimeSheet and click on the Reports button at the top of the screen Select QuickBooks Link under the QuickBooks heading from the
10. side menu Preparing to Export Data Before exporting Web TimeSheet data to Intuit QuickBooks you must set up the report You can set up the following reports Timesheet Export sends data to the Intuit QuickBooks Timesheet module and then the client invoice Time Off Export sends data to the Intuit QuickBooks Timesheet module Expense Export sends data to the Intuit QuickBooks vendor bills Timesheet Export To export timesheet data 1 Click on the Reports button at the top of the screen and select Timesheet Export from the list of QuickBooks Export reports in the side menu Select the appropriate timesheet period and specify whether you want to include all timesheets or only those which have not yet been exported Click the Settings button On the Basic Settings tab select the fields you want to export and specify how the client and project information should be mapped to Intuit QuickBooks Project information can be mapped to QuickBooks Item Class or both Make sure you enter the correct information in the fields towards the bottom of the screen CompanyName CompanyCreateTime Ver and Rel CompanyCreateTime is a unique number that identifies your organization in your version of Intuit QuickBooks To locate this number run Export Lists for Timer in Intuit QuickBooks and open the resulting iif file by default the file name is timer iif Now select the Advanced Settings tab to set up more a
Download Pdf Manuals
Related Search