What reports are available?

Follow

The following reports can be generated and downloaded as a file in CSV or JSON format. 

General Reports:

  • Active Products
  • Aggregate Contract Phase Change
  • Component Subscriptions
  • Contract Churn Overveiw
  • Contract Phase Change
  • Contracts
  • Discount Subscriptions

Accounting and Controlling:

  • Accounts Receivable Ageing Report 
  • Aggregate Accounting
  • Debitor Balances
  • Deferred Invoices
  • Dunning Overview
  • MOSS (Elster)
  • MOSS (Extended)
  • Open Items
  • Open Items (Receivables)
  • Open Items (Payables)
  • Payment Overview
  • Turnover
  • Turnover Forecast

 

Depending on the type of report, you can choose a period or a key date for which the report is to be generated. The reports are generated asynchronously, which means that it can take some time before the report is completed by the system. After completion, the reports are available for download in the "Available files" section.

Note: You can also generate reports via API call. If you subscribe to the Webhook "ReportSucceeded", you can retrieve the generated file from billwerk automatically.

 

General Reports: 

Active products

This report outputs which products are booked how often in combination with which currency, plan variant and discount. One line of the report represents a combination of product (plan variant or component), active contract phase (trial or normal) and applied discount that is used at least once in the reporting period. The following fields are available:

Designation Description
PlanVariantName The name of the plan variant.
ProductName The name of the plan or component.
PlanVariantExternalId The external ID of the plan variant.
DiscountName The name of the discount.
PhaseType The phase the contract is in (trial or normal).
Currency The applicable currency.
Count The number of contracts in which the product is active.
Quantity The quantity of all active products in the respective combination.
New The number of contracts for which the respective combination of products was added during the report period.

 

Aggregate Contract Phase Change

This report shows you which changes of contract phases occurred how often in the reporting period. One line of the report represents a Plan Variant with which there has been at least one contract phase change in the reporting period. The following fields are available:

Designation Description
OldPhaseType The type of phase of the old contract phase.
OldPlanId The technical plan ID of the old contract phase.
OldPlanName The name of the old plan.
OldPlanVariantId The technical ID of the plan variant in the old contract phase.
OldPlanVariantName The name of the Plan Variant of the old contract phase.
OldPlanVariantExternalId The external ID of the plan variant of the old contract phase.
OldQuantity The booked quantity of the plan in the old contract phase.
NewPhaseType The type of phase of the new contract phase.
NewPlanId The technical ID of the plan of the new contract phase.
NewPlanName The name of the plan of the new contract phase.
NewPlanVariantId The technical ID of the new plan variant of the new contract phase.
NewPlanVariantName The name of the plan variant of the new contract phase.
NewPlanVariantExternalId The external ID of the new plan variant of the new contract phase.
NewQuantity The quantity booked of the plang of the new contract phase.

 

Component Subscriptions

This report provides a list of all contracts with component subscriptions. One line of the report displays the details of a component subscription. The following fields are provided:

Designation Description
ComponentSubscriptionId The technical ID of the component subscription
Quantity The quantity in which the component was booked.
StartDateUtc The start date of the component subscription in Utc.
EndDateUtc The end date of the component subscriptions in Utc.
BilledUntil The date up to which the component subscription was billed.
Memo The Memo text transferred with the booking.
ComponentId The technical ID of the component booked.
ComponentExternaId The external ID of the component booked.
ComponentName The name of the component booked.
ContractId The technical ID of the contract the component subscriptions belongs to. 
ReferenceCode The contract reference code.
CustomerId The technical customer ID.
ExternalCustomerId The external customer ID.
CompanyName The company name of the customer.
FirstName The first name of the customer.
LastName The surname of the customer.
VatId The VAT ID of the customer.
DebitorAccount The debitor ID of the customer.
EmailAddress The email address of the customer.
PhoneNumber the telephone number of the customer.
CustomerHidden Flag, that the customer was hidden.
CustomerNotes Notes on the customer.
CustomerTag  
Locale Customer's "local" setting for the language used.
TaxCountry The customer's tax country.
AddressLine1 ... Country The (postal) address fields of the customer.
CustomerCreatedAtUtc The creation date of the customer in UTC.
ContractNotes Notes on the contract.
ContractStartDateUtc Start date of the contract in UTC
ContractEndDateUtc End date of the contract in UTC
Currency The currency in which the contract is billed
CurrentPlanId The ID of the current plan.
CurrentPlanVariantId The ID of the current plan variant.
CurrentPlanName The name of the current plan.
CurrentPlanVariantName The name of the current plan variant.
CurrentPlanQuantity The quantity of the current plan booked.
CurrentPhaseStartDateUtc The start date of the current phase of the contract in UTC.
CurrentPhaseType The current phase of the contract.
NextPlanId The ID of the next plan.
NextPlanVariantId The ID of the next plan variant.
NextPlanName The name of the next plan.
NextPlanVariantName The name of the next plan variant.
NextPlanQuantity The quantity of the next plan.
NextPhaseStartDateUtc The start date of the next phase of the contract in Utc.
NextPhaseType The type of the next phase of the contract.
Balance The balance of the contract ledger.
DunningLevel The dunning level of the contract.
StartDateLocal The start date of the component subscription in CET.
EndDateLocal The end date of the component subscription in CET.
BilledUntilLocal The billed until date of the component subscription in CET.
CurrentPhaseStartDateLocal The start date of the current phase of the contract in CET.
NextPhaseStartDateLocal The start date of the next phase of the contract in CET.
ContractStartDateLocal The start date of the contract in CET.
ContractEndDateLocal The end date of the contract in CET.
CustomerCreatedAtLocal The creation date of the customer in CET.

 

Contract Churn Overview

The Contract Churn Overview displays the churn rate for individual products in the reporting period. One row of the report corresponds to one product. The churn rate is calculated for all Plan Groups, Plans and Plan Variants. The following fields are available:

Designation Description
PlanGroupId The technical Id for the PlanGroup.
PlanGroupName The name of the PlanGroup.
PlanId The technical Id of the Plan.
PlanName The name of the Plan.
PlanVariantId The technical Id of the PlanVariant.
PlanVariantName The name of the PlanVariant
ChurnRate The Churn Rate in percent calculated as:
ChurnRate=TotalChurns/ContractMonths*100
TotalChurns

The total amount of contracts that have change from a normal phase to an inactive phase.

ContractMonths

The total amount of months the product has been used in a normal phase. 

AverageContracts

The average amount of contracts of the product that are in a normal phase. 

All calculation results are rounded to one decimal place. For the calculations, unrounded values are used.

 

Contract Phase Change

This report shows you which changes of contract phases occurred in which contracts during the reporting period. Each row represents a contract in which a contract phase change took place in the reporting period. The following fields are available:

Designation Description
OldPhaseType The type of phase of the old contract phase.
OldPlanId The technical plan ID of the old contract phase.
OldPlanName The name of the old plan.
OldPlanVariantId The technical ID of the plan variant in the old contract phase.
OldPlanVariantName The name of the Plan Variant of the old contract phase.
OldPlanVariantExternalId The external ID of the plan variant of the old contract phase.
OldQuantity The booked quantity of the plan in the old contract phase.
OldStartDateLocal The start date of the old contract phase in CET.
OldStartDateUtc The start date of the old contract phase in CET.
NewPhaseType The type of phase of the new contract phase.
NewPlanId The technical ID of the plan of the new contract phase.
NewPlanName The name of the plan of the new contract phase.
NewPlanVariantId The technical ID of the new plan variant of the new contract phase.
NewPlanVariantName The name of the plan variant of the new contract phase.
NewPlanVariantExternalId The external ID of the new plan variant of the new contract phase.
NewQuantity The quantity booked of the plang of the new contract phase.
NewStartDateLocal The start date of the new contract phase in CET.
NewStartDateUtc The start date of the new contract phase in UTC.
FirstPhaseType The first phase of the contract.
FirstPlanId The ID of the first plan.
FirstPlanName The name of the first plan.
FirstPlanVariantId The ID of the first plan variant.
FirstPlanVariantName The name of the first plan variant.
FirstPlanVariantExternalId The external ID of the plan variant of the first contract phase.
FirstQuantity The booked quantity of the plan in the first contract phase.
FirstStartDateLocal The start date of the first contract phase in CET.
FirstStartDateUtc The start date of the first contract phase in UTC.
ContractId The technical ID of the contract.
ReferenceCode The contract reference code.
CustomerId The technical ID of the customer.
ExternalCustomerId The external ID of the customer.
CompanyName The company name of the customer.
FirstName The given name of the customer.
LastName The surname of the customer.
DebitorAccount The debitor ID of the customer.

