Skip to main content
S
stanspalspetservices
May 1, 2025
Question

why aren't my timesheets importing the shift start or end time, only hours duration?

  • May 1, 2025
  • 1 reply
  • 0 views

I use quickbooks time and quickbooks advanced. I've finally found where to import the time sheets but when I do, it just gives me duration which doesn't work for my business. My employees cannot input their time without a start and end time, I can clearly see the start and end time when I approve the time but when I import the timesheets, it's just not there and manualy doing it on the payrun is time consuming but necassary as I have rules set up for pay. Why is it so difficult when I'm using a quickbooks product and all the help pages are saying to find the Payroll Item Mapping Tool in preferences on quickbooks time but its not there? whats that about?

1 reply

J
Jessavell_A
May 1, 2025

After exporting a timesheet from QuickBooks Time to QuickBooks Online (QBO), you can view the start and end times for each time entry in the Time section of QBO, Stan. Let’s explore this process in more detail.

 

First, access your QBO account and navigate to the Time entries section from Time. Here, you can click each entry to see the start and end times of your employees’ work shifts.

 

However, please note that when running payroll, you will only see the total duration of the time worked, rather than the detailed breakdown of start and end times for each entry. This approach focuses on aggregating the total hours worked for payroll processing. If you need to input specific times, you'll have to do this manually in the pay run according to your payroll rule setup.

 

Additionally, keep in mind the following before mapping payroll items:

 

  • To use the payroll item mapping tool, you need an active payroll subscription.
  • Initial payroll item mapping takes place during the setup of the QuickBooks Time and QuickBooks Online integration.
  • Only account administrators have the authority to map payroll items. 
  • Ensure that your employees have payroll items assigned in QuickBooks Online.
  • If you track overtime, make sure that is set up in your account. 

 

For more information, feel free to check out this article:  Map QuickBooks payroll items in QuickBooks Time.

 

Once you've completed these steps, you can run and utilize the itemized total time report. This report displays the total hours tracked against each job or customer, including details about which team members worked on each task.

 

If you require additional help with managing your employees' time entries, please let us know, and we'll gladly assist you with the process.

Terms & ConditionsAccessibility statement