MAC HOW-TO

How to keep a grant deadline calendar (free spreadsheet and calendar file)

Updated

Short answer

Keep one row per grant with every date that can be missed: the letter of inquiry, the application, the decision, and the reports due after you win. The workbook below does that and turns dates in the next 30 days orange. Put the same dates in your calendar as all-day events with an alert, and start each report’s draft about ten days early. It’s a plain spreadsheet: it knows nothing about any funder, so check every date with them.

Free downloads

No sign-up. Use them for your own organization; please don’t resell them.

The free ways

Free: the spreadsheet

  1. Open the workbook and go to the sheet called My grants. Type one row per grant; leave any column empty.
  2. Use Stage for where it is: Prospect, Letter of Inquiry, Drafting, Submitted, Awarded, Declined or Withdrawn.
  3. When a grant is awarded, fill in Award start, Award end and Next report due the same day. Report dates are the ones people forget.
  4. Sort by Application due to see what’s next. Dates in the next 30 days turn orange on their own.
  5. Go through it together once a month, and before every board meeting.

Free: your own calendar

  1. In Calendar, choose File › New Calendar and call it Grants, so the whole set can be shared, hidden or deleted.
  2. Add each date as an all-day event with an alert a week before.
  3. Add a second event for each report about ten days before it’s due: start the draft.
  4. To try it with the made-up example, choose File › Import in Calendar, pick the .ics file, and choose that calendar. In Google Calendar on the web it’s Settings › Import & export.

Where the free ways stop

  • A spreadsheet doesn’t remind anyone, and a calendar doesn’t show amounts, stages or who is responsible.
  • The two drift apart: a date moved in one has to be moved in the other by hand.
  • One row holds only the next report. A three-year award with quarterly reports has twelve.
  • Neither one knows a funder’s rules. Dates come from the award letter and the funder, and they change.

How Fundsheet does it

Fundsheet is a Mac app we make: grants and the board for small nonprofits, kept on your Mac.

  1. Save the sheet as CSV and choose File › Import Spreadsheet in Fundsheet. It matches the columns from the header row; funders are matched by name or added, and importing the same sheet twice adds nothing.
  2. For an award, choose how often it reports (yearly, half-yearly, quarterly or monthly, plus the final report). Fundsheet makes the reports from the award dates, each with a draft date ten days earlier unless you change it.
  3. Today lists what’s overdue and what’s due in the next 7 and 30 days. Share › Calendar File makes an .ics of your real dates, and importing a newer one updates the same events.
  4. Free: up to 5 grants and 3 board meetings per file, with CSV import, calendar files and reminders. Pro takes off the limits.
Fundsheet's Today page: grant deadlines and the board's action items together, with figures across the top
An award's reporting schedule and its generated reports, each with a due date and a draft date

Free to use without a key: everything, up to 5 grants and 3 board meetings per file, with a small “Made with Fundsheet” line on PDFs, for good.

$29 one-time for Pro, no subscription. Buy a license key to unlock Pro: unlimited grants and board meetings, the year’s Minute Book PDF and search, PDFs without the footer and your logo on grant PDFs. Studio adds the Portfolio window and a status report PDF per client.

macOS 14 Sonoma or later. Apple silicon and Intel.

Questions

Are the grants in the example real?

No. Every grant, funder, amount and date in the example files is made up, and each row says so. No real foundation is named.

Does it find grants for me?

No. Neither the spreadsheet nor Fundsheet has a list of funders. They keep track of the ones you already know about.

Can I use it in Google Sheets or Numbers?

It’s a plain .xlsx workbook, which both of them open, with a list for Stage and one color rule. If either doesn’t carry over, the dates and columns still work.

When should I start a grant report?

There’s no rule; it depends on who has to give you numbers. Fundsheet starts with ten days before the due date and lets you change it for all reports or for one.

Sources