In our organization our vendors work and track daily hours in our timekeeping system ([url removed, login to view]). At the end of each month we have them also send an invoice (to [url removed, login to view]). As part of our reconciliation process we manually check the time in the system and ensure that it matches the value from the invoicing system. We would like to automate this process.
Invoice tracking system – [url removed, login to view] (api: [url removed, login to view])
Time Keeping System- [url removed, login to view] (api: [url removed, login to view])
Given a command line input of:
File that contains a mapping from unique ID’s in the invoicing system to unique ID’s in the timekeeping system
MM/YYYY (the month to verify)
We’d like an output CVS with the following cols:
VendorName (from [url removed, login to view] API)
Bill.com-ID (same as input file)
Clicktime-ID (same as input file)
MM/YYYY (per input)
[url removed, login to view] Value
Clicktime Value (hours * rate)
The output CSV will contain a record for each vendor with an invoice in that input month.
Additional requirements and details:
1. The time keeping system needs to wrap external API’s such that we can swap out either
3. Script should be able to be deployed to AWS environment (Possibly a Lambda)
4. Script output should be able to integrate with slack the results of that report to a particular channel
5. NICE TO HAVE - not required, Slack integration, so that this can be initiated from Slack and the response comes to slack.
In your bid, please describe how you'd meet the requirements.
35 freelancers are bidding on average $1319 for this job