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.
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.17: Fix issue with Customer:Job changes in 4.16 where Customer:Job wasn’t being included in the IIF file.
4.16: Make sure time sheet and time list subtotal rows aren’t seen as time rows when exporting. Add option to reorder and sort the Customer:Job list by Job:[Customer] for easier data entry.
4.15: Set and correctly display good through date in About dialog for certain upgrade paths.
4.13: Updates name mapping logic. Made the mapping dialog wider for improved usability.
4.12b: Installer updated related to integration issues.
4.12: Make sure that Jobs names entered on the time sheet are not too long and they are formatted correctly with no spaces between the name levels – in the format [Customer]:[Job] – when written to the IIF file.
4.11: Resolve QuickBooks integration issues with recent QB patch releases.
4.08: Handle issue when integrating to avoid QB crash.
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.