Manage your Employees’ time sheets in Excel and Import them into QuickBooks!
Use this addin to quickly enter time in Excel for individual employees or groups of employees. Or 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 one time sheet so you can copy/paste time from one employee to another to speed data entry.
- Support for employee and vendor time sheets. Choose between no vendors, 1099 vendors only, or all vendors.
- Multiple time sheet templates included. Use one of the included templates or create your own custom time sheet templates.
- Enter start/stop time on time sheets. They Excel Timesheet add-in will automatically calculate total time worked.
- Batch-create multiple time sheets all at once for selected employees. Auto-save them as individual Excel workbooks for later use.
- Export multiple time sheets to a single IIF file for one import into QuickBooks!
- When paired with our Excel Email Manager, email time sheets directly to employees as they’re created.
- For quick data entry, pick lists are pulled from your company file and included on your time sheets. These include lists for employees, items, payroll items, classes, and customer:jobs.
- Automatic calculation for overtime and double time & now auto-selects overtime and double time items from your employee records or payroll item list – New!
- Automatically gets the default hourly or salary item from employees – New!
- Additional error checking to prevent error messages when importing into QuickBooks – New!
- Direct connect to QB to integrate lists with your company file – New!
Download this addin for a free trial, which allows you to try before you buy. You can use the trial to test the addin in your environment to create up to 100 individual transactions (e.g. 100 time records.) When you purchase then use your product key to unlock the trial to the full version.
4.07: Now export time records to IIF when the duration is 0.00 (but not blank.)
4.06: Add details to the IIF files created by the app to assist support.
4.05: Update connection error messages to include more details and updated help text.
4.04: Change code that finds the Excel custom Ribbon file.
4.03: Fix name loading/matching for very large names lists.
4.02: Fix issue with time list export and overtime calculation.
4.01: Enabled automatic OT calculation for multi-employee time sheets. Fix an issue with double-time calculation. Make integration prompt hide-able for a day. Update dialog windows for clarity.
3.99: Now find Jobs even when only the Job name is specified instead of the Customer:Job. Fix key display issue in the About & Purchase dialog.
3.98: Changes to accommodate QuickBooks 2019 and Enterprise 19.0
3.97: Changes to About & Purchase dialog to handle more than one product key. Fix for Excel 2016 to resolve issue where app would not load properly.
3.96: Changes when saving custom time sheets to prevent excel information messages about file formats.
3.95: Changes to connection method when pulling QB lists, especially when using 64-bit Excel. Now default to faster alternate connection method for all versions of Excel. It appears to be more reliable as previously implemented in the IIF Transaction Creator and other apps. Also, user interface changes for a better experience using newer versions of Excel.