Some organizations choose to enter each donation twice, once in their donor management system and again in their accounting system, as a way to provide checks and balances in their system. The upside is increased protection against errors while the downside is increased time by both development and finance to reconcile their records on a regular (usually monthly) basis. Little Green Light always allowed for the basic export of all the gift information you’d need for this kind of reconciliation, but we recently got a request from a customer to help her make the whole process a bit easier and more efficient.
Instead of the usual export in CSV format (that required extra cleanup and formatting in Excel), Megan Farkas, the development coordinator at the Sant Bani School, wanted to be able to pull a particular month‚Äôs deposits in a format she could just print or email without alteration. On the surface, those extra steps might not seem like a big deal, but they fly in the face of our belief that Little Green Light should give you the information that you want in the format you need without requiring you to jump through hoops. To that end, we worked with Megan to create a custom PDF export format that provides her with exactly the information she needs. Here’s what the new workflow looks like when she wants to grab the previous month’s deposit report from Little Green Light:
- Go to the Fundraising Tab and select “deposit date” on the date filter, then choose “Last month” from the dropdown
- Click the “Export results” button and select the “Deposits” export type; save the export
- Download/print the results
Just like that, in about 30 seconds flat she has a nice-looking PDF with all of the information she needs in a format that she doesn’t have to re-create every month. Here’s what it looks like with some test data:
The only thing that’s missing now is automating the process so Little Green Light will email her the report at the beginning of every month. That’s a feature we have in the works, and it should be ready (along with a slew of other reporting updates) within the next month or two. We’d like to thank Megan for working with us to provide her with a better report. We encourage all of our customers to do the same, so please don’t hesitate to let us know when you’d like to do so.