SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends June 27

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
res@finisroadrvp
Level 3

Can someone help me separate a QB payments batch in my bank feed in my bank register?

In my QB payments batch it includes a refund for customer A and a deposit(sale) for customer B. My bank feed shows as "Spent" because the refund is more than the deposit.

1 Comment 1
ShangY
QuickBooks Team

Can someone help me separate a QB payments batch in my bank feed in my bank register?

It can happen that the deposit in QuickBooks doesn't match your bank feeds, res, and there are steps we can take to separate the transactions that don't belong to the deposit, res.

However, please know that QuickBooks Payments combines all of your customer payments (both sales receipts, paid invoices, and refunds) for the day into a single record, and in the process I'll detail below, it's important to have your bank statement as a reference to confirm that the deposit record matches what you see in your bank statement.

 

To get started, get a list of your deposits and the related customer payments.

  1. Sign in to the Merchant Service Center.
  2. Choose Activity & Reports and then Deposits.
  3. In the Dates fields, pick the date range you're reconciling.
  4. Find the deposit you need to fix.
  5. In the Fee column, select the deposit to expand the view. This lists all the payments grouped in the deposit.
  6. Compare them to what you see in your bank statement.

Next, take note of the things that don't match and keep the payment list open in your web browser. Then, follow these steps to correct the deposit entry. Here's how:

  1. Go to the Gear icon and select Chart of Accounts.
  2. Find the bank account where QuickBooks posted the bank deposit record. Then, click View Register.
  3. Find the deposit you need to correct.
  4. Note: It should have System-record deposits for QuickBooks Payments in the Memo column.
  5. Choose the deposit to expand the view. Then select Edit.
  6. In the Deposit window, go to the QuickBooks Payments section.
  7. Review the list of checked and unchecked payment transactions.
  8. Uncheck the refund for customer A to remove it.
  9. Click on Save and close when done.

Additionally, I recommend that you regularly reconcile your account to prevent financial discrepancies in the future.

Please let me know if you have any additional questions or need clarification. I am always here to help. Have a great day!
Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us