Track Dental Lab Costs From Your Bank Statements

A dental-practice bank statement can confirm money paid to laboratories and cash deposited into the practice account. It cannot tell you which treatment produced a bundled card settlement, which patient or insurer supplied the cash, when clinical revenue should be recognized, or which lab invoice belongs to which case.

To track dental lab costs accurately, use the bank as a cash control around a case ledger and invoice workflow. The primary records are treatment or case records, patient and payer billing, processor settlements, lab work orders and invoices, and the accounting ledger.

Define the measure before calculating it

“Lab margin” can mean several different things. Label the measure precisely.

Case contribution after external lab cost

Recognized case revenue - directly attributable external lab cost

This is not net profit. It excludes clinician time, chair time, materials, staff, occupancy, payment charges, remakes, and other overhead unless you deliberately include them.

Lab-cost share of production

Direct external lab cost / consistently defined prosthetic production

“Production” might mean billed charges, contracted production, or recognized revenue depending on the practice’s management policy. Use one definition across comparable periods.

Cash paid to labs

Lab payments posted to the bank during the period

This is a liquidity measure. It is not necessarily the lab cost incurred for cases completed in that period.

What each record contributes

Record	Useful fields	Limitation alone
Case or treatment ledger	case ID, procedure, service date, provider	no proof of settlement cash
Patient/payer billing	billed and adjusted amounts, allocation	timing and collectability may differ
Processor or payer settlement	gross-to-net payment bridge	may bundle many cases
Lab work order and invoice	case reference, item, invoice date, cost	payment may occur later
Bank statement	posted deposit or lab payment	usually no reliable case allocation
Accounting ledger	recognition and account treatment	only as reliable as postings and controls

A bank description such as “CARD SETTLEMENT” cannot be treated as prosthetic revenue without a settlement report that allocates the underlying transactions.

Step 1: create a coded case-cost table

Use an internal case identifier rather than patient names in the analysis file where possible:

Case ID	Procedure group	Service date	Revenue basis	Recognized revenue	Lab	Lab invoice	Direct lab cost	Status
C-2041	Crown	2026-05-04	Ledger	1,150.00	Lab A	LA-882	185.00	Complete

The revenue basis column should point to the ledger or approved production report. The lab cost should point to a lab invoice or work order. Do not link two transactions only because their dates or amounts look similar.

Step 2: reconcile lab invoices to lab payments

Build a supplier schedule:

Lab invoice	Invoice date	Case ID	Invoice amount	Bank payment date	Bank amount allocated	Difference	Status
LA-882	May 08	C-2041	185.00	May 22	185.00	0.00	Matched

One bank payment may settle several invoices. Preserve the remittance or supplier statement that explains the allocation. One invoice may also be paid in installments.

The control proves payment completeness:

Allocated bank payment - invoices settled = cash-reconciliation difference

It does not decide the period in which the lab cost belongs in the accounts.

Step 3: reconcile practice deposits to billing sources

For patient card receipts, use the processor settlement report to bridge gross collections, charges, adjustments, and the net bank deposit. For insurer receipts, use the relevant remittance and payment trace. For direct transfers, match the payment reference to the patient or payer ledger under the practice’s approved process.

Never assume:

Bank deposit = prosthetic revenue

A deposit can combine hygiene, consultations, prosthetics, prepayments, patient balances, insurer payments, taxes, and prior-period activity.

For US insurer EFTs, the related insurance-payment reconciliation guide explains why the ERA and ledger—not the bank description—carry the claim detail.

Step 4: calculate the case contribution

Consider a documented crown case:

Component	Source	Amount
Recognized case revenue	Practice ledger	1,150.00
External lab invoice	Lab invoice LA-882	(185.00)
Contribution after external lab cost	Calculation	965.00
Lab-cost share	185 / 1,150	16.1%

The bank might show a later net processor settlement and a later lab payment, neither equal to these case values. Those cash movements should reconcile to their settlement and supplier schedules separately.

The 965.00 is not overall case profit. If the practice wants a fuller contribution measure, add an approved costing policy for clinical materials, payment charges, chair time, remakes, and other direct costs.

Step 5: compare like-for-like periods

Use both service and cash dates:

Period	Recognized prosthetic revenue	Direct lab cost assigned	Contribution after lab	Lab-cost share	Lab cash paid
May
June

This prevents a late-paid lab invoice from silently moving production economics into the wrong month. If the business uses cash accounting for a particular purpose, keep that cash view clearly labelled and separate from the management production view.

There is no universal target ratio. Investigate changes in:

• case mix;
• lab price changes;
• remake policy;
• in-house versus outsourced work;
• payer and discount mix;
• fee schedule changes;
• allocation or cut-off errors.

A higher ratio is a question, not proof that pricing or the lab is wrong.

Step 6: maintain exceptions

Keep an exception list for:

• lab payment with no invoice allocation;
• lab invoice with no case ID;
• case with missing or disputed revenue;
• processor settlement not matched to the bank;
• duplicate invoice or ledger posting;
• remake or lab credit without a linked original;
• personal or owner payment in the practice account;
• period cut-off item.

Assign an owner, evidence needed, and due date. Do not clear an exception with a guessed case match.

Tax treatment requires the facts and local rules

For a US Schedule C filer, the general IRS test is that a business expense must be ordinary and necessary, and supporting documents should show the payee, amount, date, and business purpose. Review the IRS business record guidance and current professional advice for the correct line, timing, and any capitalization issue.

For a UK sole trader, HMRC says allowable expenses must relate to business purchases and personal portions must be excluded. See HMRC’s self-employed expense overview. Entity status, NHS or private arrangements, VAT position, and accounting basis can change the treatment.

A bank payment alone does not establish deductibility or classification.

Privacy and security

Dental case, billing, and payment records can contain protected health information and other sensitive personal data. In the United States, HHS explains that billing and payment records can be PHI and that covered entities and business associates must protect relevant data. Review the HHS Security Rule overview.

Before placing data in a spreadsheet or external service:

• minimize patient identifiers;
• use role-based access;
• store the case-key separately when practical;
• use only approved devices and services;
• confirm any required vendor agreement;
• follow retention and secure-disposal policies;
• keep a review and change log.

Do not assume that removing a patient name is sufficient de-identification or that a generic financial tool is approved for PHI.

Monthly control checklist

• Case revenue comes from the approved ledger or production report.
• Lab costs are supported by invoices and case references.
• Lab payments reconcile to supplier invoices.
• Patient and payer deposits reconcile through settlement records.
• Service-period measures are separate from cash-period measures.
• The metric name states what costs are included.
• Changes in ratio have documented drivers.
• Exceptions are assigned and unresolved items remain visible.
• A qualified human reviewer signs off.
• Sensitive data stays in an approved workflow.

If a permitted practice bank statement contains no regulated patient information and no native export is available, BankStatementLab can convert supported PDFs and images to CSV, XLSX, or JSON. It extracts bank rows only; it does not identify cases, allocate deposits, calculate clinical production, or determine tax treatment.

Related articles

• Bank Statements to Excel and CSV for Dentists
• How to Prepare Bank Statements for Your Accountant
• Categorize Bank Transactions in Excel with Pivot Tables
• How to Separate Personal and Business Expenses

For approved non-PHI statements, extract lab-payment cash rows for reconciliation