Hello Kelsey,
I haven't been in the scholarship position for even a year yet, but based on the documentation that was left before I came in, it seems like the excel method was used with the person before me as well.
I'm not sure what is all happening on your side but I know that our office does not send money back and forth with the State. We will just reconcile what we have awarded with what was sent to us in the fall, and determine if we owe the State money or if the State owes us money just once in the spring.
I also know that the directors just had their meeting and that the State was there. Not sure if this process was discussed though.
Out of curiosity, do you have any ideas of how to make the process better?
I'm not sure who is all subscribed to this forum but hopefully some other scholarship coordinators will chime in.