Please create the ability to globally change, or export/import, the GL distribution account numbers of funds

Our business office wants me to correct the GL distribution of stock sales in our endowment funds.  We have 128 funds, with six instances of that account number in each fund. A global change (or export/import) facility would be very helpful with this. I am sure others have had the same issue.

  • Guest
  • Jul 25 2017
  • Attach files
  • Guest commented
    December 09, 2021 21:29

    I completely agree! We need to do several mass updates and we have over 1,000 funds. All of our funds need the same GL distributions. It makes no sense to have to make those changes manually. There should be global import and edit capabilities for gift types and gift subtypes.

  • Brenda Lenzen commented
    June 17, 2021 15:52

    We too have hundreds of funds. Accounts are added or changed over the years. We need to have a global change or an import capability to do a system wide GL Distribution Table change without having to go into each fund separately. Thanks

  • Guest commented
    July 10, 2020 14:48

    We are just now integrating RE with FE. We have a large number of Funds and have to change the format of those funds and add the project number! I agree it would be very helpful to have an import file. This is going to be very time consuming!

  • Emily Mitchell commented
    December 20, 2019 16:55

    Ran into this issue.  I wanted to add more payment methods to all funds or to change the account number used for our existing 'PayPal' gift sub type (various departments keep adding new payment platforms PayPal, Venmo, etc.) so that it didn't use the same receivable account as another program (the other program has upwards of a couple hundred transactions a month so I really wanted to move the 5 or so transactions from RE). We were using the existing gift sub types in order to get them into the correct deposit accounts, but that meant all payments (electronic, cash & checks) were being grouped together in the deposit accounts making reconciliation very difficult. However, we have over 450 funds that I would have to manually change/code. I ended up deciding that all e-payments in RE will be 'PayPal' sub gift coded into the existing receivable account and will have to manually un-group the e payments into their appropriate deposit accounts. Then I added another receivable account for the other program (also not easy to update, but easier than RE) that those payments will go into. Very disappointing that I couldn't keep the detail for the other program in the same financial statement account.   

  • Paul Hittler commented
    June 18, 2018 19:32

    Yes, I agree completely. This is one area where an import function would be particularly useful. We are just now integrating RE with FE. The import file for Funds doesn't allow including Debit or Credit accounts or Project ID. It's going to be very tedious for me to map all the account#'s/ project codes I need one by one.

    This also would be useful if/when an organization switches bank accounts and must create a new GL debit account number to record cash receipts. As of now, every single fund debit account# would need to be individually changed one-by-one.