Plug-in: Travel costs DE

Travel expense report Germany

Product line

Standard

|

Expert

Operating mode

CLOUD ABO

|

ON-PREMISES

Modules

Services & CRM

Budget & Phases

Purchases

Resource Planning

Business Intelligence

Created: 13.07.2020
Updated: 05.08.2024 | New version with adjusted lump sums published.

For many German employees, it is an integral part of their monthly billing: the digital entering of their travel and catering expenses. For companies, checking and paying employees is a regular and time-consuming task that involves many individual work steps.

This plug-in implements the ability for companies in Germany to enter trips. The resulting travel expenses to be reimbursed are automatically calculated and the corresponding postings are created.

Download and install

Download the plug-in with the following download link and install it in your Vertec. The exact procedure is in the article   Things worth knowing about the plug-ins described.

Version description Download
6.7.0.1

Includes features from version 6.7.

ConfigSet_Travel CostsEN.xml

Requirements

  • The Expert product line is a prerequisite for this plug-in.
  • Additional classes 20 and 21 may not yet be in use.
  • It is a plug-in for Germany.
  • Are there already the   Expense types KM Private and KM company in your system, so they must be assigned an Entry ID before the plug-in is imported. This can be done via Python via argobject.eintragid=”ExpenseTypeKMPRIVAT” or argobject.eintragid=”ExpenseTypeKMFIRMA” on the respective expense type.

Application

Basic settings

Once the plug-in has been imported, the following basic settings for entering trips can be made:

Save destinations

In the root folder Settings > Project > Destination, the destinations and the corresponding meal rates must be defined. Germany, Austria and Switzerland are already predefined. If additional countries or additional rates per country are required, these can be entered here and via Aktiv Checkbox to be activated or deactivated:

Only active destinations appear when entering trips for selection . The currency of the destinations is implicitly the euro, so the amounts are always expressed in euro, regardless of the country concerned.

Adjust expense types

  • In the settings for the expense types KM Private and KM company, enter your own binding amounts.
  • No amounts have to be set for the expense type, these are calculated from the destinations.

Assign users to user groups

Assign the users to the user groups:

  • Users who want to entered their own trips must be assigned to the Travel Expense Recorder user group be assigned .
  • Users who want to define destinations must be assigned to the user group Travel Expenses Supervisors be assigned .

Entering journeys

A new journey will be displayed on the user via right-click or new menu > Reise created by:

The following window will open:

description

Enter the designation of your trip here. The trip display consists of the From date and description.

project

A trip must be assigned to a project.

phase

If there are phases on the project, a phase must be selected here.

From Date / Time

The start date of the trip and the start time are specified here.

To date / time

Here is the end date of the trip and the end time.

Destination

As soon as a project is assigned, the address of the customer is automatically applied, if no address (Vertec address or free text) has been entered. This would not be overwritten even if the project were changed.

If a Vertec address is selected, the Addresstext is applied into the free text. This is especially useful if there are several addresses with the same name but different addresses.

Once a date range is entered, a second page appears where the trip details can be entered:

For each day of travel can be entered,

  • which meals were received free of charge, e.g. breakfast at the hotel
  • how many kilometers were driven on that day with a company or private car
  • whether the overnight stay was in a country other than the destination and in which

On the basis of this information, the flat-rate meal and kilometer allowances are calculated automatically and the corresponding expense documents are created. For the calculation of the flat-rate meal, the Destinations daily rates are relevant. Depending on the destination:

  • Stay <8 h and no arrival/departure day: no boarding fee
  • Stay >=8 h and <24 h or day of arrival/departure: daily rate during the day
  • Stay >= 24 h: full daily rate

These daily rates shall be reduced as follows:

  • Breakfast included: -20%
  • Lunch Received: -40%
  • Receive dinner: -40%

Also on a day of arrival/departure or a day with a stay of <= 24 h, there are deductions for meals received free of charge. However, the deductions are always calculated on the basis of the full daily rate (breakfast is not cheaper because you stay shorter). As a result, the sum of deductions may be higher than the rate to be refunded. In this case, there is 0 euro refund, there are no negative amounts.

The flat rates per kilometer are calculated according to the expense type chosen ( KM Privat or KM Firma ) are created and calculated. If KM company is selected, travel costs are usually not reimbursed because the employee is then traveling in the company car and the company pays the costs directly.

Travel in editor’s currency

The currency of the destinations is always implicitly indicated in euros.

The currency in trip lists and travel pages is always specified in the editor currency. If you place the cursor on an amount, a tooltip will appear:

Enter additional postings

Additional postings can be entered manually in the Travel entry in the Postings subfolder.

When, for example, posts are entered in currencies other than the editor’s currency, a note is shown on the travel page that posts are available in foreign currencies:

Print travel expense statement

On the individual journey, via Print Menu the travel expenses statement shall be created up. All relevant amounts shall be listed and the amount reimbursed to the employee shall be disclosed. Expenditure vouchers printed on it.

How to change a trip in retrospect

A trip can theoretically still be changed, even if expenses have already been charged for the trip. In this case, however, these expenses can no longer be adjusted. There is then a corresponding note on the travel page:

Technical Information

Importing the plug-in creates the following objects:

folder
  • folder Travel on the editor
  • folder Travel in the root folder HR (will be recreated if created not already from the Plug-in: Root folder HR already available)
  • folder Destination in the root folder Setting
User groups
  • User group Travel Expenses Supervisors : Allow the entering of trips and destinations, if access to the Settings folder settings is available.
  • User group Travel expenses Recorder : Allow entering of trips

The users must assign to the appropriate user groups .

Reports & Scripts
  • Report Template: Travel Expense Statement
  • Event: New Spese in Travel
  • Event: Calculate travel expenses
  • Script: customlogic_configSets
Expense types
  • Expense type KM Company
  • Expense type KM Private
  • Expense type Catering
Link types
  • Kilometer packages – Trip to Kilometre package
  • Posts – Journey to Posts
  • User – Travel
  • Meal packages – Travel
Custom field items

A total of 51 Custom field items created.

Custom field items and additional classes

Class settings and page adjustments for the Supplementary Class20 (journey) and Supplementary Class21 (destination).

Bitte wählen Sie Ihren Standort