cancel
Showing results for 
Search instead for 
Did you mean: 
AlliFenwick
Level 1

Matching Bank Deposit with Received Payment

I've been using Quick Books Online for about 6 months and sadly have been running into strange glitches practically every step of the way. To get around these glitches, I've been having to undo hours of work and manually re-enter a lot of things.

 

Here's what I'm running into currently. I'm a photographer, so when a client and I agree to work together, I create an invoice in Quickbooks. When a client makes their first payment through Square, I navigate to the "Invoices" page and click "Receive Payment" next to that client's invoice. Once the deposit appears in my checking account from Square, I go to the "Banking" page and click on the transaction that represents the deposit from Square. I click "Find Match" and I'm taken to a page where I'm able to select the "Received Payment" that I recorded for that client. Due to credit card processing fees, the amount that is deposited into my checking account and the payment that is to be represented on the invoice are different. So, when matching the payment with the transaction, I select "Resolve Difference" and deduct the credit card processing fees there. Every time I reach this step, I click "Save and Close" and an error message appears... "Something's not quite right. Unexpected Internal Error (-30009)." After I refresh the page, the bank transaction moves from "For Review" to "Reviewed" and multiple duplicates of the "Credit Card Processing Fee" that I put in the "Resolve Difference" section show up in my expenses. The last time I tried this, a $12.60 credit card processing fee posted eight separate times for a total of $100.80.

Screen Shot 2019-04-03 at 10.47.11 PM.png

I then have to go through and delete all of those duplicate expenses, unmatch the bank transaction from the payment, delete the payment and start all over again. 

 

This is beginning to get really frustrating. Something that should take 5 minutes ends up taking 30+ minutes. Any help would be much appreciated.

1 Comment 1
Kristine Mae
Moderator

Matching Bank Deposit with Received Payment

I can help you get around with your concern, AlliFenwick.

 

Once you receive the invoice payments, deposit it to the Undeposited Funds, and deduct the credit card processing fee from there. When the deposit hits your bank account, match it to the existing deposit in QuickBooks Online. This way, you no longer need to resolve any differences.

 

First, here's how to deposit the payment to the Undeposited Funds:

  1. Click the Plus sign (+) icon, then choose Receive Payment.
  2. Choose the customer, then the invoice.
  3. Enter the amount received.
  4. Click the Deposit to drop-down arrow, then choose Undeposited Funds.
  5. Click Save and close.

Next, add the credit card fee. Here's how:

  1. Click the Plus sign (+) icon, then choose Bank Deposit.
  2. Choose the invoice payment.
  3. Under Add funds to this deposit, add the customer, then choose an expense account for the fee.
  4. Enter the fee as a negative amount.
  5. Click the Account drop-down arrow, then choose the bank account.
  6. Click Save and close

Lastly, match both deposits.

 

Refer to my screenshots below.

 

 

 

Feel free to let us know if you have further questions. 

 

Need to get in touch?

Contact us