Source: http://www.docstoc.com/docs/24996004/MEMO-ON-FINANCIAL-REPORTING-TEMPLATE
Timestamp: 2015-05-29 05:17:38
Document Index: 27719788

Matched Legal Cases: ['Art. 15', 'Art. 9', 'Art. 2', 'Art.\n15', 'Art. 2', 'Art. 15', 'Art.\n15', 'Art. 9', 'ART. 2', 'Art. 2']

MEMO ON FINANCIAL REPORTING TEMPLATE by pua50703
24996004
MEMO ON FINANCIAL REPORTING TEMPLATE
ANNEX VI TO THE STANDARD GRANT CONTRACT (VERSION DEC 2007) – FINANCIAL REPORTING TEMPLATES
FINANCIAL REPORTING                                              EXPLANATION GIVEN BY CONCORD/FDR                                                     OPEN ISSUES STILL TO BE CLARIFIED WITH
TEMPLATES                                                                                                                                                     EUROPEAID
The beneficiary alone is               This sheet is for information purpose and should be deleted when presenting reports.
responsible for the correctness of     The information provided in these templates have to be in line with the (audited) financial reports and
the financial information provided     project accounts, i.e. it must be possible to reconcile the information provided by the project’s books and
in these tables.                       accounts.
Figures have to be rounded to the      The budget lines proposed in the template are standard. You have to copy the budget from your contract.
nearest euro cent                      This personalization of the budget will have to be carried out in the various sheets. When you add
(The other information provided in     additional lines, don’t forget “to stretch” the formulas which draw simultaneously figures. You will also not
sheet 1 has been included below        be able to copy the template of your budget in the other sheets without prior insertion of new lines, to
for sheets 2-4 where relevant)         prevent that the following columns are shifted.
Be careful with the formulas in the excel sheet and make sure that there are no formula mistakes.
All the amounts and figures have to be rounded to the nearest euro cent (0.00). It has been agreed with
EuropeAid that the printed version of the report shows rounded figures with two decimals. That’s why we
should include rounding up formulas in all cells to avoid calculation problems.
SHEET 2: FORECAST BUDGET &amp; FOLLOW-UP
The Contracting Authority may          The budget and forecast has to be provided with each interim report for grants with payment option 2 (see
request this forecast for              Art. 15.1. of the grant contract’s General Conditions (GC)). It is only meant for information purpose and will
information purposes only: it allows   thus not be taken into account when for example calculating budget deviations (15% rule, Art. 9.2 of the
the follow-up by operational and       GC).
financial services. It concerns        Forecast budgets are for information only. They do not have to be based on the exchange rate imposed by
forecasts and also allows to           EuropeAid. They can be elaborated according to each organisation’s internal exchange rate. However, be
observe adaption capacity in           careful not to loose track of the total budget. This total budget in EUR (as per contract or latest amendment
revising forecasts and their           signed) is the binding one and not the sum of annual budgets updated with internal exchange rates!)
• Personalize the budget by introducing all sub-headings as outlined in the approved project budget
• The column “unit” must be filled in the same way as it has been completed in the template of the budget
annexed to the contract.
• Implementation period of the contract = total period of the EC funding (as stipulated in Art. 2.2 and 2.3 of
the grant contract’s Special Conditions)
• previous period = period justified by the present report (that you are currently drafting)
FINANCIAL REPORTING                                               EXPLANATION GIVEN BY CONCORD/FDR                                                        OPEN ISSUES STILL TO BE CLARIFIED WITH
TEMPLATES                                                                                                                                                         EUROPEAID
• following period = period of your budget for the following year (generally corresponds to a full year); this
part has thus not to be filled for the final report
• For the 1st interim report the “Forecast” of the previous period refers to the budget of year 1 as outlined
in the approved budget sheet and annexed to the funding contract.
• For the second report (and the following), present under “Previous period” the same budget as the one
given under “Following period” at the time of the previous report, i.e. do not cumulate the amounts of the
preceding years, but only consider the provisional amount for the reporting period that you are working
• Reports should be submitted by the end of a 12-months-period. However, considering that reports do
not necessarily cover a 12-months period, it may happen that provisional budgets that have to be
provided with interim reports are also not based on this 12-months period. Example: For a project
starting on the 1/01/2007 and ending of the 31/12/2009 the budget forecast for year 1 = 1/01/2007 –
31/12/2007. The 1st interim report is sent on 30/06/2008 and covers the period from 1/01/2007 to
31/03/2008 (because, 70% of the first instalment was not spent to report only until 31/12/2007, see Art.
15.1 GC). The period covered by the budgetary forecast no.2 to be provided with the 1st interim report
will then be 01/04/2008-31/03/2009 because the forecast budget should cover the end of the reporting
period + 12 months.
• The column &quot;Real previous period&quot; corresponds to the financial statement for the present report and
should therefore include the same figures as column (h) “Total costs of the period (in EUR)” of sheet 3
SHEET 3: INTERIM REPORT &amp; SHEET 5: FINAL REPORT
Expenses: for each currency in          How to fill in sheet 3 “interim report”:                                                                           Columns “Reallocation and use of contingencies”:
which the budget has been               • Implementation period of the contract = total period of the EC funding (as stipulated in Art. 2.2 and 2.3 of     • FDR did not obtain any clear explanation from
implemented during the specific           the grant contract’s Special Conditions)                                                                           EuropeAid regarding the manner to fill the column
reporting period (including the €                                                                                                                            &quot;allowed reallocation&quot; except that hey need to see only
where the exchange Fx rate into €       • Interim financial reporting period = period on which you report (whereas this period is not necessarily
identical with the period given within the forecast budget under “previous period” - especially if the report      the changes already done (ex-post information to be
will be = 1 ) the report will:                                                                                                                               provided) and that it must only be filled in for the main
is delayed, this period must be the same as the column “Real Previous Period” of the forecast budget).
• have a set of four columns                                                                                                                                 budget headings.
(numbers of units, unit cost in       • Under the heading &quot;Budget as per contract/rider&quot; present the TOTAL budget of the contract or the last
amendment signed including all details (sub-headings, units.# units, unit costs)                                 • FDR suggests to EuropeAid to suppress the 2 columns
FX, total cost in FX, total cost in                                                                                                                        on reallocations and use of contingencies from the
€) so per each currency a set of      • Column &quot;use of contingencies&quot; should be completed only in the event of request for use of the budgetary            reporting template so as to well separate the two
four columns will be inserted           heading &quot;Provision for contingency reserve&quot; and must be the subject of prior written authorization of the          different issues of amendments and reports. Another
• establish the exchange rates            EC.                                                                                                                sheet for financial amendment request and information
(local currency &gt; €) to be used       • It is necessary to create as much block-columns as there are currencies used in the report (Headquarter            on budget modifications could be created.
by having, for the period, the          and Field expenditures), meaning per currency:                                                                   Unit costs:
simple arithmetical average of          • # units
the InforEuro exchange rate                                                                                                                             Unit costs are not contractually binding and should be
• unit cost in currency: specify the currency in which the expenditure has been made
(i.e. sum the exchange rates of                                                                                                                         applied in a flexible manner. For instance, in most of the
• total cost in currency: specify the currency = # units X unit cost
the months of the reporting                                                                                                                             cases, grant beneficiaries use average of different unit
• total cost in Euro = total cost in currency ./. exchange rate: &quot;Conversion into euro of the real costs borne    costs for a same item (ex: 3 cars with different unit cost will
period and divide the sum by the
in other currencies shall be done at the rate made up by the average of the rates published in InforEuro        be the average of those costs). Prices of quotations may
number of months)
for the months covered by the relevant report&quot; (Art. 15.9 GC). This average rate by currency must be            also vary during the project life-time. So it should be made
FINANCIAL REPORTING                                              EXPLANATION GIVEN BY CONCORD/FDR                                                       OPEN ISSUES STILL TO BE CLARIFIED WITH
TEMPLATES                                                                                                                                                       EUROPEAID
To ease the preparation of the           indicated in the title of column. When the expenditures are in Euro, the rate equals to 1 and it must also     clear that the need to report on modifications within the
reports, indications are provided on     be recorded for the calculation of formulas. We advise you to add an additional sheet with the interim         15% limit (or the need to ask for an amendment for
the relevant columns, FX= foreign        and final report, which will show the calculation of the exchange rate of the different currencies used.       variations above 15%) does not apply to units and/or unit
currency.                              • Column “Units total # for all currencies&quot; is the sum of the units from the various currencies. It may be       costs.
InforEuro is freely available at:        that this formula distorts the actual data. Example: purchase of 1 vehicle. You present the cost of             • EuropeAid has confirmed that only the variation of the
http://ec.europa.eu/budget/inforeur      purchase in Euro, the cost of transport in USD and the customs clearance charged in local currency. If            main budget headings is to be considered when
o/index.cfm?fuseaction=home&amp;Se           for each cost/currency, you note 1 unit, you will obtain 3 units whereas you bought only one vehicle. In          applying the 15% limit (except for administrative and
archField=&amp;Period=2006-                  this specific case, the unit cannot be added. EuropeAid recommends: &quot;you should only mention the unit             contingencies) and that unit costs may vary over the
5&amp;Delim=,&amp;Language=en                    once and create in the financial report as many sub-items as there are currencies&quot;. However, we advise            lifetime of the project. However they also made clear
you not to create new items (which would only increase the already high complexity of the document                that these variations must not lead to changes which
and would modify the contractual budget which some Delegation have already refused to accept).                    may call into question the grant award decision.
Mention the unit only once, with the most important expenditure and remove the unit from the other              • It still needs to be clarified in how far the unit costs are
currencies (pay attention with the added amount which will have to be corrected).                                 for information (e.g. when calculating the average unit
• Column (h) &quot;Total cost of the period (in EUR)” corresponds to the sum in Euro of all converted                    price of three vehicles purchased) or are part of the
expenditures. This sum of expenses during the period in EUR will match the amount to be reported in               calculation of the headings.
sheet 2 (forecast budget), column “Real previous period”.                                                       Reporting in different currencies:
• Column (i) &quot;Cumulated costs (before current report) (in EUR)&quot; will not be completed for the first interim       Reporting by currency is a very burdensome process for
report. For the following report, this column will present the cumulated expenditure justified in the           both the grant beneficiary and the Delegation. Some
preceding report(s) (for the 2nd report expenses of period 1, for the 3rd report expenses of period 1 +         projects work with up to 4 currencies + Euro. This would
expenses of period 2).                                                                                          lead to unreadable and very complex documents to
• Column &quot;Cumulated costs (from start of implementation to present report included) (in EUR)&quot; will                handle. However, the following suggestion of FDR to
cumulate the two preceding columns: &quot;Total cost of the period (in EUR)&quot; + &quot;Cumulated costs (before              improve the financial reporting template still needs to be
current report) (in EUR)&quot;. For the 1st period it will thus be equal to column (h).                              discussed in detail again with EuropeAid:
• Line &quot; Bank interests yielded during the period&quot;: It will be necessary to indicate the amount of the            • To have 2 different documents with 2 different
banking interests received on the EC contribution for the period under reporting as well as the                   objectives:
cumulated interests with the amounts declared over the previous periods. EuropeAid expects us to                           1:
• Doc n&#176; the financial report. It would be provided in
declare both interests perceived by the lead organisation and those perceived by its partners. We should            EUR only.
however only declare those interest earned on the EC grant (and not on other project funding).                             2:
• Doc n&#176; the annex to the financial report i.e. the list
of expenditures. This list can be provided by
• For some NGOs, it may not be relevant to declare their partners’ interest if they have a policy to do
currency, with a list of exchange rates used
regular monthly or quarterly cash transfer to their partners according to their treasury needs. The money
(Inforeuro).
received by the partners will be spent quickly so that it may not be relevant to calculate interest on these
• For the utilization and/or re-imbursement of interest earned on the EC contribution please refer to Art.
15.9 to 15.12 GC as well as to the explanations given on this issue in the CONCORD Reader on the
Standard Grant Contract 2007).
• You must not change an interim report which has been approved by the EC from one year to another.
How to fill in sheet 5 “final report”
• This sheet is almost the same as the one for the interim report.
• Only 3 new columns were added on the right, under the heading &quot;Variations in comparison with initial
budget/rider&quot;. These variations must only be calculated and filled for the main budget headings (e.g.
subtotal human resources, subtotal travel, etc.) because we can transfer money from one of these main
budget heading to another (if the resulting variation is less or equal to 15% of the initial amount entered
under of the concerned budget headings, see Art. 9.2 GC). There are different ways how to calculate
FINANCIAL REPORTING                                   EXPLANATION GIVEN BY CONCORD/FDR                                                    OPEN ISSUES STILL TO BE CLARIFIED WITH
TEMPLATES                                                                                                                                         EUROPEAID
these variations, we only give you one possibility for illustration purpose:
Column &quot;In absolute value in EUR&quot; = “cumulated costs” (from the start of implementation to present
report) – “costs in EUR” (total budget of the contract or the last amendment signed)
If you have exceeded the approved budget, the figure stated here will be positive. Example: 120.000
spent - 100.000 budgeted = 20.000 absolute variation
If you have under-spent the approved budget, the figure will be negative:
Example: 80.000 spent – 100.000 budgeted = -20.000 absolute variation
Column &quot;In %&quot; = (cumulated costs / cost in EUR ) X 100.
The idea is to have the reference number of 100. If you overspend, your variation in % will be above
100. On the contrary if you under-spend, your variation will be below 100. Examples:
Budgeted amount: 100.000
Spent amount : 120.000
Variation in %: (120.000 / 100.000) x 100 = 120
it means you have spent 20% more of the budget line
Spent amount : 80.000
Variation in %: (80.000 / 100.000) x 100 = 80
it means you have spent 20% less of the budget line
Column &quot;Explanation for all variations&quot;. Do not hesitate to add a &quot;financial comments&quot; annex if the
space of this place is insufficient to write all the necessary information. Please be aware that variations
below 15%, though not needing prior approval, still need an explanation.
• The information on the bank interest earned also needs to be provided with the final report.
SHEET 4: SOURCES OF FUNDING
This sheet has to be annexed only to the final report (also for the 2006 grant contract versions though the
respective sheet is here missing in Annex VI). However, we advise you to attach it with every report
(intermediate or final) because it allows to follow the evolution of the financial contributions from donors
(new financial donor, variation of % of cofinancing within the limit imposed by the EC...).
The header “sources of funding” says “expected” and should be replaced by “actual “.
In line with the table on sources of funding submitted and approved along with the project application the
financial contributions from donors are to be distributed between:
• Applicant&#39;s financial contribution
• Commission contribution in this application = EC grant
• Contribution(s) from other European Institutions or EU Member States = European public funds
• Contributions from other organisations = other public or private funds
• TOTAL CONTRIBUTIONS = same amount than total of the column &#171; Cumulated costs (from start of
implementation to present report included) (in EUR)&#187; of the sheet interim or final report.
• Direct revenue of the action as well as interests earned on EC prefinancing should be considered as
additional funding compared to the EC grant which can be used in the project activities.
• OVERALL TOTAL: will be superior to the cumulated costs in case it includes eventual direct revenues of
FINANCIAL REPORTING                                              EXPLANATION GIVEN BY CONCORD/FDR                                                      OPEN ISSUES STILL TO BE CLARIFIED WITH
TEMPLATES                                                                                                                                                      EUROPEAID
the action and banking interests).
Example given by EuropeAid for direct revenue: “Direct revenue of the action are the revenues generated
by this action and directly linked to it. For example an NGO implements an action aiming at helping the
local community of a village to prepare and bake their own bread. If some of the bread is eventually sold,
this is direct revenue. In case of external actions, where the objective of the Action is to generate the
revenue or increase the financial viability of the grant beneficiary, the revenue generated by the Action is
not subject to deduction.”
According to EuropeAid changes in the funding sources (e.g. replacing own fund with another donor’s
contribution) is allowed and does not request an official amendment.
In kind contributions are indicated only for information purpose, without any figures, except if envisaged in
guidelines of the call within which the contract was signed.
LIST DETAILING EACH ITEM OF EXPENDITURE (ART. 2.1 OF THE GRANT CONTRACT’S GENERAL CONDITIONS)
The 2006 versions of the grant        There is no standard template, but the list must indicate for each expenditure : the wording of the
standard contract require this list   expenditure, the amount, the concerned budget heading as well as the reference of the supporting
to be provided with each interim      document. The list should also have cross-references to the budget (headings and items). This list could
and final report (Art. 2.1 of the     thus be an additional excel sheet into which your accounting data are extracted, or it can be a print out of the
GC)                                   project’s general ledger.
The 2007 version of the grant         For expenditures which are partially presented (example: 25% of local office costs), we should present all
standard contract however limits      the expenses lines and apply a percentage on the total amount, even if this means several pages of
this obligation to those cases        expenditures.
where, in accordance with article     As far as the link can be clearly established, the reference of the supporting document can be the reference
15.6, no expenditure verification     of the accountancy (the number of the supporting document in the booking accounts of the month that the
report is required with the report.   expense was made). Otherwise extra information must be added.
According to EuropeAid this list can be presented in the language of the organisation’s account (and thus
does not necessarily have to be translated into the language of the report).
"MEMO ON FINANCIAL REPORTING TEMPLATE"
http://img.docstoccdn.com/thumb/206/120499009.png
TEMPLATE FOR OFFERING MEMO