kati1337
2020-11-25 12:51:57
- #1
I made you a screenshot of our table (cleared) here. Of course, you have to know if items will be added or removed for you. In the "Soll" column, I always had my calculation for an item. The "Ist" column was filled when there was a concrete offer/invoice for it, and then I deleted the Soll entry or moved it to the "Plan" column. The Plan column had no further significance, except that I could track where Plan/Actual diverged.
At the bottom, it calculates the target costs (everything still in the "Soll" column) and the actual costs (everything in the "Ist" column), and deducts that from the capital/money received. What is missing in my table (for most clients) are, for example, garden work/outdoor area. Or whatever else you might be missing. ;) In every field, I marked in green if an item was already paid or disbursed.
That always gave me a good overview of where we stand.

At the bottom, it calculates the target costs (everything still in the "Soll" column) and the actual costs (everything in the "Ist" column), and deducts that from the capital/money received. What is missing in my table (for most clients) are, for example, garden work/outdoor area. Or whatever else you might be missing. ;) In every field, I marked in green if an item was already paid or disbursed.
That always gave me a good overview of where we stand.