TSheets Integration with QuickBooks Desktop and Online

Intuit created and sells the accounting software suite which is known as QuickBooks. Small and medium-sized businesses are the primary […]

Voiced by Amazon Polly

Intuit created and sells the accounting software suite which is known as QuickBooks. Small and medium-sized businesses are the primary target market for QuickBooks products which includes cloud-based payroll services, on-premises accounting software, and versions that accept payments from clients.

Save Time, Reduce Errors, and Improve Accuracy

Dancing Numbers helps small businesses, entrepreneurs, and CPAs to do smart transferring of data to and from QuickBooks Desktop. Utilize import, export, and delete services of Dancing Numbers software.

As long as, you have an Internet connection, QBO enables you to access your file from any location. While only the computer or network where the file is installed can access the company data using the Desktop version.

A useful time-tracking tool that can be connected with QuickBooks is TSheets. The primary goal of this connection is to synchronize QuickBooks and TSheets operations in order to increase user convenience.

About TSheets (QuickBooks Time)

  • TSheets is a QuickBooks time tracking tool which is used to notify staff members, schedule tasks for staff members, and track the time of staff members.
  • You can easily sync your employee’s precise time tracking information for billing and payroll by integrating TSheets into the QuickBooks platform. Utilizing the QuickBooks TSheets integration has additional advantages like interactive reports and team management.
  • The QuickBooks Time & Expenses is the platform in which, this integration can be carried out. Additionally, the users can initiate the integration by selecting the Feature of Add-ons option in TSheets.

Requirement of the Integration

The things for which you have to take care before starting the integration or setup in QuickBooks are:

  • First of all, you need access of the admin. You should verify that you are signed in as the administrator, who has all the privileges.
  • The Full Payroll options must be enabled.
  • Always make sure that you “Use Time Data to Create Paychecks“, the checkbox is selected for both each active employee and corporate preferences.
  • You must have the option to enter Single-user mode whenever necessary.
  • In both TSheets and QuickBooks, the week must begin on the same day.
  • Every employee must be set up with a minimum of one payroll item; otherwise, the transfer will not be completed.
  • All users who require time to be exported into their QuickBooks account are added to QuickBooks as employees or vendors.
  • Since the synchronization of QuickBooks Desktop and TSheets is done in a single location, the system you are using is compatible with it.
  • QuickBooks Integration Add-on must be installed properly.

Advantages of QuickBooks TSheets Integration

Followings are the benefits which you can get from the TSheets Integration with QuickBooks Desktop, Online and other versions:

Tracking of Cost of the Labor as well as Jobs

You have given tasks to your staff like projects, clients, job codes, etc. Once you are done with the allotting of tasks to the staff then you can keep track of expenses as well as revenue.

Tracking of the Time

When QuickBooks interacts with TSheets, It is possible to sync the data of your employees. Your employees’ locations will be found as soon as they arrive at the job site.

Billing can be done in Advance

You can create better, more accurate invoices with the help of the TSheets and QuickBooks integration. The invoices may also be created in great detail as you require.

Real Time Report

You may create real-time reports with the help of TSheets interface with QuickBooks. It becomes simpler to quickly assess your employees’ performance in real time.

Payroll is Managed Smartly

The TSheets interface makes managing payroll simple. As a single-user interface, handling the payroll tasks is simpler.

Integration of TSheets with QuickBooks Desktop

For combining the QuickBooks Time and QuickBooks Desktop, you have to complete a number of procedures. First, you have to take some crucial changes to your QuickBooks Desktop and QuickBooks Time accounts. After that, you can log in and install the TSheets QuickBooks Desktop integration add-on on the same computer. As you integrate QuickBooks Time with the QuickBooks account, be sure to follow the instructions properly.

Step 1: Creating of Required Settings

