PDF Bank Statement to QuickBooks for Funeral Homes: Convert Funeral Home Statements to QBO

A funeral home takes in money it is not allowed to call income yet, pays out money that was never its own, and waits weeks for a life insurer to fund a service it already delivered. Preneed deposits, insurance assignments, pass-through cash advance items, and family installment payments all move through the same operating account, and none of them mean what a plain bank line makes them look like. PDFQBO converts each PDF statement into a QuickBooks QBO file so every deposit and disbursement lands in your books with the right date and amount, ready to be coded to the right account.

Quick answer

To get a funeral home bank statement into QuickBooks, convert the PDF to a QBO file first. Upload the operating account statement to PDFQBO, review the insurance assignment funding, preneed and trust transfers, family payments, and vendor disbursements it reads, and download a QBO (Web Connect) file. Import that file into QuickBooks Online or Desktop, then code each line: preneed money to a deferred revenue or trust liability account, cash advance items to a pass-through account rather than income, and service revenue only when the service is delivered.

Preneed and trust transfers Insurance assignment funding Review before import

Last updated July 2026

Convert a funeral home statement to QBO

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

No credit card required to try your first statement.

Any bank

Operating, trust, card

QBO + IIF

Online and Desktop

Multi-location

One chapel or five

Auto delete

Files removed after use

How to convert a funeral home statement to QuickBooks

Four steps take you from a PDF statement to a QBO file QuickBooks accepts, whether the money is an insurance assignment coming in or a cash advance going back out.

Gather the PDFs

Download the monthly statement from the operating account where insurance funding lands and vendors get paid, plus the preneed trust account and any card you buy merchandise and supplies on.

Upload to the converter

Drag the statements into the tool above. A heavy winter month converts as easily as a quiet one, and you can upload a whole year at once when you are catching up books before an audit or a sale.

Review the transactions

PDFQBO reads the date, description, and amount on each line and keeps deposits and disbursements on the correct side. Check the table, confirm the insurance funding and trust transfers, then export a QBO or IIF file.

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 code preneed money to a liability, cash advances to a pass-through account, and only delivered services to income.

Why funeral home books are hard to get into QuickBooks

Preneed money is not income, and in most states it is not even yours yet

State preneed statutes generally require a funeral home to place a set percentage of what a family pays in advance into a regulated trust account, or to fund the contract with a life insurance policy assigned to the funeral home. Either way the money is held against a service you have not performed, and under accrual accounting the revenue is deferred until the funeral is actually delivered. A deposit hitting the operating account looks exactly like a sale in a bank feed, which is how preneed dollars end up recognized years early. Converting the statement gets each deposit and each trust transfer in with its exact date so you can post it to the liability it belongs to and keep a per-contract ledger that stands up to a state examination.

Insurance assignments fund weeks after the service, in an amount that rarely matches the contract

When a family funds a service by assigning a life insurance policy, you deliver the funeral first and wait for the insurer or the assignment company to verify the claim and wire the proceeds, often several weeks later, minus a processing fee, and sometimes split into an initial payment and a remainder. If the policy exceeds the contract, the overage goes back to the family. That single wire is not one clean payment against one invoice, and treating it as one leaves your receivables permanently wrong. Getting the funding line in with its real date is what lets you apply it against the right case, expense the assignment fee, and pay out any excess correctly.

Cash advance items are pass-through money, not revenue

Obituary placements, death certificates, clergy honoraria, cemetery fees, flowers, and musicians are typically paid by the funeral home on the family's behalf and billed back at cost. That money passes through your bank account in both directions, and if you run it through income and expense accounts you inflate revenue and expenses by identical amounts, which distorts every margin percentage you look at and can misstate the base for a state sales tax filing. Most firms hold these in a cash advance receivable or clearing account instead. Converting the statement gets both sides in as separate dated lines so the wash is visible and provable.

Caskets, urns, and vaults are inventory that sits for a long time

A selection room represents real money parked on the balance sheet, sometimes for years, and merchandise is bought from a handful of suppliers on terms while it sells one unit at a time. If supplier payments are expensed the day they clear the bank, the cost of a casket lands in a different month than the service it was sold with, and your gross margin on that case is fiction. Getting every supplier payment into QuickBooks with a date is the first step to matching merchandise cost against the case it belongs to.

Families pay in pieces, over months, from several sources

One case can be funded by a partial insurance assignment, a card payment at the arrangement conference, a check from a second family member, and an installment plan for the balance. Those payments arrive on different days in different amounts, and a bank feed shows you four unrelated deposits. Reconstructing which case each one belongs to from memory is a slow way to lose money, and it is how uncollected balances quietly age past the point where anyone will pay them.

Built for funeral home books

One tool for every line on the statement, so a month of cases goes into QuickBooks in minutes instead of an evening of typing.

Trust transfers visible

Every movement between the operating account and the preneed trust lands as its own dated line, so the transfer you are required to make is documented rather than inferred from a monthly balance.

Insurance funding dated correctly

