How can I configure custom fields for the financial accounting export?

Follow

In billwerk you can configure additional fields in your financial accounting export to output further useful information. Go to "Settings > Accounting > Export Settings" and first 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 "Outbox" field, a title of your choice in the "Title" field and the desired information in the "Inbox" field. Use the button "Add Field" to add as many custom fields as required and finally click "Save".

accounting7.png

The following options are available: 

Name Description

Customer.Id

Id of the customer

Customer.Name

Name of the customer (Lastname, Firstname or Companyname if available)

Customer.Firstname

Firstname of the customer

Customer.Lastname

Last name of the customer

Customer.CompanyName

Company name of the customer

Customer.ExternalId

External Id of the customer

Customer.DebitorAccount

Debitor account of the customer

Customer.EmailAddress

Email address 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

The tax country

Date DD.MM.YYYY

Posting date in the format DD.MM.YYYY

Invoicing Reason

Possible values: 

  • SignUp - First ever bill in the contract
  • Recurring - recurring bill (not signup)
  • Upgrade - bill triggered by an upgrade
  • InterimBilling - an interim billinng
  • Manual - manual invoice/credit note
  • Cancellation - bill due to cancellation of a contract
PSP Transaction ID

Id of the payment transaction with the payment provider

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

Id of the posting

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. 

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