cancel
Showing results for 
Search instead for 
Did you mean: 
ccwadsworth
Level 2

Some activities from My Time not sent to Quickbooks & time calculations between My Time and Quickbooks

I am using My Time to track my time — and have been for years without incident. I just sent my recent activity to QuickBooks and not all of my activities are showing up. Complete days are missing. Any ideas?

So I exported the list and planned on adding the time manually then ran into another problem (if I need to post this separately, please let me know).

I can't figure out how the duration in My Time corresponds to the Quantity field in Quickbooks invoices. Can you help me figure out how that is calculated? For example, how does 1:33 from My Time show up as quantity of 1.71 in Quickbooks?

 

Appreciate your help, thank you!

Solved
Best answer February 16, 2019

Best Answers
JessT
Moderator

Some activities from My Time not sent to Quickbooks & time calculations between My Time and Quickbooks

Hi ccwadsworth,

 

Let's check if this is an issue with your company file. We'll run the Verify and Rebuild data utilities to check the integrity of your file and to resolve any damaged components that cause the missing data. You can follow the steps in this article: Resolve Data Damage On Your Company File.

 

If the Verify utility cannot detect any issues, please get in touch with our phone agents to check this further. They have a screen-sharing tool to help them see your setup and check this thoroughly. They can also check how your time quantity is being converted to a decimal value.

 

Here's how to get their number:

  1. Open this link: https://help.quickbooks.intuit.com/en_US/contact.
  2. Choose QuickBooks Mac Desktop.
  3. Select Using QuickBooks for Mac.
  4. Scroll down and click the Get Phone Number button.

If you have other questions, please don't hesitate to add a comment below.

View solution in original post

qbteachmt
Level 15

Some activities from My Time not sent to Quickbooks & time calculations between My Time and Quickbooks

For this Time Math: "how does 1:33 from My Time show up as quantity of 1.71 in Quickbooks?"

 

Pay attention to the Punctuation.

60 minutes = 1 hour

 

So, 1 minute = 1/60th as Decimal, or Fraction. Or, 1 minute as hours and minutes, using Punctuation.

 

1 hour and 30 minutes = 1 COLON 30

1 hour and 30 minutes = 1 POINT 5 (for 1 and one-half)

.1 of an hour = 6 minutes

33 minutes is .55

43 minutes is .71

 

Money is multiplied by Decimal Time, for currency values.

View solution in original post

4 Comments 4
JessT
Moderator

Some activities from My Time not sent to Quickbooks & time calculations between My Time and Quickbooks

Hi ccwadsworth,

 

Let's check if this is an issue with your company file. We'll run the Verify and Rebuild data utilities to check the integrity of your file and to resolve any damaged components that cause the missing data. You can follow the steps in this article: Resolve Data Damage On Your Company File.

 

If the Verify utility cannot detect any issues, please get in touch with our phone agents to check this further. They have a screen-sharing tool to help them see your setup and check this thoroughly. They can also check how your time quantity is being converted to a decimal value.

 

Here's how to get their number:

  1. Open this link: https://help.quickbooks.intuit.com/en_US/contact.
  2. Choose QuickBooks Mac Desktop.
  3. Select Using QuickBooks for Mac.
  4. Scroll down and click the Get Phone Number button.

If you have other questions, please don't hesitate to add a comment below.

qbteachmt
Level 15

Some activities from My Time not sent to Quickbooks & time calculations between My Time and Quickbooks

For this Time Math: "how does 1:33 from My Time show up as quantity of 1.71 in Quickbooks?"

 

Pay attention to the Punctuation.

60 minutes = 1 hour

 

So, 1 minute = 1/60th as Decimal, or Fraction. Or, 1 minute as hours and minutes, using Punctuation.

 

1 hour and 30 minutes = 1 COLON 30

1 hour and 30 minutes = 1 POINT 5 (for 1 and one-half)

.1 of an hour = 6 minutes

33 minutes is .55

43 minutes is .71

 

Money is multiplied by Decimal Time, for currency values.

ccwadsworth
Level 2

Some activities from My Time not sent to Quickbooks & time calculations between My Time and Quickbooks

Thank you very much Jess! I have following the procedures outlined in the link you gave me and it appears to have fixed the files. I will have to keep an eye on future submissions. I appreciate your prompt response and willingness to help, thank you!

ccwadsworth
Level 2

Some activities from My Time not sent to Quickbooks & time calculations between My Time and Quickbooks

Thank you for spelling this out for me, I appreciate it!

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us