I'd be delighted to help you match downloaded bank transactions to your payroll expenses so there won't be duplicate entries, TQ-2023.
There are a few factors why duplicate payroll expenses are showing on your Profit and Loss report. The following are some of the most frequent causes:
- Another check was created within the same pay period.
- The system added them by mistake (due to incorrect payroll mapping).
- Duplicate entries are added when bank transactions aren't matched with what's recorded in QuickBooks Online.
Thus, to help you get around this concern, you can undo the money withdrawn from the bank and match it to the payroll expenses in QuickBooks. To do that:
- Go to Bookkeeping, choose Transactions, then Bank Transactions.
- Click the bank where payroll expenses are downloaded.
- Proceed to the Categorized tab.
- Find the transaction you want to undo.
- Select the blue transaction link in the Added or Matched column to see the matched transaction.
- Hit Undo from the Action column.
The original downloaded transaction should now be added back to the For Review tab. Then, you can manually categorize and match these transactions to accurately record them to the correct account.
Moreover, I'm sharing this guide to help you review and ensure your books are balanced: Reconcile an account in QuickBooks Online.
Keep us posted in the comments below if you require additional assistance managing your payroll transactions. We'll be here to back you up always. Have a good one!
