Wholesale & eCommerce Purchase Entry in Tally Prime — Complete Inventory Guide
Wholesale & eCommerce Purchase Entry in Tally Prime — Complete Inventory Guide
Learn how to record multi-item wholesale purchase invoices, eCommerce supplier bills, batch numbers, and stock SKU mappings in Tally Prime.
Who is this for: Inventory & eCommerce
Trading, wholesale distribution, and eCommerce businesses operate on complex inventory cycles. Unlike service firms, they process high volumes of supplier bills containing diverse stock items, SKU prefixes, and wholesale discount margins. Correctly recording these purchase vouchers in Tally Prime is essential for maintaining accurate inventory valuations and claiming Input Tax Credit (ITC).
Quick Answer: How to Automate Wholesale & eCommerce Purchase Entries in Tally (2026)?
TrulyInvoice recommends configuring Stock Item Aliases under Item Alteration in Tally Prime to map vendor SKUs. Use TrulyInvoice AI OCR to extract multi-item lines, discount rates, and tax breakdowns from supplier PDFs and sync F9 purchase vouchers directly over Port 9000.
- Enable 'Use Discount Column in Invoices' in Tally F11 for trade discount entries.
- Use Stock Item Aliases in Tally to auto-map vendor SKUs to internal stock items.
- Enable 'Maintain Batches' for FMCG and pharmaceutical inventory tracking.
- TrulyInvoice AI OCR processes 50+ item lines from supplier PDFs in 15 seconds.
Table of Contents
1. Wholesale Purchase Voucher Entry in Tally
Wholesale purchases are characterized by high volume items and trade discounts. To record these transactions cleanly in Tally:
- Enable Discount Column: Go to F11 Features and set Use Discount Column in Invoices to Yes. This adds a dedicated percentage discount column to your item entry grid.
- Detailed Item Log: Use Item Invoice Mode (Ctrl+H) to record stock quantity, agreed unit rates, and discount details.
- Split GST Rates: Wholesale invoices often mix items under different tax rates (e.g. 12% and 18%). Define tax rates at the Stock Item level so Tally applies the correct rates automatically.
2. eCommerce Purchase Entry & SKU Mapping
eCommerce brands purchase inventory from manufacturers in bulk and sell online under distinct Merchant SKUs.
The main challenge is matching supplier product codes with your internal Tally stock items. If a manufacturer bills an item as 'Men's Running Shoe Blue Medium' and your Tally code is 'M-SHOE-BLU-M', a simple import will fail.
To resolve this, maintain an alias list inside Tally: Open the Stock Item alteration screen, and input the supplier SKU under the Alias field. Tally's search will resolve the alias code to your stock item during manual imports.
3. Pharma & FMCG Distribution Entries
Distribution businesses deal with perishable goods, requiring batch and expiry tracking:
Batch-Wise Details
Enable batches under F11 Features. In the purchase voucher, input the batch number for each item, which is essential for tracking shelf lives and returns.
Expiry Date Records
Input manufacturing and expiry dates alongside the batch number. Tally will warn you if you attempt to sell expired batches in retail bills.
4. Shopify and Amazon Seller Reconciliations
If you fulfill orders using Amazon FBA or multi-state warehouse networks, supplier purchases must be allocated to correct location godowns:
- Create separate Godowns in Tally corresponding to each fulfillment center (e.g. 'Amazon FBA Bangalore', 'Mumbai Warehouse').
- Allocate items to these godowns during voucher entry, ensuring inventory values by location are accurate.
5. Automating Inbound Vouchers with TrulyInvoice
Typing in wholesale bills containing dozens of items and batch codes is slow and prone to errors.
TrulyInvoice simplifies the process. Drag and drop your supplier invoices (PDF or image format) onto the dashboard, and the AI extracts item rows, maps vendor SKUs to Tally codes, assigns ledger classifications, calculates GST splits, and imports the transaction directly into Tally Prime over Port 9000.
Automate Wholesale Purchase Syncing
Integrate TrulyInvoice to map eCommerce SKUs, automate multi-item lines, and sync bulk distributor bills to Tally Prime automatically.
Get Started for FreeFrequently Asked Questions
How do I map supplier SKUs to internal stock items in Tally Prime?
In Tally Prime, open the Stock Item Alteration screen and enter the supplier's SKU or barcode under the 'Alias' field. When importing or creating purchase vouchers, Tally will automatically map the alias to your internal stock item.
How do I enable batch-wise details for wholesale pharma or FMCG purchases?
Go to Gateway of Tally > F11 Features > Inventory, and set 'Enable Batches' to 'Yes'. Also enable 'Maintain Expiry Dates' if you process perishable or pharmaceutical stock.
Can TrulyInvoice handle multi-item wholesale bills with 50+ lines?
Yes. TrulyInvoice extracts all line items from long PDFs and multi-page supplier bills automatically, matching vendor SKUs and quantities to Tally stock items in seconds.
Founder & Chief Architect of TrulyInvoice