Troubleshooting Import Issues
These are the most common reasons an import might fail and their solutions. Customer service can help if your problem isn’t solved below. Contact us at 800 770-4959.
- The Timesheets.com Importer App won’t start and you get an error message. This can happen when you fail to install the second file from the setup instructions. Return to the export setup page in Timesheets.com and re-download the Timesheets Importer App setup file. Re-open the file and make sure to run the named QBFC11. That file is necessary before our importer can connect to QuickBooks.
- Time tracking isn’t enabled inside QuickBooks. To fix this, in QuickBooks, click edit, preferences. Select Time & Expense section and the Company Preferences tab. Make sure the ‘Do you track time?’ question is set to Yes. If this is not enabled, the importer application log will indicate that time can’t be imported because the feature is not enabled.
- The CSV File won’t load into the Importer App. When the CSV file doesn’t load, it’s usually because the file was opened in an editor such as Excel, and then saved. Opening the CSV export file before saving it alters the format. In order to avoid this problem, re-export the file and save it directly to your hard drive without opening it first. Advanced users who want to make direct changes to the file should use a plain text editor like Notepad and should avoid changing the format of the data in any way.
- The import completes, but a window pops up saying “Not all data was imported successfully”. This message usually occurs when you try to import data, but someone’s weekly timesheet is being edited in QuickBooks. You cannot import data to a timesheet that’s also currently open and being edited in QuickBooks. If you try, data will import for other timesheets but not the one in QuickBooks. You’ll need to close the weekly timesheet in QuickBooks, then re-export the payroll report for just that user and complete your import again. Be careful not to import the entire original file a second time or you will duplicate entries for all the rest of your workers.
- An window pops up at the end of the import with one or more specific error messages about your data. There are several reasons an error window could display, but all are easily fixed. Read the first message to determine what type of error it is and compare to the below options. Repeat this process until all the error messages are gone when you try your import.
- Missing Service Item. Check that the Service Item is on the Item List in QuickBooks and that it’s TYPE is Service and not some other type.
- Missing Payroll Item. Check the spelling and capitalization of your payroll items in QuickBooks, and that they are properly assigned to each employee. Also check that they match the spelling and capitalization of payroll items in the Timesheets.com Importer App Settings. We recommend using Copy/Paste to ensure exact matching.
- Missing Employee ID. Check that you have an employee ID in QuickBooks and a matching ID in Timesheets.com. If an ID is missing in Timesheets.com, add the ID in user settings and re-export your file.
- Error message appears: Object reference not set to an instance of an object. A vendor or other list item is not properly setup in QuickBooks. Some special characters like the & sign may not work in vendor or other list item names. If you experience mismatch problems, try removing special characters from both lists (Timesheets.com and QuickBooks) and then try you import again.