Skip to main content
June 13, 2023
Question

Importing QB Pro Timer .iif files into 2023 Desktop

  • June 13, 2023
  • 2 replies
  • 0 views

Is there anyone running 2023 Desktop who has figured out how to import timer files from Quickbooks Pro Timer?  I upgraded from 2020, and suddenly I cannot import my time anymore. This is turning into a big problem.

2 replies

June 13, 2023

Hi there, @jbuchal.

 

With the launch of QuickBooks Desktop 2022 and Enterprise 22.0, some features are no longer available. As a result, importing timer activities are no longer available in QuickBooks Desktop, and it includes QuickBooks Pro Timer. 

 

As a workaround, you can consider looking the QuickBooks Desktop Marketplace, which features third-party applications developed by our independent developer partners.

 

You might also want to read this article to know more about the newly available features in QBDT 2023: What’s new in QuickBooks Desktop 2023.

 

If you have any other follow-up questions, let me know by adding a comment below. I'm more than happy to help. Keep safe!

jbuchalAuthor
June 15, 2023

It is unacceptable and illegal to remove long-standing features by deliberately crippling the software, especially when you are requiring an upgrade is required to maintain essential functionality (the loss of the banking interface).  I understand you want to push us to adopting QB online, but you have created an adequate incentive by more than tripling the cost of the desktop product.  I would have upgraded but for QB online's inability to import my Company file.  You need to fix this immediately.

BigRedConsulting
June 29, 2023

RE: Is there anyone running 2023 Desktop who has figured out how to import timer files from Quickbooks Pro Timer?

Yes, you can still import Pro Timer IIF files. However, in order to do so, they have to be carefully edited and the header row that identifies the file as a Pro Timer file must be removed. Then it'll import just fine.

 

To edit the IIF files, which are tab-delimited files, you can use a good text file editor that preserves the tabs. A simple one that will work is called Notepad2 (Windows notepad will not work). Notepad2 is free. See https://www.flos-freeware.ch/notepad2.html

 

The file will look something like this when opened in Notepad2 (though a timer file is not pictured):

Delete the rows that start with !HDR and HDR and then save the file.

Note that for IIF files containing time records that are not from the Pro Timer, import remains the same.

 

May 17, 2024

I tried converting it with excel and notepad but it did not work for me. I also tried QuickBooks time, but it does not work well for me. Primarily because it locks the day, once your approve the time and I bill as soon as we complete a job. PM

May 18, 2024

@paulmetz 

Do you need to import the Time Tracking data like this one?

NameTransaction DateCustomerService ItemPayroll itemDurationClassBillableNotes
John Marks01/09/2020Nguyen, TuanLaborRegular Pay1:25   
John Smith02/09/2020Nguyen, TuanLaborRegular Pay2:00   
Karen Marks02/09/2020Links, JohnLaborRegular Pay1:25