If configured, the customer fields for customers and contracts are appended to the field list of this report.

 

Contracts

Contracts is not a classic report but a list of all contracts with all information about the customer and the contract. One line of the report represents one contract that exists in the reporting period. The following fields are available:

Designation Description
ContractId The technical ID of the contract.
ReferenceCode The contract reference code.
CustomerId The technical ID of the customer.
ExternalCustomerId The external ID of the customer.
CompanyName The company name of the customer.
FirstName The given name of the customer.
LastName The surname of the customer.
VatId The Value Added Tax ID of the customer.
DebitorAccount The debitor ID of the customer.
EmailAddress The email address of the customer.
PhoneNumber The phone number of the customer.
CustomerHidden Flag, that the customer was hidden.
CustomerNotes Notes on the customer.
CustomerTag  
Locale Customer's "local" setting for the language used.
TaxCountry The customer's tax country.
AddressLine1 ... Country The (postal) address fields of the customer.
CustomerCreatedAtUtc The creation date of the customer in UTC.
ContractNotes Notes on the contract.
ContractStartDateUtc The start date of the contract in UTC.
ContractEndDateUtc The end date of the contract in UTC.
Currency The currency in which the contract is billed.
PaymentProvider The payment service provider applicable for the payments.
Role The mean of payment.
IBAN The IBAN for SEPA direct debit.
BIC The BIC for SEPA direct debit.
AccountHolder The account holder for SEPA direct debit.
CurrentPlanId The ID of the current plan.
CurrentPlanVariantId The ID of the current plan variant.
CurrentPlanName The name of the current plan.
CurrentPlanVariantName The name of the current plan variant.
CurrentPlanVariantName The name of the current plan variant.
CurrentPlanQuantity The quantity of the current plan booked.
CurrentPhaseStartDateUtc The start date of the current phase of the contract in UTC.
CurrentPhaseType The current phase of the contract.
NextPlanId The ID of the next plan.
NextPlanVariantId The ID of the next plan variant.
NextPlanName The name of the next plan.
NextPlanVariantName The name of the next plan variant.
NextPlanQuantity The quantity of the next plan.
NextPhaseStartDateUtc The start date of the next phase of the contract in UTC.
NextPhaseType The type of the next phase of the contract.
PreviousPlanId The ID of the previous plan.
PreviousPlanVariantId The ID of the previous plan variant.
PreviousPlanName The name of the previous plan.
PreviousPlanVariantName The name of the previous plan variant.
PreviousPlanQuantity The quantity of the previous plan.
PreviousPhaseStartDateUtc The start date of the previous phase of the contract in UTC.
PreviousPhaseType The type of the previous phase of the contract.
Balance The balance of the contract ledger.
DunningLevel The dunning level of the contract.
TotalPayment The total amount previously paid for the contract.
GrossTurnover The gross sales of the contract settled to date.
NumberOfDaysInCurrentPhase The number of days that the contract is in the current phase.
CustomerIsLocked Information if the customer is locked or not. 
CurrentPhaseStartDateLocal The start date of the current phase of the contract in CET.
NextPhaseStartDateLocal The start date of the next phase of the contract in CET.
PreviousPhaseStartDateLocal The start date of the previous phase of the contract in CET.
ContractStartDateLocal The start date of the contract in CET.
ContractEndDateLocal The end date of the contract in CET.
CustomerCreatedAtLocal The creation date of the contract in CET.
FirstPlanId The ID of the first plan.
FirstPlanVariantId The ID of the first plan variant.
FirstPlanName The name of the first plan.
FirstPlanVariantName The name of the first plan variant.
FirstPlanQuantity The booked quantity of the plan in the first contract phase.
FirstPhaseStartDateLocal The start date of the first contract phase in CET.
FirstPhaseStartDateUtc The start date of the first contract phase in UTC.
FirstPhaseType The first phase of the contract.
If configured, custom fields for customer and contract are added in this part of the report
VatIdValidationStatus Status or result of the VATID check performed against VIAS.

 

 

