How to Migrate QuickBooks Data to TallyPrime (2024)

PDF

In a few clicks you can easily migrate data from QuickBooks to TallyPrime. After migration, you can use the specially built reports to verify accuracy of the migrated data.

Intuit has announced discontinuation of QuickBooks in India from April 2023. Current users of QuickBooks are looking for another business solution to run their daily business. As many users have reached out to Tally Solutions for seamless migration of data in QuickBooks to TallyPrime, a tool is made available to reliably migrate your company data to make it compatible with TallyPrime.

The migration tool is provided as anaccount TDL that can be linked to your TallyPrime. You just need to check eligibility of your Serial Number to use the TDL and update your license. Once your license is updated, the migration tool-specific options are included in TallyPrime.

Migration of QuickBooks data to TallyPrime is a three-step process.

  1. Download QuickBooks data.
  2. Extract the downloaded data.
  3. Import the data to a new Company in TallyPrime.

After migrating the data, verify your data by checking the migration-related reports in TallyPrime. Once the data is verified and accepted, rest assured your journey with TallyPrime is smooth. You can start recording your transactions in TallyPrime.

Prerequisites to Migrate QuickBooks Data

  • The only prerequisite to migrate QuickBooks data is that you need TallyPrime Release 1.0/TallyPrime Edit Log Release 2.1, or later.

If you already have a license, but not the required version of Tally, you need to upgrade. Refer toUpgrade to TallyPrime and TallyPrime Edit Logfor the steps.In case your TSS has expired, refer toRenew TSS for the steps to renew the subscription.
Planning to buy a new license of TallyPrime, clickhereto buy.If you want to try TallyPrime, before taking a decision to move, click to get a7-days free trial version.

What’s New

The following changes have been made in the updated QuickBooks migration solution:

  1. While importing the data from QuickBooks to TallyPrime, now you can see the Sales Orders and Purchase Orders are also getting imported seamlessly with other vouchers and masters.
  2. There were a few issues related to Deposit vouchers and Credit Note.
    This issue is resolved.
  3. When users were importing the data, duplicate master names were getting created in TallyPrime with suffix value. Now we have handled the import of identical Ledger names.
  4. While importing the data, all Units of Measures were taken as Nos. only. This issue is resolved.
    If the user wants to change the UOM, then user can change the UOM after importing the masters, and then user can import the transactions.
  1. Check eligibility of your License Serial Number and link the migration tool.
    1. Clickhere to check the eligibility of your Tally Serial Number.How to Migrate QuickBooks Data to TallyPrime (2)
    2. Enter your Tally Serial Number, and click Check Eligibility.
    3. If your license is eligible for migration of QuickBooks data, you will get a confirmation message.How to Migrate QuickBooks Data to TallyPrime (3)
      If the Tally Serial Number is not eligible to link the QuickBooks migration tool, you will get appropriate messages and act accordingly.
    • ClickSubmit.
      You will get a success message.

2. Update your TallyPrime license.

  1. Start TallyPrime.
  2. Press F1(Help) >Settings>License>Manage License >F5 (Update).
    • In theUpdate Licensescreen, enter the administrator e-mail ID andTally.NET password.
  3. Press Enterto update your license.

The migration tool gets integrated, and you will get the required options in TallyPrime to migrate the data from QuickBooks.
How to Migrate QuickBooks Data to TallyPrime (5)

Download Your QuickBooks Data

Once the migration tool is enabled in TallyPrime, you can start downloading the data from your QuickBooks account.

By default, thedownload option in TallyPrimedownloads QuickBooks data from 01-Apr-2015 till today. All the data will be downloaded together and can be imported to a single TallyPrime Company.

In case your data is big, you can apply the period filter in the TallyPrime download option to download data for a specific period. This period can be each financial year if the data is very big, or a set of years depending on the volume of data. When you are using a specific period, you can also download data prior to 01-Apr-2015.

  • Open TallyPrime.
  • Go toImport>Download Data.
  • To download complete data, or for a specific period.
    How to Migrate QuickBooks Data to TallyPrime (6)
  • Click Download to get all the data in the QuickBooks company.
    OR
    Click Configure to download the data for a specific period.
    Enter the beginning and end date for which the data is to be downloaded. Press Enter.
    How to Migrate QuickBooks Data to TallyPrime (7)
    Click Download.
  • Refer to the below table to understand the behaviour of this configuration.
    Sl. No.FromToResult
    1BlankBlankDownloads the data from 1st April 2015 to today. Even if the data is available prior to 1st April 2015, it downloads only from 1st April 2015.
    2Blank12th December 2022Downloads the data from 1st April 2015 to 12th December 2022.
    31st January 2014BlankDownloads the data from 1st January 2014 to today.
    41st January 201412th December 2022Downloads the data from 1st January 2014 to 12th December 2022.
  • If you are logging in to QuickBooks for the first time from TallyPrime, you will get the following message.
    How to Migrate QuickBooks Data to TallyPrime (8)
    • Click Connectto get the connection with Intuit and displays the login page.
  • Enter your QuickBooks User ID or E-mail and Password.
    How to Migrate QuickBooks Data to TallyPrime (9)
  • Click Sign In.
    • If you have a single company, download will start directly.
    • If you have multiple companies, it displays the company selection screen. Select the company which you need to download.
      How to Migrate QuickBooks Data to TallyPrime (10)
  • Click Next to start the data download as per the configuration. Once the download is completed you will get a success message. How to Migrate QuickBooks Data to TallyPrime (11)

