Applies to versions: 2.0, 2.1, 2.2, 2.3, 2.4, 2.5, 3.0

MasterBuilder Integration - Setup TimeIPS

TimeIPS can directly transfer employees' time worked into MasterBuilder with the MasterBuilder integration feature available in the optional IPSEPI enhanced payroll integration module. The Integration should be done on the computer where MasterBuilder is installed and payroll is run. Four applications will be running during the integration: TimeIPS, MasterBuilder API, the TimeIPS MasterBuilder client, and MasterBuilder.

1-Time Setup

Before running the integration, you will need to:

• Configure MasterBuilder for API integration. (Instructions found on the MasterBuilder Setup article.)
• Configure Payroll Export options in TimeIPS to match fields in MasterBuilder to fit the needs of your business.
• Install the TimeIPS MasterBuilder Client on your computer running MasterBuilder. (Instructional article)

SetUp TimeIPS

Before running the Master Builder Integration for the first time, you will need to setup your TimeIPS MasterBuilder Export Settings. These settings do not need to be adjusted each time you run the Integration unless changes are made to your MasterBuilder Payroll Types or other settings.

• Add MasterBuilder Employee ID and Comp Code
• Configure Payroll Export options Preset

Add MasterBuilder Employee ID and Comp Code

Using the left pane Main Menu » Administration, go to: Employees » Employees

1. Click the plus sign in front of an employee and choose the Employment tab.
2. Put the Master Builder Employee ID in the Alternate Number field.
   Note:You can find your employees Master Builder Employee ID in Master Builder by going to menu 5-1-1 and run a employee list report.
3. Put the Master Builder Comp Code in the Title/Position field.
   Note:You can find your employees Master Builder comp code in Master Builder by going to menu 5-1-5 and run a workers comp report. You could also use other fields in TimeIPS to store the workers comp code such as the employee ssn field.
4. Click on the employees required tab to save.

Configure Payroll Export options Preset

A MasterBuilder preset will need to be created in order to export.

Using the left pane Main Menu » Administration, click on: Payroll » Payroll Export

1. Click the + (plus) sign to the left of Payroll Format Settings bar to expand the window.
   
   
   
   
   
   


2. From the drop down box, select the Sage MasterBuilder file format to modify.
3. Click the Edit Payroll Export Settings button to bring up the editing screen.

 

If you have not already created a MasterBuilder preset, you will see the following screen.

Click the Add Preset button to begin setup.

The preset window will appear.

If you have not yet downloaded the TimeIPS MasterBuilder Client, you can do so here. Click on the TimeIPS MasterBuilder Client (smbTimeIPS.exe) link at the top of the page and save it to an easily-accessed location on your computer, such as your desktop. (Instructional article)

NOTE: Make sure to install the TimeIPS MasterBuilder Client on the computer running MasterBuilder. You will launch this application each time you run the payroll integration.

1. The Preset Name can be anything you choose. In this example we have used the name Master Builder


2. The MasterBuilder File Company Name is the name of the Company in Masterbuilder that TimeIPS will be integrating with.


3. The MasterBuilder Username is the User name of the user in Masterbuilder that TimeIPS will be integrating with.


4. The MasterBuilder Computer IP Address is the IP address of the computer that you are running the MasterBuilder program on and is where you will run the Integration.
   Note: To Identify your Computer's IP Address
   Ask your network administrator.
   OR
   
   Go to the Start menu - Run option.
   • In the Open/Run window, type in the following command and press ENTER: command
   • In the Command prompt, type in the following command and press ENTER: ipconfig
5. Set the Master Builder Employee ID field to match the field in TimeIPS that you have entered the MasterBuilder Employee ID into.


6. Set Check for existence of Entities in MasterBuilder before starting export to Yes.
   NOTE: If this is set to yes and TimeIPS finds information that does not match in both MasterBuilders and TimeIPS it will not export until corrected.
   
   
   
   
   
   
7. Set the correct code for the MasterBuilder Pay Type they can be 0-9.
   NOTE: These are hard coded in MasterBuilder. Regular Pay-1, Overtime-2, Premium-3, Sick-4, Vacation-5, Holiday-6, Piece Work-7, Per Diem-8, and Misc-9.
   
   
   
   
   
   
8. Setting up the "MasterBuilder Job Tracking and Custom Field".
   • Optional Set MasterBuilder "JobRef". Choose which field you will use in TimeIPS to track this.
   • Optional Set MasterBuilder "CostCodeRef". Choose which field you will use in TimeIPS to track this.
   • Optional Set MasterBuilder "DepartmentRef". Choose which field you will use in TimeIPS to track this.
   • Optional Set MasterBuilder "ServiceOrderRef". Choose which field you will use in TimeIPS to track this.
   • Optional Set MasterBuilder "PayGroupRef". Choose which field you will use in TimeIPS to track this.
   • Optional Set MasterBuilder "Memo". Choose which field you will use in TimeIPS to track this.
   • RequiredSet MasterBuilder "Rate". Choose which field you will use in TimeIPS to track this.
     Note: Choose Payable Hourly Rate (diff/override and OT/DT/PT) to follow the FLSA.
   • Optional Set MasterBuilder "PhaseRef". Choose which field you will use in TimeIPS to track this.
   • Required Set MasterBuilder "WorkersCompCodeRef". Choose which field you will use in TimeIPS to track this.
     Note: We recommend using the employee Title/Position field to store this number.
9. Once your preset has been configured, click on Save Settings to save, or Cancel to exit without saving.



10. On the next screen be sure that your new preset is the one selected in the Export Settings Preset drop down menu.
11. Click Done.