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.

This report also provides an option to choose whether to calculate current liability based on pre-tax or tax-inclusive amounts, and an additional option to specify whether or not to include Portal-initiated refunds in the report.

CurrentLiabilityReport.pngCreate Current Liability Report

You can run a report on demand, or create a schedule for reports to be run regularly. 

To run a report now, 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, an email address. To calculate revenue based on tax-inclusive invoices, transactions and refund amounts, expand Additional Filters and check Include Taxes In Calculations. To include Portal-initiated refunds in calculations of current liabilities, check Include Portal-inititiated Refunds. 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 on date. Enter an email address if you want to be notified when the report is ready. To have the report uploaded to an SFTP server, expand SFTP Settings and provide details. Expand Additional Filters and check Include Taxes In Calculations to have taxes included when calculating revenue. Check Include Portal-initiated Refunds to include refunds initiated from the Portal. Click Submit.

The following figure shows the columns (fields) in the report.

CurrentLiabilityReport_1.png

CurrentLiabilityReport_2.png

Current Liability Report

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

Field

Description

Report 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 present at the time of invoice generation.

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—one of the following:

  • Open
  • Paid
  • Due
  • Overdue
  • Written Off
  • Closed

Currency

Currency code of the payment.

Total Charges

Total Amount of the invoice. Sum of all product amounts, excluding taxes, discounts, or credits.If you check Include Taxes in Calculations when you run the report, the amount shown in this field will include taxes.

Total Credits Total credit balance.
Total Discounts Total discounts (campaigns).
Total Tax  All sales tax charged on the invoice.

Invoice Due

Total amount to be paid by the customer. This amount includes taxes, and reflects any credits or discounts applied.

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. This amount will not include refunds initiated from the Portal unless you check Include Portal-initiated Refunds when you run the report.

Refunded Tax Amount

Sales tax amount refunded when a refund is issued.This amount will not include taxes on refunds initiated from the Portal unless you check Include Portal-initiated Refunds when you run the report.

Earned

Earned and Unearned are calculated on Invoice line items based on the following logic, then summed for Invoice level

• Earned is calculated as follows: 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 Total Charges less the Earned value (amount not yet earned).

Liability

Liability is calculated as follows: 

L = Total Received - Total Refunds + Discounts + Credits - Earned - Tax* 

Note: In the Liability formula L, *Tax: If "Yet to be paid" is greater than $0, set Tax=0 in the L formula above.

 

Vindicia Subscribe Features

Learn More
Vindicia Subscribe Features

For Developers

Learn More
For Developers
Back to Top