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 07:53pm

    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
    23 Jan, 2020 07:14pm

    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
    25 Aug, 2016 09:06pm

    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
    24 Aug, 2016 07:24pm

    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
    13 Aug, 2016 03:08am

    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
    10 Jun, 2016 01:35am

    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