Notices


Reply
 
LinkBack (1) Thread Tools Display Modes

Old 10-23-2007, 11:08 AM   1 links from elsewhere to this Post. Click to view. #1 (permalink)
Member

Join Date: Nov 2006
Location: New York
Posts: 84
Rep Power: 3 Andrew Gorczycki is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)
- NetCommunity (BBNC)
- Blackbaud Analytics/Researcher's Edge (BBA/TRE)
- API/VBA

Question Lockbox gifts/donation processing

This is a question for anybody who is using lockbox processing.

How the process of donor data import to RE is organized?

Is lockbox processor providing you with the data in final import form or you need to reformat it?

What type of payments you are processing through lockbox?

What is the volume (number of transactions not $ volume) you are processing through lockbox process?

What company are you using for the process?

Could you rate them ?

Do you know the costs?

Any
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote

Old 10-23-2007, 11:11 AM   #2 (permalink)
Member

Join Date: Nov 2006
Location: New York
Posts: 84
Rep Power: 3 Andrew Gorczycki is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)
- NetCommunity (BBNC)
- Blackbaud Analytics/Researcher's Edge (BBA/TRE)
- API/VBA

my original post has been somehow truncated, I am re-posting it

This is a question for anybody who is using lockbox processing.

How the process of donor data import to RE is organized?

Is lockbox processor providing you with the data in final import form or you need to reformat it?

What type of payments you are processing through lockbox?

What is the volume (number of transactions not $ volume) you are processing through lockbox process?

What company are you using for the process?

Could you rate them ?

Do you know the costs?

Any info would be appreciated

thanks

Andrew Gorczycki

The Solomon R Guggenheim Museum

IT Dept
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote

Old 10-23-2007, 05:27 PM   #3 (permalink)
Junior Member

Join Date: May 2006
Posts: 6
Rep Power: 0 hrodriguez is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)

Hee's a synopsis of our procedure:

Most of our membership renewals are received via our lockbox. (All of our renewal solicitations include a reply envelope with the lockbox address.) At the lockbox they deposit all of our checks, make copies, and then send us the copies along with any additional backup materials. They separate out all of the credit card transactions and we process those in house separately from our lockbox check payments. On a daily basis the lockbox also sends us a spreadsheet of data - ID number, donor name, gift amount, check date, check number, appeal code, and package code. We format the data (add a few fields, etc.) and import the gifts into RE. After the import, we "detail" the transactions. We query on the imported gifts and, via query, drill down to the individual records to renew the memberships. We also make any biographical changes noted in the backup at this point in time. Overall, this is faster than batching (and renewing memberships via batch) but still rather time consuming.

For your other questions:
  • We processed about 11,000 gifts in FY07 via this technique. These are mostly memberships renewals, some joins/rejoins from our acquisition program, and a few unrestricted/annual fund gifts.
  • We use our primary bank for this service
  • Our finance department likes the fact that we use a lockbox because it usually means money is deposited quickly. However, I've seen them tons of mistakes: miskeying data in our spreadsheet, inflating/deflating the daily deposit amount, mixing up constituent id numbers (this means we attribute a gift to the wrong record however this gets caught in our "detailing" process), incomplete information in the spreadsheet, depositing money in our account that was intended for other institutions, and on and on.
  • I'm actually not familiar with the cost of the service because it is part of the "suite" of services we receive from our bank.
I'm happy to answer any other questions you might have.
__________________
Heather Rodriguez
Assistant Director, Donor Information Services
San Francisco Museum of Modern Art
hrodriguez@sfmoma.org
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote

Old 10-24-2007, 01:01 PM   #4 (permalink)
Member

Join Date: Nov 2006
Location: New York
Posts: 84
Rep Power: 3 Andrew Gorczycki is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)
- NetCommunity (BBNC)
- Blackbaud Analytics/Researcher's Edge (BBA/TRE)
- API/VBA

thanks Heather,

it is very useful information for me,
I have been asked to check if lockbox can untie some of our resources but so far I see only more problems then in current solution where we process the cheques via direct scan link to bank and CC in house with batch process integrated via IATS.

Thanks anyway,

Andrew Gorczycki

Guggenheim Museum
IT Dept
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote

Old 10-24-2007, 01:10 PM   #5 (permalink)
Member

Join Date: Nov 2006
Location: New York
Posts: 84
Rep Power: 3 Andrew Gorczycki is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)
- NetCommunity (BBNC)
- Blackbaud Analytics/Researcher's Edge (BBA/TRE)
- API/VBA

RE: Lockbox gifts/donation processing

BODY { FONT-FAMILY: Verdana, Geneva, Arial, helvetica, sans-serif } TABLE { MARGIN-TOP: 1em } TD { FONT-SIZE: 80%; FONT-FAMILY: Verdana, Geneva, Arial, helvetica, sans-serif } TH { FONT-SIZE: 80%; FONT-FAMILY: Verdana, Geneva, Arial, helvetica, sans-serif } alt2 { FONT-SIZE: 80%; FONT-FAMILY: Verdana, Geneva, Arial, helvetica, sans-serif; BACKGROUND-COLOR: #ffffff }

Quote:
From: hrodriguez
Sent: Tuesday, October 23, 2007 6:28 PM

Subject: [Non-Profit Technology-t-2644] RE: Lockbox gifts/donation processing


Hee's a synopsis of our procedure:

Most of our membership renewals are received via our lockbox. (All of our renewal solicitations include a reply envelope with the lockbox address.) At the lockbox they deposit all of our checks, make copies, and then send us the copies along with any additional backup materials. They separate out all of the credit card transactions and we process those in house separately from our lockbox check payments. On a daily basis the lockbox also sends us a spreadsheet of data - ID number, donor name, gift amount, check date, check number, appeal code, and package code. We format the data (add a few fields, etc.) and import the gifts into RE. After the import, we "detail" the transactions. We query on the imported gifts and, via query, drill down to the individual records to renew the memberships. We also make any biographical changes noted in the backup at this point in time. Overall, this is faster than batching (and renewing memberships via batch) but still rather time consuming.

For your other questions:
  • We processed about 11,000 gifts in FY07 via this technique. These are mostly memberships renewals, some joins/rejoins from our acquisition program, and a few unrestricted/annual fund gifts.
  • We use our primary bank for this service
  • Our finance department likes the fact that we use a lockbox because it usually means money is deposited quickly. However, I've seen them tons of mistakes: miskeying data in our spreadsheet, inflating/deflating the daily deposit amount, mixing up constituent id numbers (this means we attribute a gift to the wrong record however this gets caught in our "detailing" process), incomplete information in the spreadsheet, depositing money in our account that was intended for other institutions, and on and on.
  • I'm actually not familiar with the cost of the service because it is part of the "suite" of services we receive from our bank.
I'm happy to answer any other questions you might have.

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Reply

Tags
lockbox


LinkBacks (?)
LinkBack to this Thread: http://www.blackbus.org/forum/non-profit-technology/2644-lockbox-gifts-donation-processing.html
Posted By For Type Date
Technorati: Discussion about “Lockbox gifts/donation processing” This thread Refback 01-02-2008 04:23 PM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


Cheap Electricity - Cheap Gas - Renegade Motorhomes - Loans
All times are GMT -6. The time now is 06:53 PM.

Miscellaneous


Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Integrated by BBpixel Team 2008 :: jvbPlugin R1012.364.1

SEO by vBSEO 3.2.0 Copyright 2008 Blackbaud User SocietyAd Management by RedTyger
Inactive Reminders By Icora Web Design

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70