Key takeaways
- Sessions left is computed, not remembered.
- Only attended sessions consume a package.
- Plans are measured against real attendance.
- Therapist share follows attended sessions.
Therapy is sold in packages and delivered one session at a time over weeks, which creates an accounting problem in the gap. The clinic has been paid for twenty sessions and owes twenty sessions, and the only reliable record of how many remain is usually a therapist's memory and a card in the patient's bag. TherapyDesk PH keeps sessions left as a computed figure.
A package is an obligation
Each sale takes its sessions included, price and validity days from the package list. The expiry date follows from the sale date.
Sessions left is what the clinic still owes that patient, and the sum of it across all patients is the clinic's real unearned income.
A no-show is not a session
Sessions used counts only those marked Attended. A no-show or cancellation is recorded but does not consume a paid session.
This is the fairest treatment for both sides, and it stops the quiet argument that begins when a patient believes they have six sessions left and the card says four.
Plans are measured by attendance
A treatment plan carries a goal, a frequency, a target number of sessions and a review date. Sessions done counts attended sessions for that patient.
Progress percent and a plain On plan, For review or Goal reached status then say which patients are due a reassessment rather than another block of the same.
Therapists and home visits
A therapist's share is credited on attended sessions at their own session rate, so the payable figure is built from work actually delivered.
Home visits carry their own fee, distance and transport cost, which is what tells a clinic whether visiting a patient in the next town is worth doing.
Review exceptions every week
Resolve duplicate IDs, missing links, overdue balances, negative amounts, and open operational items in CHECKS before using the dashboard for decisions.
TherapyDesk PH Private Google Sheets Web App is designed for use with a Google account, Google Sheets, and Apps Script, using owner-only deployment by default.
No electronic medical records, clinical notes or imaging, no PhilHealth or HMO claim filing, no prescription or referral generation, no appointment reminders, and no diagnosis or treatment guidance of any kind.
Frequently asked questions
What happens when a package expires with sessions left?
The expiry date is on the sale and the sessions left figure stays visible. Whether you extend or forfeit is your clinic's policy, not the workbook's.
Can a patient pay the package in instalments?
Yes. Record each payment against the sale; the balance and payment status follow.
Does it keep clinical notes?
No. It records packages, sessions, attendance, plans and money. Clinical documentation stays in your own patient records.
Does this replace official records?
No. No electronic medical records, clinical notes or imaging, no PhilHealth or HMO claim filing, no prescription or referral generation, no appointment reminders, and no diagnosis or treatment guidance of any kind.
