Custom Open Dental reports
A number Open Dental’s standard reports won’t give you, written as read-only SQL you run yourself.
How it’s delivered, and why that matters
You get a .sql file. You run it yourself from Reports > User Query. That is the whole delivery mechanism.
No remote access to your server, no add-on to install, no account to create, and no patient data ever leaves your building — so there is nothing to sign and no BAA to negotiate. Everything is read-only: it selects, it never writes.
Each file’s header states, in plain English, the assumption it makes about your question. Most “wrong” reports are right answers to a slightly different question, so that line is usually the important one.
Every query is executed before it ships
Open Dental publishes its full database schema. I build a structure-only copy of it — 430 tables, no data — from that published documentation, and run every query against it before it goes anywhere, and again on every change.
So a column that doesn’t exist in your version cannot quietly ship. The harness is public: verify.sh in the free query repository rebuilds the schema and re-runs everything against whichever version number you give it.
Free, ready to paste
Unscheduled treatment, in dollars
Diagnosed work never attached to an appointment — usually the largest recoverable number in the database.
Recall due, nothing booked
Patients overdue for hygiene with no future appointment. The reactivation list.
New patients who left unbooked
Came in, had work done, walked out with nothing on the books.
Insurance claims outstanding
Sent and unpaid, aged 0-30 / 31-60 / 61-90 / 90+.
Production by dentist incl. hygiene
Hygiene billed under a licence rolled back onto that provider, for associate comp.
Appointments excluding broken
By date range and provider, with broken appointments actually excluded.
Payment plans as of a date
Principal, charged, paid and due — with the dynamic-plan trap explained.
Daily production goal vs scheduled
Set a figure per date, not Open Dental's hourly-per-provider model.
All ten live in the public repository, free for any practice to use. Request one that isn’t there — most take a few minutes and get added for everyone.
Written to order — $150 a query, inside 48 hours
Tell me the number you want in plain English and your Open Dental version. I’ll ask one or two clarifying questions, then send the tested .sql file. $450 for three. If it doesn’t answer the question you asked, I fix it or refund you.
Questions first is fine — ishubham2101@gmail.com. I’m a software engineer; this is my own work, not an agency.