• About
    • The Attain Way
    • Leadership
    • Who We Serve
    • Alliance Partners
    • Contract Vehicles
    • Attain Digital
      • Executive in Residence Program
    • Attain Research
      • NIH’s Flat Rate for Research Overhead
      • Uniform Guidance
  • Services
      • Services
      • Technology
        • Salesforce Innovation
          • Managed Services for CRM
          • Attain Accelerate
          • Salesforce Digital Engagement
        • Application Development and Modernization
        • Enterprise Business Solutions
        • Advanced Analytics
        • Data Science
        • Emerging Technology
      • Strategy
        • Inclusion, Diversity, Equity, and Allyship (IDEA) Transformation Services
        • Program and Project Management
        • Organizational Transformation
        • Change Management
        • Strategic Planning
        • Business Process Modernization
        • Strategic Finance
        • Enrollment Management and Student Services
        • Shared and Managed Services
        • Library Planning and Strategy
        • Juran, an Attain Partners Company
      • Compliance
        • Grants Management
        • Cost Recovery Optimization
        • Financial Aid
        • Interim Staffing
        • Contract Negotiation
        • Asset Management and Valuation
  • Products
    • Research Performance
    • Strategic Finance Performance
    • Rate
  • Newsroom
    • Blog
    • Events
    • News
    • Insights
    • Awards
    • Case Studies
  • Careers
    • Open Roles
  • Contact
    • Subscribe
  • Linkedin
  • Twitter
  • Facebook
  • About
    • The Attain Way
    • Leadership
    • Who We Serve
    • Alliance Partners
    • Contract Vehicles
    • Attain Digital
      • Executive in Residence Program
    • Attain Research
      • NIH’s Flat Rate for Research Overhead
      • Uniform Guidance
  • Services
      • Services
      • Technology
        • Salesforce Innovation
          • Managed Services for CRM
          • Attain Accelerate
          • Salesforce Digital Engagement
        • Application Development and Modernization
        • Enterprise Business Solutions
        • Advanced Analytics
        • Data Science
        • Emerging Technology
      • Strategy
        • Inclusion, Diversity, Equity, and Allyship (IDEA) Transformation Services
        • Program and Project Management
        • Organizational Transformation
        • Change Management
        • Strategic Planning
        • Business Process Modernization
        • Strategic Finance
        • Enrollment Management and Student Services
        • Shared and Managed Services
        • Library Planning and Strategy
        • Juran, an Attain Partners Company
      • Compliance
        • Grants Management
        • Cost Recovery Optimization
        • Financial Aid
        • Interim Staffing
        • Contract Negotiation
        • Asset Management and Valuation
  • Products
    • Research Performance
    • Strategic Finance Performance
    • Rate
  • Newsroom
    • Blog
    • Events
    • News
    • Insights
    • Awards
    • Case Studies
  • Careers
    • Open Roles
  • Contact
    • Subscribe
  • Linkedin
  • Twitter
  • Facebook

Attain Partners at Nonprofit Dreamin 2021

January 21, 2021/in Events, Nonprofit, Salesforce, Salesforce Community Aaron Crosman/by Olivia Pycha

This fall, I was invited to join the Nonprofit Dreamin planning committee. “Dreamin” events are community-driven events in the Salesforce ecosystem and this one is the first major event planned BY the nonprofit community FOR the nonprofit community. Attain Partners encouraged me to spend time supporting the planning and marketing of this inaugural event and as the event took shape, Attain Partners came on board as a sponsor as well. 

As someone who has worked for and with nonprofit organizations for nearly 20 years, it has been exciting to be part of a project with so many people whose experiences exceed my own. I offered my expertise in digital outreach to help coordinate and drive the marketing efforts. For me, those efforts aligned with one of the great joys I find working with nonprofit organizations day in and day out. By helping nonprofits improve their use of technology to advance their mission, I believe that I am making the world a better place for everyone and our shared community. 

Coming together and learning from each other is the most powerful force for change. I have observed that the nonprofit community gets much of its strength from collaboration. It is at events like this that we catalyze each other to think creatively about how to harness the power of technology to achieve our missions.  

While we cannot fully replace the experience of meeting someone new over lunch, we are trying to use everything we’ve learned from a year of virtual conferences. We want to make this conference more than just a series of one-way broadcasts. In that spirit, one of the elements I am really excited about are the ‘collaborative spaces’. In addition to great sessions on tools like Outbound Funds, process improvements like demystifying Agile, and community improvement like the DEI panel, we have also layered in spaces for collaborative and one-on-one meetings. A great opportunity to connect, learn and collaborate! 

So, please join us as we all come together to support, grow, and expand our knowledge. Nonprofit Dreamin will have something for everyone, from people still considering Salesforce and long-time practitioner like me. 

Want to learn more?

Contact us at [email protected] with any questions, to get additional details, or to discover how we can support your organization.

About the Author 

Aaron Crosman is a Senior Specialist in Attain Partners’ Salesforce Services Group. After a decade working IT and Digital Communications for a nonprofit, Aaron moved to consulting to help organizations create first-class online communications systems. He specializes in Drupal development and Salesforce integrations for our nonprofit and higher education clients. 

0 0 Olivia Pycha Olivia Pycha2021-01-21 16:05:212023-03-14 13:30:47Attain Partners at Nonprofit Dreamin 2021
Illustration of laptop with business graphics

Key Strategies for Successful Data Migration

January 21, 2021/in Best Practices, Nonprofit, Salesforce, Thought Leadership Deepa Bedi/by Olivia Pycha

Considering moving to Salesforce Nonprofit Cloud? The key to a successful project is successful data migration; and that starts with the health of your data. Addressing data quality, cleanliness, governance, and stewardship in advance builds trust and maximizes user adoption, efficiencies, and accurate reporting for your internal and external users and stakeholders.

