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) | |||||||||||||
| Shop-Umsatz19% | 44.625 | 41.650 | 47.600 | 50.575 | 53.550 | 53.550 | 50.575 | 50.575 | 56.525 | 65.450 | 83.300 | 95.200 | 693.175 |
| Marktplätze (Amazon etc.)19% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| B2B-Verkäufe19% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Sonstige19% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Summe Einnahmen | 44.625 | 41.650 | 47.600 | 50.575 | 53.550 | 53.550 | 50.575 | 50.575 | 56.525 | 65.450 | 83.300 | 95.200 | 693.175 |
| USt vereinnahmt | 7.125 | 6.650 | 7.600 | 8.075 | 8.550 | 8.550 | 8.075 | 8.075 | 9.025 | 10.450 | 13.300 | 15.200 | 110.675 |
| VARIABLE KOSTEN (BRUTTO) | |||||||||||||
| Wareneinkauf19% | 20.081 | 18.743 | 21.420 | 22.759 | 24.098 | 24.098 | 22.759 | 22.759 | 25.436 | 29.453 | 37.485 | 42.840 | 311.931 |
| Personal (Lager/Versand) | 5.625 | 5.250 | 6.000 | 6.375 | 6.750 | 6.750 | 6.375 | 6.375 | 7.125 | 8.250 | 10.500 | 12.000 | 87.375 |
| Versandkosten19% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Zahlungsgebühren19% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Summe Variable Kosten | 25.706 | 23.993 | 27.420 | 29.134 | 30.848 | 30.848 | 29.134 | 29.134 | 32.561 | 37.703 | 47.985 | 54.840 | 399.306 |
| Vorsteuer variabel | 3.206 | 2.993 | 3.420 | 3.634 | 3.848 | 3.848 | 3.634 | 3.634 | 4.061 | 4.703 | 5.985 | 6.840 | 49.806 |
| FIXKOSTEN (BRUTTO) | |||||||||||||
| Lagermiete | 1.500 | 1.500 | 1.500 | 1.500 | 1.500 | 1.500 | 1.500 | 1.500 | 1.500 | 1.500 | 1.500 | 1.500 | 18.000 |
| Nebenkosten19% | 476 | 476 | 476 | 476 | 476 | 476 | 476 | 476 | 476 | 476 | 476 | 476 | 5.712 |
| Versicherungen | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 3.600 |
| Marketing/Ads19% | 3.570 | 3.570 | 3.570 | 3.570 | 3.570 | 3.570 | 3.570 | 3.570 | 3.570 | 3.570 | 3.570 | 3.570 | 42.840 |
| Steuerberater19% | 595 | 595 | 595 | 595 | 595 | 595 | 595 | 595 | 595 | 595 | 595 | 595 | 7.140 |
| Shop-Software19% | 595 | 595 | 595 | 595 | 595 | 595 | 595 | 595 | 595 | 595 | 595 | 595 | 7.140 |
| Kredit-Tilgung | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 6.000 |
| Summe Fixkosten | 7.536 | 7.536 | 7.536 | 7.536 | 7.536 | 7.536 | 7.536 | 7.536 | 7.536 | 7.536 | 7.536 | 7.536 | 90.432 |
| Vorsteuer fix | 836 | 836 | 836 | 836 | 836 | 836 | 836 | 836 | 836 | 836 | 836 | 836 | 10.032 |
| Gesamtausgaben (brutto) | 33.242 | 31.529 | 34.956 | 36.670 | 38.384 | 38.384 | 36.670 | 36.670 | 40.097 | 45.239 | 55.521 | 62.376 | 489.738 |
| UMSATZSTEUER (Monatlich) | |||||||||||||
| USt-Zahllast (USt − Vorsteuer) | 3.083 | 2.821 | 3.344 | 3.605 | 3.866 | 3.866 | 3.605 | 3.605 | 4.128 | 4.911 | 6.479 | 7.524 | 50.837 |
| USt-Zahlung (Liquiditätswirksam) | 0 | 3.083 | 2.821 | 3.344 | 3.605 | 3.866 | 3.866 | 3.605 | 3.605 | 4.128 | 4.911 | 6.479 | 43.313 |
| Monatssaldo | 11.383 | 10.121 | 12.644 | 13.905 | 15.166 | 15.166 | 13.905 | 13.905 | 16.428 | 20.211 | 27.779 | 32.824 | 203.437 |
| Liquidität kumulativ | 36.383 | 43.421 | 53.244 | 63.805 | 75.366 | 86.666 | 96.705 | 107.005 | 119.828 | 135.911 | 158.779 | 185.124 | 185.124 |