Think Build Implement Repeat
London, UK +44 7367 067226
WhatsApp FOLLOW f in X
  1. Home
  2. Blog
  3. How Do I Keep Track of How Many Boxes Each Prepaid Subscriber Has Left?
Problems We Solve

How Do I Keep Track of How Many Boxes Each Prepaid Subscriber Has Left?

Prepaid subscription box plans lose count of boxes remaining after skips and pauses. We build a prepaid ledger that counts each plan to its end.

Updated 3 min readBy SpiderHunts Technologies

Free estimateNo obligation

Get a free estimate

Tell us what you need. A senior engineer reads every enquiry.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →

Quick answer — TL;DR

Prepaid three, six and twelve month plans are simple until subscribers skip, pause, get a replacement or switch plans, and then 'boxes remaining' becomes a matter of opinion. We build a prepaid ledger that counts each box sent against each plan, handles skips and pauses by your rules, and prompts the subscriber before the plan runs out.

'I paid for six months, I have only had five'

The subscriber is sure. They bought a six month plan in April, paused for August, and now the plan has ended. Your subscription app says the plan finished after the September box. You look through their history: a skipped month, a replacement box sent in June after a courier lost the original, and a switch from the standard to the large box halfway through that may have reset something.

Working it out takes half an hour, and at the end you are still not certain. You send the sixth box anyway, because arguing is worse.

Why 'boxes remaining' gets muddled

Prepaid plans are often set up as a subscription that charges once and then ships on a schedule. That works for the simple case and becomes unclear for everything else.

  • Skips and pauses may or may not extend the plan, depending on how the app was set up.
  • Replacement boxes can be counted as one of the prepaid boxes by mistake.
  • Switching box size or plan length part way through creates a new subscription with its own count.
  • Prepaid plans bought as gifts behave differently from ones bought for yourself.
  • The end of a plan either renews automatically or stops, and subscribers are often unsure which.

The only reliable record is the list of boxes actually sent, and nobody compares that with what was paid for.

What the confusion costs

Every disputed count takes investigation time and usually ends in a free box to keep the peace. Some subscribers get one box too many without anyone noticing. Others get one too few and do not notice either, until they leave a review. Automatic renewals at the end of a long plan catch people out, leading to refunds and chargebacks.

Prepaid money is also money you owe in boxes. Without a clear count, you cannot say how many boxes you still owe across all prepaid subscribers, which your accountant will want to know.

The prepaid ledger we build

  1. Each prepaid plan is recorded as a balance of boxes, set when the plan is paid for.
  2. Each box actually dispatched to that subscriber reduces the balance, taken from the packing plan and courier records rather than the subscription schedule.
  3. Replacements are recorded as replacements, linked to the box they replace, and do not reduce the balance.
  4. Skips and pauses follow your rule, for example extending the plan by one box per skipped month, and the new end month is shown to the subscriber.
  5. Plan changes carry the remaining balance over to the new plan, with any price difference handled by your rule.
  6. Before the last box, the subscriber gets a note saying it is the last one and what happens next, whether that is renewal, a choice, or stopping.
EventEffect on balanceWhat the subscriber sees
Box dispatchedReduces by oneBoxes remaining on their manage page
Replacement sentNo changeReplacement noted against the original
Month skippedPlan extended by your ruleNew end month shown
Plan switchedBalance carried overUpdated plan and balance
Last boxBalance reaches zeroNote explaining what happens next

The ledger also gives a total of boxes owed across all prepaid plans at any date, which your bookkeeper or accountant can use as they see fit.

Prepaid plans without the arithmetic

When a subscriber asks how many boxes they have left, support sees the ledger and the answer, with every box listed. The subscriber can see the same number on their manage page. Skips extend plans automatically by your rule, replacements are never counted, and nobody is surprised by the end of a plan.

At the month end, you can see how many prepaid boxes you still owe and to whom.

Signs your prepaid plans need this

  • Subscribers dispute how many boxes they have received.
  • Replacement boxes are sometimes counted against the plan.
  • Skips on prepaid plans are handled differently by different staff.
  • You do not know how many prepaid boxes you still owe in total.
  • Automatic renewals at the end of long plans lead to refund requests.

FAQ

Frequently asked questions

The questions readers ask us after this guide.

Still have a question?

Ask us directly — a senior engineer will get back to you.

Ask about your project

Does our subscription app already track this?

Some do for simple cases. We check how yours handles skips, replacements and plan changes, and build the ledger only where it falls short.

How do we fix existing prepaid plans?

We rebuild each active plan's balance from the boxes actually dispatched, and list any where the records disagree for a person to decide.

Can prepaid plans renew automatically?

If you choose that. The ledger makes sure the subscriber is told before the last box, whichever rule you pick.

Is the owed-boxes figure an accounting number?

It is a count and a value at the price paid. How it is treated in your accounts is for your accountant to decide.

What drives the cost?

How prepaid plans are set up now, how many edge cases your history holds and where the balance needs to be shown.

Keep reading

More on Problems We Solve

Start here

Tell us where your subscription box admin piles up

Describe how a month runs for your box today, from the renewal charge to the last parcel leaving, and which subscription app, shop platform and courier tools you already use. We will tell you what we would build and what we would leave alone, and if a setting in your subscription app already covers it, we will say so.

  1. You tell us what you needTwo minutes on the form, or a message on WhatsApp.
  2. A senior engineer reviews itAnd comes back with questions, a realistic range and an honest view on fit.
  3. Free 30-minute scoping callWe talk through scope, options and a realistic estimate — with no obligation.
Free estimateNo obligation

Talk to someone who builds this

Send a short brief and we will come back with an honest view and a realistic range.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →