Reporting in Submit.com: From the Basics to Real Impact
Every funding round ends with questions. Who applied? Who didn’t? Where did the money go, and what did it achieve?
Senior leaders, elected members, funders and auditors all want answers, and most of them are already in Submit.com. Reporting in Submit.com has been rebuilt. This guide starts with what has changed and the basics every administrator should know. It then shows how to go further, from checking who your grant is reaching to reporting on the difference it made.
What’s new: Custom Reports
Your Reports dashboard has a new look. Any reports you built before are still available: click Legacy reports at the top right of the dashboard.
Until now, reporting in Submit.com worked through saved column choices: each person could keep one set per form, and colleagues couldn’t reuse it. Custom Reports replace that with named reports you set up once, run whenever you need them and share with your team.
The biggest change: one report across every phase
Many programmes run in phases, such as an application, an acceptance stage and a drawdown stage. Until now, reporting worked one phase at a time, so a three-phase grant meant three reports to download and combine in Excel.
Now it is one report. The column builder works phase by phase: pick the applicant details and answers you want from phase one, then move to phase two and pick from there, including that phase’s tags, questions and Office Use Only answers. The result is a single spreadsheet covering the whole programme.
That means one row per applicant, with answers from each phase side by side and a blank cell where an applicant hasn’t reached a phase yet.
More from Custom Reports
- Create as many reports as you need. You might keep a weekly report for your manager and a monthly one for your chief executive on the same programme. Each has its own name, columns and filters.
- Put the columns in the order you want. Drag and drop columns into place before you download, so the spreadsheet arrives in the layout you need.
- Save your filters and sort order. Filter by status, date range or tag, add sort levels, and save them with the report. Every time it runs, the same filters and sorting are applied.
- Run it again without rebuilding it. Once a report is set up, run it whenever you need fresh figures. Each run is kept in the report’s history, so you can go back to earlier results.
- Share it with your team. Click Make available to team and colleagues will find the report in their own Reports Builder, ready to run, with no boxes to tick. Data permissions still apply: if a colleague has access to phase one of a programme but not phase two, the phase two columns stay hidden from them.
If your form only has one phase, you still get named, saved, shareable reports, which is a real step up from the old column preferences.
Part one: the basics
Start on the Reports dashboard
Open Reports in the left-hand panel. The dashboard gives you a quick overview, including application growth and a breakdown across your account. You’ll find the new Reports Builder here, and the Legacy reports button at the top right.
Know your five report types
Summary is the report you build yourself. The other four are ready-made: choose the type, add any filters, run it, and the columns are already set.
- Summary: the flexible one. Use the column builder to choose application details, form questions and Office Use Only answers from any phase, in any order. This is the one most people use.
- Scores: every reviewer score, with the application ID, applicant name, phase, scoring criterion, evaluator, score and when it was last updated. That gives one row per reviewer, per criterion, per application.
- Payments: every payment goes straight into your organisation’s connected Stripe account. This report links each one to its applicant, form, application and payment question. It was developed with the accounts departments of public bodies to make payments easier to track and reconcile.
- Applications: a list of your applications with first name, last name, email address, form, application number and tags. Filter by form or date range.
- Users: a list of applicant accounts you have access to, with first name, last name and email address. If you just need names and email addresses, start here rather than building a custom report.
Set up a report in a few steps
In Reports Builder, click New Report, choose a type, then choose the form or programme it covers. Give it a name, set your columns (for a Summary report) and filters, and save.
A quick tip on downloads
Reports download as a comma-separated values (CSV) file, which opens in Excel or any other spreadsheet program. If it is going into a spreadsheet, tick Strip HTML from answers for clean, plain text. If names with fadas (such as á or é) look odd in Excel, check Excel’s special character settings.
Reports Builder is available on platform version 3.4.3-t-3 or higher. If you can’t see it yet, get in touch with our support team.
9.07 How to create, run and share custom reports
Part two: going further
Plan your questions with reporting in mind
The best reports start with the form. Breakdowns can turn location, multiple choice, multiple select and yes/no questions into graphs and maps, so build those question types in alongside your open questions. For example:
- Where is your organisation based? (location)
- How many people will your project reach? (multiple choice ranges)
- Is this your first application to us? (yes/no)
One tip worth knowing: maps come from a location question. If applicants type a postcode or Eircode into a text question, breakdowns can’t map it.
See the picture with breakdowns
Breakdowns turn your form answers into graphs and maps, right inside Submit.com. Combine filters and tags to dig deeper, such as looking only at applications you have tagged by electoral area or funding strand.
9.02 Reports and Statistics comprehensive guide
Check who your grant is reaching
A grant only works if the people it is meant for know about it. With a location question on your form, breakdowns will map where applications came from.
Set that map beside the official deprivation data for your area:
- England: the English Indices of Deprivation 2025, including the Index of Multiple Deprivation (Ministry of Housing, Communities and Local Government)
- Wales: the Welsh Index of Multiple Deprivation 2025 (Welsh Government)
- Scotland: the Scottish Index of Multiple Deprivation (Scottish Government)
- Northern Ireland: the Northern Ireland Multiple Deprivation Measure (Northern Ireland Statistics and Research Agency)
- Ireland: the Pobal HP Deprivation Index 2022 (Pobal)
Are areas of higher deprivation sending in fewer applications for your community grant than you would expect? That is where to focus promotion next time, for example through community groups, local partners and local councillors.
Run the same breakdown after your next round and you can show members whether the extra outreach worked.
Add an impact phase for grantees
Once grants are awarded, add another phase to your form that asks grantees to report back on what their funding delivered, for example as an end-of-grant return. Ask countable questions here too, such as how many people took part, and keep space for the short stories and case studies members like to share.
This is where cross-phase reporting pays off. One report gives you a row per grantee, with their application answers and impact answers side by side, so there is nothing to match up by hand. If you add the new phase later, it appears in the column builder automatically, so you don’t need to rebuild the report.
Track where the money has gone
If grant tracking is switched on, the Grant Tracking card on the Reports dashboard gives an overview across every form you can access. It shows totals for budget, awarded, drawn and remaining, charts of awards and drawdowns over time, and a breakdown for each form.
On a form with more than one phase, grant tracking is switched on for each phase separately, so check it is enabled on the phase where you record awards.
For leadership, that answers “how much have we committed, and how much has gone out?” without anyone building a spreadsheet.
Show how funding decisions were made
Impact tells members what the money achieved. Scores show how it was allocated, which matters when someone asks why one project was funded over another.
The Scores report lists every score by reviewer and criterion for each application, with the phase it belongs to. To rank applications, add scores to a Summary report and sort by average score.
9.05 Generating reports on scores
Show what changed, and when
When auditors or members ask what happened and when, Audit Search lets Team Leaders see who changed what on the account, from an application’s answers to a form’s settings, with the old and new value for each change. Each saved report also keeps its own record of who viewed or downloaded it.
Find out more
The next time leadership or elected members ask who your funding reached and what it achieved, start in Submit.com. The reporting section of our help centre covers all of this in more detail:
- 9.01 Reports video tutorial
- 9.02 Reports and Statistics comprehensive guide
- 9.03 Selecting specific information in a report
- 9.04 How to pull information from a table in your form
- 9.05 Generating reports on scores
- 9.06 How to see who changed what with Audit Search
- 9.07 How to create, run and share custom reports
If you have a reporting question we have not covered here, our support team is happy to help.











0 Comments