Logbook Excel template 2027, travel expenses with mileage allowance, mileage proof for self-employed individuals, Google Sheets, EÜR (income statement)

Seller's description

Suitable for 2026 and 2027: You enter the year yourself on the start sheet. The listed flat rates are for 2026; please check them briefly for 2027.

Your mileage log for Excel and Google Sheets: You enter your trips, and the template calculates kilometers, mileage allowance, and travel expenses per month, quarter, and year. This way, you have your business mileage neatly documented and the total for your income statement immediately available.

For self-employed individuals, freelancers, small business owners, and those with secondary businesses who also use their private car for business purposes. No subscription, no app, no account required.

IMPORTANT, PLEASE READ BEFORE PURCHASING
This template is for documenting mileage and travel expenses for your private car (mileage allowance). It is NOT intended as a logbook for a company car: The tax office generally does not recognize an Excel-based logbook as a "proper logbook" because entries can be altered retroactively. If you want to avoid the 1% rule with a logbook, you need a tamper-proof solution. Please consult your tax advisor for advice.

WHAT YOU GET
✓ Homepage with total mileage, business, home/work and private mileage, business usage share and total travel costs
✓ Two charts: kilometers per month and breakdown by type of trip
✓ Trips with 1,500 lines: Enter the starting and ending mileage; the template calculates the mileage.
✓ Trip type via selection list: Business, Commuter, Private
✓ Mileage allowance for business trips (as of 2026: €0.30 per km, can be changed by the user)
✓ Commuting allowance for journeys between home and work (as of 2026: €0.38, can be changed by the employee)
✓ Automatic check: reports gaps in the mileage, negative mileage, missing information and incorrect order
✓ 50% check: Notification if you use the car for business purposes more than half the time
✓ Months and quarters: km by type of trip and travel costs, the totals for your income statement
✓ Locations and customers: frequent destinations with distance as a suggested list, plus journeys, km and costs per customer
✓ Instructions directly in the file and a sample file to try it out

IT'S THAT EASY
Year 1, enter vehicle and mileage as of January 1st.
2. Create frequent destinations under "Places" (optional)
3. Record each trip with date, mileage, destination, purpose and type of trip.
4. Read the mileage and travel costs per month, quarter and year.

Yellow fields are for entering data, grey fields calculate automatically. The formulas are protected (without a password) to prevent any errors.

DELIVERY CONTENTS (INSTANT DOWNLOAD)
• Logbook.xlsx: the blank template
• Logbook_Demo.xlsx: the same template with sample data
• Quick guide.pdf: Explained step by step

COMPATIBILITY
• Microsoft Excel (Windows and Mac, from Excel 2010 onwards)
• Google Sheets (free, also on mobile)
• LibreOffice Calc (free)
Only standard formulas, no macros.

FREQUENTLY ASKED QUESTIONS
Do I also need to enter private trips?
No. You can record all trips or only business trips. If you select "business only," you disable gap reporting. Private mileage will then be calculated from the odometer reading.

Can I use the file for several years?
Yes. You make a copy for each year and enter the new year and the mileage on January 1st. Trips from other years are not included.

Does this fit with the EÜR (income statement)?
Yes. Under "Months" you'll find the travel expenses per quarter and year. You transfer this total as a business expense to your income statement, for example, using our income statement template.

Is this a logbook for my company car?
No, see note above. For a company car, you need a tamper-proof solution.

NOTES
• Digital product, nothing will be shipped.
• This template is a working aid and does not replace tax advice. Flat rates as of 2026, calculations without guarantee.
• The templates are developed with the support of AI tools and are checked and tested before being sold.

Questions? Message me on Etsy, I'm happy to help.