Differentiating subscription invoices from one-shot services

Question

Hello,
I’m starting to learn how to use Odoo’s spreadsheet feature, mainly to calculate some ratios and get a clearer view of my window cleaning business.
Right now, I’d like to calculate my LTV (how much revenue an average client generates during the time they remain a client). To do this, I want to use my invoices in a spreadsheet. The issue is that I provide both one-shot services and subscriptions (billed monthly or annually, not per service). If subscription invoices and one-shot invoices a

Jaideep · Accepted Answer

custom filter > Account move line > Product > Subscription product is 'set' for invoices with subscription product and 'not set' for invoices with other products
image [1]
If you are filtering Sale orders then filter by 'Recurring'

[1] /web/image/81691156-448d4381/image.png?access_token=166bacb7-1b39-44e9-9dbb-2c598330b77b

Cybrosys Techno Solutions Pvt.Ltd · Answer

Hi,

On invoices, you can filter by Account Move Line → Product → Subscription Product: if it is set, the invoice comes from a subscription product, and if it is not set, the invoice is for a one-shot service. Similarly, on sales orders, you can filter by Recurring = True to identify subscriptions and Recurring = False for one-shot sales. This way you can clearly separate subscription revenue from one-shot revenue, ensuring your LTV calculation in Odoo Spreadsheet is accurate.

To get the sales

Gerelateerde posts	Antwoorden	Weergaven
How to filter contact those parent are in archive stage Opgelost filter	1 sep. 25	136
Simultaneous search criteria across companies and persons filter	1 aug. 25	232
Having to manually clear filters in Odoo version 18 on the webstore shop makes us lose customers filter	0 jul. 25	1013
Filters in multiple companies Opgelost filter	1 mei 25	1703
ADD PROPERTIES Opgelost filter	1 mei 25	3409

Deze vraag is gerapporteerd

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!