Limited time. 50% OFF QuickBooks for 3 months.
Buy now & saveWe accidentally paid an employee $400 via direct deposit, instead of $100. The employee returned $300, we voided the $400 paycheck, and we registered the correct $100 payroll as a paper check. I don't know how to categorize this to reconcile our accounts. Currently our chart of accounts sees payments of $400 and $100, and a deposit of $300. This leaves our balance at -$200, instead of -$100.
I thought I could split the paper check transaction to bring the sum to $0 while still including that payroll item so our tax liabilities are correct. But when I try to edit the item through either bank register or payroll item's transaction journal, I just get sent to the Payroll Summary reports page.
Solved! Go to Solution.
The response above is going to put you in the same situation: -$400 expense + $300 deposit - $100 check = -$200.
I think the solution here is to create a $0 paycheck (instead of $100) for the employee because it's the $100 paycheck that's throwing off the balance since you didn't give that to the employee. The only two transactions that are hitting your bank account are the $400 payment and the $300 deposit, correct? If so, assign your payroll wage expense account to both of those transactions, create the $0 paycheck to get the withholding correct and you should be all set.
There's no need to modify the paycheck or item, smpri. Instead, we can accurately track and document the actual cash flow. Let me break down the details for clarity.
Since you've already recreated the $100 payment, create an expense transaction for the $400 payment with your employee as the Payee. This will account for the expense within your Chart of Accounts. You can refer to the image below:
Then, record a Bank deposit to account for the $300 returned payment you received from your employee. Following this process ensures your QuickBooks records match your bank statements.
Once that's complete, categorize all remaining transactions and proceed with reconciliation. Moreover, if you're unsure about the correct categories or accounts to use, I recommend consulting an accounting professional to provide further guidance to ensure you're on the right track.
Need more help categorizing payroll transactions? QuickBooks Live Expert Assisted offers personalized guidance from certified experts on bookkeeping, financial management, and streamlining processes. By accurately classifying transactions and maintaining balanced accounts, businesses can improve employee management and free up time for growth.
I'll be sharing with you some resources to streamline your account reconciliation and payroll workflow management:
Remember, you're always welcome to post any additional queries about reconciling payroll transactions or other QuickBooks concerns. The Community and I will be here to ensure you have all the support you need.
The response above is going to put you in the same situation: -$400 expense + $300 deposit - $100 check = -$200.
I think the solution here is to create a $0 paycheck (instead of $100) for the employee because it's the $100 paycheck that's throwing off the balance since you didn't give that to the employee. The only two transactions that are hitting your bank account are the $400 payment and the $300 deposit, correct? If so, assign your payroll wage expense account to both of those transactions, create the $0 paycheck to get the withholding correct and you should be all set.
You are right, and I will make a note in case this happens in the future. You are also correct about the $400 payment and $300 return being the only transactions to hit my bank account.
For now, since the paper check payroll item was in a previous quarter and taxes have been filed, I cannot edit or delete it. Right now, my bank account is reconciled (excluding that payroll item) and the employee has the proper withholding, but there is a discrepancy between my bank balance and the balance in Quickbooks. As a workaround, could I have her next payroll be a zero net paper check? I am assuming the check deposit should be categorized as Payroll:Wages. I think that would have the correct withholding, correct bank balance, correct money in our employee's pocket, and the QB/Bank balance would be settled, right?
"Right now, my bank account is reconciled (excluding that payroll item) and the employee has the proper withholding, but there is a discrepancy between my bank balance and the balance in Quickbooks."
Ahh, got it. Since you need to fix this in the current period and your withholding is/was correct, the fix is to make a deposit in the current period and assign Payroll: Wages to it. That reverses the effect of the $100 payroll check never given to the employee - it increases your bank account by $100 so you can clear that against the $100 payroll check the next time you reconcile your bank account and it reduces your Payroll: Wages by $100 because that's currently $100 overstated.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here