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.
Upload your bank statement
Drop file here or click to upload
PDF, JPG, PNG, BMP, HEIC, TIFF
Uploading...
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.
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].
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.
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.
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.
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.
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.
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.
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.
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 statement | What it actually is | Where it belongs in QuickBooks |
|---|---|---|
| Medicaid or Medicare EFT deposit | Payment against AR you already billed, net of contractual allowance | Receive payment on the open invoice, post the shortfall to contractual allowance |
| VA or private insurer ACH | Payer payment on invoiced visits | Receive payment, apply contractual adjustment if allowed differs from billed |
| Private-pay client card deposit (net of fee) | Client payment with processor fee taken out | Split: client revenue at gross, merchant fee as expense |
| ADP, Gusto, or Paychex debit | Bundled net wages, payroll taxes, and withholdings | Split into wages, employer taxes, and payroll liabilities |
| Payroll tax impound draft | Taxes the processor remits for you | Payroll tax liability |
| Medical supply and PPE ACH or card | Gloves, wound care, PPE | Supplies expense |
| Fuel or mileage reimbursement to caregiver | Accountable-plan reimbursement, not wages | Vehicle or reimbursement expense |
| EVV or EMR SaaS charge (WellSky, AlayaCare, Axxess) | Scheduling and visit-verification software | Software or subscriptions expense |
| Background-check and licensing fees | Compliance cost of onboarding | Operating or compliance expense |
| Franchise royalty ACH | Brand royalty on revenue | Franchise royalty expense |
| Franchise ad-fund or brand-fee draft | Marketing contribution to franchisor | Advertising or franchise fee expense |
| Owner distribution transfer | Money the owner takes out, not a cost | Owner'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.
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.
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.
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.
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.
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.
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.
Upload a PDF, get a QuickBooks-ready .qbo back in seconds. No card to try it.
Related pages: bulk statement conversion, the QBO converter, the workflow for accountants, guides for medical and dental practices and staffing and recruiting agencies, and how to record per-visit billing and payer receivables.
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 |