Reliable and accessible data enables you to better and more rapidly achieve your goals so that you can spend more time on mission-critical work. It also allows you to leverage the latest predictive analytic techniques for constituent engagement and retention.

Where to Begin?

The idea of data migration can be daunting and complex. Careful planning, expectation setting, and execution is needed to accelerate onboarding and to avoid frustration and budget overrun later.

To successfully plan and strategically manage your data migration, adhere to the following key principles.

Identify Your Data Experts & Super Users

Super UserIdentify and engage your existing data experts. These are individuals using the system daily and have a deep understanding of the ways in which data enter and leave the system. Make sure they understand the time commitment and level of involvement needed before the project begins.

Establish a Well-defined Process for Decision Making

ProcessBe ready to answer important questions such as: What data should be migrated? What should be archived? How do we translate the data? Which processes need to remain the same? Which can be made more efficient? Have you prioritized these items?

Communicate & Set Realistic Expectations

communicationEnsure that your core and ancillary teams consist of users across departments and functional areas. Communicate early and often throughout the process through weekly office hours, internal newsletters, small demos, etc.

Establish a Practical Data Governance Plan

Governance PlanThe plan should include data cleansing, data security, data entry, and stewardship rules and processes. Your data must continue to be visible and open to your users, otherwise user adoption may be threatened.

Identify Areas of Process Improvements

Process ImprovementDon’t miss out on the opportunity to improve, and don’t get bogged down with a no-data-left-behind mentality. Focus on what you NEED moving forward, not how things have been done in the past. Identify critical reports for each functional area that teams will need in Salesforce on day one.

What’s Next?

Make sure you’re ready for the move by getting up to speed on all things Salesforce. Trailhead is a great way to gain a foundational understanding of the Salesforce platform and its capabilities. Check out the Focus on your Data module, which includes useful links on data quality, data archive, and duplicate handling, to help you better understand the nuances of the Salesforce Nonprofit Cloud.

Want to Learn More?

Contact us with any questions, to get additional details, or to discover how we can support your Salesforce migration project. Attain Partners’ team of data migration experts can help you think through your data migration strategy, data governance plan, as well as execute a successful migration with great care.

About the Author

Deepa Bedi is a Principal at Attain Partners delivering Salesforce services and solutions to clients. She has led over 100 transformational cloud-based implementations and integration projects for our higher education, nonprofit, and healthcare clients to help them achieve business success. Deepa has been engaged in the Salesforce ecosystem for over 15 years and is passionate about enabling nonprofits and higher education institutions to achieve their missions through customer-centric technology solutions.

Be the First to Know

Subscribe to our monthly Pulse newsletter
to be the first to hear about new blog posts

Subscribe
https://attainpartners.com/wp-content/uploads/Graphics_2024-04_Maximizing-Investment-AttainPlus.webp 628 1200 Olivia Pycha Olivia Pycha2021-01-21 15:59:142024-05-14 17:49:40Key Strategies for Successful Data Migration

Introducing Admissions Connect – Scale for Speed, Flexibility, and Maximum Engagement

November 19, 2020/in Higher Education, Salesforce, Thought Leadership Alanna Steffens, Kaia Brown/by Josue

We know that this year, more than any other, has created opportunities for change. That’s no exception for Salesforce.org which has a major change on the horizon, and we couldn’t be more excited. It has been a persistent challenge for our customers to implement a cost-effective, low-technical debt solution to address recruiting and admissions.   

The recruiting and admissions part of the student lifecycle is frequently regarded as the key first step in introducing CRM to higher education institutions looking to gain visibility and efficiency while increasing the quality of prospects. From undergraduate, to graduate, non-degree, and lifelong learner programs, Salesforce’s Education Cloud has allowed customers to increase enrollments by an average of 11% over three years. 

With the release of Admissions Connect, institutions are one step closer to a complete 360-degree view of their constituents. As Salesforce prepares to launch Admissions Connect, it’s a great time for institutions to evaluate if your current recruiting and admissions solution is meeting your goals. 

Introducing Admissions Connect 

Salesforce is rolling out its newest Education Cloud offering, Admissions Connect, an EDA-based Recruiting and Admissions solution. Admissions Connect will provide increased flexibility to recruiting and admissions teams, with a unified student view to maximize productivity and engagement. With built-in SIS integration support, Admissions Connect enables teams to quickly leverage application data to maximize constituent engagement. 

Admissions Connect Screen Shot

Is Admissions Connect Right for Your Institution? 

We believe the answer is yes. But if you need proof, review the questions below: 

  • Do you struggle to support multiple prospecting streams for undergraduate, graduate, non-traditional, and lifelong learner programs?   

  • Are you supporting and managing multiple complex integrations to other systems? 

  • Are you leveraging native Salesforce architecture (EDA, NPSP) that supports enterprise growth? 

  • Are your event management and email marketing solutions leaving you with blind spots that prevent you from effectively scoring prospects?   

  • Are prospects dropping off during the application and recruitment process, but you can’t understand why? 

If the answer to any of these questions is yes, then Admissions Connect on Salesforce may be the next step in your institution’s journey. Our team would be happy to talk with you about our experience with institutions going through a similar evaluation, help you determine the right path forward, and support you along the different stages of that journey. 

How can I get started with Admissions Connect? 

Contact us at [email protected] with any questions, for additional details, or to schedule a demo. We will show you how you can incorporate Admissions Connect into your overall vision for a cloud-based, unified constituent experience. 

