Bank Statement to QuickBooks for Physical Therapy Clinics: Convert PDF Statements to QBO

Convert a physical therapy or chiropractic clinic's PDF bank statement to QuickBooks with a .qbo file, and code prepaid care, superbills and HSA cards 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

You 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 that imports straight into QuickBooks Online or Desktop, with Excel and CSV also available if you prefer a spreadsheet. A cash-based rehab clinic's statement is harder to code than most because the deposits blend things that belong in different places on the books: prepaid care packages that are not yet earned, out-of-network patients who pay in full and take a superbill home, HSA and FSA debit card payments that arrive net of a processor fee, and retail sales of orthotics or supplements that carry inventory and sales tax. This page walks through how each of those lands in QuickBooks.

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

Cash-pay treatment packages are unearned revenue until each visit is delivered

When a patient prepays for a plan of care, say a 12-visit package bought up front, that money is not income the day it hits your bank account. It is a liability, usually called unearned or deferred revenue, because you still owe the patient care. You recognize the revenue visit by visit as treatment is actually rendered. Buy a 12-visit package for $1,200, and each completed visit moves $100 from the liability into income.

The practical trick is to track the remaining visit balance so the liability on your books always equals the care you still owe. Some clinics keep this in the practice-management system and reconcile the total to QuickBooks monthly; others post each visit's earned portion with a journal entry. Either way, do not book the whole package as revenue on day one, or your income will spike in the sale month and go flat during the weeks you are doing the actual work.

Out-of-network superbills mean you carry no insurance receivable

This is the distinction that separates a cash-pay clinic from an in-network one. In an out-of-network model the patient pays your clinic in full at the time of service, so that payment is revenue when the visit happens. You then hand the patient a superbill, an itemized receipt with CPT and diagnosis codes, so they can seek reimbursement directly from their own insurer. The clinic is done once it is paid.

Because the patient bears the reimbursement risk, your clinic never books an insurance accounts receivable and never records a contractual allowance. There is no claim sitting open on your books and no adjustment for the difference between billed and allowed amounts. Contrast that with an in-network practice, which bills the payer, waits weeks to be paid, and writes off the contractual portion. If you give patients superbills, skip all of that. Your revenue is simply what the patient paid you.

HSA and FSA cards are just a payment method

Patients frequently pay with a health savings account (HSA) or flexible spending account (FSA) debit card. On your books that is an ordinary card payment, nothing exotic. The revenue is recognized when the visit is rendered, exactly as it would be for a Visa or Mastercard, and the card processing fee is a business expense.

What shows up on the bank statement is usually the deposit net of the processor's fee, so a $150 visit paid by FSA card might land as roughly $145 after the merchant charge. Record the full $150 as revenue and the difference as a merchant fee expense, rather than only booking the net deposit. That keeps your gross revenue accurate and your processing costs visible.

Copays and coinsurance collected at the visit

If you do run any in-network visits, the copay or coinsurance you collect at check-in is revenue at the time of service. A $30 copay taken at the front desk is income the day of the appointment.

Keep these amounts separate from package prepayments in your chart of accounts. A copay is earned right away because the visit is happening; a prepaid package is a liability until the visits are used. Lumping them together muddies both your revenue timing and the liability balance you owe patients in future care.

Retail products: orthotics, braces, supplements and TENS units

Custom orthotics, cervical pillows, supplements, kinesiology tape and home TENS units that you resell are inventory, which is an asset while it sits on your shelf. When you sell an item, its cost moves to cost of goods sold and the sale itself is retail revenue, ideally tracked separately from treatment income so you can see the margin on products.

Any sales tax you collect on those retail items is not your money and not income. It is a liability you hold until you remit it to the state. Record the tax collected to a sales tax payable account, and when you send the payment to the tax authority it clears that liability rather than showing up as an expense.

Contractor PTs, locum therapists and 1099s

Per-diem physical therapists, locum coverage and other 1099 contractors you pay are reported on Form 1099-NEC, not on a W-2. Keep their pay in a contract labor expense account and collect a W-9 before you cut the first check so you have their taxpayer details ready at year end.

Watch the reporting threshold, which changed. For payments made on or after January 1, 2026, the 1099-NEC and 1099-MISC reporting threshold is $2,000 per payee for the calendar year, and it will be adjusted for inflation in later years. If you pay a contract therapist at or above that amount across 2026, you owe them a 1099-NEC. Tagging vendors as 1099-eligible in QuickBooks as you go makes January painless.

Getting the .qbo file into QuickBooks and building rules

The workflow is short. Upload your PDF statement to the QBO converter, download the .qbo file, and import it into QuickBooks through Web Connect on Desktop or the File Upload option in the banking screen on QuickBooks Online. If you would rather see the data first, the PDF to QBO converter also gives you Excel or CSV. There is a step-by-step guide to importing a bank statement into QuickBooks Online if you want the full walkthrough.

Once transactions are in, build bank rules for the vendors that repeat every month: clinic rent, your EMR or practice-management software like WebPT or Jane, continuing-education tuition, merchant processing, and clinical supplies. A rule that auto-categorizes WebPT to software and your landlord to rent means most of next month's statement codes itself, and you only review the exceptions.

What shows up on the statement, and where it goes
What appears on the bank statementWhat it usually isWhere it goes in QuickBooks
Patient card payment (deposit net of fee)Revenue for a rendered visitTreatment income (record gross; fee posted separately)
Package prepaymentCash received for care not yet deliveredUnearned revenue (liability) until visits are used
HSA or FSA card paymentOrdinary card payment for a visitTreatment income; fee to merchant expense
Copay collected at check-inRevenue earned at time of serviceTreatment income (kept separate from packages)
Retail orthotics or supplement saleProduct sale plus cost of the item soldRetail revenue; cost to cost of goods sold
Sales tax remittanceTax you collected, now paid to the stateClears sales tax payable (liability), not an expense
EMR or practice-management subscriptionSoftware you use to run the clinicSoftware or dues and subscriptions expense
Clinic rentLease payment for the spaceRent expense
Clinical suppliesTape, electrodes, linens, consumablesSupplies expense
Contract PT paymentPay to a 1099 contract therapistContract labor expense (track for 1099-NEC)
Merchant processing feeCost of accepting card paymentsMerchant or bank fees expense
CE or continuing-education tuitionCourse or license training costContinuing education expense
Frequently asked questions

How do I record prepaid physical therapy packages in QuickBooks?

Book the prepayment as unearned revenue, a liability, not as income. When a patient buys a 12-visit package for $1,200, the full amount sits in that liability account. As each visit is delivered you move the earned share (here $100 a visit) into treatment income, so the liability always equals the care you still owe.

Are cash-pay patient payments income when I collect them?

Yes, as long as the visit is being delivered. A single cash-pay visit paid at the time of service is revenue that day. The exception is a prepaid package covering future visits, which is unearned revenue (a liability) until you actually render each visit and recognize that portion as income.

Do I record an insurance receivable if I give patients a superbill?

No. When you give the patient a superbill, they collect from their own insurer, so your clinic carries no insurance accounts receivable and no contractual allowance. The patient already paid you in full, so your revenue is simply what they paid. The reimbursement is between the patient and their insurance company, not on your books.

How do I record HSA and FSA card payments in QuickBooks?

Treat them like any other card payment. Recognize the full visit fee as treatment income when the visit is rendered, then record the merchant processing fee as an expense. Because the bank deposit usually arrives net of that fee, post the gross revenue and the fee separately so your income and processing costs both stay accurate.

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

Convert your PDF statement to a .qbo file with the converter on this page, then import it. In QuickBooks Desktop use File, then Utilities, then Import, then Web Connect File. In QuickBooks Online, open Transactions, then Bank transactions, and use Upload from file. The import guide covers each step.

Can I convert a chiropractic clinic's PDF bank statement to QuickBooks?

Yes. The converter works for any chiropractic or physical therapy clinic statement in PDF form, and the same rules apply: prepaid care plans are unearned revenue, HSA and FSA cards are ordinary payments, and superbill patients leave you with no insurance receivable. Upload the PDF, download the .qbo, and import it into QuickBooks Online or Desktop.

Ready to clean up the books? Start with the bank statement converter on this page or the dedicated QBO converter, and if you handle several practices, the guide for accountants and bookkeepers shows how to batch the work. For related setups, see our pages on medical practices and veterinary clinics.

More bank statements we convert to QuickBooks

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