I can help you sort this out, @crazy horse lady.
You can exclude duplicate downloaded transactions from your account. Let's first compare your list of bank transactions with your bank statement. From here, we can determine the duplicate transactions.
Here's a short video on how to remove duplicates in your account:
For step-by-step instructions, you can read through this article: Remove duplicate transactions or personal expenses from bank feeds.
Once completed, let's run your Transaction Detail by Account report. It contains a list of your transactions and total for each account in your chart of accounts.
To view report, here's how:
- Go to the Reports menu.
- Scroll down to the For my accountant section.
- Select the Transaction Detail by Account report.
You can use this to compare the payments you've received and the expenses you've spent. Also, you can match the manually added transactions with your downloaded bank transactions.
Here's how:
- Open the transaction to expand the view.
- Review the “Records found.”
- Select the link next to each record to get more details.
- Review the “Deposit to” field on the forms.
- When you’re done, select Match.
You can refer to this article for more detailed instructions: Download, match and categorise your bank transactions in QuickBooks Online.
Feel free to click the Reply button if you have other questions. The Community and I are always here to help.