Attain Partners has achieved the rank of Expert in Education Cloud, Salesforce’s highest recognition for consulting partners. As a Premier Partner with Salesforce.org, Attain Partners has contributed to the evolution of solutions under the Education Cloud, including the new Recruiting and Admission offering, Admissions Connect. Our team provided essential design input and feedback for Education Data Architecture (EDA), Advisor Link, and Gift Entry Manager (GEM). Salesforce’s commitment to the expansion of Education Cloud features allows clients to stay native, reducing maintenance needs and priming institutions for scale. 

About the Authors 

Alanna Steffens Headshot

Alanna Steffens is the Practice Lead of Attain Partners’ Salesforce Services Group. With almost 10 years in the Salesforce ecosystem, her experience in higher education spans the student-facing lifecycle and support for backend management functions. Alanna has led several successful large-scale recruiting and admissions projects, and gladly welcomes the Admissions Connect product into the suite of tools available for our clients within the Education Cloud. 

Kaia Brown Headshot

Kaia Brown is a Senior Delivery Manager in Attain Partners’ Salesforce Services Group. After five years in the healthcare industry working as a Salesforce Product Owner, Kaia made the move to consulting to help commercial, nonprofit, and higher education clients maximize their Salesforce ROI. She currently leads enterprise technology transformations for our nonprofit and higher education clients, with a focus on creating unified experiences for teams and the constituents they serve. 

0 0 Josue Josue2020-11-19 14:32:122021-08-20 02:34:09Introducing Admissions Connect – Scale for Speed, Flexibility, and Maximum Engagement

Extending Salesforce Accounting Subledger for Oregon State University Ecampus

November 10, 2020/in Higher Education, Salesforce, Thought Leadership David Bruce, Jeff Cowgill, Kaia Brown/by [email protected]

Initially designed with nonprofit fundraising in mind, Salesforce’s Accounting Subledger can also significantly benefit universities that need to manage complex transactions with payables, receivables, and interdepartmental transfers. Many departments use CRMs like Salesforce to track grants, services, and more. Subledger provides a way to link operational data effectively and efficiently with financial systems and creates efficiency by reducing or eliminating manual processes.

As a Salesforce.org partner since 2005 that has implemented over 800 higher education and nonprofit projects, Attain Partners was invited to contribute to and collaborate on key design decisions in the development of this new package. We were excited to be the first implementation partner to enable this essential functionality for a client this summer, giving the organization more time to engage with their constituents and less time working on accounting.

OSU logoOregon State University Ecampus (OSU) sought a solution to streamline their online course and program development systems and financial operations. Their interdepartmental transfers relied heavily on highly manual and redundant steps and involved manipulation of multiple spreadsheets.

Attain Partners implemented and configured Subledger to securely manage payments and reconcile ledger entries in the format required by Banner Financials. Attain Partners has worked directly with Salesforce on the development of Subledger and selected it for OSU to add the rigor and transparency they needed for its financial operations. To complement this, Attain Partners leveraged native Salesforce reports and dashboards to provide other Ecampus groups detailed insights across each stage of their operations. Why Subledger?

  • Limits technical debt – no need to maintain complex, custom code

  • Future proof – solution maintained alongside Nonprofit Success Pack (NPSP)

  • Ad hoc reporting – takes advantage of native Salesforce reporting

  • Rapid prototyping and testing – quickly builds trust between functional teams and finance

  • Reduced risk – uses codified and automated standards of data processing

  • Data transparency – provides predictable information between groups

  • Clicks not code – uses declarative code to update or adjust solution

How can I get started with Subledger? 

  • Contact us at [email protected] with any questions, to get additional details, or to discover how we can support incorporating Subledger into your overall vision.

  • Watch Attain Partners’ free, on-demand webinar: Seven Ways to Get More out of Salesforce with Subledger

  • Review the Salesforce Accounting Subledger product guide for an overview of the features.

  • Request a demo by reaching out to us or your Salesforce Account Executive to explore this licensed product.

For more information about Oregon State University Ecampus, visit Ecampus.oregonstate.edu.

0 0 [email protected] [email protected]2020-11-10 18:57:022021-09-08 10:43:59Extending Salesforce Accounting Subledger for Oregon State University Ecampus

Trailblazing the Attain Partners Way

November 3, 2020/in Higher Education, Nonprofit, Salesforce, Thought Leadership Austin Wilson/by Reach Local

Salesforce’s mission is to empower organizations to connect with their audiences in a whole new way. The on-demand training modules of Salesforce’s Trailhead program make it even easier to use as they provide no-barrier access and an equal playing field for adopting the cloud. Whether you are a super user or accidental admin, Trailhead supplies essential resources to navigate all the features offered by Salesforce.

After several years working in the Salesforce ecosystem, here are my recommendations for Trailheads that will get you and your team on the right track to achieve your CRM goals:

New Content Releases 

With the Spring 20’ Release, Salesforce moved away from three maintenance exams a year to just one; you might decide to focus less on Trailhead and more on work at hand. However, much like staying up-to-date with the world news, staying current with Salesforce’s new releases, both monthly and annually, is critical to staying on top of changes coming to your org. Keep up with emerging trends like Contact Tracing for COVID-19 to learn how Salesforce is developing solutions to help organizations contain the virus and keep your workforce safe.

Training Your Team 

Change at any scale is never an easy undertaking, and adopting a new platform can be an even greater challenge. Preparing your team for upcoming change is essential for a successful technical initiative. Attain Partners’ Prosci certified change management experts strongly recommend helping your first-time users gain confidence in Salesforce by taking a couple of Trailheads, preparing them for further training and setting them up for post-implementation success. By taking this step, users have a sense of ownership, and are significantly more prepared for change.

Making Your Mark 

