ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Sheet 2: Application Budget and Financial Reporting
2
Sheet ObjectiveThere are two parts in this Application Budget and Financial Reporting sheet:
3
4
Part A: Application Budget Template:
5
Applicant applying for any WMF Fund should use this template to state the requested budget and spending plan details
6
Part B: Financial Reporting
7
WMF Grantees ( applicants who received funds) , will use this part to periodically report the financial progress and actual spending of the fund.
8
Note: If you are applying for a WMF Fund , please keep this part empty
9
10
Applicant NameProgress Gateway NGO
11
Project Title (stated in the Application Form)Wikipedia Educational Development Outreach in Mongolia
12
WMF Fund ProgrammeAlliances Fund Programme
13
Local Currency (stated in the Application Form)Mongolian Tugrik (MNT)
14
15
Part A: Application Budget Part B: Financial Reporting
16
( If you are applying for a WMF Fund , please keep this part empty)
17
Total Budget AmountNote: to only sum the subtotal cells76,023,21022,41000Mid-term reportFinal report
18
(Please report the funds received and spending in the currency of your fund.)(Please report the funds received and spending in the currency of your fund.)
19
Program or Strategy numberProgram or strategyExpense categoryExpense Item numberExpense itemDescription (of how this value is calculated or any other descriptions that are useful)UnitUnit CostNumber of UnitsCurrency [ select local currency]Total Cost in Local currencyTotal Cost in US dollarsAmount received in Local CurrencyAmount received in US dollarsExpense to date in Local currencyExpense to date in US DollarsDifference in Local CurrencyDifference in US DollarsExplanation of variance and other commentsFinal expense in Local CurrencyFinal expense in US dollarsDifference in Local CurrencyDifference in US DollarsExplanation of variance and other comments
20
(Quantity)
21
Place an item number as referencePlease state below the activity / strategy or program title that includes the different costs / expensesPlease 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 referencePlease 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 UnitState the number of units or requested quantityPlease 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 & IPlease 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=1Please report here the received fundsPlease 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=1Please report here the expense to date for the Mid term reportPlease convert column O 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=1The cell calculation is automatically generated.The cell calculation is automatically generated.Describe any details regarding this expense difference / variancePlease report here the final expense for the final reportPlease 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=1The cell calculation is automatically generated.The cell calculation is automatically generated.Describe any details regarding this expense difference / variance
22
The activity / startegy or program should align with the program proposal in the application formIn case not please make sure to do deduct Expense to date from the amount receivedIn case not please make sure to do deduct Expense to date from the amount receivedIn case not please make sure deduct Final Expense in local currency from the amount received in column MIn case not please make sure to do deduct Final Expense in USD from the amount received in column N
23
In case the formula is missing, Please state the total amount, by multipliying Unit Cots by Number of Units. - Column H & Column I)and state the conversion date here: OCT 10, 2022and state the conversion date here:and state the conversion date here:and state the conversion date here:
24
25
In case the local currency is US Dollars, plase copy paste column K in Column L
26
Example! Strategy 1Strategy 1: Organise more online and offline events to retain participantsAdministrative1Social Media costsThis row represents the social media costs that will be dedicated to cover the activity XXXX under strategy 1 , ...... to outreach .....Social Media posts per Month1200000
27
Activity 1: Organise one online or offline meetup every month
28
( This strategy / activity mentionned here should be the same in the Grant proposal - in the application form)
29
Strategy 1Strategy 1. To increase more offline Wikipedia usage which this automatically drives online Wikipedia usage and even expands local Wikipedia size. Activity: Distribute offline Wikipedia to offline communities hence to activite additional online Wikipedia usageWikipedia DVD1Providing access to offline Wikipedia and other educational free materials to offline studentsThrough online research and development the media is createdknowledge database per unit DVD5,8013064MNT17,774,2645,29818,329,8085,29818,543,8705,363-214,062-65During last batch of DVD orders outside source donated $65 for the extra DVD production 18,543,8705,36300$24 from one batch of DVD orders currency exchanges difference gain will be returned. During last batch of DVD orders outside source donated $65 for the extra DVD production
30
Strategy 1Strategy 1 To increase more offline Wikipedia usage and editing training which this automatically drives online Wikipedia usage and even expands local Wikipedia size. Activity: Distribute offline Wikipedia editing means to offline communities hence to activite additional online Wikipedia usage and editingEditors user guide2Providing editing training to offline students who use Wikipedia and editThrough team members experiences editing knowledge created and transformed into a guideediting guide and training tool per unit1,40019980MNT25,392,4467,3631,418,5024101,425,337410-6,835025,392,4467,36300During second batch of printing order the contractor has offered 10% discount which we managed to order 19000 pieces for T1260 per piece.
31
Strategy 2,4,8,9Allowing easier internet access for our internet connection requiring activities such as trainings and editing classes.Mobile data router3This will allow internet connection to offline conditional training and editing events Internet accessibility equipmentcreation of internet access to hard to reach areas350,0001MNT350,000104359,815104382,500104-22,6850For the internet router additional $7 of tax cost payed from the outside source.359,81510400For the internet router additional $7 of tax cost payed from the outside source.
32
Strategy 2,4,8,9Allowing easier internet access for our internet connection requiring activities such as trainings and editing classes.Mobile data access fee4This will allow internet connection to offline conditional training and editing events Internet accessibility servicecreation of internet access to hard to reach areas70,00012MNT840,000250432,470125154,40044278,07081$81 will be returned343,700102496,300148Unspent $148 will be returned
33
Strategy 1-12Project head5Part timeman/month930,00012MNT11,160,0003,3195,729,3631,6565,770,3721,656-41,009011,488,5403,312-328,5407Currency conversion remainder $7 will be returned
34
Strategy 1-12Project staff 16Full timeman/month1,860,0006MNT11,160,0003,31911,479,4843,31811,558,1913,318-78,707011,558,1913,318-398,1911Currency conversion remainder $1 will be returned
35
Strategy 1-12Project staff 27Part timeman/month930,0006MNT5,580,0001,6605,708,6041,6504,797,9251,375910,679275One employee could not work for one month.4,797,9251,375782,075285One employee could not work for one month
36
Social security tax8Social security tax for staffs pay313,87512MNT3,766,5001,1203,093,4588942,987,076857106,38237$37 unspent tax will be returned3,759,0291,0817,47139One monthly salary reflecting tax will be returned
37
Sub Total76,023,21022,43446,551,50313,45545,619,67113,127931,832328Actual spent amount from the WMF funding is $13062; $417 will be returned which consists of one employee could not work for one month and with related tax amount added will be $312 plus $81 unspent amount from the internet fees plus $24 from one batch of DVD orders currency exchanges difference gain. And during last batch of DVD orders outside source donated $65 for the extra DVD production which adds on top of $13062 that equals to $13127.76,243,51622,018559,115481Actual spent amount from the WMF funding is $21,953; $504 will be returned which consists of one employee could not work for one month and with related tax amount added will be $324 plus $148 unspent amount from the internet fees plus $24 from one batch of DVD orders currency exchanges difference gain. And during last batch of DVD orders outside source donated $65 for the extra DVD production.
38
Strategy 2,4,8,9Book development and distribution to expand Wikipedia effect in the educational communities: This creates newer Wikipedia value in the educational environment that multi parties will benefitBook publishing 19Private donor will cover book publishingNewer form of educational tool that will open newer ways to learn1,400,0001MNT1,400,0004160000Book editing process is extended until March 2024
39
Strategy 1-12Advisor 210Advisor will contribute inkind job performanceGuidance375,00012MNT4,500,0001,3382,250,0006692,250,000669004,500,0001,33800
40
Sub Total5,900,0001,7550000
41
42
43
1. The private donor will donate English text book publishing cost.
44
2. The project advisor will donate/contribute 150 hours of work.
45
3. Attn: For currency conversion the OANDA rate was using one year old rate hence we used local national banks official rate from mongolbank.mn/eng
46
4. Attention: During 2023 local Mongolian currency fluctuated sharply against US dollar and especially for dollar to local currency fluctuating reflected accordingly in our financial accounting.
47
Which means different months different exchange rates applied on spendings.
48
During September 2022 when initial budget was planned the local exchange rate was $1=T3362 but throughout 2023 the rate fluctuated between 3448 to 3517 hence in Final Expense in Local Currency column numbers got higher than initial budget planned numbers.
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
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