Report this item to Etsy

Travel Meal Allowance Excel 2027 | Travel Records with Editable Domestic and Foreign Per Diem Rates [DE]

NowPrice:$3.43

Original Price: $5.72

Loading

40% off

•

Sale ends in 4 days

You can only make an offer when buying a single item

Highlights

Product language: German.

Edition for 2027.

• 10 visible Excel sheets: Start, Einstellungen, Pauschalentabelle 2026, Mitarbeitende & Reisen, Tageserfassung, Übersicht, Beispiel, Anleitung, Quellen & Stand, Lizenz.

Meal-allowance calculations for business travel raise practical questions: when does a part-day or full-day rate apply, how are employer-provided meals deducted, and when does the statutory three-month rule apply at a recurring workplace? The supplied 2026 examples include German rates of EUR 14/EUR 28 and meal deductions of 20%/40%.

This workbook supports travel records and meal-allowance calculations. Use actual travel dates and maintain the applicable part-day and full-day rates for the travel year and country in Pauschalentabelle 2026!D7:E15. Breakfast, lunch and dinner deductions refer to the entered full-day rate.

Use a separate file copy for each travel year. There is no automatic annual filter or online rate update. Supplied values, examples and source dates relate to 2026; enter the rates actually applicable before using the file for a 2027 trip. The historical sheet name “Pauschalentabelle 2026” is retained so the input location remains clear.

The delivery includes travel records, daily entries and an overview. Check the legal conditions for your own case, including the relevant absence duration and three-month rule. This 2027 version does not promise an additional automatic time or deadline check.

Delivery: one ZIP with exactly 13 customer files – the blank 2027 workbook and unchanged 2026 example workbook (XLSX), PDF guide and licence, LICENSE.txt, original business card, annual-use and colour guidance, and five themes.
Files:
• Anleitung_verpflegungsmehraufwand.pdf
• FARBGESTALTUNG.txt
• JAHRESNUTZUNG.txt
• LICENSE.txt
• Lizenz_verpflegungsmehraufwand.pdf
• Lumen.thmx
• Opacitas Clara.thmx
• Opacitas.thmx
• Schattenspiel-verpflegungsmehraufwand-LEER_2027.xlsx
• Schattenspiel-verpflegungsmehraufwand_2027_BEISPIEL_2026.xlsx
• Visitenkarte.jpg
• Visus Lucis.thmx
• Visus.thmx

The product content is supplied in German. This is a digital download; no physical item is supplied.

We welcome ideas and suggestions, and support is available after purchase.

Licence: you may use the files privately and in your own business. You may not resell, share, publish or use them for AI training. Questions? hallo [!at] schattenspiel.eu

This template is designed for computer use; smartphone use is limited. For the best experience, open it on a PC or Mac in Microsoft Excel or Google Sheets. A PDF reader is required for the guide and licence.

We update our templates regularly and state the revision date. Facts, figures and legal requirements may still change. Check the rules that apply to you; if you notice outdated information, write to hallo [!at] schattenspiel.eu. Questions and ideas are welcome at the same address.

Instant Download

Your files will be available to download once payment is confirmed.  Here's how.

Instant download items don’t accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.

Etsy Purchase Protection
Shop confidently on Etsy knowing if something goes wrong with an order, we've got your back for all eligible purchases — see program terms

You may also like

Shoppers with similar taste loved these

Show more
Show more
Listed on Oct 10, 2026