Net Sales Dashboard - Not Including Payment Due Later Sales

[TartByTaylor]

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!