Hi there, abel-horvath.
There are possible reasons wages from payroll and your bank transactions are created separately. That's why it counts double on the profit and loss report. Here are the reasons:
To fix this, I suggest to undo those payroll transactions from the Reviewed tab. Then, find a match so you're able to locate matches to your payroll transactions to avoid duplicate entries.
Here's how to undo:
1. Click Banking at the left panel. Then the Banking section.
2. Go to the Reviewed tab and find the payroll transactions.
3. Put a checkmark on payroll transactions and click the Undo link located at the right corner.
After that, you can now go to the For Review tab. Then select each payroll transaction and choose to Find Match. Please follow these steps:
1. From For Review tab, select the payroll transaction.
2. Click it to see the full details and click the Find Match button.
3. In the Match transactions window, choose the specific date to show all transactions that match with the payroll transactions.
4. Hit the Save button.
You can refer to this article for more information about reviewing your downloaded bank transactions: Match and categorize bank transactions in QuickBooks Online. This helps you to avoid duplicate entries in you QuickBooks account.
To guide you in reconciling your accounts properly, you can check out this link: Reconcile an account in QuickBooks Online. This article also provides on how you can edit completed reconciliations.
Please know that you're always welcome to post if you have any other concerns. Wishing you and your business continued success.
the issue is that the amounts don't match. The Payroll expenses are a few % different between what QuickBooks says it will be taken off the account and what the bank actually removed from the account. So the two amounts don't match at all, that's why the matching is not working.
Thanks for your answer but this won't work.
The amount that Qucikbooks is suggesting in the Payroll/Wages page is not the same that is being lifted from the bank. There is a few % difference. So either the bank is taking less what they should or the QuickBooks is showing more, and taking less but I cannot match the amounts, because they are not identical.
Let me help you with the bank transactions not matching in your account, abel-horvath.
If you manually add the transactions in QuickBooks Online (QBO), we can exclude the downloaded bank data on your Banking page. This way, they will not be added to your Profit and Loss report as a duplicate transaction.
For more details about this one, check out this article: Exclude expenses from downloaded bank transactions.
Then, clear the transactions that were created in QBO.
I've got a link here that provides you with articles about managing your bank transactions: https://quickbooks.intuit.com/learn-support/en-us/banking/07?product=QuickBooks%20Online.
Feel free to go back to this thread if you need a hand with reconciling your accounts or any QBO related. I'm always here to help. Take care always.
I would like to have the amount from the bank account showing in the profit and loss statement since that's the actual amount. Could you please let me know how I can remove the forecast from the Payroll, that's automatically generated and added to the Profit and Loss Account?
We'll help you match the amounts of our direct deposit transactions. However, we'll need help from Support since only them have the tools to correct the amounts.
You can reach them using these steps:
As for removing the forecast and showing the actual amounts on P&L, you won't need this since the amounts will be corrected. So eventually, the amounts will match. And, please know that the bank transactions will only show on the Balance Sheet report.
Please let me know if there's anything you need at this point. We'll be here to continue helping you.
I want to make sure you'll be guided to the right support. I'd like to check this for you and get it taken care of myself.
However, as much as I would like to get this handled directly, payroll and bank transactions requires pulling up your account information, which I am unable to do in this public forum.
I know you've already called in. Nonetheless, I still suggest getting in touch with our QuickBooks Support to have the amount corrected. All account-related concerns need to be directed to our phone support for security purposes.
You'll first have to review our support hours to ensure they can assist you on time. Here's how:
Also, you might want to go through the resources below. This will provide you more information on how to review multiple and excluding duplicate transactions in QuickBooks Online as well as handling banking rules:
Feel free to reach out to us again if you have other concerns. We're here to help you.