Docs
You are viewing:
Product Catalog 2.0
This article includes
What are Sales, Discount, Tax Reversals, and other terms on the Account Summary report?
Where can I see the breakdown details of the account summary report numbers?
Summary
Sales Formula |
---|
Sales = Sum(Amount of invoices in the status of Paid/Payment Due/Not Paid/Voided/ Posted, whose invoice date falls in the month) + Sum(Amount of voided credit notes (not write off case) which are voided in that month) |
Sales Reversal Formula |
---|
Sales Reversal = Sum(Amount of invoices in status Void and voided at date falls in that month) + Sum(Amount of credit notes(not write off case) which are created over that month) |
Discounts Formula |
---|
Discounts = Sum(discount applied in invoices in the status of Paid/Payment Due/Not Paid/Voided/Posted, whose invoice date falls in the month) + Sum (Discounts over the voided credit notes which are voided in that month) |
Discount Reversal Formula |
---|
Discounts Reversal = Sum(Discount applied over invoices in status Void and voided at date falls in that month) + Sum(Discounts of credit notes which are created over that month) |
Tax Formula |
---|
Tax = Sum(Tax applied in invoices in the status of Paid/Payment Due/ Not Paid/Voided/ Posted, whose invoice date falls in the month) + Sum (Tax over the voided credit notes which are voided in that month) |
Tax Reversal Formula |
---|
Tax Reversal = Sum(Tax applied over invoices in status Void and voided at date falls in that month) + Sum(Tax of credit notes which are created over that month) |
Bad Debt Formula |
---|
Bad Debt = Sum(Amount in Credit Notes that has reason code as a write off based on created at) |
Bad Debt Reversal Formula |
---|
Bad Debt Reversal = Sum(Amount in voided credit notes that has reason code write off based on voided at date) |
Payment Formula |
---|
Payment = Sum(Transactions Amount with the type (Payment) whose transaction date without settled at date falls under the month) + Sum(Transactions Amount with type Payment whose settled date falls under the month) - Sum(Transactions Amount with type Payment Reversal) |
Refund Formula |
---|
Refund = Sum(Transactions Amount with type "Refund" based on the transaction date) |
Recognized Revenue: This has the sum of all recognized revenue which is greater than zero for the selected period from the revenue recognition detail report
Revenue Reversal: This has the sum of all recognized revenue which is less than zero for the selected period
Deferred Revenue: This has the sum of all deferred revenue for the selected period from the deferred revenue detail report
Aging Balance: This has the sum of outstanding amount which the customer needs to pay by Due date at the end of the month.
Was this article helpful?