Sharing Solutions: Blog

Beyond the API – Ensuring Data Consistency Between AcademicWorks and Financial Software


Author and Presenter: Tara Mcgiel, North Carolina State University

As you may have discovered early into your use of AcademicWorks, you have the ability to send scholarship award data to your financial system (Banner, PeopleSoft, etc.) through the use of the API. However, due to some technical challenges, you may not be able to take advantage of the API right away. Over the last year, we have had a few clients asks how they can accurately and efficiently keep AcademicWorks in sync with their campus systems in the meantime.

During this session, Tara Micgiel, the Assistant Director of Scholarships at North Carolina State University, discussed how you could keep your scholarship award information up-to-date in both AcademicWorks and your financial systems. Even without the use of the API, Tara has discovered a way to prevent overspending, identify errors quickly, and identify areas where additional award training for departments and staff may need to take place.

Tara was able to provide two examples of award data she has had to reconcile over the last year. These examples provide a step-by-step on what to look for when tracking scholarship award data made in AcademicWorks, and having that data accurately reflected in your financial system.

Key Takeaways:

  • As you begin to award scholarship in AcademicWorks, you will want to keep your AcademicWorks platform in sync with your campus financial systems to prevent errors and overspending.
  • Even if you are not taking advantage of the award API, you can download award information from AW, and using Tara’s method, you can reconcile any errors discovered during the process of transferring award information.

Are you interested in learning more about scholarship management best practices? Subscribe to our sharing solutions blog to receive monthly updates about the latest trends in donor stewardship, donor reporting, and scholarship management. 

Subscribe to the Sharing Solutions Blog

Author: Morgan Love

Morgan Love

Morgan is a graduate of Texas State University with a degree in Public Relations and is passionate about event planning, communications, and marketing. She has been in the tech industry for a year and is loving her new home in higher ed. tech. When she's not in the office she loves spending time with her husband and puppy, reading a good book, traveling, and exploring the Texas hill country.