Current Liability Report
This report generates a CSV format report of liability at the invoice level, on a given day. If run on-demand (not scheduled), the report runs on the date requested. When creating a scheduled report—whether daily, weekly, or monthly—you specify the start date and the report runs on that date.
The report identifies invoices by Customer ID, Invoice ID, Subscription ID, Billing Plan ID, and Affiliate ID if available. Dates include the service period start and end date, and the invoice date. Currency values include the Invoice Total, Payments Received, Payments Due, and Total Refunds. Earned and Unearned values and Liabilities are calculated based on these values.
Invoices are included for reporting if
Service Start Date <= Reporting Date < Service End Date
Service Start Date > Reporting Date, and the Invoice has been paid off
Service End Date <= Reporting Date and the Invoice has not yet been fully paid off
The Earned value is either the full amount, if the Reporting Date <= Service End Date, zero if the Reporting Date is before the Service Start Date, or the ratio of the amount times how much of the service period has been fulfilled. If the invoice is half way through the service period at the Report Date, the Earned value is half the amount.
The Unearned value is the Invoice Total less the Earned Value.
The Liability is either the payment less Refunds and Earned Value or, if the Earned value is more than the Invoice Total less Refunds, the negative of the payment due.
Enter desired parameters and click Submit to run the report.
Display Columns
|
Field |
Description |
|
Reporting Date |
Date provided by the Merchant. The report data is as-of this date. The report is run at this date at 24:00:00. |
|
Customer ID |
Merchant’s ID for the customer for whom the invoice is generated. |
|
Subscription ID |
The ID of the Subscription for which the invoice is generated. |
|
Affiliate ID |
Affiliate ID associated with the Subscription—indicates the sub group within merchant. |
|
Invoice ID |
Merchant’s Invoice ID. |
|
Billing Plan |
Merchant Billing Plan Identifier of the Subscription. |
|
Service Period Start |
Start date of the Service Period for the invoice. |
|
Service Period End |
End date of the Service Period for the invoice. |
|
Invoice Date |
Original activity date of the invoice. |
|
Currency |
Currency code of the payment. |
|
Invoice Total |
Total Amount of the Invoice. |
|
Payment Received |
Total Payments made against this invoice. |
|
Yet to be Paid |
Difference between Invoice Total and Payments received. |
|
Total Refunds |
Sum of Refunds that have been done against transaction(s) for this invoice. |
|
Earned |
Earned and Unearned are calculated on Invoice line items based on the following logic, then summed for Invoice level • Earned is calculated as below if (Service Start Date <= Reporting Date < Service End Date): Amount * (number of days between Service start Date and Reporting date /number of dates in service period). (Service period start date, Service End Date and Reporting date are inclusive) • Earned is "0" if Service Period Start Date > Reporting Date. • Earned is "Amount" if Service End Date <= Reporting Date. |
|
Yet to be Earned |
Difference between Invoice Total and Earned. |
|
Liability |
Liability is calculated as below: If (Total - refunds) < Earned then Liability = -1 * 'Yet to be Paid' else Liability = (Payments received - Refunds) - Earned |