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

This is the most consequential entry in death care bookkeeping. A family signs a pre-arranged funeral contract and pays, sometimes in full and sometimes over installments, but the firm has not yet performed anything. The cash is an obligation to serve that family later, so it is recorded as a liability, commonly called Deferred Preneed Revenue, and not as income. Revenue is recognized when the service is delivered, which the industry calls going at need. Booking preneed payments as income on receipt overstates revenue by years of prepayments and understates what you owe every family on the preneed roll. Bring the transactions in with the PDF to QBO converter, then categorize by contract stage.

Every state regulates preneed funds, and no single percentage applies nationwide. Some states require 100% of the payment to be placed in trust. Others let the provider retain a portion for administrative and selling costs, particularly on guaranteed price contracts. Florida is a useful published example: Florida law requires at least 70% of the service portion of preneed payments to be trusted, and for merchandise, at least 30% of the retail price or 110% of the wholesale cost. Do not carry those figures into another state. The trusting percentage, the treatment of any retained amount, and the reporting deadlines are set by state statute and a state funeral board, so check your own statute.

Trust money must never be commingled with operating income. Three entries carry the cycle. Money in: the family's payment increases cash and credits the deferred preneed liability, and the transfer to the trustee moves cash from the operating account to a trust asset account if the trust is on the books. That transfer is not an expense. Trust earnings and interest generally accrete to the contract, increasing both the trust asset and the liability, so they are not operating income. Withdrawal at need reverses the cycle: the trust releases the funds, the liability clears, and revenue is recognized. Tie the trust balance to the trustee's statement.

Many families fund arrangements with a life insurance policy rather than a trust, assigning the policy or part of its benefit to the funeral home. The home performs the service first, files the claim, and waits, often for weeks. That gap is a receivable: at the time of service, record the full contract as revenue and set up a receivable from the insurer or assignment funder. Funding companies commonly advance the money and take a fee. The fee is an expense, and the EFT arrives net, so the deposit is smaller than the invoice. Post it against the open receivable and book the difference to a funding fee expense. Treating the net deposit as fresh income double counts revenue.

Under the FTC Funeral Rule, cash advance items, also called accommodation items or cash disbursements, are goods and services the funeral home buys from a third party on the family's behalf: cemetery and crematory fees, clergy honoraria, flowers, obituary notices, certified death certificates, musicians, and pallbearers. The Rule requires each to be listed separately with its price on the itemized Statement of Funeral Goods and Services Selected, and a firm that marks an item up or keeps a rebate or commission cannot claim the price equals its cost and must disclose that it charges more. The books follow the economics. Items genuinely passed through at cost are best recorded as a wash through a receivable rather than running both sides through income and cost of sales. Where there is a markup, the markup is your revenue. Some states prohibit markups outright, so settle this with your CPA first.

Caskets, urns, vaults, and outer burial containers bought from suppliers such as Matthews Aurora or Batesville are inventory, not an expense on the day the ACH debit clears. The purchase increases an inventory asset. When the merchandise is selected and the service is performed, the cost moves to cost of goods sold and the merchandise revenue is recognized at the same time. Expensing supplier invoices on payment distorts gross margin in both directions.

Hearses, lead cars, and removal vehicles are fixed assets, depreciated over their useful lives. The complication on the statement is the loan draft: a vehicle or building payment leaves the account as one amount but is two things, loan principal on the balance sheet and interest expense on the profit and loss. Split every draft using the lender's amortization schedule, or the loan balance stays permanently wrong. Crematory operators should capitalize the retort and major rebuilds while expensing routine maintenance.

Licensed funeral directors, staff embalmers, attendants, and office administrators are ordinarily W-2 employees paid through payroll with withholding. Funeral homes also use genuinely independent help: trade embalmers, third-party removal services, and per-call celebrants. Where the relationship is truly independent under the applicable worker classification tests, those payments are reported on Form 1099-NEC. The 1099-NEC reporting threshold is $2,000 for payments made on or after January 1, 2026. Track contractor payments by vendor from the first check.

Sales tax in death care is state-specific. The common pattern is that professional services, such as the basic services of the funeral director, are often not taxed, while tangible merchandise such as caskets, urns, and vaults frequently is. Some states exempt funeral merchandise, some tax it, and some apply special rules to preneed merchandise sold years before delivery. The itemized statement already separates services from merchandise, so the tax mapping usually follows those lines. Confirm the rules with your state and CPA.

QuickBooks cannot read a PDF, so convert the statement to .qbo with the tool above. In QuickBooks Desktop, import through File, then Utilities, then Import, then Web Connect Files. In QuickBooks Online, go to Transactions, then Bank transactions, then Upload from file. Manual uploads carry no 90 day limit, so a prior year or an account the feed never covered can be reconciled month by month. Each path is covered on the QuickBooks Desktop guide and the walkthrough for how to import a bank statement into QuickBooks Online.

Bank rules handle the predictable lines: the casket supplier ACH, the merchant batch, the payroll debit, the loan draft. Deposits deserve caution. Preneed payments, at-need family payments, and assignment funding can look nearly identical in a bank description while meaning different things, so route deposits to a review queue and match them to the contract instead of letting a rule decide. Multi-location groups can convert every account at once with bulk bank statement conversion.

How do I record preneed funeral contracts in QuickBooks?

Record the payment as a credit to a Deferred Preneed Revenue liability, not income, and track the trusted portion as a trust asset if the trust is reported on your books. When the service is performed at need, clear that liability and recognize the service and merchandise revenue.

How do I import a bank statement into QuickBooks?

Convert the PDF to a .qbo file first, because QuickBooks cannot read a PDF. In QuickBooks Desktop, go to File, then Utilities, then Import, then Web Connect Files. In QuickBooks Online, go to Transactions, then Bank transactions, then Upload from file, then select the matching account.

Are preneed trust deposits taxable income to the funeral home?

Generally not when the money is received, because no service has been performed and the funds are held for the family. Timing depends on your state's trusting rules, whether the contract is guaranteed, and your tax accounting method. Any portion the statute lets you retain may differ, so ask your CPA.

How do I record an insurance assignment payment in QuickBooks?

Recognize the full contract as revenue when the service is performed and set up a receivable from the insurer or funder. When the EFT arrives, apply it to that open invoice rather than booking new income. The deposit lands net of the funding fee, so post the shortfall to an expense account.

Are cash advance items revenue for a funeral home?

Only to the extent of any markup. Cemetery fees, clergy honoraria, and obituary notices are bought from third parties for the family, and when passed through at cost they are usually a wash rather than revenue. If you mark them up, the markup is revenue and the Funeral Rule requires disclosure.

Can I import prior year statements to catch up the books?

Yes. Manual .qbo uploads have no date limit, unlike bank feeds that reach back only about 90 days. Convert each month's PDF, import them in order, and reconcile month by month. This is the usual approach for catching up a neglected year or rebuilding records before a state board review.