Berta
←All posts

Logbook templates in Germany: Excel or app?

Published:

If you drive a company car in Germany and want to tax your private use by actual cost, a logbook template in Excel will not get you there. Germany's Federal Fiscal Court requires that later changes to a logbook are either impossible or remain visible, and an ordinary spreadsheet cannot do that. What works is a bound paper logbook or an electronic one that documents every later change (as of November 2026).

The essentials

  • Excel file on your computer: unsuitable, because entries can be overwritten without a trace.
  • Template to print: loose sheets are not enough; the logbook needs a closed, book-like form.
  • Bound paper logbook: works if you keep it promptly and completely.
  • App or electronic logbook: possible if changes are technically ruled out or documented in the record itself.
  • Acceptance is always the tax office's decision in the individual case.

Why would I keep a logbook at all?

In Germany, private use of a business vehicle is a taxable benefit. The default is a flat method known as the 1 percent rule: each month, 1 percent of the car's German list price at first registration counts as the taxable benefit. The other option is to tax only the share of the actual costs that falls on private trips. That is allowed only if all vehicle costs are proven by receipts and the ratio of private to other trips is proven by a proper logbook, in German an "ordnungsgemäßes Fahrtenbuch". The rule sits in section 6 of the Income Tax Act for the self-employed and in section 8 for employees with a company car. Both texts are in German.

The law does not define "proper". The standards come from the Federal Fiscal Court (Bundesfinanzhof, BFH), the highest German court for tax matters, and they are strict.

What must a German logbook contain?

The court has summarised the minimum details several times, for example in its judgment VI R 31/10 of March 2013. For every business trip you need:

  • the date,
  • the start and the destination, named specifically,
  • the customer or business partner you visited, or the specific reason for the trip if there was none,
  • the total odometer reading at the end of the trip.

Several legs of one connected business trip may be combined in a single entry if the stops are listed in order and the odometer reading at the end is recorded. When use switches from business to private, you note the odometer reading at that point.

These details have to be in the logbook itself. According to the judgment, calendars, expense reports, garage invoices or spreadsheets cannot replace them.

Why is an Excel template a problem?

A logbook must be kept promptly and in closed form, so that later insertions or changes are ruled out or at least recognisable. For files, the court has been specific: a file created with a computer program is sufficient only if later changes to data already entered are technically impossible, or if their extent is documented and disclosed in the file itself.

In an ordinary spreadsheet you can overwrite any cell and nothing shows it. The court rejected a logbook kept in a spreadsheet program for that reason back in 2005, and it expressly confirmed that position in its order VI B 37/23 of January 2024.

If the logbook is rejected, the flat 1 percent rule applies instead, and a year of record keeping was for nothing.

Is a printed template good enough?

Printing a template and filling it in by hand is closer, but it has its own trap. According to the 2024 order, a loose collection of individual sheets with no outward connection is not a logbook at all. What is required is a book-like form in which later changes are clearly recognisable as such.

In practice: if you want to work on paper, use a bound booklet instead of single printouts. Enter each trip straight afterwards and leave no lines empty.

When does an app work?

An electronic logbook is possible in principle. The court says the requirements are not identical to those for paper. What matters is that every later change is documented and disclosed in the record. The record also has to stand on its own: if the tax office first has to request further lists or ask third parties before it can see a closed register, the file is not a suitable method.

So when you choose an app, check three things:

  • Corrections stay visible and the original entry is not overwritten.
  • You can export the complete record including corrections.
  • The app makes it easy to enter trips right away instead of at the end of the month.

How does Berta help?

In Berta you switch the logbook on per vehicle. Each trip gets a category (business, commute or private) plus the odometer reading at start and end, the destination, the business partner and the purpose. Entries can be edited for 24 hours and are then locked. Later corrections appear as a visible correction trail. Berta also points out gaps, where kilometres are shown by other odometer evidence but not covered by logged trips, and exports the year as a PDF. The details are in the logbook documentation.

Whether a logbook is accepted in a particular case is decided by the tax office. This article is not tax advice or legal advice. If it concerns your company car, agree the method with a tax adviser in advance.

Frequently asked questions

Will the German tax office accept a logbook kept in Excel?

As a rule, no. The Federal Fiscal Court requires that later changes are technically impossible or are documented and disclosed in the file itself. An ordinary spreadsheet can be overwritten without leaving a trace.

Can I print a logbook template and fill it in by hand?

Loose printed sheets are not enough. According to the court, a paper logbook needs a book-like, connected form in which later changes are clearly recognisable. A bound booklet is the simplest way to meet that.

What has to be recorded for each trip?

For every business trip: the date, the start and destination, the customer or business partner visited or the specific reason for the trip, and the odometer reading at the end. These details must be in the logbook itself.

Is an app allowed as a logbook in Germany?

Yes, an electronic logbook is possible if later changes are ruled out or visibly documented in the record. Whether it is accepted in a particular case is decided by the tax office.