We need to automate a simple cash flow spreadsheet we are currently using. We want to have an admin panel and an input interface. we are a start-up trucking company with 2 trucks and numerous customer so we will like to create an application/ database to create
* daily begining balance
* We might have increased cash via operations - we made money on services
* We used cash or new assets and expenses.
* We might have raised cash throughout the year.
Using the above four pieces of information we can calculate a fifth value - the cash we have at the of the day. These building blocks of a cash flow statement are typically labeled as follows:
> Cash and Cash Equivalents (Beginning)
> + Cash from Operations
> - Cash Flows from Investing Activities
> + Cash Flows from Financing Activities
> = Cash and Cash Equivalents (Ending)
We will like daily inputs to roll over to weekly, monthly, yearly buckets... I will attach a spreadsheet to show our current design.