Report this item to Etsy

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

Loading

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

You may also like

Shoppers with similar taste loved these

Show more
Show more
Listed on Jul 29, 2026