NOTE: we only map hours over to the default items you see listed in this sample.

Open your QuickBooks session→ Go to the Employee Center→ Select an employee from the list and go to ‘Payroll Info.'→ In Earning Codes enter in the default payroll items, and check the box ‘Use time data to create paychecks’ is checked to run Payroll. The Import tool is only compatible with Microsoft-based computers no tool is available for MAC users. We are not compatible with Contractor Editions of QuickBooks Desktop We do not send over salary hours at this time, only hourly payroll items will be sent to QuickBooks Desktop. Your payroll items must be labeled as the following: Hourly, Overtime (x1.5) hourly, Double-time hourly, Triple-time hourly, Hourly Vacation, Hourly Holiday, Hourly Sick, and Hourly Personal. The QuickBooks Desktop Importer will only send time to the default payroll items in QuickBooks Desktop. This includes jobs, projects, customers, tasks, and department information. Job & costing information cannot be sent to Quickbooks Desktop. For example, make sure you have fully reconciled all bank accounts and applied open credits to the correct invoices or bills. Tidy up QuickBooks data - If you need to do accounting work to tidy up the file, do it before you convert to Xero.

To import a CSV file into QuickBooks you need to download the Ontheclock QuickBooks Importer from our website. It can be downloaded here.įor help setting up your QuickBooks Desktop import tool and getting hours from OnTheClock into QuickBooks, watch our setup video here. Now that you have checked we can convert your QuickBooks file, prepare your QuickBooks accounts.

Settings & Applications in QuickBooks Desktop QuickBooks Desktop Importer Tool Instructions YouTube - Using the QuickBooks Desktop Importer OnTheClock offers a QuickBooks Desktop Import tool for download to help you seamlessly send your hours from OnTheClock to your QuickBooks Desktop account.

Import qb file into qb for mac