Track Dental Lab Costs and Margins From 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. Track credit notes and remakes against the original invoice so they do not become unrelated negative costs. For supplier balances, reconcile opening payable + invoices − credit notes − payments = closing payable, with other supported adjustments shown separately.

For an approved set of payment allocations, this check detects an unexplained settlement difference:

Allocated bank payment - invoices settled = cash-reconciliation difference

A zero difference does not prove all invoices were captured: compare the supplier statement, invoice register and unpaid schedule as well. 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.

Compare bank movements with your books

BankStatementLab’s bank reconciliation report can compare the processed statement debits with a ledger export of lab payments. Review proposed pairs and export Excel, CSV or PDF after approval. It does not automatically allocate one payment across several lab invoices or calculate treatment profitability.

Frequently asked questions

Can a bank statement calculate exact dental lab margin?

No. It can confirm lab payments and practice deposits, but deposits may bundle many treatments and payment-processor adjustments. Use case records, patient invoices, settlement reports, lab invoices, and the accounting ledger to calculate production and direct lab cost; use the bank as a cash-reconciliation control.

What records support a case-level margin?

Use the treatment or case identifier, fee schedule or patient invoice, payment allocation, lab work order and invoice, adjustments, and ledger posting. A matching amount and nearby date on the bank statement are not enough to prove that two transactions belong to the same case.

Is there a universal lab-cost-to-production target?

No. Case mix, geography, payer arrangements, clinical model, in-house production, pricing, and accounting policy all affect the ratio. Compare like-for-like internal periods and investigate the drivers of change.

How should timing differences be handled?

Keep both service or production period and cash date. A lab invoice may be incurred and paid in different periods, while a patient or insurer payment can arrive earlier or later. Apply the accounting method chosen with your accountant and reconcile cash separately.

Are dental lab payments automatically deductible?

No. Tax treatment depends on jurisdiction, entity, accounting method, business purpose, and documentation. Retain the lab invoice and proof of payment, then follow current official guidance or professional advice.

What privacy controls apply?

Case, billing, and payment records may contain protected health information or other regulated data. Use only approved systems, minimize identifiers, restrict access, and complete any required vendor agreement before uploading or sharing files.

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