I am looking for someone to work with me to develop a mobile app for internal use in my contracting company. At this point, I would just like to have mobile time sheets and material sheets for my staff, that would sync with Quickbooks (desktop or online) to exchange the data. The staff have iPad minis/iPhones and I would need desktop access for my computer.
The app would have to pull the customer / job database from Quickbooks (daily or on demand) and create a drop town menu in the app (both time sheets and material sheets) for the staff to select. Then the data entered would be synced back to Quickbooks.
Right now we use TSheets (www.tsheets.com) for the time sheets side and it does everything above plus scheduling. The Quickbooks integration of the field entered data is not very refined (it does a lot but not effectively in any one area) though and creates lots of problems on invoicing. No material sheets are available from Tsheets.
We use a Numbers cloud based spreadsheet for the material sheets (I have attached a sample) and while it works fairly well, it does not sync with Quickbooks and therefor the customer / job name is really whatever my staff chooses to type in rather than choosing only from available, existing job names (pulled from QB).
I would at least need desktop back end access to build and maintain an Inventory list (as in the attached spreadsheet) but it would be even better if we could pull that from QB too and create a dropdown. There would have to be an approval process before the sync too.
In an ideal world, I would dispatch a job from the schedule (customer for the job is pulled from QB customer list) and send an invite. The staff member could click on the customer in the invite (that shows up in his schedule) to create his timesheet and a material sheet. The charges (time and material) would be defaulted to the customer I set in the invite.
The whole point is to get the time AND material imported into QB under the same customer/job name. What happens now is the time through TSheets is generally right (its included in the invite) but the material is assigned randomly to a name somewhat close to what it really is. Makes for a mess of interpretations at invoicing.
The idea is to make this simple, simple, simple. New staff has to be able to pick it up immediately and work with it.
What other information would you need to start something like this?