Travel Meal Allowance Excel 2027 | Travel Records with Editable Domestic and Foreign Per Diem Rates [DE]
NowPrice:$3.43
Original Price: $5.72
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
Be the first to review this item
More from this shop
Visit shop-
Digital download
Business Templates for Notion | CRM, Projects, Finances and Content | Duplicate Link or CSV Import [DE]
Sale Price $25.83
Original Price $43.05
-
Digital download
Product Database Excel Template | Items, Prices, Margins and Stock [DE]
Sale Price $22.73
Original Price $37.87
-
Digital download
Swiss Freelancer Bookkeeping Excel 2027 | Income, Expenses and Quarterly VAT Summary [DE]
Sale Price $19.47
Original Price $32.46
-
Digital download
Creator Income and Tax Reserve Tracker Excel 2027 | Platform Earnings, Products Received and Expenses [DE]
Sale Price $4.13
Original Price $6.88
-
Digital download
Excel Template Travel Budget Planner, Vacation Expense Tracker Spreadsheet, Trip Cost Calculator Digital Download
$9.99
-
Digital download
Income statement - EÜR - profit determination | Excel template
$6.85
-
Digital download
Budget Planner Excel | Monthly Budget Spreadsheet | Expense & Income Tracker | Budget Template | Excel, Numbers and Google Sheets
$5.82
-
Digital download
Household budget Excel template, monthly financial planner, digital budget planner, Excel template, money saving challenge, budget planner in German
Sale Price $4.84
Original Price $9.68
-
Digital download
Household budget Excel template, monthly financial planner, digital budget planner, Excel template, money saving challenge, budget planner in German
Sale Price $4.84
Original Price $9.68
-
Digital download
Simple income statement - EÜR - profit calculation | Excel template
$6.85
-
Digital download
Excel Household Budget + Inventory Management – 2 in 1 Finance Bundle
$9.33
-
Digital download
10 day vacation travel planner | Microsoft Excel | Google Sheets | shareable and editable
$6.61
-
Digital download
Monthly budget template Excel, Excel Google Sheets table, expense income tracker, Excel budget German, Excel financial plan
Sale Price $4.81
Original Price $6.01
-
Digital download
Digital Ultimate Travel Itinerary - Excel
Sale Price $7.49
Original Price $9.99
-
Digital download
Household Budget Excel Template – Monthly Budget Planning & Expense Overview | Instant Download from FormundFlair
$11.66
-
Digital download
Editable Debt Planner Template
$5.78
Shoppers with similar taste loved these
-
Digital download
Schedule C Masterclass SLIDES, Teach Tax Students/PTIN Holders, Self Teach, Learn, Profit and Loss Statement, Tax Academy, Tax Agents, IRS.
$99.99
-
Custom Square Acrylic Business Logo Sign || custom logo sign for business outdoor use black frosted clear white acrylic glass look door sign
Sale Price $35.83
Original Price $47.78
-
Digital download
Tax Glossary: BEGINNER Guide. You can also give to your PTIN holders for guidance! Packed with terms, definitions, common questions and MORE
$15.00
-
Digital download
Tax Prep Social Media Templates: Editable Instagram & Facebook Posts and Stories (Canva Digital Download)
Sale Price $17.50
Original Price $35.00
-
Digital download
SCHEDULE C MASTERCLASS - REPLAY video of the live class! Level up your knowledge with this Masterclass! Learn everything you need to know!
$80.00
-
Digital download
Tax Prep Flyer, Tax Prep Instagram, Diy Editable Template,Tax Flyer Template, Preparation Flyers, Tax Prep Template, Canva Instant download
Sale Price $2.98
Original Price $5.96
-
Digital download
Tax Professional Business Cards, DIY Card Template Design, Tax Prep Business Cards, Accountant Business Cards, Premade Tax Consultant Card
Sale Price $1.68
Original Price $4.20
-
Digital download
IRS Audits & Penalties Tax Training Course | Workbook + Instructor Guide | PLR License
$39.99
-
Digital download
DIY Tax Business Card, Tax Prep Business Card, Tax Refund Business Card, Premade Template, Taxes Business Card, Editable Design
Sale Price $6.00
Original Price $10.00
-
Digital download
2 Tax Valentine Flyer, Tax Prep Bundle, Tax Prep Instagram,Tax Prep Flyer Bundle, Tax Flyer Template, Prep Flyers Bundle, Tax Prep Templates
Sale Price $5.99
Original Price $9.99
-
Digital download
Small Business Bookkeeping and Tax Spreadsheet, Daily Monthly Annual Expense Tracking, Daily income and expense log, Schedule C Tax Template
$15.49
-
Digital download
Tax Business Card, Tax Preparer Business Card, Tax Services, Tax Business Card Template,
Sale Price $3.50
Original Price $14.00