Anfangsbestand:|USt:|Klicke auf eine Zelle zum Bearbeiten
| Kategorie USt% | Jan | Feb | Mär | Apr | Mai | Jun | Jul | Aug | Sep | Okt | Nov | Dez | Σ Jahr |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| EINNAHMEN (BRUTTO) | |||||||||||||
| Unterhaltsreinigung19% | 24.871 | 24.871 | 26.180 | 27.489 | 26.180 | 26.180 | 23.562 | 23.562 | 26.180 | 27.489 | 27.489 | 28.798 | 312.851 |
| Glasreinigung19% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Sonderreinigung19% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Facility Services19% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Summe Einnahmen | 24.871 | 24.871 | 26.180 | 27.489 | 26.180 | 26.180 | 23.562 | 23.562 | 26.180 | 27.489 | 27.489 | 28.798 | 312.851 |
| USt vereinnahmt | 3.971 | 3.971 | 4.180 | 4.389 | 4.180 | 4.180 | 3.762 | 3.762 | 4.180 | 4.389 | 4.389 | 4.598 | 49.951 |
| VARIABLE KOSTEN (BRUTTO) | |||||||||||||
| Reinigungsmittel19% | 2.985 | 2.985 | 3.142 | 3.299 | 3.142 | 3.142 | 2.827 | 2.827 | 3.142 | 3.299 | 3.299 | 3.456 | 37.545 |
| Personal (Reinigungskräfte) | 11.495 | 11.495 | 12.100 | 12.705 | 12.100 | 12.100 | 10.890 | 10.890 | 12.100 | 12.705 | 12.705 | 13.310 | 144.595 |
| Fahrzeugkosten19% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Summe Variable Kosten | 14.480 | 14.480 | 15.242 | 16.004 | 15.242 | 15.242 | 13.717 | 13.717 | 15.242 | 16.004 | 16.004 | 16.766 | 182.140 |
| Vorsteuer variabel | 477 | 477 | 502 | 527 | 502 | 502 | 451 | 451 | 502 | 527 | 527 | 552 | 5.997 |
| FIXKOSTEN (BRUTTO) | |||||||||||||
| Lagermiete | 800 | 800 | 800 | 800 | 800 | 800 | 800 | 800 | 800 | 800 | 800 | 800 | 9.600 |
| Nebenkosten19% | 238 | 238 | 238 | 238 | 238 | 238 | 238 | 238 | 238 | 238 | 238 | 238 | 2.856 |
| Versicherungen | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 4.800 |
| Marketing19% | 238 | 238 | 238 | 238 | 238 | 238 | 238 | 238 | 238 | 238 | 238 | 238 | 2.856 |
| Steuerberater19% | 357 | 357 | 357 | 357 | 357 | 357 | 357 | 357 | 357 | 357 | 357 | 357 | 4.284 |
| Sonstige Fixkosten19% | 357 | 357 | 357 | 357 | 357 | 357 | 357 | 357 | 357 | 357 | 357 | 357 | 4.284 |
| Kredit-Tilgung | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 3.600 |
| Summe Fixkosten | 2.690 | 2.690 | 2.690 | 2.690 | 2.690 | 2.690 | 2.690 | 2.690 | 2.690 | 2.690 | 2.690 | 2.690 | 32.280 |
| Vorsteuer fix | 190 | 190 | 190 | 190 | 190 | 190 | 190 | 190 | 190 | 190 | 190 | 190 | 2.280 |
| Gesamtausgaben (brutto) | 17.170 | 17.170 | 17.932 | 18.694 | 17.932 | 17.932 | 16.407 | 16.407 | 17.932 | 18.694 | 18.694 | 19.456 | 214.420 |
| UMSATZSTEUER (Monatlich) | |||||||||||||
| USt-Zahllast (USt − Vorsteuer) | 3.304 | 3.304 | 3.488 | 3.672 | 3.488 | 3.488 | 3.121 | 3.121 | 3.488 | 3.672 | 3.672 | 3.856 | 41.674 |
| USt-Zahlung (Liquiditätswirksam) | 0 | 3.304 | 3.304 | 3.488 | 3.672 | 3.488 | 3.488 | 3.121 | 3.121 | 3.488 | 3.672 | 3.672 | 37.818 |
| Monatssaldo | 7.701 | 7.701 | 8.248 | 8.795 | 8.248 | 8.248 | 7.155 | 7.155 | 8.248 | 8.795 | 8.795 | 9.342 | 98.431 |
| Liquidität kumulativ | 15.701 | 20.098 | 25.042 | 30.349 | 34.925 | 39.685 | 43.352 | 47.386 | 52.513 | 57.820 | 62.943 | 68.613 | 68.613 |