Cash Flow database
$100-500 USD
Paid on delivery
We have a spreadsheet which we use to track and predict cash flow in a business. Basically, it works like a checkbook register, only it goes from now into the future. You start with a balance, then enter every expense, the amount and date, as far and as detailed as you can, and it shows you your (projected) balance on any given day in the future.
We'd like to change to a web-based solution, using PHP on Linux, with a MySQL database to hold the information. We'd still like to have a view of it like what the spreadsheet currently provides - one entry per line, date, item, amount, balance (red or black, depending on negative or positive) - but we want it all web-based.
We want to be able to enter items as single (pay plumber for fixing leak) or recurring costs (monthly light bill) on any interval (daily, weekly, monthly, quarterly, etc.). We want changes to a recurring event to be able to "cascade" to the subsequent ones (but not affect past ones). If we change an item's date, and when we refresh the view, it would automatically be in the right place in the list. It should order income (deposits) above outflow (expenses) that occur on the same day.
Attached is a short article written to explain how the cash flow spreadsheet (on which this is based) is typically used. A sample of the cash-flow spreadsheet is also attached (it should open in Excel or in Open Office or equivalent).
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
Target platform is Linux, running MySQL, Apache, and PHP. All development should be done in PHP (no Java, etc.), though shell scripts are OK for the installation process
**only**. NO GUI is involved here, and we are ONLY willing to look at web-based, MySQL+PHP+Apache solution, running on Linux. NOTHING else.
Project ID: #3119341