Based on the browser settings, QuickBooks data gets downloaded to a folder on your computer. Time taken to download depends on the volume of data.

How to Migrate QuickBooks Data to TallyPrime (12)

Once the download is completed you will get a success message.

Extract Downloaded QuickBooks Data

  1. Open TallyPrime.
  2. Go toImport>Extract Data from Zip File.
  3. Select the zipped file from the folder the data is downloaded in the field Zip File Name.
  4. The field Path of the downloaded zip file and filename gets copied.How to Migrate QuickBooks Data to TallyPrime (13)
  5. Browse and select the Path to extract data from zip file.
    By default it selects the TallyPrime application path.How to Migrate QuickBooks Data to TallyPrime (14)
  6. Press Enter.

All the extracted files are stored in the specified folder.

Import QuickBooks Data to a New Company in TallyPrime

Since you are importing the data from QuickBooks to TallyPrime, it is recommended to use a new Company in TallyPrime. This helps in retaining the masters from QuickBooks and verifying your data for accuracy.

You can complete the data import using one of the following methods:

  • Create a new Company by importing the Company from QuickBooks, and import masters and transactions.
    This helps in transferring the data completely and validating it before recording new transactions in TallyPrime.
  • Create a new company. Import masters and transactions from the QuickBooks data as and when required using the options QuickBooks Masters and QuickBooks Transactions from Import menu.
    This helps in validating the imported data step-by-step. However, this method takes longer to complete data migration.

One-click Import

  1. Go to Import > Create Company for QB Data.
    How to Migrate QuickBooks Data to TallyPrime (15)
  • Click Yes to create the company and click No to skip this step.
    All the company information is transferred to TallyPrime.
    If you want to configure any of the Company information, refer to the topic Set Up Your Company and configure.
    You can do F11 configurations later, if needed.
    How to Migrate QuickBooks Data to TallyPrime (16)
    Configure the required features and accept the Company configuration screen. It prompts for the confirmation to import masters. Once it is confirmed, the following screen appears.
    How to Migrate QuickBooks Data to TallyPrime (17)
  • Select Yes to import masters.
    Once the masters are created, you will be prompted to import transactions.
  • Select Yesto import transactions.

How to Migrate QuickBooks Data to TallyPrime (18)
A new Company is created in TallyPrime, and masters and transactions are imported.

You can also create the Company separately and import the masters and transactions as and when required. This helps in validating the imported data in each step.

Import Data for a Specific Period

  1. Go to Import > QuickBooks Transactions.
  2. Select QB Data Folder from the folder where you have extracted the data.
  3. Enter the From and To values to mention the required period.
    On accepting, TallyPrime imports transactions based for the specified period.

To import foreign currency transactions, user has to ensure that the currency exists in QuickBooks. Alternatively, manually create the currency before importing the transactions

By default, thedownload option in TallyPrimedownloads QuickBooks data from 01-Apr-2015 till today. All the data will be downloaded together and can be imported to a single TallyPrime Company.

In case your data is big, you can apply the period filter in the TallyPrime download option to download data for a specific period. This period can be each financial year if the data is very big, or a set of years depending on the volume of data. When you are using a specific period, you can also download data prior to 01-Apr-2015.

Verify Imported Data Using Reports

Once the import process is completed, you can check and confirm whether all the data is imported to TallyPrime or not, using the reports of QuickBooks data migration.

Do not re-accept any imported transactions as there will be mismatches. If you want to make any changes in the imported transactions, create reversal transactions and then make the changes in the imported transactions.

Ledger Closing Balance

You can use the report Compare Ledger Closing Balance to validate the account details for reconciliation purposes. This report shows the differences between QuickBooks Ledger Balance (Chart of Accounts) and TallyPrime Ledger Balance.

  • Go to Import> Compare Ledger Closing Balance.
    The report Ledger Closing Balance Comparison displays the data as in QuickBooks, data in TallyPrime and the differences between these two, if any.
    How to Migrate QuickBooks Data to TallyPrime (19)
  • Under the column Difference, you can select any line and drill down to view the differences in transactions between QuickBooks and TallyPrime.How to Migrate QuickBooks Data to TallyPrime (20)