You should set up your QuickBooks Time and QuickBooks Desktop accounts before integrating TSheets with QuickBooks Desktop. You must make all the necessary adjustments for integrating TSheets with QuickBooks Desktop. To make the necessary adjustments to QuickBooks settings, read the instructions which are given below.

  • First, You have to make sure that your QuickBooks account has the “Full Payroll” feature enabled.
  • Then, confirm that QuickBooks Time and QuickBooks Desktop have the same week start date.
  • Each current employee’s “Company-wide” selection should have the “Use Time Data to Create Paychecks” and the option is checked.
  • Users must ensure that each employee is created with at least one payroll item; otherwise, time normally cannot be transferred.
  • Make sure you sign in as an administrator to the QuickBooks account.
  • In QuickBooks Desktop, you also need to switch towards “Single User Mode.” Because the syncing process can only be carried out on a single computer, users should make sure they are on the same computer as the one you will use to sync QuickBooks Desktop and QuickBooks Time.
  • Additionally, all users that need their time exported to QuickBooks must be added as “Vendors” or “Employees.” Admin can be added if necessary.

When you want to combine QuickBooks Desktop with the QuickBooks Time account, you need stick to these guidelines. If you don’t already have one, you can download QuickBooks Time to your computer.

Step 2: Login to the Same Computer

It is important that you use only the system on which you are synchronizing QuickBooks Desktop and QuickBooks Time. Here are some actions which you should take:

  • First you have to open “QuickBooks Desktop“.
  • Launch the QuickBooks Desktop “Company File” which you want to connect to your QuickBooks Time.
  • Then sign in as the primary administrator.
  • Make sure “Single-User” mode is selected.
  • Once finished, log in with administrator privileges to “QuickBooks Time.

Step 3: Installing of the Add-on of TSheets QuickBooks Integration

Installing the add-on is the most important step in integrating QuickBooks Time with QuickBooks Desktop properly. To simplify your procedure, we’ll use the Web Connector app in this instance. You can, however, integrate QuickBooks Time and QuickBooks Desktop directly.

  • Click the “Feature Add-ons” button on the left, once you opened the “QuickBooks Time” account.
  • Then select “Manage Add-ons” from the menu.
  • Search for “QuickBooks Desktop Integration“.
  • Select “Install” from the menu.
  • You can select options by clicking this link. After making your selections based on the information you want to include, click “Next.
  • You can read the following selections if you’re curious about all the choices that are available.

Please be aware that you can modify these choices by visiting the “Preferences” section:

All the Users are Deleted:

Employees that have already been added to QuickBooks Time will not automatically be connected to the QuickBooks account. As a result, you might choose to archive personnel during your initial sync.

Importing of the Customers and Job:

You can import all of the open jobs and customers into the QuickBooks Time account by choosing the option of importing. The employees will be able to simply track the time spent on them. You can allocate them to specific employees or the entire workforce.

Showing the Service Time:

This option will bring up a list of service items so that staff can select them while keeping track of their time.

Showing of Billable:

This choice specifies whether or not the time is billable.

Importing of Vendors as Employees:

Choose the option to import them as users into your QuickBooks Time account if you have “Contractors and Vendors” who want to monitor time.

Showing Class:

When this option is chosen, a selection of classes is displayed for your employees to select from when keeping track of their time.

Following these choices will cause the initial sync to remove any customers or jobs you have created in your QuickBooks Time account before integrating them.

  • You might receive a warning prompt. If you want to continue after seeing the warning message, all you have to do is write Delete and click the “Continue” button.
  • The “Web Connector” configuration comes next.
  • You must select “Advanced/Manual Setup” to do this.
  • Select the link that says “Web Connector.”
  • Open the downloaded file after that.
  • Then “OK” button will appear in a security window.
  • When a new security window appears, select “Yes, Whenever this QuickBooks Company is open” from the drop-down menu.
  • Select “Continue” from the menu.
  • Click “Done” when you see the access confirmation box.
  • Now locate the password in QuickBooks Time’s “Set up Web Connector” page.
  • After that, go back to the “Web Connector” screen and enter your account’s four-digit password before pressing the “Enter” key. Be careful to save the password when requested.
  • The “QuickBooks Time” app can now be checked off to the left.
  • Select “Update Selected” from the menu.

Your sync will be finished as soon as you complete these steps. The confirmation notice will also appear on your screen. In other words, here is how you can integrate TSheets with QuickBooks Desktop.

