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

Convert PDF bank and card statements to QBO for QuickBooks Online or Desktop so orthodontic treatment contracts, patient autodrafts, and insurance post right.

Totals reconcile to the original QuickBooks Online and Desktop
Loved by bookkeepers and accountants 50K+ pages converted

PDF, JPG, PNG, BMP, HEIC, TIFF

Upload your bank statement

Orthodontic practices and their bookkeepers can upload a PDF bank or credit card statement to the converter at the top of this page and download a .qbo (Web Connect) file to import into QuickBooks Online or QuickBooks Desktop. The core accounting problem is timing: a course of treatment is sold as one contract fee but collected over 18 to 30 months, so the deposits landing on your statement are mostly payments against a contract you already booked, not fresh income for the month they arrive.

Last updated July 2026.

A real .qbo file QuickBooks accepts

Built for the statements US banks actually send, checked before it exports.

Reconciliation

Every total checked against the statement

The converter adds up the transactions it parsed and matches that to the statement total before you export, so nothing is silently dropped.

Web Connect

A genuine .qbo, not a renamed CSV

Valid OFX 1.02 with QuickBooks Web Connect headers. Online and Desktop import it as a standard bank feed.

OCR

Scans and phone photos read line by line

OCR runs before parsing, so a scanned or photographed paper statement comes out the same as a digital PDF.

Volume

A year of statements in one batch

Bulk upload for catch-up and cleanup work. Each file gets its own reconciliation check and its own exports.

Locked files

Password-protected PDFs handled

Enter the password on upload. Multi-column and multi-page statement layouts are parsed too.

Exports

Excel and CSV in the same download

One conversion, three files: the .qbo for QuickBooks, an XLSX to review, and a CSV for everything else.

How to convert your statement to QuickBooks

Three steps. No column-mapping wizard.

1

Upload the PDF statement

Drag in a PDF, a scan, or a phone photo. Password-protected and multi-page files are fine.

2

Review the reconciled rows

Every transaction is extracted and checked against the statement total. You see the parsed rows before exporting.

3

Import into QuickBooks

Download the .qbo and import it as a Web Connect bank feed. Excel and CSV are in the same download.

Questions worth answering

The specifics that decide whether the import is clean. If your case is not here, email [email protected].

The treatment contract is why ortho books look different

A full course of braces or clear aligners is priced as a single contract, often $4,000 to $7,000, but the patient pays it down over the life of treatment. That gap between when you collect the cash and when you earn it is the defining feature of orthodontic accounting. If you treat every autodraft as income the day it hits the bank, your monthly revenue swings with collections instead of with the work you actually performed.

Under accrual accounting, the contract fee is unearned (deferred) revenue when you book the case, and you recognize it over the treatment period. A common pattern recognizes a larger slice at banding and records to reflect the front-loaded chair work, then spreads the rest straight-line across the remaining months. Many smaller practices instead report on a cash basis, where the fee is income when collected. Accrual versus cash, and the exact recognition schedule, are a decision for your CPA. This page shows how to post the bank activity cleanly either way.

Convert the PDF statement first, then reconcile

Bank and card statements come as PDFs, and neither QuickBooks Online nor QuickBooks Desktop imports a PDF directly. Run the statement through the PDF to QBO converter to produce a .qbo Web Connect file, the same format your bank would push through a direct feed. Then follow the steps to import a bank statement into QuickBooks Online or, if you run a desktop company file, convert the statement for QuickBooks Desktop.

Starting from the real statement matters here because so much of what you see is net of a fee: autodraft batches, merchant card settlements, and lender payouts all arrive after a deduction. Working from the bank record forces you to book the gross amount and split out the fee, rather than quietly understating both revenue and expense.

Patient autodrafts and in-house financing

