When doing bank reconciliations, how do you calculate unadjusted cash balances in the general ledger? Is there a 'formula" to be used here

For most problems, the company's cash balance is given. Since the unadjusted balance is just the ending balance from the cash account (or really, the check register), it's just all the ads and subtracts that have been going on in that account all month. Not what I'd call a "formula." The problem could give you a beginning balance, and then all the deposits and checks written for the month, and it would be easy to get the ending balance from there.

Or you might just be confused over the fact that "unadjusted cash balance" for a bank rec is the same thing as your ending balance in the ledger cash account.

I'm still not 100% sure where to start, so I am attaching an excel file, which gives all the information I have . I am hoping to get some pointers on where to begin.

My opening book balance should be: 1075, and 2750 should be the cash balance, but I can't quite figure out how to get there.