120 likes | 121 Views
Here we have given detailed steps regarding how to download, install and configure our Excel to Tally tool depending on the excel version you have. Please read the instructions given below carefully.
E N D
Excel to Tally Import Software How To Use Here is where your presentation begins
How to Install Excel to Tally Software Here we have given detailed steps regarding how to download, install and configure our Excel to Tally tool depending on the excel version you have. Please read the instructions given below carefully.
What make us Unique Enjoy the ease of Excel Minimum Data Input Ledger mapping Our software completely designed in Microsoft Excel You need to provide minimum data and most of the fields are auto-calculated. Map your purchase, sales & GST ledgers based on the tax rate & place of supply
Step 1 Pre-requisite Step 2 Downloading, Installation and Activation Step 3 Connection with Tally Install Excel to Tally Software In 3 easy steps
Step 1 Pre-Requisite • Windows XP or above • Microsoft Excel 2007 or above • Tally 9 or Tally.ERP9 or Tally Prime • Microsoft 2007 Users needs to install Microsoft Office 2007 service pack 3
Step 2 Downloading, Installation and Activation 1. Download QuikAccount setup file from https://quick2tally.com/home/download 2. Right click setup file and install on your PC and you will find three shortcut on your desktop. a) First shortcut is for Excel 2007, 2010 and 2013 users b) Second is for Excel 2016 and above version (32bit only) c) Third is for Excel 2016 and above version (64bit only)
Step 2 Note Note: If you have excel 2007 and installed Office Service Pack 3, you can also use file mentioned in point b) 3. Open the applicable file, file will open in Excel. 4. Enable macros from the security warning given below Excel Ribbon. (See detailed steps to enable macro here) 5. Once you enable macros, you will be redirected to 'Registration' sheet. 6. Click on Activation Button, fill the form and activate your trial license.
Step 3 Connection with Tally 1. Once your trial license is activated as explained in above step. You need to make tally connection.
Tally Settings • a) For Tally.ERP9--> At Gateway of Tally --> Press F12 --> Advanced Configuration and make following configuration
Tally Settings • b) For Tally Prime--> Press F1 (Help) --> Settings ---. Connectivity --> Client/Server Configuration and make following configuration • 3. Set port on QuikAccount Help Sheet-The port you have set in tally, you need to mention same port in Help sheet of QuikAccount. • 4. Click on Connect Tally button. This will import all tally masters like Stock Item, Ledgers, Vouchers, Godowns, Cost Centres etc.
THANKS! Do you have any questions? support@quick2tally.com +91-93584-44502 , +91-141-4012472 https://www.quick2tally.com/