Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks. Explore QuickBooks Payroll

Reply to message

View discussion in a popup

Replying to:
ReyJohn_D
Moderator

Reply to message

I'll help match your transactions in QuickBooks, @HollyJ.

 

First, thanks for following the suggestions given by my peer above. I've got other solutions you can perform to get around the matching issue you're having.

 

Yes, you can't calculate those processing fees directly since you received those payments from third-party merchant services, like PayPal, etc. There are bank service fees that the credit card company will deduct from the payment. Thus, the payment amount that shows on the bank register won't match the deposit amount in QuickBooks Online.

 

In this case, you can enter the bank service fee amount directly into the register. This way, the register balance matches the bank statement balance. 

 

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

Then, it's time to create a bank deposit:

 

  1. Click + New again, 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, please refer to this handy article: Enter a bank service fee while using a third-party merchant service.

 

Next, you can do the usual matching process.

 

Also, QuickBooks will create an adjustment or journal entry when you use the Resolve difference feature. You usually do this when you're matching the same transactions, but their amounts don't quite add up.

 

When you're all set, you can begin your usual reconciliation. This way, you can ensure your books are accurate.

I'm still around to help if you need more banking insights. I'd be glad to extend a helping hand. Have a great day!

Need to get in touch?

Contact us