Comprehensive Quickbooks Integration Guide

Created by Kylah Brown, Modified on Fri, 17 Jul at 2:49 PM by Kylah Brown

Integrations Guide

Connecting and Using the QuickBooks Integration

Before you begin:  The QuickBooks integration lives under My Facility → Integrations. Connecting it is a one-time setup that must be done by someone who can log in to your company’s QuickBooks Online account — usually your bookkeeper, accountant, or owner. Once it’s connected, anyone with the right permissions can view and sync the data.

What Is the QuickBooks Integration?

The QuickBooks integration creates a two-way link between Hashio and QuickBooks Online, so you don’t have to enter the same information in two places.

Hashio sends your sales and catalog out to QuickBooks — your customers, invoices, and product items — so your bookkeeping stays up to date automatically.

QuickBooks sends your accounting information back into Hashio — your vendors, chart of accounts, bills, purchases, payments, and journal entries — so you can see costs right alongside your production data.


Setting Up the QuickBooks Integration

Step 1  Open the Integrations page
  1. From the left sidebar, go to My Facility.
  2. Open the Integrations page.

This page lists any integrations you’ve already set up and shows whether each one is enabled.

Step 2  Add a new integration
  1. Click the New Integration button in the top right corner.
  2. Open the Name dropdown and choose QuickBooks.

You may also see LeafLink and Apex Trading in this list — for this guide, choose QuickBooks.

Step 3  Grant access and sign in to QuickBooks
  1. Make sure the Enabled box is checked.
  2. Click Grant access.
  3. A QuickBooks sign-in window opens. Log in with your QuickBooks Online username and password, then approve the connection.

This step requires your QuickBooks password, so it must be completed by someone who can log in to your QuickBooks account.

Step 4  Save the integration
  1. Click Save.
  2. QuickBooks now appears in your list of integrations, with Enabled set to True.
Tip:  Only one person needs to complete the setup. Because it requires your QuickBooks login, ask whoever manages your QuickBooks account to do this once — after that, your team can use the integration without signing in again.

Opening the QuickBooks Dashboard

Step 1  Open the dashboard
  1. On the Integrations page, click quickbooks in the list.
  2. The QuickBooks dashboard opens, with a row of tabs across the top: Dashboard, Items, Customers, Vendors, Invoices, Bills, Purchases, Payments, Journal Entries, and Chart of Accounts.
Step 2  Check that you’re connected
  1. At the top of the dashboard, look for QuickBooks Online with a green Connected badge.
  2. The Realm ID shown next to it is your QuickBooks company’s unique ID — you don’t need to do anything with it.

If you don’t see the Connected badge, repeat the Grant access step above to reconnect.


Understanding the Dashboard

The dashboard is split into two groups that show which direction your information is flowing.

Outbound (Hashio to QuickBooks) covers what Hashio sends to QuickBooks:

  • Customers — your customers, matched to QuickBooks customers
  • Invoices — sales invoices pushed to QuickBooks
  • Items / Catalog — your products, matched to QuickBooks items

Inbound (QuickBooks to Hashio) covers what QuickBooks sends back to Hashio:

  • Vendors — your suppliers from QuickBooks
  • Chart of Accounts — your accounts, mapped to Hashio categories
  • Bills & Purchases — bills and purchases entered in QuickBooks
  • Bill Payments, Customer Payments, and Journal Entries — payment and ledger records from QuickBooks

Each item shows a quick summary (for example, how many records synced and when they last synced), along with a Manage button and a Sync button.

Tip:  The Manage button opens the full tab for that item, where you can view records and set up matching — for example, linking a QuickBooks customer to your Hashio customers.

Syncing Your Data

Syncing refreshes the information between Hashio and QuickBooks. You can sync one section at a time or everything at once.

Step 1  Sync one section at a time
  1. Find the section you want to refresh (for example, Customers or Vendors).
  2. Click the Sync button on that card.

Only that section is updated. The card shows how long ago it was last synced.

Step 2  Sync everything at once
  1. Click Sync all in the top right corner of the dashboard.

Hashio refreshes every section — both what it sends to QuickBooks and what it pulls back.

Step 3  Check the Activity log
  1. Scroll to the Activity section at the bottom of the dashboard.
  2. Each row shows the Entity, a Status (such as Success), the Result (for example, 80 ok of 80), how long it took, and when it ran.

Use this log to confirm your most recent sync finished successfully.


Customers

The Customers tab connects your Hashio customers to the matching customers in QuickBooks, so every invoice lands on the right account.

Step 1  Open the Customers tab
  1. From the dashboard tabs, click Customers.
  2. You’ll see a list of QuickBooks customers with their QB ID, Name, Email, Phone, and how many Hashio customers are linked to each.
Step 2  Link a QuickBooks customer to your Hashio customers
  1. Click a customer row to open the Link customers to QBO customer window.
  2. Check the box next to each Hashio customer that should map to that QuickBooks customer. You can use the search box to find them quickly.
  3. Click Save.

Turn on “Hide customers linked elsewhere” to only show customers that aren’t linked yet. Saving will reassign any customers that were linked somewhere else.

Step 3  Match customers automatically or pull the latest list
  1. Click Auto-map by name to let Hashio match customers whose names are the same.
  2. Click Sync from QuickBooks to pull in the newest customer list from QuickBooks.

Items / Catalog

