Report this item to Etsy

Small Business Bookkeeping Excel 2027 | Income, Expenses, Invoices and Turnover Monitor [DE]

NowPrice:$4.15

Original Price: $6.91

Loading

40% off

•

Sale ends in 4 days

You can only make an offer when buying a single item

Highlights

Product language: German.

Small-Business Bookkeeping 2027: two German-language Excel workbooks for annual records and German Section 19 VAT-turnover monitoring. The main workbook and Premium monitor are prepared for 2027, with examples dated in that year. One digital purchase for EUR 5.90, no subscription.

MAIN WORKBOOK
200 income and 200 expense rows, category dropdowns, an EÜR overview with profit and category reconciliation, and a Section 19 monitor covering preceding-year turnover, current statutory turnover, headroom and the first crossing payment reference. Also included: 120 outgoing-invoice records with paid/open/overdue status and 120 incoming e-invoice records with storage location and retention year. All eleven original sheets, navigation, logos, colours and designated input rights are retained.

PAYMENT YEAR AND STATUTORY TURNOVER
Einstellungen D12 is the year input, set to 2027. D11 remains the 14-day payment term. Column F records the full amount actually received, G the actual receipt date and I the amount relevant under Section 19. Complete income is retained. An excluded fixed-asset disposal can therefore have F = 15,000 and I = 0. Missing required entries are not the same as explicit zero. Record each actual payment or partial payment once; do not add unpaid invoice face values as fictitious receipts.

The monitor follows receipt chronology and identifies the first crossing payment. Same-day receipts follow their actual entered order. A later reduction does not erase a historical crossing. You classify the statutory amount in I; a category does not perform legal classification. EÜR and other totals are not general mixed-year filters. Keep a separate pair of files for each year.

PREMIUM MONITOR
Seven sheets provide a dashboard, twelve separately maintained statutory monthly amounts, cumulative turnover, first crossing month, linear projection, option-to-tax commitment and independent source/threshold checks. No automatic transfer from the main workbook. Monthly totals are not equivalent to individual payments: a crossing followed by a reduction within the same month requires reconciliation to the transaction history.

Under the rules used here, continuing businesses use EUR 25,000 preceding-year/EUR 100,000 current-year limits; a start-up uses actual EUR 25,000 without annualisation. Configure the three current-limit/comparison inputs consistently in both files and enter actual prior-year amounts separately. Equality remains within the limit; the next relevant cent crosses it. The guide covers start-ups, following years, asset disposals and year-end payments.

FIVE FILES IN ONE ZIP
Schattenspiel-Kleinunternehmer-Buchhaltung-2027.xlsx
Premium_Kleinunternehmer-Paragraph19-Waechter_2027_EDITIERBAR.xlsx
Anleitung_Kleinunternehmer-Buchhaltung_2027.pdf – complete five-page German guide
Lizenz_License_DE-EN.pdf – complete German/English licence
Visitenkarte.jpg – business card
These are different tools, not a blank/example pair. The incoming e-invoice sheet is a register; it does not generate or replace structured invoice files.

For Excel on a computer; the guide explains Google Sheets import, but no pre-created Google spreadsheet is supplied. Check features and protection after importing; complete platform equivalence is not promised. Historical 2026 legal/source notes and the reform applying since 2025 remain accurate. The 2027 edition does not claim an advance legal review of future legislation. Check official changes and individual circumstances. Existing illustrations show the original design.

Personal and own-business use under the full DE/EN licence, including your own annual copies. No sharing, resale, publication or AI/ML use. Support: hallo [!at] schattenspiel.eu. Organisational aid, not individual tax advice. Digital download, no physical item.

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 28, 2026