Timesheet import mismatch

Thanks for taking the time to reach out to the QuickBooks Community, @drjsparker.

How are you doing today? I hope all is well. 

I recommend checking that your time format matches with Excel. In QuickBooks Desktop there are two format options:

1. Decimal: This uses the base 10 number system (0-9) to represent time. For example: one-half of one hour would be written as “.5” instead of 30 minutes.
2. Time: This uses 60 minutes to represent one hour (or one whole). For example: ¾ or “.75” of one whole is 45 minutes (of one hour).

Here's how you can check your format in QuickBooks Desktop:

1. Click on Edit From the top menu.
2. Choose Preferences.
3. Select the General tab
4. Click on the Company Preferences tab.
5. Under the Time Format section, tap on Decimal or Minutes.
6. Hit OK to save your changes. 

You can also utilize a 3rd party importer tool instead of using Excel. If this is something you're interested in, please use the link I'm including below to explore our 3rd party apps.

• QuickBooks App Store

Please don't hesitate to let me know if you have any additional questions or concerns. Take care, and have a wonderful day! 

It is set to use the decimal format.

I opened the Excel file that I'm importing using Wordpad (attached) to confirm that the number is in fact 5.31, but after it's imported into QB it shows as 5.32.

Thanks for circling back to this thread, drjsparker. I've got additional insights about imported timesheet data in QuickBooks Desktop (QBDT).

QuickBooks stores time data in minute intervals, regardless of how you input or import time data. Even if you've set it in decimal format, some decimal equivalents won't saved exactly. It is because decimals display hundreds of an hour, while there are only 60 minutes in an hour.

As a result, the time is rounded to the nearest minute when saved and then displayed as the closest decimal equivalent to that saved value. We recommend manually editing your time entries once imported to QBDT to ensure accurate employee work hours.

Moreover, I can see how this feature would be helpful for you and your business. I recommend sending this suggestion to our product development team. The more requests we receive about a specific feature, the more likely it gets implemented.

Here's how:

1. At the top, select the Help menu.
2. Choose Send Feedback Online and click Product Suggestion.
3. Type in your feedback or feature request.
4. Click the Send Feedback button.

Finally, QuickBooks offers a selection of payroll reports to view your employee's total earnings, deductions, and tax details over time. Reference this article for a complete list of available payroll reports containing instructions on how to access them: Run payroll reports.

Properly recording employees' work hours is essential to complying with wage and hour regulations. Comment below if you require additional assistance importing employees' hours to QBDT. We'll be happy to lend a hand again. Stay safe!

Thank you for the insight!

What doesn't make sense is that if I import 5.31 for example, it will post to the employees Timesheet as 5.32; whereas if I manually import 5.31 it will save as 5.31.

If it were a rounding issue, I would expect it to change it to 5.32 regardless of whether it was manually inputted or imported.

As well, being that this is a payroll issue with significant consequences if the payroll is incorrect, I can't imagine that Intuit wouldn't have a resolution for this.

Is there another issue that could be causing this that's being overlooked?

Data damage can also cause inconsistencies when importing files and hours into QuickBooks Desktop, drjsparker. For someone who runs payroll, making sure that the hours are accurate down to the last second is very important, as this directly affects employee payments.

Let me provide the steps that can resolve the most common data issues in the software.

Start by making sure that your QuickBooks is on the latest maintenance release. This fixes for minor bugs and program issues, which can significantly improve the software's performance and reliability.

Use this article as a guide: Update QuickBooks Desktop to the latest release.

Then, install and use the QuickBooks Tool Hub. This utility tool is specifically designed to resolve a wide array of program and file-related issues that could be causing the hours to round off when importing in QuickBooks.

Here's how to use it:
  

1. Download the most recent version (1.6.0.8) of the QuickBooks Tool Hub.
2. Open the file you downloaded (QuickBooksToolHub.exe). You can look it up in your Downloads folder or in the location you selected when you downloaded it.
3. Follow the on-screen steps to install and agree to the terms and conditions.
4. Double-click the icon on your Windows desktop to open the tool hub.
5. Once opened, look for Company File Issues or Program Problems, then select Quick Fix my Program.

Please check out this article for additional details: Fix common problems and errors with the QuickBooks Desktop Tool Hub.

After using the tool, import the hours one more time to check if it's no longer rounding off.

Let me also share these articles in case you might need them when working with employee hours in QuickBooks Desktop:

• Create a total hours worked by employee report
• Set up and pay overtime based on different hourly rates

The Community is always here if you have other questions when dealing with employee payments, importing data, or any other payroll-related tasks. We're committed to providing guidance and assistance whenever you need it.

I went thru the above steps, but it did not solve the problem

I went thru the steps above, but it did not solve the problem.

Hello drjsparker,

Thank you for connecting with the QuickBooks Community! I appreciate you going through the steps. Since the issue persists, I highly recommend contacting our Support Team to take a deeper look. They have tools such as screen sharing to assist you as well. Here's how:

1. Log into your QuickBooks account.
2. Click the Help option in the upper-right corner.
3. Enter the necessary information and click Continue.
4. Choose a way to connect.

Please keep me updated! If you have any other questions, I will be around. Take care for now!