Our new QuickBooks connector for Slack brings your data to your favourite collaboration platform

See how we can supercharge your collaboration and workflows by bring your QuickBooks data to your fingertips.

Ben Liebert Developer & Data Specialist LinkedIn

Ever been in Slack and needed the latest report from QuickBooks? What about a simple breakdown of your Invoice data? SYNCHUB makes this possible with our new QuickBooks connector for Slack. In this post I'll show how you're just a few mouse-clicks away from conversing directly with your QuickBooks data from directly within Slack.

Connecting your QuickBooks account

To get started, just connect your QuickBooks data to your SYNCHUB data warehouse - you may use your own database, or we will provide one to you for free.

Connect Slack

Once your data is downloading, you need to authorize your Slack account to read from it. Visit your User menu within SYNCHUB, select the Slack Settings, then follow the instructions to connect.

Our integration supports two use cases for Slack:

  1. A chatbot, letting you converse directly with your QuickBooks data; and
  2. A notification channel for messages from SYNCHUB

When you connect, you'll be asked to provide the channel - I'll show you later how this is used.

Querying your QuickBooks data from within Slack

After the authorization, you'll notice a new App available in Slack, which offers up a chat window with a direct line to your data:

SyncHub
Chat
History
About
SyncHub APP

Ever been in Slack and need the latest company financials? Project status? Last week's timesheets? SyncHub makes this possible. Connect the cloud services that drive your business (like Hubspot, Xero, monday.com and 70+ more) then converse directly with your data, without leaving Slack.

B I U S
🔗
Reply…

And now, it's just like the AI Assistant you know and love from SYNCHUB. Ask any questions you like and Slack will return the answer. Let's try a question by requesting our latest Invoice data:

SyncHub
Chat
History
About
SyncHub APP

Ever been in Slack and need the latest company financials? Project status? Last week's timesheets? SyncHub makes this possible. Connect the cloud services that drive your business (like Hubspot, Xero, monday.com and 70+ more) then converse directly with your data, without leaving Slack.

Ben Just now
Did we get any new Invoice data from QuickBooks recently? Give me the last few records.
SyncHub APP Just now
Your Invoice data was last synced on April 20. Here are the new records:
CustomerID DocNumber TxnDate TotalAmt Balance
CUST-4567 INV-APR-001 2024-04-01 10:00:00 500.75 200.25
CUST-1234 INVOICE-2024-XYZ 2024-04-03 15:30:00 1,200.00 0.00
CUST-7890 ORD-789-QB-2024 2024-04-10 09:15:00 350.50 150.50
B I U S
🔗
Reply…

Receiving SYNCHUB notifications within Slack

SYNCHUB runs continuously in the background, monitoring your QuickBooks data and syncing changes where necessary. On occasion, this means that we need to notify you - for example, if your data connection becomes unavailable. To enable these notifications in Slack, go back to your Slack Settings, and toggle the notification option:

Now, any notifications that you would usually receive via email are also sent to the Slack channel you specified earlier:

# synchub-notifications
Messages
SyncHub APP Just now
Your QuickBooks connector has been unable to sync to your database for the last hour. Please check your database settings.
B I U S
🔗
Reply…

SYNCHUB brings your QuickBooks data to you. Not the other way around.

You're already dealing with dozens of open tabs and apps on your computer, so let SYNCHUB remove some of the complexity by bring your reporting and business data to the place your team hangs out all day - Slack.

Happy reporting, everybody.