Difference between revisions of "Financials"

From Technologia Incognita
Jump to: navigation, search
m (Tax)
Line 1: Line 1:
Our monthly expenses are fixed. We pay €1.095,73 a month for rent.
+
The following is a print-out of our administration, reconciled with the bank statements. I aim to keep this updated monthly.
  
Our income fluctuates more wildly, but from the data the bank gives the following figures can be extracted for the last 6 or so months (NOT ADJUSTED FOR TAX):
+
Note that because of the way double-entry accounting works, the signs are inverted from what you might be used to. Expenses are positive, and income is negative. This means that a negative subtotal is a net positive to our assets.
  
 
+
<pre>
===April 2013===
+
Date                            Account                Amount    Subtotal
 
+
2012/04/01 - 2012/04/30        Expenses:Bank              €2.50      €2.50
Ingoing: € 1.135,69
+
                                Income:Members          €-120.00  €-117.50
 
+
2012/05/01 - 2012/05/31        Expenses:Admin            €50.72    €-66.78
Outgoing: € 1.095,73
+
                                Expenses:Bank              €2.50    €-64.28
 
+
                                Expenses:Other            €167.05    €102.77
 
+
                                Ex:Rent:Mediamatic        €400.00    €502.77
===May 2013===
+
                                Expenses:Tax              €61.00    €563.77
 
+
                                Income:Donations        €-124.23    €439.54
Incoming: € 1.900,80
+
                                Income:Members          €-3001.49  €-2561.95
 
+
2012/06/01 - 2012/06/30        Expenses:Bank              €2.50  €-2559.45
Outgoing: € 1.095,73
+
                                Ex:Rent:Mediamatic        €400.00  €-2159.45
 
+
                                Income:Members          €-721.99  €-2881.44
 
+
2012/07/01 - 2012/07/31        Expenses:Bank              €2.50  €-2878.94
===June 2013===
+
                                Ex:Rent:Mediamatic        €400.00  €-2478.94
 
+
                                Expenses:Tax              €562.00  €-1916.94
Incoming: € 2.287,99
+
                                Income:Donations        €-333.00  €-2249.94
 
+
                                Income:Members          €-594.99  €-2844.93
Outgoing: € 1.095,73
+
2012/08/01 - 2012/08/31        Ex:Rent:Mediamatic        €400.00  €-2444.93
 
+
                                Income:Members          €-352.49  €-2797.42
 
+
2012/09/01 - 2012/09/30        Expenses:Bank              €2.50  €-2794.92
===July 2013===
+
                                Expenses:Club-Mate        €241.10  €-2553.82
 
+
                                Expenses:Other            €138.41  €-2415.41
Incoming: € 1.658,16
+
                                Ex:Rent:Mediamatic        €400.00  €-2015.41
 
+
                                Income:Members          €-1099.99  €-3115.40
Outgoing: € 1.095,73
+
2012/10/01 - 2012/10/31        Expenses:Bank              €2.50  €-3112.90
 
+
                                Ex:Rent:Mediamatic        €400.00  €-2712.90
 
+
                                Expenses:Rent:UR        €1100.07  €-1612.83
===August 2013===
+
                                Expenses:Tax              €197.00  -1415.83
 
+
                                Income:Donations        €-300.00  €-1715.83
Incoming: € 772,49
+
                                Income:Members          €-1076.99  -2792.82
 
+
2012/11/01 - 2012/11/30        Expenses:Bank              €2.50  €-2790.32
Outgoing: € 1.095,73
+
                                Expenses:Rent:UR        €1100.07  €-1690.25
 
+
                                Income:Members          €-803.14  €-2493.39
 
+
2012/12/01 - 2012/12/31        Expenses:Bank              €2.50  €-2490.89
===September 2013===
+
                                Expenses:Fobs            €199.65  -2291.24
 
+
                                Expenses:Rent:UR          €978.47  €-1312.77
Incoming: € 1.509,99
+
                                Income:Donations        €-170.00  -1482.77
 
+
                                Income:Members          €-956.99  €-2439.76
Outgoing: € 1.095,73
+
                                Income:Other              €-15.00  €-2454.76
 
+
2013/01/01 - 2013/01/31        Expenses:Bank              €2.66  €-2452.10
 
+
                                Expenses:Rent:UR        €1059.53  €-1392.57
===October 2013===
+
                                Income:Interest          €-13.99  €-1406.56
 
+
                                Income:Members          -579.99 €-1986.55
Incoming: € 1.069,99 (so far)
+
                                Income:Other              €-20.00  €-2006.55
 
+
                                Income:Pledges            €-50.00  -2056.55
Outgoing: € 1.095,73
+
2013/02/01 - 2013/02/28        Expenses:Bank              €13.01  €-2043.54
 
+
                                Expenses:Fobs              €18.15  €-2025.39
 
+
                                Expenses:Rent:UR        €1059.53  €-965.86
 
+
                                Income:Members          €-1436.99  €-2402.85
 
