Grant Reconciliation Made Easy

By Beth Pease posted 02-17-2014 03:39 PM


Grants are “special”  – we all know that! In order for us to do our daily and monthly processes we cross bridges from Grants to Project Costing, Contracts, Billing, and Accounts Receivable before finally landing in General Ledger. In a perfect world the transactions you started with are the same as the ones you finished with, however sometimes it’s a bit more like a children’s game of “Whisper Down the Lane.”  The end doesn’t exactly match the beginning.

For PeopleSoft Versions 9.1 and earlier, working in conjunction with several clients, a series of queries were created to make sure that all transactions are moving smoothly through the system.  Since I like pictures, we created a graphic that people can use to visually match trouble areas with the queries that they need to run.

Oracle has simplified this process significantly in PeopleSoft Version 9.2 with the availability of the WorkCenter functionality. Many of the queries developed on earlier client projects are now delivered links that can be displayed in the WorkCenter. If they aren’t there yet, no problem. We can pull my queries into the WorkCenter so it’s all there right in front of the user.

If this sounds familiar to you, come to our session at Alliance 2014.  I will be co-presenting on Grant Reconciliation through the Ages with Chris White, Systems Analyst for the University of Delaware Research Office, on Monday, March 10, 8:00-9:00 am. 

Get a systematic way to control your Grant Reconciliation issues. Who doesn’t want a few new queries to play with?