Integration of TSheets with QuickBooks Online

It is necessary to install the integration software in order to combine QuickBooks Time with QuickBooks Online. Once installed, the Preferences window will allow you to select the proper settings. Later, you can import the items from QuickBooks Online into your QuickBooks Time account. Once QuickBooks has mapped the payroll items, double-check them.

Let’s learn more about the TSheets and QuickBooks Online integration.

Step 1: Integration of TSheets QuickBooks Online with Add-ons

You must have the integration app installed on your account in order to combine TSheets with QuickBooks Online. There are two ways to obtain the app:

  • Either uses the Feature Add-ons option in QuickBooks Time to install the integration app.
  • Go to the Apps.com page to locate the QB Time Tracking app.

Getting of Integration App from QuickBooks time

  • Select the “Feature Add-ons” option from the menu on the left after opening the “QuickBooks Time” account.
  • Next, choose “Manage Add-ons” from the menu.
  • Search for “QuickBooks Online Integration” after that.
  • Select “Install” from the menu.
  • You can select “Connect to QuickBooks” from this menu. This will display Intuit’s sign-in page.
  • You may now access the account. If you have multiple businesses, decide which one you want to connect to your account.
  • When the prompt appears, select “Authorize” from the menu. You will see a notice stating “You are now connected” after which the “Preferences” page will appear for you to make the necessary adjustments.

Getting of Integration App from Apps.com

  • Browse to “Apps.com” page.
  • Search for “QuickBooks Time Tracking” after that.
  • Select “Learn more” from the menu.
  • You can choose which QB firm you wish to combine with your QuickBooks Time account when you see the prompt.
  • The “Setup QuickBooks Time Tracking” screen will then appear. You can start the free trial or sign in to an existing account here.

Step 2: For Importing the Items You have to Select Preferences

You can choose the items as the integration software is installed so that you can import them later from QuickBooks Online into your QuickBooks Time account.

For greater insights, adhere to following steps:

  • Select the items in the “Preferences” window. Here, you have the following choices:
    • Selecting this option will allow you to import all of the open jobs and clients into the QuickBooks Time account. The employees will be able to simply track the time spent on them thanks to this. You can allocate them to specific employees or the entire workforce.
    • Delete All Users: Employees who have already been added to QuickBooks Time will not be immediately connected to the QuickBooks account. As a result, you might choose to archive personnel during your initial sync.
    • Show Billable: This choice indicates whether or not the time is billable.
    • Vendors that want to track time can be imported as employees in your QuickBooks Time account by choosing the option to import “Contractors/Vendors” as users.
    • Show Service Items: Selecting this option will display the list of service items so that employees can select them while keeping track of their time.
    • Show Class: By choosing this option, a selection of classes is displayed for your employees to choose from while keeping track of their time.
  • If you consent to the deletion when prompted about it, type “Delete” when the warning message appears.
  • Push the “Next” button after that.
  • Select the date prior to which the timesheet would not be exported to QuickBooks Online from the “Exporting time to QuickBooks” section.

Step 3: Importing Id Data Form

Every minute, the modifications and additions performed in QuickBooks will be automatically imported into the QuickBooks Time. The automatic imports will be listed next to the sync log.

  • Navigate to “QuickBooks” and select “Preferences” if you wish to halt the import.
  • You can remove all the items you don’t want to be automatically imported from the “Automatically import changes to” list.
  • You can uncheck the “Automatically import for changes made in QuickBooks” option to make the automatic import grayed out.

Step 4: Mapping of Payroll item

You must select this option in your options if you want to use the payroll interface between QuickBooks Online and QuickBooks Time. It will automatically map them if you are importing the payroll item for the first sync. It is advised to inspect and make the necessary adjustments, nevertheless.

Employee, customer, class, or service item mapping is available for payroll items. The payroll elements can be chosen by your employees. The processes for mapping your payroll items by employee are listed below.

  • Visit “QuickBooks Time,” which is in the upper right corner.
  • Select “QuickBooks” from the menu.
  • Choose “Preferences” from the menu.
  • The “Employee Map” tab should be selected.
  • Select the employee’s name by clicking.
  • You can select one payroll item for each hour type column when you see them. The modifications you make automatically save.
  • Select the “Employee CSV” to download the spreadsheet.