The Items tab matches your Hashio products to QuickBooks items, so your invoices post to the right places in QuickBooks.

Step 1  Open the Items tab
  1. From the dashboard tabs, click Items.
  2. Each row shows an item Name, the QuickBooks Product it maps to, and how many Hashio products are linked.
Step 2  Add a QuickBooks item
  1. Click Add Item.
  2. Enter the Name as it should appear on invoices.
  3. Choose the matching QuickBooks Product.
  4. Click Create.
Step 3  Link your Hashio products to the item
  1. On an item row, open the Link products to item window.
  2. Search by name or SKU, then check the products that belong to this item.
  3. Click Save.

Turn on “Show non-cannabis items” if you need to link products that aren’t cannabis. Saving will reassign any products linked elsewhere.

Step 4  Sync your products
  1. Click Sync products to update the item list with QuickBooks.

Invoices

Invoices are created in Hashio and pushed out to QuickBooks. The Invoices tab lets you see each one and confirm it synced.

Step 1  Open the Invoices tab and read the list
  1. From the dashboard tabs, click Invoices.
  2. Each row shows the Doc #, Customer, Invoice date, Due date, a Status (Open, Overdue, or Paid), whether it’s Synced to QuickBooks, when it was created in QuickBooks, and the Total and Balance.
Step 2  Filter the list
  1. Use the status filters to show All, Open, Overdue, or Paid invoices.
  2. Use the sync filters to show All, Synced to QBO, or Not synced invoices.

You can also search by document number or customer name.

Step 3  View invoice details
  1. Click the eye icon on any invoice row.
  2. A window opens showing the line items — product, quantity, unit price, and amount — along with the invoice status.

Vendors

Vendors are your suppliers, brought into Hashio from QuickBooks. The Vendors tab shows which ones are matched up.

Step 1  Open the Vendors tab
  1. From the dashboard tabs, click Vendors.
  2. Each row shows the vendor Name, Email, Phone, QB ID, and a Status of Synced or Unsynced.

Use the All / Synced / Unsynced filters to focus on vendors that still need to be matched.

Step 2  Match vendors or pull the latest list
  1. Click Auto-map by name to match vendors with the same name automatically.
  2. Click Sync from QuickBooks to bring in the newest vendor list.

Chart of Accounts

Your QuickBooks accounts import into Hashio here. Mapping each expense account to a Hashio category is what lets your costs show up in the right place.

Step 1  Open the Chart of Accounts tab
  1. From the dashboard tabs, click Chart of Accounts.
  2. Each row shows the QuickBooks Account, its Type (such as Expense), an Allocatable toggle, and its Hashio Category.
Step 2  Import your accounts
  1. Click Sync from QuickBooks to import or refresh your accounts.

Use the search box and the Expense-side only, All accounts, and Unmapped only filters to find what you need.

Step 3  Map an account to a Hashio category
  1. Find the account you want to map.
  2. Open the Hashio Category dropdown on that row and choose the right category.

Any accounts left unmapped will land in “Other” until you map them. Your choices are remembered for future syncs.

Step 4  Choose which accounts are allocatable
  1. Turn the Allocatable toggle off for accounts you don’t want split onto batches — for example, rent.

Accounts you turn off still import and appear in reports. They just won’t show up in the batch allocation window.

Heads up:  If you see a banner saying some expense accounts are unmapped, it’s reminding you that lines on those accounts will land in “Other” until you map them. Mapping your accounts is what powers accurate batch costs.

Bills & Purchases

Bills and purchases you entered in QuickBooks import into Hashio. The Bills tab gives you accounts-payable visibility, and the Purchases tab lists purchases pulled from QuickBooks.

Step 1  Open the Bills tab and read the list
  1. From the dashboard tabs, click Bills.
  2. Each row shows the Vendor, Bill date, Due date, a Status (Open, Overdue, Partial, or Paid), and the Total and Balance.

Use the status filters or the search box to find a specific bill.

Step 2  View bill details
  1. Click the eye icon on any bill row.
  2. A window opens showing each line — category, QuickBooks account, description, and amount.
Good to know:  Bills are tracked for accounts-payable visibility and are not allocated to batches. Only purchases (and manual expenses) feed batch costs in the Accounting module. You’ll find the Purchases tab right next to Bills in the dashboard tabs.

Payments

The Payments tab shows the payments recorded in QuickBooks — both money you’ve paid to vendors and money customers have paid you.

Step 1  Open the Payments tab
  1. From the dashboard tabs, click Payments.
  2. Switch between the Bill payments and Customer payments sub-tabs.

Bill payments show what you paid vendors; customer payments show what customers paid you.

Step 2  View a payment
  1. Click the eye icon on any payment row.
  2. A window opens showing which bill or invoice the payment was applied to, and the amount.
Good to know:  Payments are a read-only mirror of QuickBooks. Balances in Hashio aren’t recomputed from these payments right now, so use QuickBooks as your source of truth for payment balances.

Journal Entries

The Journal Entries tab is a read-only view of the journal entries in QuickBooks, so you can see your ledger activity without leaving Hashio.

Step 1  Open the Journal Entries tab
  1. From the dashboard tabs, click Journal Entries.
  2. Each row shows the Date, Description, number of Lines, and the Amount.
  3. Click Sync from QuickBooks to refresh the list.

Related guides:

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article