Manage your Employees’ time sheets in Excel and Import them into QuickBooks!
Note: This is a special version of the Timesheet Link which uses IIF files for list integration. Generally, we recommend the direct connect version has additional error checking to ensure smoother importing. If QuickBooks is not installed on your computer, or if the company file you will import time into is not available locally, this version of the Timesheet Link will work best.
————————————————————–
Use this add-in to quickly enter time in Excel for individual employees or groups of employees. Or have your employees fill out excel-based time sheets and then import into QuickBooks.
You can batch-create customized time sheets using Excel, email time sheets to employees, and then batch-import time sheets into QuickBooks. The Excel Timesheet also supports importing time records from other sources, such as time clock software.
Enter start/stop times in Excel. Time sheets will automatically calculate the time worked for import into QuickBooks.
Create time sheets for one or multiple employees. Or, include multiple employees on a single worksheet time sheet so you can copy/paste time from one employee to another to speed data entry.
Recent updates now include these features making this tool a solution for individuals & for time tracking administrators!
- Automatic calculation for overtime and double time.
- Support for Vendor time sheets. Choose between no vendors, 1099 vendors only, or all vendors.
- Enter start/stop time in time templates. They’ll automatically calculate total time worked.
- Multiple time sheet templates: Use ours or create custom templates!
- Batch-create multiple time sheets at once for selected employees. Auto-save them as individual Excel workbooks for later use.
- Batch email time sheets to employees (when integrated with the Excel Email Manager.)
- Export multiple time sheets to a single IIF file for one import into QuickBooks.
Free Trial
Download this add-in for a free trial, which allows you to try before you buy. You can use the trial to test in your environment to create up to 100 individual transactions (e.g. 100 time records.) When you purchase, you’ll then use your product key to unlock the trial to the full version.
Release Notes
3.68: Update the export to IIF success message to include advise on the recommended import steps.
3.67: Remove tab characters from the Memo/Description, item, and class fields because tabs are not allowed within fields in IIF files. Update installer code that configures the add-in within Excel.
3.66: Update the About & Purchase window with better messaging for key entry errors and other cases.