Why renewal dates cause trouble at quarter close
Stripe renewal dates at quarter close depend on four rules: the billing cycle anchor, the end-of-month rule, UTC, and trial, reset and plan changes. Every subscription has a day when the customer is billed again. Those are renewal dates. When a quarter is closing, someone has to say which renewals land inside it, and building that list is harder than it looks. The renewal date on one screen is not always the date that matters on the books. A trial that ended, a plan that was switched, a month with fewer days, or a clock in another time zone can each move a renewal across the edge of the quarter.
Key takeaways
- Take each renewal day from Stripe for every active subscription, not from a spreadsheet of start dates.
- Count the last day of the quarter as included, so a renewal that lands on it still makes the list.
- Pick one clock for the whole list, and check renewals on the last day of the quarter and the first day after it.
- Check trials, resets and plan switches from recent months, since each can move a renewal or create a bill.
This post walks through four rules that catch most of these surprises. The examples use Stripe, a billing system whose rules are published in detail, so you can check each claim yourself. A later section covers the sales report, because a renewal that is billed in the quarter is not always counted as a sale in that quarter.
You do not need to be a billing expert to use these rules. You need the real renewal date for each subscription and a clear answer to one question: which clock does your company use to decide what day it is?
Rule 1: Read the renewal day from each subscription
Stripe sets a subscription's renewal day from a reference date it calls the billing cycle anchor. Think of the anchor as the day the whole schedule hangs from. Stripe's billing cycle guide says the default anchor is "either the subscription creation date or the trial end date." So the day a customer signed up is only one possible starting point. If the subscription began with a trial, the day the trial ended may be the one that counts.
This is why a spreadsheet of contract start dates is risky. The two can drift apart as soon as a trial, a change or a reset happens, and nobody updates the spreadsheet. Read the renewal day from Stripe itself, for each active subscription. The spreadsheet can stay as a record of what was signed, but it should not decide the quarter.
What to do:
- Find each active subscription in your Stripe account.
- For each one, write down its next renewal date.
- Mark any subscription that started with a trial or had a change recently. Rule 4 applies to those.
Rule 2: A renewal set to the 31st moves in shorter months
Stripe's guide states the rule plainly: "If a month has less than 31 days, the subscription renews on the last day of that month." A subscription set to renew on the 31st does not skip February or April. It renews on the last day of that month instead.
This matters most at the edge of a quarter. Suppose your quarter ends on the last day of a month that has fewer than 31 days. A renewal set to the 31st will land on that last day, which is still inside the quarter. If your cut-off is written as "before the last day," that renewal will drop off your list. The fix is simple: make the cut-off include the last day itself. For more on cut-offs, see quarter cutoff checks.
The shift can happen in any quarter, not only at its end. A subscription set to the 31st moves in every short month, so a list built only from the stored day will show the wrong date for those months. Check the real date for each month, not only the day stored on the subscription.
What to do:
- Flag every subscription whose renewal is set to the 31st.
- For each flagged subscription, check the real renewal date in every month of the quarter.
- Treat the last day of the quarter as an included day, not an excluded one.
Rule 3: Stripe keeps time in UTC, so a late renewal can change its day
Stripe's guide also says: "The billing cycle anchor uses Coordinated Universal Time (UTC)." UTC is the standard world clock. It does not move for daylight saving time, and it usually does not match the clock on your office wall.
This matters for renewals that happen late in the day. A renewal late in the afternoon on the US West Coast can already be the next calendar day in UTC. If your team counts days in local time, and the billing data is in UTC, the same renewal can fall on one side of your quarter's last day in one report and on the other side in another. The problem only shows up on the last day of the quarter and the first day after it. Those are the days people argue about at close.
Your company's clock might be the one on the office wall, the time at headquarters, or the time in the place where the books are kept. Any of these can work. What matters is picking one, writing it down, and using it for every renewal on the list.
What to do:
- Write down the clock your company uses to decide which quarter a day belongs to. Use that one clock for the whole list.
- Check every renewal dated on the last day of the quarter, and every renewal on the first day after it.
- For those renewals, look at the exact time and its time zone, then convert it to your chosen clock before you assign it to a quarter.
Rule 4: Trials, resets and plan switches can move the date and send a bill
Changes made after sign-up cause most of the surprises. Stripe's guide describes three that matter for quarter close.
First, a trial that ends on a set date moves the renewal day to that date. The guide says that setting the trial end "sets the billing cycle anchor to the same date." A trial that ends late in the quarter can therefore give a customer a new renewal day, and the day on the original contract no longer applies.
Second, a reset sends a bill straight away. Stripe says: "After you reset the billing cycle anchor, Stripe immediately sends an invoice." If someone resets a renewal to today, the customer receives a bill today. That bill can land inside the quarter you are closing, even when the regular renewal was due later.
Third, switching to a plan billed on a different schedule resets the renewal day. The guide says the anchor "resets to the current time when switching to a price with a different" billing interval. Moving a customer from a monthly plan to a yearly plan, or back again, sets a new renewal day from the moment of the switch.
A new subscription can also produce an early bill. Stripe "automatically creates a prorated invoice to bill for the period between the subscription creation date and the first full invoice date." In plain words, when a subscription starts partway through a billing period, Stripe bills the leftover days first, on their own invoice. That first bill can fall inside the quarter even though the regular renewal does not.
These changes are easy to make and easy to forget. A small team may change a plan to settle a customer complaint, or end a trial early to keep a deal moving, and never think about what it does to the renewal day. Ask the people who handle customer changes to tell you when they made one.
What to do:
- List every trial that ended, or is set to end, in the last few months.
- List every reset and every plan switch from the same period.
- For each one, note the new renewal day and any bill it created. A bill dated inside the quarter counts as billed in the quarter.
Illustrative example with three customers
Picture a small software company with three subscriptions. The example is made up.
Customer A has a monthly plan renewing on a late day of the month. In a shorter month, Stripe moves that renewal to the month's last day. If the quarter ends on that day, the renewal counts only if the cut-off includes it. Rule 2 catches it.
Customer B finished a trial on the last day of the quarter. The trial's end date is now the renewal day. Stripe records the anchor in UTC, so the exact time may fall on the first day of the next quarter in your company's clock. Rule 3 and Rule 4 both apply.
Customer C switched from a monthly plan to a yearly plan last week. The switch reset the renewal day, and Stripe sent an invoice straight away. That bill counts as billed in the quarter. Rule 4 catches it.
Common mistakes to avoid
Three mistakes show up again and again:
- Writing a cut-off as "before the last day" and dropping renewals that land on that day.
- Mixing time zones in one list.
- Counting a bill as revenue for the quarter it was sent in, when the money is earned over the months it covers.
Keep three numbers apart
The four rules tell you when a renewal is billed. They do not tell you when the money is earned. Stripe's explainer on ratable revenue describes ratable revenue as income spread out over time, and says: "The business gradually recognizes ratable revenue as income over the period in which a service or product is delivered."
In plain words, when a customer pays for a year of software, the company usually earns that money a little at a time, across the months the customer is covered. The bill date and the earning date can fall in different quarters. A bill sent in the last month of a quarter can cover service in the next one.
So split your quarter close into three separate numbers:
- Billed in the quarter: renewals and first bills dated inside the quarter.
- Earned in the quarter: the share of each fee that covers months inside the quarter.
- Closed in the quarter: sales deals marked won, with a close date inside the quarter.
Each number answers a different question. A renewal can appear in the first list and not in the second. Do not add the three together, and do not use one as a stand-in for another.
Nutshell's sales report counts deals on their close date
If your sales report is in Nutshell, its X axis is explained in Nutshell's sales report guide, which says: "The X axis on the report is the close date of your Won leads." In plain words, each won deal sits in the period of its close date. For dates that have moved, see the close date change log.
This creates a gap. A customer can be billed every month in Stripe and still not appear in the quarter's sales numbers, if no won deal with a close date in the quarter was recorded for that renewal. Nobody has to make a mistake for this to happen. The billing system records the payment, the sales system records the deal, and the two lists have to be matched by hand or by a rule.
What to do:
- Match each billed renewal to a won deal in your sales system. For a related checklist, see bookings reconciliation checks.
- Where a renewal has no matching deal, decide whether it needs one. Some renewals need no new deal. Others were never recorded.
- Write the decision next to the renewal, so the same question does not come back next quarter.
How to say which renewals land in the quarter
When someone asks which renewals landed in the quarter, answer with three numbers and one note. Give the count of renewals billed in the quarter, the amount of each fee earned in the quarter, and the count of deals closed as won in the quarter. Then name the clock you used, so nobody has to guess whether a late-day renewal was counted correctly.
Add a short note listing the renewals that moved because of a trial, a reset or a plan switch. Leaders tend to trust a close that shows its exceptions, because the exceptions are where the surprises would have been.
Keep the note plain. "Four renewals moved because of trials, and one was billed early after a switch" tells the room more than a table of dates. A sentence like that also shows that someone checked the edges, which is what a close is supposed to do. If the numbers are not final yet, say so in the same note and name the one thing still open.
A short check before the quarter closes
Use this list in order. It takes less time than fixing a wrong number after the books are shut.
- Find every active subscription in Stripe and list it with its next renewal date.
- Mark the renewals that fall inside the quarter.
- Mark the subscriptions set to renew on the 31st, and check their real dates in each month of the quarter (Rule 2).
- Write down your company's clock for the quarter. Check every renewal dated on the last day of the quarter or the first day after it (Rule 3).
- List trials, resets and plan switches from the recent months. Note each new renewal day and any bill each one created (Rule 4).
- Split the results into billed, earned and closed. Keep the three numbers apart.
- Match each billed renewal to a won deal, and record any that do not match.
Where these rules come from
The rules in this post come from two help pages: Stripe's billing cycle guide and Nutshell's sales report guide. Stripe's explainer on ratable revenue supports the point about earning money over time. The quotes are word for word from their cited pages, and the links point to them, so you can read the full context. We did not check how other billing systems set their dates, so do not assume the same settings apply to them.
What these rules do not cover
These four rules explain how Stripe sets renewal days and bills. They do not decide how your accountant books revenue, what your contracts say about start dates, or which time zone your company must use for tax or formal reports. Check those questions with the people who handle your books.
Other billing systems use different names for these settings, so look for the same four ideas: the reference day that a renewal hangs from, the end-of-month rule, the clock the system uses, and what a trial, reset or plan change does to the date. Rules change over time, so check the guide's current wording before you rely on it for a close.
Your next step today
Today, pick one active subscription that started a trial or changed plan in the last few months. Find its next renewal date in Stripe and compare it with the date on your list. If the two differ, correct the list before the close.
Frequently asked questions
Does a trial change the renewal day?
Yes. When a trial ends, the renewal day can move to the trial's end date, so check trial end dates before you rely on the contract start date.
Which clock should the quarter list use?
Pick one clock your company already uses, write it down, and use it for every renewal on the list.
Does the last day of the quarter count?
Yes, it should. A renewal set to a late day of the month can land on the last day of a shorter month, and a cut-off that stops before that day will drop it.