Thanks for adding more details, office-fireprote. I'm here to help you resolve this.
Let's exclude the downloaded bank transaction in QuickBooks. Doing so helps us remove the duplicate in the Balance Sheet report. Here's how:
- Go to Bookkeeping and then select Transactions.
- Select Bank transactions
- Choose the For Review tab.
- Check the box for the $4,000 bank transaction.
- Select Exclude.
Moving forward, when receiving the payments, you'll have to put the amounts in the Undeposited Funds account. Then, make a deposit. This way, they'll match the transactions on the Banking page.
You can check out this article to ensure you review downloaded bank and credit card transactions and put them in the correct accounts: Categorize and Match Bank Transactions in QuickBooks Online.
Additionally, I've added an article that'll help you review your accounts in QuickBooks to make sure they match your bank and credit card statements: Reconciliation Workflow.
Please keep us posted if you need additional assistance managing your sales and banking transactions. We want to make sure your books are accurate.
