Skip to main content
Vindicia Knowledge Center

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




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 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 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 is calculated as below:

If (Total - refunds) < Earned then Liability = -1 * 'Yet to be Paid'

else Liability = (Payments received - Refunds) - Earned