Wiki source code of Spesen

Last modified by YellowFox_RD on 2025/12/09 14:10

Hide last authors
YellowFox_RD 1.1 1 (% class="box" %)
Dominic Lippmann 7.1 2 (((
YellowFox_RD 13.1 3 Table of Contents
Dominic Lippmann 7.1 4 )))
5
YellowFox_RD 1.1 6 {{toc/}}
7
YellowFox_RD 13.1 8 This modul uses position data of the cars to determine expenses for your employees.
Dominic Lippmann 7.1 9
YellowFox_RD 13.1 10 = Common =
Dominic Lippmann 7.1 11
YellowFox_RD 13.1 12 Expenses will be payed if an employee must work outside of his working place. Also he cannot be at his principal residence. This time calls absence. The legislator published on yearly base lists with legal costs rates for each country. These rates are the basis of expenses calculation. For calculation are needed information about first working place or the principal residence for each employee.
13 Expenses are divided in:
YellowFox_RD 12.2 14
YellowFox_RD 1.1 15 (((
YellowFox_RD 13.1 16 1. Absence over 8 hours (arrival and departure)
17 1. Absence of 24 hours
18 1. over night
YellowFox_RD 1.1 19 )))
Dominic Lippmann 7.1 20
YellowFox_RD 13.1 21 Expenses will be calculated according German law for companies which are located in Germany. The calculation runs over night and it calculates expenses until day before yesterday.
Dominic Lippmann 7.1 22
YellowFox_RD 13.1 23 = Configuration =
YellowFox_RD 12.2 24
YellowFox_RD 13.1 25 You have to assign a first wrking place and a principal residence for your personnel to get calculated expenses automatically. In addition you can define further working places to interrupt absence. Create and provide of working place will be explained in chapter 'working places'. You have to edit personnel data to activate expenses. Click on 'Activate expenses calculation for this person'. Choose an already defined working place and assign a validation. Expenses will be calculated from now on.
26 There is a possibility to assign working place for several employees in one step. Check these employees under personnel. An assistant will pop up by clicking on this symbol [[image:travel_costs_location.png]] to assign working places.
YellowFox_RD 12.2 27
YellowFox_RD 13.1 28 = Expenses editor =
YellowFox_RD 12.2 29
YellowFox_RD 13.1 30 After selection of a driver and a time period  expenses will be shown in a table. Each row contains expenses for a day. Days without expenses will be shown gray.
31 This table shows the follow:
YellowFox_RD 12.2 32
YellowFox_RD 1.1 33 (((
YellowFox_RD 13.1 34 * day of expensesstart and end of longest absences period of this day
35 * duration of absence
36 * cars which were used in this period
37 * expenses region, by click on this symbol [[image:border16.png]] it opens an overview with border crossings of this day
38 * expenses for meals and accommodation
39 * proportionally taxation rates  (tax free, tax flat rate and taxable) of expenses for meals
40 * calculation base by settings
41 * field for comments
YellowFox_RD 1.1 42 )))
Dominic Lippmann 7.1 43
YellowFox_RD 13.1 44 Entries with *1 have a period which could be used for expenses. Hover shows detail information for this period.
45 Entries with *2 have an expenses day but no vehicle was used.
46 Entries with *3 means the tax data include a pro rata calendar month.
47 Entries with *4 means the calculation and output of tax data is a new function and is only supported for data from 01.01.2023.
Dominic Lippmann 7.1 48
YellowFox_RD 13.1 49 == Actions ==
Dominic Lippmann 7.1 50
YellowFox_RD 13.1 51 |=Icon|=Action
52 |[[image:edit.png]]|Manual edit of this expense entry
53 |[[image:cross.png]]|Delete this entry
54 |[[image:map_16.png]]|Daily based presentation of driven route. Blue parts are related to expenses.
55 |[[image:info.png]]|Shows manually changes of this entry
56 |[[image:info.png]]|List absence times
57 |+|Add absence (in terms of absence management).
YellowFox_RD 1.1 58
YellowFox_RD 13.1 59 == Edit entry ==
Dominic Lippmann 7.1 60
YellowFox_RD 13.1 61 Manually changes can be made with inline editor. There can be added comments to the comment field. The type of absence determines the legal standard amount according to the selected country or region. Table will be updated after saving this entry.
YellowFox_RD 1.1 62
YellowFox_RD 13.1 63 = Export of expenses =
Dominic Lippmann 7.1 64
YellowFox_RD 13.1 65 It can be exported the current view from expenses editor as PDF, Excel or CSV. The report center gives you possiblity to generate series and export them as HTML, PDF, Excel or CSV.
66 A generated report contains a conclusion of costs divided in total costs, meal and accommodation for the selected period. Furthermore you will get a list of all days with expenses. Over a checkbox you can additional show taxation values.
Dominic Lippmann 3.1 67
YellowFox_RD 13.1 68 = Legal Regulations for Germany =
Dominic Lippmann 7.1 69
YellowFox_RD 13.1 70 == Types of Absences ==
Dominic Lippmann 7.1 71
YellowFox_RD 13.1 72 |=Rule|=Explanation
73 |**Absence**|The employer assigns a task to the employee, which requires them to leave their primary workplace and not stay at their private residence.
74 |**Full Expense Rate (24-Hour Absences)**|Paid when the absence is 24 hours.
75 |**Reduced Expense Rate (> 8 hours or Arrival/Departure)**|Paid when the absence exceeds 8 hours or during travel days (arrival/departure), regardless of absence duration.
76 |**Midnight Rule**|When an out-of-office task spans midnight and lasts a maximum of 16 hours, the absence is assigned to the calendar day with the predominant absence period.
YellowFox_RD 1.1 77
YellowFox_RD 13.1 78 == Tax Information ==
Dominic Lippmann 7.1 79
YellowFox_RD 13.1 80 The **legal expenses** are **tax-free**. For example, if an employee receives €14 for an absence of over 8 hours, neither the employee nor the employer is required to pay taxes on this amount.
81 However, if the company's expense rates exceed the legal rates, the excess is subject to taxation. For additional subsistence allowances up to twice the tax-free rate, a 25% flat tax applies. Anything exceeding this is **fully taxable**.
Dominic Lippmann 7.1 82
YellowFox_RD 13.1 83 === Total Reimbursement Procedure ===
Dominic Lippmann 3.1 84
YellowFox_RD 13.1 85 Expenses are typically evaluated monthly, and the tax implications depend on the total expenses reimbursed over the period. Legal flat rates are compared to individual company rates, and any excess beyond the total legal allowance is taxable.
86 Example:
Dominic Lippmann 7.1 87
YellowFox_RD 13.1 88 |=Day|=Expense|=Tax-free|=Max tax-free|=25% taxed|=Taxable
89 |**Day 1 - Travel**|€30.00|€14.00|€14.00|€14.00|€2.00
90 |**Day 2 - 24h**|€30.00|€28.00|€28.00|€2.00|€0.00
91 |**Day 3 - Return**|€30.00|€14.00|€14.00|€14.00|€0.00
92 |**Day 4 (< 8h)**|€30.00|€0.00|€0.00|€0.00|€30.00
93 |**SUM**|€120.00|€56.00|€56.00|€34.00|€30.00
Dominic Lippmann 7.1 94
YellowFox_RD 13.1 95 = Working places =
YellowFox_RD 11.1 96
YellowFox_RD 13.1 97 Under this point you can create and manage workplaces. When creating a new working place, you can give it a suitable name.
98 Furthermore, the following options are available:
YellowFox_RD 11.1 99
YellowFox_RD 13.1 100 |=option|=description
101 |Radius|Defines the size of the sphere of this working place.
102 |Interruption of absence|immediately, 30 minutes, 1 hour… 
103 Determines how long the vehicle may stay in the workplace without interrupting the absence in terms of expenses.
104 |Type of working place|Type of working place is determined. ( principal residence, first working place, further working place )
Dominic Lippmann 3.1 105
YellowFox_RD 13.1 106 Working places can be edited at any time. Changes will be applyied immediately. There is a history where you can see your changes.
107 On page "map" are shown all working places with their defined radius.
108 Working places can be assigned to a single driver or several drivers on page "assigments". Assigments can be done at personnel tab as well. There you choose a working place from a select box and set a validation. Principal residence can be created there as well.
Dominic Lippmann 7.1 109
YellowFox_RD 13.1 110 **Assignment:**
Dominic Lippmann 7.1 111
YellowFox_RD 13.1 112 An assignment to a work location cannot take effect before the date on which that location was created. For example, if a work location is created on January 1, 2025, a driver cannot be assigned to it at any earlier date.
113 If the work location is modified again on February 1, 2025, the driver can still be assigned retroactively back to January 1, 2025.
YellowFox_RD 1.1 114
YellowFox_RD 13.1 115 However, a retroactive assignment may not exceed three months from the respective first day of the month. This means that on December 1, 2025, a driver can be assigned to a work location no earlier than September 1, 2025.
YellowFox_RD 11.3 116
YellowFox_RD 13.1 117 == Default Values for New Work Locations ==
YellowFox_RD 11.3 118
YellowFox_RD 13.1 119 In the settings of the expense module, you can define values under "Work Locations" that will be assigned as default values when creating new work locations.
YellowFox_RD 1.1 120
YellowFox_RD 13.1 121 |=Setting|=Description
122 |**Default Value for the Radius of a Work Location**|The radius of a work location determines the area around the specified position where an interruption of absence, in terms of expenses, takes place. If the vehicle enters or passes through this area, the expense time will be interrupted. The longest absence period of a day is evaluated.
123 |**Interruption of Absence After**|A maximum stay duration can be defined for a work location. During this time, a vehicle can remain within the respective work location without the absence time, in terms of expenses, being interrupted. Each time the work location is entered, the full interruption time is available again
YellowFox_RD 11.2 124
YellowFox_RD 13.1 125 = Expense Profiles =
YellowFox_RD 11.2 126
YellowFox_RD 13.1 127 == Overview ==
YellowFox_RD 11.2 128
YellowFox_RD 13.1 129 In the Expense module, you will find the tab **Expense Profiles** under Settings. This section provides an overview of all existing profiles.
Dominic Lippmann 7.1 130
YellowFox_RD 13.1 131 === The following profile is always available: ===
Dominic Lippmann 7.1 132
YellowFox_RD 13.1 133 ==== **Profile "§ gesetzliches Standardprofil"** ====
Dominic Lippmann 3.1 134
YellowFox_RD 13.1 135 This profile contains all the statutory regulations and cannot be modified.
136 Customers who previously had company-wide settings will receive an additional profile:
Dominic Lippmann 3.1 137
YellowFox_RD 13.1 138 ==== **Profile "individuelle Regelungen"** ====
Dominic Lippmann 7.1 139
YellowFox_RD 13.1 140 All previous settings have been transferred to this profile.
141 All drivers in your company have been assigned to this profile.
142 If you wish to continue using only this single expense profile, no further action is required.
Dominic Lippmann 7.1 143
YellowFox_RD 13.1 144 == Actions ==
Dominic Lippmann 3.1 145
YellowFox_RD 13.1 146 Using the action menu, you can perform the following options for the profile:
Dominic Lippmann 7.1 147
Dominic Lippmann 3.1 148 (((
YellowFox_RD 13.1 149 * **Edit**: Opens a dialog to modify a specific expense profile -> see //Create/Edit Expense Profile//.
150 * **Assign Employees**: Provides a direct way to assign a profile to multiple people simultaneously. Alternatively, expense profiles can also be assigned to an individual via personnel management.
151 * **View Profile Details**: Opens a view displaying the latest applicable regulations and a history of the expense rates.
152 * **Delete**: The profile is deactivated. When deleting a profile, all current employee assignments will end on the day before deletion. From the day of deletion onward, these assignments will automatically be reallocated to the "§ Legal Standard Profile."
153 * **Create New Profile**: Opens a dialog to create a new expense profile -> see //Create/Edit Profile//.
Dominic Lippmann 3.1 154 )))
Dominic Lippmann 7.1 155
YellowFox_RD 13.1 156 == Creating/Editing an Expense Profile ==
Dominic Lippmann 7.1 157
YellowFox_RD 13.1 158 If you would like to create additional profiles, this can be done in the **Expense Profiles** tab by clicking on the **Create New Profile** button.
159 During the process, you can:
Dominic Lippmann 3.1 160
161 (((
YellowFox_RD 13.1 162 * Define **rules** for evaluating absences.
163 * Specify your **expense rates** using the selection fields: percentage, fixed amount, or country adjustments. If you wish to define additional country-specific rates, this can be done in the **"Country Rates"** tab.
Dominic Lippmann 3.1 164 )))
165
YellowFox_RD 13.1 166 When editing a profile, you can define the **effective date** for the changes. Retroactive adjustments can be applied up to three months back, always starting on the 1st of the month. Any expenses already calculated for individuals currently assigned to this profile will be deleted, and a recalculation will occur promptly.
Dominic Lippmann 7.1 167
YellowFox_RD 13.1 168 === Regulations ===
Dominic Lippmann 3.1 169
YellowFox_RD 13.1 170 Expenses settings are in settings of this module.
Dominic Lippmann 3.1 171
YellowFox_RD 13.1 172 |=rule|=description
173 |For one-day trips abroad, which start and end in a place of work, should be the expense|If the employee travels abroad from one country to another within one day and back home again, the employer can always refund the lump sum for the non-resident state in which your employee last stopped. With this setting, you can specify whether the lump sum for the last foreign state or the rate of compensation of the place of work is used for the calculation.
174 |Recognition start expense relevant period|The absence in the sense of the expenses begins with the leaving of the area of the place of work and ends with the driving of this area.   The user can choose between the following two modes:(((
175 1. By ignition and standstill
176 In this mode, the time of absence begins and ends with the ignition signal or upon detection of a vehicle stall. This setting may be useful during loading operations within a site with the ignition on. This is the case, for example, if the vehicle has a mobile crane.
177 1. By ignition
178 The period of absence begins when the ignition is switched on within the workplace and ends with the ignition being switched off after driving in this area.
YellowFox_RD 1.1 179 )))
YellowFox_RD 13.1 180 |Trip assignment|In order to identify which trips are counted for the driver, the user can choose between the following two modes:(((
181 1. Exact trip assignment: With exact trip allocation, only those parts of the trip for which the driver was registered are assigned to the driver.
182 1. Tolerant trip assignment: With tolerant trip assignment, the entire trip is assigned to the driver even if the driver logs in late or logs out early.
YellowFox_RD 1.1 183 )))
YellowFox_RD 13.1 184 |Adding up multiple absence periods for single-day external activity.|An absence period begins when leaving the workplace and ends upon re-entering the location.
185 Multiple absence periods related to a single-day business trip can be handled as follows:(((
186 * Absence periods should be aggregated, as permitted by the BMF directive.(((
187 * Several absence periods within a day are summed up and included in the expense calculation.
188 * For overnight trips (crossing midnight), there is a special rule: portions can be split and allocated to individual calendar days.
189 * In an optimal calculation check, YellowFox determines which allocation is more expense-relevant. Typically, overnight trips are taken into account unless the absence periods for a single calendar day more frequently fall below the legal flat-rate amount for a single-day absence.
190 * If an optimal calculation check is pending for a certain period, this will be indicated in the expense editor.
YellowFox_RD 1.1 191 )))
192
YellowFox_RD 13.1 193 * Only the longest absence period is considered as the relevant business activity.
YellowFox_RD 1.1 194 )))
YellowFox_RD 13.1 195 |Midnight Regulation|The midnight rule applies when an absence spans overnight and lasts a maximum of 16 hours.
196 Two modes can be chosen for evaluating an overnight absence:(((
197 * According to the legal evaluation, where the absence is split across 2 calendar days (in accordance with §9 Abs.4a Nr.3 EStG),
198 * Or the absence falls within the time frame between 4:00 PM and 8:00 AM the following day.
YellowFox_RD 1.1 199 )))
Dominic Lippmann 3.1 200
YellowFox_RD 13.1 201 === **Set Expense Rates** ===
Dominic Lippmann 7.1 202
YellowFox_RD 13.1 203 In the "Customization of Expense Rates" section, you can define individual expense rates based on:
Dominic Lippmann 7.1 204
Dominic Lippmann 3.1 205 (((
YellowFox_RD 13.1 206 * **Percentage**: The monetary values are based on a percentage of the statutory flat rates. For example, if "more than 8 hours of absence" is set to 50%, this absence is recorded with €7 for Germany (as of 2025).
207 * **Fixed Amount**: The monetary values for absences over 8 hours, 24-hour absences, and overnight stays can be set as fixed amounts and made uniform for all countries.
208 * **Country Adjustments**: Here, you can select a custom country list. You can find the setting for a country list under the tab "Country Rates" -> see Country Rates.
Dominic Lippmann 3.1 209 )))
210
YellowFox_RD 13.1 211 = **Personnel Assignment** =
Dominic Lippmann 7.1 212
YellowFox_RD 13.1 213 There is a specific action to assign persons to a profile. The assignment is made under "New Assignment." You can also select multiple people directly via the group selection. In the "Existing Assignments" section, you get an overview of which drivers have already been assigned to this profile.
Dominic Lippmann 3.1 214
YellowFox_RD 13.1 215 = **Country Rates** =
Dominic Lippmann 7.1 216
YellowFox_RD 13.1 217 There is an option to define individual expense rates for each country/region via the "Country Rates" settings section.
Dominic Lippmann 7.1 218
YellowFox_RD 13.1 219 == Overview ==
Dominic Lippmann 7.1 220
YellowFox_RD 13.1 221 The overview displays all created lists for these country rates. For the past four years, the statutory guidelines are also shown.
Dominic Lippmann 7.1 222
YellowFox_RD 13.1 223 **Functions for Lists:**
Dominic Lippmann 3.1 224
YellowFox_RD 13.1 225 (((
226 * **Show List Values**
227 Opens the settings page for this list.
228 Past lists cannot be edited. If changes are made to the current list, it will be copied (and deleted if necessary).
Dominic Lippmann 7.1 229
YellowFox_RD 13.1 230 * **Copy List**
231 Copies a list along with all its values.
Dominic Lippmann 7.1 232
YellowFox_RD 13.1 233 * **Delete List**
234 Deletes a list.
Dominic Lippmann 7.1 235
YellowFox_RD 13.1 236 * **Create New List**
237 Opens the settings page for a new list.
238 The basis for a new list is always the statutory flat rates of the respective year and countries.
239 )))
Dominic Lippmann 7.1 240
YellowFox_RD 13.1 241 == Settings ==
Dominic Lippmann 7.1 242
YellowFox_RD 13.1 243 Each list consists of an identifier. When creating a new list, there is also the option to define whether it should cover all countries or only the modified ones. By default, you will receive a limited list with all countries whose settings deviate from the statutory rates. However, you can switch to a full view in which all countries/regions are listed and can be edited.
244
245 === Settings "list coverage" ===
246
247 The difference if a list contains all countries or only the changed ones maybe trivial for the first time, but can have an great impact later.
248 If your list contains only the changed countries, for all unchanged the legal values are used. These are managed by YellowFox. Is a validity period of a list over the years and there are changes to to legal for the new year these values are used automatically.
249 A list containing all values do not use these changes, all values keep stable no matter if a legal value changed.
250
251 === Change settings ===
252
253 You can set your own point of time you want to pay expenses for, for each country or region. Point on the timeline and just click on the point of time to set a new marker or you click on a marker and move it to left or right. To delete a marker you can click on it (all other are faded out) and click on the [[image:cross.png]].
254 To deselect a marker, click a second time on it. Now all other markers are faded in again.
255 To change a value, click on it and fix it. If you change the value for the 24h marker, the value for "full day expenses" are set too.
256 Changes are marked red.
257 If you want to reset your changes, click on the action [[image:reset2.png]]All your data for this country/region are set back to point of your last save. To go back to the legal settings, use the action [[image:legal2.png]]
258 After saving the data, these settings are used for all calculations.