This article is for owner-operators and small shops with no payroll, where customers pay when the work is done and most vendors are paid at the counter or on receipt. It covers day-to-day habits only.
Please read: This is general guidance on using ShopView and QBO together. It is not tax, legal or accounting advice. Questions about sales tax, what counts as a business expense, how to pay yourself, equipment and vehicles, or year-end filing belong with your CPA or a bookkeeper. When in doubt, ask them before you change anything.
How ShopView and QBO work together
Each task has one home. Do it there, and only there. ShopView is where the shop's work happens. QBO is where the money is checked against the bank. Entering the same thing in both places is the most common cause of doubled sales, doubled expenses and messy balances.
Task | Do it in | What shows up in QBO |
Customers and their invoices | ShopView | Customer and invoice sync over |
Taking a customer payment | ShopView | Payment syncs and marks the invoice paid |
Customer deposits or prepayments | ShopView (deposit feature) | Held as a deposit until applied to the invoice |
Ordering and receiving parts, entering the vendor's invoice | ShopView | A bill (what you owe the vendor); parts go into inventory |
Parts returns and core credits | ShopView | A vendor credit to use against that vendor's bills |
Paying vendor bills | QBO | You record the payment here |
Rent, fuel, tools, phone, insurance and other overhead | QBO (bank feed) | Categorized from the bank or card feed |
Matching the bank and reconciling | QBO | Done monthly against your statement |
Reports: profit and loss, who owes you, who you owe | QBO | Built from all of the above |
When you sell a part, ShopView moves its cost out of inventory and into cost of goods sold, so your profit reflects what the part actually cost you.
How your accounts are mapped (which QBO account labor, parts, shop supplies and fees land in) was set up during onboarding. Leave the mapping alone unless ShopView support or your bookkeeper walks you through a change.
Every day (10 to 15 minutes)
Close out today's work in ShopView before you go home; that is what keeps QBO current.
Invoice finished work orders in ShopView. Check labor, parts, shop supplies and tax before you finalize.
Record every payment in ShopView the day you get it: card, check, cash or ACH. Put the check number or reference in the payment.
Enter vendor invoices in ShopView when parts arrive. Type the vendor's invoice number, date and total exactly as printed on their paper.
Record returns and cores in ShopView when they go back, so the credit follows.
Glance at the QB Unexported report in ShopView. Anything listed there did not reach QBO. Fix it the same day (see the box below).
Keep the paper. Snap a photo of every receipt and vendor invoice, or attach it in QBO.
Why things fail to sync, and the fix:
The same name is used for a customer and a vendor (for example, "Smith's Towing" is both). QBO will not allow it. Make one name unique, like "Smith's Towing (V)".
An invoice or bill number already exists in QBO. Check you are not entering it twice.
The customer is missing in QBO, or the name has special characters.
Once fixed, export it again from the report. Only mark an item "exported" if you are sure it is already in QBO.
Money coming in (accounts receivable)
With due-on-receipt customers, every invoice should have a payment against it within days. Anything older is money you need to chase.
Invoice and payment both start in ShopView. QBO gets a copy of each. Do not create the invoice or "receive payment" again in QBO.
Match, don't add. When the deposit shows up in the QBO bank feed, match it to the payment ShopView already sent. Clicking "Add" instead counts the sale twice.
Card deposits rarely equal one invoice. Your processor bundles several payments into one deposit and takes its fee out first. Match the deposit to all the payments it covers and record the fee as an expense, so the total equals what hit the bank. Ask us to walk you through this the first time.
Deposits on big jobs go through the ShopView deposit feature, not as a regular payment. That keeps them separate until the job is invoiced.
Credits and discounts should be applied on the ShopView invoice, not adjusted later in QBO.
Check who owes you weekly. Run the A/R Aging report in QBO (or the aging report in ShopView). On due-on-receipt terms, anything past 30 days needs a call.
Money going out (accounts payable)
Parts bills come from ShopView; you pay them in QBO. Even if you pay at the counter the same day, the bill still has to be marked paid in QBO, or it sits there looking like money you owe.
Parts you paid for at the counter (card or debit):
Enter the vendor invoice in ShopView when you receive the parts. A bill appears in QBO.
When the charge shows in the QBO bank or card feed, match it to that open bill. Do not "Add" it as a new expense; that doubles your parts cost.
The bill amount and the charge must match to the penny. If they don't, check the ShopView entry against the vendor's paper first.
Parts on a vendor account (paid later):
Enter the vendor invoice in ShopView as usual.
When you pay, use Pay bills in QBO, pick the bills you are paying, and apply any vendor credits from returns or cores.
Before you save, check which bills and credits QBO selected. It sometimes spreads a credit across bills you didn't intend.
Everything that isn't parts (shop supplies, rent, fuel, tools, phone, insurance, software): don't enter it in ShopView. Categorize it straight from the QBO bank or card feed. If you aren't sure which category something belongs in, ask your bookkeeper or CPA rather than guessing.
Check who you owe weekly: run the A/P Aging report in QBO. If a vendor shows a balance you know you paid, a bill was probably never matched to its payment.
Every week and every month
Once a week, clear the bank feed. Once a month, reconcile. A month left alone takes hours to fix; a week takes minutes.
Weekly (about 30 minutes)
☐ Go through the For review list in QBO Banking. Match anything from ShopView; categorize everything else.
☐ Make sure the QB Unexported report in ShopView is empty.
☐ Run A/R Aging and follow up on anyone past due.
☐ Run A/P Aging and confirm every bill you paid shows as paid.
Monthly (when the statement arrives)
☐ Reconcile each bank and credit card account in QBO against its statement. The difference must be 0.00.
☐ Look over the Profit and Loss for anything odd: a category way too high, income that looks doubled, a big "Uncategorized" amount.
☐ Review the Sales Tax liability in QBO before you file, and file and pay by your deadline. Your CPA or the state can confirm what you owe and when.
☐ Save the statement and your reconciliation report.
Yearly: send your CPA access to QBO (accountant user) instead of exported spreadsheets.
Dos and don'ts
Most cleanups we see come from the right-hand column.
Do | Don't |
Create invoices and take payments in ShopView | Re-create or re-receive them in QBO |
Fix a wrong invoice in ShopView and let it re-sync | Edit or delete a synced invoice or payment in QBO |
Enter parts vendor invoices in ShopView, exactly as printed | Type parts bills straight into QBO as well |
Match bank deposits and charges to what ShopView sent | Click "Add" on something that already came from ShopView |
Record returns and cores in ShopView | Just net them off the next bill in your head |
Check the QB Unexported report daily | Let failed syncs pile up for weeks |
Keep customer and vendor names unique | Use the exact same name for a customer and a vendor |
Keep business and personal money in separate accounts | Pay personal bills from the business account. If it happens, ask your CPA how to record it |
Reconcile every account every month | Assume the bank feed is right because it's automatic |
Keep receipts and vendor invoices (photo or attachment) | Rely on the bank description alone |
Ask before buying a truck, lift or large tool how to record it | Expense it and sort it out at tax time |
Call ShopView support or your bookkeeper when unsure | Change account mappings, tax rates or settings on a guess |
Who to call
ShopView support helps with how the software works. Your CPA or bookkeeper answers what the numbers mean for your taxes.
Call ShopView support for | Call your CPA or bookkeeper for |
Something didn't sync or is on the QB Unexported | Sales tax rates, exemptions, resale certificates |
Call ShopView support for | Call your CPA or bookkeeper for |
report | and filing |
A payment, deposit or vendor credit landed in the wrong place | What category an expense belongs in |
Changing account mappings or ShopView settings | How to pay yourself or record personal money in or out |
Training a new person on the daily routine | Trucks, equipment and loans |
Matching card processor deposits the first time | Year-end, 1099s and tax returns |
| Fixing past months that won't reconcile |
| QBO questions on how the program works |
Quick glossary
A/R (accounts receivable): money customers owe you.
A/P (accounts payable): money you owe vendors.
Bill: a vendor invoice you owe. Comes from ShopView when you receive parts.
Vendor credit: money a vendor owes you back from a return or core.
Bank feed: your bank and card transactions pulled into QBO for review.
Match: linking a bank transaction to a record already in QBO. The opposite of "Add".
Reconcile: confirming QBO agrees with your bank statement, to the penny.
Inventory: parts on your shelf, counted as something you own until sold.
COGS (cost of goods sold): what the parts you sold cost you.
Due on receipt: payment is due when the invoice is issued.
