How to turn your logbook into a tax advantage #
At first glance, a logbook may appear to be just a simple record of distances traveled. But for many drivers, it is of far greater importance. Whether you are self-employed with your own company car or an entrepreneur with employees who use a company car – the logbook not only serves to document the distances driven, but also brings tax advantages.
While it is not generally mandatory to keep a logbook, the tax office or another authority may require it in certain cases. In addition, a properly kept logbook helps you avoid the so-called 1% rule and provides a clear record of the proportion of private and business trips. A logbook can therefore be worthwhile for you even if it is not mandatory.
This article shows you what you absolutely need to keep in mind when maintaining a logbook and provides an informative overview of the most popular tools for keeping a digital logbook.
Whether a logbook or the 1% rule makes more sense #
What is the 1% rule for company cars? #
The 1% rule is a flat-rate taxation method for company cars that the tax office offers in order to easily calculate the non-cash benefit of a company car that is also used privately. Each month, one percent of the domestic gross list price of your vehicle is taxed as a private use benefit. This applies regardless of how often you actually use the car for private or business purposes.
Whether a logbook or the 1% rule is more worthwhile for your company car depends largely on how the driver uses it. A helpful rule of thumb: if you use the company car about equally for private and business purposes, flat-rate taxation is usually the cheaper and simpler choice.
When a logbook is worthwhile #
The situation is different if you use the car privately less than half of the time. In this case, a logbook can be an advantage. By documenting in detail when and for what purpose you use the vehicle, you can prove to the tax office exactly what proportion of your trips is private and what is business. This way, you only declare the actual private use and can possibly reduce the non-cash benefit you have to pay tax on significantly. Ultimately, the drivers of the company cars bear the effort, even if they cannot claim any tax deductions of their own. However, if the car is mainly used for business purposes, this effort can be financially worthwhile for the company in the long term.
Legal requirements and what you need to consider #
If you also use a company car privately, it is important to document every trip conscientiously in order to properly pay tax on the non-cash benefit. Prompt recording is essential: ideally, you should write down the details immediately after each trip or at the end of the day at the latest. This way, you can avoid errors and manipulation and always keep track of your trips.
A logbook that meets the requirements of the GoBD (principles of proper accounting) requires the following information to be documented for business trips:
- Date, time and mileage: Note these points at the beginning and at the end of each business trip.
- Destination and purpose of the trip: Note where you went and why. If you take a detour, you should also record the route you took.
- Business partners or customers: If you had a business appointment, you should note the name of the person in question.
For private trips, it is sufficient to state the kilometers driven. Trips between your home and your place of work only require a brief note, as they take place regularly and no further details are necessary. By carefully documenting your trips, you not only satisfy the tax office, but also keep track of the use of your company car yourself.
What the tax office looks for in your logbook #
Logbooks are closely scrutinized by tax offices, as they form the basis for tax deductions and for distinguishing between private and business use of company vehicles. The tax offices not only check the entries in the logbook itself, but often also compare them with other documents such as fuel receipts and maintenance logs. For example, your fuel receipt from a certain city must match the trips recorded in the logbook. Otherwise, the tax office could question the plausibility of your information.
Even small gaps or inconsistencies, such as an unclear distinction between business and private trips, can be problematic. If the tax office becomes aware of such errors, it can reject the logbook and automatically apply the 1% rule. This flat-rate taxation is usually more expensive and is at the expense of the vehicle owner. That is why care is particularly important when you keep a logbook.
When keeping the logbook, whether handwritten or digital, the principle of traceability applies. Subsequent changes must under no circumstances cover up traces or obscure the original entries. In a handwritten logbook, this means that you may only cross out incorrect entries in such a way that they remain legible – the use of Tipp-Ex or similar means is prohibited. In an electronic logbook, all changes must be logged in order to ensure a complete history of trips at all times.
Analog vs. digital – which logbook is more worthwhile for you #
Whether an analog or a digital logbook is right for you depends on your individual preferences and requirements. Both variants offer specific advantages, but also disadvantages, which you should weigh up depending on the use and purpose of the logbook.
Analog logbook #
The analog logbook, i.e. the classic handwritten record, has advantages above all due to its independence and simplicity. It is accessible at any time (independent of a technical device) and does not require a power source or internet connection. This option is often cost-effective, as you only need to purchase the logbook itself. An analog logbook is therefore particularly suitable for occasional users or people who only have low documentation requirements.
However, the disadvantage of the analog logbook is the higher time investment, as you have to enter every trip by hand. This manual effort also increases the susceptibility to errors: illegible handwriting, missing information or forgotten entries can quickly render the records in the logbook unusable. There is also a risk that your logbook will be damaged or lost completely due to everyday wear and tear and the effects of the weather.
Keeping a digital logbook #
Digital logbooks are becoming increasingly popular as they offer a convenient and modern alternative. A clear advantage of digital logbooks is that they can neither be lost nor damaged, which is a real problem with physical logbooks. As digital solutions are usually based on cloud technologies, your data is stored securely and can be accessed online at any time. In addition, digital logbooks are often equipped with analysis tools that allow you to precisely evaluate the routes driven and usage patterns. For example, you can evaluate and track the kilometers driven in connection with the purpose of use.
A frequently discussed aspect of digital logbooks is data protection. Strict regulations apply here, especially if you process personal data. Good digital systems encrypt and anonymize your data and thus meet the requirements of the General Data Protection Regulation (GDPR). Another point is the cost: digital logbooks are usually associated with ongoing subscriptions, and the costs for software or apps can vary depending on the scope of the functions. In practice, however, the added value of time saved and precise data analysis can often offset these costs.
Comparison of the digital logbooks from Vimcar, Excel and SeaTable #
If you want to keep a logbook, there is now a wide range of digital solutions, from practical apps to comprehensive software. The market offers both fully automatic versions and alternatives with manual entry – there is something for every need and every budget. We have put some of the most popular tools through their paces for you. We focused on the criteria of ease of use, legal certainty, data protection, costs, analysis functions and the manual effort required.
Vimcar logbook #
Vimcar is digital logbook software designed specifically for companies and the self-employed who require complete and legally compliant documentation. With user-friendly functions such as automatic trip recognition and categorization as well as seamless integration into existing workflows, Vimcar makes it easier to manage the logbook.
- Ease of use: High ease of use, user-friendly app and simple handling
- Legal certainty: Legally compliant and recognized for tax purposes
- Data protection: Data is stored encrypted in the cloud
- Costs: Ongoing costs through a monthly subscription from €13.90 per month/vehicle
- Analysis function: Extensive analysis functions
- Manual effort: Minimal effort due to automated recording
Logbook with Excel #
If you create your logbook using an Excel template, this is inexpensive and flexible, but it requires full manual effort and involves tax uncertainties. While this method may be suitable for internal purposes, it is usually not recognized by the authorities. The reason for this is the lack of a tamper-proof change history, which prevents entries from being manipulated retroactively. This is an important point that often disqualifies Excel as a tax-compliant logbook.
- Ease of use: Flexible, but without a ready-made interface
- Legal certainty: Not legally compliant, as the lack of a change history can lead to manipulation
- Data protection: Local storage, privacy-friendly, but without encryption
- Costs: No additional costs for Microsoft 365 users, as Excel is already available
- Analysis function: Flexible, but analysis is only possible with a great deal of effort of your own
- Manual effort: Very high manual effort, as it is kept completely manually
Free template: Keeping a digital and efficient logbook with SeaTable #
If you’re looking for a logbook app that is free and makes your day-to-day work easier, SeaTable is an excellent choice. SeaTable offers a flexibly customizable logbook template, allowing you to record your trips digitally and manage them conveniently online.
SeaTable scores highly in terms of data protection and offers you the choice between cloud and on-premises hosting, so you can decide for yourself where you store your data. Another advantage: entries can be made quickly and easily using the integrated web form. This form can request all the necessary information, including a digital signature, which makes the process particularly efficient and secure.
A particular highlight is the option of generating a QR code directly in SeaTable, which you can attach to your company vehicle, for example. This allows you to conveniently access the web form for the logbook at any time. SeaTable also enables simple analyses and evaluations so that you can precisely track the use of your vehicle.
After submitting the form, drivers no longer have access to their entries and therefore cannot make any subsequent changes or manipulations. Although you have the option of making adjustments directly in the table, all changes are logged in detail and thus remain traceable at all times.
- Ease of use: Flexible, with a ready-made template incl. web form
- Legal certainty: Legally compliant with change history
- Data protection: GDPR-compliant, cloud or on-premises, server location in Germany
- Costs: Free basic version, more functions from €7 per month/user
- Analysis function: Comprehensive analysis with little effort
- Manual effort: Moderate effort due to manual entry in the form
If you would like to use SeaTable’s digital logbook, simply register and start with the free template.
Frequently asked questions #
Do I have to document every trip?
What must be included in a logbook?
The following details must be fully documented in a logbook for each trip:
- Date of the trip
- Time at the start and end
- Mileage at the start and end of the trip
- Destination and purpose of the trip
- Name of the business partner or customer (for business trips)
What happens if I lose my logbook?
If you lose your logbook, the consequences depend on whether you were obliged to keep it:
If you were obliged to keep a logbook: The loss will result in a fine of 100 euros. In addition, the logbook requirement may be extended, as the logbook can no longer be presented.
If you keep a voluntary logbook for the tax office: In this case, the 1% rule applies, which often leads to higher costs, as private use is taxed at a flat rate.
Is the 1% rule or the logbook more favorable?
What are the advantages of a logbook?
In summary, a logbook for company cars offers advantages above all if the private use of the vehicle is low and the effort that a logbook entails seems justified.
The digital alternatives make the logbook accessible online and simplify administration considerably, which makes them particularly attractive for companies and the self-employed who rely on precision and efficiency.
The ability to document trips in detail and with legal certainty allows you to make the most of tax benefits while maintaining a clear overview of your vehicle use.