Skip to main content

ShopView + QuickBooks Online: Daily Bookkeeping Cheat Sheet

The short version: run the shop in ShopView, let it send invoices, payments and parts bills to QuickBooks Online (QBO), and use QBO to pay vendors, match your bank and see your numbers.

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.

  1. Invoice finished work orders in ShopView. Check labor, parts, shop supplies and tax before you finalize.

  2. Record every payment in ShopView the day you get it: card, check, cash or ACH. Put the check number or reference in the payment.

  3. Enter vendor invoices in ShopView when parts arrive. Type the vendor's invoice number, date and total exactly as printed on their paper.

  4. Record returns and cores in ShopView when they go back, so the credit follows.

  5. Glance at the QB Unexported report in ShopView. Anything listed there did not reach QBO. Fix it the same day (see the box below).

  6. 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):

  1. Enter the vendor invoice in ShopView when you receive the parts. A bill appears in QBO.

  2. 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.

  3. 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):

  1. Enter the vendor invoice in ShopView as usual.

  2. When you pay, use Pay bills in QBO, pick the bills you are paying, and apply any vendor credits from returns or cores.

  3. 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.

Did this answer your question?