I'll be more than happy to assist you with running and exporting your report, @info2078.
Currently, QBO does not support the functionality of getting the total amount of an invoice without the discount percentage affecting it. However, you can use the Invoice List report to view the total amount, and the invoice number does not duplicate.
Once the report is exported to Excel, you can manually adjust the total by adding back the discounted amount. It will allow you to see the original total before the discount is applied. Ensure to add the discount amount back to the net total to reflect the full original amount.
Example:
The invoice amount is £25, and there is a discount of £5. Therefore, the total comes to £30. (£25 +£5 = £30)
Moreover, visit this link to customize your reports in QuickBooks Online.
Additionally, for your future reference, check out this link to learn about customizing your sales templates.
Let me know if you still have questions about your reports. Have a great day, and take care.
