Best Practices on organizing paper backup for donations

Options
We recently converted from eTapestry to Raiser’s Edge.  And we’re struggling to figure out the most efficient way to organize our hard copy documentation.  In eTapestry, we ran gift reports approximately weekly, and had all the paper backup (copies of checks, donation envelopes, letters and cards from donors, etc.) filed alphabetically together with the gift report.  This made it easy to find the paper copy of something when we needed to refer to it later for a donor question or processing discrepancy.

With RE, we often have multiple batches for each gift report, and we’re not sure how to organize the paper copies so that we can find it later. We’re curious how other organizations handle this.  I’ve spent some time looking through other entries in this forum, and can’t seem to find any mention of this process, other than it gets stored with the batch report for those that keep paper copies. Our struggle is that we may have dozens of pieces of paper for each gift report (or, during busy times of year, hundreds), so having to flip through them all to find one donation’s information seems cumbersome. Do you organize this paper backup in any particular way that you find helpful?

 
Tagged:

Comments

  • Sharon Sevransky:

    We recently converted from eTapestry to Raiser’s Edge.  And we’re struggling to figure out the most efficient way to organize our hard copy documentation.  In eTapestry, we ran gift reports approximately weekly, and had all the paper backup (copies of checks, donation envelopes, letters and cards from donors, etc.) filed alphabetically together with the gift report.  This made it easy to find the paper copy of something when we needed to refer to it later for a donor question or processing discrepancy.

    With RE, we often have multiple batches for each gift report, and we’re not sure how to organize the paper copies so that we can find it later. We’re curious how other organizations handle this.  I’ve spent some time looking through other entries in this forum, and can’t seem to find any mention of this process, other than it gets stored with the batch report for those that keep paper copies. Our struggle is that we may have dozens of pieces of paper for each gift report (or, during busy times of year, hundreds), so having to flip through them all to find one donation’s information seems cumbersome. Do you organize this paper backup in any particular way that you find helpful?

     

    I organize my paper backup by gift batch. I try to enter at least one batch a day, sometimes more. I print the batch validation report and batch commit report and staple those with all of the backup. I file the batches in numerical order, by month. Since all of our gifts are entered in batch, I'm able to find the batch number on the gift record and then easily pull that batch from my files.

  • Our school converted to digital filing. We use Google Drive so everything is stored there. We scan each donation and it is saved in one file folder by name and gift date (Last, First MMDDYY). When we need to see a particualr gifts backup, we can sort the files by name or by saved on date if for some reason we don't know the name. Gifts are entered into RE as batches and we save the Batch Commit Report and combine it with the PDF files generated when we deposit the checks. (Our bank uses remote capture so we deposit our own checks.) Then we save the Batch Commit/Deposit combination in a file folder called Batch Documentation. Our accounting people occassionaly use the Batch files when reconciling at the end of the month but from an RE standpoint we do not typically use the Batch files after they are saved. 

    I wasn't sure about the not keeping paper copies aspect but it has worked for the last 2 years. I even find myself wishing previous years were digitized when we have that occasional need to look up a donor's gift from a few years back and I have to climb into the attic. 
  • At my last org, we changed to electronic filing.  First to the Media Tab in RE:7, then to RE:NXT Gift Attachments...in both cases with backups to a folder on the org's network.  Per our CFO, we kept the paper copies of everything until that FY was closed and the audit complete.  Then to the shredder!


    When we kept paper copies, they were filed by donor name...same at other orgs I worked at prior, although in those cases, we kept a copy filed by donor name and also a copy filed by deposit date.


    Moving to electronic filing, I created a file naming convention of "c456789+2017-11+g12345 Hernandez" where 456789 is the Constituent ID, 12345 is the Gift ID, Hernandez is the donor's last name, and 2017-11 means that the gift was received/deposited in Nov 2017.  Easy to embed/attach in RE with the ID numbers, and also searchable by ID or name in the backup folder (and sortable in the "to be filed" folder when doing the embed/attach process in RE).
  • When we kept paper files, we used to use attach everything for each batch posted to a batch cover sheet. The cover sheet gave Batch number, date, and amount of deposit.  We filed numerically by batch and grouped all  files by month/year. When the auditors requested documentation for a particular gift during an annual audit, we could locate it easily by batch number. We have transitioned to PaperSave  several years ago and attach electronic documentation to each gift posted. I also attach electronic copies of thank you letters to each gift. All of the posting reports are saved as they are generated as .PDF documents and kept on our computer in appropriate files that are shared with our Business Office. We also save electronic copies of credit card reports downloaded  from the web  for each batch. All of our computer files are backed up regularly by IT, so we do not worry about losing electronic documents.

  • We keep our paper back up filed by gift date.  Makes it really easy to go back and find it.  

  • Melissa Steinbach:

    We keep our paper back up filed by gift date.  Makes it really easy to go back and find it.  

     

    Thanks, this is helpful. Within date, do you organize it any particular way?

  • Michelle Gundrum:

    Sharon Sevransky:

    We recently converted from eTapestry to Raiser’s Edge.  And we’re struggling to figure out the most efficient way to organize our hard copy documentation.  In eTapestry, we ran gift reports approximately weekly, and had all the paper backup (copies of checks, donation envelopes, letters and cards from donors, etc.) filed alphabetically together with the gift report.  This made it easy to find the paper copy of something when we needed to refer to it later for a donor question or processing discrepancy.

    With RE, we often have multiple batches for each gift report, and we’re not sure how to organize the paper copies so that we can find it later. We’re curious how other organizations handle this.  I’ve spent some time looking through other entries in this forum, and can’t seem to find any mention of this process, other than it gets stored with the batch report for those that keep paper copies. Our struggle is that we may have dozens of pieces of paper for each gift report (or, during busy times of year, hundreds), so having to flip through them all to find one donation’s information seems cumbersome. Do you organize this paper backup in any particular way that you find helpful?

     

    I organize my paper backup by gift batch. I try to enter at least one batch a day, sometimes more. I print the batch validation report and batch commit report and staple those with all of the backup. I file the batches in numerical order, by month. Since all of our gifts are entered in batch, I'm able to find the batch number on the gift record and then easily pull that batch from my files.

     

    Thanks, very good information. Within the batch, do you organize the gift documentation in any particular order?

  • Sharon Sevransky:

    We recently converted from eTapestry to Raiser’s Edge.  And we’re struggling to figure out the most efficient way to organize our hard copy documentation.  In eTapestry, we ran gift reports approximately weekly, and had all the paper backup (copies of checks, donation envelopes, letters and cards from donors, etc.) filed alphabetically together with the gift report.  This made it easy to find the paper copy of something when we needed to refer to it later for a donor question or processing discrepancy.

    With RE, we often have multiple batches for each gift report, and we’re not sure how to organize the paper copies so that we can find it later. We’re curious how other organizations handle this.  I’ve spent some time looking through other entries in this forum, and can’t seem to find any mention of this process, other than it gets stored with the batch report for those that keep paper copies. Our struggle is that we may have dozens of pieces of paper for each gift report (or, during busy times of year, hundreds), so having to flip through them all to find one donation’s information seems cumbersome. Do you organize this paper backup in any particular way that you find helpful?

     

    Our paper backup is filed by gift date and we keep copies of the gift documentation (copies of check, any cards/letters that came with it and the envelope it came in), the acknowledgment letter, the batch report, our validation reports and the deposit sheet.  It's not in any particular order once it's in there other than the top page is the mail opening sheet (which shows the date the gifts were received and total amount of the donation(s)) followed by the deposit sheet, acknowledgment letters and any gift documentation.  We don't have hundreds of gifts a day, the most we'll get in is at year end and it is usually less than 20/day, unless there is a large memorial dropped off in which case those can be closer to 100 gifts.  Regardless, it's fairly easy to look in RE for the name of the donor and when the gift was processed and then go to that particular date in the file to find whatever documentation is required.  My fingers are crossed that we'll be moving to elelctronic filing after the first of the year, in hopes that our paper files can go away.  :)

  • Before moving into our new building in 2014, we did a scan and shred process for almost all our old paper files, saving only big donors' and board members' hard files. Since I've been working here (6 years) we have scanned and attached everything related to a gift to the donor's Media tab, and destroyed the paper. We keep electronic files of the acknowledgement letters by date and batch number, and we only scan and attach the acknowledgment letter to the donor's record if the signer makes some very special hand-written notes that we think need to be kept. The auditors have told us that they don't care about routine correspondence (ack letters) that we send out, only about what the donor sends to us. My predecessor had only recently begun scanning instead of keeping, and he scanned the whole thing together - check, form, signed ack letter - but that was overkill and way too slow. Deposits didn't happen until the letter was signed and scanned, and sometimes that held up deposits by about a week. He also entered every gift individually, so there was no batch to use as a starting point for accessing the files to attach Media.


    We actually do a handwritten paper log of all gifts to make the batch entry go faster and to have a place to record whether the ack letter has been printed, whether the documents have been scanned, and whether the scans have been "attached" (a job for our lucky work-study students). We sometimes have multiple batches of a couple of gifts each on one log. We staple the Batch Control Report(s) to the log, and also save that report and the Validation Report in PDF form to our shared drive. When we're done with the audit for a year, we shred the paper logs, and after about 2 years we delete the saved PDFs of the reports (you can always run a list of the gifts by batch number out of Query). ​Because we scan while making the log, we can deposit the checks as soon as we have a batch number for them, and hand off the log for the students to use (through the committed batch) to attach the media. Works well for us and is relatively quick - but we're a small office, so that might not work scaled up to a big organization.
  • Sharon Sevransky:

    Melissa Steinbach:

    We keep our paper back up filed by gift date.  Makes it really easy to go back and find it.  

     

    Thanks, this is helpful. Within date, do you organize it any particular way?

     

    Just by the manner on which it arrived (ie - regular post, on-line).

     
  • Sharon Sevransky:

    We recently converted from eTapestry to Raiser’s Edge.  And we’re struggling to figure out the most efficient way to organize our hard copy documentation.  In eTapestry, we ran gift reports approximately weekly, and had all the paper backup (copies of checks, donation envelopes, letters and cards from donors, etc.) filed alphabetically together with the gift report.  This made it easy to find the paper copy of something when we needed to refer to it later for a donor question or processing discrepancy.

    With RE, we often have multiple batches for each gift report, and we’re not sure how to organize the paper copies so that we can find it later. We’re curious how other organizations handle this.  I’ve spent some time looking through other entries in this forum, and can’t seem to find any mention of this process, other than it gets stored with the batch report for those that keep paper copies. Our struggle is that we may have dozens of pieces of paper for each gift report (or, during busy times of year, hundreds), so having to flip through them all to find one donation’s information seems cumbersome. Do you organize this paper backup in any particular way that you find helpful?

     

    We also switched to electronic storage. Development files all gift paperwork electronically with the batch reports by the batch number. Paper goes to Finace where they store for 3 years.

  • Just by the means in which it came in (on-line, credit cards, etc.)



    Sharon Sevransky
    :

    Melissa Steinbach:

    We keep our paper back up filed by gift date.  Makes it really easy to go back and find it.  

     

    Thanks, this is helpful. Within date, do you organize it any particular way?

     

     

  • Sharon Sevransky:

    We recently converted from eTapestry to Raiser’s Edge.  And we’re struggling to figure out the most efficient way to organize our hard copy documentation.  In eTapestry, we ran gift reports approximately weekly, and had all the paper backup (copies of checks, donation envelopes, letters and cards from donors, etc.) filed alphabetically together with the gift report.  This made it easy to find the paper copy of something when we needed to refer to it later for a donor question or processing discrepancy.

    With RE, we often have multiple batches for each gift report, and we’re not sure how to organize the paper copies so that we can find it later. We’re curious how other organizations handle this.  I’ve spent some time looking through other entries in this forum, and can’t seem to find any mention of this process, other than it gets stored with the batch report for those that keep paper copies. Our struggle is that we may have dozens of pieces of paper for each gift report (or, during busy times of year, hundreds), so having to flip through them all to find one donation’s information seems cumbersome. Do you organize this paper backup in any particular way that you find helpful?

     

    The most straightforward way I have found - and have used at several orgs. now -- is to file hard copy collateral this way:

    All batches for the day are in a folder by Date and the Batches are entered by Pay Method.  So there is a batch for checks, a batch for credit cards, batch for any online giving tool(s), etc.


    The collateral for that batch is attached to the Batch Report that is run upon Commitment of the Batch (only opportunity to get that report!) If you are attached to the alpha thing, you can sort the batch alphabetically.

    The label on the folder has the Date first and then a list of the Batch Numbers.


    Then, when and if you have to go back and look for something it is easy enough to look at the donor record in RE and see the date and batch number and pull the file quickly and easily.
  • Sharon Sevransky:

    We recently converted from eTapestry to Raiser’s Edge.  And we’re struggling to figure out the most efficient way to organize our hard copy documentation.  In eTapestry, we ran gift reports approximately weekly, and had all the paper backup (copies of checks, donation envelopes, letters and cards from donors, etc.) filed alphabetically together with the gift report.  This made it easy to find the paper copy of something when we needed to refer to it later for a donor question or processing discrepancy.

    With RE, we often have multiple batches for each gift report, and we’re not sure how to organize the paper copies so that we can find it later. We’re curious how other organizations handle this.  I’ve spent some time looking through other entries in this forum, and can’t seem to find any mention of this process, other than it gets stored with the batch report for those that keep paper copies. Our struggle is that we may have dozens of pieces of paper for each gift report (or, during busy times of year, hundreds), so having to flip through them all to find one donation’s information seems cumbersome. Do you organize this paper backup in any particular way that you find helpful?

     

    At my organization, where we also have a busy times of the year, we recently converted to keeping the bare minimum of paper and converted to storing our batch reports as PDFs and check copies as scans. One way we process gifts is through a lockbox at a local bank and they scan everything as it comes in, checks and direct mail together, and it is stored on a secure server and we have a log-in to the system to review those daily while reconciling. They keep those for 7 years so we have access to them the entire time if we ever need to go back and print a check copy for reference. We enter up to 5 lockbox batches every day based on what avenue of direct mail it was received, but we do receive a hard copy breakdown daily of what was received that we verify with the bank's deposit and those are filed by date for up to a year. Once the annual audit is done, we shred them. We also receive checks/cash/credit cards through the regular mail and Finance scans those check copies/credit card transaction approvals, etc. as a PDF and Accounting processes the checks remotely and then keeps them for a short amount of time. After the audit is complete, they're shredded. For our bigger donations, $500+ for organizations and $1,000+ for individuals, we store PDF scans of those checks and letters on the media tab/attachments in RE NXT, so they're easily viewable by our gift officers.


    Our processes provide back-up documentation pretty well, where if ever questioned, we can go back and find anything we'd need. Our organization went green in the past few years, so paper back-up was cut out as much as it could be, and honestly it was cumbersome and unnecessary as well. Since you're having to implement new processes due to your conversion, maybe you should step back and take a look at what it is you absolutely need vs. what you don't. I think you'll find a lot of it, you don't actually need and can access another way. Good luck! yes

  • We may do one or more batches in a day, generate one daily gift report, alphabetize the donation media for that day, and put them together in a binder. End of year, when we are processing large numbers of gifts, we may separate out memorial gifts from non-memorial gifts if that makes the thank you and acknowledgement process easier.  
  • Jill Freidmutter:

    We may do one or more batches in a day, generate one daily gift report, alphabetize the donation media for that day, and put them together in a binder. End of year, when we are processing large numbers of gifts, we may separate out memorial gifts from non-memorial gifts if that makes the thank you and acknowledgement process easier.  

    Thanks, this is helpful.

Categories