My bank amount and posted amount is out by a huge amount.Also noticed if i sort chart of accounts from old to new it gives me different result apposed to new to old

The QuickBooks Balance reflects all transactions posted to your financial books, while the Bank Balance is the actual real-world cleared amount pulled from your bank feed. Discrepancies between the two usually stem from unaccepted transactions, incorrect register sorting, or duplicate entries.

To resolve this, go to your Chart of Accounts, open the account register, and click the Date column header until the arrow points down or Newest to Oldest. This fixes the running math calculation and displays the current QuickBooks Balance on the top row.

Next, accept or match all transactions in the bank feed's For Review tab. Finally, sort your register by the Payment or Deposit columns to quickly locate and delete any duplicate entries caused by accidentally adding instead of matching transactions.

If you have other questions about QuickBooks, please don't hesitate to click the Reply button.