Excel Dashboard VBA & Quickbooks Online API Integration

$30.00-$100.00/小时

$30.00-$100.00/小时 Upwork Technology & Programming Overseas
952 days ago

Description

I am needing a skilled individual to assist and implement an API automation between an Excel based VBA macro and QuickBooks Online (QBO). I run a small business that does custom carpentry and have developed an in house, excel based, work management system (WMS). There is nothing particularly complex with my system as it is just a custom user form tied to a VBA macro that places user input information within a spreadsheet, and copies/pastes/renames a template folder for project files. I also use QBO for my accounting and payroll tracking. I am currently having to re-enter this information within QBO to create the project. I would like to leverage the API capabilities of QBO to automate the project creation using the backend data already entered in the Excel WMS. I intend this scope of work to be a ~30 minute digital meeting to review the workflow & needs. I then see the individual working (~1-3 hours?) to complete this integration & testing offline, followed with another ~30 minute meeting to review and wrap up. I could see this scope moderately expanding as needed to further improve the WMS based on the individual's recommendations. See the attached PNG file that shows some screenshots that should provide context. Thanks in advance, and let me know if you have any questions.

关注公众号,不定期副业成功案例分享
Follow WeChat

Success story sharing

Want to stay one step ahead of the latest teleworks?

Subscribe Now

Similar Teleworks

Good day, This is a challenge for all the programmers out there, who can help resolve this issue, and if this issue is resolved, then this is going to be a celebration time :). We have been trying to resolve this issue but so far no luck, so thought to post here with this hope and wish that someone can help resolve this issue. Please let me know, how long it will take and how much you will cost to resolve this issue. See below and let me know if any of you can resolve this issue: ------- See this code: https://github.com/SoftEtherVPN/SoftEtherVPN_Stable We need to compile or convert the softether client pack send/receive binary protocol and encryption to swift ios project like their client do for windows and linux. Softether actually not providing the implementation for ios. We have replicated the TLS connection but not able to make the handshake binary protocol and softether server terminates the TLS connection with following logs: On the TCP Listener (Port 443), a Client (IP address 39.60.124.38, Host name "39.60.124.38", Port number 56504) has connected. For the client (IP address: 39.60.124.38, host name: "39.60.124.38", port number: 56504), connection "CID-4992" has been created. SSL communication for connection "CID-4992" has been started. The encryption algorithm name is "TLS_AES_256_GCM_SHA384". Connection "CID-4992" terminated by the cause "A client which is non-SoftEther VPN software has connected to the port." (code 5). Connection "CID-4992" has been terminated. The connection with the client (IP address 39.60.124.38, Port number 56504) has been disconnected. ------- Basically, you need to convert the C files logic of softether client into swift files that will be implemented in iOS.
500.0 USD Technology & Programming peopleperhour Overseas
2 days ago