Which reports are available?
The following reports can be generated and downloaded as a file in CSV or JSON format.
General Reports
Active Products
Aggregate Contract Phase Change
Cancellations
Component Subscriptions
Contract Churn Overview
Contract Pause
Contract Phase Change
Contracts
Discount Subscriptions
Order
Accounting and Controlling
Accounts Receivable Ageing Report
Aggregate Accounting
Debtor Balances
Deferred Invoices
Dunning Overview
Line Items
Monthly Recurring Revenue
OSS (Elster)
MOSS (Extended)
Invoice
Open Items
Payment Overview
Payment Overview (Extended)
Turnover
Turnover Forecast
Note
Note: These reports depend on accounting exports and monthly closing. We recommend to read the following articles for more background information:
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
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 amount of subscriptions for a particular product. |
Quantity | The quantity of phases, components or metered usages for a particular product. |
New | The amount of subscriptions for a particular product where subscription starts during the report period. |
Note
Note on the use of the Exported by / Export period filter
This report is designed so that contracts whose end date is in the future are not considered. Therefore, only entries whose creation date is before the export date will be included in the report. This is the case both for the Month selection and for an individual period.
Example:
Today's date is 01.09.
The selected dates for the individual period are 01.08. - 01.10.
The report contains only data from 01.08. - 01.09.
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 plan of the new contract phase. |
Count | Number of contracts affected by this type of change in the reporting period. |
Cancellations
This report outputs a list of all contract cancellations, even if the contract cancellation was afterwards undone by upgrades.
The CancellationStatus column provides information about the status of the specific cancellation. The WonBack column provides information on whether the contract was ever reactivated after the set end date.
Designation | Description |
CancellationDateUtc | Cancellation date in UTC |
CancellationDateLocal | Cancellation date in CET |
EndDateUtc | End date of the contract in UTC |
EndDateLocal | End date of the contract in CET |
ContractId | Contract-Id |
ReferenceCode | Contract reference code |
CustomerId | Customer-Id |
ExternalCustomerId | External Id of the customer |
OldPlanVariantId | Id of the plan variant of the previous contract phase |
OldPlanId | Id of the plan of the previous contract phase |
CancellationStatus | Cancellation status
|
WonBack | Specifies whether the contract is active at the time of cancellation or at any time afterwards.
|
Examples
A contract was canceled in November 2021 with an end date of 12/01/2021 and later reactivated by an upgrade on 01/01/2022. In this case, the cancellation has the CancellationStatus Ended and the WonBack status true.
A contract canceled in November 2021 with an end date of 12/01/2021 has been reactivated by an upgrade on 12/01/2021. In this case, the cancellation has the CancellationStatus Withdrawn and the WonBack status true.
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 locale 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. |
ContractPaused | Indicates whether the contract is paused.
|
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 changed 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.
Contract Pause
This report shows you a list of all contracts with pause phases and related details to the pauses.
Designation | Description |
CustomerId | Technical ID of the customer |
ContractId | Technical ID of the contract |
ContractPauseStartDateUtc | Start date of the contract pause in UTC |
ContractPauseStartDateLocal | Start date of the contract pause in CET |
ContractPauseEndDateUtc | End date of the contract pause in UTC |
ContractPauseEndDateLocal | End date of the contract pause in CET |
ContractPausedBy | Indicates who paused the contract.
|
ContractPaused | Indicates whether the contract is paused.
|
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 locale 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. |
ContractPaused | Indicates whether the contract is paused.
|
ContractPauseStartDateUtc | Start date of the contract pause in UTC |
ContractPauseStartDateLocal | Start date of the contract pause in CET |
ContractPauseEndDateUtc | End date of the contract pause in UTC |
ContractPauseEndDateLocal | End date of the contract pause in CET |
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 coupon used. |
CouponCode | The coupon 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 the contract, the discount subscription applies to. |
DiscoutInternalName | The internal name of the discount. |
CouponInternalName | The internal name of the coupon. |
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. |
Order
The Order report provides you with a detailed breakdown of orders. One line of the report represents one order. The Order report can be generated for a customized date range.
Note
Note: In order to generate this report, your user rights in billwerk need to be set to Administrator, Finance or Report. You can learn more about user rights and roles in this article.
The following fields are available:
Designation | Description |
FirstName | First name of the customer |
LastName | Surname of the customer |
CompanyName | Company name of the customer |
Email Address | Email address of the customer |
Street | Street of the customer's address |
AddressLine1 | First line of customer’s (postal) address |
AddressLine2 | Second line of customer’s (postal) address |
ZipCode | Zip code of the customer's address |
City | City of the customer's address |
Country | Country of the customer's address |
PhoneNumber | Phone number of the customer |
PlanId* | Id of the plan |
ProductName* | Name of the product (plan) |
PlanVariantId* | Id of the plan variant |
PlanVariantName* | Name of the plan variant |
Type | Type of the order (signup or upgrade) |
Amount | Amount of the order |
Currency | Currency of the order |
PSP** | Name of the payment service provider (PSP) |
PaymentMethod** | Payment method |
Status | Status of the order (in progress, payment pending, aborted, completed, failed, expired, approval pending, approved, declined or incomplete) |
ContractId | Id of the contract |
* fields can be empty if the order refers to an upgrade order which does not change the plan
** fields can be empty if the PSP or Payment method are not configured
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 amount of days the receivable is overdue for. |
DueDate | Due date of the receivable. |
Amount | Amount overdue. |
County | The quantity of overdue receivables. |
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 reporting period. 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, calculated 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. |
Type | Currently always "revenue". |
Debtor Balances
The Debtor 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 payments, credits balances and refunds. |
ReceivablesInPeriod | The amount due in the reporting period. Attention: this can partially 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 invoice 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. |
Line Items
This report lists all the line items of the invoices in the export period. One line of the report represents one line item of an invoice.
Designation | Description |
InvoiceId | Invoice Id |
InvoiceNumber | Invoice number |
InvoiceDocumentDate | Invoice date |
InvoiceDueDate | Due date of the invoice |
InvoiceCurrency | Currency |
InvoicingReason | Reason for invoicing
|
CustomerId | Customer Id |
RecipientVatId | Customer VAT ID |
RecipientName | Name of the customer |
ExternalCustomerId | External Id of the customer |
CustomerDebitorAccount | Debtor Id of the customer |
ContractId | Contract Id |
ContractReference | Contract reference code |
ContractExternalId | External Id of the contract |
ProductId | Product Id |
ProductExternalId | External product Id |
ProductType | Product type
|
ProductName | Product name |
LineItemId | Id of the line item |
LineItemQuantity | Quantity of the line item |
LineItemUnitPrice | Unit price of the line item |
LineItemNetPrice | Net price of the line item |
LineItemVatPercentage | VAT percentage of the line item |
LineItemGrossPrice | Gross price of the line item |
LineItemPeriodStart | Start of the period |
LineItemPeriodEnd | End of the period |
IsDiscount | Specification of whether the line item is a discount
|
ReductionPercentage | Percentage of discount as decimal number |
Monthly Recurring Revenue
Montly Recurring Revenue (MRR) is a report that outputs the recurring revenue per contract based on the dashboard MRR-KPI. It includes active discounts and metered usage is not taken into the account. MRR allows you to track individual customers to analyze their performance.
Note
Note:
If the period is longer than 1 month, the revenue is divided across each month of the delivery period,
Either Gross or Net value is filled for each line.
The following fields are available:
Designation | Description |
InvoiceId | The invoice Id |
InvoiceNumber | The invoice number |
DebitorAccount | The debitor ID of the customer. |
CustomerName | The aggregate name* of the customer. |
ContractId | The contract Id |
ReferenceCode | The contract reference code. |
ContractStartDateUtc | The start date of the contract in UTC. |
ContractEndDateUtc | The end date of the contract in UTC. |
Country | The country of the customer's address. |
PaymentProvider | The name of the payment service provider (PSP). |
Gross | The total gross revenue. |
Net | The total net revenue. |
Month | The applicable month. |
* - the aggregate name is the company name, if the company name is empty, the given name and surname are displayed.
OSS (Elster)
One-Stop-Shop (OSS) is a special scheme for VAT. The aim is to simplify the cross-border VAT compensation for services consumed in foreign countries within the EU internal market.
billwerk supports this regulation and offers an OSS report for download. The OSS (elster) report is generated in the format defined by the German tax authorities and the MOSS (extended) report contains additional information in a format defined by billwerk.
The prerequisite for the OSS reports to contain sales is that the option Is OSS applicable has been activated in the tax policy used.
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 | |
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. |
Invoice
This report lists all invoices in the specified time period.
One line of the report corresponds to one invoice.
Designation | Description |
InvoiceId | Invoice Id |
InvoiceNumber | Invoice number |
InvoiceDate | Invoice date |
StartDeliveryPeriodUtc | Beginning of the service period in UTC |
EndDeliveryPeriodUtc | End of the service period in UTC |
InvoiceDueDate | Due date of the invoice |
InvoicingReason | Reason for invoicing
|
CorrectedInvoiceId | Id of the correction invoice |
InvoiceCurrency | Currency |
Total Net | Net amount |
Total Gross | Gross amount |
CustomerId | Id of the customer |
VatID | VAT ID of the customer |
RecipientName | Name of the customer |
ExternalCustomerId | External Id of the customer |
CustomerDebitorAccount | Debtor Id of the customer |
ContractId | Id of the contract |
ContractReferenceCode | Contract reference code |
ContractExternalId | External Id of the contract |
ContractStartDateUtc | Start date of the contract in UTC |
Open Items
This report displays a list of all open items - unpaid invoices with either a pending amount or an amount completely unpaid. The open item report is generated on a key date and contains all open items until the key date including the key date.
The Open Items report is structured as follows:
If an invoice number is provided for a ledger entry, the ledger entry is displayed as a separate line in the report containing the invoice number in the Invoice Number column. This means our system has determined that the invoice mentioned is still open (unpaid).
If there is no invoice number, ledger entries get aggregated within one contract. As a result, they are displayed as one line in the report without an invoice number in the Invoice Number column. This line refers to all open positions in the contract that have not been assigned to an invoice number.
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. |
Country | The country 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. This value is based on the ContractBalanceConfirmed, it only takes into account confirmed payment transactions. |
AmountPaid | The amount paid of the open item. This value is based on the ContractBalanceConfirmed, it only takes into account confirmed payment transactions. |
AmountUnpaid | The amount unpaid of the open item. This value is based on the ContractBalanceConfirmed, it only takes into account confirmed payment transactions. |
AmountPending | The amount of pending payments. If the value is negative or null, it represents an unconfirmed payment with a confirmed chargeback. |
ContractId | The technical ID of the contract. |
ContractBalanceConfirmed | Balance of the contract ledger including only confirmed payment transactions. |
ContractBalanceUnconfirmed | Balance of the contract ledger including confirmed and unconfirmed payment transactions. |
AmountWrittenOff | Amount written off |
AmountHandlingFee | Total of handling fees as indicated on the invoice. Note
|
* - the aggregate name is the company name, if the company name is empty, the given name and surname are displayed.
You can set different filters for this report so you have only receivables (AmountUnpaid > 0) or payables (AmountUnpaid < 0) given as a result. If you don't set any filters, both receivables and payables will be shown in this report.
More information about Contract Balance (Un)Confirmed
The amounts applies to the contract balance as a whole, not to a particular document.
Please be aware
(1) that if several invoices are still open, the same (un)confirmed contract balanceis repeated for each invoice. In this case the report lines should not be summed up to reflect the balance of the contract.
(2) these two columns deliver different values for the same contract at the same time. It depends on which values you need:
Payments that already arrived on your bank account can be seen in the confirmed column.
The amount for the open receivables shown in the unconfirmed column can be smaller than expected due to payment transaction errors, like credit card expirations that are taken into account by the measure in the report.
Important : Having both columns displaying the same numbers is not necessarily a good sign. It could be that you received a chargeback and thus the automated billing has been switched off.
Payment Overview
The Payment Overview report 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. In case no payment data for a particular payment type is provided, the row is not displayed.
The following fields are available:
Designation | Description |
PaymentProviderRole | The mean of payment. |
PaymentProvider | 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 and/or chargebacks) |
TriggeredCount | The quantity of all triggered payment transactions. |
ConfirmedSum | The sum over the amount of payment of all confirmed payment transactions. (confirmed payments - confirmed refunds and/or chargebacks) |
ConfirmedCount | The quantity of all confirmed payment transactions. |
BookedSum | The sum over the amount of payment of all confirmed payment transactions with the timestamps of the booking. |
BookedCount | The quantity of all confirmed payment transactions with the timestamps of the booking. |
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.
Payment Overview (Extended)
The Payment Overview report lists all payments made for each payment service provider, mean of payment and currency with additional details about the payment types.
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. In case no payment data for a particular payment type is provided, the row is not displayed. If it is not possible for the output to have a value, an empty string is provided.
The following fields are available:
Designation | Description |
PaymentType | The type of payment (payment, refund, chargeback or cancellation). |
PaymentProviderRole | The mean of payment. |
PaymentProvider | 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 and/or chargebacks) |
TriggeredCount | The quantity of all triggered payment transactions. |
ConfirmedSum | The sum over the amount of payment of all confirmed payment transactions. (confirmed payments - confirmed refunds and/or chargebacks) |
ConfirmedCount | The quantity of all confirmed payment transactions. |
BookedSum | The sum over the amount of payment of all confirmed payment transactions with the timestamps of the booking. |
BookedCount | The quantity of all confirmed payment transactions with the timestamps of the booking. |
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 Variant 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 report is based on the current invoices in the selected period. Resolved deferrals are not included in the report. If you need a report with the resolved deferrals, use the aggregated accounting export.
The following fields are available:
Designation | Description |
PlanVariantName | The name of the plan variant. |
ProductName | The name of the product. |
ProductID | The ID of the product. |
ProductExternalId | This ID can represent either a plan variant or a component. |
PlanVariantExternalId | The external ID of the plan variant. |
Currency | The currency applicable. |
TotalNet | The net total. |
TotalGross | The gross total. |
ThisPeriod | The revenue booked in this interval = TotalNet - Total deferred income from this interval |
DeferredFromThisPeriod | The deferred income for this interval. |
ResolvedDeferrals | The sum of Resolve Deferral Postings in the reporting interval |
RecognizedRevenue | = TotalNet - DeferredFromThisMonth + ResolvedDeferrals |
Turnover Forecast
The Turnover Forecast report is structured similarly to the Turnover report. billwerk determines the turnover according to the contract data known at the time the report is generated.
The invoice date is decisive for the month in which the turnover is taken into account. If you place an order with a future start date in billwerk, the first invoice will be created immediately. If an order is placed in September for October, then the first invoice will be created in September. The first invoice is then included in the turnover for September.
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 report generated for past periods will be identical to the Turnover report.
If you generate the Turnover Forecast report 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.