Discount Subscriptions

This report displays a list of all contracts with discount subscriptions. One line of the report represents one discount subscription including all details. The following fields are available:

Designation Description
Id The technical ID of the discount subscription.
DiscountId The technical ID of the discount booked.
CouponId The technical ID of the coupond used.
CouponCode The coupond code used for the discount subscription.
CreationTimeUtc The time, when the discount subscription was booked in UTC.
StartDateUtc Start date of the discount subscription in UTC.
EndDateUtc End date of the discount subscription in UTC.
ContractId The technical ID of tthe contract, the discount subscription applies to.
DiscoutInternalName The internal name of the discount.
CouponInternalName The internal name of the coupond.
CreationTimeLocal The time, when the discount subscription was booked in CET.
StartDateLocal Start date of the discount subscription in CET.
EndDateLocal End date of the discount subscription in CET.

 

Accounting and Controlling:

 

Accounts Receivable Ageing Report

The Accounts Receivable Ageing Report provides an overview of how many receivables are overdue for how long. One line of the report summarizes the existing open receivables grouped by currency that are overdue for the same amount of days. The first line shows the receivables that are not yet overdue. The following fields are available:

Designation Designation
Currency The currency. 
DaysOverdue The amoun of days the receivable is overdue for.
DueDate Due date of the recivable.
Amount Amount overdue.
County  The quantity of overdue reveiables.

 

Aggregate Accounting

This report displays the financial key figures aggregated for the report period per month. One line of the Report represents one month of the reportingperiod. The following fields are available:

Designation Description
Month The applicable month.
StartDate The start date of the month.
EndDate The end date of the month. 
Currency The applicable currency.
Account The configured accounting account
VatPercentage The VAT rate applied.
TotalGross The total gross.
TotalVatFromGross The total tax amount incurred for the gross sales for this sales tax rate and month.
TotalNetFromGross

The total net, calculated from the total gross at the VAT rate applied. 

TotalVatSum

The total VAT sum for the month, calculated from the VAT sum of all invoices for this VAT rate.

TotalNetSum The net total for the month, calculed from the individual invoices for this VAT rate.
Deferrals The deferred income positions created for the month and VAT rate.
ResolvedDeferrals The deferred income positions resolved for the month and VAT rate.

 

Debitor Balances

The Debitor Balances display a list of all receivables and payments as well as the corresponding balance of a customer in the reporting period. One line of the report represents one customer for which the receivables have changed in the reporting period.

The following fields are available:

Designation Description
CustomerId The technical ID of the customer.
DebitorAccount The debitor ID of the customer.
CustomerName The aggregate name* of the customer.
Currency The currency applicable.
Balance Before The balance of all due receivables and pacments, credits balances and refunds.
ReceivablesInPeriod The amount due in the reporting period.
Attention: this can parcially consist of credit
PaymentsinPeriod The amount paid in the reporting period.
BalanceAfter The balance of due receivables and payments, credit balances and refunds at the end of the reporting period.

* - the aggregate name is the company name, if the company name is empty, the given name and surname are displayed.  

 

Deferred Invoices

This report displays all invoices for which deferred income positions exist in the report period that have not yet been resolved. One line of the report represents one invoice. The following fields are available:

Designation Description
InvoiceNumber The invocie number.
InvoiceDate The invoice date.
StartDeliveryPeriod The beginning of the service period.
EndDeliveryPeriod The end of the service period.
StartReportingPeriod The start of the reporting period.
ReferenceDate The key date for the report.
TotalNet The total net.
SumResolvedAccDeferredIncome The sum of the resolved deferred income positions.
SumNotResolvedAccDeferredIncome The sum of the existing deferred income positions.

  

Dunning Overview

This report is generated for the time of creation and gives you an overview of how many contracts are in which dunning level and how high the dunned amounts for each dunning level are. One line of the report represents one dunning level grouped by currency. The following fields are available:

Designation Description
Currency The currency applicable.
Level The dunning level.
Count The quantity of contracts on this dunning level.
Sum The total gross of receivables on this dunning level.

 

MOSS (Elster)

Information on the purpose of the MOSS Report can be found in this article.

