Skip to main content

Five Ways to Ensure Compliance with Your Grant Management System



As a grantor or a grantee, your organization is responsible to ensure compliance with the terms and conditions of the funding that you receive.  My company InfoStrat has implemented grant management systems for U.S. government agencies and non-profits for over twenty years.  Here are some of the principles that we follow in order to help clients achieve compliance and accountability as efficiently as possible:

  1. Focus on your system of record.  Having a central system that is the authoritative source of information on your grants is essential for high quality data and accurate reporting.  Try to eliminate and discourage additional "side" systems such as spreadsheets and Access databases which may lead to inconsistent data or calculations.  
  2. Respect your data. Keeping your database clean is a constant process, but is the only way to meet your compliance goals. Encourage users to take care in data entry, and create validation where possible to capture errors.  Audit reports can be helpful when validation rules are not sufficient to show data anomalies. 
  3. Make your data fit your business rules. We have learned that there is no single, universal data model or set of business rules that is appropriate for all grant programs.  Funding may come with complicated conditions that govern progress payments and post-award reports.  You must make your system match the compliance rules, because by the time you have received funding it is almost always too late to change the rules. For instance, in the most common data model that we encounter, an agency receives one or more funding sources for a program, and that program funds individual grants.  Under a grant there may be one or more projects.  This is the data model used in Grants Manager Plus.  Some agencies, however, may have different data relationships, such as a project spanning multiple grants, or only a single funding source per program. With a flexible grant management system, you can model the appropriate relationships and data elements. 
  4. Use structured data rather than documents when appropriate. Some agencies approach grant management as a document management problem.  They use fillable forms for accepting applications, and create storage and search mechanisms to handle the documents.  While documents and other file attachments are useful and appropriate, the problem with a document-based approach is that it makes validation and reporting quite difficult.  Having grantees fill out online forms rather than submitting documents as email attachments allows you to create a stronger structure and have conditional logic to improve the quality of data.  By gathering consistent data from all grants, you can build meaningful reports and make ad hoc queries when necessary.  Our clients are often required to respond to information requests from government executives.  Pulling reports out of a folder full of documents is much more painstaking (and not repeatable) than using a query writer in a database. 
  5. Document your compliance rules and processes. The unique requirements of a funding source almost always translates to complex rules.  You must write down these rules and diagram them in order to understand the process and automate it.  The requirements documentation should spell out such details as reporting formats, scoring criteria, acceptance criteria for payment requests, reporting schedules, and all the other details of your grant business processes.  Too often these rules are implicit rather than explicit, and they often end up handled informally outside the grant management system (bringing us back to item 1). 
In addition to enhancing compliance, a comprehensive grant management system will make it easier to train new users, and help grantors and grantees be more responsive so that they can focus on the work of achieving the goals of a grant program.

For more information on grant management and Microsoft Grants Manager Plus, see my posts:

InfoStrat Releases New Versions of Grants Manager Plus
Microsoft Grants Manager Plus Frequently Asked Questions (FAQ)
User Stories for Grants Manager Plus
6 Things to Look for in Grant Management Software
Estimating the Cost of a Microsoft Grants Manager Plus Implementation
Grants Manager Plus: Theme and Variations
Microsoft Grants Manager Plus
Online Resources for Microsoft Grants Manager Plus
Portal Options for Microsoft Grants Manager
Statewide Grant Management Systems
Usage Scenarios for Microsoft Grants Manager

You can view a PowerPoint presentation on Grants Manager Plus

Popular posts from this blog

The DATA Act Driving Grant Management Automation

The Digital Accountability and Transparency Act enacted in May 2014 calls for making spending data available in open, standardized formats to be published online.  It is a continuation of transparency initiatives and lessons learned with experiences such as grants.gov, the 2009 economic stimulus under the Recovery Act and the spending site USASpending.gov.

Government grantees will have significant new administrative responsibilities.  Many organizations that were tracking grants in spreadsheets or documents will have to adopt more sophisticated automated grant management systems such as Microsoft Grants Manager to keep up with reporting rules.

For profit companies will lose some privacy as a result of this law.  Grant recipients will be required to disclose information including officer salaries.

Continued improvements to publishing grant opportunities such as grants.gov may make it easier to find grants. These reforms together are designed to improve the effectiveness of grant prog…

Dynamics 365 for Government Contractors (GovCon) Frequently Asked Questions (FAQ)

One of InfoStrat's most popular solutions is Dynamics 365 for Government Contractors (GovCon).



Here are some answers to frequently asked question on this solution:
Can I add new fields to the solution?  -- Yes, the solution is fully customizable and you can add your own new fields to any form, view or report.Does Dynamics 365 for GovCon work on mobile devices?  -- Yes, Microsoft offers mobile apps for all the most popular platforms including iPhone, iPad, and Android phone and tablets.Does Dynamics 365 connect with bid data systems such as Deltek and Onvia?  -- Some information services, such as Onvia, offer integration with Dynamics 365.  Others require third party solutions such as the InfoStrat integration with Deltek GovWin IQ.What do customers typically customize for their unique requirements? -- Not all contractors follow the same steps in the capture process.  Most clients will tailor the business process to add or remove steps in order to match their sales methodology.  Of…

Introducing InfoStrat ProShop Professional Services

InfoStrat has recently announced a new service offering called ProShop to allow its clients access to dedicated support and software development services throughout the year outside of a structured project.  This service complements InfoStrat's specialties of Microsoft Dynamics, SharePoint, ClickDimensions, Scribe, Sitecore, and custom development.

ProShop addresses your information technology goals without hiring a fulltime overhead employee.
For a predictable monthly subscription, you’ll get personalized support. Your costs are fixed, so you can budget without surprises. You’ll have a dedicated consultant who will help you identify issues, upgrades, customizations, training, and goals. Whenever you need help, you know exactly how to get it—your consultant, backed by our team of experts.

While most of our services are either projects staffed by a full team or staff augmentation of certain roles to a project team, clients may need not only ongoing support but ongoing development s…