From the same report, you can view the number of vouchers in TallyPrime and QuickBooks using the buttons Vouchers in QB and Vouchers in TallyPrime.

When there is a difference in the report under Current Assets and Current Liabilities, in the drill down report you can see the actual difference under Sundry Creditors and Sundry Debtors. This is happening due to the difference of entering transactions in QuickBooks versus TallyPrime. For example, Accounts Receivable in QuickBooks and Sundry Debtors in TallyPrime as shown in the below image.

How to Migrate QuickBooks Data to TallyPrime (21)

Refer toMappings of QuickBooks Data with TallyPrime.

Stock Item Closing Balance

You can use the report Compare Stock Item Closing Balanceto validate the stock items for reconciliation purposes.

  • Go to Import> Compare Stock Item Closing Balance.
    The report of Stock Item Closing Balance Comparison stock balances as in QuickBooks, stock balance as in TallyPrime and the differences between these two, if any.
    How to Migrate QuickBooks Data to TallyPrime (22)

Closing balance comparison reports can be compared only after importing the entire data. Partial data import cannot be compared as the Trial Balance/Stock Balance repot always show the final closing balance.

Import Log

The reportImport Logshows the total number of accounts and vouchers in QuickBooks and the number of accounts and vouchers imported and not imported to TallyPrime.

  • Go to Import > Import Log.
    How to Migrate QuickBooks Data to TallyPrime (23)

To understand details of the error drill down to the not imported accounts or vouchers .

Statistics

You can check the statistics using the TallyPrime default reports.

  1. PressAlt+G(Go To) >Statistics.
    Alternatively, go toGateway of Tally>Display More Reports > Statements of Accounts > Statistics.

In this report you will be able to see all the Vouchers and Ledgers from your Company.

You may start working on TallyPrime only after the complete verification of the migrated data from QuickBooks.

  1. Go to Import > Disable QB Migration Tool
    or
    Click Disable Add-On fromhere.
  2. Enter the your Tally Serial Number and click Submit.
    How to Migrate QuickBooks Data to TallyPrime (24)
  3. Open TallyPrime and update your license.

Mappings of QuickBooks Data with TallyPrime

QuickBooks have different types of masters and voucher types. To support all types of masters and voucher types from QuickBooks, we have segregated and added the terms in the below table with equivalent terms used in TallyPrime.

Masters

#

QuickBooks

TallyPrime

1Accounts, Customers, VendorsLedgers
2BankBank Accounts
3Accounts ReceivablesSundry Debtors
4Accounts PayablesSundry Creditors
5Fixed AssetFixed Assets
6IncomeDirect Incomes
7ExpenseDirect Expenses
8Other IncomeIndirect Incomes
9Other ExpenseIndirect Expenses
10Supplies MaterialsPurchase Accounts
11Global Tax PayableDuties & Taxes
12Long Term LiabilityLoans (Liability)
13Cost of Goods SoldPurchase Accounts
14EquityCapital Account
15Other Current LiabilityCurrent Liabilities
16Other Current AssetCurrent Assets
17Other AssetDeposits (Assets)

Voucher Types

#QuickBooksTallyPrime
1Journal Entry, Inventory Qty Adjust, Inventory Starting Value, Expense, Payroll Check, Payroll Adjustment, TransferJournal
2InvoiceSales
3BillPurchase
4Vendor Credit, Supplier CreditDebit Note
5Receive Payments, Sales Receipt, DepositReceipt
6Bill Payment, Advance Payment, Pay Bills, Expense, Refund Receipt, Credit Card Expense, Credit Card Payment, Cash/Other Expense, CheckPayment
7Credit Note, Credit MemoCredit Note
8EstimateSales Order
9Purchase OrderPurchase Order

Related Topics

  • How to Migrate Company Data in TallyPrime
  • QuickBooks Migration - FAQ
  • How to Exchange Data Between Branches: Data…
  • How to Repair Company Data in TallyPrime
How to Migrate QuickBooks Data to TallyPrime (2024)
Top Articles
Latest Posts
Article information

Author: Edmund Hettinger DC

Last Updated:

Views: 5511

Rating: 4.8 / 5 (78 voted)

Reviews: 93% of readers found this page helpful

Author information

Name: Edmund Hettinger DC

Birthday: 1994-08-17

Address: 2033 Gerhold Pine, Port Jocelyn, VA 12101-5654

Phone: +8524399971620

Job: Central Manufacturing Supervisor

Hobby: Jogging, Metalworking, Tai chi, Shopping, Puzzles, Rock climbing, Crocheting

Introduction: My name is Edmund Hettinger DC, I am a adventurous, colorful, gifted, determined, precious, open, colorful person who loves writing and wants to share my knowledge and understanding with you.