cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here

Reply to message

View discussion in a popup

Replying to:
LieraMarie_A
QuickBooks Team

Reply to message

Thanks for the clarification, @lizelle-cjctax-c

 

I've got all the steps to make sure everything is accounted for. If you receive a payment less than the invoice amount due to bank fees, we can use the Resolve Difference feature to account for the bank charge.

 

First, let's undo the invoice you've matched in the bank feeds. Doing this will allow us to make the changes as it will reverse the transaction and go back in the For Review tab.

 

  1. Go to Banking.
  2. Select the blue tile for the account you want to review.
  3. Select the Categorized tab.
  4. Find the transaction you want to remove.
  5. Select Undo from the Action column. 

The screenshot below shows you the last three steps.
Capture.JPG

 

These instructions are available from our guide on categorizing and matching online bank transactions in QuickBooks Online.

 

Then, follow these steps below to create a Bank Charges account:

  1. Go to Accounting from the left menu.
  2. Choose Chart of Accounts.
  3. Click New.
  4. In the Account dialog, create an Expense account for Bank Charges, and give it a name, e.g Bank Charges or Bank Fees.
  5. Select Save and close.


You can refer to our guide on adding an account to your chart of accounts in QuickBooks Online for your convenience.

Once done, you can match the invoice with the bank transaction and use the Resolve Difference feature to record the bank fee. Let me show you how.

 

  1. Go to Banking on the left menu and choose Banking.
  2. On the Bank and Credit Cards page, make sure you have selected the Bank Account with the transaction.
  3. Locate the transaction with the amount of 1891.27 in the For Review tab.
  4. Tap Find Match.
  5. In the Match transactions window, choose the checkbox of the appropriate Invoice.
  6. Enter the exact payment 1898.07 in the Payment field.
  7. Tick Resolve Difference to open the Add resolving transactions fields.
  8. Click Add new transaction.
  9. From the drop-down list in the Category field, select the Bank Fees expense account you created.
  10. Enter a negative amount for the bank fee, e.g -6.80.
  11. Press Save and close.

Here's an example:

Capture.jpg

 

Your transaction is now matched off against the invoice and the bank fees are accounted for. Feel free to visit our Banking page for more insights about managing your bank feeds.

 

If you have any other questions or clarifications, feel free to leave them in the comments below. I'll get back to you as soon as I can.