QuickBooks HelpQuickBooksHelpIntuit

Fix QuickBooks Payment deposits that don't match your bank statement

by Intuit Updated 1 year ago

Learn how to fix QuickBooks Payments deposit issues so you can reconcile your accounts.

If you have QuickBooks Payments, you can process customer payments in QuickBooks Online. QuickBooks automatically puts the money in your bank account and categorizes everything in your chart of accounts. When you accept multiple payments in one day, QuickBooks groups everything and records them as a single deposit.

In rare cases, your bank may group payments differently. When you reconcile the account, you may notice the deposit in QuickBooks doesn't match your bank statement. We'll show you how to edit deposits in QuickBooks so everything matches.

If you don't use QuickBooks Payments, here's how to do a manual bank deposit.

Step 1: Find the payments you need to fix

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

  1. Sign in to the Merchant Service Center.
  2. Select the Activity & Reports tab and then Deposits.
  3. In the Dates fields, select the date range you're reconciling.
  4. Find the deposit you need to correct.
  5. In the Fee column, select the deposit to expand the view. This lists all the payments grouped in the deposit.

Compare the list of payments with your bank statement. If QuickBooks grouped everything the same way and the totals match, you're good to go. You can continue reconciling the account.

If things don't match, don't worry. Keep the payment list open in your web browser and move on to Step 2.

Step 2: Correct the deposit in QuickBooks Online

Review the deposit QuickBooks created for you. Use your bank statement as the source of truth and the list of payments as a reference:

  1. Sign in to QuickBooks Online.
  2. Go to Settings and select Chart of Accounts.
  3. Find the account you're reconciling. It's the one you use for QuickBooks Payments. Then select View Register.
  4. Find the deposit you need to correct. Tip: It should have "System-record deposits for QuickBooks Payments" in the Memo column.
  5. Select the deposit to expand the view. Then select Edit.

Check your bank statement again. How did your bank combine the payments? If the bank combined two payments and recorded the third separately, but QuickBooks grouped all three together, fix the deposit in QuickBooks. If you've found the issue:

  1. In the Deposit window, go to the QuickBooks Payments section.
  2. Review the list of checked and unchecked payment transactions. If a payment is checked on the deposit, but it's not part of the deposit on your bank statement, uncheck it to remove it. Or select the checkbox to add a payment to the deposit.
  3. Check the deposit total. It should match the deposit amount on your bank statement.
  4. When the deposit in QuickBooks matches your bank statement, select Save.

Now you can continue reconciling the account.

Don't see a payment you need to add?

In rare cases, QuickBooks may have added the payment to a different deposit. Follow "Step 2: Correct the deposit in QuickBooks Online" to find the deposit and remove the payment.

Then follow the steps again to add the payment to the correct deposit.

QuickBooks Online AdvancedQuickBooks Online EssentialsQuickBooks Online PlusQuickBooks Online Simple StartQuickBooks Payments

Sign in now for personalized help

See articles customized for your product and join our large community of QuickBooks users.

More like this