Browse AddOns by: View products listed by Category View products for specific Industries Alphabetical listing of Products Products listed alphabetical by Manufacturer   Buy ACT! Add Ons here
QSalesData for ACT! See Quickbooks sales transactions in ACT! and developed by Effective Solutions

PRODUCT | QSalesData for Act!

Link Act! & QuickBooks! Having separate Act! and QuickBooks databases is a major source of inefficiency and duplicate work.

QSalesData Link for Act! is the perfect solution to getting Act! and QuickBooks working together. Synchronize your QuickBooks Data with Act!. No need to switch back and forth between programs, you can initiate all of your important tasks from Act!.

Give key sales data to your Act! users without having to give them access to QuickBooks. Individual Act! users do not have to have QuickBooks installed to see the QuickBooks Transactions and QuickBooks Items Purchased from within Act!. This feature alone will save you $$$.

QSalesData is a QuickBooks Link addon that brings data into fields into Act!. This gives Act! users the ability to:

  • Perform Key Lookups using the QuickBooks Data in Act!
  • Use QB Data in Dynamic Group criteria
  • Include QB field data in Reports and Dashboards
  • All QuickBooks data in Act! synchronizes out to remote Act! databases

Implementing the QSalesData QuickBooks Link for Act! will change the way you do business!

Watch a video that describes many of the great features in QSalesData.

Click on the images below to view larger slide show:

QB Data Tab Opps to Transactions QB Transactions Tab
QB Items Tab QBSD Create Transactions

Here are the key features of the QSalesData Link:

  • Link Records to QuickBooks Customers
  • Create QuickBooks Customers from Records in Act!
  • Push Address Changes between Act! and QuickBooks
  • Create QuickBooks transactions (invoice, sales order, estimate, etc.) from within Act!
  • View QuickBooks Transactions from within Act!
  • View QuickBooks Items purchased from within Act!
  • View 5 years of Sales Totals, Past Due Balances, and other key sales metrics in Act!
  • Lookup Customers in Act! by Items Purchased
  • Convert Act! Opportunities to QuickBooks Transactions (Act! 2010 and higher)
  • All data resides in Act! fields and synchronizes out to Act! remote databases

No more back and forth. Life just got easier.

Click to buy




Click to buy
$159.00 -- One-user License
$149.00 -- Five or more
$139.00 -- Ten or more

View Shopping Cart



  • How to convert an Act! Contact to a QuickBooks Customer (QB Create/Link button) view

Show/Hide more videos

