Net Sales Dashboard - Not Including Payment Due Later Sales

Payments + Shipping & Fulfilment

Topic summary

A store owner needs to calculate sales team commissions based on net sales, but only for orders that have been paid.

The current issue: Shopify’s Net Sales report includes orders marked as “Payment Due Later” (Net 90 terms), even though payment hasn’t been received yet.

What’s needed:

  • A Net Sales report that excludes “Payment Due Later” orders
  • Orders should only appear in the report once payment status changes to “paid”
  • The Payments dashboard was considered but shows total sales (including shipping) rather than net sales

The question remains unresolved with no responses yet on how to filter net sales by payment status in Shopify’s reporting system.

Summarized with AI on October 29. AI used: claude-sonnet-4-5-20250929.
1

Hello!

I pay my sales team a percentage of net sales each month.

We have a few customers on Net 90 terms. For those orders, we input them into Shopify and set the payment terms to “Payment Due Later” with a due date 90 days out.

However, when I run my Net Sales report, it includes these Net 90 orders - even though they haven’t been paid yet.

Is there a way to pull a Net Sales report that excludes any orders marked as “Payment Due Later”? And then only shows the order subtotal in my Net Sales once that orders been actually paid?

I thought the ‘Payments’ dashboard might have what I need, but it shows total sales (including shipping), which isn’t helpful since commissions are based solely on Net Sales.

Basically looking for a report that shows net sales on only sales that have a payment status of ‘paid’.

Thanks in advance for your help!

3 Likes