You want the Cash Balance to be dynamic. Hard plugging something like that will get you in a lot of trouble as you start making changes.
The Cash Flow Statement will drive the Cash Balance on the Balance Sheet. Let the changes in Working Capital on the Balance Sheet flow into the Cash Flow Statement. Then use the Cash at the End of Period (last line of the Cash Flow Statement) to flow into Cash on Balance Sheet.
Want valuable startup information delivered straight to your inbox?