How to Track GLP-1 and Hormone Membership Patients: Reorders, Autopay, and Nurse Follow-Ups

A monthly medication membership has four dates that matter: the next medication reorder, the next autopay, the last nurse follow-up, and the date the pharmacy order was placed or shipped. Track those four on every member and nothing slips. Lose any one of them and you get the three failures every clinic knows: a patient who runs out of medication, a shipment sent to someone whose card declined, and a patient nobody has talked to in two months.

This is how to set that up with a spreadsheet, where the spreadsheet stops working, and what Prescripta Member Management does instead.

Step 1: one row per membership, four dates per row

Start with a sheet where each row is one membership, not one patient (a patient on both a GLP-1 and a hormone plan gets two rows). Columns:

• Patient name and membership type (semaglutide, tirzepatide, BHRT, TRT, peptide)
• Start date
• Next autopay date and the amount
• Next reorder date
• Last nurse follow-up and whether the patient answered
• Pharmacy order status: upcoming, pending approval, ordered, shipped, delivered
• Saved medication: product, strength, directions, days supply
• Notes

Keep the autopay date and the reorder date as separate columns even when they land on the same day. They drift apart the first time a shipment is delayed or a card fails, and clinics that merge them end up shipping unpaid medication or charging a patient who has not been reordered.

Step 2: set the reorder window at seven days

Compounded medication takes time to fill and ship, so the reorder has to be placed before the patient runs out. Seven days before the reorder date is the standard window: enough time for the provider to approve, the pharmacy to compound, and shipping to arrive. Add a formula column that shows "due" when today is within seven days of the reorder date and "overdue" when the date has passed and the status is still upcoming.

Step 3: put nurse follow-ups on a 28-day cycle

Every member gets a nurse check-in every 28 days from the membership start, independent of the reorder. Log the date and whether the patient was reached. A patient who did not answer stays on the list; the follow-up does not reset until someone actually talks to them. This is the step most clinics drop first, and it is the one that catches side effects, dose questions, and the quiet cancellation before it happens.

Step 4: the Monday routine

Once a week, in this order:

1. Sort by autopay date. Check the processor for any failed charges in the last week and mark those rows. Do not reorder for a failed row until it is resolved.
2. Sort by reorder date. Every row that is due or overdue and not yet pending approval gets its order prepared.
3. The provider reviews the prepared orders and approves them.
4. Place each approved order in the pharmacy's portal, then set the row to ordered with the date.
5. Sort by last follow-up. Every row past 28 days goes on the nurse's call list.
6. Check e-mail for tracking numbers and set rows to shipped.

With 30 members this takes an hour. With 100 it takes a morning, and it is done by one person who knows the sheet.

Where the spreadsheet breaks

It breaks in predictable places, and usually between 50 and 100 members:

• The sheet is only right on Monday. Everything that happens Tuesday through Friday is in someone's head until the next pass.
• Orders are typed twice. Once in the sheet, once in the pharmacy portal, by the same person, with a login that gets shared.
• Status comes back by e-mail. Tracking numbers live in an inbox. "Did it ship?" is a search, not a glance.
• Failed payments are found late. The processor report and the sheet are two different places, so a declined card is noticed when the reorder is already placed.
• One person owns it. When they are out, the routine stops.
• Nobody can see the month. How many reorders are due this week, how many follow-ups are overdue, how many cards failed: the sheet can show one of those at a time.

What Member Management does instead

Member Management is the sheet, made into software that does the Monday routine every day:

• One list with the four dates on every member, with filters and sorting, and a dashboard that counts reorders due, follow-ups due, pending approvals, and failed payments.
• The reorder reminder opens on its own seven days before the date and stays up until the order is placed. Overdue is flagged.
• Nurse follow-ups every 28 days, with answered or not answered logged and the member kept on the list.
• Failed autopay is flagged on the member and counted on the dashboard, so it is seen before a reorder is approved.
• The pharmacy order is placed from the row. The order form is pre-filled from the saved medication or the last order, the nurse prepares it, the provider approves it, and the portal sends it to the pharmacy. Shipped and tracking come back to the row. No pharmacy portal login. Our post on compounding pharmacy e-ordering covers that in detail.
• A morning brief lists who needs a reorder, a follow-up, or an approval today.
• It reads your EHR. Members come in from OptiMantra's tags and report, from Zenoti's sync, or from any EHR's CSV export, so the list is not typed a second time.

It costs $19, $29, or $49 per clinic per month, is bought online with no consult, and runs beside whatever EHR you already have. If the Monday routine above is a morning of your week, it pays for itself the first week.

Frequently asked questions

How far ahead should a GLP-1 refill be ordered?

Seven days before the patient's next dose date is the common window for compounded semaglutide and tirzepatide, allowing for provider approval, compounding, and shipping. Member Management opens its reorder reminder seven days before the date and keeps it open until the order is placed.

Should the autopay date and the reorder date be the same?

Track them separately. They often start together, but a shipping delay or a failed card pulls them apart, and the clinic needs to see both: whether the month is paid, and whether the medication is ordered.

How often should a nurse follow up with a membership patient?

Every 28 days is a workable default for GLP-1 and hormone memberships, timed between reorders. The key rule is that an unanswered call does not count; the follow-up stays due until the patient is reached.

Can I keep using my EHR and still track memberships this way?

Yes. Member Management runs beside any EHR. It reads members from OptiMantra, Zenoti, or a CSV export and keeps the membership schedule and pharmacy orders; the chart and the card on file stay in the EHR.

What happens to the spreadsheet?

Import it. Member Management's CSV import maps your columns, shows a preview, and creates the members with their dates. Re-importing later updates only the cells that changed.