Transactions can be entered manually, via a copy from excel feature, or with an import. All three methods are described below.
Copy from Excel: In order to use the COPY FROM EXCEL feature, transactions need to be entered in a three column format in a worksheet that can be copied and pasted (four columns if you are entering distributions and want to include the spending/income account number). The columns should be in the following order: GLID, amount, note and spending/income account number (if entering distributions). Next go to ACTIVITY TRANSACTION ENTRY and select the COPY FROM EXCEL tab. Select the transaction type for the transactions you will be pasting in from the TRANSACTION TYPE drop down box. Copy the three (or four) columns of the worksheet then go back into Fundriver and select the PASTE button (you will be prompted to enter Ctrl + V to complete the paste). When you are ready to commit the records to the database select the PROCESS button.
Please note that each individual transaction type needs to be processed separately.
For step-by-step screen shots of the Copy From Excel process, please see the article entitled "How do I add gifts or other transactions to Fundriver using Copy from Excel
Go to the ACTIVITY >TRANSACTION ENTRY.
Select the GL IMPORT
tab. This will bring up a feature that will allow you to import one of our standard import files or a file that you created from your accounting system.
For step-by-step instructions on how to use our Standard Transaction Activity Import file see this article; Standard Transaction Template and GL Import Instructions.
Note: If you are using the Expendable Funds Module, you will also see the Expendable Funds Transaction Activity Import in this drop down. If your organization utilizes custom transaction types, be sure to use the template that was provided during implementation.
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. Once the corrections are made, return to the GL Import screen and click REPROCESS to commit the records.
All import files are archived and can be found by clicking ACTIVITY > EDIT TRANSACTIONS > FILE MAINTENANCE tab