If you do not already have an Administrator certification, it is an absolute necessity in your Salesforce journey. It validates that you have the baseline knowledge of the Salesforce platform and is a requirement for all other certification paths. Preparing for your Administrator certification can feel like a sprint or a marathon, but with proper preparation, it can be achieved. If you pass on the first try, that is definitely a reason to celebrate! If you do not pass, don’t stress! Review the areas where you can improve, and make a game plan to focus on those in your studying.

Migrating to Lightning 

If you haven’t migrated to Lightning yet, the sun is setting, and it is always better to ride the wave than to crash with it. Salesforce develops new Lightning- only features that offer competitive, if not better features, than Classic. If you want to be amazed at what Lightning can offer, check out Salesforce’s whitepaper on Lightning Only Features.

Now What? 

If you have not already utilized Trailhead, then now is the time, proceed to Trailhead and follow the trail that most closely aligns with your role and experience level. In addition to Salesforce’s curated content, Trailmixes created by industry experts provide relevant modules and external links. Can’t find the right trail? Create your own Trailmix for you or your team that meets your needs by visiting Trailhead.

Still unsure of which path to take? Attain Partners offers expert services to guide your journey with Trailhead, Marketing Cloud, and more. Reach us directly at [email protected].

Attain Partners has extensive experience working with our clients to deliver transformative solutions. A key component of this success is guiding users and admins with Trailhead to get the most out of their Salesforce investment. We have helped many organizations transition to Lightning as well as to the Nonprofit Success Pack (NPSP) and Education Data Architecture (EDA). Team Attain Partners’ deep expertise with Salesforce implementations, digital transformation, and change management combined with your investment in Trailhead create a solid foundation to promote a smooth and successful cloud implementation.

About the Author 


Austin Wilson is a consultant in Attain Partners’ Salesforce Services Group. In addition to working with nonprofits and higher education institutions, he has experience working with federal agencies. Austin is currently studying for his seventh Salesforce certification with the help of Trailhead. 
By Austin Wilson, Consultant

0 0 Reach Local Reach Local2020-11-03 01:15:402023-07-07 16:56:43Trailblazing the Attain Partners Way

2020 Giving Tuesday Preparation Checklist

October 12, 2020/in Fundraising, Nonprofit, Salesforce Aaron Crosman/by Josue

2020 has certainly been a wild ride thus far. While the passing of time has ebbed and flowed, end-of-year deadlines are approaching at a frenzied pace. Believe it or not, Giving Tuesday 2020 is less than two months away. With so much happening this year, many organizations that would normally be well into preparations are suddenly scrambling to get started. 

Maybe you’re just jumping into the fray, or perhaps you are mid-preparation. Either way, Giving Tuesday will be here soon, and nonprofits need to be ready. With the added complexity of an election year and the economic impact of the pandemic, it is more important than ever to end the year on a high note. 

At the best of times, none of us know what will happen two months from now—and 2020 hasn’t been a year to try to predict—but there is still time to prepare and be ready to take full advantage of Giving Tuesday. To help make sure that your organization is ready, here is my 2020 preparation checklist: 

Elections Matter – Win or Lose, Be Ready 

If your organization is involved in politics, political issues, or social causes, you understand the significant impact a major election can have on your fundraising. If donors think of your mission as an outlet for their political ideals—or the challenges you address will be resolved by a shift in power—the election may impact their attitude toward giving in the weeks following the election. 

While crafting your strategy and content, take the different potential outcomes of the election into account. Create different versions that you can revise and refine based on the events as they are unfolding. Just because you don’t know today what will happen, doesn’t mean you cannot plan ahead by creating a version of events that feels like a win for your audience and a second that feels like a loss. Remember that what feels like a political win may be a revenue loss if you don’t emphasize the ongoing importance of your work in the new year. If your target audience is divided, you still need to understand how their opinions about the election may impact their feelings toward you and what you say three weeks later. 

Data Matters – Stop Putting Off the Cleanup 

Start by looking at last year’s data and setting metrics and goals for success this year. Break last year’s giving information down hour-by-hour and set hourly goals that allow you to track your progress over the course of the day. 

Next, make sure your email lists are organized and ready to go. Depending on your email tool and strategy, the details here can vary. Regardless, data owners and stewards should be working now to make sure that they have all the data they need, that audience segmentations are set up correctly, and that your organization can quickly and reliably execute on the delivery plan. 

Filtering out email addresses known to be undeliverable and removing the stale contacts that never open or click on your messages will improve deliverability and give you a more accurate view of what is happening in the moment. The first time I removed inactive addresses it felt like my list was shrinking, but in truth we had already lost people’s attention. After the cleanup, we had a much better picture of what was really happening, and we began to see our open and click-through rates improve. 

Practice Matters – Giving Tuesday is NOT the Day to Break in a New Tool 

The current generation of email tools and CRM databases is varied and immensely powerful. While Attain Partners’ Salesforce Services Group focuses primarily on the implementation and enhancement of Salesforce-specific marketing automation products such as Pardot and Marketing Cloud, we do not recommend sending your first message using these tools on Giving Tuesday. During the high-stress giving time at the end of the year, it’s better to be reliable than to be perfect.  

Even with tools you already know well, you’ll want to find ways to practice and test your plans. Create lists of your colleagues and friends that you can segment and target to send your trial messages. Test all the options on your giving page well in advance. If you have backup plans and tools to use, make sure you thoroughly test those as well. 

It is also critical that you are prepared to monitor the health of the system in real time so you will know quickly if something is going wrong. Validate that your data passes all the way through your various systems—including your main accounting ledgers—smoothly and reliably. 

How can I get help preparing for Giving Tuesday? 

The team and I would be happy to help you prepare for Giving Tuesday. Attain Partners offers easy-to-access support and expert services, including assessments and implementation efforts, to help your development teams realize the best giving year yet. Contact us at [email protected] with any questions, to get additional details, or to discover how we can support your fundraising efforts leveraging Salesforce. 

