Sales reports include unearned revenue, even though the service item on the invoices is linked to a liability account. How can I troubleshoot why?

Your deferred revenues will appear in your sales reports, Dustin. Let me provide sufficient information about this below.

Invoices for deferred revenue appear in sales reports in QBO because the program records the total amount as a sale, regardless of the revenue's earned status. This occurs even when the service item is linked to a liability account, as QuickBooks processes invoices or sales receipts as sales upon recording. The reporting mechanism aggregates all invoiced amounts, including those associated with deferred revenue, treating them as sales transactions. As a result, even technically unearned revenue is included in sales reports.

Nonetheless, it will not be included in your Profit and Loss (P&L) report until it is recognized as earned revenue. When you create an invoice for deferred revenue, the total amount shows up as a liability on the balance sheet rather than as income on the P&L report.

To exclude the deferred revenue from the sales reports, you can filter out the report to show only a specific amount.

1. Go to the Reports menu.
2. Select any sales reports.
3. Click on Customize in the top right corner.
4. Tap the Filter dropdown.
5. From the Product/Service dropdown, select only those items not linked to your deferred revenue account.
   
6. Click Run report to display the data.

Once you've tailored your reports to meet your specific needs, you can refer to this article to seamlessly export your business data to Microsoft Excel for use beyond QuickBooks: Export your reports to Excel from QuickBooks Online.

I'm just a reply away if you have any other questions about deferred revenue in QBO. We're always around here in the Community forum to help. Have a great day!