Integration for Airtable and QuickBooks Desktop 2021

[Ana_Chairez]

Hello, I would like to integrate an Airtable workspace to QuickBooks Desktop (2021), not online. I need automate the creation of multiple sales receipts. Does anyone know how to set up this integration?

[Bill_French · Accepted solution]

Hi Ana, and welcome to the community!

Ana_Chairez:

Does anyone know how to set up this integration?

Yes, and by “know”, I know that it’s not simple or effortless. :winking_face:

The desktop version of QuickBooks has an API, but it’s very complex and message-based meaning that you’d have to create a local app to listen for the messages and act accordingly. The best you can do in this case is to manually copy and paste or craft a Goldbergian-like menagerie of reports emailed to Zapier and uploaded into Airtable. It’s a mess.

And if you happen to upgrade to QuickBooks Online, it’s not much better but I suspect some like @Cherry_Yang2 might be able to help.

[Cherry_Yang2]

Thanks Bill for the callout! :slightly_smiling_face:

Hi Ana,

We work with clients on QuickBooks Online only at the moment. It’s often a delicate set up even with QBO so we unfortuantely don’t work with QuickBooks Desktop right now.

Thank you and please let me know if you need help with QBO in the future. You can book me here: Calendly - Cherry Yang or visit our website here: https://www.airopsconsulting.org/

Warm regards,
Cherry

[MichaelTomar]

You can use the Skyvia cloud platform to connect QuickBooks and Airtable. It is a freemium app with no code.