How-To Fill Out a TerraFund Financial Report

All TerraFund champions must submit an annual financial report as part of their July 31 project report.

After reviewing this article, if you have any questions about this process, please reach out to our team via WhatsApp or at info@terramatch.org.

DOWNLOAD THE TEMPLATE HERE.

For instructions on how to submit a financial report, please consult this detailed, step-by-step PowerPoint.

All About the Financial Report

  • The report is in a standard format that you must download and use.
  • Non-profits and for-profits use the same financial report format.
  • The currency of your financial report should match the currency of your agreement.
  • If you are reporting in USD, you must note the exchange rate that you are using.
  • It should cover all expenses to date for your TerraFund project – and only for your TerraFund project. Be accurate to the $0.01.
  • It must be signed by your financial officer and executive director.
  • We do not require you to submit receipts or other transaction documentation, but you must collect that information and provide it if we request it
  • Enterprises: You must also submit audited financial statements as an an "additional document" in your project report.

You are required to fill out the financial report and map your expenses according to the category definitions found in the "definitions" tab of the template. We understand that each organization tracks expenses in a different way, but we need to analyze the data and therefore need a comparable format across each project.

For guidance on how to complete your financial report, please review the instructional video below:

Step-by-step guide for the TerraFund for AFR100 Financial Report Template workbook:

  • Insert your organization’s name and project information (rows 6-10)
  • Insert the appropriate reporting period (line 15)
  • Insert the appropriate currency exchange rate calculation (line 17). 
    • Note: Please keep track of all exchange rates used from USD to local currency throughout the reporting period. For financial reporting, we advise you to report the average exchange rate, considering the documented rates used during that implementation period.
  • Insert the total approved budget (inclusive of Years 1-6/7) in USD in column 2. This is the exact total in your project budget approved by your project manager.
    • We expect you to communicate any proposed adjustments in advance to your project manager.
  • Enter the annual expenses for the following categories on the summary page in the Year 1 column. 
Personnel/Salaries

This includes the salaries and benefits associated with staff officially and legally employed by the implementing organization. This should cover only those staff who are actively working on the project.

Community Engagement & Capacity Building
This line includes all work to mobilize smallholder farmers and other community members that will contribute to the project, along with any conference or training costs.
Monitoring & Reporting
This line includes costs associated with collecting the information needed to establish sites and submit reports on the TerraMatch platform, along with expenses related to data collection, in-field monitoring and evaluation work. Crucially, this includes expenses related to producing high-quality geospatial shapefiles of each restoration site. There should be a modest budget for this line for each year of the project. Note that monitoring professionals will independently analyze progress within each site; this budget line should not include that data analysis.
Communications 
This line includes all communications and marketing expenses related to the project, e.g., printed materials and website development.
Local Transportation
This line includes the costs of local travel undertaken within the project area, including per-diems for staff and drivers, fuel, mileage etc. External travel, including all flights and international conferences, must be either covered by the organization's overhead or by requesting additional funding from the assigned project manager.
Administrative Expenses & Indirect Costs
This line includes all the costs that will go toward the management of your organization. It is expected that these expenses will be shared across multiple projects, but the reported cost should only include the relevant proportion of the costs for this TerraFund project. It is expected that many partners will include different types of costs in this section but some examples would be office space, phones, internet, etc.
  • Enter the individual expenses for the following categories in the 'YR1_Detailed Expense Report' tab. Within each category, list the line item, cost per unit, and quantity. The “total cost” will auto calculate and auto populate into the summary tab. *Repeat this step annually utilizing the appropriate “YRX_Detailed Expense Report” tab found in the workbook* Report on multiple expenses together, e.g., “Seeding purchases,” if you had several transactions of the same type.  
External Contractors 

This includes any work that may be outsourced to other organizations or individual contractors and must involve formal contracts for goods or services rendered. This should not be a significant portion of the budge and must be justified.

Seedlings Cost
This line includes the costs of growing seedlings in a nursery or purchasing them from a third party. This should include payments to community members that care for seedlings but are not formally employed. For natural regeneration projects, this cost should be 0.
Tree Nursery Management
This line includes all construction, management, and expansion costs of nurseries managed by this project. If the project does not operate its own nurseries, this cost should be 0. This should include payments to community members that construct or manage nurseries but are not formally employed.
Site Preparation 
This line includes all of the start-up costs related to work within the project's restoration sites, including clearing vegetation, fencing, building infrastructure, and preparing the ground for planting. This should include payments to community members that work on preparation but are not formally employed by the organization. Note that this can include buying land, but projects that do not have access to land already are less likely to be selected for funding.
Tree Planting
This line includes all of the costs associated with planting trees on prepared sites. For natural regeneration projects, this cost should be 0. This should include payments to community members that work on planting but are not formally employed by the organization.
Tree & Site Maintenance 
This line includes all work on the site after the initial restoration work is complete to ensure that the trees grow to full health, in line with the proposal. This should include payments to community members that work on maintenance but are not formally employed by the organization. There should be a modest budget for this line for each year of the project.
Material Inputs
This line includes expenses for materials that improve the livelihoods of communities but are not related to nursery management, site preparation, or tree management, e.g., processing machinery, bee hives, and water pumps. This should be a modest portion of the budget.
Other Project Costs
Other costs must remain less than 5% of the total project costs and be directly related to implementation, but they must not be included in one of the above categories. They must be clearly defined in the project proposal.
Was this article helpful?
3 out of 3 found this helpful

Comments

0 comments

Please sign in to leave a comment.

Articles in this section

See more
Contact Us On WhatsApp
You can reach our support team on WhatsApp at +44 7456 289369.
Email Us Your Questions
You can email our support team directly at info@terramatch.org.
How to Use TerraMatch
Access detailed guidance for all tasks on TerraMatch