Most offices run recurring auto-debits through their practice-management system (Dolphin, Cloud9, OrthoTrac) or a servicing platform such as OrthoBanc or HealthiPlan. On the statement these usually land as one batch deposit covering many patients, and often net of a processing or servicing fee. Post the batch to the patients' contract balances, and split the fee out to a merchant or servicing expense account. Do not net the fee against revenue.

A $200 monthly autodraft is a payment against a contract you already recorded. On accrual books it mostly reduces the patient's contract receivable or the unearned balance; the income for that month comes from your recognition schedule, not from the size of the draft. On cash books the $200 is income when it clears. Either way, if the batch arrives as $2,940 after a $60 servicing fee on $3,000 of drafts, record $3,000 to the patients and $60 to expense so the two sides reconcile.

Third-party patient lending: CareCredit, LendingUSA, Sunbit

When a patient finances through CareCredit, LendingUSA, Sunbit, or a similar lender, the lender pays your practice most of the balance up front and keeps a merchant fee or discount. The patient then repays the lender, so the credit risk leaves your books. Treat the lump lender deposit as a payment against that patient's contract, reducing the receivable, and post the discount fee as an expense.

Say a patient's remaining balance is $5,000 and the lender funds $4,750 after a 5 percent discount. Debit cash $4,750, debit merchant discount expense $250, and credit the patient's contract receivable $5,000. The entry balances, the patient's balance goes to zero, and the fee is visible instead of buried. Do not record the deposit as new income; the income recognition still follows your treatment schedule.

Insurance with a lifetime orthodontic maximum

Dental and ortho plans usually pay a one-time lifetime orthodontic benefit, a fixed dollar cap, commonly released as an initial payment then monthly or quarterly installments while the case is active. Each insurance EFT is another payment against the patient's contract receivable, not standalone income. On an in-network plan, the difference between your fee and the insurance allowed amount is a contractual write-off (contra-revenue), not bad debt. Book it as an adjustment against the contract, and keep bad debt reserved for balances a patient genuinely fails to pay.

Card and merchant batches never match the day's charges

Front-desk card payments settle in a nightly batch that the processor deposits net of its fees, so the bank deposit almost never equals the charges you rang up that day. Record production gross and book the processor fee as an expense; a batch of $2,000 in charges that deposits as $1,942 means $58 of merchant fees, not $1,942 of revenue. This is the same net-of-fee pattern as the autodraft and lender deposits, and it is the most common reason a reconciliation drifts by a few dollars per day.

Refunds when treatment ends early

If a patient moves away or stops mid-treatment, you may owe back the unearned portion of what they paid. That refund reduces the contract liability (unearned revenue), because you are returning money for work you will not perform. It is not a marketing or office expense. Reverse the remaining deferred balance and pay the refund against it, so both the liability and the cash go down together and your recognized revenue for the completed months stays intact.

Supplies, lab, and per-patient aligner costs

Brackets, archwires, bands, and bonding materials are cost of services. Aligner lab fees, such as Invisalign trays from Align Technology or a ClearCorrect case, are also cost of services, and a large aligner invoice tied to one patient can be tracked as a job or patient cost so you can see the margin on that case. When these charges hit a business card, the QBO converter turns the card PDF into an importable file; from there you code each line to supplies, lab, or the specific patient job.

Equipment loans, payroll, and sales tax

Financed equipment such as treatment chairs, a cone-beam (CBCT) imaging unit, or an intraoral scanner shows up as one monthly draft, but that number combines principal and interest. Split it: the principal portion reduces the loan liability and the interest portion is an expense. Your lender's amortization schedule tells you the exact split each month, which the bank statement alone will not.

Your clinical assistants, treatment coordinators, front-desk team, and any associate orthodontists on payroll are W-2 employees. A true independent contractor associate who sets their own hours and terms is the narrow exception; if you pay one, the 2026 Form 1099-NEC reporting threshold is $2,000. Orthodontic treatment is generally not subject to sales tax, but if you sell retail items like electric toothbrushes or whitening kits, some states tax those goods, so confirm the rule for your state.

