Data Extraction for CP2.0
The ConstructionPayroll.COM Export menu option is used to extract payroll data for existing AccuBuild customers that wish to use the ConstructionPayroll.COM service. The data will be imported by AB into the CP2.0 program in order to establish year to date totals for employees.
•Data Extraction for CP2.0: A new screen has been created for CP2.0 data extraction. To access this screen, select the option entitled ConstructionPayroll.COM Export from the Payroll Menu:
•Payroll Batches: The batch extraction process allows for individual posted payroll batches to be exported to excel spreadsheets for uploading into CP2.0 in order to perform parallel testing. This allows for timecard entries to be processed in CP2.0 automatically using the identical user entries from the AccuBuild System. Extract a payroll batch as follows:
oPayroll Batches: Select the desired batch number from the list of captured payroll batches.
oExport the Batch: Click the Export Timecard Batch Data Entries to Excel button to create the export files for the selected batch number. These files will be saved in the user’s AccuBuild Folder for processing in CP2.0. Two files are created for each batch and identified by the batch type:
▪AUTO = Source 17 Automatic Payroll Checks
▪HANDWRITTEN = Source 18 Handwritten Payroll Check Entry
•Employee Year to Date Totals: This option will allow you to extract year to date totals for each employee from AccuBuild into excel spreadsheets for uploading into CP2.0. This process MUST be done before attempting to run parallel payroll batch tests so that the tax calculates will respect each employee’s year to date totals. Extract the year to date totals as follows:
oConstructionPayroll.com Tenant ID: Enter the Tenant ID for ConstructionPayroll.com. Please contact AccuBuild Support if you are unsure of your Tenant ID.
oCutoff Dates: Set the cutoff date range for the desired calendar year.
oExport Year to Date Totals: Click the Export Hand Written Check Entries to Excel button to create the year to date export files. These files will be saved in the user’s AccuBuild Folder for processing in CP2.0. Three files are created for the year to date totals:
oTechnical Notes: A new user based class series 810000 has been added to the Script Library to handle all of the CP2.0 Processing (810001 thru 810999)
•User Information for Check Posting integration - This option is used to set up the automatic integration posting between ConstructionPayroll.COM (CP.COM) and AccuBuild so that all of the job cost and accounting transactions created in CP.COM are automatically posted to AccuBuild.
Click on the Create / Verify User Setup for CP.COM Check Posting Process button to create the integration database files that are needed for the posting process. If the database files do NOT exist, they will be created automatically, otherwise these files will be validated. In either case, both the user name and file path will be displayed.
When the files are created, the user directory will contain the user database files for BASEUSER (3 files) as well as the posting batch table entitled INTAPHWBAT as shown:
