PDF Bank Statement to QuickBooks for Assisted Living: Convert Senior Care Statements to QBO

An assisted living community runs at least two bank accounts that behave nothing alike. The operating account collects private pay drafts from families, long-term care insurance reimbursements, VA Aid and Attendance benefits, and state Medicaid waiver payments, then pays out payroll, food, and med-tech agency invoices. The resident trust account holds money that is not yours at all, and every dollar in it has to be traceable to one named resident. PDFQBO converts each PDF statement into a QuickBooks QBO file so both accounts land in your books with the right dates and amounts, ready to reconcile.

Quick answer

To get an assisted living facility bank statement into QuickBooks, convert the PDF to a QBO file first. Upload the operating account statement to PDFQBO, review the private pay deposits, insurance and VA payments, Medicaid waiver remittances, and vendor payments it reads, and download a QBO (Web Connect) file. Import that file into QuickBooks Online or Desktop. Convert the resident trust account statement the same way, but post every line against a resident funds held in trust liability account, tagged to the resident by name, so the trust bank balance always equals the sum of the resident sub-ledgers.

Operating and trust accounts Per-resident detail preserved Review before import

Last updated July 2026

Convert an assisted living statement to QBO

Upload an operating or resident trust account PDF and download a QBO file for QuickBooks.

No credit card required to try your first statement.

Any bank

Operating and trust

QBO + IIF

Online and Desktop

Multi-entity

One community or twenty

Auto delete

Files removed after use

How to convert an assisted living bank statement to QuickBooks

Four steps take you from a PDF statement to a QBO file QuickBooks accepts, whether the account is the operating account or the resident trust account.

Gather the PDFs

Download the monthly statement for the operating account, the resident trust or personal needs account, and any payroll or petty cash account. Multi-site operators pull one set per community.

Upload to the converter

Drag the statements into the tool above. A month with sixty resident drafts converts as easily as a quiet one, and you can upload several months at once when you are catching up or preparing for a survey.

Review the transactions

PDFQBO reads the date, description, and amount on every line and keeps deposits and withdrawals on the correct side. Check the table, confirm the resident names and remittance references survived, then export QBO or IIF.

Import and categorize

Upload the QBO file from the Banking screen in QuickBooks Online, or import the Web Connect or IIF file in Desktop. Then apply resident payments to their invoices and post trust activity to the liability account by name.

Why assisted living books are hard to get into QuickBooks

The resident trust account holds money that is not yours

When a community manages spending money for residents, those funds are a liability, not revenue. Federal nursing facility rules are explicit that resident funds may not be co-mingled with facility operating funds, and many state assisted living regulations follow the same principle. You are allowed to hold everyone's money in a single bank account, but only if you keep a separate written accounting for each resident, so the pooled bank balance has to reconcile to the sum of dozens of individual sub-ledgers. A bank feed will never give you that split. It gives you one line that says a $40 withdrawal happened. Which resident it belonged to, and whether it was the beauty shop or a pharmacy copay, lives in the memo, the check register, or the front-desk log, and the reconciliation is only defensible if every one of those lines is in QuickBooks with its date, amount, and description intact.

Four payers fund the same resident, on four different schedules

A single resident's monthly bill can be paid from several directions at once. The family drafts the private pay portion on the first. A long-term care insurance carrier reimburses on its own cycle, often in arrears and often net of an elimination period. VA Aid and Attendance lands as a benefit deposit, sometimes directly to the resident and sometimes to the community. A state Medicaid waiver or HCBS program remits on a schedule nobody at the community controls, occasionally as one lump covering many residents. None of those deposits look alike on the statement, and only the remittance detail says which resident and which service month each one covers. Getting them into QuickBooks with exact dates is what lets you apply them to the right invoice instead of dumping everything into a single resident revenue line.

Level-of-care charges change month to month

Base rent is the easy part. On top of it sit care level tiers that move when a resident's assessment changes, plus medication management fees, incontinence supplies, escort or two-person transfer charges, guest meals, salon services, and a second-occupant fee. A resident who moved from level two to level four in the middle of the month generates a prorated charge nobody expected. When the deposit that finally arrives does not match the base rate, you need the actual bank line, dated, to reconcile against the billing system rather than guessing which month it settled.

Move-ins and move-outs create prorations and refunds

A move-in usually brings a community fee or one-time move-in fee plus a prorated first month. A move-out brings the opposite: a partial-month refund, a security or care deposit returned, and in the case of a death, a final settlement of the resident's trust balance paid to the estate. These are low-volume, high-scrutiny transactions. Regulators and families both look at them closely, and a trust balance refunded to the wrong party or at the wrong time is the kind of finding that follows a community around. Each one needs to be a dated line in the ledger, not a note in a spreadsheet.

Operators run several entities and several communities

It is common for the building to sit in a property company and the operations in a separate operating company, with rent paid between them, and for a growing operator to add a third and fourth community each with its own accounts. That multiplies the number of statements someone has to key in every month, and a bank feed has to be established and maintained separately for each one. Converting the PDFs is the path that scales with the entity count instead of fighting it, especially for the smaller local banks and credit unions where these accounts are often opened.

Built for senior living and care facility books

One tool for every account a community runs, so a month closes in minutes instead of an evening of typing.

Trust account lines kept whole

Every deposit and disbursement in the resident trust account comes through with its date, amount, and description, which is what you need to tie the pooled bank balance back to each resident's sub-ledger.

Every payer type read the same

Family drafts, insurance reimbursements, VA benefit deposits, and state waiver remittances all arrive as clean dated lines, so you can apply each one to the resident and service month it belongs to.

Multiple communities at once

Upload statements from several buildings and entities in one session. Each converts to its own QBO file, so you import into the right company file without re-keying anything.

