Integrating QuickBooks with At Your Service

This article will describe the configuration and setup of QuickBooks integration with At Your Service Repair Center software.

QuickBooks integration is an optional feature that you may purchase for your license.  Please contact us for a quote if you are interested in adding this feature to your license.

Open Your Company File

Begin by launching both AYS and QuickBooks.  Open both your company database in AYS and your company file in QuickBooks.

In the AYS Menu, click on “Export – To Quickbooks – Export Options”.  The QuickBooks Options form will open and give you step-by-step instructions in configuring integration with AYS.

Quickbooks Options Form

Click on “Get Company File from QuickBooks”.  If you have QuickBooks running, it should retrieve the company filename automatically.

Troubleshooting

If you see the following error when trying to get the company file even though Quickbooks is running, ensure that you are not running Quickbooks as the Windows Administrator. If this is the case, Windows will not allow AYS to communicate with Quickbooks.

Quickbooks Automation Error

You may need to update the Integrated Applications within Quickbooks as described in the next popup dialog.

Setup QuickBooks Application Security

You can find this in your Quickbooks preferences, it may look something like this.

QuickBooks Application Security Settings

The application settings have already been applied in this example.

Create Codes to Match AYS Codes

Next, return to the Quickbooks Options screen in AYS and click “Get Default Codes from QuickBooks”.

After a few seconds, you should be brought to the first of the configuration tabs, “Items”.

QuickBooks Item Codes

Enter the codes in each of these fields.  All fields are required.  Be sure not to leave any blank, otherwise you will get errors when exporting.  You can click “Create 0% Tax Item” to automatically create an item in QuickBooks to match this code.

When all fields are filled, click on the next tabs to fill in the information for your company.  Click the “Create Missing Payment Methods” and “Create Missing Payment Terms” buttons to create any items that are not yet in your database.

QuickBooks Profile Codes

Once this is all done, click “Save”.  Now you can export your Customers and Vendors first by choosing “Export – To Quickbooks – Customer Accounts” and “Vendor Accounts”.  After that you can export Invoices and Purchase Orders from this same menu.

Which editions and versions of QuickBooks is AYS compatible with?