| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Sheet 2: Application Budget and Financial Reporting | ||||||||||||||||||||||||||
2 | Sheet Objective | There are two parts in this Application Budget and Financial Reporting sheet: Part A: Application Budget Template: Applicant applying for any WMF Fund should use this template to state the requested budget and spending plan details | |||||||||||||||||||||||||
3 | Part B: Financial Reporting WMF Grantees ( applicants who received funds) , will use this part to periodically report the financial progress and actual spending of the fund. Note: If you are applying for a WMF Fund , please keep this part empty | ||||||||||||||||||||||||||
4 | |||||||||||||||||||||||||||
5 | Applicant Name | WMDC | |||||||||||||||||||||||||
6 | Project Title (stated in the Application Form) | ||||||||||||||||||||||||||
7 | WMF Fund Programme | ||||||||||||||||||||||||||
8 | Local Currency (stated in the Application Form) | USD | |||||||||||||||||||||||||
9 | |||||||||||||||||||||||||||
10 | Part A: Application Budget Template | Part B: Financial Reporting ( If you are applying for a WMF Fund , please keep this part empty) | |||||||||||||||||||||||||
11 | Total Budget Amount | Note: to only sum the subtotal cells | 109,900.00 | 109,900.00 | 146,450.00 | 146,450.00 | Final report (Please report the funds received and spending in the currency of your fund.) | ||||||||||||||||||||
12 | Program or Strategy number | Program or strategy | Expense category | Expense Item number | Expense item | Description (of how this value is calculated or any other descriptions that are useful) | Unit | Unit Cost | Number of Units (Quantity) | Currency [ select local currency] | Total Cost in Local currency | Total Cost in US dollars | Amount received in Local Currency | Amount received in US dollars | Final expense in Local Currency | Final expense in US dollars | Difference in Local Currency | Difference in US Dollars | Explanation of variance and other comments | ||||||||
13 | Place an item number as reference | Please state below the activity / strategy or program title that includes the different costs / expenses The activity / startegy or program should align with the program proposal in the application form | Please choose one of the following categories. Please refer to the Guide (first tab/ Sheet) for definitions of each category and associated items. If there is anything that does not fit your proposal, please state other and describe this expense in detail. | Place an Expense item number as reference | Please select an expense item from the reference. If there is an expense item that does not fit into the following list, please describe the item. | Describe any details regarding this expense and how it is calculated. If you are referring to staff costs please explain each role and responsibility and how their costs are calculating. For instance full-time, part-time based on national salary scales or hourly costs. Please state if you are using any market rate references. | Please state the unit value, for instance a time unit (days, months), number of people, number of materials, etc. | If possible please state the cost of each Unit | State the number of units or requested quantity | Please indicate the currency that aligns with the proposal currency (local currency where the proposal will be developed) | The calculations are generated automatically by multiplying columns H & I In case the formula is missing, Please state the total amount, by multipliying Unit Cots by Number of Units. - Column H & Column I) | Please convert the total costs istated in column K per local currency to the US Dollars currency using OANDA Rate in this link https://www.oanda.com/currency-converter/en/?from=EUR&to=USD&amount=1 and state the conversion date here: In case the local currency is US Dollars, plase copy paste column K in Column L | Please report here the received funds | Please convert the total received amount stated in column M per local currency to the US Dollars currency using OANDA Rate in this link https://www.oanda.com/currency-converter/en/?from=EUR&to=USD&amount=1 and state the conversion date here: | Please report here the final expense for the final report | Please convert column T per local currency to the US Dollars currency using OANDA Rate in this link https://www.oanda.com/currency-converter/en/?from=EUR&to=USD&amount=1 and state the conversion date here: | The cell calculation is automatically generated. In case not please make sure deduct Final Expense in local currency from the amount received in column M | The cell calculation is automatically generated. In case not please make sure to do deduct Final Expense in USD from the amount received in column N | Describe any details regarding this expense difference / variance | ||||||||
14 | Example! Strategy 1 | Strategy 1: Organise more online and offline events to retain participants Activity 1: Organise one online or offline meetup every month ( This strategy / activity mentionned here should be the same in the Grant proposal - in the application form) | Administrative | 1 | Social Media costs | This row represents the social media costs that will be dedicated to cover the activity XXXX under strategy 1 , ...... to outreach ..... | Social Media posts per Month | 12 | 0.00 | 0.00 | 0.00 | ||||||||||||||||
15 | Strategy 1 & 2 | Strategy 1. Organizational and administrative excellence Strategy 2. GLAM and Organizational Partnerships | Personnel related expenses | Program-specific Staff | One FTE, with payroll tax costs, to sustain the ongoing administrative and partnership work of the chapter as a compliment to the work of the volunteer board. Organize and lead editing workshops focused on diverse content to recruit, engage, and inform participants; project management of logistics around partner engagements, expanding to cover other programs, Chapter meetings, and some reports. | monthly salary and taxes | $6,250 | 12 | USD | 75,000.00 | $75,000.00 | $112,500.00 | $112,500.00 | $121,332.66 | $121,332.66 | -$8,832.66 | -$8,832.66 | Payroll taxes were higher than estimated | |||||||||
16 | Strategy 1 | Strategy 2. Organizational and administrative excellence | Administrative | Software and Digital platform costs; Accounting and legal fees | Software subscriptions, tax services, payroll service, email marketing, web hosting, mailing, post office box, bank fees | monthly subscription costs | $5,000 | 1 | USD | 5,000.00 | $5,000.00 | $7,500.00 | $7,500.00 | $4,142.23 | $4,142.23 | $3,357.77 | $3,357.77 | Software costs were lower than estimated | |||||||||
17 | Strategy 1 | Strategy 1. Organizational and administrative excellence | Administrative | Accounting and legal fees | Accountant - cleanup of historical books and ongoing accounting services to aid in future compliance with non-profit tax regulations | Quickbooks online $2000 one-time cleanup fee, plus $200/month for 12 months | $4,400 | 1 | USD | 4,400.00 | $4,400.00 | $6,600.00 | $6,600.00 | $9,159.39 | $9,159.39 | -$2,559.39 | -$2,559.39 | Accounting costs were higher than estimated | |||||||||
18 | Strategy 1 | Strategy 1. Organizational and administrative excellence | Services | Consulting and professional services | Consultant to lead strategic planning process to faciliate and write a new 5-year plan for the chapter, aligning us with overall WMF movement strategies | 12-16 week consulting engagement | $25,000 | 1 | USD | 25,000.00 | $25,000.00 | $19,350.00 | $19,350.00 | $0.00 | $0.00 | $19,350.00 | $19,350.00 | Contract for consulting and related travel expenses are not yet awarded | |||||||||
19 | Strategy 3 | Strategy 3. Community Partner for Advocacy | Services | Office space & Facilities | OpenGovHub membership for in-person space and WMF partnership | Annual fee | $500 | 1 | USD | 500.00 | $500.00 | $500.00 | $500.00 | $500.00 | $500.00 | $0.00 | $0.00 | ||||||||||
20 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
21 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
22 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
23 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
24 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
25 | Sub Total | 109,900.00 | $146,450.00 | $146,450.00 | $135,134.28 | $135,134.28 | $11,315.72 | $11,315.72 | |||||||||||||||||||
26 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
27 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
28 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
29 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
30 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
31 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
32 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
33 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
34 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
35 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
36 | Sub Total | 0.00 | 0.00 | 0.00 | |||||||||||||||||||||||
37 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
38 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
39 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
40 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
41 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
42 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
43 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
44 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
45 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
46 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
47 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
48 | Sub Total | 0.00 | 0.00 | 0.00 | |||||||||||||||||||||||
49 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
50 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
51 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
52 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
53 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
54 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
55 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
56 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
57 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
58 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
59 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
60 | Sub Total | 0.00 | 0.00 | 0.00 | |||||||||||||||||||||||
61 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
62 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
63 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
64 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
65 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
66 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
67 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
68 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
69 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
70 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
71 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
72 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
73 | Sub Total | 0.00 | 0.00 | 0.00 | |||||||||||||||||||||||
74 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
75 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
76 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
77 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
78 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
79 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
80 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
81 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
82 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
83 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
84 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
85 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
86 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
87 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
88 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
89 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
90 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
91 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
92 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
93 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
94 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
95 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
96 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
97 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
98 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
99 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
100 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||