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:
- 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. - 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.
- 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.
- Your vendors. Connect each QuickBooks vendor to a ShelfSpace vendor.
- Bills we already have. Link bills your bookkeeper already entered to the matching ShelfSpace invoice.
- Bills to pay. Bring over open QuickBooks bills ShelfSpace has no invoice for.
- Vendor details. Fill blank vendor email, phone and mailing address from QuickBooks.
- 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
- Overview tab on the QuickBooks card: Synced, Failed and Pending counts, plus how many checks are already matched in your QuickBooks bank feed.
- Sync activity tab: each entry and its status, with Retry on any that failed. Failed entries also retry on their own every 10 minutes.
- Bills from QuickBooks: when your bookkeeper keeps entering bills in QuickBooks, click Scan QuickBooks to find new ones to link or bring over. The page doesn't scan on its own; with two-way sync turned on (Settings tab), new QuickBooks bills can come over on their own instead.
- Settings tab: change your accounts, accounting method, or reconnect.
Adjusting after the fact
| Change | Effect on already-synced rows | Effect on future rows |
|---|---|---|
| Change the expense account | Past bills stay on the old account | Future bills post to the new account |
| Change a per-vendor account | Past bills for that vendor stay where they are | Future bills for that vendor use the new account |
| Change the bank account | Past checks stay on the old bank | Future checks use the new bank |
| Disconnect QuickBooks | Past bills and checks stay in QuickBooks | Nothing posts; reconnect to resume |
| Void a payment in ShelfSpace | Voids the check, then the bill, in QuickBooks | n/a |
If you need to re-route a specific past bill, edit it directly in QuickBooks. ShelfSpace will not override your manual edits.
Troubleshooting
- An entry shows Failed: open Sync activity and click Retry. Failed entries also retry every 10 minutes on their own.
- Only bills post, no checks: the bank account isn't set. Add it on the Settings tab.
- A bill went to the wrong QuickBooks vendor: match that vendor again on the QuickBooks page. Future bills follow the new match; edit the past bill in QuickBooks if needed.
- "Reconnect to QuickBooks" appears: QuickBooks ended the connection. Click Reconnect and sign in again; nothing is lost.
- Duplicate document number error: someone entered a bill or check by hand with the same number. Link it on Bills from QuickBooks, or edit or delete the manual entry, then Retry.
- A cleared check isn't marked Cleared: make sure the bank account is mapped and the check appears in your QuickBooks bank feed with the same check number and amount. ShelfSpace checks early each morning.
What's not covered today
- Sales tax lines: transactions post as-is, with no separate tax line.
- Class and location tracking: bills post without a Class or Location. If you report by department, set them in QuickBooks.
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