Bank Statement to QuickBooks for Home Health Agencies: Convert PDF Statements to QBO

Convert PDF bank and credit card statements into .qbo files for QuickBooks so a home health or home care agency can post payer deposits, payroll, and mileage.

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

Home health and home care agency owners and their bookkeepers can turn a PDF bank or credit card statement into a .qbo Web Connect file for QuickBooks Online or Desktop. Upload the statement to the converter at the top of this page, and it reads every line so Medicaid and Medicare deposits, payroll debits, medical supply purchases, and caregiver reimbursements post cleanly. You also get Excel and CSV copies for your accountant, and the tool reads either a PDF or an image.

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

Payer receivables and contractual allowances

A home health agency bills several payers at once: Medicare, state Medicaid programs, the VA, private insurance, and private-pay clients. The catch is that government and insurer payments almost never arrive at the amount you billed. They post net of a contractual adjustment, which is the difference between your billed charge and the amount the payer has agreed to allow under its fee schedule. That difference is not a bad debt and it is not lost income you can chase. It is a write-off you agreed to in advance.

Record the allowed amount as revenue and post the shortfall to a contractual-allowance contra-revenue account, not to bad debt expense. Bad debt is money a payer or client owes and will not pay. A contractual allowance is a negotiated reduction that you knew about when you sent the claim. Keeping the two apart is what lets your net patient service revenue actually tie to the cash you collect.

The long AR lag on government payers

You bill when the visit happens, but the cash lands weeks later. When the Medicaid or Medicare EFT finally hits the bank, it is a payment against accounts receivable you already invoiced, not fresh income to record a second time. If you book the deposit as new revenue, you double-count: once when you billed the visit and again when the money arrives.

Treat the EFT as receive-payment against the open AR, then apply the contractual adjustment so the invoice closes to zero. This keeps your aging report honest and stops phantom revenue from inflating a month where you simply got paid for work booked earlier.

Per-visit and hourly billing

Home health revenue is earned as care is delivered, visit by visit or hour by hour, not when a lump payment shows up. A skilled nursing visit, a home health aide shift, or an hour of personal care becomes revenue at the point the service is provided. For Medicaid personal care and many state programs, electronic visit verification (EVV) data records the caregiver, the client, and the exact times, and that EVV record is what supports the claim you submit.

Because billing follows the visit and payment follows billing, your books carry a running receivable. Converting your bank statements gives you the deposit side of that cycle so you can match each EFT back to the visits it settles.

Payroll is the biggest line, and the ACH must be split

For most agencies, caregiver wages are the single largest expense, and the way payroll leaves the bank is easy to book wrong. When ADP, Gusto, or Paychex debits your account, that one number usually bundles net wages, payroll taxes, and employee withholdings together. Posting the whole debit to a single payroll expense account overstates wage expense and hides the employer tax and liability pieces.

Split the processor debit into its parts: gross wages, the employer share of payroll taxes, and the withheld amounts that the processor remits on your behalf. If you run a separate impound or tax draft, code it to the payroll liability it clears. Done this way, your payroll expense and your tax filings agree instead of drifting apart at year end.

Worker classification: W-2 or 1099

Home care aides and personal care attendants almost always fail the IRS and Department of Labor tests for independent contractor status, because the agency controls their schedule, methods, and clients, and the worker is economically dependent on the agency. Courts have repeatedly rejected 1099 treatment for these roles, and misclassification carries back wages and penalties. Treat aides as W-2 employees unless you have strong counsel telling you otherwise.

Some skilled clinicians, such as per-visit physical therapists, occupational therapists, or nurses who genuinely run their own practice, are sometimes paid as 1099 contractors, but that is a fact-specific call worth hedging with a professional. If you do pay contractors, note that the 1099-NEC reporting threshold is $2,000 for payments made on or after January 1, 2026.

Caregiver mileage and reimbursements

Aides and nurses drive between clients all day, and how you pay for that mileage changes how it is taxed. Mileage paid under an accountable plan, where the caregiver substantiates the miles and returns any excess, is a reimbursement and not taxable wages. It belongs in a vehicle or reimbursement expense account, kept separate from payroll.

If you fold mileage into a paycheck without an accountable plan, it becomes taxable compensation and you lose the clean deduction. Tracking reimbursements on their own line at import time keeps them out of your wage totals and makes the deduction easy to defend.

Medical supplies, PPE, software, and franchise fees

