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.

For runtime reports only, the Current Liability report provides an option to choose whether to calculate current liability based on pre-tax or tax-inclusive amounts.

CurrentLiabilityReport.pngCreate 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. To calculate revenue based on tax-inclusive Invoice, Transaction and Refund amounts, expand Additional Filters and check the Include Taxes In Calculations checkbox. Uncheck this checkbox to calculate revenue based on pre-tax amounts. 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.

CurrentLiabilityReport_2.png

CurrentLiabilityReport_3.png

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.

Invoice ID Merchant’s Invoice ID.

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.

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.

Invoice Status

Current status of the invoice—Open, Paid, Due, Overdue, Written Off, Closed.

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.

Total Credits Total credit balance.
Total Discounts Total discounts (campaigns).
Total Taxable Credits Total pre-tax credits. 

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.

Unearned

The Invoice Total less the Earned value (amount not yet 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