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)
• Contract Net Turnover
• Invoice
• Open Items
• Payment Overview
• Payment Overview (Extended)
• 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.

 

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.

 

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 Ineffective In this status, the cancellation has no effect due to another triggered process. The contract is inactive on the end date set by the cancellation. The inactive contract phase created by this cancellation no longer exists, but has been replaced by another inactive phase. This can be done by a contract cancellation or another cancellation with an earlier end date. Withdrawn In this status, the cancellation has no effect because another process has been triggered. The contract is active on the end date specified by this cancellation. The inactive contract phase created by the cancellation no longer exists, but has been replaced by an active phase. This may be due to a contract upgrade. Cancelled The contract has been cancelled and is still active. The cancellation date is in the future. Ended The contract has been cancelled and has already ended. The cancellation date is in the past.
WonBack	Specifies whether the contract is active at the time of cancellation or at any time afterwards. true The contract is in the active phase. false The contract is in the inactive phase.

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. true The contract is paused. false The contract is not 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. PaymentEscalation The contract was paused due to the settings in the payment escalation. Manual The contract was paused manually in the contract details.
ContractPaused	Indicates whether the contract is paused. true The contract is paused. false The contract is not 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. true The contract is paused. false The contract is not 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.

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 Signup Recurring Manual
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 PlanVariant Component RatedItem
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 False True
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.

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	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.

 

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 Signup Recurring Manual Up-/Downgrade Cancellation
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. Handling fees are not output if they are not assigned to an invoice. Currently, we only support the chargeback fee type handling fee.

* - 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 balance is 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.
ThisMonth	The revenue booked in this interval = TotalNet - Total deferred income from this interval
DeferredFromThisMonth	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.