Catch-up and survey prep

When a surveyor or an auditor asks for a trust reconciliation going back a year, converting twelve statements at once beats retyping them. Older months convert exactly the same as last month's.

No feed required

Trust and operating accounts are often opened at a small community bank or credit union with no QuickBooks connection at all. The PDF statement works regardless of whether a feed exists.

Reads any bank's layout

A national bank, a regional lender, or a local credit union each format a statement their own way. PDFQBO finds the transaction rows on each one and leaves out the summary boxes that are not transactions.

Who uses it in senior care

Anyone keeping a care community's books in QuickBooks from PDF statements.

Assisted living and memory care communities

Private pay is the bulk of revenue, care levels move monthly, and the trust account has to reconcile per resident. Converting both statements gets the whole month into QuickBooks with dates that match the billing system.

Residential care homes and board and care

Six to sixteen beds, one owner-operator, and often no in-house bookkeeper. A converter turns the monthly statement into an import instead of a night of data entry after the caregiving shift ends.

Adult day care and adult day health programs

Attendance-based billing, heavy Medicaid waiver and grant funding, and transportation costs. The remittances arrive on the payer's schedule, so complete dated books are how you know which program periods have actually been funded.

Bookkeepers and CPAs with senior care clients

Clients hand you an operating statement, a trust statement, and a resident roster that do not obviously line up. One converter for every account gives you a repeatable monthly close and a trust reconciliation you can hand to a surveyor.

Common assisted living categories once the transactions are in

Once the statements are converted and imported, you code each transaction to an account. These are the accounts a care community leans on most. The one that matters more than any other is the trust liability, because it is the only account where a wrong number is a regulatory problem rather than just a bad report.

• Resident funds held in trust a liability account, never income, with a sub-account or name tag per resident so the balance can be proven individually.
• Resident service revenue split between base rent or room and board, care level fees, and ancillary charges so occupancy and acuity can be read separately.
• Community and move-in fees kept apart from monthly revenue, since they are one-time and may be refundable in part.
• Salaries, agency staffing, and payroll taxes with contract med techs and caregivers separated from employees, because agency cost is the number that moves margin.
• Dietary and food service which is a large, steady, per-resident-per-day cost worth tracking on its own.
• Housekeeping, laundry, and plant operations including maintenance, utilities, and life safety inspections.
• Licensing, liability insurance, and professional fees which are heavy in this sector and belong in their own accounts.
• Rent or mortgage to the property entity if the building is held separately, recorded as an intercompany payment rather than an operating expense guess.

For the deposits families pay at move-in, see recording a security deposit in QuickBooks, and for a family that pays part of the bill now and the rest when insurance settles, see handling a partial payment or deposit. When a resident moves out mid-month and money goes back, see handling a customer refund. For coding the imported lines, see categorizing bank transactions in QuickBooks.

Frequently asked questions

How do I set up resident trust accounts in QuickBooks?

Set up one bank account in QuickBooks for the pooled trust bank account and one liability account named resident funds held in trust. Do not create a separate bank account per resident. Instead, record each deposit and disbursement against the liability using the resident's name, so you can run a report by name that proves each resident's balance. The trust bank balance and the total of the liability must agree every month, and the per-name detail is what a surveyor or auditor asks to see.

Can resident trust funds be kept in one bank account?

Yes, in most cases resident funds may be held in a single pooled bank account, but only if the facility maintains a separate written accounting for each resident showing every deposit, withdrawal, and any interest earned. What is prohibited is co-mingling resident money with the facility's own operating funds. Rules vary by state and by license type, so confirm the requirements with your state licensing agency before you design the account structure.

Is QuickBooks good for an assisted living facility?

QuickBooks handles the general ledger, accounts payable, payroll, and financial statements for a care community well, and it is what most small and mid-size operators use. What it does not do is resident census, care level assessments, or eMAR, so communities usually pair it with a resident management platform and treat QuickBooks as the accounting book of record. Converting your statements is what keeps the two systems agreeing with each other.

How do I record a Medicaid waiver payment in QuickBooks?

Record the deposit as it appears on the bank statement, then apply it against the specific resident invoices the remittance advice covers. State waiver programs often pay one lump sum for several residents and several service dates, so the deposit amount rarely matches a single invoice. Split the deposit across the invoices it settles rather than posting the total to a single revenue line, or your accounts receivable by resident will never clear.

How do I record a resident's personal needs allowance?

Treat it as trust money, not revenue. When the allowance is deposited into the trust account, increase the trust bank account and increase the resident funds held in trust liability under that resident's name. When the resident spends it at the salon or on a pharmacy copay, decrease both. The community never recognizes income on those dollars; it is only holding and disbursing them on the resident's behalf.

How do I get an assisted living facility bank statement into QuickBooks?

Convert the PDF statement to a QBO file, then import it. Upload the operating or trust account statement to PDFQBO, review the resident payments, insurance and waiver deposits, and vendor disbursements it reads, and download a QBO (Web Connect) file. In QuickBooks Online you upload it from the Banking screen; in Desktop you import the Web Connect or IIF file. Then apply each line to the resident or vendor it belongs to.

What accounting software do assisted living facilities use?

Most independent and mid-size operators run QuickBooks Online or Desktop for accounting alongside a senior living platform such as PointClickCare, Yardi Senior Living, ALIS, or Eldermark for census, care plans, and resident billing. Large multi-site operators sometimes move to Sage Intacct. Whatever sits on top, the bank statement stays the source of truth for what actually cleared, which is why converting it keeps the accounting side complete.

Get your community's statements into QuickBooks

Upload an operating or resident trust account PDF, review the deposits and disbursements, and download a QBO file QuickBooks accepts. No install, and your first conversion is on us.

Convert a statement View pricing