How To "Upgrade" a Membership Mid-Cycle in Kilo GMS
How To: “Upgrade” a Membership Mid-Cycle in Kilo GMS
At this time, Kilo Gym Management Software (GMS) does not have a built-in feature to automatically upgrade a membership in the middle of a billing cycle.
However, you can still accomplish the same result by ending the current membership and starting the new one on the desired date, then manually reconciling the billing difference.
This guide will walk you through the recommended process.
Step 1: Cancel the Athlete’s Current Membership
First, cancel the athlete’s existing membership on the date their current access should end.
- Navigate to the Athlete Profile
- Locate the athlete’s Active package
- Click Cancel Package Early in the Action menu
- Select the End Date (typically the day before the upgraded membership begins) and ensure the status is set to No change
This stops future billing of this package type.
Note: Canceling a membership early does not automatically generate a prorated refund. Partial refunds or credits must be calculated manually.
Step 2: Schedule the New Membership
Next, add the upgraded membership.
- From the athlete’s Profile, select Add Package
- Choose the new package
- Set the Start Date to the day the upgraded membership should begin
- Save the package
The system will automatically generate the first invoice for the new membership.
Reconciling the Billing Difference
Because the previous membership ended early, you will likely need to adjust billing to account for unused time.
Kilo currently does not automatically prorate refunds when a membership is canceled early, so you will need to calculate this manually.
A typical approach is:
- Determine the total value of the membership
- Determine the number of days in the billing period
- Calculate the daily value
- Multiply by the unused days remaining
This gives you the amount to credit or refund to the athlete.
Membership Proration Calculator
When canceling a membership early to move an athlete into a new package, you can calculate the unused value of the current membership using this formula:
Step 1 — Calculate the daily value of the membership
Membership Price ÷ Total Days in Billing Period = Daily Rate
Step 2 — Calculate unused value
Daily Rate × Unused Days = Credit or Refund Amount
Example
An athlete has a $160 monthly membership and upgrades halfway through their cycle.
Billing details
- Membership price: $160
- Billing cycle: 30 days
- Daily rate: $160 ÷ 30 = $5.33/day
If the membership is canceled with 12 days remaining:
$5.33 × 12 = $63.96 credit
You can then either:
- Refund $63.96 from the previous payment
- Reduce the first invoice of the new membership by $63.96
Once you have that number, you have two options.
Option 1: Issue a Partial Refund
You can refund the unused portion of the previous membership payment.
- Go to the original invoice
- Click the blue arrow action button to the far right
- Select Refund
- Enter the partial refund amount
Then allow the new membership to begin normally with its full first payment.
This option keeps billing clean and easy to track.
Option 2: Adjust the First Invoice of the New Membership
Instead of issuing a refund, you may choose to reduce the first invoice of the new membership to account for the unused time from the previous package.
To do this:
- Add the new membership
- Locate the first invoice
- Edit the invoice amount before it is charged
- Reduce the amount by the calculated credit
Important
Invoices can only be edited before they are charged.
You can accomplish this in one of two ways:
Method 1 — Schedule the membership
Schedule the membership to start on a future date, then edit the invoice while it is still in the Upcoming state.
Method 2 — Start the membership immediately
- Add the membership with AutoPay turned OFF
- Edit the first invoice amount
- Collect the payment
- Turn AutoPay ON for the membership afterward
Best Practices
• Clearly communicate the adjustment to the athlete so they understand the credit or refund
• Document the reason for the adjustment in the athlete’s notes
• Double-check the start date of the new membership to prevent billing overlap