Save hours every week
Turn your bank statements (PDF) into Excel, CSV or OFX, without manual retyping.
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
Direct external lab cost includes case-attributed lab charges and external remake charges assigned to the case, net of related lab credits. This measure excludes clinician and chair time, in-house materials, staff, occupancy and payment fees.
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
Keep the case-cost table and the key that links case codes to patients in approved practice systems. Use internal case codes within that workflow and restrict access to the key. In the separate financial workbook, record a payment-level reference that does not identify a patient.
| 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
Keep the supplier schedule, case IDs and invoice allocations in the approved practice system.
| Lab invoice | Invoice date | Case ID | Invoice amount | Bank payment date | Bank amount allocated | Unpaid invoice balance | 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:
Bank debit amount (as a positive number) - total amounts allocated to this payment = cash-reconciliation difference
Use the amount paid against each invoice in this payment, after any credit applied, and track each unpaid balance separately. For example, if a 100.00 instalment is allocated to the 185.00 invoice, the cash difference is 0.00 and 85.00 remains payable.
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 U.S. insurer payments sent over ACH under the adopted standard, use the shared reassociation trace in the EFT addenda and the ERA within the approved practice system. Keep claim-level details and the ERA there. CMS guidance · Insurance-payment reconciliation guide
Step 4: calculate the case contribution
In this fictional worked example, the crown case has a recognized fee and a directly attributable lab invoice:
| 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% |
In the supplier example, the May 22 payment allocates 185.00 to LA-882. A bundled payment may be larger. Match any net processor deposit separately to its settlement report.
The 965.00 is not overall case profit. For a fuller contribution measure, use an approved costing policy for additional costs such as in-house materials, payment charges and chair time. Count each cost once, including external remakes already assigned to the case.
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. Check the VAT treatment of the specific supply and the supplier’s professional status. HMRC’s dental guidance covers qualifying NHS and private supplies. Confirm the accounting basis for your practice.
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.
Under HIPAA, a covered entity or business associate needs a business associate agreement with a cloud vendor that handles electronic protected health information on its behalf. HHS cloud computing guidance
Under the UK GDPR, an invoice that reveals an identifiable patient’s care can contain special category health data. A patient code that can be linked back through a retained key is still personal data. ICO guidance on health data · ICO guidance on pseudonymisation
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 native export is unavailable, use only practice-approved operating-account statements without patient-identifying information or clinical details. Check statement narratives and references before upload. BankStatementLab can convert supported PDFs and images to CSV, XLSX or JSON for review. Keep case allocation and clinical revenue in the practice’s approved records.
Compare bank movements with your books
BankStatementLab offers a bank reconciliation report. With active Starter, Pro or Business access, compare approved statement debits and an approved payment-level accounting export for the same account and currency. Use files without patient-identifying information or clinical details. Review the one-to-one proposals, then export the report in Excel, CSV or PDF. Keep allocations across multiple lab invoices in your supplier schedule.
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?
Keep patient-level billing, lab work orders, claim remittances and the case key in approved practice systems. Restrict access and use payment-level references that do not identify a patient in the financial workbook. Before using BankStatementLab, check that the approved bank and accounting files contain no patient-identifying information or clinical details.
Related articles
Save hours every week
Go from PDF to an Excel file ready to use, with no manual data entry.