Overview
In this user guide, grantees will learn how to:
Login and access the portal
Add or upload indicator results
Visualize targets vs. results in a performance graphs
Fill out narrative reports
Add or upload financials
Submit a grant report
To get started, grantees need to be invited to report via email.
Access grant reports via email
Grantees are sent an email, like the one shown below, hyperlinking the grant report by the grant-maker or funder. Clicking the hyperlink will open a new tab, where grantees can input their login credentials to access the reports. Automatic reminder emails are sent to the grantee according to upcoming reporting periods.
The email text and Community look-and-feel may differ as it can be customized by a funder.
Upon clicking the link to submit the report, grantees will be prompted to log in from an interface similar to the screenshot below.
Fill Out Grant Reports
Reports are assigned for grantees to complete. A funder may choose to collect quantitative and qualitative indicator data, narrative reports and financials as part of a grant report.
Once a grant report has been submitted, the Add Results, Financials, and Narrative Reporting pages will lock and no longer be editable.
Add Results
Grantees may create, update, and upload results. Values inputted directly into the Result Entry interface are automatically saved.
Click on the Add Results tab.
Create results by directly entering values in the Results interface, shown below. Grantees may input a number value up to 16 digits in length.
If the grantee inputs a value that is 9 digits or more, the number is rounded to the nearest hundred thousand or million with one decimal place when grantee clicks outside of input field.
An input larger than 16 digits will result in a validation error.
3. Similarly, grantees may update previously entered results by entering new values in the Results interface.
4. To work on data entry for results offline, grantees may click on Download Excel Version as shown below.
a. Grantees can then use the auto-generated excel template to enter their results.
5. Confirm Download request by clicking “Generate”, as shown below.
6. Confirm Download.
7. Open the generated Excel file to update rows with Results data.
8. Read the Instructions tab carefully, which is the default first tab as per the screenshot below.
a. Ensure data follows the outlined guidelines for upload.
9. After updating Results, save the Excel file.
10. Return to the Add Results tab.
11. Click the Upload icon next to the Download icon.
12. Attach updated .xlsx file in popup by clicking the Attach button.
13. On Step 2, confirm that the attached .xlsx file is the updated file.
14. On Step 3, confirm Upload by clicking Yes, screenshot below.
15. Any values entered directly into the Result Entry interface are automatically saved.
a. New values in previously empty rows create new Result records.
b. New values in previously non-empty rows update existing Result records.
c. Any values uploaded via the Excel upload interface are upserted to Result records.
Visualize Results vs. Targets in Performance Graphs
After adding results, grantees may view performance graphs that display targets vs. actuals, or results.
On the Reporting Period, click the Performance Graphs tab as shown below.
2. View performance graphs according to active indicators with target and result inputs.
a. The first 9 indicators, as ordered on the AddResults page, are automatically selected.
b. If the project has fewer than 9 indicators, all indicators are displayed.
c. Indicators display across all reporting periods.
d. Graphs do not include cross-disaggregation by sex, if applicable.
3. To view specific indicators only, click on the dropdown above the graphs to select via checkbox which indicators to render, as shown below.
4. Click Apply Selection.
Add Narrative Reporting
Open the Reporting Period record. Navigate to the Narrative Reporting section, as displayed in step 2.
If the report is divided into sections, each section will appear over a horizontal grey bar, with their related questions listed below. Questions are displayed according to response type (qualitative, short text, number, multi-select picklist, date, or picklist), as seen below.
3. Check if a question is required by noting whether or not it has a red asterisk displayed next to it.
4. Check if a question has any special instructions/criteria by hovering over the info icon to expand the help text.
5. Respond to questions depending on the questions’ response types:
a. Text/Qualitative - respond in a rich text editor which allows responses such as typed text, insert images and tables
i. If word limits are defined for Question__c records, either by system or another user (i.e., M&E manager or System Admin), then the respondent will be unable to enter a qualitative response that exceeds the word limit.
b. Short Text - respond in an input text field using a combination of letters and numbers.
i. Any short text response values entered are saved in ampi__Short_Text_Response_c.
ii. If the default word limit (255 characters) or user-defined word limit set by the template creator in the Text Response Character Limit field for a Question__c record are violated by the respondent, then an error message displays when the user clicks out of the input field stating that the prescribed word limit is exceeded.
c. Picklist - select a single value from the pre-defined picklist
d. Number - enter a numeric value with up to 16 digits and 2 decimal places (i.e. 19 total characters)
i. If a value entered exceeds the digit or decimal count, an error message will display
e. Multi-Select Picklist - Select single or multiple values from a user-defined picklist
i. Any picklist value entered or changed are saved in ampi__Multi_Select_Picklist_Response__c
f. Date - select or enter a date value from a datepicker component.
i. Any date values entered or changed are saved in ampi__Date_Response__c.
6. Add comments or explanations to the picklist or number answers.
a. Some picklist or number questions may allow grantees to provide an explanation to their response. Grantees will be able to type directly into a text input box displayed next to the picklist or number input box to add that information.
7. Click out of an input cell to save any entered answers. Once the grantee clicks out of the input cell, the information entered is automatically saved.
8. Responses are auto-saved, question records are automatically updated with the entered/modified responses. If entered/modified responses are invalid (i.e. too many characters or incorrect response type), grantee is notified to fix their response.
a. For any offline work that might be required to complete the submission response, users can download the submission response by clicking the Download button at the top of the form to generate a Word document version of the submission. See below for screenshot.
9. A pop-up will appear, prompting the user to confirm the download, as shown in the screenshot below.
10. Once the download is confirmed, a Word document version of the submission will download through the user’s browser, and they can open the document to view the submission.
a. If any answers were entered, those will display below their related questions in the Word document.
i. For picklist and multi-select picklist questions, the selected picklist value(s) will display in bold, and unselected picklist values will display in normal text.
b. If an answer has not been entered for a question, the question will be displayed with either an input box with placeholder text or the list of picklist options.
i. For picklist and multi-select picklist questions, the picklist values will display as options in normal text.
Add Financials
On the Financials tab, grantees may review, add, update, and upload financial and budget records pertaining to their reporting.
Click on the Financials tab.
Create or update values by manual input or by uploading data using the template.
To create a new financial value, click the New button.
4. Fill out name, budget, reporting period, which are mandatory fields necessary to create a new financial line. It is highly recommended to include financial type, category, and subcategory if applicable from the picklist. Click Save when done. See screenshot below.
Once created, Budget names cannot be edited. This is due to the fact that the Budget name is a Master-Detail relationship field type that cannot be reparented.
5. In addition to working online, grantees can also download an Excel file to create new financial line items and/or edit existing information.
Admin Note:
Users may speak to a system admin to ensure that the custom fields have been added to the RP_EXCEL_COLUMNS fieldset on ampi__Financial__c.
6. To download the Excel, click on “Download Financials”. An excel file will be downloaded on the same screen. Open the file and first read the detailed information in the Instructions tab, screenshot below.
7. In Excel, create new financial line items or edit existing financials. Once complete, click Save. This may save to the Downloads folder, be sure to save the file to the appropriate space.
8. Back on the Financials tab, click on “Upload Financials”. A popup will display with instructions for Step 1.
a. Step 1: Click “Upload Files” to find and select the updated excel file. Once selected, click “Upload” to attach the updated .xlsx file.
b. Step 2: Confirm Upload.
c. Step 3: Upon upload, grantees may view error and success logs. Note that if budget is locked, grantees will be unable to successfully upsert data as per the error log.
Note that a single reporting period may have multiple budgets. Grantees can enter financials related to one or more budgets within a single reporting period. As grantees add new financials, they may click into the Budget field to search and select from a list of available Budgets.
Submit the Grant
Once all answers have been entered and saved, users can submit their response to be reviewed and/or scored by the funder. All reporting requirements, including indicators, budgets, activities, narrative, are submitted through one button.
Click the Submit button at the top of the page.
2. A pop-up will appear, prompting the user to confirm their submission, as shown below.
3. Click “Submit”. If the user confirms submission and a required question has been left unanswered, the user will be prevented from submitting and they will be prompted to address the required questions.
4. Once successfully submitted, the submission’s Status is updated to “Submitted”.
Remember, successfully submitting the response will also lock the submission response from editing.