Somewhere in your shared drive there is a spreadsheet called something
like Grants 2025 FINAL v3. It has a row per application, a column
somebody added for the report deadline, another for “status” whose values
have drifted (submitted, Submitted, sent??), and a tab from last year
nobody dares delete. One person understands it. She is also the person
writing the applications.
The spreadsheet exists for a defensible reason: your database holds contacts, and a grant is not a contact. It has its own life. It moves through stages (researching, drafting, submitted, awarded, reporting), it has its own dates and amounts, and it is attached to a funder and to the people at the funder. None of that fits in a contact record’s notes field, so it moved to a spreadsheet, and the spreadsheet became the system.
The failure is structural, not personal
The grant spreadsheet fails the same three ways everywhere:
- It is disconnected from the people. The program officer you met at a conference is in your database; the application she is reviewing is in the spreadsheet. When she emails, whoever answers cannot see that a $40,000 decision is pending behind the pleasantries.
- Stages drift into prose. “Waiting on budget from Karen then resubmit” is a status only its author can act on. Nothing can count, remind or report over sentences.
- It cannot tap you on the shoulder. A spreadsheet does not know the interim report is due in two weeks. The deadline column is only as good as the last person who scrolled past it.
The same story plays out for pledges, volunteer shifts, equipment loans and case files. Any time your work has a thing with its own stages and the database only offers contacts and deals, a spreadsheet is born.
A record type of your own
The fix is not a grants product. It is a database that lets you define the record type yourself.
In Mercleo’s Audience area, a custom record type is exactly that: you name it (Grant), give it your fields (amount requested, program, report deadline), define its stages, and link each record to the companies and people it involves. From then on grants behave like first-class records. The funder’s company page shows every application you have ever sent them. The pending grant sits beside the program officer’s emails, on the same timeline. Reports run over grants the way they run over anything else, because stages are data rather than prose.
And because it is one platform, the connections come free. The funder who attends your showcase event is the same record the grant hangs off. The thank-you campaign to this year’s funders is a list, not an export.
Retiring the spreadsheet
The migration is smaller than it feels: your columns become fields, your tabs become stages, and the CSV imports with dedupe against the funders you already have. What you retire is not really a file. It is the job of being the only person who knows what the file means.
Grants were never a spreadsheet problem. They were a “my database only believes in contacts” problem, and that one is solvable.
Posts on this blog are general information, current as of their publish date. They are not updated as laws, regulations, or products change. Nothing here is legal, tax, accounting, financial, or other professional advice, and reading a post does not create an advisor relationship of any kind. Check requirements against official sources, and talk to a professional advisor about your organization's situation.
Descriptions of Mercleo products, features, or pricing reflect the product at the time of writing and are not a commitment. The current product pages are the reference. Links to third-party sites are provided for convenience, not endorsement; we don’t control what’s on them.