Good eye with noticing the discrepancy in the amount calculated versus what you gave your employee. I'm glad to hear you were able to work it out with them. It sounds like you're now trying to match those two separate amounts from your account in the banking feed to the single pay cheque in QuickBooks Online.
When it comes to matching amounts from the bank feed to pay cheques from the Payroll module, the program will only allow you to match one transaction to the payroll transaction. In instances where you have more than one transaction in your bank feed for a single pay cheque, you won't be able to match it and it's best to exclude the transactions from the bank feed. Learn more about bank feed tasks here: Categorize and match online bank transactions in QuickBooks Online
Don't worry, excluding the transactions doesn't hurt your books since the payroll transaction already exists from the Payroll module. All that happens in this case is since you're not matching anything to it, the program won't have it pre-checked during reconciliation. All you'll need to do is keep this in mind when you're reconciling your accounts later.
I hope that helps. Let me know if you have further questions.
Thank you Laura. I excluded both the 3256 and 270 transactions.
When I reconcile, I still have a difference of $270 showing up. I originally completed the payroll on Feb 27 for 3526, however I mistakenly paid the employee 3256 and did not notice the discrepancy until April.
I then paid the employee the missing $270 April 16. So QB sees the payroll amount from Feb as 3526, however the February bank statement shows the amount is 3256.
How do get to zero when reconciling?
I see. In this instance, I recommend getting in touch with QuickBooks Online support directly so an agent can work with you directly to see about working out a solution based on what you've done so far and the Payroll module you're using. Here are the options for contacting support outside of community.
Phone and Chat: Click Contact Us to learn how to reach phone and chat support.
Schedule a Callback: click (?)Help in the upper right > click Contact Us > explain your situation > click Let's Talk > choose Get a callback (Note: Callback hours are the same as regular phone hours.)
Don't hesitate to reach out!
Did this get resolved? I am having a similar issue. I created one paycheck. I had to make two electronic deposits to equal the paycheck. I ignored the two checks in my bank feed and now I can't get any reconciliation to match.
Unfortunately the Quickbooks team could not help and recommended I ask my accountant. Create a journal entry on the date of the first incomplete payment difference (in my case, I shorted them $270). Debit the Bank 270, and credit Uncategorized Expenses 270. Create a second journal entry on the day you applied the 2nd payment. In my case, credit the Bank 270 and debit Uncategorized Expenses 270. From there, you can match the 270 bank transaction if you want, and exclude the original incorrect payroll payment. Your payroll reports and source deductions will not be affected by doing this as the paycheque has already been created. After this, the bank reconciliation zeroed out.
I'm unsure why QBO doesn't allow you to match 2 payments to a paycheque to avoid this hassle.