Description
With this Excel to Tally Prime 6 Ecommerce Import Utility you can Import your E-Commerce Data Entry into TallyPrime 3, 4, 5, 6 and upcoming versions with Easy and quick way. With this Excel to Tally Prime 6 software we can import Sales, Returns, Settlements, Masters and Vouchers with every detail. It work perfectly in Tally Prime 6.2 Multi GST and Also Single GST Option. Import entries very quickly with Tally Prime 6 TSF Template File provided with this Software. No need to Create Tally Prime 6 Excel to Tally Templates Manually.
It holds below features that make it best Excel to Tally E-Commerce Data Import software :
Excel to Tally Ecommerce Import for Older version Tally (Tally Erp9 and Tally Prime)
Excel to Tally Prime 6 Ecommerce Import Features:
- Realtime connection with Tally
- Master and Voucher Creation in Same Sheet
- Import Text, CSV, Excel formats Directly in this sheet
- Auto Calculation columns of Cell address, Round off, Taxable Value etc with Validate Button
- Upto 25000 entries with one click
- Very supportive formats for every type work.
- Small and supportive file, work with every version of Excel
- Lifetime Use, No renewal required, 24×7 free support with whatsapp, call and Ultraviewer, Anydesk.
- Perfectly work in Tally Prime 6 with Multi GST and Also Single GST Option.
- Free Updates, and Free Modification as per Tally Master (Ledgers and Items Name from Tally)
- Free Tally Prime 6 TSF Template file to Import Entries Very Quickly.
Welcome! The primary purpose of the ‘Excel to Tally Prime Ecommerce Import Utility’ is to provide a simple and quick way to import your e-commerce data—like sales, returns, and payment settlements—directly into Tally Prime. For anyone managing online store finances, this tool acts as a powerful bridge between complex spreadsheet data and professional accounting software.
This document will walk you through the key features of the utility, explaining how it simplifies and automates your accounting workflow.
——————————————————————————–
1. What Can You Import? A High-Level Overview
At its core, the utility is designed to handle the most common types of e-commerce accounting data. You can import:
• Sales & Returns: This covers the core transaction vouchers from your various e-commerce platforms, including both customer purchases and product returns.
• Settlements: This handles the payment records you receive from marketplaces like Amazon or Flipkart, detailing how much you were paid after their fees and charges.
• Masters & Vouchers: The tool can automatically create fundamental records (like Ledgers for customers and Stock Items for products) and the corresponding transaction entries at the same time.
These capabilities are powered by a set of specific features designed to make the import process as smooth as possible.
——————————————————————————–
2. Core Features: How the Utility Simplifies Your Work
The utility is built with features focused on speed, flexibility, and long-term value. Here’s a breakdown of what makes it effective.
These features are designed to dramatically cut down on manual work and the potential for human error.
1. Real-time Tally Connection This feature ensures immediate and seamless data synchronization between the Excel utility and Tally Prime. Your data is always current, providing a single source of truth without delays.
2. One-Click Bulk Import The utility can import up to 25,000 entries in a single click. This massive capacity transforms what would be days of manual data entry into a task that takes only moments.
3. Pre-built Tally Template The software includes a “Free Tally Prime 4.0 TSF Template file.” This means you don’t need to spend time manually creating or configuring your own templates; you can start importing data much faster using a ready-made format.
4. Automatic Calculations The utility contains “Auto Calculation columns” and automatically calculates Debit/Credit amounts. This automation minimizes common spreadsheet errors and removes the need for you to perform these calculations manually in Excel before importing.
The software is designed to work with various systems, file types, and e-commerce platforms.
|
System/Requirement
|
Supported Versions/Types
|
|
Tally Version
|
Tally Prime 6, Including Tally Prime all versions like 3 , 4 ,5 and Upcoming versions
|
|
Microsoft Excel
|
All Versions (From Excel 2007 to Excel 365 and all Latest Versions
|
|
GST Handling
|
Multi GST and Single GST options
|
|
Input File Formats
|
Text, CSV, and Excel
|
|
E-commerce Platforms
|
Amazon, Flipkart, Meesho, Jiomart, Ajio, Myntra, Snapdeal, Nyka, and many others
|
The ownership model is structured to provide long-term value and assistance.
• Lifetime Use: The software is a one-time purchase with no recurring renewal fees required.
• Free Support & Updates: Your purchase includes free support, free future updates in the Sheet, and free modifications to align with your specific Tally Master setup.
——————————————————————————–
3. A Closer Look: Specialized Data Handling
The utility organizes its functions into dedicated sheets within the Excel file, each tailored for a specific accounting task. The two primary sheets are for Vouchers and Settlements.
3.1. Vouchers Sheet:
The
VOUCHERS sheet is the main engine for importing sales, returns, and other transactional data. Its power lies in its comprehensive and flexible design.• All-in-One Creation: Create Masters (Ledger, Stock, Unit, etc.) and their corresponding Vouchers from this single sheet without switching contexts.
• Unmatched Flexibility: Handle both inventory-based and service-based (without inventory) vouchers in the same sheet, and choose between manual and automatic voucher numbering to match your workflow.
• Financial Precision: The sheet supports bill-wise details and includes columns for all necessary financial elements like shipping charges, wrapping fees, discounts, GST, and TCS.
• Accurate GST Reporting: Ensure compliance by capturing critical details like Party State and Place of Supply, which allows entries to directly affect the GSTR1 report without errors.
• Error Prevention: The system is designed to prevent the creation of duplicate vouchers, ensuring your accounting data remains clean and accurate.
• Simple Interface: The Excel ribbon features clear, dedicated buttons like
IMPORT, VALIDATE, and POST VOUCHER to streamline the process.3.2. Settlement Sheet:
The
SETTLEMENT sheet is optimized for processing the complex payment files you download from marketplaces.• Direct Import: Import settlement files (in Text, CSV, or Excel format) directly as you download them from e-commerce websites, without needing to reformat them.
• Simplified Reconciliation: Handle payments with multiple reference entries, making it easier to match a single settlement against numerous orders or invoices.
• Combined Posting: The tool allows you to post bank receipts and related expense journals at the same time, streamlining the entire reconciliation process.
• Platform-Specific Tools: It includes separate, optimized sheets for Amazon and Flipkart settlements, which feature extra buttons for efficiency:
POST RECEIPT, POST EXPENSES, and POST TCS TDS WITH POST ALL BUTTON.• GST Reporting: Entries posted from this sheet are structured to correctly affect your GSTR 2A and 3B reports.
With these powerful and specialized tools, you can manage your e-commerce accounting with greater precision. Next, let’s see where you can find help to get started.
——————————————————————————–
4. Getting Started and Finding Help
The utility is designed to be user-friendly, and several resources are available to guide you.
1. Built-in Help The utility has a dedicated ‘HELP SHEET’ with instructions. Additionally, you can get instant help by simply moving your cursor over any button in the Excel ribbon to see a tooltip explaining its function.
2. Video Guides Video tutorials are available on YouTube to walk you through the process:
3. Direct Contact For direct support, you can reach out via:
◦ Phone:
+91-9131810293 ◦ Email:
Learnwells@outlook.com
Reviews
There are no reviews yet.