Excel Dashboard VBA & Quickbooks Online API Integration

$30.00-$100.00/小时

$30.00-$100.00/小时 Upwork Technology & Programming Overseas
1005 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

Overview We are building a browser based text MMORPG. Focusing on long term island management, alliance interactions, and strategy. The game will be developed in PHP, using MySQL for data storage, and HTML/CSS/JS for the frontend. Game Concept Players start on a random island, collect resources (gold, stone, lumber), build structures, train units, form alliances, and eventually conquer or colonise other islands. The game is slow paced, requiring strategic planning over days and weeks. Initial Player Setup Starting resources: 250 Gold, 250 Stone, 250 Lumber. Starting buildings: Level 1 Main House, level 0 other buildings. Starting location: Randomly assigned island within a grid (ocean system). World Structure World: Contains 10 oceans. Ocean: Contains 100 grids (10×10). Grid: Contains up to 25 islands (5×5). Island: Player’s individual base, with buildings and troops. Buildings General Each building has levels 1–20. Upgrade costs and times increase by a factor of ~1.2 per level. Core buildings Building Prerequisite Function Main House None Controls build slots, unlocks new buildings. Gold Mine Main House Lvl 1 Produces gold. Stone Quarry Main House Lvl 1 Produces stone. Lumber Mill Main House Lvl 1 Produces lumber. Storehouse Main House Lvl 1 Stores resources, protects from plunder. Stone Wall Main House Lvl 1 Defense boost. Watch Tower Main House Lvl 1 Visibility, anti-espionage. Laboratory Main House Lvl 10 Research technologies. Harbour Main House Lvl 10 Build ships. Barracks Main House Lvl 5 Train ground units.
330.0 GBP Technology & Programming peopleperhour Overseas
3 days ago