In billwerk you can configure additional fields in your financial accounting export to output further useful information.
Summary
Add new fields
- Go to Settings > Accounting > Export Settings.
- Select whether the additional fields in the export of
- Datev postings,
- Datev debitors,
- Lexware postings or
- Lexware debitors should be output.
- Then select
- the output column in the Output field
- a title of your choice in the Title field and
- the desired information in the Input field.
- Use the button Add Field to add as many custom fields as required.
- Finally click Save.
Datev and Lexware postings
The following options are available in the Input field:
Name | Description |
---|---|
Customer.Id |
ID of the customer |
Customer.ExternalId |
External ID of the customer |
Customer.DebitorAccount |
Debitor account of the customer |
Customer.DestinationCountry |
Destination country of the customer |
Customer.CustomFields.* |
Content of a custom field of the customer |
VAT Percentage |
Applied tax rate (VAT / Sales Tax) |
Tax Country |
Tax country |
Date DD.MM.YYYY |
Posting date in the format DD.MM.YYYY |
Invoicing Reason |
Possible values:
|
PSP Transaction ID |
ID of the payment transaction with the payment provider |
Transaction ID |
the billwerk transaction ID |
LineItem.Description |
Description of the LineItem |
LineItem.ProductId |
ProductId of the LineItem |
LineItem.PlanVariantId |
ID of the PlanVariant active in the contract |
LineItem.PeriodStart |
Start of the delivery period |
LineItem.PeriodEnd |
End of the delivery period |
Posting.Id |
billwerk ID of the posting |
Posting.SequentialId |
Unique numeric ID for the posting group which only exists for final postings |
IdealPostingDate |
Ideal posting date of a posting (disregarding closed periods) |
Contract.StartDate |
Start date of the contract |
Contract.EndDate |
End date of the contract |
Contract.Contract.* Contract.CustomFields.* |
Content of the custom field of the contract |
PostingGroup.DocumentNumber |
Document number of the invoice / credit note |
If you want to use the LineItem.* fields, you should active the option "Per line item postings" in the Accounts settings.
Datev and Lexware debitors
The following options are available in the Input field:
Name | Description |
---|---|
Customer.Id |
ID of the customer |
Customer.ExternalId |
External ID of the customer |
Customer.DebitorAccount |
Debitor account of the customer |
Customer.DestinationCountry |
Destination country of the customer |
Customer.Name |
Name of the customer (Lastname, Firstname or Companyname if available) |
Customer.Firstname |
First name of the customer |
Customer.Lastname |
Last name of the customer |
Customer.CompanyName | Company name of the customer |
Customer.EmailAddress | Email address of the customer |