Assignment wires and checks come through with the date they actually cleared, which is what lets you apply them to the right case, split out the processing fee, and see how long your funding really takes.

Cash advances kept separate

Payments to cemeteries, clergy, florists, and newspapers arrive as distinct transactions you can code to a pass-through account instead of burying them in expenses and overstating your cost base.

Merchandise costs traceable

Casket, urn, and vault supplier payments come in as clean lines with dates and amounts so inventory purchases can be matched to cases rather than expensed whenever the check cleared.

Multi-location ready

Run several chapels, a crematory, or a cemetery alongside the funeral home and each account converts the same way, so you can tag by class or location and see what each one actually earns.

Reads any bank's layout

A national bank, a small-town institution, or a trust company 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 deathcare

Anyone keeping a funeral home's books in QuickBooks from PDF statements.

Family-owned funeral homes

One or two locations, a preneed book built over decades, and an office manager wearing four hats. Converting the operating statement each month gets insurance funding, family payments, and vendor disbursements into QuickBooks without retyping.

Cremation-focused providers

Lower average case value and far more volume means a statement full of small card deposits and permit and certificate fees. Converting it keeps every one of those small lines in the books where the margin math actually happens.

Combination firms and cemeteries

A funeral home, a crematory, and cemetery property under one roof means separate revenue streams and separate trust obligations. Converting each account's statements the same way gives you comparable books across all of them.

Accountants with deathcare clients

Preneed rules, trust reporting, and pass-through items make this a specialty. One converter for every account gives you a repeatable way to bring a client's month or year into QuickBooks before you start the real work.

Common funeral home 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 funeral home leans on most, and having every line in QuickBooks is what makes your per-case margin and your trust reporting trustworthy.

• Preneed trust liability holding money collected in advance until the service is delivered and the revenue is earned.
• Service revenue for professional services, facilities, staff, and transportation on delivered cases.
• Merchandise revenue and inventory for caskets, urns, vaults, and markers sold from the selection room.
• Cash advance clearing for obituaries, certificates, clergy, flowers, and cemetery fees paid on behalf of families.
• Insurance assignment fees charged by the funding company out of the proceeds before they reach you.
• Facility and fleet costs for the chapel, the crematory, and coaches, which run whether the month is busy or not.
• Merchant processing fees pulled out of card deposits before they reach the operating account.

To hold preneed money correctly until the service is delivered, see recording a customer prepayment or retainer. When a family pays a case off in pieces, see handling a partial payment or deposit on an invoice. For coding the imported lines, see categorizing bank transactions in QuickBooks, and for the monthly service charges and returned-item fees the bank takes out, see recording a bank fee or overdraft charge.

Frequently asked questions

How do I record preneed funeral contracts in QuickBooks?

Record the money a family pays in advance as a liability, not as income. Post the deposit to a preneed or deferred revenue liability account, record the required transfer into the state-regulated trust account or the insurance policy funding, and move the amount into service and merchandise revenue only when the funeral is performed. Keep a ledger per contract showing the original amount, earnings, and current balance.

Is preneed money income when it is collected?

No. Under generally accepted accounting principles, revenue from a preneed contract is deferred until the service is actually delivered, because you have been paid for work you have not performed. Recognizing it on the day the money arrives overstates this year's profit, understates the years you do the work, and can conflict with the trust reporting your state requires.

How do funeral homes account for cash advance items?

Treat them as pass-through money. When you pay a newspaper, a cemetery, a clergy member, or a florist on a family's behalf and bill it back at cost, post both the payment and the reimbursement to a cash advance clearing or receivable account rather than to expense and income. The account should wash to zero per case, and your revenue stays a true picture of what you actually earned.

How do I record an insurance assignment payment in QuickBooks?

Record the gross proceeds against the family's balance, expense the assignment or processing fee separately, and pay any overage back to the family rather than keeping it in income. The deposit that hits your bank is net of the fee, so a single line coded straight to revenue will understate both your income and your costs. Converting the statement gets the funding line in with its real date so you can split it correctly.

What accounting software do funeral homes use?

Most independent funeral homes run QuickBooks for the general ledger alongside a deathcare management system that handles case files, contracts, and the statement of goods and services. The management system knows the case; QuickBooks is the accounting book of record. The two only agree if every bank transaction actually reaches QuickBooks, which is where converting the PDF statement comes in.

How do I get a funeral home 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 insurance funding, family payments, trust transfers, 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 categorize each line.

Is QuickBooks good for a funeral home?

QuickBooks works well for a funeral home when preneed money sits in a liability account, cash advance items run through a clearing account, merchandise is carried as inventory, and each location is tagged. It will not manage case files or preneed contracts on its own, so pair it with your management system and keep the bank side complete by converting every statement.

Get your funeral home statements into QuickBooks

Upload an operating or trust account PDF, review the insurance funding, family payments, and vendor disbursements, and download a QBO file QuickBooks accepts. No install, and your first conversion is on us.

Convert a statement View pricing