MedSpa Deferred Revenue & Package Tracker

Stop booking package and membership cash as revenue the day you receive it. Under GAAP (ASC 606), that money is a liability until your client actually redeems the service, and this tracker calculates it correctly, automatically, every time.

Built for medspas selling packages, memberships, and gift cards, this Excel/Google Sheets workbook gives you:

• Package Log, one row per sale, tracks cash collected, sessions included, and expiration
• Redemption Tracker, logs each visit, auto-calculates revenue recognized per redemption
• Deferred Revenue Schedule, your month-by-month liability roll-forward, done for you
• Breakage and Expiration Flags, automatically surfaces packages with unused balances nearing expiration

No manual math. No guessing what you actually earned this month versus what's still owed in services. Just open it, log your sales and redemptions, and your real numbers are right there.

Works in Excel and Google Sheets. Includes a full walkthrough tab so you're never guessing what to enter where.