I am doing a bank rec and quickbooks is saying that I have $6819.25 more deposited & cleared than i do and the I have $2,764.97 more cleared in withdrawls than I do.

Hello there, @info1895. I'll make sure you'll be able to finish the reconciliation process successfully in QuickBooks Online (QBO).

If your bank is connected to QBO, downloaded transactions should be matched instead of adding them manually to prevent duplicates. With this, I'd recommend checking your bank register and making sure to filter the date to see the specific transactions. 

1. Go to the Banking tab.
2. Click on Categorized and tick all the duplicate transactions.
3. Select Undo. This will move the transaction to the For review tab.
4. On the For review tab, find the transaction and click on Match.

Also, when doing a reconciliation, an accurate opening balance plays a big role, and entering it inaccurately might trigger an error.

Additionally, if you want to automatically categorize transactions, please feel free to read through this article for reference: Set up bank rules to categorize online banking transactions in QuickBooks Online.

I'll be here if you've got additional queries regarding the reconciliation process in QBO. It's always my pleasure to be of assistance. Take care.