I am beyond Thrilled with this product! It is without a doubt the best software that I have ever bought (and I've bought a lot of software over the years) because it does what I need it to do. Effective Solutions delivered what they PROMISED and more! If you are thinking about this product – you can stop thinking. It will start making you money on day one. --Bruce Lyon, Owner, Stitch Logo

QBSalesData has given our sales dept. a "birds eye view" of outstanding debt prior to making sales. This has helped our small company stay on top of collecting money prior to initiating additional sales. It is very user friendly, quick to apply and the ability to initiate an invoice directly from Act! is outstanding. I would recommend this product without hesitation! --Irene E. Holmes, Business Administrator, Western Weather Group

We have been asking Act! for a link for QuickBooks for 2 years. With the release of QBSalesData our dream has come true. Thank you very much for your great support. Your program has enabled us to have true visibility on our active VS potential customers. We now have an easy method to keep in touch with our active customers. Also we have a much better grip on our marketing campaigns using our CRM. We appreciate your work. Your program has a direct impact on our bottom line.--Ramin Heydari, CEO, CellGateUSA, Irvine CA

QBSalesData has been great for my business. I was new to QuickBooks and had used Act in the past, but tackling both at once and trying to integrate them seemed daunting. QBSalesData has been very easy to navigate and is extremely functional. I now spend much less time on data entry and more time on building my business. It has made us much more efficient, and we are now able to track information that used to get lost. Effective Solutions is great to work with. --Tim Nichols, Four Seasons Home Services, Dallas, TX

Compatible with:

QSalesData works with the following US, Canada and UK versions of Act!

  • Act! 2010 Standard, Premium and Corporate Edition
  • Act! 2011 Pro and Premium
  • Act! 2012 Pro and Premium
  • Act! 2013 Pro and Premium
  • Act! v16 and Newer

QSalesData works with the following US VERSIONS of QuickBooks

  • QuickBooks 2007 Basic, Pro, Premier and Enterprise
  • QuickBooks 2008 Basic, Pro, Premier and Enterprise
  • QuickBooks 2009 Basic, Pro, Premier and Enterprise
  • QuickBooks 2010 Basic, Pro, Premier and Enterprise
  • QuickBooks 2011 Basic, Pro, Premier and Enterprise
  • QuickBooks 2012 Basic, Pro, Premier and Enterprise
  • QuickBooks 2013 Basic, Pro, Premier and Enterprise
  • QuickBooks 2014 Basic, Pro, Premier and Enterprise

QSalesData works with the following CANADIAN and UK VERSIONS of QuickBooks

  • QuickBooks 2010 Basic, Pro, Premier and Enterprise
  • QuickBooks 2011 Basic, Pro, Premier and Enterprise
  • QuickBooks 2012 Basic, Pro, Premier and Enterprise
  • QuickBooks 2013 Basic, Pro, Premier and Enterprise


Technical Support
provided by Effective Solutions



CONTACT US  1-800-806-5281
Other AddOn Stores / GoldMine / Outlook
Copyright © 2015 SJR Productions, Inc.
All brands and product names - are trademarks or registered on trademarks of their respective companies.

AddOnStore   AddOnStore

Frequently Asked Questions

Does the information on the QB Invoices tab synchronize out to my Act! remote sync user databases?
Yes. All data on the QB Invoices tab and the Sales Totals tab will synchronize out to remote Act! databases.

Do I need to re-import 3 years of sales data from QuickBooks each time?
No. Once you do your initial import of 3 years of sales data, you can simply pick the date range of sales data since the last time you imported into Act!. But note, you can pick any date range of data to import, and the QSalesData program is smart enough to figure out what to bring in to Act!.

Can I bring in QuickBooks transactions more than 3 years old?
Yes. Transactions will get created on the QB Invoices tab for whatever transactions you export from QuickBooks. But note, the Sales Totals tab will always calculate for a rolling 3-year period.

Do I need to do anything special at the end of the year regarding Sales Totals?
No. The QSalesData import program works off of the current system date to calculate the data on the Sales Totals tab. When you do your first import in the new year, it will recalculate all of the data appropriately.

Will duplicates get created if I import the same data twice?
No. The QSalesData import program keys off of Invoice Number, so it won't create duplicate Invoice transactions.

Will QSalesData work with Act! Premium for Web Versions?
Not yet, we are currently working on a version that will work with Act! for Web. The Sales Totals tab will display properly because those are simply Act! fields, but the QB Invoices tab will not display in Act! for Web at this time.

What happens if existing invoices are updated in QuickBooks?
The next time you import QuickBooks data the invoice transactions on the QB Invoices tab will be updated, and the Sales Totals tab will be recalculated.

Where does the QB Invoices data reside, and is it included in Act! backups?
In Invoice data resides in a custom table in Act! called QSalesData. It will be included in all Act! backups.

If I run an import during the day will it slow down my Act! system?
System speed should not be affected. Note that remote users may see a slight increase in sync times if you are importing a large range of invoice transactions.




Screen Shots -- Click on images to see full sized

    QB Transactions Tab displays the last three years of Invoices


When you double-click on an Invoice you see the Invoice Details

    View the past 3 years of monthly QuickBooks Sales Totals from the Sales Totals Tab in Act!.
We also include YTD Sales comparisons and Last Invoice Date.



Accounts Receivable Data with Past Due Information also comes over from QuickBooks


QB Link Wizard lets you quickly link Act! Contacts to QuickBooks






QSalesData version 2.0 Product Feature Chart

  • Link Act! Contacts and Companies to QB Records (QB)
  • QB Link Wizard to link records all at once (QB)
  • Automatic sync of your QB Transactions into Act! each night (QB)
    • (runs in windows scheduler, can be configured to run on a server without QB open)
  • Synchronize Customer Address Field Changes between Act! and QuickBooks (QB)
    • Map fields to be updated
    • Tag which Company and Contact Records get updated when information changes
    • Run Update process for Current Lookup or All Contacts
  • Create Basic Invoice from Contact Record in Act! (QB)
  • Create QB Customer from a record in Act! (QB)
  • Create Act! Records from QuickBooks Customer Records (QB)
  • QuickBooks Sales Related Fields synch to fields in Act!
    • Last 3 Years of Monthly Sales Totals
    • 3 Years of YTD and Year End Totals (recalc with each data update)
    • Last Invoice Date
  • The Following A/R Related Fields sync to fields in Act!
    • Credit Limit
    • Balance 0-30
    • Balance 31-60
    • Balance 61-90
    • Balance 91 +
    • Total Past Due Balance
    • Total Balance
  • The Following QB Account Fields sync to fields in Act!
    • Account No., Terms, Type and Rep
  • QB Data fields can exist on both Company and Contact Records
  • QuickBooks Transactions Tab in Act! includes:
    • Invoices, Estimates, Sales Receipts and Credit Memos
  • Double-Click on Invoice Transactions in Act! to see the line item details
  • All Data exists in Act! and synchronizes out to remote databases!!!
  • All Data is stored in ACT fields and Tables so you can:
    • Add QB Data fields to the Contact List View
    • Use QB Data fields to create Dynamic Groups
    • Add QB Data fields to Reports
    • Add QB Data information to Dashboards
    • Map QB Data fields to your smart phone
  • Additional Transaction Types to the QB Transactions Tab
    • Payments
    • Sales Orders
  • Create Invoices from CLOSED/WON Opportunities in Act! (QB)
    • QuickBooks Item Numbers, Descriptions and Pricing will synchronize to Act! Products table
    • Act! users will populate the Products tab of the opportunity with the appropriate line items
    • Click a button to create a QuickBooks invoice using the Opportunity Product Tab information

Features that have (QB) designator require the QuickBooks client to be installed and open on the computer