Excel to Tally in Seconds with 1 Click
Save Drive Name to create Templates by this Application. A folder named QuickTally will be created automatically.
Run Tally and ensure that the ODBC Server is enabled.
For Tally.ERP9, go to Gateway of Tally → F12 → Advanced Configuration. Set "Tally.ERP is acting as" = Both and Enable ODBC Server = YES.
For TallyPrime, go to Help → Settings → Connectivity. Set "TallyPrime acts as" = Both and Enable ODBC = YES.
Click "Connect with Tally". Select the running company. QuickTally will import all Ledgers, Groups, Stock Items and Units automatically.
Select Entry Type from Home Sheet or QuickTally Ribbon. Ledger names should exactly match Tally.
Copy and paste or import your template into the sheet
Verify entries before posting. Once entries are posted, they cannot be reversed. Test with dummy data first.
Click "Post in Tally". Errors, if any, will be displayed with row numbers and descriptions.
If no errors are found, QuickTally will show the number of entries ready for posting and the time taken after posting.
Double-click any Blue Heading cell or Blue Button to select Ledgers, Groups, Stock Items and Units.
QuickTally automatically creates Groups, Ledgers, Stock Groups and Stock Items while posting entries.
System Requirements:Windows 7+, Office 2007+, RAM 2GB+, Date Format DD-MM-YYYY or DD/MM/YYYY in Control Panel. Excel 64-bit is required for TallyPrime.
If the Application does not work, contact QuickTally Support.
Always take a backup of your Tally data before posting entries. Test the application using sample data before using it on live company data.
quicktally.in@gmail.com
support@quicktally.in