Simple database design for tracking business expenses and income with report printing
- or -
Post a project like this3798
$100
- Posted:
- Proposals: 6
- Remote
- #360793
- Awarded
PHP | MYSQL | Magento | Joomla | Wordpress | Responsive | Jquery | HTML | CSS | Javascript
Kanpur
Advanced Financial Modeler, Business Plan Writer, Investor Pitch Deck, Xero Setup and Migration expert,
Indore
461086108719287946429894552249552614
Description
Experience Level: Intermediate
Estimated project duration: 1 - 2 weeks
What I am looking for is a database that is designed with an interface that looks similar to a web browser. It would have a drop down to select if I am inputting mileage, expenses, or sales. There would be a taxable sale check box only visable if sale dropdown is selected. Under mileage there would be a box to enter date, miles driven, and reason text box (100 characters). Under sales there would be date, invoice number, amount, and the taxable sale box. Under expenses there would be date, paid to, description (200 characters), boxes to check if it is shipping fee, paypal fee, or postage.
For the reports it would need to print, I would want it to print each type of drop down seperately (Sales, Expenses, and Mileage). I would be printing monthly reports, so I would need to be able to select the date range when printing the reports. On the report it would need to display all information input in the record in a table format with a heading at the top of the pages showing what report and what page it is as well as date range.
I would also like the database to purge the information after 7 years automatically so it doesn't become too large.
For the reports it would need to print, I would want it to print each type of drop down seperately (Sales, Expenses, and Mileage). I would be printing monthly reports, so I would need to be able to select the date range when printing the reports. On the report it would need to display all information input in the record in a table format with a heading at the top of the pages showing what report and what page it is as well as date range.
I would also like the database to purge the information after 7 years automatically so it doesn't become too large.
Brian H.
100% (3)Projects Completed
5
Freelancers worked with
5
Projects awarded
100%
Last project
27 Nov 2017
United States
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies