Closed

Invoicing Matching Script

Background:

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.

Systems:

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])

Problem:

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)

Match (Y/N)

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.

TECH - Ideally done in JavaScript

In your bid, please describe how you'd meet the requirements.

Skills: Amazon Web Services, Aws Lambda, Javascript, Scripting

See more: script background music, script background audio, horoscope matching script, kundli matching script, php horoscope matching script, php script background rotation, php poll script background color, iphone app keeping car details, server 2003 script background, script login router give interface details, invoicing php script, free kundli matching script, run mysql script background, mysql run script background, countdown banner script background image, product matching script, action script background effects

About the Employer:
( 57 reviews ) Baltimore, United States

Project ID: #15869980

36 freelancers are bidding on average $1317 for this job

ByteAnt

Hello, We are a team of .NET stack developers experienced with AWS, API`s of different complexity and Javascript. Relevant Skills and Experience we have built our own inner time and task tracking system Proposed Mile More

$1500 USD in 20 days
(15 Reviews)
7.3
arcdevsol

Hi there, I can write this in Node (Javascript). It will first make request to Bill and clicktime api to get the data (I've already gone through the api endpoints). Relevant Skills and Experience I have done number of More

$1500 USD in 25 days
(61 Reviews)
6.7
helmot

Hello. I just finished this project: [url removed, login to view] Your project is very similar. I can start it asap. Thanks, Vahid Relevant Skills and Experience - AWS - Ansible for AWS automatio More

$1250 USD in 20 days
(36 Reviews)
6.7
sunsoftpro

may you discuss?

$1429 USD in 22 days
(100 Reviews)
6.9
hawkscodeaus

I have 7+ years in Amazon web services - javascript developers with very good experience. Relevant Skills and Experience I am good in Amazon Web Services, Aws Lambda, Javascript, Scripting Proposed Milestones $1000 U More

$1000 USD in 15 days
(39 Reviews)
6.6
tudiptechnology

Hi, I have gone through the project description and this is definitely in our wheelhouse and we would love to help you out on this. Relevant Skills and Experience Few links for your reference: [url removed, login to view] [url removed, login to view] More

$1500 USD in 35 days
(12 Reviews)
6.8
jatindhoot

Hello Sir, This is not a canned response and I have gone through the requirements thoroughly before placing my bid. Regarding how to be done, I think it can not be done alone in Javascript. Relevant Skills and Exper More

$1323 USD in 8 days
(35 Reviews)
6.6
steven6

Hi, I have done this sort of automation before and can deliever the verification process implemented within 3 days. Please send me a message if you're interested. Relevant Skills and Experience # Proposed Milestones More

$2000 USD in 3 days
(11 Reviews)
6.4
mingxiao2008

Hello, I read your proposal, and I have experienced developing 2 national-wide commercial site using aws. So I think I can do this in high quality. Relevant Skills and Experience Amazon Web Services, Aws Lambda, Javas More

$1000 USD in 20 days
(20 Reviews)
6.3
sphinxsolution

Hi, With a team of 110+ in-house developers we are keen to help you out with all your app development. Share your requirements in details and let us have a discussion. Relevant Skills and Experience We have developed More

$1500 USD in 30 days
(3 Reviews)
6.2
linuxwarm

I can help you with the same. I have been dealing with software development and infrastructure management since 14+ years. Can we talk on chat? Relevant Skills and Experience PHP MySQL JAVAScript Ajax CSS HTML5 IOS An More

$1250 USD in 20 days
(35 Reviews)
5.5
xiqian88

Dear,Sir How are you? I have read your project details and am very interested in your project. Relevant Skills and Experience I have extension experienced in Amazon Web Services, Aws Lambda, Javascript, Scripting. Esp More

$800 USD in 20 days
(12 Reviews)
5.2
WebExpertsx

We read your requirement about [url removed, login to view] and we want you to know that we have a good past experience in PHP,wordprss,laravel ,angular.js, javascript, Bootstrap, SEO, node js, html and css . Relevant Skills an More

$805 USD in 5 days
(2 Reviews)
5.3
shomuk

Hi, I understand that you want a platform where you can generate reports as csv file which will contain details from [url removed, login to view] and clicktime.com. We will develop this in php and integrate the APIs. Relevant Skills and More

$2705 USD in 28 days
(11 Reviews)
5.3
pointlogic

Hello..I have read your complete project requirement and i have good working knowledge on Javascript and i can complete your project well. Relevant Skills and Experience I have in-depth knowledge of php, mysql, javasc More

$794 USD in 20 days
(17 Reviews)
6.1
$1323 USD in 20 days
(5 Reviews)
4.7
superman1987417

Hi, Dear Client. I am expert Web developer with high JavaScript & API integration Skills. I can do it quickly and perfectly. Regards. Relevant Skills and Experience JavaScript, API integration Proposed Milestones $10 More

$1000 USD in 10 days
(15 Reviews)
4.8
codeblockinfo

Overall 10+ yrs of exp in Java/J2EE and Javascript(NodeJS). 2+ year of exp on AWS tech ( lambda, RDS, Dynamo, API gateway, cloud watch, SNS, SQS, SES, cloud search,) along with serverless framework. Relevant Skills an More

$1388 USD in 10 days
(26 Reviews)
4.8
caciocode

Hi, If C#, Java are any option as a desktop app or a web based admin system then I am available for that. Relevant Skills and Experience Java C# JavaScript Stay tuned, I'm still working on this proposal.

$1250 USD in 20 days
(39 Reviews)
4.7
VangHaleena17

Hello Invoicing Matching Script Relevant Skills and Experience Amazon Web Services, Aws Lambda, Javascript, Scripting Proposed Milestones $1250 USD - when i did it i have some quesitons for your project now thx

$1250 USD in 20 days
(12 Reviews)
4.4