SELECT 
    MAX(Order_Entry_System) AS Source, 
    MAX(OrderDate) AS Day, 
    COUNT(OrderID) AS Qty, 
    SUM(PaymentAmount) AS Payment, 
    SUM(TotalShippingCost) AS Shipping, 
    SUM(IFNULL(SalesTax1,0)+IFNULL(SalesTax2,0)+IFNULL(SalesTax3,0)) AS Tax, 
    SUM(PaymentAmount- IFNULL(SalesTax1,0)+IFNULL(SalesTax2,0)+IFNULL(SalesTax3,0)) AS TotalExcTax
FROM 
    orders
WHERE 
    OrderStatus != 'Cancelled' 
    AND OrderDate > '2020-01-31 23:59:00'
GROUP BY 
    order_entry_system, DATE_FORMAT(OrderDate, '%Y-%m-%d')
ORDER BY 
    Day DESC