QuickBooks from the POS
Connect QuickBooks Online, pick who posts to it, choose your accounts, share one company between stores, and fix anything that needs a look.
Only owners see this. It is in Settings › Posting to QuickBooks, once you have answered Yes, we use QuickBooks. Connecting QuickBooks is on the Shop plan and up (see Your plan).
Only one system posts
If two systems send the same sale to QuickBooks, it is in your books twice. So each store picks one:
- Off: nothing is posted. If QuickBooks is connected here, your bills and bank balances are still read in.
- BridalIQ: BridalIQ posts for this store. The POS doesn't connect at all. Stores that already said they use QuickBooks start here.
- The POS: the POS posts. First turn off QuickBooks in BridalIQ for this store, then tick I've turned off QuickBooks in BridalIQ for this store. The POS posts only what is dated that day or later.
To send earlier days, open Catch up earlier days, pick the first day and tick that nothing else posted those days. Only do this if BridalIQ and BridalLive did not already post them.
Connect
- Pick Off or The POS.
- Press Connect QuickBooks, sign in to Intuit and pick your company.
- You come back to Settings. The card says Connected to your company's name.
The connection renews itself. If QuickBooks ever asks to be connected again, the card says so: press Connect QuickBooks. Nothing is lost while you wait. Disconnect stops reading and sending; nothing already in QuickBooks changes.
What the POS posts, and when
Your books count a sale when the dress leaves the store, even though money comes in earlier. Money taken before pickup is owed to the bride until she takes it, so it waits in a Customer deposits account.
- A payment comes in (cash, check, card, other): a sales receipt for a "Customer deposit" item, into Undeposited Funds (or the account you pick for that kind of payment). Make your bank deposits in QuickBooks from Undeposited Funds, as you do now.
- Money goes back: a refund receipt from the same account.
- Paid with a gift card or store credit: moved from your gift card account to Customer deposits.
- Items leave the store: a journal entry the same day: Customer deposits to Sales and Sales tax to pay (and a gift card sold to the gift card account). With Cost of goods sold and Inventory picked, the cost moves too. A return reverses it the day it comes back.
- A receiving voucher (an order received on its PO): a bill to the vendor, the way BridalLive does it. Each received line goes to Inventory at its cost (Cost of goods if you don't use an Inventory account). Freight and vendor fees are their own lines. A vendor discount goes as its own vendor credit right after the bill; apply it when you pay that bill in QuickBooks. The memo has the RV and PO numbers; the bill number is the vendor's invoice number if you typed it, else the RV number. Nothing is received without a PO.
- Vendor invoices no longer post bills. They stay on the Invoices screen and in Reconciliation, where a difference between the invoice and what was received shows as a finding. A receipt with no invoice yet shows "Received, no invoice yet" until it comes.
- A received cost corrected later (open the RV, press Correct): only the difference goes to QuickBooks, as a supplemental bill or a vendor credit. The bill already there is never changed.
- A piece marked damaged or missing: its cost moves from Inventory to Inventory shrink, once. Put back in stock, it moves back.
- A balance still owed when she takes it (a manager OK'd it): the unpaid part goes to Balances owed at pickup (Accounts receivable), and moves out of it when she pays.
- A forfeited deposit: a restocking fee, from Customer deposits to Restocking fees. It is not taxed. Deposits are never taxed either.
- A bill marked paid in the POS: a bill payment against the bill from its receiving voucher (or its old invoice bill), from your bank account or card account. After that, undo it in QuickBooks, not here.
Already posting vendor invoice bills? The first time the POS runs with this, it picks a switch day (that day). Invoices dated before it still post as before; receiving vouchers from that day on post bills. Nothing is posted twice: a voucher whose invoice was already a bill is skipped, and the other way round. A note on Settings › QuickBooks says so once.
Closed months. If your accountant closed the books in QuickBooks, nothing is dated into a closed month: it goes on the first open day, with a note on it and in the history.
Cash or accrual. Accrual is the default (above). On cash basis, money in is Sales the day it comes in, refunds take it back, and nothing goes through Customer deposits; cost of goods still posts at pickup. A ticket paid before a switch and picked up after it is posted from where its money is (Customer deposits or Sales), so nothing is left behind or counted twice. Change it in Cash or accrual, from a day you pick. Ask your CPA first.
Inventory is one account (Other Current Asset). The POS doesn't use QuickBooks inventory items, so it works on every QuickBooks Online plan. Classes and Locations (only needed when two stores share one company) need QuickBooks Online Plus or higher.
Inventory: POS vs QuickBooks (monthly)
Owners and your accountant: pick a month and press Check. You see the pieces at cost in the POS rolled forward (opening + received − cost of goods − write-offs ± corrections = closing), QuickBooks' Inventory account on the month's last day, the difference, and its likely reasons: postings not sent yet, bills entered straight into QuickBooks, pieces added or taken out by hand, edits made in QuickBooks. Nothing is fixed automatically. If a difference is left, the owner can post an adjustment to an "Inventory adjustments" account, with a reason (your CPA should agree). It can be reversed.
CPA sign-off sheet
One page of questions for your CPA: cash or accrual, how deposits are taxed, freight, samples, when sales tax is owed, alterations accounts, opening balances and who approves adjustments, and tux rental stock. Print it or copy it into an email, then save the answers. Open questions are marked. Some are BridalIQ's rules and already answered: deposits and restocking fees are never taxed, and nothing is received without a PO.
Card numbers are never sent. Everything goes every 15 minutes, or press Send now. Nothing is ever sent twice.
Accounts
Open Accounts to see where each kind of money goes. The POS picks sensible ones from your chart of accounts; change any of them and press Save accounts. If you don't have a Customer deposits account, make one in QuickBooks (type Other Current Liability) and press Read my accounts again.
Two stores, one QuickBooks company
Each store can have its own QuickBooks company, or share one with another store you own. On the store that shares, pick Share QuickBooks with: and the other store, then Save.
- There is one connection: connect and disconnect on the main store. Disconnecting there disconnects both.
- Each store's postings carry its own Location or Class, so you can tell the stores apart in QuickBooks. Turn on Locations or Classes in QuickBooks (Settings › Account and settings › Advanced), add one per store, press Read my accounts again, and pick one on each store. Nothing is sent until each store has one.
- Accounts: The same accounts as the main store (this store can still pick its own Sales and Customer deposits), or This store's own accounts.
- Changing this later is kept in the history and never sends anything again.
Needs a look
If QuickBooks refuses something, it shows under Needs a look with the reason in plain words, like an account that was turned off in QuickBooks or books closed for that date. Fix it, then press Retry. When QuickBooks is just busy or down, the POS tries again by itself.
Money: Reports › Money and one line on Home
With QuickBooks connected, Reports › Money shows what you owe vendors (QuickBooks' open bills as of today), checks already scheduled (checks dated after today that QuickBooks already took off the bill), how much is over 60 days late, Vendor bills by how late they are, and Cash you can spend: your chosen bank accounts minus vendor bills due in the next 30 days (an estimate). Owners also get one money line on Home that opens it. The Invoices screen also checks each vendor invoice against your QuickBooks bills. See Reports › Money.
Bank accounts and what your team sees (owners)
In Settings › Connections, under Posting to QuickBooks, the Bank accounts and what your team sees card lists your QuickBooks bank accounts. Tick the ones that count toward available cash; unticked accounts are ignored everywhere. Two switches, both off to start:
- Let managers see bank balances. Off: only you and your accountant see balances and cash you can spend. Your team still sees invoices, bills and every warning.
- Let managers see how late vendor bills are. Off: they see the total owed to vendors, but not how much is past due or how many days late.
Staff never see store money whatever is ticked: these are for managers and anyone else you let see sales figures. What you owe vendors (and so how late bills are and cash you can spend) also needs See costs, the same as Bills due. Every change is kept in the history.