If Fundriver has configured a specific import template for your transactions, please use that file to import activity. Otherwise, use the Standard Transaction Template attached to this article.
Select an IMPORT TYPE of TRANSACTION ACTIVITY IMPORT.
In most cases, pending records represent gift transactions that were entered to funds that have not yet been set up in Fundriver.
Populate this template as shown below. Transaction Type, GLID and Amount are required fields.
Below are examples of how AMOUNTS should be entered, where as a positive or negative value:
| Transaction Type | Enter as a Positive or Negative value in Transaction Entry Screen | Notes |
| Gift | Positive | |
| Distribution | Positive | Fundriver will automatically subtract the amount from the Fund balance |
| Expense | Positive | Fundriver will automatically subtract the amount from the Fund balance |
| Internal Transfer | Positive | Fundriver will automatically subtract the amount from "transfer from" Fund balance, and add it to the "transfer to" fund balance |
| External Transfer In or Out | Positive | Use the deactivate fund feature found in the Fund Profile section if you are closing the Fund. Fundriver will automatically create the necessary transactions for you |
| Cash Historical Gift Transfer | Positive if adding to Fund; Negative if subtracting from Fund | |
| Income | Positive if adding to Fund; Negative if subtracting from Fund | Investment Income (Interest & Dividends) that are to be spread across the entire Pool should be entered in the Investment Activity screen |
| Income to Principal | Positive | |
| Investment Fees | Positive | Investment Fees that are to be spread across the entire Pool should be entered in the Investment Activity screen |
| Non Cash Historical Gift Transfer | Positive if adding to Fund; Negative if subtracting from Fund | |
| Due To Due From Transfer | Positive if money has not yet been deposited with the Investments; Negative if money has not yet been withdrawn from the Investments | ONLY use this transaction type for DTDF Funds. Other transaction types should not be used with a DTDF Fund. |
| Non Unitized Asset Transfer *Non Pooled Transfer prior to 5/25/18 | Positive if adding to the non-unitized asset balance; negative if subtracting from the non-unitized asset balance. | Use only for Non Unitized Funds or Funds that have a Non Unitized Asset component (Not a usual occurrence) |
| Pledge | Positive | Pledge Activity is tracked on the Pledge Balances Report |
| Pledge Payment | Positive | Pledge Activity is tracked on the Pledge Balances Report |
| Pledge Write Off | Positive | Pledge Activity is tracked on the Pledge Balances Report |
| Realized Gains | Positive if adding to Fund; Negative if subtracting from Fund | Realized gains/losses that are to be spread across the entire Pool should be entered in the Investment Activity screen |
| Unrealized Gains | Positive if adding to Fund; Negative if subtracting from Fund | Unrealized gains/losses that are to be spread across the entire Pool should be entered in the Investment Activity screen |
Not sure which transaction type to use? See our Transaction Type Guide for more information! Please note: On the Informational tab there are instructions on how to add custom transaction types to the transaction types drop down list.
To import the file into Fundriver, navigate to ACTIVITY > TRANSACTION ENTRY > GL IMPORT.
Select an IMPORT TYPE of TRANSACTION ACTIVITY IMPORT.
Any records that are corrupt or have no matching GLID number in Fundriver will be pending and will not commit to the database. Those pending records will be visible in the “GL Import” grid until either deleted or corrected.
In most cases, pending records represent gift transactions that were entered to funds that have not yet been set up in Fundriver.
If a fund needs to be set up, follow the instructions in the Fundriver Knowledge Base under General Software Use "How do I add a fund?" Once the new fund has been set up, go back to ACTIVITY > TRANSACTION ENTRY. Select the GL IMPORT, and select the import from the IMPORT TYPE drop down box that was previously used. The pending record(s) will still be in the grid. Select the REPROCESS button to commit the record(s) to the database.