DAC7 Sales Tracker Excel 2027 | 1,000 Sales Rows, Ten Platforms, Year Selector and Separate Section 23 Model [DE]
NowPrice:$4.13
Original Price: $6.89
40% off
Sale ends in 3 days
You can only make an offer when buying a single item
Highlights
Product language: German.
Edition for 2027.
Record sales, filter them by calendar year and review two separate models. This German-language Excel template offers 1,000 sales rows and ten platforms. The DAC7 view compares recorded paid goods sales and net consideration with statutory thresholds. The simplified Section 23 model shows recorded model profits and unresolved inputs. Neither view determines actual reporting obligations or personal tax liability.
WHAT IS INCLUDED
• An .xlsx workbook with eight German sheets: Menü, Verkaufs-Log, DAC7-Ampel, §23-Rechner, Regeln 2026, Quellen, Einstellungen and Terms of Use.
• 1,000 input rows (7–1006), platform/category dropdowns, protected formulas and editable input fields.
• A reporting-year selector in Einstellungen D28 (2024–2100). Both summaries filter the selected calendar year; changing the year does not update the underlying legal reference rules.
• Ten uniquely named platform slots, including five custom names. Update existing sales entries when renaming a platform.
• DAC7 counts and consideration after recorded platform fees. The model marks a threshold at 30 sales or EUR 2,000. The earlier warning at 25 sales/EUR 1,500 is a template setting.
• A simplified Section 23 model for recorded private valuables sold within the one-year period, compared with the EUR 1,000 exemption threshold. Missing purchase data triggers a review message; a known purchase price of zero is treated as a numeric value.
• Sample entries, official references, a three-page German PDF guide, a licence and a business card.
GETTING STARTED
Open on a computer, select the year, replace the sample entries and complete the white input cells. Check unresolved entries and reconcile with platform statements. No macros or subscription. The workbook can be imported into Google Sheets; appearance, protection and printing may differ after import.
MODEL LIMITATIONS
This is an organisational template, not an individual tax calculation. Business taxes, VAT, other private disposal transactions, additional costs, loss-offset rules, income-producing assets, real estate, gifts/inheritance and special cases require separate review. The log footer totals all recorded years, while the two summaries filter the selected year. Reference rules checked on 29 September 2026 against PStTG sections 4–6 and EStG section 23. Check changes in law and applicability to your situation.
Digital download; no physical item. Personal use and use in your own business are allowed. No redistribution, resale or publication of the files. The complete included licence applies. Questions and support: hallo [!at] schattenspiel.eu.
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.85
Original Price $43.08
-
Digital download
Product Database Excel Template | Items, Prices, Margins and Stock [DE]
Sale Price $22.74
Original Price $37.90
-
Digital download
Swiss Freelancer Bookkeeping Excel 2027 | Income, Expenses and Quarterly VAT Summary [DE]
Sale Price $19.49
Original Price $32.48
-
Digital download
Creator Income and Tax Reserve Tracker Excel 2027 | Platform Earnings, Products Received and Expenses [DE]
Sale Price $4.13
Original Price $6.89
-
Digital download
DCA Excel File – Automatic Investment Tracking | ETF, Stock, Crypto Yield Tracker
$5.83
-
Digital download
5S Audit Excel Template, Lean Workplace Checklist (Digital Download)
$6.95
-
Digital download
Crypto Portfolio Tracker: Purchase and sales transactions, FIFO Capital Gains Calculator (Google Sheets, Excel)
Sale Price $4.55
Original Price $7.01
-
Digital download
Accounts Workflow Efficiency Analysis Template | Excel + Google Sheets Dashboard | Process Optimization & KPI Tracker
Sale Price $4.49
Original Price $6.60
-
Digital download
Sellers Cost Template Excel & Google Sheets: Stop Losing Profits to Hidden Selling Costs
Sale Price $4.49
Original Price $6.60
-
Digital download
Excel Template Sales Tracker, Ecommerce Dashboard Spreadsheet, Online Business Revenue & KPI Analytics Digital Download
$9.99
-
Digital download
Activity Based Costing Template Excel | Cost Tracker | Product Cost Analysis Dashboard | Manufacturing Budget Spreadsheet
Sale Price $4.89
Original Price $6.99
-
Digital download
Inventory Stock Control Tracker Lite | Product Management | MS-Access Database Template
$5.59
-
Digital download
ISO 27001 Audit Checklist Excel | ISMS Compliance Tracker | Editable InfoSec Spreadsheet | Cybersecurity Risk Tool
$6.99
-
Digital download
Sales Performance Tracker Spreadsheet | Sales Goals & Target Monitoring | Excel Microsoft 365 Template | Sales Rep Activity Tracker Template
Sale Price $6.42
Original Price $12.84
-
Digital download
Crypto Portfolio Tracker: Purchase and sales transactions, FIFO Capital Gains, summary (Google Sheets, Excel)
Sale Price $4.55
Original Price $7.01
-
Digital download
DAC7 Seller Data Template | Excel Tracker, Dashboard, Fillable KYC Checklist PDF and Submission Letters En/De
$19.90
Shoppers with similar taste loved these
-
Digital download
Tax Prep Season Flyer, Tax Season Flyer, Accountant Flyer, Credit Repair Flyer, Business Consultation Flyer, Instagram Post, Flyer Template
$6.99
-
Digital download
Tax Prep Facebook Template: Q&A Posts for Professionals (Canva)
$3.99
-
Digital download
Tax Prep Instagram Posts: Tax Preparer Canva Templates
$9.89
-
Digital download
Tax Prep Social Media Flyers, Tax Instagram Posts, Tax Season Social Media Flyer, Tax Preparation Flyers, Tax Services Instagram Post
$9.00
-
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
Engagement Post Tax Preparer Facebook Post Canva Template Tax Professional Facebook Page Accountant Facebook Group CPA Social Media Template
Sale Price $10.20
Original Price $12.00
-
Digital download
DIY Tax Prep Flyer Template, Accounting Marketing (Canva)
Sale Price $3.00
Original Price $12.00
-
Digital download
Tax Prep Instagram Canva Template: 55 Posts & Captions (Digital Download)
$5.47
-
Digital download
4 Tax Prep Valentines Flyer | Valentines Flyer | Tax Professional | Tax Prep Flyer Bundle | Tax Flyer Template | Prep Flyers Bundle | DIY
Sale Price $9.00
Original Price $15.00
-
Digital download
10 Valentine's Day Tax Prep Flyers | Tax Prep Valentines Flyer Bundle | Tax Prep Instagram Templates | Tax Prep Flyers | Tax Flyer Template
Sale Price $7.04
Original Price $17.61
-
Digital download
Tax Madness Flyer Bundle: Editable Canva Template for Tax Professionals
$5.00
-
Digital download
March Tax Bundle, Tax Prep Flyer, March Flyer, Tax Flyer Template, Prep Flyers Bundle, Tax Prep Templates, Tax Prep Post, March Madness
Sale Price $9.00
Original Price $15.00