4.2012 0831 - Cash Flow - report

Page 1

12 month Actual Cash report

01-Sep-12

Stichting AIESEC International All figures in EUR Operational Account (ABN AMRO) Savings Account (ABN AMRO) Deposit Account (ABN AMRO) Investment Account (ABN AMRO) Foreign Currency Account (ABN AMRO) Operational Cash Account (Van Lanschot) Investment Account Cash (Van Lanschot) Investment Account Bonds (Van Lanschot) Petty Cash (EUR) Total Cash beginning of month Cash Receipts: Corporate Partnerships (long term contracts) Corporate sales (short term) MC fees MC balance items MC debt repayment Grants and funds Corporate ` Deductions Other VAT Payroll Tax returns Deposits Financial Interest Total cash receipts Cash Dispbursementss: Employee Salaries and loans (without inkinds) Employee Housing and Internet Employee Health Insurance Employee Legal and admin costs Employee Relocation and Moving Allowance Payroll taxes Global IM systems Other IM costs Office Rent Office Electricity Internet and Telephone Other Office costs Printing costs Travel Insurance Travel costs Conference costs SG expenses IA expenses EA expenses Transition Team and planning days Bookkeeping Bank fees and transaction costs Legal costs Stichting Legal and Admin costs Other running expenses Local and regional taxes and fees VAT Financial Interest Debt repayment AI investments (funds) Global and regional Funds payouts MC balance payments Total cash disbursements Monthly Cash Flow Incoming cash flow Outgoing cash flow Net Cash from Operations

Sum Total Cash - Beginning Month Net Cash From Operations Cash End of Month

Actual Sep-11 358,534.82 944,930.95 32.94 32,407.20 -161.79 13,647.64 392,781.74 24,714.40 1,766,887.90

Actual Oct-11 309,307.69 944,931.06 7,260.48 32.94 34,482.40 -214.10 13,647.64 399,758.40 11,626.38 1,720,832.89

Actual Nov-11 242,641.05 948,975.62 7,263.17 32.94 33,134.00 -224.10 13,647.64 399,758.40 4,926.13 1,650,154.85

Actual Dec-11 131,477.31 948,975.62 7,263.17 32.94 37,032.30 -234.10 13,647.64 399,758.40 7,515.51 1,545,468.79

Actual Jan-12 66,967.29 948,975.67 7,263.17 34.60 36,584.50 -289.98 14,097.95 399,706.28 7,175.01 1,480,514.49

Actual Feb-12 118,528.96 1,100,000.06 7,295.90 34.60 46,053.90 200.02 13,597.95 399,706.28 6,146.37 1,691,564.04

Actual Mar-12 237,006.57 1,100,000.06 7,295.90 34.60 51,052.10 190.02 13,597.95 399,706.28 12,391.84 1,821,275.32

Actual Apr-12 182,572.21 1,100,000.11 7,295.90 34.60 51,406.90 142.40 13,519.20 414,785.29 11,363.84 1,781,120.45

30,000.00 7,988.00 406.50 251.90

26,600.00 3,898.30 1,490.00

1,280.00 33,489.00 21,378.35 3,464.89 443.00

169,718.87 13,791.89 114,490.94

90,785.00 12,738.20 92,631.77

4,940.00 26,030.00

28,800.00 36,157.00

1,000.00

9,703.00 1,000.00

176.32

3,000.00

3,804.97

461.80 2,650.99 15,398.00

4,680.01

170.00 2,482.13

3,500.00

3,383.34

75.18 8,458.00

9.00 6,976.77

4,047.25

10,958.06

47,373.66

20,366.09 7,489.42 1,947.11 2,400.00 2,899.95

82.11 2,941.31

4,283.12

53,499.09

63,168.39

305,668.16

14,228.38 7,489.42 2,173.28

15,178.92 7,440.42 1,100.70

16,316.00 7,538.42 994.20

29,771.00

13,164.00 92,287.59 82.11 2,941.31 600.00 2,338.90 585.52

656.34 63.69

959.44 1,939.36 751.00

17,945.58 3,503.44 565.16

8,847.97

137.12

4,563.64

1,348.40

916.62 285.60

9,740.00 344,953.16 5,660.00 1,400.00

55,000.00 18,574.00 740.00 1,000.00

21,787.22 13,160.00 141,037.24 250.00 9,796.38

4.58

1,768.06

380.00 2,747.43

1,376.10 9,359.00 29,836.00

1,082.50 212.95 8,802.00 10,730.00

0.05

6,030.69

208,188.15

91,599.58

82,826.02

171,447.77

77,082.11

225,024.96

382,580.61

1,719,416.56

14,101.09 7,745.32 3,258.84 140.00

14,762.61 7,587.36 1,226.45 140.00

14,845.26 7,587.36 1009.95

15,430.21 7,587.36 554.65

31,014.12 7,494.60 940.50

9,291.99

761.55 288.62

9,291.00 73,125.43 109.74 3,007.85 295.00 581.91 95.77

9,291.00 24,948.76 82.11 3,007.85 295.00 849.77 98.69

21,675.88 7,733.69 9,554.27 5,400.00 6,685.30 12,389.00 10,170.93 82.11 3,007.85 315.00 1,642.69 138.08

31,735.64 7,733.69 11,798.67

10,501.00 21,646.10 752.11 3,074.39 630.00 1,814.87 98.44

15,387.97 7,440.42 3,560.35 125.02 18,113.60 9,291.00 52,078.23 82.11 3,007.85 417.46 1,680.86 804.88

8,662.13

5,141.56

3,582.73 14,965.95

11475.6 22.94 938.50 1,064.20

1104.17 5,385.36

26,706.62 82.11 2,941.31

82.11 3,007.85 295.00 701.27 265.78

259.14 5,859.16

521.10 2,407.94

153.34 3,460.76 4,393.73

3,884.64 214.41 246.22 8,252.06 551.80 165.51

300.00 6,872.46 74.60

665.48 3,613.44

48.16 3,391.50 472.85

13,251.89 1,917.00 394.98

5,402.60 110.64

376.38 969.85 103.62 950.51

361.09 466.36

4,499.15 168.00

52.12

7,157.92

5,617.47 276.88

530,632.56 204,266.39 718,507.96 40,187.84 27,347.37 0.00 380.00 6,234.37 28,049.70 42,017.00 75,283.00 0.00 46,510.37

3,393.00

57.41

244.84 1,558.90

1,715.63

3,069.27

1,384.98

1,418.91

13,304.20 2,117.90 30,363.00

225,042.17 90,867.48 38,118.97 8,205.02 35,126.86 162,810.99 321,305.52 3,808.64 35,894.58 3,782.46 16,264.48 4,396.31 2,344.32 2,609.14 86,583.61 41,624.67 5,100.63 5,629.85 0.00 904.80 11,251.53 26,320.02 2,069.79 30,074.19 48.16 26,195.81 1,558.32 17,427.00 40,447.09 40,000.00 76,558.68 67,588.25 38,557.98

5,114.06 9,291.00 10,170.93 82.11 3,007.85 315.00 2,062.32 218.54 105.45

821.7 8,339.62 739.05

1,192.92 904.80 5,341.03

50.00

2,313.95 50,530.00 10,170.93 82.11 3,007.85 315.00 1,419.73 1,175.12 2,238.87 2,350.00 8931.68 5,551.00 443.82 964.79

1,159.48 10,817.10 113.96

17,427.00

9,816.49

Actual Total End Period 407,333.44 1,111,762.94 7,353.73 34.60 62,161.26 122.40 13,519.20 374,390.32 41,109.25 2,017,787.14

5,789.92

140.00 643.02 70.12 5,060.98

Actual Aug-12 253,519.90 1,111,762.94 7,353.73 34.60 62,161.26 122.40 13,519.20 374,390.32 12,365.65 1,835,230.00

15,537.55

747.02

1,400.58 92.44 7,177.54

Actual Jul-12 142,877.83 1,105,761.22 7,324.76 34.60 55,118.20 122.40 13,519.20 374,390.32 6,093.60 1,705,242.13

101,721.47 28,700.00 2,120.00 20,118.05 6,031.67

34,708.00

452.02

2,207.80 2,941.31 305.00 1,754.27 563.18

9,384.03

Actual Actual - End FY May-12 Jun-12 120,554.49 152,089.52 1,105,761.17 1,105,761.17 7,324.76 7,324.76 34.60 34.60 51,725.20 55,118.20 132.40 122.40 13,519.20 13,519.20 414,785.29 374,390.32 11,557.84 8,872.65 1,725,394.95 1,717,232.82

48,238.84 7,392.94

40,394.97 5,390.21 4,081.00

3,197.92 7,919.00 764.13

2,900.00 8,035.11

40,000.00 830.66 10,071.93 3,598.97

2,696.85 3,959.58 3,555.00

57,013.07

118,051.70

158,185.15

128,122.69

94,618.61

78,476.87

131,754.45

138,551.52

179,609.90

89,072.80

95,037.09

200,023.47

1,468,517.32

-46,055.01

-70,678.04

-104,686.06

-64,954.30

211,049.55

129,711.28

-40,154.87

-55,725.50

-8,162.13

-11,990.69

129,987.87

182,557.14

250,899.24

10,958.06 -57,013.07 -46,055.01

47,373.66 -118,051.70 -70,678.04

53,499.09 -158,185.15 -104,686.06

63,168.39 -128,122.69 -64,954.30

305,668.16 -94,618.61 211,049.55

208,188.15 -78,476.87 129,711.28

91,599.58 -131,754.45 -40,154.87

82,826.02 -138,551.52 -55,725.50

171,447.77 -179,609.90 -8,162.13

77,082.11 -89,072.80 -11,990.69

225,024.96 -95,037.09 129,987.87

382,580.61 -200,023.47 182,557.14

1,719,416.56 -1,468,517.32 250,899.24

1,766,887.90 -46,055.01 1,720,832.89

1,720,832.89 -70,678.04 1,650,154.85

1,650,154.85 -104,686.06 1,545,468.79

1,545,468.79 -64,954.30 1,480,514.49

1,480,514.49 211,049.55 1,691,564.04

1,691,564.04 129,711.28 1,821,275.32

1,821,275.32 -40,154.87 1,781,120.45

1,781,120.45 -55,725.50 1,725,394.95

1,725,394.95 -8,162.13 1,717,232.82

1,717,232.82 -11,990.69 1,705,242.13

1,705,242.13 129,987.87 1,835,230.00

1,835,230.00 182,557.14 2,017,787.14

1,448,967.33 250,899.24 1,699,866.57


Turn static files into dynamic content formats.

Create a flipbook
Issuu converts static files into: digital portfolios, online yearbooks, online catalogs, digital photo albums and more. Sign up and create your flipbook.