How to Set up the Reckon / QuickBooks Desktop Accounting Link

The accounting link needs to be installed on the same PC where Reckon / QuickBooks Desktop software is installed on.

To download the accounting link for Reckon / QuickBooks Desktop, contact Simpro Premium Support.

To set up the accounting link:

1. Open the installer.
2. Follow the steps in the setup wizard to install the accounting link, then open it when the installation is complete.
3. Enter your Simpro Premium URL, username, and password.
   • Remove 'https://' from the beginning of the URL if required.
4. Click Continue.
5. In Reckon / QuickBooks Desktop, a window with the following message displays: "Do you want to allow this application to read and modify this company file?" Select Yes, always; allow access even if quickbooks is not running.
6. Click Continue.
7. When the Confirm to Proceed message appears, click YES, then click DONE.
8. Open the accounting link again, and the QB Items window displays. If your Simpro Premium items do not appear, click Add required line items to QuickBooks. Learn more in Set up required items.
9. Click OK.

To test the accounting link and ensure it is working:

1. Open Reckon / QuickBooks Desktop.
2. Open the accounting link.
3. In the accounting link, go to the Setup tab and click Test Connection.

If the test is successful, the accounting link is connected to Reckon / QuickBooks Desktop correctly.

Ensure you have set up your tax codes in Simpro Premium. To learn more, see How to Use Tax Codes. You also need a single tax code with a rate of zero percent to apply to any tax-exempt items on a job.

Set up required items

To use the accounting link, set up line items in Reckon / QuickBooks Desktop that correspond to your country's tax codes.

If you are in the United States, you do not need to have tax codes when you set up items.

United States

Item Name	Type	Tax Code	Account
simPRO Sales	service	Non	Any income account
simPRO Purchases	non-inventory part	Non	Any expense account

Australia

Item Name	Type	Tax Code	Account
simpro sale	service	GST	Any income account
simpro sale nogst	service	FRE	Any income account
simpro purchase	non-inventory	NCG	Any expense account
simpro purchase nogst	non-inventory	NCF	Any expense account
simpro freight	non-inventory	NCG	Any expense account

New Zealand

If you started using Reckon after 2010, use the following tax codes:

Item Name	Type	Tax Code	Account
simpro sale	service	S	Any income account
simpro sales nogst	service	E	Any income account
simpro purchase	non-inventory	S	Any expense account
simpro purchase nogst	non-inventory	E	Any expense account

If you started using Reckon prior to 2010, use the following tax codes:

Item Name	Type	Tax Code	Account
simpro sale	service	S	Any income account
simpro sales nogst	service	E	Any income account
simpro purchase	non-inventory	S15	Any expense account
simpro purchase nogst	non-inventory	E	Any expense account

United Kingdom

Item Name	Type	Tax Code	Account
Sales	service	20% VAT	Any income account
Sales novat	service	0% VAT	Any income account
Purchase	non-inventory part	20% VAT	Any expense account
Purchase novat	non-inventory part	0% VAT	Any expense account

To adjust accounting link settings:

1. Click the Setup tab.
2. Under To Export on the right, select the types of data you send through the accounting link.
3. Adjust tracking settings.
4. If you want the accounting link to locate and prevent duplicate records from being sent, select Flag on Duplicate.
5. If you select Load Dependents, the accounting link checks if any transactions you are sending require other data. For example, if you are sending an invoice, the accounting link imports the customer if the customer has not already been created in Reckon / QuickBooks Desktop.
6. If you have multiple accounts receivable or accounts payable accounts in Reckon / QuickBooks Desktop, select the check boxes and enter the name of the accounts that the accounting link should use.
7. Next to Sales Item, enter the name of the service item to be used on sales invoices. Learn more in Set up required items.
8. Next to Purchase Item, enter the name of the non-inventory item to be used on supplier invoices. Learn more in Set up required items.
9. If you use multiple currencies in Simpro Premium, select Multiple Currencies. Learn more in How to Use Currencies.
10. Click Save Settings.

Adjust tracking settings

Select the following check boxes as required:

Simpro Premium and Reckon / QuickBooks apply different rounding conventions to transactions. So, it is possible that the Sub Total and / or Tax Amount of certain transactions in Reckon / QuickBooks may differ by a few cents when compared to the same transactions in Simpro Premium. The only figure that must match between Reckon / QuickBooks and Simpro Premium is the Total.