Bank reconcilation has multiple offsetting entries

Let me provide some insights about offset entries when reconciling and how to handle this, @dksnyder. 

It could be that there were old transactions or Journal entry that was created before using payroll on the account causing the offset entries. To verify, I suggest consulting your client if they have recorded any previous data. 

Additionally, let me share this link to help you reconcile your accounts so that they always match your bank and credit card statements.

Feel more than welcome to post a reply if you have further questions about reconciling an account in QuickBooks. I'll be here to help. Have a wonderful day!

There are no journal entries for any payroll information. It only happens with some of the entries. I think it may have something to do with the deposits that Quickbooks is making to pay various payroll items. (direct deposit checks, taxes, child support withheld, etc)

.It only happens with some of the entries. I think it may have something to do with the deposits that Quickbooks is making to pay various payroll items. (direct deposit checks, taxes, child support withheld, etc)

Hello there, @dksnyder. I appreciate you for getting back to us.

Some bank transactions may not perfectly match system transactions. The mismatches are due to bank errors in reference such as transaction number, amount, and other details of the transactions. You may want to check this article for more information: Fix mismatched or miscategorized bank transactions.

You have the option to undo a reconciliation. Here's how:

1. Go to the Gear icon.
2. Select Reconcile under the Tools column.
3. On the Reconcile an account page, select History by account.
4. On the History by account page, click the Account and Report period to locate the reconciliation to undo.
5. Choose Undo on the Action column, then Yes.
6.  In the final confirmation window, pick Undo and OK.
   

Once done, you and your client are ready to redo the reconciliation.

Please let me know if you have follow-up questions. We're all right here to assist you anytime. Take care and stay safe.

This is not mismatches. This is extra entries that negate the actual entry.  There are entries for $xx.xx which are payments so the bank account is credited for that amount and then immediately nest to that  or very near it is an entry fo r the exact amount but it is a debit to the account thus voiding the actual entry.  This in turn understates the expenses or if it is a deposit understates the income going into the account. If I delete the extra entry then the actual entry also disappears from the account.

Hi @dksnyder,

I have some information about the multiple payroll entries in your register. When you send your Direct Deposit payroll to Intuit for processing, the following happens:

• Intuit's payroll system posts a QuickBooks Liability Check in your bank register for the total amount of Direct Deposit payroll plus processing fees.
• Intuit will debit your bank account for the total amount on that liability check, a banking day before the paycheck date.

The QuickBooks Payroll Liability Check is auto-generated and posted to your bank register by the payroll system. This liability check reduces the balance in your QuickBooks bank register for the sum total of all direct deposit paychecks and their associated processing fees. Because the net amounts on Direct Deposit paychecks are already included in the QuickBooks Liability Check, any Direct Deposit paycheck will display on your bank register with a zero net amount.

That said, you'll want to reconcile the entry that has the total amount of your Direct Deposit amounts. For detailed steps, refer to this guide: Reconcile an account in QuickBooks Online.

I'm also adding this link if ever you encounter direct deposit issues. It has answers that'll help you on how to deal with them:: Fix direct deposit issues.

Know that you're always welcome to reply if you have other questions or concerns with entries in your register or bank statement.  Take care and have a wonderful day ahead.