Bank Statement to QuickBooks for Optical Labs: Convert PDF Statements to QBO

A wholesale optical lab is a factory. You buy lens blanks and pucks, then surface, coat, tint, and edge them into finished prescription jobs that ship to optometry practices and opticians on account. Your customers are businesses, not patients, and there is no vision-plan billing at the lab level. The accounting that matters is inventory, work in process, and job cost, not contractual allowances. The converter gives you a clean, dated record of every supplier draft, card charge, and practice deposit to build those numbers on. Start with the PDF to QBO converter.

When you buy finished single-vision stock, semi-finished blanks, or free-form pucks from a supplier such as Essilor, Hoya, Shamir, Zeiss, or a VSP Optics private-label line, that is inventory: a balance-sheet asset the day the ACH draft clears. It does not become cost of goods sold until a job that uses it is finished and shipped. Post the purchase to an inventory asset account, then relieve it to COGS as jobs complete. Expense every blank order the month it hits the bank and your margin swings wildly, heavy when you restock and thin when you ship, while the profit on any single job stays invisible.

Coating chemistry, AR and hardcoat materials, tint dyes, edging supplies, and stock frames follow the same logic. Larger stock orders are inventory you draw down; small consumables can be expensed as bought when tracking them by unit costs more than it is worth. Set that threshold once with your CPA.

A job that has been surfaced but not yet coated, edged, or shipped is work in process. It already carries real value, the blank plus the lab labor consumed so far, but it is not COGS until the job ships and you invoice the practice. Think of WIP as partially completed inventory: material plus lab labor on unfinished jobs sits in a WIP account and moves to cost of goods sold when the job ships. Carrying WIP at month end keeps the timing of cost and revenue lined up.

Per-job costing is optional but worth it. Tie the blank, coating, and any outside service to a specific job number and gross margin per job becomes visible, so you can see which lens designs and which accounts actually make money. The imported statement is the source for the material and outside-service side of each job.

You invoice a practice when its job ships and carry the balance as accounts receivable, usually net 30. When that practice's ACH or check deposit lands on your bank statement, it is a payment against AR for jobs already invoiced, not fresh income at deposit time. If your system already booked revenue at invoice, recording the deposit as income again double-counts it: once at invoice, once at deposit. Receive the payment against the open invoice instead, so income is stated once. The guide to importing a statement into QuickBooks Online walks through matching those deposits after the .qbo import.

Labs routinely farm out certain steps: a specialty AR coating, a digital free-form surface, or a drill-mount, sent to another lab or back to the manufacturer. That outside-processing invoice is a direct cost of the specific job, not office overhead. Post it to an outside services or subcontracted lab account inside cost of goods sold, and tie it to the job number. Bury it in general expenses and your in-house margin looks better than it is, while the true cost of the jobs you outsource disappears.

Inbound freight on blanks and frames is part of the cost of that inventory, so it belongs with the goods it delivered, not a catch-all shipping expense. Outbound shipping, the daily UPS and FedEx runs that send finished jobs to your accounts, is a fulfillment expense (or a cost you bill back to the practice). Inbound freight quietly raises the cost of every job you make, so collapsing the two into one line hides both.

Generators and surfacing equipment, edgers, AR and coating chambers, blockers, and tracers are the capital core of the lab. Bought outright, each is a fixed asset you capitalize and depreciate over its useful life, not an expense in the month of purchase. When you finance or lease equipment, the monthly draft is one number with two parts: the principal portion pays down the loan liability, and the interest portion is an expense. A genuine operating lease is simply rent. Book the whole draft as one expense and your costs are overstated while the loan balance never moves. A converted Desktop statement gives you the exact draft dates to build that recurring split against.

For the few practices that pay by card, the processor batches charges into one payout that is net of its fee, so the deposit never equals the invoices it covers. Record it in parts: the gross the practices paid as a payment against their receivables, and the processor fee as a merchant fee expense, so the two net to the deposit line. Say a practice paid 1,000 and the processor kept 29: book 1,000 to AR and 29 to merchant fees, and the 971 deposit ties out. Post only the net and your fee expense vanishes while receivables never clear to the right balance.

Surfacing, finishing, and coating technicians, edging techs, QC staff, and delivery drivers are almost always W-2 employees, and their pay runs through payroll, not a contractor account. The narrow exception is a genuine independent contractor, for example a courier who sets their own terms and serves other clients; track that pay in a contract labor account so it totals cleanly at year end. The 1099-NEC reporting threshold is $2,000 for payments made on or after January 1, 2026, and is indexed after that. Classification follows the IRS control test, so confirm any close call with your CPA.

Wholesale sales of finished lens jobs to a practice for resale are generally exempt when you hold a valid resale or exemption certificate from that account, because the practice, not your lab, collects tax from the end wearer. That is not automatic. Any direct-to-consumer sales you make, and the treatment of certain materials, vary by state. Collect resale certificates where your state requires them and verify your treatment with a CPA rather than assuming any sale is exempt. Your customers, the optometry practices you sell to, face their own tax and payer rules downstream.

How do I import a bank statement into QuickBooks?

Convert the PDF or image statement to a .qbo file with the converter at the top of this page, then import it. In QuickBooks Desktop, go to File, then Utilities, then Import, then Web Connect Files. In QuickBooks Online, go to Transactions, then Bank transactions, then Upload from file, and map the columns before you categorize.

Are lens blanks inventory or an expense in QuickBooks?

Lens blanks and semi-finished pucks are inventory, a balance-sheet asset, the day you buy them. Post the purchase to an inventory asset account, then relieve it to cost of goods sold as jobs that use the blanks are finished and shipped. Expensing blanks at purchase distorts your margin and hides the true cost of each job.

How do I job cost lab work in QuickBooks?

Assign a job number, then tie the blank, coating materials, any outside service, and lab labor to it. Carry unfinished jobs in work in process and move the cost to cost of goods sold when the job ships. The converted statement feeds the material and outside-service side so gross margin per job becomes visible.

Is a practice's payment income when it hits my bank?

No. If you invoiced the job when it shipped, the deposit is a payment against accounts receivable, not new income. Receive it against the open invoice so revenue is counted once. Booking the deposit as fresh income double-counts the job, once at invoice and again when the ACH or check arrives, and inflates your sales.

What is work in process for an optical lab?

Work in process is the value of jobs still on the bench: blanks that have been surfaced but not yet coated, edged, or shipped, plus the lab labor spent on them. It is partially completed inventory that sits in a WIP account until the job ships, then moves to cost of goods sold. Carrying WIP keeps cost and revenue timed together.

Do I charge sales tax on wholesale lens jobs?

Usually not, because a wholesale sale to a practice for resale is generally exempt when you hold a valid resale or exemption certificate from that account. Rules and any direct-to-consumer sales vary by state, and some materials are treated differently. Collect resale certificates where your state requires them and confirm your exact treatment with a CPA.