How to Import Sales Invoices from Excel to Tally Prime
How to Import Sales Invoices from Excel to Tally Prime
For retail shops, distributors, and e-commerce sellers, recording sales bills manually takes hours. Learn how to bulk upload sales registers from Excel.
Who is this for: Tally Setup Docs
If your business sells products through e-commerce channels (such as Amazon, Shopify, or Flipkart) or operates a local Point of Sale (POS) system, you generate hundreds of sales invoices daily. Typing these details into Tally Prime manually creates typing backlogs. Bulk importing sales registries from Excel is the standard solution.
Required Excel Columns for GST Sales Invoices
To ensure Tally calculates and records tax allocations (CGST, SGST, IGST) accurately, format your sales sheet with these headers:
| Column Header | Type | Description | Example Value |
|---|---|---|---|
| Invoice Number | Alphanumeric | Unique billing reference | INV/2026/0014 |
| Date | DD-MM-YYYY | Date of sales invoice generation | 01-04-2026 |
| Party Name | Text | Customer ledger name in Tally (or "Cash") | Acme Retailers |
| Stock Item | Text | Product name (must match inventory masters) | Syska LED Bulb 12W |
| Quantity | Number | Number of units sold | 10 |
| Rate | Decimal | Selling price per unit (excluding GST) | 150.00 |
| Taxable Value | Decimal | Total amount before taxes (Qty * Rate) | 1500.00 |
| CGST / SGST / IGST | Decimal | GST tax values | CGST: 135.00, SGST: 135.00 |
Intra-State vs. Inter-State Tax Mappings
To ensure correct tax calculations on imports:
- Intra-State Sales (Within State): If the customer's state matches your business registration location, Tally will split the tax equally into **CGST** and **SGST** ledgers.
- Inter-State Sales (Outside State): If the customer is located in a different state, Tally requires the entire tax to be mapped to the **IGST** ledger.
Note: If your Excel sheet attempts to allocate CGST/SGST on an inter-state sale, Tally will reject the voucher during import or flag it in GSTR-1 error logs.
Importing Sales Invoices Natively
- Go to Import > Manage > Mapping Templates.
- Select Sales Invoices and open your PDF file.
- Map fields (Invoice No, Customer, Item, Quantities, Rates, Tax Ledgers).
- Go to Import > Transactions to load the entries.
Why TrulyInvoice is Superior for E-Commerce Sellers
E-commerce sales registers from Amazon, Shopify, or POS sheets often contain complex layouts, multi-tier discount columns, and shipping fees. Creating Tally templates for these formats is difficult.
TrulyInvoice automates this workflow:
- No Layout Mapping: Upload your Amazon or Shopify sales PDF invoices. TrulyInvoice's AI extracts customer details, taxable values, and stock items automatically.
- Discount Distribution: Automatically distributes invoice-level coupons or discounts across item lines.
- Flat pricing: Sync unlimited transactions to Tally Prime for a flat subscription fee of **plans starting at ₹399/month**, bypassing credit limits.
Frequently Asked Questions
Q: Can I import sales vouchers without item details (accounting invoice only)?
A: Yes. If you do not track physical stock quantities, you can import sales in Accounting Invoice mode. In this mode, you only need to map the customer ledger, sales account, and tax ledgers without item quantities.
Q: What happens if a customer name does not exist in Tally?
A: Tally will throw a "Ledger does not exist" error and fail the voucher. TrulyInvoice lets you review missing ledgers and auto-creates them under Sundry Debtors before importing.
Q: What is TrulyInvoice's flat pricing?
A: TrulyInvoice charges a flat rate of plans starting at ₹399/month for unlimited statement and invoice synchronization, enabling automated data entry directly to Tally Prime.
Sync Invoices and Statements Directly to Tally Prime
Stop spending hours on manual data entry. Simply upload purchase/sales invoices and bank statements, review mapped items, and sync transaction entries directly to Tally Prime. Get started at just plans starting at ₹399/month for unlimited sync.
Start Free TrialFounder & Chief Architect of TrulyInvoice