Handling deferred revenue when the e-commerce platform doesn't.
- Michael Pirumov
The setup¶
A small boutique e-commerce business selling one-time products plus recurring perfume subscriptions. Single-owner operated, running on a standard e-commerce platform with Stripe under the hood. The operator needs clean monthly books and accurate revenue recognition — particularly for the subscription side of the business.
What makes this hard¶
Subscription revenue can't be recognized when the customer is charged. A subscription paid upfront has to be recognized across the months the product delivers. The e-commerce platform has no built-in deferred revenue module, which means someone has to track every active subscription's earning schedule and post the right journal entries monthly.
What we built¶
- Manual deferred revenue tracking process, run outside the e-commerce platform.
- For each active subscription, we track the prepaid balance and the portion earned to date.
- Monthly journal entries to recognize revenue as earned and reduce the deferred balance.
- Year-end finalization so the books match reality at each reporting date.
How it runs now¶
Every month: subscription activity gets pulled, the deferred revenue schedule updates, journal entries post, and the books stay current. Subscription revenue lands in the P&L when it's earned, not when it's charged. The operator doesn't have to think about the mechanics — they get clean monthly books.
The outcome¶
- Subscription revenue recognized correctly every month.
- Deferred revenue balance tracked accurately.
- Monthly bookkeeping without the owner having to handle accrual accounting themselves.
- Year-end books match reality — no surprises at tax time.