I need someone that can write an application that I can run on my Mac (Apple Compter). This will be for my own personal use for my company and will generate a report based on a csv upload that I upload into the program.
It's really just simple mathematical equations that are calculated from some predetermined values that are correlated against values that are input using a csv that I'll import into the program.
I have a very thorough document that explains exactly what I'm looking for and what I'm needing attached to this posting.
I have a property management company that generates a total revenue number each month for each property. Out of that number there are other things subtracted from it, such as taxes, cleaning fees, management fees, service charges, etc.
I need a program that will take the csv import that has all our reservations for each property, and total everything out for each property and then give me some resulting data so I can figure out the following:
How much to pay to the property owners
How much to pay to all the different taxing authorities
How much to pay for the insurances I have to carry for each
How much to pay my company for each property each month
I have an existing spreadsheet that I use for all of this, but I am manually copying and pasting, and tabulating, and it's a pain in the butt and very time consuming.
I have no need for fancy user interface or clever design, I just need something that works well and reliably.
The output could be as simple as a csv that looks exactly like my existing spreadsheet, which would be provided to the person that gets the job.
Additionally, it would need to be able to spit out a monthly report for each property that has a breakdown of the reservations, total revenue minus costs and what we are paying the owner.
I could be wrong, but I think this could be something simple for someone that knows how to do this.
I'll be importing pre-formatted csv's that would contain all the data, I just need a program that knows what to do with that data automatically and gives me the reports I want.
I must be able to communicate via skype and phone, in addition to email with this person as what I need is very specific and we'll have to chat about how to make it happen during development.
As a side note, I have no idea how much someone would charge me for this, so I just put a number of $15-25/hr