There are a couple of different ways to manipulate the balance I have recommended to my clients in the past since getting the initial reconciliation to work correctly can be a little tricky.

You should try making entries that post to the same account as the Cash Account ID that you are using to see if it make your issue any better.  This is the simplest way you can make transaction entered directly through the GL appear in the CM reconciliation.

If I recall correctly the GL amount displayed in the reconciliation is just a calculated value based on cash management transactions.  So if you entered something against the GL account outside of CM,AP,AR your actual GL balance and calculated GL balance may different.

You may not have entered all the transactions for you beginning balance in the correct order and using the above manipulations will just ending up pushing the value around but never resolving it.  If all fails start again by clearing all transactions and creating a $0 ending balance statement and then setting up a new beginning balance.  

You should make a test db any try some of this stuff out in the test database to see the effect with out creating additional entries to you ledger.

Hope that helps.

-Adrian-

We have a really good KB article that talks about adjusting the bank balance.  KB Article: 18352 How to adjust balances in Cash Management

You must be logged into the KB to access this link for the article noted above:

support.na.sage.com/.../viewdocument.do