We have shared carefully selected information in the aforementioned material to carry out the QuickBooks TSheets integration. QuickBooks connection is something you can do to make your payroll service intelligent. To simplify the setup, you can use this to pull your employee and company data from QuickBooks Online. Still if there is any query regarding this then you can connect with Dancing Numbers experts via LIVE CHAT, we will help you in resolving the issue.

Accounting Professionals, CPA, Enterprises, Owners
Accounting Professionals

Looking for a professional expert to get the right assistance for your problems? Here, we have a team of professional and experienced team members to fix your technical, functional, data transfer, installation, update, upgrade, or data migrations errors. We are here at Dancing Numbers available to assist you with all your queries. To fix these queries you can get in touch with us via a toll-free number
+1-800-596-0806 or chat with experts.


Frequently Asked Questions

Is QuickBooks Time Work with the QuickBooks Online?

Yes, QuickBooks integrates with QuickBooks Online Plus, Essential and advanced.

Is there is a Time clock Feature in QuickBooks?

Utilize QuickBooks Time to track time. You can make timetables with QuickBooks Time, and employees may clock in and out using a PC, laptop, or smart phone app from any location.

What are the Two Ways to Track Time using QuickBooks Time?

The hours of employees can be tracked in a variety of methods. There are numerous ways to use QuickBooks Time including manually entering time, utilizing the mobile app, or using the QuickBooks Time Kiosk. You can even connect your employee’s accurate time tracking data for payroll and invoicing by integrating this software with QuickBooks.

Features of Dancing Numbers for QuickBooks Desktop

Imports

Imports

Exports

Exports

Deletes

Deletes

Customization

Customization

Supported Entities/Lists

Dancing Numbers supports all QuickBooks entities that are mentioned below:-

Customer Transactions

Invoice
Receive Payment
Estimate
Credit Memo/Return Receipt
Sales Receipt
Sales Order
Statement Charge

Vendor Transactions

Bill
Bill Payment
Purchase Order
Item Receipt
Vendor Credit

Banking Transactions

Check
Journal Entry
Deposit
Transfer Funds
Bank Statement
Credit Card Statement
Credit Card Charge
Credit Card Credit

Employee Transaction / List

Time Tracking
Employee Payroll
Wage Items

Others

Inventory Adjustment
Inventory Transfer
Vehicle Mileage

Technical Details

Easy Process

Bulk import, export, and deletion can be performed with simply one-click. A simplified process ensures that you will be able to focus on the core work.

Error Free

Worried about losing time with an error prone software? Our error free add-on enables you to focus on your work and boost productivity.

On-time Support

We provide round the clock technical assistance with an assurance of resolving any issues within minimum turnaround time.

Pricing

img

Importer, Exporter & Deleter

*See our Pricing for up to 3 Company Files

$199/- Per Year

Pricing includes coverage for users
  • Services Include:
  • Unlimited Export
  • Unlimited Import
  • Unlimited Delete

img

Accountant Basic

*See our Pricing for up to 10 Company Files.

$499/- Per Year

Pricing includes coverage for users
  • Services Include:
  • Importer,Exporter,Deleter
  • Unlimited Users
  • Unlimited Records
  • Upto 10 companies

img

Accountant Pro

*See our Pricing for up to 20 Company Files.

$899/- Per Year

Pricing includes coverage for users
  • Services Include:
  • Importer, Exporter, Deleter
  • Unlimited Users
  • Unlimited Records
  • Up to 20 companies

img

Accountant Premium

*See our Pricing for up to 50 Company Files.

$1999/- Per Year

Pricing includes coverage for users
  • Services Include:
  • Importer, Exporter, Deleter
  • Unlimited Users
  • Unlimited Records
  • Up to 50 companies

Dancing Numbers: Case Study

Frequently Asked Questions

 
How and What all can I Export in Dancing Numbers?

