Accounting: Connect to QuickBooks DESKTOP

May 12, 2015

Vijay Brihmadesam

Forget about the manual data entry (QuickBooks Desktop)!

We are excited to announce our integration with QuickBooks desktop today (for QuickBooks ONLINE click here).

This should save you/bookkeeper at least 10-15 hours a month and clean up your books as you will now be able to easily split a bill to multiple expense categories and/or classes.

With this integration you will now be able to:

  1. Sync all your bills to your company file in QuickBooks.
  2. Classify each line item by expense catagory and/or class. We will remember it so next time we seem that line item we will automatically code it for you!
  3. Sync all your vendors with QuickBooks.
  4. Sync all pamyments into Quickbooks along with check numbers so that matching it to your bank account becomes a matter of seconds not minutes

Painless Setup

Here is how to set it up in 15 steps (takes about 10-15 mins to get it going!). Note that the initial setup must be done on a WEB BROWSER and CANNOT be done on mobile, tablet, or Clover.

  1. Login to your billSync account and go to the top right corner and click on the gear icon, then click accounting.

    Show/Hide Screenshot

    Screen Shot 2015-04-20 at 6.13.21 PM
  2. Click connect to Quickbooks Desktop.

    Show/Hide Screenshot

    Screen Shot 2016-06-29 at 6.18.34 PM
  3. Type in any password. You will need to use in about 2 minuites

    Show/Hide Screenshot

    Screen Shot 2016-06-29 at 6.18.48 PM
  4. Open QuickBooks and make sure the company you want to connect billSync to is open.
  5. Then open QuickBooks Web Connect. Some times this is located within QuickBooks Desktop by going to File -> Update WebServices

    Show/Hide Screenshot

    image-7
  6. Click add application and pick the billSync file you just downloaded.

    Show/Hide Screenshot

    image-6
  7. Accept the agreement.

    Show/Hide Screenshot

    image-10
  8. Give billSync access to sync bills. We recommend picking this option: Yes, always; allow access even if QuickBooks is not running.

    Show/Hide Screenshot

    image-5
  9. Type in your password (the one you set in step 3), click save password, check the box next to the application, now click update selected for the first time (this time we are just pulling your company name to make sure we only sync to that company in the future), do this 1 more time to get the initial setup completed. The second time we are pulling your chart of accounts so that way you can set the defaults on billSync.

    Show/Hide Screenshot

    image-3

    image-2

  10. Now login to billSync and go back to the accounting tab, if you are still logged in from step 3 just click refresh. Then click edit under Bill Management Defaults. Here you can choose the default bank account, accounts payable account, and expense category. These will be used if you have not set something otherwise.

    Show/Hide Screenshot

    Screen Shot 2016-06-29 at 6.23.33 PM
  11. If you have already processed a few bills with billSync click on the vendors menu next, Click into each vendor and then click the accounting tab. Here you can set vendor defaults at the top, and defaults for each item individually below.

    Show/Hide Screenshot

    Screen Shot 2015-04-20 at 6.18.07 PM

    Screen Shot 2015-04-20 at 6.19.33 PM

  12. Now you have all your expense accounts setup, hit update selected on quickbooks webconnect.

    Show/Hide Screenshot

    image-1
  13. You should see the vendors getting pushed to your Quickbooks Company file.

    Show/Hide Screenshot

    image-8
  14. Click “update selected” once more and your bills from billSync should appear!

You are done, billSync will automatically run in the background every 2 hours so your blooks are always up to date! NO MORE DATA ENTRY!

Let us know if you have any issues or would like us to add something to make your life easier by emailing us at hello@bill-sync.com.