About the Author 

Aaron Crosman is a Senior Specialist in Attain Partners’ Salesforce Services Group. After a decade working IT and Digital Communications for a nonprofit, Aaron moved to consulting to help organizations create first-class online communications systems. He specializes in Drupal development and Salesforce integrations for our nonprofit and higher education clients. 

0 0 Josue Josue2020-10-12 21:01:122021-08-20 02:36:342020 Giving Tuesday Preparation Checklist

Tracking COVID-19 Expenses for Optimal Cost Recovery

September 29, 2020/in Higher Education David Moore/by Josue

When first considering the impact of COVID-19 on the facilities and administrative (F&A) rate at your research institution, it will be important to track and assess new costs to meet the demands created by the pandemic. Generally speaking and where appropriate, pooling these expenses with your institution’s operations and maintenance expenses provides significant opportunities. As an uncapped indirect cost pool with a variety of sub-pooling opportunities, the operations and maintenance (O&M) pool and sub-pools have the highest potential to optimize your institution’s rate.

Cleaning

One change that organizations of any size can expect from a transition to the next normal, where constituents return onsite, is an increase in cleaning and sanitation to combat the spread of the virus. Individuals returning for classes or work need to feel safe and comfortable with their environment. With this in mind, organizations can maximize their ability to recover indirect costs related to cleaning by making the right selections in their accounting systems to track these costs.

While cleaning costs already exist as part of the typical everyday operations, special attention should be paid to any enhanced cleaning protocols directly related to lab areas that are above and beyond what is being done for non-lab areas, such as extra cleaning intervals or additional sterilization measures. For these activities, institutions should seriously consider creating new accounting codes to track lab cleaning costs. Ideally, these additional costs for lab areas would be tracked in the institution’s accounting system with a specific code so that the costs can be easily identified during the next F&A proposal. This will streamline the cost tracking and reduce the risks of not being able to identify the costs, should a secondary tracking system break down.

Another important decision is who is going to oversee, monitor, and incur these costs. This will likely dictate how they can be treated in the F&A rate proposal. The three potential areas to allocate these costs are:

  1. Environmental Health & Safety
  2. Facilities Management
  3. Academic Departments

Since Environmental Health and Safety (EH&S) already has specific oversight of removing hazardous materials from lab areas, the best practice is to make lab cleaning costs part of the EH&S department, which is typically a separate O&M sub-pool. This will allow for an easy allocation of these costs based on lab and lab service square feet, which is an appropriate treatment and results in the highest recovery of the costs

While including lab area cleaning costs as part of EH&S is the best treatment, conducting any of these allocations as opposed to the general university or campus-wide sub-pool, the portion of these costs that will be attributable to research will likely be higher, which will cause an increase in the F&A rate.

You may also consider including these costs in the facilities management budget. However, this may cause them to lose their identity and become part of the overall facilities management operating expenditures. If this happens, the costs will most likely be identified to buildings and allocated on building square footage. Since these are costs related to lab areas, this is the least optimal choice for recovery as the percent of research space for an entire building is almost always lower than that of lab areas.

Should these costs be incurred within academic departments, they would likely be transferred into the departmental O&M sub-pool and allocated based on the space of the departments. While this would likely result in higher recovery versus including them with facilities management, it is still not ideal as the costs will be allocated to non-lab areas, which will lower the recovery of these costs as part of the F&A rate.

Tracking of PPE

Similar to cleaning costs, the expenses related to Personal Protective Equipment (PPE) will have an outsized impact when compared to previous years. Special care should be used to identify and track these costs specifically. As a best practice, create new codes (e.g., subaccount, object) within the institution’s accounting system if they do not already exist. This way, the costs can easily be identified when your institution prepares the F&A proposal. Another consideration is to determine if there is a significant difference in PPE costs for lab areas relative to all other areas. If so, it may be beneficial to track lab and non-lab PPE costs separately.

Once these costs are identified, they should be moved to O&M as these costs are for the security of the institution. If the identified PPE costs encompass all areas of the institution, they can be left in the campus-wide O&M pool. However, if the PPE costs for lab areas are tracked separately, they should be assigned to an O&M sub-pool, thereby allocating the costs to the benefiting lab areas. The EH&S sub-pool may accommodate this, but the institution should determine if a new sub-pool needs to be created to allocate the costs appropriately.

Contact Tracing & Testing

We know that many institutions will be conducting some level of contact tracing and testing on their campuses to supplement state and national efforts. These efforts should include some form of manual contact tracing, development and enforcement of new policies, and campus-wide testing. However, they may extend as far as the development or implementation of new applications to support contact tracing or workforce management. Each of these activities will incur costs in a variety of categories. These costs should also be considered so that they can be be treated appropriately in the F&A proposal. Because they are incurred as part of the security function of the institution, these costs belong in the O&M pool.

Renovations

While renovation costs may be the furthest afield from the current situation, the given magnitude of expense is high enough that it’s worth considering the implications as soon as possible. Should the current environment persist for an extended amount of time, institutions may consider pursuing lab renovations or retrofitting to divide lab space to minimize the potential for the virus to spread while maximizing active research.

If the project expense is above the institution’s capitalization threshold, the cost will be reflected in the depreciation used for the F&A proposal. If the project is below the capitalization threshold, accounting for the renovation expense becomes essential.

If the facilities management department incurs the cost, then the best practice is to identify the project to the building and allocate it based on the square footage of the building. However, if an academic department pays for the renovation, then it needs to be identified separately. Costs should still be included as part of the O&M sub-pool, but can be part of the departmental O&M sub-pool and will be allocated based on the space of the department.

Recap

