Raiser's Edge Reporting Tip . . . & Trick?
Published
Have you ever gotten frustrated pulling month-end or quarterly reports from Raiser’s Edge and because different offices or sources are depositing the gifts you cannot get your totals in your report to match finance?
Never fear, there is a solution! :)
We had a similar issue to this about 3 years ago and we decided to add a gift attribute (or custom field, for those NXT users out there):
To pull reports by bank deposit type or office location/bank deposit type go to the attributes tab on the report parameters, it is tab 3 or 4 on financial reports; except the General Ledger Audit Report (which only has General, Gift Type, and Format tabs). On the attribute tab decide if you are including or excluding certain attributes: select include if you only want specific deposit types like BBMS CC and Online Express only or choose to exclude if you want all deposit types except for a certain one, two, or three: if you want every deposit type, except credit card types, choose exclude and then select BBMS CC and Online Express. Once you have decided if you are including only those types you are selecting or excluding those you select, but including everything else, you will choose the record type (Gift); the category (Deposit Type); and the description (choose the appropriate choice from the drop-down menu). Then you can run the report; it will now only contain the deposit types you want to show and you can easily reconcile with finance for what was deposited where, the funds the deposited gifts are associated with, and what type of deposit it references.
Be sure to record this in your policies and procedures guide (both for the entry portion, adding the attribute, and the reporting structure/steps)!
Best of luck to all! I hope this may prove helpful; to at least some of you! :)
Never fear, there is a solution! :)
We had a similar issue to this about 3 years ago and we decided to add a gift attribute (or custom field, for those NXT users out there):
- We started by adding an attribute of Deposit type and then set it up as a drop-down table (no free text fields or you might wind up with: Bank Deposit; Bk Dep.; Bank Dep.; Deposit: Bank; Bank In-Person Deposit; etc. in your list and you will not be able to use the info in a meaningful way (more on that to come)).
- We then added a table with all of the possible bank processing types we had: Online Express BBMS; Credit Card BBMS; ACH Direct Debit; Bank Deposit; Bank Quick Deposit; etc. (You can also do this by office location if needed Main Office - OLX; Main Office - CC; Main Office – Bank Deposit; Satellite Office 1 – OLX; Satellite Office 1 – Bank Deposit; Satellite Office 2 – Bank Deposit; etc.)
- Finally, we added Deposit Type; Deposit Type Date; and Deposit Type Comment to our Batch Templates
To pull reports by bank deposit type or office location/bank deposit type go to the attributes tab on the report parameters, it is tab 3 or 4 on financial reports; except the General Ledger Audit Report (which only has General, Gift Type, and Format tabs). On the attribute tab decide if you are including or excluding certain attributes: select include if you only want specific deposit types like BBMS CC and Online Express only or choose to exclude if you want all deposit types except for a certain one, two, or three: if you want every deposit type, except credit card types, choose exclude and then select BBMS CC and Online Express. Once you have decided if you are including only those types you are selecting or excluding those you select, but including everything else, you will choose the record type (Gift); the category (Deposit Type); and the description (choose the appropriate choice from the drop-down menu). Then you can run the report; it will now only contain the deposit types you want to show and you can easily reconcile with finance for what was deposited where, the funds the deposited gifts are associated with, and what type of deposit it references.
Be sure to record this in your policies and procedures guide (both for the entry portion, adding the attribute, and the reporting structure/steps)!
Best of luck to all! I hope this may prove helpful; to at least some of you! :)
News
Tips, Tricks, and Timesavers!
08/30/2019 10:12am EDT
Leave a Comment
Thank you for this idea - this will be a great help to us too!