Subject: Rollover Bug fix

Description:
1. update closing balance was not working
2. need to connection.commit