Skip to main content
March 11, 2021
Question

CC payment deposit adjustment

  • March 11, 2021
  • 1 reply
  • 0 views

I'm in a bit of a bind with CC payments and I'm not sure if there's an easy way to fix this or not. 

 

We use PayPal for our CC processing. We typically get payments through checks but we do accept CC when customers need us to. But now a problem popped up during reconciliation.

 

The problem is this

 

1. Whenever someone pays with a CC my AR manager was marked them down as paid though Quickbooks on the invoice, like you regularly would when accepting a check payment but she didn't transfer the money into our bank until sometimes a month or 2 later. So it looks like it was paid one day but the money doesn't come into our bank for another month.

 

2. We aren't recording the fee associated with accepting the CC payment correctly either so the invoices that have been paid have been recorded without the fee so the when we actually do transfer the money from PayPal into our bank the numbers don't add up since whatever the original invoice costs is higher then the invoice minus the CC fee PayPal takes out.

 

I didn't know she was doing it this way so when I started the reconciliation I was matching up the PayPal transfers and having the payments go in the right accounts but now we are basically showing 2 payments for every invoice paid through CC. 

 

3. The PayPal transfer we make is in one lump sum so it's sometimes hard to see which invoices it's paying for.

 

Is there an easy way to fix this? Would anything bad come of just keeping the lump sum payments recorded the way I have been for the rec and just delete or void all the invoices paid this way or do I have to go back and manually enter the payments for the dates the money actually came into the account and alter the price of the invoices manually?

 

Thank you!

1 reply

JasroV
March 11, 2021

I appreciate you for sharing the details of your concern with us, @cityelevatorcompany.

 

I know some way we can record the lump sum payment and the banking fees. You can create a bank deposit do deposit the lump sum amount on any day. Then, add the fees from there. Let me show you how.

 

  1. Go to the + New menu
  2. Click Bank Deposit.
  3. Choose the bank account where you want to put the money into.
  4. Select the checkbox for each transaction you want to combine.
  5. Then go down to the Add funds to this deposit section.
  6. Enter the fee as a line item.
  7. Fill in the needed details and click Save and close.

 

You can also check this link for more details: Record and make bank deposits in QuickBooks Online.

 

I’d also recommend working with your accountant for additional guidance. This way, we can guarantee the accuracy of your accounts after recording this. If you don’t have one, you can visit our ProAdvisor page and look for one from there.

 

Also, to be able to select those transactions when recording a bank deposit, you’ll want to ensure you put them first in your Undeposited funds. An Undpeoosited fund acts as a lockbox or safe where you keep the funds until you’re ready to deposit them to your bank. 

 

For more insights on how Undeposited funds works, check out this link for reference: How to Use the Undeposited Funds Account to Receive Payments in QuickBooks Online.

 

Moreover, I got you this article that you can read for reference in matching your bank balance and QuickBooks balance seamlessly: Reconcile an account in QuickBooks Online.

 

If you have other follow-up questions about recording payments or reconciling your accounts, you can always tag me in your reply. I’m only a few clicks away from you. Stay safe and keep well