Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I use a 3rd party payment processor for church donations. When I receive reports of transactions, I create a sales receipt for each donor and deposit to the Undeposited Funds account. When the bank deposit comes in, I match the deposit to the sales receipt and I deduct any processing fees. There could be multiple sales receipts on one day.
My issue is I had 2 sales receipts (2 donors) created on 2 different days. Donor 1's payment had to be reversed. Subsequently, when the deposit came in both donors were on the same transaction and it ended up being a net expense.
How do ensure donor 2 receives "credit" for their donation and Donor 1's payment is reversed?
Thanks for getting in touch with the Community, MUMC Finance. I appreciate your detailed information.
To verify my understanding, did these two payments get lumped into one transaction, or did the bank deduct your cancelled payment from the deposit? Once I have these details, I'll be able to do further research into what options you have.
I'll be looking forward to your reply. Have a lovely Thursday!
Initially the bank accepted the donor 1 deposit. A few days later the bank cancelled the previously deposited amount of Donor 1 and accepted Donor 2's donation which was lumped into the same transaction yielding a negative deposit.
Thanks!
Thanks for getting back with the Community, MUMC Finance.
If your negative deposit is currently in the Undeposited Funds account, you can't deposit a negative value entry by itself. Your net deposit must be a value greater than, or equal to, zero.
To resolve this, you can make a zero value deposit and record the negative value deposit with it.
Here's how:
After creating your journal entry, you can offset the negative value.
I'll be here to help if there's any additional questions or information you'd like to provide. Have a wonderful Thursday!
Additional clarification:
1/10/24
Donor 1 Sales receipt - $300 credit to Undeposited Funds
Donor 1 Deposit - $295.44 credit to bank account
Donor 1 Processing Fees – ($9.56) debit to bank account
Register reflects $295.44 net deposit
1/16/24
Donor 2 Sales Receipt - $130 credit to Undeposited Funds
"Donor 1" – ($291.93) debit to bank account
"Donor 2" - $130 credit/deposit to bank account
"Donor 2" Processing Fees – (3.91) debit to bank account
Register reflects ($165.84) debit to expense (Not connected to either Donor 1 or 2)
Donor 1 still reflects $300 in Undeposited Funds
Donor 2 still reflects $130 in Undeposited Funds
Donor 1 account is overstated by $300
Donor 2 account is understated by $130
I wan to ensure in reporting that Donor 1 isn't erroneously with $300 and Donor isn't erroneously understated $130.
Thanks
Awaiting resolution based on clarification sent on 4/22. There was no negative deposit in Undeposited Funds.
Thanks
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here