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

CC to receive pymts EX. Customer paid square $925. I rcv'd $892.47 with a fee $32.53. In bank review it has $892.47,Partially matched: $925.00 remaining out of $892.47

I do not know how to match this correctly
1 Comment 1
BettyJaneB
QuickBooks Team

CC to receive pymts EX. Customer paid square $925. I rcv'd $892.47 with a fee $32.53. In bank review it has $892.47,Partially matched: $925.00 remaining out of $892.47

Hi there, @4545.

 

I got you covered in matching your bank transactions in QuickBooks Online.

 

There are two ways on how you can handle merchant fees in the system in order to match your bank transactions.

 

The first is to utilize the Resolve Difference option on the Banking page. This helps match your transaction and resolve its difference until it will be equal to zero.

 

To do that:

  1. Go to the Banking menu at the left pane to get to the Banking page.
  2. Proceed to the For Review tab and tick the transactions to open. 
  3. Select the Find other records or Find match button to open the Match transactions window.
  4. By default, the Match transactions window lists All transactions within the date range, but you can narrow the results.
  5. Use options on the Show drop-down menu to specify the type of transaction you're looking for.
  6. If the amounts are different, you can locate additional matched transactions, or select Resolve Difference to open the Add resolving transaction fields to add the Category and Amount (and, optionally, Payee) of a resolving transaction until the difference equals zero.
  7. If necessary, you can use the Add new transaction button to add multiple resolving transactions.

The second is to enter the bank service fee amount directly into the register. This way, the register's balance matches the bank statement balance. Entering the bank service fee, you will then enter the fee as a negative amount on the Bank Deposits screen when depositing a payment.

 

Here's how:

  1. Go to the Accounting menu, and then choose Chart of Accounts.
  2. Select the right account, and then click View register from the Action column.
  3. Add the bank service fee, and then click Save.
    q30.PNG
     

After that, you can now enter the fee as a negative amount on the Bank Deposits screen when depositing a payment.

 

To do that:

  1. Click + New, and then select Receive Payments.
  2.  Enter all the payment information, and then choose the checkbox next to the invoice you would like the payment to be applied to.
  3. Select the Undeposited funds account from the Deposit to drop-down.
  4. Click Save and close.
    q31.PNG

Once done, create a bank deposit and add the fee as a negative amount:

  1. Click + New, and then select Bank deposit.
  2. Select all the payments you want to deposit.
  3. Go to the Add other funds to this deposit section, and then enter the amount of the bank service fee charged to you by the credit card company as a negative amount.
  4. From the Account section, select the Expense account you usually use in tracking bank fees.
  5. Check and fill out other necessary information.
  6. Click Save and close.
    q32.PNG
     

For more details about this process, please refer to this link: Enter a bank service fee while using a third-party merchant service.

 

Also, to learn more about matching transactions, feel free to check out this article for more guidance: Categorize and match online bank transactions in QuickBooks Online.

 

Feel free to post a reply below if you have other concerns with your bank transactions in QuickBooks Online. I'll be more than happy to assist you again. Have a great day and take care always.

Need to get in touch?

Contact us