lexoffice Auto-Export Module


lexoffice offers a range of bookkeeping and payroll services designed to meet the needs of many different small to medium size businesses. From simple one off final accounts and self assessments to more complex online packages maintained weekly, monthly or quarterly.
HostBill integration allows to export invoices from HostBill to lexoffice - as lexoffice Invoices or as Vouchers. Invoices can be exported either manually or automatically as soon as the invoice is generated or when the invoice is paid in full. lexoffice-generated PDF documents can be automatically downloaded and replace HostBill-generated PDF for invoice in admin and client UI. The module also enables to customize invoices: add customer salutation and introductory text on invoice, as well as configure tax types and rules and credit settings.

Activating the module

  1. If the plugin is included in your HostBill edition you can download it from your client portal.
  2. If the plugin is not included in your HostBill edition you can purchase it from our marketplace and then download it from the client area.
  3. Once you download the plugin extract it in the main HostBill directory.
  4. Go to Settings → Modules, find and activate lexoffice plugin.
  5. Once the plugin is activated you will be directed to Settings→ Modules→ Plugins to configure the plugin.

Module configuration

Due to lexoffice's multiple configuration/operation modes module exposes following configuration options:

  1. Auto-export invoices - select whether invoices from HostBill should be auto-exported to lexoffice upon generation:
    1. Off - invoices can be exported manually in invoice details page and bulk export page
    2. On, all invoices - as soon invoice is generated
    3. On, only paid invoices - as soon invoice is paid in full
  2. Manually-export invoices - select whether invoices from HostBill should be exported to lexoffice by pressing 'Export to lexoffice' button on invoice page
    1. Off
    2. On, all invoices
    3. On, only paid invoices
  3. API Key - Your API key obtained in lexoffice panel (details on how to obtain below)
  4. Sandbox mode - When enabled sandbox API endpoints will be used instead of production ones
  5. API Endpoint - Select how invoices from HostBill should be exported to lexoffice
    1. Invoices endpoint - should invoice from HostBill be exported as invoice to lexoffice
    2. Vouchers endpoint - invoices from HostBill will be exported as vouchers

Invoices API endpoint requires additional configuration options:

  1. Use invoice from lexoffice as PDF When enabled PDF generated in lexoffice will replace HostBill-generated PDF for invoice in admin and client UI
  2. Your business country - Select your business country, used to determine vat exemption
  3. IntraCommunity tax type - Select what tax type should be applied to invoice for IntraCommunity services
    1. externalService13b
    2. intraCommunitySupply
  4. Default unit name - Example: Stück
  5. Introductory text on invoice - Show introduction text on the lexoffice invoice: eg. Invoice #
  6. Export credit as Payment Conditions note - The invoice credit will be added to the lexoffice invoice to the payment conditions section
  7. Customer Company VAT field key - Key of the customer field with VAT ID. Example: vateu
  8. Customer salutation - Possible values: Herr, Frau

Vouchers API endpoint requires additional configuration option:

  1. Category ID for vouchers - Select what category should be applied for voucher items

Obtaining API credentials from lexoffice

First of all you must have an active lexoffice account.

Log in to your lexoffice developer account. 

To use the lexoffice service you must obtain API key:

  1. Go to the page Erweiterungen
  2. Click on the Mehr erfahren button in lexoffice Public API section
  3. Next click on the Schlüssel jetzt erstellen button
  4. Copy the API key and enter it in the appropriate field in the module's configuration

Using the module

After installing the module, an additional page in the Payments menu will be available on which you can manually export invoices to lexoffice.

In addition, a new button will be added to the invoice page with which you can view the export status of the invoice or export this invoice if it has not been exported yet.