Credit Card Fees in RE and FE

Options
Dear Colleagues!  Let me start by saying that we have both RE and FE and we are tied together.  We have one credit card processing company that takes out the processing fees BEFORE they deposit the money into our Bank account.  So the donor gives us $100 but we receive only $97.  We want to enter ONE donation on the personal record at $100 but this will NOT reconcile to Finance.  We do not want to enter two entries on the donor record - like $97.00 and then $3.00 which would confuse the staff and create incorrect reports.  We have not in the past EVER entered split gifts - but that might be the only way to go?  Any ideas or tricks?   thank you!  Karen Knisely- Moses Brown School
Tagged:

Comments

  • Hello!  I'm not sure if this is helpful, since we do not use FE, but we have 4 different credit card sources, and have the same issue.  I always enter the actual donation amount to the constituent record, and then on the deposit summary for finance, I add a second line item for fees related to that particular deposit.  this way, the constituent record shows the actual donation, and my bank reports reconcile.  its a lot of extra work, but its the only way for me to tie out.  With systems like everyday hero, most donors actually pay the fees, so for each deposit and each item, i have to make sure I record correctly to tie in RE and also to the bank.  i don't use FE, so not sure if this is helpful.  Good luck!
  • Thank you so much!  karen

     

    Karen
    Knisely

    Moses Brown
    School

    Development
    Associate for Gifts and Records

    kknisely@mosesbrown.org

    401-831-7350 ext.
    183

     

     

  • This helps a lot!!  Thank you so
    much!  karen

     

    Karen
    Knisely

    Moses Brown
    School

    Development
    Associate for Gifts and Records

    kknisely@mosesbrown.org

    401-831-7350 ext.
    183

     

     

  • You enter the full gift amount - your finance office books the fees to a bank fee account. They just need to access whatever report tells them the fees incurred.
  • Thank you!!  That’s what we thought –
    have a great day!!  karen

     

    Karen
    Knisely

    Moses Brown
    School

    Development
    Associate for Gifts and Records

    kknisely@mosesbrown.org

    401-831-7350 ext.
    183

     

     

  •  Yes, this has always been up to the finace department to figure out at all of the organizations I've worked at. We enter the full gift and finance has to justify the credit card fees in their database.

  • To use a tiny bit of fiance jargon, RE should only be tracking gross income, not net income. Finance just needs to look at the gross amount you post and apply the fee for the credit card processing company and come up with a net amount, which will reconcile with their deposit. 
  • Elaine Tucker
    Elaine Tucker Community All-Star
    Ancient Membership Facilitator 2 Name Dropper Photogenic
    I agree with all posts Total income in RE. This following may be helpful to some: 


    We are integrated with FE and we use BBMS, so when I get notification that a disbursement has been made, I post all the credit card gifts for the "report period" to FE in summary.  Prior to POSTING in FE, I adjust the journal reference field for the deposits, and note the NET of the deposit.  I also make all the post dates equal to the disbursement date.  This helps our finance office tremendously when they are reconcilling the bank statement.


    We also have a recurring batch in FE that is "credit card fees" and I create a batch for those fees right after I've posted from RE to FE to reflect the fees for the same "report period" and also make the post date the same as the disbursement date of the deposits - this also helps in bank rec.
  • Dear
    Elaine – thanx so much for this additional information!!! 
    karen

     





  • Karen Knisely:

    Dear Colleagues!  Let me start by saying that we have both RE and FE and we are tied together.  We have one credit card processing company that takes out the processing fees BEFORE they deposit the money into our Bank account.  So the donor gives us $100 but we receive only $97.  We want to enter ONE donation on the personal record at $100 but this will NOT reconcile to Finance.  We do not want to enter two entries on the donor record - like $97.00 and then $3.00 which would confuse the staff and create incorrect reports.  We have not in the past EVER entered split gifts - but that might be the only way to go?  Any ideas or tricks?   thank you!  Karen Knisely- Moses Brown School

    No matter the CC fees.  The donor should get credit for the $100.  The fees are the cost of doing business and should not be entered as a separate item or even noted in RE.  That is something that your Finance department has to reconcile. 
  • Thank
    you Christine!  We really need comments like these since our
    Finance Department is fighting us on this - karen

     





  • We have both sides. Our processor bills for credit card fees so we get the full amount of the donation. But we have a couple recurring donors that set up with eCheck years ago and the processor will deduct from those before depositing the funds into the account.  We enter the full amount of the donation into RE and accounting makes an adjustment on their side for the fees. 
  • Thanx
    Jessica!!   karen

     





  • Karen, you can add another vote if you need it for full donation amount in RE, fees handled by finance.  Totally agree with posts to that effect.


    It's no different than your constituents paying for programs, memberships, trinkets through other departments using a credit card.  Finance should be dealing with all in a similar manner.
  • Yay
    JoAnn!!  Thanx so much - karen

     





  • We also record the full amount of the donation to the donor's record. Fees are recorded as an expense.
  • Karen Knisely:

    Dear Colleagues!  Let me start by saying that we have both RE and FE and we are tied together.  We have one credit card processing company that takes out the processing fees BEFORE they deposit the money into our Bank account.  So the donor gives us $100 but we receive only $97.  We want to enter ONE donation on the personal record at $100 but this will NOT reconcile to Finance.  We do not want to enter two entries on the donor record - like $97.00 and then $3.00 which would confuse the staff and create incorrect reports.  We have not in the past EVER entered split gifts - but that might be the only way to go?  Any ideas or tricks?   thank you!  Karen Knisely- Moses Brown School

    Just like stocks - do you take all the fees or gains intoaccount when putting a gift on a donor's account? That's cost of doing business, and the donor doesn't pay that.

  • We do the same.

Categories