What shows up on the statement, and where it goes
What appears on the bank statementWhat it actually isWhere it belongs in QuickBooks
OrthoBanc / HealthiPlan batch depositAutodraft collections, net of a servicing feePayment against patient contracts; fee split to servicing expense
Daily card settlement depositFront-desk card payments, net of processor feesGross to patient balances; processor fee to merchant expense
CareCredit / LendingUSA / Sunbit depositLender funding a patient balance, net of discountReduce patient contract receivable; discount to fee expense
Insurance EFT (delta dental, etc.)Installment of a lifetime ortho benefitPayment against patient contract receivable
Patient personal ACH or checkDirect payment on a treatment contractReduce contract receivable / unearned balance
Refund to a patientReturn of unearned fee on ended treatmentReduce unearned (deferred) revenue liability
Align Technology chargeInvisalign aligner lab feeCost of services (lab), optionally to patient job
Ortho supply distributor chargeBrackets, wires, bonding materialsCost of services (clinical supplies)
Equipment loan draft (scanner, CBCT)Principal plus interest combinedSplit: principal to loan liability, interest to expense
Payroll / payroll service debitW-2 wages and payroll taxesWages and payroll tax expense; liabilities
Practice-management software debitDolphin / Cloud9 subscriptionSoftware or dues and subscriptions expense
Merchant or servicing statement feeMonthly processor or platform chargeMerchant / bank service charge expense
Frequently asked questions

How do I import a bank statement into QuickBooks?

Convert your first statement free.

Upload a PDF, get a QuickBooks-ready .qbo back in seconds. No card to try it.

Related guides

QuickBooks will not read a PDF, so convert the statement to a .qbo Web Connect file first, then import it. Upload your PDF to the converter at the top of this page, download the .qbo, and use File then Import in Desktop or the bank feed upload in Online. Our QuickBooks Online import guide walks each step.

Is a patient's monthly orthodontic payment income when I receive it?

On accrual books, no. The autodraft is a payment against a contract you already recorded, so it mostly reduces the patient's receivable or unearned balance; income follows your recognition schedule. On cash-basis books, the payment is income when it clears. Which method you use is a decision for your CPA.

How do I record orthodontic treatment contracts in QuickBooks?

Book the full case fee as a receivable with an offsetting unearned (deferred) revenue liability when treatment starts. Recognize revenue over the treatment period, often a larger amount at banding then straight-line for the remaining months. Patient, insurance, and lender payments reduce the receivable as they arrive. Cash-basis practices skip the deferral and record income on collection.

How should I record a CareCredit deposit in QuickBooks?

Treat it as the lender paying down a patient's balance. Debit cash for the net deposit, debit merchant discount expense for the fee the lender kept, and credit the patient's contract receivable for the full amount financed. The patient now repays CareCredit, not you, so the balance clears and the discount shows as an expense.

Is orthodontic insurance a lifetime benefit?

Usually yes. Most dental plans pay a one-time lifetime orthodontic maximum, a fixed dollar cap per patient, often released as an initial payment then installments while treatment is active. Each payment reduces the patient's contract receivable. On in-network plans, the gap between your fee and the allowed amount is a contractual write-off, not bad debt.

Do I charge sales tax on orthodontic treatment?

Generally no. Orthodontic services are not typically subject to sales tax. The exception is retail goods some offices sell, such as electric toothbrushes or whitening kits, which certain states tax as tangible products. Rules vary by state, so confirm your state's treatment of retail dental items with your accountant.

Ready to post a month of activity? Convert your PDF bank or card statement to a .qbo file with the converter at the top of this page, then import it into QuickBooks Online or Desktop. Handling several offices or a full client roster? See the bulk statement converter, the workflow built for accountants, or our sibling guide for medical practices.

More bank statements we convert to QuickBooks

Same converter, tuned for the layout each bank uses. Find yours: