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.
Upload your bank statement
Drop file here or click to upload
PDF, JPG, PNG, BMP, HEIC, TIFF
Uploading...
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.
Built for the statements US banks actually send, checked before it exports.
The converter adds up the transactions it parsed and matches that to the statement total before you export, so nothing is silently dropped.
Valid OFX 1.02 with QuickBooks Web Connect headers. Online and Desktop import it as a standard bank feed.
OCR runs before parsing, so a scanned or photographed paper statement comes out the same as a digital PDF.
Bulk upload for catch-up and cleanup work. Each file gets its own reconciliation check and its own exports.
Enter the password on upload. Multi-column and multi-page statement layouts are parsed too.
One conversion, three files: the .qbo for QuickBooks, an XLSX to review, and a CSV for everything else.
Three steps. No column-mapping wizard.
Drag in a PDF, a scan, or a phone photo. Password-protected and multi-page files are fine.
Every transaction is extracted and checked against the statement total. You see the parsed rows before exporting.
Download the .qbo and import it as a Web Connect bank feed. Excel and CSV are in the same download.
The specifics that decide whether the import is clean. If your case is not here, email [email protected].
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.
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.
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.
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.
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.
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.
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 appears on the bank statement | What it usually is | Where it goes in QuickBooks |
|---|---|---|
| Patient card payment (deposit net of fee) | Revenue for a rendered visit | Treatment income (record gross; fee posted separately) |
| Package prepayment | Cash received for care not yet delivered | Unearned revenue (liability) until visits are used |
| HSA or FSA card payment | Ordinary card payment for a visit | Treatment income; fee to merchant expense |
| Copay collected at check-in | Revenue earned at time of service | Treatment income (kept separate from packages) |
| Retail orthotics or supplement sale | Product sale plus cost of the item sold | Retail revenue; cost to cost of goods sold |
| Sales tax remittance | Tax you collected, now paid to the state | Clears sales tax payable (liability), not an expense |
| EMR or practice-management subscription | Software you use to run the clinic | Software or dues and subscriptions expense |
| Clinic rent | Lease payment for the space | Rent expense |
| Clinical supplies | Tape, electrodes, linens, consumables | Supplies expense |
| Contract PT payment | Pay to a 1099 contract therapist | Contract labor expense (track for 1099-NEC) |
| Merchant processing fee | Cost of accepting card payments | Merchant or bank fees expense |
| CE or continuing-education tuition | Course or license training cost | Continuing education expense |
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.
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.
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.
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.
Upload a PDF, get a QuickBooks-ready .qbo back in seconds. No card to try it.
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.
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.
Same converter, tuned for the layout each bank uses. Find yours:
For one bookkeeper running monthly close.
USD
per month
billed as
$288 yearly
Choose speed vs accuracy when extracting
| Base AI Faster | 2,500 pages |
| Pro AI Best accuracy | 500 pages |
For an accounting firm or finance team with steady volume. Adds QuickBooks .qbo export and bulk conversion.
USD
per month
billed as
$888 yearly
Choose speed vs accuracy when extracting
| Base AI Faster | 10,000 pages |
| Pro AI Best accuracy | 2,000 pages |
For lenders, audit firms and analysts running thousands of statements a month.
USD
per month
billed as
$ yearly
Choose speed vs accuracy when extracting
| Base AI Faster | pages |
| Pro AI Best accuracy | pages |