cancel
Showing results for 
Search instead for 
Did you mean: 
BandN
Level 2

QB payment

I made an invoice and QB payment took the fee related to that invoice and QBO recorded that amount as an expense.

When I received the payment, I matched it to the invoice and I had to resolve the difference by adding the fee as an expense. 

But now I have two expenses for the same transaction. One that was added by the system automatically and one that I added manually. 

 

Is there another way to do that where I don't have 2 transactions or do I need to delete the one that the system created?

Solved
Best answer April 12, 2024

Best Answers
JoanaC
QuickBooks Team

QB payment

Thank you for your prompt response on the thread, @BandN. Let me assist you in matching your invoice and payment in QuickBooks Online.

 

We can undo the categorized bank transaction from your client. Since you have QuickBooks Payments, we can turn on the automatic match. This feature will match invoices and payments automatically without you manually doing so.

 

Here's how :

  1. Go to Transactions, then Bank Transactions.
  2. Select the Categorized or Reviewed tab.
  3. Select Settings ⚙ at the top of the transaction list.
  4. Turn the Automatic matching switch On or Off.

 

Let me share these articles that can help you match your transaction:

 

 

I'll be here if you still have questions about your bank transactions, Have a great day!

View solution in original post

8 Comments 8
MariaSoledadG
QuickBooks Team

QB payment

Let me guide you on how you can resolve this, Band. 

 

In scenarios like this, you can record a deposit for the bank fees so QuickBooks automatically matches them with the payment. To create a deposit, you can follow the steps below:

 

  1. Go to the + New, then select Bank deposit.
  2. Under Add funds to this deposit, enter the bank fee. 
  3. Click Save and close.

 

You can delete the transactions you've manually entered and record them as deposits. 

 

In addition, learn how to reconcile an account to ensure that everything matches and is accurate. For more details, I've added this article: Reconcile An Account in QuickBooks Online.

 

You can always get in touch if you have any questions about bank charges or payments. I'm always right here to help you.

BandN
Level 2

QB payment

Thank you for your response, 

 

But when I do that, I still have the payment showing in my bank feed and when i try to match, there is nothing anymore since I did the bank deposit. 

 

So the invoice was for $5,000

The client paid $5,000 but quickbooks took $149.5 and the system record it from the start in the QBO (it show in the P&L report and the reconciliation). 

And when I received the money in my bank account, I have that transaction showing in my bank feed for $4,850.5 and when I match it to the invoice for $5000 I have to resolve the difference of $149.5 so I add the fee to the bank fee account. But now I have two bank fees for $149.5 and it doesn't reconcile. 

JoanaC
QuickBooks Team

QB payment

Thank you for your prompt response on the thread, @BandN. Let me assist you in matching your invoice and payment in QuickBooks Online.

 

We can undo the categorized bank transaction from your client. Since you have QuickBooks Payments, we can turn on the automatic match. This feature will match invoices and payments automatically without you manually doing so.

 

Here's how :

  1. Go to Transactions, then Bank Transactions.
  2. Select the Categorized or Reviewed tab.
  3. Select Settings ⚙ at the top of the transaction list.
  4. Turn the Automatic matching switch On or Off.

 

Let me share these articles that can help you match your transaction:

 

 

I'll be here if you still have questions about your bank transactions, Have a great day!

BandN
Level 2

QB payment

If I do the bank deposit first, it still doesn't recognize the transaction in the transaction tab. 

 

 

BandN
Level 2

QB payment

If I do the bank deposit first, It still doesn't recognize the transaction in "bank transaction"

CamelleT
QuickBooks Team

QB payment

Let me jump in and help you match your transactions in Quickbooks Online (QBO), BandN.

 

Your QBO account is already set up on where to deposit the payments and fees. Therefore, you don't need to use the "resolve the difference" feature. However, if you've already matched the payment and invoice, you'll need to undo these categorized transactions. Here's how to do it:

 

  1. Go to Transactions and choose Bank transactions.
  2. Select the tile for the bank or credit card account you downloaded the transaction from.
  3. Click the Categorized tab and locate the transactions you manually matched or resolved differences. 
  4. Once you find the transactions, hit Undo from the Action column.

 

The transactions will now go back to the For Review tab. Then, you can follow the steps provided by my colleague above to turn on automatic matching since you're using QB Payments. Once this feature is enabled, you won't need to manually match your deposits or other transactions. 

 

Lastly, I'll add this article to help you void or delete any transactions made in error to ensure that your account balances and reports aren't affected: Void or delete transactions in QuickBooks Online.

 

Just post a reply below if you require further assistance in matching your transactions or managing your deposits. I'll be around to help you. 

BandN
Level 2

QB payment

Thank you for your help but I still have issues. 

 

1. When I add the fee of 149.5 in the bank deposit In "Add funds to this deposit" like suggested,  I now have 2 transaction of $149.5 in the expense account. One from QB payment that says "system-recorded fee QB payment, transaction type "Expense" and one from the deposit. 

 

2. When I don't add it, now in the transaction in the bank fee, QB does not automatically match the amount receive to that bank deposit because the 2 amounts are different.

 

The amount showing in the bank deposit is $5,000 just like the invoice. But in reality the amount deposited was $4,850.5 because Quickbooks payment took a fee of $149.5.

 

Also when I try to reconcile the bank account I always have the $149.5 showing as an expense. But in reality, the transaction does not show in the bank statement. The bank statement shows that I received $4,850.5. So this transaction that QB payment automatically created won't be reconcile. 

 

Thank you 

 

 

 

 

Maybelle_S
QuickBooks Team

QB payment

I can help with your bank deposits, BandN.

 

QuickBooks Online (QBO) has an automatically match transactions feature to streamline the reconciliation process by identifying and matching transactions from your bank or credit card statement with those you've entered manually or imported into the program.

 

Since the issue persists after following the steps above, I suggest contacting our Customer Support Team. This way, they can pull up your account securely and check the cause of the problem.

 

Here's how:

 

  1. Go to the (?) Help icon.
  2. Select Talk to a Human.
  3. Enter a short description of your concern.
  4. Click on I still need a human.
  5. Tap Contact Us to connect with our live support.
  6. Choose to Get a callback.

 

For more details, check this link: Automatically match QuickBooks Online product transactions.

 

Once fixed, reconcile your accounts so they always match your bank and credit card statements.

 

Additionally, check out this article for revising past reconciliations:  Learn the reconcile workflow in QuickBooks.

 

Please keep us posted if you need assistance managing bank transactions or reconciling accounts. We're always here to help you out.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up