Perfect, thank you. Is there a way for me to have a list of those filters ? I often spend a lot of time looking for some filters. Once I know where to look, it becomes easy but the first time is always a pain in the a. 

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 orders, apply the following filter in the sales module.

To get the invoices, use the following filter.

Hope it helps