Small Business Bookkeeping Excel 2027 | Income, Expenses, Invoices and Turnover Monitor [DE]
NowPrice:$4.15
Original Price: $6.91
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
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.92
Original Price $43.21
-
Digital download
Product Database Excel Template | Items, Prices, Margins and Stock [DE]
Sale Price $22.81
Original Price $38.01
-
Digital download
Swiss Freelancer Bookkeeping Excel 2027 | Income, Expenses and Quarterly VAT Summary [DE]
Sale Price $19.54
Original Price $32.57
-
Digital download
Creator Income and Tax Reserve Tracker Excel 2027 | Platform Earnings, Products Received and Expenses [DE]
Sale Price $4.15
Original Price $6.91
-
Digital download
Real Estate Cash Flow Calculator Excel – Return Calculation, Financing Comparison & Investment Template
$5.27
-
Digital download
Break-Even Excel Template [DE/EN] – Business Plan Calculator, Fixed & Variable Costs, Profitability Analysis, Instant Download
$5.84
-
Digital download
Offline Income and Expense Tracker: VAT, Small Business Bookkeeping
$9.95
-
Digital download
Compare electricity and gas prices from up to 3 providers quickly and easily. Ready-made Excel template for immediate download.
$7.03
-
Digital download
Offline Income and Expense Tracker: VAT, Small Business Bookkeeping
$9.95
-
Digital download
Short-Term Rental Management Software | Excel and Google Sheets Templates for Vacation Rentals | Automatically Calculate Commissions, Cleaning Fees, and Actual Net Profit
$9.12
-
Digital download
Bookkeeping Income and Expense Tracker: Small Business, Event Planning
$9.95
-
Digital download
Equipment ROI Tracker, Dark Mode, Excel Dashboard for Any Business, Profit & Depreciation Tracker
$5.99
-
Digital download
MS Excel template financial tracker | monthly planner | budget planner | income, expenses, savings | personal finances | household book | german
$9.82
-
Digital download
Automated Excel Invoice Template | Small Business, Freelancer Bookkeeping (Digital Download)
$7.21
-
Digital download
50+ Excel Financial Calculators Template Bundle | Business, Loan, Budget, ROI, Mortgage Expense Tracking Spreadsheet
$6.00
-
Digital download
Cash Flow Tracker for UK Small Business – Excel + Guide
$8.39
Shoppers with similar taste loved these
-
Digital download
Small Business Bookkeeping Spreadsheet Planner Google Sheets Excel Project Management Task Tracker Gantt Chart Accounting Template Bundle
Sale Price $9.95
Original Price $24.87
-
Digital download
Bookkeeping Spreadsheet Small Business Bookkeeping Google Sheets Accounting Template Easy Book Keeping Income and Expense Profit And Loss
Sale Price $4.99
Original Price $9.98
-
Digital download
Small Business Bookkeeping Template Excel Bookkeeping Spreadsheet Business Expense Tracker Sales Tracker Accounting Template Income Tracker
Sale Price $9.95
Original Price $14.21
-
Digital download
Small Business Bundle Bookkeeping Spreadsheet Client Tracker CRM Excel Template Google Sheets Budget Tracker Pricing Calculator Freelancer
Sale Price $12.97
Original Price $32.43
-
Digital download
Small Business Bundle Bookkeeping Inventory Tracker Order Tracker Product Handmade Pricing Calculator Smart Bill Calendar Google Sheet Excel
Sale Price $14.96
Original Price $29.92
-
Digital download
Small Business Easy Bookkeeping Spreadsheet Profit And Loss Excel Google Sheets Sales Tax Tracker Accounting Template Profit Tracker Invoice
Sale Price $8.45
Original Price $21.13
-
Digital download
Small Business Bundle Inventory Tracker Excel Pricing Calculator for Handmade Business Bookkeeping Spreadsheet Client Invoice Google Sheets
Sale Price $14.99
Original Price $29.98
-
Digital download
Profit and Loss Easy Bookkeeping Template & Business Spreadsheet with Income and Expense Tracker | Tax Planner and Client Tracker
Sale Price $14.58
Original Price $29.16
-
Digital download
All-in-One Business Spreadsheet Bundle | Editable Google Sheets & Excel Templates |Complete Sales and Inventory Management System|PLR Rights
Sale Price $2.31
Original Price $4.62
-
Digital download
Etsy Seller Bookkeeping Spreadsheet Small Business Planner Income Expense Profit Tracker Google Sheets Excel Accounting Template Tax Tracker
Sale Price $8.23
Original Price $16.46
-
Digital download
Small Business Bookkeeping Spreadsheet Inventory Tracker Order Tracker Product Handmade Pricing Calculator Client Tracker Google Sheet Excel
Sale Price $12.34
Original Price $24.69
-
Digital download
PLR Small Business Digital Product Bookkeeping Tracker Task & Invoice Tracker Financial Planner Client Tracker Digital Download
Sale Price $6.88
Original Price $13.77