A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | ||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Budget Variance | ||||||||||||||||
2 | One for the World | ||||||||||||||||
3 | |||||||||||||||||
4 | |||||||||||||||||
5 | Jul-21 | Aug-21 | Sep-21 | Oct-21 | Nov-21 | Dec-21 | Jan-22 | Feb-22 | Mar-22 | Apr-22 | May-22 | Jun-22 | YTD | ||||
6 | |||||||||||||||||
7 | Revenue | ||||||||||||||||
8 | Bank Interest | $13.35 | $22.17 | $20.40 | $18.97 | $13.55 | $6.67 | $6.33 | $12.62 | $114.06 | |||||||
9 | Corporate Donations - Unrestricted | $13.82 | $100.00 | $0.00 | $113.82 | ||||||||||||
10 | Grants - Unrestricted | $260,798.00 | $204.75 | $0.00 | $0.00 | $2,000.00 | $15,000.00 | $278,002.75 | |||||||||
11 | Individual Donations - Unrestricted | $206,977.75 | $12.00 | $615.00 | $10,043.00 | $341.69 | $31,040.00 | $4,377.75 | $1,690.23 | $11,050.00 | $20,000.00 | $286,147.42 | |||||
12 | Sales Income | $244.54 | $325.50 | $69.75 | $23.25 | $663.04 | |||||||||||
13 | Total Revenue | $467,789.10 | $238.92 | $635.40 | $10,306.51 | $2,694.56 | $31,146.67 | $19,453.83 | $1,726.10 | $0.00 | $11,050.00 | $0.00 | $20,000.00 | $565,041.09 | |||
14 | |||||||||||||||||
15 | Less Cost of Sales | ||||||||||||||||
16 | Cost of Goods Sold | $203.57 | $281.13 | $42.30 | $20.50 | $547.50 | |||||||||||
17 | Reconciliation Discrepancy | $2.44 | $2.44 | ||||||||||||||
18 | Total Cost of Sales | $0.00 | $0.00 | $0.00 | $203.57 | $281.13 | $0.00 | $42.30 | $22.94 | $0.00 | $0.00 | $0.00 | $0.00 | $549.94 | |||
19 | Gross Profit | $467,789.10 | $238.92 | $635.40 | $10,102.94 | $2,413.43 | $31,146.67 | $19,411.53 | $1,703.16 | $0.00 | $11,050.00 | $0.00 | $20,000.00 | $564,491.15 | |||
20 | |||||||||||||||||
21 | Operating Expenses | ||||||||||||||||
22 | Accommodation | $0.00 | $0.00 | $2,137.96 | $0.00 | $746.90 | $1,749.99 | $0.00 | $650.28 | -$5,285.13 | HQ operating costs | ||||||
23 | Bank Service Charges | $77.20 | $6.02 | $31.34 | $37.47 | $44.92 | $25.00 | $10.23 | -$232.18 | HQ operating costs | |||||||
24 | Business License & Fees | $100.00 | $4.07 | $25.00 | $110.00 | $301.50 | $225.00 | -$765.57 | HQ operating costs | ||||||||
25 | Organization Insurance | $0.00 | $0.00 | $0.00 | $431.18 | $496.00 | $380.00 | $495.00 | -$1,802.18 | HQ operating costs | |||||||
26 | Postage & Delivery (6240) | $0.00 | $5.79 | $128.20 | $1.16 | $17.18 | $1.74 | -$154.07 | HQ operating costs | ||||||||
27 | Professional Fees | $825.00 | $0.00 | $750.00 | $750.00 | $1,200.00 | $1,435.00 | $2,270.00 | -$7,230.00 | Staff & on costs | |||||||
28 | Repairs & Maintenance (6640) | $0.00 | $0.00 | $0.00 | HQ operating costs | ||||||||||||
29 | Staff Training & Development (6400) | $0.00 | $0.00 | $985.27 | $937.00 | $88.00 | -$2,010.27 | Staff & on costs | |||||||||
30 | Team Meals & Entertainment | $79.98 | $40.00 | $397.91 | $0.00 | $232.57 | $418.94 | $365.41 | -$1,534.81 | HQ operating costs | |||||||
31 | Total Operating Expenses | $1,082.18 | $55.88 | $2,592.21 | $1,025.67 | $2,508.23 | $4,371.38 | $2,397.00 | $4,106.66 | $380.00 | $0.00 | $495.00 | $0.00 | -$19,014.21 | |||
32 | |||||||||||||||||
33 | Operating Income / (Loss) | $466,706.92 | $183.04 | -$1,956.81 | $9,077.27 | -$94.80 | $26,775.29 | $17,014.53 | -$2,403.50 | -$380.00 | $11,050.00 | -$495.00 | $20,000.00 | $545,476.94 | |||
34 | |||||||||||||||||
35 | Other Income and Expense | ||||||||||||||||
36 | Advertising | $0.00 | $0.00 | $15.00 | $0.00 | -$71.10 | -$56.10 | Fundraising & marketing | |||||||||
37 | Bad Debt (6900) | $0.00 | $0.00 | $0.00 | HQ operating costs | ||||||||||||
38 | Bank Revaluations | -$0.17 | -$6.74 | $7.96 | -$217.46 | -$210.64 | -$427.05 | HQ operating costs | |||||||||
39 | Chapter Accommodation (6820) | $0.00 | $0.00 | $0.00 | Chapter costs | ||||||||||||
40 | Chapter Expenses (6800) | $0.00 | $0.00 | $0.00 | Chapter costs | ||||||||||||
41 | Chapter Marketing Materials | $0.00 | $0.00 | -$418.95 | -$743.66 | -$896.79 | -$532.30 | -$41.93 | -$87.83 | -$2,721.46 | Chapter costs | ||||||
42 | Chapter Meals & Entertainment | $0.00 | -$86.75 | -$209.15 | -$356.77 | -$576.00 | -$206.30 | -$26.00 | -$74.74 | -$1,535.71 | Chapter costs | ||||||
43 | Chapter Travel (6810) | $0.00 | $0.00 | $0.00 | Chapter costs | ||||||||||||
44 | Chapter T-Shirts & Clothing | -$44.02 | -$66.90 | -$71.51 | -$441.14 | -$81.92 | -$44.37 | -$36.91 | -$786.77 | Chapter costs | |||||||
45 | Chapter Venue Hire (6870) | $0.00 | -$32.86 | $0.00 | -$25.00 | -$57.86 | Chapter costs | ||||||||||
46 | Conference Tickets (6401) | $0.00 | $0.00 | -$40.71 | -$40.71 | Fundraising & marketing | |||||||||||
47 | Contractor Fees | -$195.00 | -$180.00 | -$150.00 | -$300.00 | -$135.00 | -$120.00 | -$1,859.63 | -$1,566.70 | -$4,506.33 | Staff & on costs | ||||||
48 | Donations for Giving Lunch participants | $0.00 | $0.00 | -$74.72 | -$86.92 | -$70.00 | -$231.64 | Fundraising & marketing | |||||||||
49 | Donations to other charities (8000) | $0.00 | $0.00 | $0.00 | Fundraising & marketing | ||||||||||||
50 | Employee Healthcare/Insurance | -$1,233.06 | -$1,300.35 | -$1,254.49 | -$1,612.00 | -$1,576.48 | -$1,576.48 | -$1,582.93 | -$1,576.48 | -$11,712.27 | Staff & on costs | ||||||
51 | Fundraising Meals & Entertainment (6200) | $0.00 | $0.00 | $0.00 | -$4.86 | -$4.86 | Fundraising & marketing | ||||||||||
52 | Office Expense | $0.00 | $0.00 | -$1,068.44 | -$273.64 | -$44.27 | -$1,386.35 | HQ operating costs | |||||||||
53 | Online Donation Fees | -$82.43 | -$163.92 | -$197.64 | -$240.00 | -$374.23 | -$1,561.09 | -$695.43 | -$2,271.45 | -$5,586.19 | HQ operating costs | ||||||
54 | Payroll taxes | -$667.90 | -$1,919.85 | -$1,374.95 | -$1,358.80 | -$1,185.49 | -$1,181.80 | -$2,427.03 | -$1,427.39 | -$11,543.21 | Staff & on costs | ||||||
55 | Realized Currency Gains | $2.59 | -$4.07 | $1.27 | -$3.96 | $114.32 | $110.15 | HQ operating costs | |||||||||
56 | Rent | -$444.68 | -$489.62 | -$1,420.49 | -$617.79 | -$1,142.59 | -$994.00 | -$1,163.85 | -$989.61 | -$7,262.63 | HQ operating costs | ||||||
57 | Software Subscriptions & Costs | -$841.73 | -$1,543.31 | -$788.31 | -$652.46 | -$1,513.26 | -$2,353.53 | -$434.62 | -$856.10 | -$8,983.32 | HQ operating costs | ||||||
58 | Technical/Web Development (6651) | $0.00 | $0.00 | -$18,000.00 | -$18,000.00 | HQ operating costs | |||||||||||
59 | Telephone & Internet (6600) | $0.00 | -$5.00 | -$39.40 | -$29.38 | -$14.40 | -$19.75 | -$19.54 | -$127.47 | HQ operating costs | |||||||
60 | Travel (6773) | $0.00 | $0.00 | -$482.54 | -$557.44 | -$1,359.39 | -$491.81 | -$108.22 | -$1,247.93 | -$2,472.93 | -$6,720.26 | HQ operating costs | |||||
61 | Wages & Salaries | -$17,352.00 | -$21,852.00 | -$22,625.07 | -$22,240.05 | -$22,398.72 | -$22,398.72 | -$29,431.38 | -$22,398.72 | -$180,696.66 | Staff & on costs | ||||||
62 | Total Other Income and Expense | -$20,860.82 | -$27,640.56 | -$30,046.54 | -$29,505.45 | -$31,438.08 | -$31,490.57 | -$56,082.19 | -$32,739.56 | -$2,472.93 | $0.00 | $0.00 | $0.00 | -$262,276.70 | |||
63 | |||||||||||||||||
64 | Net Income / (Loss) before Tax | $445,846.10 | -$27,457.52 | -$32,003.35 | -$20,428.18 | -$31,532.88 | -$4,715.28 | -$39,067.66 | -$35,143.06 | -$2,852.93 | $11,050.00 | -$495.00 | $20,000.00 | $283,200.24 | |||
65 | |||||||||||||||||
66 | |||||||||||||||||
67 | Net Income | $445,846.10 | -$27,457.52 | -$32,003.35 | -$20,428.18 | -$31,532.88 | -$4,715.28 | -$39,067.66 | -$35,143.06 | -$2,852.93 | $11,050.00 | -$495.00 | $20,000.00 | $283,200.24 | |||
68 | |||||||||||||||||
69 | |||||||||||||||||
70 | Total Comprehensive Income | $445,846.10 | -$27,457.52 | -$32,003.35 | -$20,428.18 | -$31,532.88 | -$4,715.28 | -$39,067.66 | -$35,143.06 | -$2,852.93 | $11,050.00 | -$495.00 | $20,000.00 | $283,200.24 | |||
71 | |||||||||||||||||
72 | Total expenditure | -$21,943.00 | -$27,696.44 | -$32,638.75 | -$30,531.12 | -$33,946.31 | -$35,861.95 | -$58,479.19 | -$36,846.22 | -$2,852.93 | $0.00 | -$495.00 | $0.00 | -$281,290.91 | |||
73 | |||||||||||||||||
74 | |||||||||||||||||
75 | |||||||||||||||||
76 | |||||||||||||||||
77 | |||||||||||||||||
78 | |||||||||||||||||
79 | |||||||||||||||||
80 | |||||||||||||||||
81 | |||||||||||||||||
82 | |||||||||||||||||
83 | |||||||||||||||||
84 | |||||||||||||||||
85 | |||||||||||||||||
86 | |||||||||||||||||
87 | |||||||||||||||||
88 | |||||||||||||||||
89 | |||||||||||||||||
90 | |||||||||||||||||
91 | |||||||||||||||||
92 | |||||||||||||||||
93 | |||||||||||||||||
94 | |||||||||||||||||
95 | |||||||||||||||||
96 | |||||||||||||||||
97 | |||||||||||||||||
98 | |||||||||||||||||
99 | |||||||||||||||||
100 |