Skip to main content
March 23, 2021
Question

I've received a payment to remove from A/R. The transaction is less the wire fee. How do I manually match these to items so it doesn't show double entry in my total?

  • March 23, 2021
  • 1 reply
  • 0 views
Original commenter did not share additional details

1 reply

Rebecca R
March 23, 2021

Hi there SU2020-KF,

 

Ensuring that you're matching the transactions in your bank feed with those that you've manually entered into QuickBooks is important. It's a great way to prevent duplicate entries, as you've mentioned, and saves you the step of manually checking off your transactions during reconciliation. Let me give you a hand with this.

 

It sounds to me like the transaction that's showing up in the bank feed is the amount of the transaction that you manually entered, minus the fee. There are a couple of ways you can handle this. For both options you'll need to create an expense account for Bank Fees. Here's how to do this:

 

  1. Hit the Accounting menu from the left and choose Chart of Accounts.
  2. Select New.
  3. Create an Expense account for Bank Charges, and name it Bank Fees or something along those lines.
  4. Save and close when you've finished entering the account details.

 

The first option you have would be to create a Non-inventory item from the Products and Services tab of the Sales menu. You can title it Bank Fees or something along those lines and ensure that you've selected that you Purchase this product/service from a supplier. Use the new expense account that you created as the Expense account for this item. Open the transaction that you've already created in QuickBooks Online and add an extra line for your new item and enter the amount of the fee as a negative number so that it subtracts from your total. 

 

The second option you have is to simply Resolve the difference in the bank feed. Once the expense account is created you can resolve the difference between the transaction you've entered and the feed by hitting Resolve Difference and opening the Add resolving transactions fields. You'll find the step-by-step instructions on how to do this in the article below:

 

 

Let me know if you have any other questions or if my response didn't quite hit the mark. You can expand on your inquiry by replying to this thread, making sure that you don't include any sensitive account details since this is a public forum. Take care and enjoy your week!