Dental Canvas
Free download
For Open Dental offices

12 copy-paste Open Dental queries + the worksheet

The lists your office should work every morning, pulled straight from your own Open Dental. Paste, click Submit, and work the list.

From the video: . It’s query in the pack.
  • Money still in the chartTreatment planned, nothing on the schedule. Biggest dollars first.
  • Overdue cleanings, unconfirmed, left without a next visitYour hygiene schedule and tomorrow’s book, with the phone on every row.
  • Insurance to verify, claims 30+ days, done but not billedThe billing lists, oldest first, carrier phone on the row.
  • Notes missing, year-end benefits, balances over 90, huddle, openingsThe rest of the 12. All read-only: they only look, never change anything.
  • The worksheet (Excel / Google Sheets)Paste each list into its tab. It totals the dollars and turns green as you book.
The Open Dental Morning Lists worksheet
Sample data. Fictional patients and carriers.

Get the free queries

We’ll email it to you right away, and you can download it on the next page.

FreeNo credit cardWorks with Open Dental
Do I need to know SQL?

No. If you can copy and paste, you can run these. Reports, then User Query, paste, Submit.

Is it safe to run?

Every query is a read-only SELECT. It reads your Open Dental and never changes anything in it.

What version?

Tested on Open Dental 25.3. Your login needs the User Query permission to paste new queries.

Dental Canvas · San Diego, CA · Open Dental is a trademark of Open Dental Software, Inc. Dental Canvas is independent and not affiliated with or endorsed by Open Dental Software.