+
2013/03/01 - 2013/03/30        Expenses:Bank              €13.01  €-2389.84
It's rather difficult to draw any conclusions from this, mostly because sometimes people pay multiple months in one go or don't pay.
+
                                Expenses:Fobs            €363.00  €-2026.84
We are working on fixing this and will update this page with new information as soon as its calculated (including data for previous months).
+
                                Expenses:Rent:UR        €2125.11    €98.27
 +
                                Expenses:Tax            €-568.00  €-469.73
 +
                                Income:Donations        €-750.00  -1219.73
 +
                                Income:Members          €-725.99  €-1945.72
 +
2013/04/01 - 2013/04/30        Expenses:Bank              €12.01  -1933.71
 +
                                Income:Collective        €-31.70  €-1965.41
 +
                                Income:Members          €-1103.99  €-3069.40
 +
2013/05/01 - 2013/05/31        Expenses:Bank              €12.01  €-3057.39
 +
                                Expenses:Club-Mate        €867.96  €-2189.43
 +
                                Expenses:Collective        €10.04  -2179.39
 +
                                Expenses:Fobs            €181.50  €-1997.89
 +
                                Expenses:Pledges          €50.00  -1947.89
 +
                                Expenses:Rent:UR        €2119.06    €171.17
 +
                                Income:Collective        €-18.81    €152.36
 +
                                Income:Members          €-881.99  €-729.63
 +
2013/06/01 - 2013/06/30        Expenses:Bank              €10.01  €-719.62
 +
                                Expenses:Club-Mate        €-48.00  €-767.62
 +
                                Expenses:Rent:UR        €1095.73    €328.11
 +
                                Expenses:Tax              €-32.00    €296.11
 +
                                Income:Donations        €-760.00  -463.89
 +
                                Income:Members          €-1327.99 €-1791.88
 +
2013/07/01 - 2013/07/31        Expenses:Admin            €11.00  €-1780.88
 +
                                Expenses:Bank              €12.01  €-1768.87
 +
                                Expenses:Collective        €55.50  -1713.37
 +
                                Expenses:Rent:UR        €1095.73   €-617.64
 +
                                Income:Donations        €-300.00  €-917.64
 +
                                Income:Members          €-1358.16  €-2275.80
 +
2013/08/01 - 2013/08/31        Expenses:Bank              €12.01  €-2263.79
 +
                                Expenses:Keys              €45.00  €-2218.79
 +
                                Expenses:Phone            €15.25  €-2203.54
 +
                                Expenses:Tax              €464.00  €-1739.54
 +
                                Income:Members          €-772.49  €-2512.03
 +
2013/09/01 - 2013/09/30        Expenses:Bank              €12.01  €-2500.02
 +
                                Expenses:Fobs            €181.50  €-2318.52
 +
                                Expenses:Rent:UR        €2191.46  -127.06
 +
                                Income:Members          €-1509.99 €-1637.05
 +
2013/10/01 - 2013/10/31        Expenses:Bank              €12.01  €-1625.04
 +
                                Expenses:Fobs            €181.50  -1443.54
 +
                                Expenses:Rent:UR        €1101.78  €-341.76
 +
                                Income:Members          €-1382.99  €-1724.75
 +
2013/11/01 - 2013/11/28        Expenses:Bank              €12.01  €-1712.74
 +
                                Expenses:Fobs            €181.50  €-1531.24
 +
                                Expenses:Rent:UR          €121.75  €-1409.49
 +
                                Expenses:Tax              €39.00  €-1370.49
 +
                                Income:Members          €-1048.96  €-2419.45
 +
</pre>

Revision as of 12:13, 24 December 2013

The following is a print-out of our administration, reconciled with the bank statements. I aim to keep this updated monthly.

Note that because of the way double-entry accounting works, the signs are inverted from what you might be used to. Expenses are positive, and income is negative. This means that a negative subtotal is a net positive to our assets.

Date                            Account                 Amount     Subtotal
2012/04/01 - 2012/04/30         Expenses:Bank               €2.50      €2.50
                                Income:Members           €-120.00   €-117.50
2012/05/01 - 2012/05/31         Expenses:Admin             €50.72    €-66.78
                                Expenses:Bank               €2.50    €-64.28
                                Expenses:Other            €167.05    €102.77
                                Ex:Rent:Mediamatic        €400.00    €502.77
                                Expenses:Tax               €61.00    €563.77
                                Income:Donations         €-124.23    €439.54
                                Income:Members          €-3001.49  €-2561.95
2012/06/01 - 2012/06/30         Expenses:Bank               €2.50  €-2559.45
                                Ex:Rent:Mediamatic        €400.00  €-2159.45
                                Income:Members           €-721.99  €-2881.44
2012/07/01 - 2012/07/31         Expenses:Bank               €2.50  €-2878.94
                                Ex:Rent:Mediamatic        €400.00  €-2478.94
                                Expenses:Tax              €562.00  €-1916.94
                                Income:Donations         €-333.00  €-2249.94
                                Income:Members           €-594.99  €-2844.93
2012/08/01 - 2012/08/31         Ex:Rent:Mediamatic        €400.00  €-2444.93
                                Income:Members           €-352.49  €-2797.42
