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

Publicaciones relacionadas	Respuestas	Vistas
How to filter contact those parent are in archive stage Resuelto filter	1 sept 25	117
Simultaneous search criteria across companies and persons filter	1 ago 25	231
Having to manually clear filters in Odoo version 18 on the webstore shop makes us lose customers filter	0 jul 25	1012
Filters in multiple companies Resuelto filter	1 may 25	1702
ADD PROPERTIES Resuelto filter	1 may 25	3405

Se marcó esta pregunta

¿Le interesa esta conversación? ¡Participe en ella!