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)
- Net Turnover (contract based)
- 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. |
| Count | Number of contracts affected by this type of change in the reporting period. |
Component Subscriptions
This report provides a list of all contracts with component subscriptions (on/off and quantity based components). 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.
Remark:
To analyse the total amount of ending contracts in a reporting period per product you can use the TotalChurns value.
Hinweis:
Um zu ermitteln wie viele Verträge absolut pro Produkt in einem Zeitraum beendet wurden können Sie die Spalte TotalChurns analysieren.
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. |
| CreditCardType | Type of credit card |
| CreditCardExpiryMonth | Expiry month |
| CreditCardExpiryYear | Expiry year |
| CreditCardHolder | holder of the credit card |
| PaypalEmailAddress | email address of Paypal account |
| 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
The Deferred Invoices report is created for a reporting period.
This report shows all invoices and credit notes for which accruals and deferrals (PRAPs) are released during the reporting period or for which PRAPs continue to exist after the end of the reporting period. PRAPs that were already reversed before the beginning of the reporting period and services for which no PRAPs were created are not included in the report.
One line of the report represents one invoice or credit note. 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 in the reporting period. |
| SumNotResolvedAccDeferredIncome | The sum of the existing deferred income positions after the end of the reporting period. |
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 | |
| 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. (triggered payments - triggered refunds / chargebacks) |
| TriggeredCount | The quantity of all triggered payment transcations. |
| ConfirmedSum | The sum over the amount of payment of all confirmed payment transcations. (confirmed payments - confirmed refunds / chargebacks) |
| 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 |
| 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, a Plan Variant or a Component (on/off or quantity based). 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. |
If you generate the report for an entire year, this report will be the sum of all monthly reports this year.
The Turnover forecast for past periods will be identical to the Turnover report.
If you generate the Turnover forecast in the current year for the entire year, all past months will be considered with the actual Turnover, the current and future months are considered based on the Forecast.