Automate the Entering of Commissions from Broker/Dealer Software into QuickBooks

Project Description

We need an easy and accurate way to get commissions from the software program that our Broker/Dealer provides (M&O), and then organized into QuickBooks (desktop version) broken down into a few categories and classified by sales representatives.

Below is an outline of the current process.

Commission Detail Process

1. Get Commission Statements from MyView Portal (M&O software) through Edocs' Single Sign On (software through our Broker/Dealer)
2. Download and save to Excel
3. Create Pivot Tables for QuickBooks breakdown-->Put into 3 groups
4. Consolidate commissions onto a single Excel sheet for payroll purposes
5. Enter data from #3 into QuickBooks

You can access two screencasts that walk thru each step of the process: 

https://www.dropbox.com/sh/c9kuztxm95621oo/AAA0KjO_gSFHXJfkLUGxUtKFa?dl=0

Password: M&O2QBe@sy 

Note: In accessing the above information, as a registered provider of services, you are bound by Experfy's Terms, Clause 6 on Confidentiality, https://www.experfy.com/terms

Automation Process

1. There is no API available to extract all data from the Broker/Dealer software.  Therefore, the data will be downloaded manually and saved in Excel format.
2. We will run an algorithm that you will develop.
3. The alogrithm will create an output in QuickBook supported format.
4. We will manually import the QuickBooks supported file into Quickbooks for payroll purposes.

We are open to moving to the online version of QuickBooks, if that helps automate #4.

In your proposal, please provide your detailed approach and what kind of tool you intend to build to help us automate some or all of this process. Please also provide a ballpark estimate of the number of hours this project may take.