COVID-19 related costs are likely to be significant to an institution’s F&A rate proposal preparation and should be an area of focus during the next rate-setting cycle. In summary, the following steps should be taken for any new COVID-19 costs:

  1. Determine if the costs for lab and lab service areas are significantly higher than for non-lab areas.
  2. Identify and track the expenses in the accounting system for easy identification and inclusion into the correct O&M sub-pool.
  3. Ensure the costs are genuinely O&M costs to be included in the O&M pool.
  4. Allocate the costs based on the appropriate space that supports the cost.

About the Author

David Moore

David Moore is a Manager in Attain Partners’ Education, Nonprofit, and Commercial Services practice. Since 2005, he has specialized in guiding higher education and academic medical center institutions on F&A proposal preparation and negotiation, F&A diagnostic reviews, space functional usage studies, service center rate calculations, and other costing issues. He is also the solution manager for AttainSpace and AttainRate. Mr. Moore is a frequent presenter at conferences, webcasts, and webinars on these subjects.

0 0 Josue Josue2020-09-29 00:06:132021-08-20 02:37:11Tracking COVID-19 Expenses for Optimal Cost Recovery

Salesforce Open Source Commons

September 2, 2020/in Salesforce, Thought Leadership Aaron Crosman/by Olivia Pycha

This year, Attain Partners has been a proud contributor in formalizing Salesforce.org’s Open Source Commons initiative to support the nonprofit community through new open source projects.

Over the years, our team has contributed to Nonprofit Success Pack (NPSP), Education Data Architecture (EDA), and other open source projects. That work has helped Attain Partners forge strong relationships with the project teams and allowed us to provide critical input into the direction those projects take, and now we’re helping to power the next generation of these Salesforce efforts. We are committed to using this opportunity to help resolve challenges facing our clients and other organizations.

In October 2019, I attended my first Salesforce.org Community Sprint in Philadelphia. As part of the first exercise, we were asked to propose projects that we were interested in seeing move forward. I posted that the community needed an effective tool to quickly generate test data for complex projects—it became quickly obvious that we were not alone. Several other attendees expressed an interest as we all find it time consuming to maintain datasets for large projects, meaning better tools could reduce costs and save time. The idea was selected for work during that sprint and once the ball got rolling, great ideas started flowing and a clear energy emerged. By the end of the sprint, we had created proof-of-concept code for one aspect of the problem.

When Salesforce was forced to cancel the Atlanta Sprint due to COVID-19, I wasn’t sure what would happen to all that drive. But the data initiative was selected by the Salesforce team for continuation during their first Virtual Sprint. Again, we saw the same positive energy and more ideas that helped the project evolve to include a vision for both new tools and better documentation for existing tools. We agreed to take the next steps to initiate a formal project under the Salesforce Open Source Commons banner, and so was born the Data Generation Toolkit project. I’m proud to represent Attain Partners by serving as one of the project leaders for the group.

I’m excited to see that Salesforce has taken the need seriously and started to create a new Open Source tool called Snowfakery that will likely be the core data generation engine for the tool that started as a suggestion back in Philadelphia.

From an idea posted on a piece of paper on a wall, to a group of community members with a full vision, to the real tool created to help meet a community need, it has been an exciting ride—and we’re just getting started.

Even with COVID-19 forcing a change in the process, Salesforce has shown an ongoing commitment to community sprints. There will be another Virtual Sprint from September 23 – 24, and Salesforce is experimenting with mini-sprints for the various projects—hopefully including the Data Generation Toolkit team. If you’re able, please consider attending the next Sprint and help the community grow.

 

About the Author

Aaron Crosman is a Senior Specialist in Attain Partners’ Salesforce Services Group. After a decade working IT and Digital Communications for a nonprofit, Aaron moved to consulting to help organizations create first-class online communications systems. He specializes in Drupal development and Salesforce integrations for our nonprofit and higher education clients.

0 0 Olivia Pycha Olivia Pycha2020-09-02 19:07:282023-03-29 10:28:44Salesforce Open Source Commons

COVID-19 Response and Strategic Planning for Higher Education

September 1, 2020/in Digital Transformation, Higher Education, Strategy, Thought Leadership Reshma Patel-Jackson/by Olivia Pycha


Diane: Reshma is a senior principal in Attain Partners’ Education, Nonprofit, and Commercial Services practice and has been serving the higher education and non-profit sectors for over 15 years. She specializes in strategy, change management, and organizational transformation and has been working closely with her clients to help them navigate recent events. Reshma, thanks for joining us to discuss the strategic responses across Higher Education to the COVID-19 pandemic.

Reshma: Thanks for having me.

Diane: To begin, can you briefly summarize what our viewers need to know about Attain Partners?

Reshma: I’d be happy to. We are a next generation, values-driven, built-to-last consulting company committed to serving the Higher Education and Nonprofit industries, as well as Federal, State and Local governments. As a technology firm focused on digital transformation, we amplify our capabilities by delivering expertise in strategy and change management to help our clients maximize their results.

Diane: Can you describe how Attain Partners supported our clients during the initial months of the COVID-19 pandemic?

Reshma: First, I’d like to acknowledge how difficult this has been for our entire nation—but particularly for the nonprofit industry, where demand for services has skyrocketed, as well as in Higher Education, where the model of in-person teaching and on-campus education was literally “turned off” overnight, leaving many institutions struggling to right their ships. Against the odds, we’ve seen our clients weather this storm as they have to make unprecedented decisions that impact their clients, their students, their faculty and staff as well as their overall mission.

