Allow us to record debits to cash receipts, allowing us to post net amounts (such as Spherion payments where fees were charged)

When posting cash receipts, we often have a debit offsetting the revenue, creating a net deposit amount. An example is using the Spherion website for fundraising. We receive a twice monthly payment from Spherion, when people have posted gifts online using a credit card. Spherion charges a fee and we have bank fees associated with the gift. We want to record the full gift amount against the receivable but the net amount to cash. Currently we have to record the net amount and then do an ugly journal entry to capture the other pieces.
  • Guest
  • May 2 2016
  • Future consideration
  • Attach files
  • Taylor C-H commented
    13 Aug 19:53

    I posted a similar idea myself before seeing this, but seeing as this is old, I figure I can keep my entry. That said, seeing as this is at least marked as future consideration, I'm going to add my voice. Fees need to be incorporated into payments without having to make an entire second entry. Be that against an invoice, or just a cash receipt.

  • Guest commented
    January 23, 2020 19:14

    Agreed this is definitively not solved - you cannot create a net import outside of a journal entry and there is no way to deposit a cash receipt item net of fees. 

  • Sannyasin Siddhanathaswami commented
    August 25, 2016 21:06

    Aloha Thomas,

    Two important things:

    1. You can't import negative amounts into a Cash Receipt (according to the link you sent).

    2. I import deposits as Bank Adjustments not via Cash Receipts. I need to be able to import Bank Adjustments with fees. Maybe this is a separate idea from the original post?

  • Thomas Walker commented
    August 24, 2016 19:24

    here is the KB tip, it's geared more to the database view but you can do the same thing in FE NXT

    https://kb.blackbaud.com/articles/Article/74196

  • Sannyasin Siddhanathaswami commented
    August 13, 2016 03:08

    This idea was just marked "Already exists" but I don't see how to do this in either FE7 or NXT. Can you point me to documentation on how to do this?

  • Sannyasin Siddhanathaswami commented
    June 10, 2016 01:35

    Agreed. We have this issue with Paypal donations. Paypal deposits funds in our bank account net of fees. For us, that means we have to enter one entry for fees, then a separate entry for the gross donation. Makes bank reconciliation more tedious.

  • +19