You need to click "Start" to Export data From QuickBooks Desktop using Dancing Numbers, and In the export process, you need to select the type you want to export, like lists, transactions, etc. After that, apply the filters, select the fields, and then do the export.

You can export a Chart of Accounts, Customers, Items, and all the available transactions from QuickBooks Desktop.


How can I Import in Dancing Numbers?

To use the service, you have to open both the software QuickBooks and Dancing Numbers on your system. To import the data, you have to update the Dancing Numbers file and then map the fields and import it.


How can I Delete in Dancing Numbers?

In the Delete process, select the file, lists, or transactions you want to delete, then apply the filters on the file and then click on the Delete option.


How can I import Credit Card charges into QuickBooks Desktop?

First of all, Click the Import (Start) available on the Home Screen. For selecting the file, click on "select your file," Alternatively, you can also click "Browse file" to browse and choose the desired file. You can also click on the "View sample file" to go to the Dancing Numbers sample file. Then, set up the mapping of the file column related to QuickBooks fields. To review your file data on the preview screen, just click on "next," which shows your file data.


Which file types are supported by Dancing Numbers?

XLS, XLXS, etc., are supported file formats by Dancing Numbers.


What is the pricing range of the Dancing Numbers subscription Plan?

Dancing Numbers offers four varieties of plans. The most popular one is the basic plan and the Accountant basic, the Accountant pro, and Accountant Premium.


How can I contact the customer service of Dancing Numbers if any issue arises after purchasing?

We provide you support through different channels (Email/Chat/Phone) for your issues, doubts, and queries. We are always available to resolve your issues related to Sales, Technical Queries/Issues, and ON boarding questions in real-time. You can even get the benefits of anytime availability of Premium support for all your issues.


How can I Import Price Level List into QuickBooks Desktop through Dancing Numbers?

First, click the import button on the Home Screen. Then click "Select your file" from your system. Next, set up the mapping of the file column related to the QuickBooks field. Dancing Numbers template file does this automatically; you just need to download the Dancing Number Template file.

To review your file data on the preview screen, just click on "next," which shows your file data.


What are some of the features of Dancing Numbers to be used for QuickBooks Desktop?

Dancing Numbers is SaaS-based software that is easy to integrate with any QuickBooks account. With the help of this software, you can import, export, as well as erase lists and transactions from the Company files. Also, you can simplify and automate the process using Dancing Numbers which will help in saving time and increasing efficiency and productivity. Just fill in the data in the relevant fields and apply the appropriate features and it’s done.

Furthermore, using Dancing Numbers saves a lot of your time and money which you can otherwise invest in the growth and expansion of your business. It is free from any human errors, works automatically, and has a brilliant user-friendly interface and a lot more.


Why should do you change the Employee status instead of deleting them on QuickBooks?

If you are unable to see the option to terminate an employee on your list of active employees on the company payroll, this mostly implies that they have some history. Thus, if you change the employee status instead of deleting it on QuickBooks, the profile and pay records remain in your accounting database without any data loss in your tax payments.


Is it possible to use the Direct Connect option to sync bank transactions and other such details between Bank of America and QuickBooks?

Yes, absolutely. You can use the Direct Connect Option by enrolling for the Direct Connect service which will allow you access to the small business online banking option at bankofamerica.com. This feature allows you to share bills, payments, information, and much more.


Why should do you change the Employee status instead of deleting them on QuickBooks?

If you are unable to see the option to terminate an employee on your list of active employees on the company payroll, this mostly implies that they have some history. Thus, if you change the employee status instead of deleting it on QuickBooks, the profile and pay records remain in your accounting database without any data loss in your tax payments.


What are the various kinds of accounts you could access in QuickBooks?

QuickBooks allows you to access almost all types of accounts, including but not limited to savings account, checking account, credit card accounts, and money market accounts.

Get Support

Bulk import, export, and deletion can be performed with simply one-click. A simplified process ensures that you will be able to focus on the core work.

Worried about losing time with an error prone software? Our error free add-on enables you to focus on your work and boost productivity.

Close X
Call Now+1-800-596-0806
Top