Documentation

Cannabis Dispensary QuickBooks Setup

Docs / QuickBooks / Cannabis Dispensary Setup
QuickBooks

At a Glance

▶ Watch the full tutorial with transcript →

  • Pay a vendor and QuickBooks gets a Bill plus the Bill Payment (check) that pays it, with the check number on the payment and copies of the check and invoice attached to the Bill. Consignment payouts post the same pair at approval.
  • Cash (nothing posts until you pay) or accrual (the bill posts when product arrives). Which one you start on depends on your store. If you have received wholesale deliveries still waiting to be paid when you save your two QuickBooks accounts, you stay on Cash; otherwise saving them switches you to Accrual, expense at receipt. The one in use is marked Current under My Account → QuickBooks Online → Settings.
  • Setup is a six-step guide after you click Connect to QuickBooks under My Account.
  • Cleared checks come back from your QuickBooks bank feed early each morning and show as Cleared.

What lands in QuickBooks, and when

Every time you pay a vendor from ShelfSpace, two entries post to QuickBooks Online:

  1. A Bill: what you owed the vendor. Its reference is the vendor's invoice number (or PM- plus the payment number when there isn't one), it posts to your expense account against the matched QuickBooks vendor, and the vendor's invoice and a copy of the check are attached to it.
  2. A Bill Payment: the check that paid it. Its reference is the check number, it draws on your mapped bank account, and it is linked to the Bill so the bill shows as paid.

Approving a weekly consignment payout posts the same pair: a Bill referenced SR- plus the payout number (with the payout report attached) and the Bill Payment for its check.

When the bill posts depends on your accounting method (My Account → QuickBooks Online → Settings → Accounting method). On Cash, expense when paid, nothing posts until you pay, then the bill and check post together. On Accrual, expense at receipt, the bill posts when you receive the delivery and the check posts later, when you pay. Which one you start on depends on your store. If you have received wholesale deliveries still waiting to be paid when you save your two QuickBooks accounts, you stay on Cash; otherwise saving them switches you to Accrual, expense at receipt. The one in use is marked Current under My Account → QuickBooks Online → Settings. Accrual, capitalize inventory (under Advanced) posts the bill at receipt to your Inventory Asset account. See Accounting method. Consignment payouts always post at approval, whatever you pick.

Cleared status comes back on its own. Early each morning, ShelfSpace reads the checks that have cleared in your QuickBooks bank feed and marks the matching payments Cleared. This needs the bank account to be mapped.

Setup in 6 steps

Go to My Account → QuickBooks Online and click Connect to QuickBooks. QuickBooks asks you to sign in and choose your company, then sends you back to ShelfSpace's setup guide. You can stop at any step and pick up where you left off.

  1. Accounts. Pick the expense account vendor costs post to (typically Cost of Goods Sold) and the bank account your checks are drawn on. Click Save and continue.
  2. Your vendors. Connect each QuickBooks vendor to a ShelfSpace vendor.
  3. Bills we already have. Link bills your bookkeeper already entered to the matching ShelfSpace invoice.
  4. Bills to pay. Bring over open QuickBooks bills ShelfSpace has no invoice for.
  5. Vendor details. Fill blank vendor email, phone and mailing address from QuickBooks.
  6. Done. Bills and the checks that pay them post automatically from here.

Step 1: Accounts

The expense account list shows your QuickBooks expense and cost-of-goods-sold accounts. The bank account is required: without it the bills post but the payments that close them don't, which leaves bills open in QuickBooks that you've already paid, and checks can't be marked Cleared. The Show bank balance in ShelfSpace switch puts your QuickBooks bank balance in the Cash status widget on your Payments page; turn it off if you'd rather not have it visible to everyone with portal access.

To post one vendor somewhere else (a landlord to Rent, for example), set a per-vendor account on that vendor's page. It overrides the default for that vendor's future bills.

Step 2: Your vendors

ShelfSpace matches QuickBooks vendors to yours from evidence, not names: the vendor's cannabis license number, invoices you already have from them, or a match you made before. Each match is listed with the evidence that made it. Vendors whose name is unclear stay in a list for you to pick from; Not one of mine — add them creates the vendor in ShelfSpace instead. Match all my vendors & bring bills over does the obvious matches and imports their open bills in one click; Match my vendors, don't bring bills over leaves the bills in QuickBooks. Matching a vendor connects all of their bills, past and present.

Step 3: Bills we already have

Each row is a bill sitting in QuickBooks that looks like an invoice ShelfSpace already has: the same invoice number, or the same amount around the same date. Tick the rows that are the same bill and click Confirm; click Not a match on the ones that aren't. Once linked, paying that invoice in ShelfSpace posts the payment against the bill your bookkeeper entered instead of creating a second bill for the same expense. Nothing links on its own.

Step 4: Bills to pay

Open QuickBooks bills with no matching ShelfSpace invoice. Select them and click Import as bills to pay. Each becomes a bill to pay at its QuickBooks balance (what's still owed, not the original total), and when you pay it the payment attaches to that same QuickBooks bill. You can also pick the matching invoice yourself, or dismiss a bill so it stops showing.

Step 5: Vendor details

Click Preview what we can fill to see every billing email, phone and remit-to address QuickBooks can supply, then fill them. Only blank fields are filled. The mailing address decides where a physical check goes.

After setup

Handled for you: closed accounting periods (posts with today's date instead of asking you to reopen), transient QuickBooks errors (10-minute retry), sign-in renewal, and voids (the payment is voided before the bill, in the order QuickBooks requires).

Adjusting after the fact

Effects of common QuickBooks settings changes on already-synced rows versus future rows
ChangeEffect on already-synced rowsEffect on future rows
Change the expense accountPast bills stay on the old accountFuture bills post to the new account
Change a per-vendor accountPast bills for that vendor stay where they areFuture bills for that vendor use the new account
Change the bank accountPast checks stay on the old bankFuture checks use the new bank
Disconnect QuickBooksPast bills and checks stay in QuickBooksNothing posts; reconnect to resume
Void a payment in ShelfSpaceVoids the check, then the bill, in QuickBooksn/a

If you need to re-route a specific past bill, edit it directly in QuickBooks. ShelfSpace will not override your manual edits.

Troubleshooting

What's not covered today

Need help with setup?

Email us at support@shelfspace.pro. If you have vendors on ShelfSpace asking how their side works, point them to our Cannabis Vendor QuickBooks Setup guide.

Ready to connect your books? Let's talk.

Schedule a call
30 minutes with Chris. See how it would run for your business.