How to Track Client Sessions

Occasional Visitor

Hi everyone,

 

I was looking for some help/guidance for my personal training business.

 

I currently have a sheet that lists data such as: Client Name (First/Last), Date, Amount of Sessions Purchased, and the Total Purchase Amount

 

I then have a second sheet that tracks the clients sessions, as I add them in it automatically removes sessions from the total. 

 

Edit: I attached two photos for reference. Squared off in yellow is the info I would like it to track

 

What I was looking for, if it's possible, is on the second sheet, I have a section that tracks the session price that client is at, is there a way to automatically track this? 

 

For example, if a client has 20 sessions left, 

They purchased the first 10 sessions at a price of $40 per, for a total of $400

But the second set of 10 sessions, they purchased at price of $32 per, for a total of $320

 

I'm looking for a way where it knows that after they run through the first 10, it automatically drops the session price column to $32 from $40

0 Replies