Wrong number showing in left column

By "left column" ... are you talking about the account balance shown in the Account Bar?
The balance shown in the Account Bar can either be the Current Balance (aka Today's Balance) or the Ending Balance (i.e., the balance of all transactions entered in the account register, including future-dated transactions such as postdated checks and other payments or deposits that have been recorded but have not yet cleared the bank.)
Click the gear icon in the Account Bar title line to switch between these two balances.