Gloves, wound-care supplies, incontinence products, and PPE are ordinary supplies expense. Keep them separate from durable equipment and from office supplies so you can see the true cost of delivering care. The software your agency runs also lands on the statement: EVV systems, scheduling and EMR platforms such as WellSky, AlayaCare, or Axxess, plus background-check and state licensing fees, are all operating expenses.

One more hedge worth naming: many home care agencies operate as franchises rather than independents. If yours is a franchise, the royalty draft and the ad-fund or brand-fee ACH are operating expenses, not owner draws or cost of goods. Independent agencies simply skip those lines. Either way, code the recurring drafts consistently so month-to-month reports stay comparable.

What shows up on the statement, and where it goes

The deposit and debit descriptions on a home health statement rarely explain themselves. Here is how the common ones map into QuickBooks.

What appears on the bank statementWhat it actually isWhere it belongs in QuickBooks
Medicaid or Medicare EFT depositPayment against AR you already billed, net of contractual allowanceReceive payment on the open invoice, post the shortfall to contractual allowance
VA or private insurer ACHPayer payment on invoiced visitsReceive payment, apply contractual adjustment if allowed differs from billed
Private-pay client card deposit (net of fee)Client payment with processor fee taken outSplit: client revenue at gross, merchant fee as expense
ADP, Gusto, or Paychex debitBundled net wages, payroll taxes, and withholdingsSplit into wages, employer taxes, and payroll liabilities
Payroll tax impound draftTaxes the processor remits for youPayroll tax liability
Medical supply and PPE ACH or cardGloves, wound care, PPESupplies expense
Fuel or mileage reimbursement to caregiverAccountable-plan reimbursement, not wagesVehicle or reimbursement expense
EVV or EMR SaaS charge (WellSky, AlayaCare, Axxess)Scheduling and visit-verification softwareSoftware or subscriptions expense
Background-check and licensing feesCompliance cost of onboardingOperating or compliance expense
Franchise royalty ACHBrand royalty on revenueFranchise royalty expense
Franchise ad-fund or brand-fee draftMarketing contribution to franchisorAdvertising or franchise fee expense
Owner distribution transferMoney the owner takes out, not a costOwner's draw or distribution (equity)

The Medicaid and Medicare rows are the ones agencies most often mishandle. Booking that EFT as new revenue instead of a payment against AR double-counts income and leaves the contractual allowance unrecorded, so the aging report never clears.

Frequently asked questions

How do I record Medicaid payments in QuickBooks?

Record the Medicaid EFT as receive-payment against the invoice you already sent for those visits, not as new income. The deposit usually arrives net of a contractual allowance, so apply that shortfall to a contra-revenue account and close the invoice to zero. Keep the remittance so you can match the payment to specific claims.

How do I record a contractual adjustment in QuickBooks?

Post the difference between your billed charge and the payer's allowed amount to a contractual-allowance contra-revenue account, not to bad debt. It is a reduction you agreed to under the payer contract, so it reduces net patient service revenue rather than becoming an expense. This keeps revenue tied to the cash you actually collect.

Are home care aides W-2 or 1099?

Home care aides and personal care attendants are almost always W-2 employees. The agency controls their schedule, methods, and clients, so they fail the IRS and DOL independent-contractor tests, and misclassification brings back wages and penalties. Some per-visit skilled clinicians who run their own practice are sometimes 1099, but confirm that with counsel.

How do I record caregiver mileage in QuickBooks?

If you pay mileage under an accountable plan where caregivers substantiate their miles, record it as a reimbursement in a vehicle or reimbursement expense account, not as wages. That keeps it out of taxable pay and preserves the deduction. Without an accountable plan, the mileage becomes taxable compensation and runs through payroll instead.

How do I split a payroll ACH in QuickBooks?

A payroll processor debit from ADP, Gusto, or Paychex usually bundles net wages, payroll taxes, and withholdings into one number. Split that transaction into gross wages, the employer share of taxes, and the payroll liabilities the processor remits. Booking it as a single lump expense overstates wages and hides your tax and withholding amounts.

How do I import a bank statement into QuickBooks?

Convert each PDF statement into a .qbo file with the tool above, then upload it. In QuickBooks Online, go to Transactions, then Bank transactions, then Upload from file. In QuickBooks Desktop, use File, then Utilities, then Import, then Web Connect. Convert bank, credit card, and payroll accounts separately so each one reconciles on its own.

Convert your first statement free.

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

More bank statements we convert to QuickBooks

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