The Submission Library

The Submission Library is your record of every grant you have applied for: what you asked for, who you asked, and how it turned out. It is the one place in PowerGrant that looks backwards.

It earns its keep twice. It answers “what have we submitted this year, and how did we do?” without anyone rebuilding a spreadsheet. And it feeds three things elsewhere in PowerGrant: the Analysis that compares your wins against your losses, the funder recommendations in Funder Finder, and the sources Query can cite back to you.

Getting submissions in

There are two ways, and most organizations use both.

From a draft you just finished. At the top of the Application Workspace, Send to Submission Library carries the finished application across. This is the normal path once you have written something in PowerGrant.

By hand, for everything that came before. Click Add submission. Nothing stops you entering grants from years before you started using PowerGrant, and it is worth doing. A library with only this year’s applications in it can tell you very little.

Recording what happened

Every submission carries an outcome: Won, Lost, or Pending.

Pending is the honest answer for anything you have not heard back on, and it is the default. Marking a submission Won opens a few more fields, including the award date and the amount you actually received, which is often not the amount you asked for. It also offers Track reporting for this award, which schedules the reports the funder expects; see Reporting on an award.

Keeping outcomes current is the single highest-value habit here. A library where everything says Pending cannot tell you anything, and the Analysis below has nothing to compare.

The table, and the columns you care about

Eight columns are available:

Column	What it holds
Title	The application’s name. Always shown.
Funder	Who you applied to.
Date Submitted	When it went in.
Outcome	Won, Lost, or Pending.
Awarded	The date of the award, for anything you won.
$ Requested	What you asked for.
$ Awarded	What you actually received.
Project	The project the submission belongs to, if you tag them.

By default you see Title, Funder, Date Submitted and Outcome, because that is what most people scan for. Use the column picker to turn the others on. That choice is remembered on the computer you are sitting at, so turning a column on at the office does not turn it on at home.

Above the table you can search by title or funder, filter by outcome, and narrow to a Period:

• All time, the default.
• This Year, the current calendar year.
• Past 12 Months, counting back from today.
• Custom Range, where you set the two dates yourself. Leaving one blank means “no limit on that end”.

The period matches on Date Submitted, so a submission with no date recorded drops out of the table while a period is set. Sort by clicking any column heading.

These three narrow the table together, which is the useful part: show me this year, only the wins, then pick from what’s left.

Comparing submissions with Analysis

Narrow the table first if you want to, then tick two or more submissions and Analyze compares them, looking for what the winning applications did that the others did not. Filtering to a year and an outcome before you select is usually faster than hunting through the whole library.

It also works on a single submission if that one was Lost and you have saved the funder’s scored feedback against it. That is the most useful analysis PowerGrant does, and it needs the feedback to be in there.

Exporting a report

Tick the submissions you want and click Export to download a CSV. It opens in Excel, Google Sheets, or Numbers.

The report is exactly what you ticked. Narrow the table first with the search, outcome and period controls, then select from what you see.

A few things worth knowing before you send the file to anyone:

• The report always contains all eight columns, even the ones you have hidden. The column picker changes what you look at, not what you send.
• The button tells you how many rows you are about to download, as in Export (7).
• If you change a filter after selecting, a line says how many of your ticked submissions are now hidden. Your selection survives searching and filtering on purpose, so you can build one set out of several passes (this year’s wins, then last year’s), and the report includes everything ticked, shown or not.
• Amounts are exported as plain numbers, so the person who opens the file can total the column.

Frequently asked

Do I have to write a grant in PowerGrant to keep it here? No. Add anything you have ever submitted.

Does the AI use my past submissions? For some things. Analysis compares them to find what your winning applications did differently, Funder Finder takes your giving history into account, and Query can cite a past submission as a source. Writing a first or second draft works from your knowledge base, not from this library, so a fact you want in a draft belongs there.

Can I get the full application text out, not just this summary? The report is the record of the submission. To export the written application itself, use the Word export in the second draft and exporting.

Can I report on a whole year without ticking each row? Set the period, then use the checkbox in the table header to select everything currently shown.

Someone deleted a submission I had ticked. The count updates on its own, and a deleted submission is never in the report. A submission that is merely hidden by a filter is the other case: that one stays in, and the bar says so.