How can i make my closing balance to opening balance automatically next day?

We have 60 bank accounts and every day we make payments and receive cash from parties. I am making our bank position as per cheque issued to parties by subtracting from current balance and adding amount received to know our actual bank position. For this every next day I have to copy closing balance and make it opening. Is there any way to automate this process that my closing balance will convert to opening? Please help me in this.

Please attach your workbook to this thread.