2012/09/01 - 2012/09/30         Expenses:Bank               €2.50  €-2794.92
                                Expenses:Club-Mate        €241.10  €-2553.82
                                Expenses:Other            €138.41  €-2415.41
                                Ex:Rent:Mediamatic        €400.00  €-2015.41
                                Income:Members          €-1099.99  €-3115.40
2012/10/01 - 2012/10/31         Expenses:Bank               €2.50  €-3112.90
                                Ex:Rent:Mediamatic        €400.00  €-2712.90
                                Expenses:Rent:UR         €1100.07  €-1612.83
                                Expenses:Tax              €197.00  €-1415.83
                                Income:Donations         €-300.00  €-1715.83
                                Income:Members          €-1076.99  €-2792.82
2012/11/01 - 2012/11/30         Expenses:Bank               €2.50  €-2790.32
                                Expenses:Rent:UR         €1100.07  €-1690.25
                                Income:Members           €-803.14  €-2493.39
2012/12/01 - 2012/12/31         Expenses:Bank               €2.50  €-2490.89
                                Expenses:Fobs             €199.65  €-2291.24
                                Expenses:Rent:UR          €978.47  €-1312.77
                                Income:Donations         €-170.00  €-1482.77
                                Income:Members           €-956.99  €-2439.76
                                Income:Other              €-15.00  €-2454.76
2013/01/01 - 2013/01/31         Expenses:Bank               €2.66  €-2452.10
                                Expenses:Rent:UR         €1059.53  €-1392.57
                                Income:Interest           €-13.99  €-1406.56
                                Income:Members           €-579.99  €-1986.55
                                Income:Other              €-20.00  €-2006.55
                                Income:Pledges            €-50.00  €-2056.55
2013/02/01 - 2013/02/28         Expenses:Bank              €13.01  €-2043.54
                                Expenses:Fobs              €18.15  €-2025.39
                                Expenses:Rent:UR         €1059.53   €-965.86
                                Income:Members          €-1436.99  €-2402.85
2013/03/01 - 2013/03/30         Expenses:Bank              €13.01  €-2389.84
                                Expenses:Fobs             €363.00  €-2026.84
                                Expenses:Rent:UR         €2125.11     €98.27
                                Expenses:Tax             €-568.00   €-469.73
                                Income:Donations         €-750.00  €-1219.73
                                Income:Members           €-725.99  €-1945.72
2013/04/01 - 2013/04/30         Expenses:Bank              €12.01  €-1933.71
                                Income:Collective         €-31.70  €-1965.41
                                Income:Members          €-1103.99  €-3069.40
2013/05/01 - 2013/05/31         Expenses:Bank              €12.01  €-3057.39
                                Expenses:Club-Mate        €867.96  €-2189.43
                                Expenses:Collective        €10.04  €-2179.39
                                Expenses:Fobs             €181.50  €-1997.89
                                Expenses:Pledges           €50.00  €-1947.89
                                Expenses:Rent:UR         €2119.06    €171.17
                                Income:Collective         €-18.81    €152.36
                                Income:Members           €-881.99   €-729.63
2013/06/01 - 2013/06/30         Expenses:Bank              €10.01   €-719.62
                                Expenses:Club-Mate        €-48.00   €-767.62
                                Expenses:Rent:UR         €1095.73    €328.11
                                Expenses:Tax              €-32.00    €296.11
                                Income:Donations         €-760.00   €-463.89
                                Income:Members          €-1327.99  €-1791.88
2013/07/01 - 2013/07/31         Expenses:Admin             €11.00  €-1780.88
                                Expenses:Bank              €12.01  €-1768.87
                                Expenses:Collective        €55.50  €-1713.37
                                Expenses:Rent:UR         €1095.73   €-617.64
                                Income:Donations         €-300.00   €-917.64
                                Income:Members          €-1358.16  €-2275.80
2013/08/01 - 2013/08/31         Expenses:Bank              €12.01  €-2263.79
                                Expenses:Keys              €45.00  €-2218.79
                                Expenses:Phone             €15.25  €-2203.54
                                Expenses:Tax              €464.00  €-1739.54
                                Income:Members           €-772.49  €-2512.03
2013/09/01 - 2013/09/30         Expenses:Bank              €12.01  €-2500.02
                                Expenses:Fobs             €181.50  €-2318.52
                                Expenses:Rent:UR         €2191.46   €-127.06
                                Income:Members          €-1509.99  €-1637.05
2013/10/01 - 2013/10/31         Expenses:Bank              €12.01  €-1625.04
                                Expenses:Fobs             €181.50  €-1443.54
                                Expenses:Rent:UR         €1101.78   €-341.76
                                Income:Members          €-1382.99  €-1724.75
2013/11/01 - 2013/11/28         Expenses:Bank              €12.01  €-1712.74
                                Expenses:Fobs             €181.50  €-1531.24
                                Expenses:Rent:UR          €121.75  €-1409.49
                                Expenses:Tax               €39.00  €-1370.49
                                Income:Members          €-1048.96  €-2419.45