Hello!
I’m not an IT person and cannot provide much help. Also, UR is an Advance shop. However, I can tell you that when we migrated to Workday, our feed had to be split/edited to be TWO feeds – one for new cash and one for mods. Workday could not take one feed as our previous system had done. The new cash feed impacts the banking side and cash reconciliation whereas the mod activity is a more straightforward net zero GL entry.
If your legacy process doesn’t rec to the penny to the bank statement and/or credit card merchant accounts by deposit date, you are in for a world of hurt. Been there! Everything in Workday interacts and pings off everything else. If you process and feed $100 in gifts with a deposit date of 2/7/2019, the bank statement (and cash module in Workday) must have a deposit for $100 on 2/7/2019 from your location id. Or the sky will fall! Similar with credit card activity. You cannot send $100 to the GL today, deposit $90, and catch up by depositing the missing $10 the next day. No can do.
When Workday came, our entire process (and focus of our accounting labor) had to change to dance around this issue. We are all better reconciled for it, but it was a very big change. Good luck!
Aaron
Aaron Forrest CPA
Senior Director Gift and Donor Services
University of Rochester Office of Advancement
Larry and Cindy Bloch Alumni and Advancement Center
300 East River Road
Rochester NY 14627
Office 585.275.2799 / Fax 585-273-4558
Email
aaron.forrest@rochester.edu
[Description: Description: Description: cid:
image001.gif@01C92E92.3629C5E0] <http://www.rochester.edu/>
P Please consider the environment before printing this email.
Confidentiality Notice: This message, including attachments may contain confidential information. Any unauthorized use, disclosure or distribution is prohibited.
From: Advancement Services Discussion List <
FUNDSVCS@LISTSERV.FUNDSVCS.ORG> On Behalf Of Maureen Trafford
Sent: Wednesday, February 6, 2019 7:50 PM
To:
FUNDSVCS@LISTSERV.FUNDSVCS.ORG
Subject: [FUNDSVCS] Banner & Workday
Hi all,
I'm in search of others who have already, or are currently, designing a feed from Banner Advancement to Workday for gift processing and might be willing to share lessons learned or help connect your integration specialists with ours. Thank you in advance!