Self-employed package Excel 2027, income statement template, invoice template, time tracking, mileage log, small business owner, Google Sheets German
Item highlights
Seller's description
Suitable for 2026 and 2027: You enter the year yourself on the start sheet. The boundaries shown are as of 2026; please check them briefly for 2027.
Four Excel templates for your self-employment in one package, in German, for Excel and Google Sheets: write invoices, track working hours, record travel expenses, and have your income statement ready at the end of the year. All in the same style, all usable without prior knowledge.
Individually, the four templates cost €44.60 in this shop. The package costs €29.90.
THIS IS IN THE PACKAGE
1. Income statement & profit
✓ Income and expenses with automatic net and tax calculation
✓ Depreciation (AfA) calculated on a monthly basis, hospitality expenses automatically deducted at 70%
✓ Sales tax, input tax and tax liability per month and quarter
✓ Small business checklist with traffic light system and income statement overview on one A4 page
2. Invoice template & invoice book
✓ Select customer, address automatically filled in, items from your service catalog
✓ 7% and 19% VAT shown separately, small business notice according to § 19 UStG with one click
✓ Invoice book with status open, overdue and paid
3. Time tracking & timesheets
✓ Hours per client and project, hourly rate and amount automatically
✓ Hourly budget with warning, monthly overview per customer
✓ Printable timesheet, matching the invoice
4. Logbook & Travel Expenses
✓ Trips with mileage, destination and purpose, check for gaps
✓ Mileage allowance for business trips, quarterly totals for the income statement
✓ Note: An Excel-based logbook is generally not accepted as a valid logbook for company cars. This template is intended for documenting mileage with a private vehicle.
DELIVERY CONTENTS (INSTANT DOWNLOAD)
• YOUR.xlsx, Invoice Template.xlsx, Time Tracking.xlsx, Logbook.xlsx: the four empty templates
• Example_files_and_instructions.zip: four example files to try out and four quick guides as PDFs
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 need accounting knowledge?
No. You fill in the yellow fields, the grey fields are calculated automatically. Each file contains instructions.
Can I use the templates every year?
Yes. You create one copy per year and set it for the new year.
What about e-invoicing?
The invoice template creates PDF invoices. This is still permitted for private customers, small businesses, and small amounts up to €250. For invoices to other businesses, e-invoicing is becoming mandatory in Germany (as of 2026). Details can be found in the instructions.
NOTES
• Digital product, nothing will be shipped.
• The templates are working aids and do not replace tax advice. Limits and calculations are provided 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.
If something goes wrong with an order, we've got your back for all eligible purchases. View programme terms
Price:£26.27
You can only make an offer when buying a single item.
Delivery
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.
Seller's description
Specifications
Suitable for 2026 and 2027: You enter the year yourself on the start sheet. The boundaries shown are as of 2026; please check them briefly for 2027.
Four Excel templates for your self-employment in one package, in German, for Excel and Google Sheets: write invoices, track working hours, record travel expenses, and have your income statement ready at the end of the year. All in the same style, all usable without prior knowledge.
Individually, the four templates cost €44.60 in this shop. The package costs €29.90.
THIS IS IN THE PACKAGE
1. Income statement & profit
✓ Income and expenses with automatic net and tax calculation
✓ Depreciation (AfA) calculated on a monthly basis, hospitality expenses automatically deducted at 70%
✓ Sales tax, input tax and tax liability per month and quarter
✓ Small business checklist with traffic light system and income statement overview on one A4 page
2. Invoice template & invoice book
✓ Select customer, address automatically filled in, items from your service catalog
✓ 7% and 19% VAT shown separately, small business notice according to § 19 UStG with one click
✓ Invoice book with status open, overdue and paid
3. Time tracking & timesheets
✓ Hours per client and project, hourly rate and amount automatically
✓ Hourly budget with warning, monthly overview per customer
✓ Printable timesheet, matching the invoice
4. Logbook & Travel Expenses
✓ Trips with mileage, destination and purpose, check for gaps
✓ Mileage allowance for business trips, quarterly totals for the income statement
✓ Note: An Excel-based logbook is generally not accepted as a valid logbook for company cars. This template is intended for documenting mileage with a private vehicle.
DELIVERY CONTENTS (INSTANT DOWNLOAD)
• YOUR.xlsx, Invoice Template.xlsx, Time Tracking.xlsx, Logbook.xlsx: the four empty templates
• Example_files_and_instructions.zip: four example files to try out and four quick guides as PDFs
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 need accounting knowledge?
No. You fill in the yellow fields, the grey fields are calculated automatically. Each file contains instructions.
Can I use the templates every year?
Yes. You create one copy per year and set it for the new year.
What about e-invoicing?
The invoice template creates PDF invoices. This is still permitted for private customers, small businesses, and small amounts up to €250. For invoices to other businesses, e-invoicing is becoming mandatory in Germany (as of 2026). Details can be found in the instructions.
NOTES
• Digital product, nothing will be shipped.
• The templates are working aids and do not replace tax advice. Limits and calculations are provided 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.
-
Item typeDigital download
-
Digital file type(s)1 ZIP, 4 other files
If something goes wrong with an order, we've got your back on all eligible purchases. View programme terms
Meet your seller
More from this shop
-
Digital download
EÜR template 2027 Excel for small businesses, income statement, accounting for self-employed individuals, Google Sheets, profit calculation
£13.09
-
Digital download
Parents' Association Cash Book Excel Template 2027 School/Kindergarten: Parents' Association Cash Book, Members, Contributions, Cash Report, Cash Audit
£13.09
-
Digital download
Shared cash register Excel template (German), household budget for couples, shared apartment cash register, splitting costs, Google Sheets, who owes whom, expenses
£11.33
-
Digital download
Household Budget 2027 Excel Template (German), Budget Planner, Financial Planner (Google Sheets), Household Planner with Savings Goals, Fixed Costs
£11.33
-
Digital download
Music Association Choir Cash Book Excel Template 2027: Cash book for music association, members, fees, concerts, cash report, audit
£13.09
-
Digital download
Time tracking Excel template 2027 for freelancers, timesheet, proof of hours for invoicing, self-employed, Google Sheets German
£8.70
-
Digital download
Simple utility billing Excel calculator – Automatic tenant letter | Single-family homes, multi-family homes & commercial properties | Up to 24 units
Sale Price £11.33
Original Price £22.67
-
Digital download
Financial plan template for founders | 5 years | Business plan & unemployment benefit I/II viability calculation | P&L, cash flow, grants
£43.06
-
Digital download
Modern Excel template for creating utility bills and automated cover letters with intuitive operation
Sale Price £2.72
Original Price £10.87
-
Digital download
Modern Excel template for creating utility bills and automated cover letters with intuitive operation WITHOUT SHEET PROTECTION
Sale Price £3.92
Original Price £15.67
-
Digital download
The ultimate Excel bundle for real estate: renovation of old buildings, operating cost accounting and occupancy plan for your investment apartment
£43.89
-
Digital download
Excel Controlling Template / Dashboard, Accounting, Cash Flow & Liquidity - Business Tool for Freelancers and Self-Employed
£27.17
-
Digital download
VAT Calculator Spreadsheet 2024 Income and Expense Tracker Excel Google Sheet, Small Business Accounting Excel
£24.04
-
Digital download
Household budget Excel 2026: Cost tracking, expense management, financial planning tool, cost control, debt repayment, budget tracker
£26.34
-
Digital download
Digital Excel Budget Template | Manage Income and Expenses | Personal Finances & Asset Overview | Digital Financial Planner Download
£21.08
-
Digital download
Cash book, accounting, EÜR planner German
Sale Price £16.10
Original Price £29.27
-
Digital download
Accounting Dashboard for Sales and Expense Tracking | Financial Management Accounting for Self-Employed People Excel Google Sheets
Sale Price £19.03
Original Price £27.18
-
Digital download
Financial planning - 3-year planning including profit and loss statement as well as balance sheet and cash flow for a subscription model in e-commerce
£39.53
Shoppers with similar taste loved these
-
Digital download
Etsy Seller Bookkeeping Spreadsheet Small Business Planner Income Expense Profit Tracker Google Sheets Excel Accounting Template Tax Tracker
Sale Price £7.38
Original Price £14.75
-
Digital download
Small Business Finance Tracker Notion Template, Income and Expense, Bookkeeping, Notion Financial Planner
Sale Price £4.70
Original Price £9.41
-
Digital download
All-in-One Business Spreadsheet Bundle | Editable Google Sheets & Excel Templates |Complete Sales and Inventory Management System|PLR Rights
Sale Price £1.66
Original Price £4.13
-
Digital download
Small Business Bundle Bookkeeping Inventory Tracker Order Tracker Product Handmade Pricing Calculator Smart Bill Calendar Google Sheet Excel
Sale Price £13.40
Original Price £26.82
-
Digital download
PLR Small Business Digital Product Bookkeeping Tracker Task & Invoice Tracker Financial Planner Client Tracker Digital Download
£12.83
-
Digital download
Small Business Bookkeeping Spreadsheet Inventory Tracker Order Tracker Product Handmade Pricing Calculator Client Tracker Google Sheet Excel
Sale Price £11.06
Original Price £22.13
-
Digital download
Small Business Planner Budget Spreadsheet: Income, Expense, Inventory Tracker, Sales Tax, Bookkeeping Template Accounting (Google Sheets)
£14.66
-
Digital download
Small Business Bookkeeping Tracker Inventory Tracker Order Tracker Handmade Product Task Tracker Pricing Calculator Google Sheets Excel
Sale Price £10.06
Original Price £20.11
-
Digital download
Small Business Reseller Spreadsheet, Automated Monthly Inventory, Profit, Sales Dashboard, Order & Stock Status View, Google Sheets Excel
Sale Price £16.68
Original Price £25.66
-
Digital download
Expense Income Tracker Spreadsheet Business Finance Log Personal Budget Organizer Money Tracking Template Google Sheets Excel Accounting
£4.21
-
Digital download
Small Business Spreadsheet Inventory Tracker Order Sales Tracker Product Handmade Pricing Calculator Client Tracker Google Sheets Excel
Sale Price £7.38
Original Price £14.75
-
Digital download
Sales Tracking Spreadsheet Multi-Platform Tracker Product Costing Template Excel Google Sheets Sales App for Business Revenue Analytics
£5.15