One of the issues we have seen is clients grappling with modeling—how could they plan for the future when standard assumptions were no longer valid? We’ve been working with clients to develop financial models that both reflect past activities and adapt to this “new normal.” Those models represent a multitude of scenarios, which include a hybrid model inclusive of both virtual and on-campus learning, a 100% virtual model, and a staggered model where universities will transition into on-campus learning and then gradually shift to a fully virtual environment by Thanksgiving break. We’ve also identified additional drivers that are relevant to the implications of this pandemic such as:

  • Significant declines in international students due to travel bans and H1B1 visa challenges
  • Continued demand for lower tuition rates due to hybrid models
  • Potential decrease in enrollment in new and returning students (gap years)
  • Decreased revenue from auxiliary services due to social distancing requirements in areas like residence halls, dining services, etc.
  • Decreased revenue from athletics

What make these models even more powerful is the inclusion of the composite financial indicator, or CFI, and other, higher education-specific, ratios that are outlined in the Strategic Financial Analysis for Higher Education: Identifying, Measuring & Reporting Financial Risks, Seventh Edition1. This has allowed our clients to move beyond projections that are tailored to the for-profit sector, and deeply measure and project their performance in ways that are meaningful to their industry.

Diane: Those must have been challenging models to review, given the amount of revenue colleges and universities generate from student services and athletic activities.

Reshma: They were. However, it’s important for our clients to walk through those scenarios so that they can plan accordingly. Appropriate scenario planning and financial modeling helps our clients plan so they can rise to this challenge and meet their missions of education, research, and service.

Diane: We’ve discussed how Attain Partners has supported institutions in the immediate response to the COVID-19 pandemic. Let’s turn now to how we are currently helping institutions across Higher Education with longer term efforts. Can you tell me a bit more about that?

Reshma: Of course. We’ve shifted from the immediate triage activities to more medium- and long-term planning activities. Locally, we’re working to help universities develop a standardized decision-making approach for how they will manage activities in the fall of 2020. The big questions on everyone’s mind is “when can we get back to in-person education? When can our students return to campus? How can we do this while protecting the health and safety of our entire community—faculty, staff, visitors, and students?”

We created a report for a specific group of universities that summarized current “back-to-school” decisions made by colleges in similar areas, specifically schools in urban or urban-like areas with a high incidence of COVID-19. It seems that many schools are ultimately pursuing a hybrid model of some kind. Even those universities who have decided to return to in-person education this fall have an emphasis on smaller physical class sizes with corresponding increases in class listings and remote learning. The question we’re working to help universities answer is where on the spectrum of ‘hybrid’ they lie, and how are they building in and budgeting for the required safety activities that have become our new normal. This covers the spectrum from social distancing protocols, tracking, tracing, and isolation initiatives, additional investments in physical and mental health services, and increased cleaning protocols.

As I’m sure our readers know, there are no one-size-fits-all solution for colleges and universities, so each institution is working to develop their own plan that meets their individual needs and adheres to state and local guidelines.

On a personal note, I was recently invited to join as a charter member for Fairfax County Public Schools’ (FCPS) Technology Advisory Council. My role is to provide guidance and support on FCPS’ communications and change management workstream as they continue to integrate technology into their classrooms, whether at the individual school campuses and classrooms, or remotely. As a mother, it has been gratifying to translate my work with higher education and nonprofits to serve our local school district.

Diane: Reshma, thank you for your time.

Reshma: My pleasure. Thank you for yours.

Diane: Remind us where people can find us, and how they can access further resources.

Reshma: If you have any questions about anything we discussed here today, please reach out to us at [email protected]. You can also visit our COVID-19 resource hub at attain.com/ENCSCOVIDResources. We’re here to help and are happy to answer any questions you may have.


1Prager, Sealy and Co. LLC., KPMG LLP, and Attain Partners LLC. Strategic Financial Analysis for Higher Education: Identifying, Measuring & Reporting Financial Risks, Seventh Edition. 2010.

0 0 Olivia Pycha Olivia Pycha2020-09-01 16:47:132024-05-22 18:49:50COVID-19 Response and Strategic Planning for Higher Education

Getting Started with NPSP Accounting Subledger

July 28, 2020/in Fundraising, Nonprofit, Salesforce, Thought Leadership Aaron Crosman, Allison Letts, Chris Pifer/by Jesse Dean

This spring, Salesforce released their highly anticipated Accounting Subledger product to help nonprofits bridge the gap between their fundraising information and their accounting systems. As a Salesforce.org partner since 2005 that has implemented over 300 nonprofit projects, Attain Partners was invited to contribute to and collaborate on key design decisions in the development of this new package. We were excited to be the first implementation partner to enable this essential functionality for a client this summer, giving the organization more time to engage with their constituents and less time working on accounting.

In the Know: What is Accounting Subledger?

Accounting Subledger is a Salesforce package that can be installed on top of Nonprofit Success Pack (NPSP) and will generate records that can then be imported into your accounting system to speed reconciliation.

NPSP uses Opportunity records to track gifts, along with their associated Payment and Allocation record. Opportunities provide excellent information for fundraising teams, but they are not ready for easy import into an accounting system. For that, you need more information structured to align with the needs of a two-column accounting system. Accounting Subledger does just that by automatically generating records designed to be imported into a two-column accounting system with minimal effort. Both the revenue and expense accounts are tracked in lines that are easy to group and report upon.

With records able to easily transfer to the accounting system, the finance teams within your organization can more efficiently reconcile fundraising income with bank statements, track restrictions, manage allocations, and other critical business processes.

The Basics: Ledger Entry Records

The most important output of Subledger are the Ledger Entry records that are used to generate importable data. These records are generated from Opportunities using a scheduled job or a trigger. Most organizations only need to synchronize between Salesforce and their accounting ledger once a day—often less—so the Subledger package is designed to let you schedule the generation of records at the intervals that make the most sense for your needs. That can be nightly, on a custom schedule, and even triggered immediately when gift is created or updated. Our experts work with you to customize the right structure for your organization or departmental needs.

