Hello,
I've got a project that I need some direction on. I have a contract in which work is delegated to 6 subcontractors. I receive monthly invoices from them and have been manually entering their hours/expenses into an Excel spreadsheet that calculates their current balances. I then use these total numbers to compile one single invoice that I then send to the contract provider.
I am looking for ways to make this process more efficient, as it takes a long time to manually enter all the data. The best idea I have come up with so far is to set up an Access database and, using SharePoint or something similar, have each subcontractor log in and enter their own data so that I can simply download the compiled report. Unfortunately, I have never used Access but am familiar with MySQL and the like.
So, I am looking for direction as far as where to start/look for templates, ideas, tutorials, etc. I would also welcome any other thoughts on the project in general.
I have downloaded a couple Contract Management templates but none seem to be very useful. I will need simply a form for subcontractors to fill out with their hours/expenses and then a report of the total hours.
Thanks for your help!
Brandon