Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
A
aaron-ho1
September 23, 2025
Question

Accountinglink Integration - Export to Quickbooks desktop enterprise

  • September 23, 2025
  • 1 reply
  • 5 views

Hello,

 

Our company has recently started using Sage Construction Management to assist with project management related to construction projects. Currently how it is set up is that bills are supposed to be entered in Sage Construction Management, and a software/utility link called "Accounting Link" is used to export the bill to Quickbooks desktop after it is approved

 

For cost codes, it is currently linking it based on the service items in the items list. Ie, item list in Sage CM cost code would equal to the same item list in Quickbooks desktop, so when the export happens, the linked GL account in Quickbooks is used when the bill is exported

 

I am currently experiencing an issue when the bill contains a "tax item",  IE if i try exporting a bill with GST in Sage construction management using accountinglink. If there is no tax item, the bill export works fine.

 

I created a tax item called "GST" in sage construction management,  which when i use the sync preferences in accountinglink and match it to the "GST" sales tax item, i am getting an error. 

 

The error code is "Quickbooks bill add response error #3000. The given object ID "GST' in the field "list id" is invalid. Do you know how i can fix it so the export works correctly?

I have attached a screenshot of our item list which i am  trying to link to the tax code. it is the first item "gst" currently being used. Thank you

 

 

1 reply

E
EmanE17QuickBooks Team
QuickBooks Team
September 23, 2025

I understand that dealing with tax items when exporting into QuickBooks Desktop (QBDT) can be challenging since you're not familiar with it, Aaron. I'll do my best to assist you.

 

The error message you're encountering indicates that the Accounting Link utility is trying to reference a sales tax item in QuickBooks that it can't find or access. This issue usually arises from a mismatch between how the tax item is set up in Sage Construction Management and how it's configured in QuickBooks Desktop, especially in the Canadian version.

 

To resolve this, you need to ensure that the sales tax item in QBDT is set up correctly and properly linked to a vendor (tax agency). Both Accounting Link and QBDT require a specific setup for sales tax items to work properly with bills.

 

Here’s how you can fix it:

 

  1. Log in to your QuickBooks Desktop account.
  2. Go to the Lists menu and select Item List.
  3. Locate the tax item you created, named "GST," in your item list.
  4. Double-click the "GST" item to open the Edit Item window.
  5. Verify or Assign a Tax Agency:
    • Make sure the Type is set to Sales Tax Item.
    • Check the Tax Agency field. A vendor must be selected in this field.
    • If no vendor is selected, click the drop-down menu and choose the appropriate tax agency (e.g., "Canada Revenue Agency" or "CRA"). If the vendor doesn't exist, you'll need to create a new vendor for the tax agency first.
  6. Once everything is set, click OK to save the changes.

 

I've also included a helpful article for your reference: How to Set Up Sales Tax in QuickBooks Desktop.

 

Feel free to reply to this post if you need further assistance with QBDT. I'm always here to help. Stay well!

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement