What report should I run to get the details for Discount Reversal?

Problem Statement

This article helps you understand what report should i run to get the details for discount reversal.

Solution

This article covers

My discount reversal doesn't show up in the Invoice or Credit report

Summary

Discount Reversal is the sum of the discount amount applied over all the voided invoices. (Voided at date filter applied). It also includes the sum of the credit notes.

The formula applied is,

For example, in order to check the reversals for the month of December 2019 for the summed up amount say, ($395.66) follow the below steps:

1. Go to the Invoices report and invoices section and filter the invoices which were voided in the month of December 2019 (Use column AB for the filter).

   

2. Search for these invoices in the Line items tab and check for the corresponding discount value. (Specifically for the month of December 2019, there is no discount value associated with the voided invoices.)

   

3. Go to the Credit notes section and filter the invoices which were created in the month of December 2019 (Use column G for the filter). The below image shows the Credit Notes created in December 2019.

   

4. Now search for the Credit Notes in the Line items tab and check for the corresponding discount value. (The discount value is highlighted in column-J.)

   

5. As specified in the image above, only the credit Notes TEST-CN-3 and TEST-CN-10 have a discount value associated with them.