To minimize the risk of problems with locking and platform limits, we recommend that you only generate the records just before you need them and not based on the trigger process.

The Setup: Account Settings and Custom Metadata

The Subledger package adds additional settings that coordinate with NPSP to extend the payment and allocation system that is already part of the parent package. To really get the most from Subledger, you will need to make sure your organization is set up to leverage the NPSP automations for Payments and Allocations. Our team is well equipped to ensure that setup options are complete whether for new or existing Salesforce implementations.

One of the critical features is the Opportunity Stage to State mapping that helps link your Opportunity Stages to appropriate state values for each gift. There are two Opportunity States: Finalized and Committed. Finalized describes any gift that is fully resolved, like a received gift (“Closed Won”) or a planned gift that was canceled for some reason (“Closed Lost”). Committed describes gifts that are still in process, like a Pledge. For most organizations, the Finalized state will be the most common target and it’s reasonable to expect you will have several stages that map to Finalized.

We can also configure Accounting Subledger to pull details from the Payment, General Accounting Unit, or Opportunity directly onto the Ledger Entry object for easy reporting. This functionality is driven by the Accounting Mapping custom metadata type.

The Options: Licenses

Salesforce has released Subledger with two levels of Licensing: Starter and Growth.

The Starter license provides the basic Ledger Entry object and a few reports designed for specific Accounting systems, such as QuickBooks. If you only need to track your revenue accounts and adjustments within Salesforce, the Starter license may be a good fit for you.

The Growth license includes full support for two column accounting and more reports for a wider range of ERP solutions, including Financial Edge, Microsoft Dynamics, NetSuite, and Workday. Reports for other systems can be developed easily with Salesforce’s powerful native reporting engine.

As with any license purchase, we encourage you to talk to your Salesforce Account Executive. If you’re considering Accounting Subledger, Attain Partners can also help you understand your options to make the best informed decision.

How can I get started with Subledger?

  • Watch Attain Partners’ free, on-demand webinar: Seven Ways to Get More out of Salesforce with Subledger
  • Review the Salesforce Accounting Subledger product guide for an overview of the features.
  • Request a demo by reaching out to us or your Salesforce Account Executive. As this is a licensed product, you cannot test all of the features without support. In coordination with Salesforce, our team of experts can help you make an informed decision as to which option may be best for your organization.
  • Contact us at [email protected] with any questions, to get additional details, or to discover how we can support incorporating Subledger into your overall vision for cloud-based fundraising using Salesforce.

About the Authors

Aaron Crosman is a Senior Specialist in Attain Partners’ Salesforce Services Group. After a decade working IT and Digital Communications for a nonprofit, Aaron moved to consulting to help organizations create first-class online communications systems. He specializes in Drupal development and Salesforce integrations for our nonprofit and higher education clients.

Allison Letts is a Principal Consultant in Attain Partners’ Salesforce Services Group. After four years as a nonprofit fundraiser and Salesforce admin, Allison joined Attain Partners to help nonprofits and educational institutions streamline their data so that they can spend more time on their missions.

Chris Pifer is a Principal Consultant serving higher education and nonprofit clients. As a senior leader, Chris provides subject matter expertise on the technical implementation of Salesforce and relevant third-party tools. His specialties include solution analysis and design, data analysis and migration, and test and quality assurance.

0 0 Jesse Dean Jesse Dean2020-07-28 02:00:552021-09-08 10:48:58Getting Started with NPSP Accounting Subledger
Page 25 of 34«‹2324252627›»

Subscribe to Our Newsletter

  • This field is hidden when viewing the form
  • This field is for validation purposes and should be left unchanged.
  • About
    • The Attain Way
    • Leadership
    • Who We Serve
    • Alliance Partners
    • Contract Vehicles
    • Attain Digital
      • Executive in Residence Program
    • Attain Research
      • NIH’s Flat Rate for Research Overhead
      • Uniform Guidance
  • Services
    • -
      • Services
    • -
      • Technology
        • Salesforce Innovation
          • Managed Services for CRM
          • Attain Accelerate
          • Salesforce Digital Engagement
        • Application Development and Modernization
        • Enterprise Business Solutions
        • Advanced Analytics
        • Data Science
        • Emerging Technology
    • -
      • Strategy
        • Inclusion, Diversity, Equity, and Allyship (IDEA) Transformation Services
        • Program and Project Management
        • Organizational Transformation
        • Change Management
        • Strategic Planning
        • Business Process Modernization
        • Strategic Finance
        • Enrollment Management and Student Services
        • Shared and Managed Services
        • Library Planning and Strategy
        • Juran, an Attain Partners Company
    • -
      • Compliance
        • Grants Management
        • Cost Recovery Optimization
        • Financial Aid
        • Interim Staffing
        • Contract Negotiation
        • Asset Management and Valuation
  • Products
    • Research Performance
    • Strategic Finance Performance
    • Rate
  • Newsroom
    • Blog
    • Events
    • News
    • Insights
    • Awards
    • Case Studies
  • Careers
    • Open Roles
  • Contact
    • Subscribe

© Copyright 2025 Attain Partners

Terms of Use | Privacy Policy | Sitemap

LinkedIn logo in yellow circle
Twitter logo in cyan blue square
Facebook logo in navy blue triangle

Attain Partners
1650 Tysons Boulevard
Suite 1530
McLean, VA 22102

Phone: 703.857.2200
Email: [email protected]

Salesforce Consulting Partner logo
Salesforce Consulting Partner of the Year Education seal
Salesforce Equality Partner badge
Salesforce Summit Partner badge

Scroll to top