Bank Statement to QuickBooks for Optometry Practices: Convert PDF Statements to QBO

The exam side sells time. There's no inventory behind an eye exam or a contact lens fitting. The dispensary is a retail store: it buys frames, lens work, and boxes of contacts, sells them at a markup, and carries an inventory asset plus a real COGS line.

So split the income accounts: exam income, frame sales, lens and lab sales, contact lens sales, accessories. Lump it into one "Sales" account and you can't see your materials margin or tell whether the dispensary earns its floor space. Transactions from your converted PDF to QBO converter import can then be ruled straight into those accounts.

VSP, EyeMed, Davis Vision, and Spectera pay routine care on a vision plan fee schedule, and the plan's own lab often makes the glasses, so no lab invoice reaches you for that job. A medical eye complaint (dry eye, glaucoma, diabetic retinopathy) bills to medical insurance instead. One patient, one visit, two payers is normal.

Now the error that costs the most. The EFT or ACH deposit on your statement is a lump remittance covering many patients and many claims, some filed weeks apart. It isn't new income. It's cash collected against accounts receivable you recorded when the claim went out, so post it against A/R and apply it to the individual claims. Book payer deposits straight to income and you double count revenue.

The gap between the billed charge and the allowed amount is a contractual allowance, a contra revenue account, not bad debt. You agreed to that discount in the payer contract, so it reduces revenue. Bad debt is money a patient owed and never paid. Confusing the two is the most common error in optometry books, and the same mechanics run through our guide to bank statements to QuickBooks for medical practices.

Frames bought from EssilorLuxottica, Safilo, Marchon, or Marcolin are an asset. They sit on the board until somebody buys them, so the purchase goes to inventory and moves to COGS only when the frame is dispensed. Expensing frame orders the month they clear the bank wrecks your margins: one buying show order makes a month look terrible and the next three look great. Lab work from Essilor, Hoya, or Zeiss is different, since a lab bill ties to a job already sold.

One caveat: not every frame on your board is yours. Plenty of vendors and buying groups supply boards on consignment or memo terms, where you're charged only when a frame sells. Those frames aren't your inventory and must not be capitalized, because you don't own them yet. Terms vary by vendor, so check the agreement.

The patient orders through you, the distributor ships the boxes to the patient's house, and you get billed for product the patient already paid for. That debit has no obvious matching deposit, because the card payment landed two days earlier inside a batch mixed with exams and glasses. Code it to contact lens COGS (or inventory, if you stock boxes). Annual supply prepayments can be deferred revenue rather than income if the boxes ship over time, so ask your CPA.

Your practice management system says you collected one number today. The bank shows a smaller deposit, because the processor takes its cut first. Split it: gross patient collections, refunds separately, and the processing fee as its own expense. CareCredit style financing also deposits net of a merchant fee, often a steeper one on promotional terms. Our walkthrough on importing bank statements into QuickBooks Online covers the upload step.

Practice management and EHR subscriptions, recall tools, and optical POS software are ordinary software expenses. The lane is where the real money sits. An OCT, a visual field analyzer, a fundus camera, an autorefractor, and the rest of the exam lane are capital assets, usually financed, and they get depreciated, not expensed.

The trap is the monthly draft. Your bank shows one clean number leaving the account, but it's two things: principal, which reduces the loan liability, and interest, which is an expense. Code the whole draft to expense and you overstate costs while the loan balance sits frozen. Pull the amortization schedule and split each payment. Leases have their own rules, so let your accountant classify yours.

Opticians, techs, scribes, front desk staff, and staff associate ODs are almost always W-2 employees, because you control the schedule, the location, the equipment, and how the work gets done. Split the payroll ACH per your provider's report: net pay, tax liabilities, and employer taxes go to different places.

A true locum tenens or fill in OD who sets their own terms, works for several practices, and carries their own malpractice coverage may be a legitimate independent contractor. It's a narrow category, and misclassifying a regular associate is expensive. If you do pay a contractor OD, the 1099-NEC reporting threshold is $2,000 for payments made on or after January 1, 2026. Flag that vendor for 1099 tracking in QuickBooks.

There's no national answer. Many states treat prescription eyeglasses and prescription contact lenses as exempt medical devices while taxing non-prescription sunglasses, readers, cases, and cleaning solutions. A few tax nearly everything sold in an optical. Check your own state's rules (and local rates) with your department of revenue or your CPA before configuring tax in QuickBooks. Tax you collect isn't revenue: it's a liability you hold for the state.

The workflow is short. Upload the PDF to the converter at the top of this page, download the .qbo file, and import it. In Desktop that's File > Utilities > Import > Web Connect Files. In QuickBooks Online it's the Transactions screen, then Upload from file, then map the .qbo to the right account. Importing by hand also means no live feed date limits.

Then build rules around the names that repeat on an optometry statement: VSP, EyeMed, Davis, Spectera, your medical payers, your processor, your frame vendors, your lab, your contact lens distributor, and your payroll provider. Rules handle the routine coding so your attention goes to the judgment calls. The bulk bank statement to QuickBooks workflow converts a stack of months at once, and firms with several optical clients should see the workflow built for accountants.

How do I import a bank statement into QuickBooks?

Convert the PDF statement to a .qbo (Web Connect) file first, because QuickBooks won't read a PDF. In QuickBooks Desktop, go to File > Utilities > Import > Web Connect Files and select the .qbo. In QuickBooks Online, open Transactions, choose Upload from file, and map the .qbo to the right bank account.

Should a VSP or EyeMed deposit be booked as income in QuickBooks?

No. A vision plan EFT is a lump payment against claims you already billed, so post it against accounts receivable and apply it to the individual patient claims rather than recording new income. Booking it as income double counts revenue, and your books will never reconcile to your practice management system.

Are frames inventory or an expense when I buy them?

Frames you own are inventory, an asset on the balance sheet, and they hit cost of goods sold only when a patient buys them. Expensing them the day the vendor invoice clears distorts your margins. The exception is a consignment or memo board, where you don't own the frames until they sell.

What is a contractual allowance and why does it matter?

A contractual allowance is the difference between what you billed a payer and what that payer's fee schedule allows, and it's a contra revenue account that reduces gross revenue. It is not bad debt, which is money a patient owed and never paid. Coding contractual write offs as bad debt makes your revenue unreliable.

Why doesn't my card deposit match the day's sales?

Because the processor takes its fee before depositing, so the bank shows a net figure while your practice management system shows gross collections. Split the deposit in QuickBooks into gross sales, refunds, and merchant fee expense. CareCredit style financing works the same way and usually carries a higher fee.

Do I charge sales tax on glasses and contact lenses?

It depends on your state. Many states exempt prescription eyeglasses and prescription contact lenses as medical devices while taxing non-prescription sunglasses, readers, cases, and cleaning solutions, and a few tax nearly everything sold in an optical. Check the rules with your state department of revenue or your CPA.