This KB explains the differences that may be present between the Product Sold and Invoice Report pages.
The difference between the Total Excluding VAT values visible in both the reports are discribes as follows:
Invoice Report -
Here, Total Excl Vat is inclusive of shipping cost excluding vat and discount excluding vat.
Shipping Cost and Total Discount is including Vat.
Product Sold -
Here, Sold Excl Vat is the total price excluding Vat of all products sold during that period of time without including the discount or shipping cost values.
Therefore,
Total Excl Vat (Invoice Report) = Sold Excl Vat (Product Sold) + Shipping Cost Excl. Vat + Total Discount Excl. Vat.