How to export your schedule from NextGen

First, confirm which NextGen you have

NextGen Healthcare sells more than one practice system. NextGen Enterprise PM is typically paired with NextGen Enterprise EHR. NextGen Office is a separate cloud product with its own screens and reports.

Everything below is drawn from the NextGen Knowledge Center's help guide for NextGen Enterprise PM 8. If your practice uses NextGen Office, or an older Enterprise PM version, the menus may differ. Check the NextGen Knowledge Center for your product and version, or ask NextGen support. You also need a login with rights to run scheduling reports; if the Reports menu doesn't show Scheduling, your system administrator controls that access.

Step by step: the Appointments Listing report

NextGen describes the Appointments Listing as a report that can be pulled daily to show who is scheduled, who needs to be confirmed and what records to pull. It is sorted by resource name, appointment time, beginning time and event. Per the Knowledge Center:

1. In NextGen Enterprise PM, open the Reports menu, select Scheduling, then select Appointments Listing.
2. In Report Filter: Appointments Listing, set the date range and any other filters your version offers.
3. Under Filter 1, use the Appt Statuses field. Pick a single status such as No Show or Cancelled, or choose <none> or leave it blank to list appointments of all statuses.
4. Decide how to handle Confirmed, Deleted, Rescheduled and Retained appointments. NextGen gives options to display only, exclude, or include all of each.
5. Run the report. On the report toolbar, select Export to Excel. The Export File Location window opens.
6. Select Browse, choose a secured practice folder, then select Export. The file is saved in Excel (.xlsx) format.

Choosing the right status settings

The status filter decides whether the file is useful for recovery. A listing of only Kept and Expected appointments shows a full-looking schedule and hides the problems. For revenue work, run it two ways:

• Looking back (the last 30 to 90 days): all statuses, with Rescheduled included. This shows who missed or cancelled and lets you check whether each one was rebooked.
• Looking ahead (the next two to four weeks): Expected and Pending, with Deleted excluded. Gaps between appointments on each resource are your open time.
• Pending deserves its own look. Appointments still unconfirmed a day or two before the visit are worth a call or reminder before they become open time.

Export formats, and which one to pick

NextGen's Knowledge Center documents several export buttons on the Enterprise PM report toolbar, each using the same Export File Location window: Excel (.xlsx), CSV, HTML, ASCII (.txt) and PDF.

For schedule work, CSV or Excel is the right choice, because each appointment stays on its own row. PDF is fine for a printed huddle sheet but is hard to turn back into data. ASCII text can work, though columns sometimes shift.

The Appointments Listing also carries audit-style details: who last modified an appointment, who originally created it, and the created and last-modified dates. These are helpful for spotting patterns, such as a run of cancellations entered on the same afternoon, but most outreach tasks don't need them. Trim them if your vendor doesn't ask for them.

What to look for once it's open

Here is an illustrative example for a three-location orthopedic and physical medicine group. The numbers are invented to show the method.

A month of Appointments Listing data, all statuses, shows 64 No Show and 118 Cancelled appointments. Sorting by patient and checking for a later Expected appointment shows 41 patients with nothing rebooked. A forward-looking listing for the next two weeks shows 26 open follow-up slots spread across the three locations.

Say a follow-up visit is worth $140 here. The 41 unbooked patients represent about $5,740 of care that hasn't been rescheduled. If the practice rebooks 20 of them into the open slots at their usual location, that is $2,800 recovered, and 6 slots still open for the next patient who calls. Because the report is sorted by resource, the front desk can see at a glance which provider's calendar has the most room.

Making it a daily habit

NextGen positions the Appointments Listing as a daily report, and that rhythm fits revenue recovery well. Open slots fill best when patients hear about them days ahead, not hours.

NextGen also documents memorized reports and a Background Business Processor that can run report jobs, which can take the manual clicking out of a daily export. Setting that up is usually an administrator task, so ask yours whether it suits your system. Wherever the file lands, it should be a secured practice location, not a personal desktop or inbox, and local copies should be removed once the file has been uploaded to a vendor under a Business Associate Agreement.