The MOSS report is created by billwerk in the format specified by ELSTER and can be directly imported there. You can read the details on the structure and import of the file on this page.

Only sales in euros are listed in the report. Sales for which no sales tax has been settled are excluded. One line of the report represents an EU country for which sales were posted at a concrete tax rate >0 in the reporting period. The following fields are available:

Designation Description
CountryCode

The country code according to eurostat.

VatType always =“STANDARD“
VatPercentage The applied VAT rate.
Net

The total net revenue calculated based on the total gross and applied VAT rate. 

Vat

The total VAT calculated based on the total gross. 

 

MOSS (Extended)

In this report you will find extended information on your sales in EU foreign countries and the withheld sales tax amounts. One line of the report represents an EU country for which sales were settled in the respective currency and at the respective tax rate in the reporting period. All currencies are included. Sales for which no sales tax was settled are excluded. The following fields are available: 

Designation Description
IsoCountryCode

The country code according to ISO-3166

EuCountryCode The country code according to eurostat.
CountryName The name of the country.
Currency The currency.
VatPercentage The VAT rate applied.
TotalGross The total gross revenue.
TotalVatSum The total withheld VAT.
TotalVatFromGross The total VAT calculated based on the total gross. 
TotalNetSum The total net revenue. 
TotalNetFromGross The total net revenue calculated based on the total gross and applied VAT rate. 

 

Open Items

This report displays a list of all open items. The open item report is generated on a key date. One line of the report represents one customer for which there is an open item at the key date. The following fields are available:

Designation Description
CustomerId The technical ID of the customer.
DebtorId The debitor ID of the customer.
Name The aggregate name* of the customer.
Street The street of the customer's address.
PostalCode The postal code of the customer's address.
City The city of the customer's address.
InvoiceNumber The invoice number.
SentAt The date of the invoice.
DueDate The due date of the open item.
Currency The currency applicable.
AmountDue The amount due of the open item.
AmountPaid The amount paid of the open item.
AmountUnpaid The amount unpaid of the open item. 

* - the aggregate name is the company name, if the company name is empty, the given name and surname are displayed.  

You can generate the open item report separately for open items (receivables) and open items (payables). Open items (receivables) contains all customers with AmountUnpaid > 0. Open items (payables) contains all customers with AmounUnpaid < 0.

 

Payment Overview

The payment overview lists all payments made for each payment service provider, mean of payment and currency. One line of the report represents one mean of payment for one payment service provider and currency. The number of triggered transactions and also the number of confirmed transactions are displayed. The following fields are available: 

Designation Description
PaymentProviderRole The mean of payment.
PymentProvider The name of the payment service provider (PSP).
Currency The currency applicable.
TriggeredSum The sum over the amounts of payment of all triggered payment transactions.
TriggeredCount The quantity of all triggered payment transcations.
ConfirmedSum The sum over the amount of payment of all confirmed payment transcations.
ConfirmedCount The quantity of all confirmed payment transactions. 

The confirmed payments (sum and count) refer to all confirmations registered in the reporting period, regardless of the payments initiated in the same period. It is therefore possible that a payment is listed in the report as initiated in one month, and then is listed as confirmed in the following month.

 

Turnover

This report displays the sales per product in combination with the plan variant posted and the respective currency. One line of the report represents a product (Plan Vairant or Component). Products with no revenue are included in the report. The first line summarizes the revenues that cannot be associated to a product. 

The following fields are available:

Designation Description
PlanVariantName The name of the plan variant.
ProductName The name of the product.
PlanVariantExternalId The external ID of the plan variant.
Currency The currency applicable
TotalNet The net total.
TotalGross The gross total.
ThisMonth

the revenue booked in this month
= TotalNet - Total deferred income from this month

DeferredFromThisMonth The deferred income for this month.

 

Turnover forecast

The turnover forecast is structured similarly to the turnover report. billwerk determines the turnover according to the contract data known at the time the report is generated. One line of the report represents one product (Plan Variant or Component). The following fields are available:

Designation Description
PlanVariantName The name of the plan variant.
ProductName The name of the product.
PlanVariantExternalId The external ID of the plan variant.
Currency The currency applicable.
TotalNet The total net.
TotalGross The total gross.

 

 

 

 

 

 

 

Was this article helpful?
1 out of 1 found this helpful