Transcript Microsoft Word - User manual - Sales Voucher Authorization.doc

Migration from Quick books to
Tally.
EE Software Technologies Pvt. Ltd.
#447/A, 17th G Main, 6th Block
Koramangala, Bangalore 560095
Tel: +91 80 41131825.
Email: [email protected]
Next
EE Software Technologies Pvt Ltd. All rights reserved.
Tally, Tally 9, Tally9, Tally.ERP, Tally.ERP 9, Shoper, Shoper 9, Shoper POS, Shoper HO, Shoper 9 POS, Shoper 9 HO,
TallyDeveloper, Tally Developer, Tally. Developer 9, Tally.NET, Tally Development Environment, Tally Extender, Tally
Integrator, Tally Integrated Network, Tally Service Partner, TallyAcademy & Power of Simplicity are either registered
trademarks or trademarks of Tally Solutions Pvt. Ltd. in India and/or other countries. All other trademarks are properties of
their respective owners.
Prev
Next
Migration from Quick books to Tally.
TALLY ERP.9
Tally.ERP9 is the one of the leading accounting package provider from India. Tally products are transforming
businesses across industry in over 94 countries. Today, more than 2 million business users benefit from its
product philosophy... the 'Power of Simplicity'.
QUICK BOOKS
QuickBooks is an accounting software package developed and marketed by Intuit – USA, provides both
Web (online)and Desktop based accounting applications for small and medium businesses
The growing popularity and simple to use Tally software has been conquering various geographies and
is attracting wide segments of business users from migrating to Tally from their already existing
systems. One such segment is QuickBooks , where Users are migrating to Tally in huge numbers. We will
discuss in detailed on how to export data from QuickBooks and import the same in to Tally in the next few
slides
Prev
Next
Step 1
Export Accounting masters from Quick Books
From the Menu bar, click on Reports, then on List and select Account Listing as shown from the below screen.
The background screen in the below screen will be presented to the User.
Prev
Next
Step 1
Export Accounting masters from Quick Books-Contd.
Click on Excel and select Create New Worksheet as in below screen
Prev
Next
Step 1
Export Accounting masters from Quick Books-Contd.
An excel sheet will be opened as in below screen with the relevant data, except Customer and suppliers list
Prev
Next
Step 1
Export Accounting masters from Quick Books-Contd.
Then exported master excel sheet format should be made to below format (Note: Master other than Customer and
Suppliers)
Prev
Next
Step 2
Export Customer’s & Supplier’s List
From the Menu bar, click on Reports, then on Customers & Receivables and select Customer contact List as shown
from the below screen. The background screen in the below screen will be presented to the User.
Prev
Next
Step 2
Export Customer’s & Supplier’s List
From the Menu bar, click on Reports, then on Vendors & Payables and select Vendor contact List as shown
from the below screen. The background screen in the below screen will be presented to the User.
Prev
Next
Step 2
Export Customer’s & Supplier’s List - Contd
The exported Customer or Supplier master should be formatted as displayed in below screen
Prev
NB: Please change the grouping accordingly for customer and suppliers
Next
Step 2
Export Transactions
From the Menu bar, click on Reports, then on Custom Reports and select Transaction Details as shown from the
below screen, below screen will be presented to the User to select the period from and To date .
Prev
Next
Step 2
Export Transactions - Contd
After selecting the period using From and To date, User can choose what are the columns needed to be exported
to excel in the highlighted area and click on Filters Tab
Prev
Next
Step 2
Export Transactions - Contd
Select “Transaction Type” from Choose Filter Tab and then select “Transaction Type” from “TransactionType”
drop down as shown in the below screen and click on OK button
Prev
Next
Step 2
Export Transactions - Contd
From the Transaction details, click on Excel and select option Create New worksheet and click on Advanced
Button as shown in below screen.
Prev
Next
Step 2
Export Transactions - Contd
From the Advanced Excel options screen, ensure all the below selected options are ticked and un-ticked accordingly
as shown in below screen.
Prev
Next
Step 2
Export Transactions - Contd
Data will be exported to excel in the below format and should look similar, which the User can save it to desired
location.
NB: All the transaction excel sheet should have the following columns and must follow the structure. Its
compulsory to give a space between each columns.
Columns : Trans#, Type, Date, Num, Name, Memo, Account, Class, Clr, Split, Debit, Credit, Balance
Prev
Next
Step 2
Configure Tally to Import data.
Open Tally and from Gateway of Tally, press F12 button and navigate to Product & Features. Press F4(Manage
Local TDL) and Enable License validation tcp file by specifying the path of this file as shown below and accept
the same.
Prev
Next
Step 2
Configure Tally to Import data - Contd
From Gateway of Tally, press F12 and navigate to Advanced Configuration and make the following changes:
I. Enable ODBC server = Yes
II. Port = 9001
Prev
Next
Step 2
Configure Tally to Import data - Contd
From Gateway of Tally, press F12 button and navigate to General configuration screen and set Ignore Error &
Continue during data Import = Yes
Prev
Next
Step 2
Run Import Tool
Open Vch_eTally.exe, import tool used to import data from the excel sheet
Note : If the Import License Top is invalid then the user will get to see the error “Could not open eTally integration”
screen
Prev
Next
Step 2
Run Import Tool - Contd
If the User is needs to import Masters exported from QuickBooks, then select the “Master” radio button as
highlighted in Green in below screen.
Note: If Master is selected, Select Voucher to import option is disabled
If User is trying to import Transactions exported from QuickBooks, then select the “Transaction” radio button as
highlighted in Red in above screen.
Note: Once Transaction button is selected, “Select Voucher to Import” dropdown gets enabled and allows user to
select the Voucher type.
Prev
Next
Step 2
Run Import Tool - Contd
1. Select Type of import i.e. Master Or Transaction.
2. Click the browse button (…) and select specific excel sheet to be imported.
3. Always ensure that the data to be imported is placed on the first sheet of the workbook. Remove / Move
any sheets in the beginning before the first sheet as the import tool reads data only from first sheet.
4. If you select Transaction, then User needs to browse for the same and then select the “Voucher Type” to be
imported from “Select the Voucher Type” Dropdown.
5. Once you selected the Excel sheet and choose the Voucher Type then Click the Button Post to Tally, which will
import the selected data in to Tally.
Prev
Next
FAQ
Q. Which version/releases of Tally.ERP 9 does the add-on support?
Ans. This add-on will work only with Tally.ERP 9 Series A, release 3.6 onwards.
Q. How will I get support for this add-on?
Ans. For any functional support requirements please do write to us on [email protected] or call us at
+91 80 41131825,
Q. If I need some enhancement / changes to be incorporated for the add-on, whom should I contact?
Ans. Please to write to us on [email protected] with your additional requirements and we will revert to you
in 24 hours.
Q. Will new features added be available to us?
Ans. We offer one year availability of all support and new features free of cost. After one year, nominal
subscription cost will be applicable to you to continue to get free support and updates.
Q. What will happen after one year?
Ans. 20% of the then MRP will be charged for one year of email support and versions (minor & major).
Home
Exit