Data Migration from Quickbooks to a Cloud ERP Software

Move from Quickbooks Accounting Software to an Cloud ERP Software


How to do Data migration from QuickBooks Online to ACTouch ERP?

Many businesses will migrate from QuickBooks as they grow out of the Accounting software stage. Because, Quickbooks Online is not designed for complex needs of Manufacturing companies. 

Few reasons based on our customer feedback’s are as below.

  • Many prospects / customers asks us a question – How to migrate data from QuickBooks  Online as its not taking care as our business grows? 
  • Quickbooks is designed for SOHO or mainly small company to meet their Accounting and compliances needs.
  • QuickBooks Software is not able to help large business with Production (Manufacturing), Planning, Materials Management, Procurement Management etc. Due to this reason many companies either they use excel or manage them manually.
  • To compensate Inventory management, Procurement etc, few Business buys local software and it becomes too many Systems without interconnection, Investing More Time & Resources to manage.
  • May face problem to manage as the number of users increases and the work load increases thats demands workflow, approvals etc.
  • Its not taking the complex Indian business scenarios that needs many layers of sophistication. 

ERP Implementation has many challenges and it requires to follow a discipline in the implementation approach. You have to manage multiple facets of the business departments, identify the stakeholders and others.

One of the major challenge that’s faced in ERP implementation (based on our experience) is preparation of Implementation Plan and activities.

Let us address this in one by one.

  1. Decide the objective of the Migration – Define what you want to achieve as part of migration from QuickBooks to ACTouch.com? Some of the reasons could be as below.
    1. Multiple Business department integration that’s lacking in your old software.
    2. You want to implement new modules for your business like Manufacturing, Planning modules, Subcontracting, Material Management etc. 
    3. Controlling the behaviour of the Products and its part details.
    4. Missing ability to customize.
    5. Better MIS Reports.
    6. Better visibility of process and approvals.
    7. Define a Workflow automation to avoid the decision making process?
    8. Find the process that takes more time to customer delivery
    9. Reduce the manual errors and clerical mistakes.
    10. Make sure customer is happy and on time delivery improves.

 

2.  Who are the stakeholders for this project? These are those people who are impacted directly or indirectly, decides the fate of the project. 

More than 50% of ERP projects get delayed or failed due to not addressing these stakeholders concerns.

    1. Management team and department heads.
    2. Production department and engineers
    3. Sales and Marketing departments
    4. IT department
    5. Purchase and procurement team
    6. Stores and Inventory controls
    7. Finance
    8. Sales people
    9. External entities like Distributors and Re-sellers.

Identify the above teams and work with them. Find the reasons why they should support your Migration from QuickBooks to ACTouch.com

3.  Define the project plans and milestones.

    1. Define the activities and dependencies. (For example before testing begins the data should have been migrated).
    2. It is also important to define the Milestones and what should be achieved by that time frame? For example
      1. Current System Study completion
      2. Data migration
      3. Customization of Changes of process etc.
      4. User Acceptance Testing (UAT)
      5. Plan for Go live and decide on the Cut-off date.
      6. Live date and what departments are moved to new system.
    3. Who is responsible and when it’s expected to complete?
    4. Who owns the data migration
    5. What portion of the earlier ERP would be migrated?
    6. Is the new ERP implemented at One go or stage wise? If its stage-wise then what are the modules should go first and how the interdependence are addressed? In case of ACTouch.com, many modules are integrated and one activity has an impact across other modules. So it is an important decision process.

4. Post Go-live with ACTouch ERP software, how to do the hand holding of your teams and how their issues are addressed?

 

Please download the Project Plan Template that we use for ACTouch.com ERP Implementation. This document would be extended after our discussion with Project Team.

How to do ERP Data migration from QuickBooks to ACTouch?

ACTouch.com is completely integrated ERP software for medium to large Manufacturing companies and it has many modules that are tightly integrated. We follow a detailed approach for the data migration, so that we don’t miss any.Steps to migrate from freshbooks has been mentioned below

  1. First define the list of master data that needs to be migrated. There are 2 sets of data. Some are mandatory and some are optional, but these data preparation could help you with a Proper ERP implementation and its reports.

Mandatory lists

    1. Vendor / Supplier master. Download the format here.
    2. Customer master. Download the format here.
    3. Product masters / Parts Master – It contains the list of Raw Materials, Semi Finished Goods, Finished Goods, Expenses Items etc. Download the format here.

Optional Master data lists

    1. Product Groups and Subgroups – You can define up to 3 levels of Sub groups for a Product Group.
    2. Location masters – If you are identifying the Products with specific work locations, then you can define them.
    3. Chart of Accounts – ACTouch.com would be defined with a standard Chart of Accounts and its financial categories. In case you want to define your own Chart of Accounts then you can do so.
    4. Supplier and Product Price lists
    5. Customer and Product price lists
  1. Transactional data migration. These are the ones that helps to continue with QuickBooks transactions in ACTouch.com from cut-off date.
    1. Open Invoices – Those invoices where the material is sold, but yet to receive the money from customers.
    2. Open Bills – Open bills for which you have to do the payments.
    3. Opening Stocks – These are the opening stocks of the available inventory and we need the unit costs.
    4. Opening Account Balances – We take Trial Balance report from QuickBooks and enter those data into a Journal Entry.
    5. Open Purchase Orders – download the format
    6. Open Sales Orders – download the format
  1. To simplify the process, we have defined the .CSV formats for you to capture the data and you can upload them into ACTouch.com.
    1. Simple to use and no expertise required.
    2. Verify the data in excel form.
    3. Download these data from QuickBooks and upload into ACTouch.com

Based on our implementation process, the preparation of right Master and old transaction data takes time.

Migrate to 100% Manufacturing ERP Now





Want to know more about ERP Features and our Services?

Are you looking for Best ERP Software for your Factory?

Let's talk now for a new Improved, Better ERP.

Let's talk about Your "ERP" requirements. Speak to us now.

Book a ERP Demo, Now FREE!!!