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

Issue with Importing hours (time sheet) from 3rd party - eSub

We use a 3rd party app - eSub - to import weekly hours to do our payroll in QB. It was working fine in Enterprise v 2021. After we upgraded to 2022, the Timer Activtity in the Utilities - Import was gone in QB. - so we used iif. Since then, we have 3 employees's data that are not being exported, we contacted eSub support and they say that nothing has changed on their side and it has to be QB side after the upgrade to 2022. 

I can send you a copy of error message - your help is very much appreciated. Thank you.

 

 
12 Comments 12
ChristieAnn
QuickBooks Team

Issue with Importing hours (time sheet) from 3rd party - eSub

Hi there, Mal2020.

 

Thank you for visiting again the QuickBooks Community. I'll be providing details on how upgrading works in QuickBooks Desktop. Then, to ensure that you'll be able to achieve your goal. Beforehand, may I ask the specific error message you're referring to? I appreciate any further details so I can provide accurate solutions.

 

When upgrading QuickBooks Desktop, you'll need to know the system requirements. This is to ensure that everything's compatible before the activation to avoid any issues when utilizing the system. 

 

On the other hand, Importing and exporting.IIF files in QuickBooks Desktop are easy and the system formats the file for you. However, adapting data from another program is technically complicated because you can only import a certain number of list items and transactions. That said, importing hours or timesheets isn't possible in QBDT. You can click on this article to see further details on how IIF works in our software: Export, import, and edit IIF files.

 

Additionally, you have the option to manually create a weekly timesheet to track hours in QuickBooks Desktop. This is to make sure that the timesheet will appear in the system.

 

Lastly, you may refer to this article to view different details on what features are included in the QuickBooks Desktop 2022 release and how you can use them to benefit your business: What’s new in QuickBooks Desktop 2022.

 

If there's anything else I can do for you about managing your data, please don't hesitate to leave a comment below. I'm a post away to help. Keep safe!

Mal2020
Level 2

Issue with Importing hours (time sheet) from 3rd party - eSub

Thank you, Christie Ann,

Please see the error message - I couldn't attach the file because it's in notepad, so I just copied the first few lines

 

*** YOUR IIF FILE COULDN'T BE IMPORTED ***   
;
;Some of your records have errors.
;
;1. Search for the errors by typing "[ERROR]" to see only the failed records.
;
;2. Fix the errors and try to import the file again
;
;-----------------------------------------------------------------------------
;
;
!TIMEACT DATE JOB EMP ITEM DURATION PROJ BILLINGSTATUS NOTE PITEM
; [ERROR] The record at (or starting at) this line could not be imported. The name "Bac Mutzus, Domingo" of the list element is already in use. [3100] 
TIMEACT 2/3/2022 JL Construction, Inc.:21-43 - Los Medanos ES Bac Mutzus, Domingo Construction 8:0 1 Laborer Reg Rate
; [ERROR] The record at (or starting at) this line could not be imported. The name "Bac Mutzus, Domingo" of the list element is already in use. [3100] 
TIMEACT 2/3/2022 JL Construction, Inc.:21-43 - Los Medanos ES Bac Mutzus, Domingo Construction 0:30 1 Laborer OT
MirriamM
Moderator

Issue with Importing hours (time sheet) from 3rd party - eSub

Thanks for getting back and providing detailed information about your concern, @Mal2020.

 

The error message you receive when importing is related to how your file is created. To ensure you'll successfully import the IIF file, ensure to verify the file first. Double-check the account names used, the spelling and any other typographical error. You must confirm that the names used exist and are acceptable in QuickBooks.

 

You'll want to download the sample .IIF file in the article I'm including below and check to make sure your format is correct as the file name corresponds with the transaction type you're importing. 

 

Additionally, to learn more about importing IIF files, here's an article that you can read: Export, import, and edit IIF files.

 

If you have any questions about importing in QuickBooks or have any questions at all. You can reach me at any time by replying below. I look forward to hearing how these steps worked for you. Have a great day!

Mal2020
Level 2

Issue with Importing hours (time sheet) from 3rd party - eSub

 Yes, we did match all the names and still the same error.

Fiat Lux - ASIA
Level 15

Issue with Importing hours (time sheet) from 3rd party - eSub

@Mal2020 

It's very likely that your app doesn't support QBD 2022 yet. You should explore another 3rd party app to isolate the problem.

Mal2020
Level 2

Issue with Importing hours (time sheet) from 3rd party - eSub

Sadly, that's not an option.

Is there a work around to make it work without switching to another app?

 

 

Archie_B
QuickBooks Team

Issue with Importing hours (time sheet) from 3rd party - eSub

Thank you for following-up, Mal2020.

 

Let me get you to the right person who can assist you further in importing the IIF file into QuickBooks Desktop (QBDT).

 

Since you did make sure all account names used, the spelling are correct but you still have the same error, I'd suggest contacting our Support Team. They have the right tools to guide you in a secure environment and make sure you import the data QuickBooks.

 

Here's how:

 

  1. Go to QuickBooks Help menu.
  2. Choose QuickBooks Help.
  3. Click on Contact Us.
  4. Give a brief description of your concern, then select Let's talk.
  5. Choose a way to connect:
  • Start a chat with a support expert.
  • Get a callback from the next available expert.

 

For more details you check this link: Contact QuickBooks Desktop support.

 

Once you've successfully imported those data, you can run a report to check all information are correct: Create a payroll summary report.

 

Let me know if you still have other questions about importing data to QBDT. I'll be happy to help. Have a good day!

Mal2020
Level 2

Issue with Importing hours (time sheet) from 3rd party - eSub

Thank you, I will try that again.

I have done that a couple of times and none of the support people I talked didn't know what's going on and gave me similar solutions like you guys did. That's why I posted my problem in this platform.

ZackE
Moderator

Issue with Importing hours (time sheet) from 3rd party - eSub

Thanks for getting back with the Community, Mal2020.
 

In the event our Customer Care team can't solve your issue with importing hours from eSub, they'll be able to create an investigation ticket for our Product Investigations team to research further. They'll also add your account to it as an affected subscriber and send email notifications.
 

I'd also recommend reaching back out to the app's manufacturer if necessary. It's possible their application might not be functional with QuickBooks Desktop 2022 yet.
 

You'll also be able to find many detailed resources about using QuickBooks in our help article archives.

 

The Community's always here to help as well. Please don't hesitate to send a reply or create a new thread if there's ever any questions. Have a wonderful day!

Mal2020
Level 2

Issue with Importing hours (time sheet) from 3rd party - eSub

Will do, thank you all for your help.

Johnolly2
Level 1

Issue with Importing hours (time sheet) from 3rd party - eSub

I'm having the same problem. Has anyone come up with a solution yet? 

Kevin_C
QuickBooks Team

Issue with Importing hours (time sheet) from 3rd party - eSub

Hello there, @Johnolly2.

 

It seems that you've replied to the same concern twice, and my colleague has already added a response. If you haven't been notified of the new reply, here's the link: https://quickbooks.intuit.com/learn-support/en-us/employees-and-payroll/re-error-code-3100/01/143105...

 

Feel free to leave a comment if you need more help with QuickBooks. The Community team always has your back.

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

Need to get in touch?

Contact us