"in quickbooks" differes from "bank balance", export excel and sum values I get "bank balance" number

Thanks for the screenshot, rich77.

The QuickBooks balance is the total balance of all bank transactions you've added or matched to QuickBooks. On the other hand, bank balance is your bank's actual balance from the last bank feed update. 

You can check the lists of transactions on your bank statement with what's in QuickBooks to see if there are any changes made from the previous reconciliation or any transaction that shows in QuickBooks but not in the bank. Here's how:

1. From the Gear icon, select Reconcile.
2. Choose the affected bank account, and you'll see the red message saying Your account isn't ready to reconcile yet.
3. Click the We can help you fix it, then select the View link in the History column.

From there, you'll see when the transaction was deleted, changed, and who did it. For deleted transactions, you'll need to manually re-enter it and do a mini-reconciliation to fix it. Here's how: 

1. Go to Accounting on the left panel. 
2. Within the Chart of Accounts tab, click the bank account.
3. Click Account history under the Action column.
4. Choose transaction, click the field until you see R. 
5. Then, Save.

I've also added these references as your guide in reconciling the transactions:

• Fix issues at the end of a reconciliation in QuickBooks Online
• Fix issues for accounts you've reconciled in the past in QuickBooks Online

I'd like to know how you get on after trying the steps, as I want to ensure this is resolved for you. Feel free to reply to this post, and I'll get back to you.