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.
Kruze Consulting is a leading accounting firm working with seed and venture funded Delaware C-Corps. Funded startups choose Kruze Consulting’s team of CPAs, bookkeepers, CFOs, former IRS tax auditors, and venture experts. In addition to running the books, Kruze does tax, finance, and HR. Contact Kruze today!