Summary

This document addresses work instructions for how to run tmsTime2Pay with a QuickBooks export using Internet Explorer.

  1. Log into tmsConneXion; also, QuickBooks should be open.

  2. Select Payroll and Payroll Monitor from the quick menu (Figure 1).

  3. Confirm you have no critical issues in the Previous Period and the Issues row is Green (Figure 2).  If you do have Critical exceptions, see Step 4, otherwise, skip to Step 8.

  4. If you have Critical exceptions which are typically caused by missing punches, you will want to address these before running payroll.  To see the Critical Exceptions, click anywhere in the Issues row (Figure 3).

  5. Upon clicking on the Issues, you will be taken to a list of employees who need something corrected; the Condition will alert you to the specific issue.  Click on the employee’s name to be taken to their timecard where the exception can be fixed.  Repeat this step for each employee on the list. (Figure 4).

  6. On the employee timecard, look for the Missing Punch in the Description field; add the missing punch(es) (Figure 5).

  7. You may use the Breadcrumb Trail in the upper right-hand corner to either go back to your employee list (Previous Period) or back to the Payroll Monitor by clicking whichever you prefer (Figure 6).  Please note that the employee you just fixed may continue to show in the list.

  8. Once all of the Critical Exceptions have been fixed, Payroll Monitor will change the Issues row to Green and you are ready to proceed.  Click on Initiate Close Payroll and the system will now generate payroll data.  This may take a moment to run. (Figure 7).

  9. Once finished, an output.csv file will be available for download (Figure 8).

  10. An option bar will open at the bottom of the screen; click the arrow next to Save and change to Save As.  Click Save As (Figure 9).

  11. You will be asked where you want to save the file; select the Hours folder that you created on the C: and click Save (Figure 10). 

  12. A message box will open at the bottom of your screen stating the download has been completed.  Click the X to make it go away or you may click Open Folder to see your three downloaded files (Figure 11).

  13. To see the files that have been downloaded, open the Hours folder and double click on the Payroll Close File; you will see output, PayDesignation and Payroll Report files (Figure 12).

  14. This step is optional but you can produce a file that you may use to compare to the file you will provide to QuickBooks and one that may be kept for historical purposes.  In the Manager Portal, select Balancing Hours to Payroll (Figure 13).

  15. Select Excel (Figure 14).

  16. An option bar will open at the bottom of the screen; click the arrow next to Save and change to Save As.  Click Save As (Figure 15).

  17. You will be asked where you want to save the file; select the Hours folder that you created on the C: and click Save (Figure 16). 

  18. Open tmsTIme2Pay by clicking on the icon on your desktop (Figure 17).

  19. Click Select your file (Figure 18).

  20. Navigate to the C:hours/payroll close file folder and find the output.csv file you saved; click on it and select Open (Figure 19).

  21. Once the file has been selected, click Export (Figure 20).

  22. Enter in the name of what you would like to call your file, select the location, and click Save (Figure 21).

  23. If successful, the following message will display (Figure 22).

  24. The file is now available to upload to QuickBooks (Figure 23).