Skip to main content
Vindicia Knowledge Center

Current Liability Report

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, Autobill 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.

Create Current Liability Report

To run the report, go to Reports > Run Reports and select the report name. Enter a Day of Report date and, if you want to be notified when the report is ready, enter an email address. Click Submit.

To schedule a report, go to Reports > Create Scheduled Report and select the report name. Select weekly/monthly and enter a Begin the first report period date. Enter an email address if you want to be notified when the report is ready, and click Submit.

Current Liability Report

The following table describes the fields of the Current Liability Report.

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.

AutoBill ID

The ID of the Autobill for which the invoice is generated.

Affiliate ID

Affiliate ID associated with the Autobill—indicates the sub group within merchant.

Invoice ID

Merchant’s Invoice ID.

Billing Plan

Merchant Billing Plan Identifier of the Autobill.

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

 

Cashbox Features

Learn More
Cashbox Features

For Developers

Learn More
For Developers
Back to Top