Follow

FAQ: Data Load Template

Q: Do I need to load all of my data during the initial implementation data load?

A:  No, although it is recommended that at least all existing fund information is included in the initial load.  Clients have access to load additional data using either the Data Load Template and/or Manager Data Load Template (for clients who subscribe to the Investment Portfolio Module) at any time.

New data is loaded using the most recent version of your templates.  Please contact your Client Support Specialist to obtain the most recent copy of your Data Load or Manager template.

 

Q:  Should my corpus/historical gift and gains/income be set up as two separate funds in Fundriver (permanent and temporarily restricted)?

A: Even if this is how your funds are set up in your general ledger, in Fundriver they need to be set up as a single fund (one row on the data load template).  Provide the historical gift and total market value in the appropriate columns and then give us the corpus restriction.  Fundriver reports will automatically break out permanently restricted, temp restricted and unrestricted funds based on current historical gift and market value figures.

 

Q:  What should I put in columns D, E, F, G and H on the Funds tab?

A: Columns D through H will all relate to spending revenue data and account information.

These are typically used for pulling into an export file (vs. Report) for clients to book spending distributions within their Financial System.

 

Q:  For the funds that have a Spending Exception, what do I put in columns D, E, F, G and H on the Funds tab? 

A:  Leave these blank.  What is put on the Spending Exception tab will overwrite this.

 

Q:  What do I put in column W for those same items? 

A:  You will want to have your same spending rule for all your other funds in this column.  This will tell the system what to calculate.  Then what you put on the Spending Exceptions tab will take the amount calculated based on what the Spending Rule is and do the function (example:  Endowment B0500 - Spending Rule calculates your spend for an endowment at $27,000 for the year.  Then the Spending Exception will take that $27,000 and split it out 10% to reinvest back into the principal of the endowment-$2,700 and 90% to distribute-$24,300.)

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.