How do FMCG wholesalers manage manufacturer discounts in Tally?

You can map cash discounts to a central 'Discount Received' ledger, or apply them directly to item values during import to keep your material costs accurate.

How do I configure stock reorder points in TallyPrime?

Go to the Stock Query screen or the Reorder Status report, and set the minimum stock levels and reorder quantities for each item.

What is the best way to handle free promotional stock in Tally?

Configure separate actual and billed quantity columns in Tally's voucher settings, allowing free units to be recorded without changing the item's cost.

Can TrulyInvoice parse HUL, ITC, or Britannia invoices?

Yes. TrulyInvoice extracts transaction details from any major FMCG manufacturer invoice, matches product codes, and formats clean Tally imports.

FMCG Wholesale Purchase Bill Entry Automation in Tally Prime

FMCG (Fast-Moving Consumer Goods) distributors and wholesalers operate on thin margins and high volumes. Reconciling high-volume manufacturer invoices is a major administrative task.

Entering these invoices manually, along with complex discount structures and promotional schemes, is slow and can lead to errors. Automating purchase entries directly in TallyPrime solves this issue. This guide covers manufacturer invoice mappings, scheme reconciliations, and inventory setups.

Quick Answer: How to Automate FMCG Wholesale Purchase Entry in Tally Prime (2026)?

TrulyInvoice automates FMCG wholesale purchase bill entry in Tally Prime by using Google Gemini AI OCR to extract multi-item manufacturer invoices (HUL, ITC, Britannia, P&G) from PDF, scanned image, or photo bills into F9 purchase vouchers via Port 9000 sync in 15 seconds.

Handles 50+ line item FMCG supplier bills automatically with item-level HSN mapping.
Parses trade discounts, scheme deductions, and GST tax allocations (5%, 12%, 18%).
Auto-creates missing FMCG stock items and supplier ledgers during sync.
Flat plans starting at ₹399/month subscription for unlimited wholesale invoice sync.

1. Mapping Manufacturer Discounts

FMCG distributors offer various discounts, including cash discounts, trade discounts, and schemes. To map these in TallyPrime:

Trade Discounts: Deducted from the item rate directly in the purchase voucher.
Cash / Scheme Discounts: Mapped to a central Discount Received ledger (grouped under Indirect Incomes) at the end of the voucher.

2. Database Schema for FMCG Purchase Imports

FMCG Field	Tally Field Code	Description
EAN Barcode / Item SKU	`Alias`	Matches stock item profiles automatically
Actual Quantity	`ACTUALQTY`	Total physical units received
Billed Quantity	`BILLEDQTY`	Payable units after discount adjustments
Distributor Discount	`DISCOUNTAMOUNT`	Rebate values deducted from invoice totals

3. Managing Alternate Units of Measure for Retail Packs

FMCG items are bought in cases and sold as single units. Configure alternate units of measure (UOM) to track this inventory:

Set up the main unit as Pcs and the alternate unit as Case. Enter the conversion factor (e.g. 1 Case = 48 Pcs). During import, you can specify quantities in cases, and Tally will update your stock counts in pieces automatically.

4. Reconciling Brand-wise Gross Margins

To track profitability across brands, group stock items under their respective brand hierarchies (e.g. parent groups for HUL or ITC). Tally's stock group summary report will show total sales, purchases, and gross margins for each brand.

Simplify FMCG Wholesaling and Purchase Logging

TrulyInvoice parses complex manufacturer invoices, extracts EAN barcode identifiers, aligns unit quantities, and formats clean Tally imports in seconds.

Start 14-Day Free Trial