Skip to main content
KLEACH1
KLEACH1
February 20, 2025
Question

Verification file in Quickbooks desktop

  • February 20, 2025
  • 3 replies
  • 0 views

We have Time Clock plus now for almost 3 years and from about the last 6 months when I have a new hire the hours do not import correctly into my QB desktop and TCP tells me the verification file in QB needs to be updated. I am not sure if they are talking about my import IIF file that I use to import into QB. Has anyone else had this issue? I am just manually putting the new hire times in but all my other long time employees time imports correctly from the time sheet. I have updated to version 24 in QB and still doesn't work.

HELP!

Thank you in advance.

Karla

3 replies

G
GlinetteC
February 20, 2025

I acknowledge the challenges you're having with importing new hire hours from Time Clock Plus to QuickBooks Desktop, Karla. And I'm here to help point you in the right direction. 

 

Since TCP has mentioned the need for an updated verification file in QuickBooks, it likely relates to the IIF file used for importing data. To resolve the import issue effectively, I recommend contacting TCP support directly. They can guide you on the specific updates required for the verification or IIF files involved in the process.

 

I'm sharing this article about importing and exporting data in QuickBooks Desktop to learn more about the limitations: Import and export data in QuickBooks Desktop.

 

Additionally, you can generate payroll reports. This offers a detailed view of your payroll expenses, which is essential for any company looking to sustain a strong financial standing and keep employees happy.

 

If there's anything else you need help with, Karla, please don't hesitate to add them in the comments. The Community is always here to assist.

    KLEACH1
    KLEACH1Author
    February 21, 2025

    I did contact TCP and that is what they told me was QB needed to update the verification file but I figured out the issue, I need to check in the new hire payroll set up to use time data to create paychecks. I have never checked this before so it must have had a update that requires that to be checked with all my new hires.

    I hope this helps anyone else that has had issues with importing time from other vendors.

    C
    Chrea
    February 21, 2025

    Run the Verify/Rebuild Data utility in your QB Desktop. Did you encounter any unresolved error messages?

      KLEACH1
      KLEACH1Author
      February 21, 2025

      Yes, I did run that and came back fine. No errors. But I did figure out the issue.

      G
      GilbertFox33
      February 21, 2025

      The problem could be with how the IIF file is structured or how QuickBooks processes new employee records.

       

      First, check if new employees are fully set up in QuickBooks before importing the file—meaning their names match exactly in both QuickBooks and TCP. Any slight difference (extra space, missing middle initial) can cause QuickBooks to reject the data.

       

      Second, try opening your IIF file in Excel or Notepad and compare the entries for old employees versus new ones. Look for any missing fields, incorrect formatting, or variations in how employee data is listed.

      If TCP specifically mentions the verification file, they may mean that QuickBooks' company file needs a rebuild. Try running File -> Utilities -> Verify Data and then Rebuild Data in QuickBooks to fix any underlying corruption issues.

       

      Since you've updated to QuickBooks 24 and the problem persists, it might also be worth testing a manual import of a single new hire's hours using a test IIF file.

       

      Hope this helps!

        Terms & ConditionsAccessibility statement