Learn how to manage liquid inventory in litres and millilitres using Composite Units in TallyPrime. This guide explains unit creation, stock configuration, purchase and sales entries, automatic quantity conversion, and practical inventory management examples.
How to Manage Stock in Litres and Millilitres Using Composite Units in TallyPrime
Managing inventory becomes challenging when a business purchases products in large quantities but sells them in smaller measurements. This is particularly common in businesses dealing with liquids such as cooking oil, milk, juice, petrol, chemicals, paint, and other liquid products.
For example, a shopkeeper might purchase 20 litres of cooking oil from a supplier but sell it to customers in 500 ml, 1 litre, or 2 litre quantities. Recording every transaction manually or maintaining separate stock calculations can lead to errors.
TallyPrime makes this process easier with Composite Units. You can use this feature to manage stock in litres and millilitres without maintaining complicated manual calculations.
In this guide, you will learn how to configure composite units, record purchases and sales, and maintain accurate inventory in TallyPrime with practical examples.
What Are Composite Units in TallyPrime?
Composite Units allow you to combine two different units of measurement into a single measurement structure.
For example:
1 Litre = 1,000 Millilitres
500 Millilitres = 0.5 Litre
2 Litres = 2,000 Millilitres
Instead of treating litres and millilitres as completely separate measurements, TallyPrime can use their relationship to calculate quantities automatically.
This is especially useful when a business purchases products in litres but sells them in millilitres.
Practical example:
Suppose you purchase 50 litres of cooking oil and sell it in the following quantities:
Transaction | Quantity |
|---|---|
Opening stock | 50 Litres |
Sale to Customer A | 2 Litres |
Sale to Customer B | 500 Millilitres |
Sale to Customer C | 1,500 Millilitres |
Remaining stock | 46 Litres |
TallyPrime can maintain the inventory accurately when the units are configured correctly.
Why Use Composite Units for Liquid Stock Management?
Using composite units helps businesses maintain consistent inventory records when the same product is purchased and sold using different measurement units.
Here are some important advantages:
Automatic quantity conversion: Convert litres into millilitres using the defined conversion relationship.
Accurate stock tracking: Maintain inventory without manually calculating every transaction.
Flexible purchasing: Purchase products in bulk quantities.
Flexible sales: Sell products in smaller quantities according to customer requirements.
Reduced calculation errors: Avoid mistakes caused by manual unit conversions.
Better inventory management: Check available stock using consistent measurement units.
For example, a paint shop may purchase 100 litres of paint and sell it in 500 ml, 1 litre, and 5 litre quantities. Composite units help simplify this inventory process.
Understanding the Difference Between Simple Units and Composite Units
Before creating composite units, it is important to understand how they differ from simple units.
Feature | Simple Unit | Composite Unit |
|---|---|---|
Measurement | Single unit | Combination of units |
Example | Litre | Litre and Millilitre |
Conversion | Not necessarily required | Defined conversion |
Usage | Basic stock management | Different measurement sizes |
Example business | Selling products only in litres | Buying in litres and selling in millilitres |
A simple unit is suitable when all transactions use the same measurement. Composite units are useful when you need to work with different measurement sizes.
How to Create Units for Litres and Millilitres in TallyPrime
The first step is to create the required units of measurement.
You need to configure litres and millilitres before creating the composite unit.
Create the Litre Unit
Follow these steps:
Open TallyPrime.
Select your company.
Go to Create → Unit.
Enter the symbol as
Ltr.Select the unit type as Simple.
Enter the formal name as Litre, if available.
Save the unit.
You have now created the basic unit for measuring liquid products.
Create the Millilitre Unit
Next, create the millilitre unit.
Go to Create → Unit.
Enter the symbol as
ml.Select the unit type as Simple.
Enter the formal name as Millilitre, if available.
Save the unit.
You now have two simple units available in your company.
How to Create a Composite Unit in TallyPrime
After creating both simple units, you can configure the composite measurement.
For example, you want to establish the relationship:
1 Litre = 1,000 Millilitres
Follow these steps:
Open the Unit Creation screen.
Select the Composite unit option.
Choose Litre as the first unit.
Enter the conversion quantity as 1.
Choose Millilitre as the second unit.
Enter the conversion quantity as 1,000.
Save the configuration.
The exact field labels and screen arrangement may vary depending on your TallyPrime release.
Important: If your version supports only specific composite-unit configurations, check the available unit creation options before proceeding. You can also use a suitable alternate unit configuration where necessary.
How to Create a Stock Item for Liquid Products
Once your measurement units are ready, create the stock item you want to manage.
For example, let's create a stock item called Cooking Oil.
Follow these steps:
Open TallyPrime.
Go to Create → Stock Item.
Enter the item name as Cooking Oil.
Select the appropriate stock group.
Choose the applicable unit or composite unit.
Enter the opening balance, if required.
Save the stock item.
You can follow the same process for milk, juice, paint, lubricants, chemicals, and other liquid products.
How to Record Purchases in Litres
Let's understand how to record a purchase transaction.
Suppose your business purchases 50 litres of cooking oil from a supplier at ₹120 per litre.
Your purchase details will look like this:
Particulars | Details |
|---|---|
Product | Cooking Oil |
Quantity | 50 Litres |
Rate | ₹120 |
Total Amount | ₹6,000 |
Follow these steps:
Open the Purchase Voucher.
Select the supplier's ledger.
Choose Cooking Oil.
Enter the purchase quantity as 50 litres.
Enter the purchase rate as ₹120 per litre.
Check the total amount.
Save the voucher.
TallyPrime will record the purchase and update the inventory according to your stock-item configuration.
How to Sell Products in Millilitres
Now suppose a customer purchases 500 ml of cooking oil.
You originally purchased the product in litres, but the customer wants a smaller quantity.
Your sales transaction would look like this:
Particulars | Details |
|---|---|
Product | Cooking Oil |
Quantity | 500 ml |
Equivalent Quantity | 0.5 Litre |
Selling Rate | ₹150 per Litre |
Sales Amount | ₹75 |
Follow these steps:
Open the Sales Voucher.
Select the customer ledger.
Choose Cooking Oil.
Enter the quantity using the supported millilitre unit.
Enter the selling rate.
Verify the calculated amount.
Save the voucher.
The quantity should be converted using the defined relationship between litres and millilitres.
Note: The ability to select a particular unit directly in a voucher depends on how the stock item and units are configured. If TallyPrime does not offer the required unit selection, use an alternate-unit configuration or another supported inventory setup.
Practical Example: Complete Stock Management in Litres and Millilitres
Let's take a realistic example to understand how inventory changes after multiple transactions.
Suppose a retail business starts with 100 litres of cooking oil.
During the day, it makes the following sales:
Transaction | Sold Quantity | Equivalent in Litres |
|---|---|---|
Sale 1 | 2 Litres | 2 L |
Sale 2 | 500 ml | 0.5 L |
Sale 3 | 1,500 ml | 1.5 L |
Sale 4 | 3 Litres | 3 L |
Total Sales | 7 L |
The remaining inventory is:
Stock calculation
Opening stock
100 L
Total sold
7 L
Remaining stock
93 L
This example shows why consistent unit conversion is important for businesses selling liquids in different quantities.
How to Check Stock Balance in TallyPrime
After recording purchase and sales transactions, you should verify the available inventory.
TallyPrime provides inventory reports that help you monitor stock movements and closing balances.
Follow these steps:
Open the Gateway of Tally.
Navigate to Display More Reports or the relevant inventory reports menu.
Open the Stock Summary report.
Select the required stock item.
Check the closing quantity.
Verify that the remaining stock matches your purchase and sales records.
For example, if your opening stock was 100 litres and total sales were 7 litres, the closing balance should be equivalent to 93 litres.
If the figures do not match, review your voucher entries and unit conversion settings.
Common Mistakes to Avoid When Managing Liquid Stock
Even with automatic inventory calculations, incorrect configurations can create problems.
Keep these points in mind:
Incorrect conversion ratio: Always verify that 1 litre equals 1,000 millilitres.
Different unit symbols: Avoid creating multiple units for the same measurement without a clear reason.
Incorrect stock-item configuration: Check that the stock item uses the intended unit structure.
Wrong selling rate: Make sure the selling rate corresponds to the selected measurement unit.
Missing purchase entries: Unrecorded purchases can result in incorrect stock balances.
Incorrect decimal settings: Use sufficient decimal precision when recording fractional quantities.
Ignoring physical stock verification: Compare the TallyPrime balance with the actual inventory regularly.
One particularly common mistake is entering 500 ml as 500 litres. Always verify the selected unit before saving a voucher.
Composite Units vs Alternate Units: Which Is Better?
Composite units and alternate units serve different purposes in inventory management.
Requirement | Suitable Configuration |
|---|---|
Combine different measurement units | Composite Units |
Purchase in litres and sell in millilitres | Alternate unit or supported composite-unit setup |
Maintain a fixed conversion ratio | Composite Units |
Use different units for purchase and sales | Alternate Units |
Manage simple inventory | Simple Units |
For example, if you purchase cooking oil in litres but sell it in millilitres, an alternate-unit configuration may be more convenient when your TallyPrime version supports the required stock-item setup.
Choose the configuration based on how your business actually purchases, stores, and sells products.
Best Practices for Managing Liquid Inventory in TallyPrime
To maintain accurate stock records, follow these practical recommendations:
Use standard measurement symbols such as Ltr and ml.
Maintain consistent conversion ratios.
Check stock balances after important purchase and sales transactions.
Record every inventory movement in TallyPrime.
Avoid creating duplicate stock items for the same product unnecessarily.
Verify physical inventory periodically.
Keep purchase and sales rates consistent with their respective units.
These simple practices can make inventory management more reliable and reduce mistakes during daily accounting operations.
Conclusion
Managing stock in litres and millilitres becomes easier when you configure measurement units correctly in TallyPrime. Composite Units help establish relationships between different units, while alternate-unit configurations can be useful when purchasing and selling the same product in different quantities.
Whether you manage cooking oil, milk, paint, chemicals, or other liquid products, the right inventory configuration can reduce manual calculations and improve stock accuracy.
Before using the setup in your live company, test a few purchase and sales transactions to confirm that the quantity conversions and stock balances work as expected.
Frequently Asked Questions (FAQs)
Q1. What are Composite Units in TallyPrime?
Composite Units combine two measurement units using a defined conversion relationship, such as litres and millilitres.
Q2. How many millilitres are there in one litre?
One litre is equal to 1,000 millilitres.
Q3. Can I purchase products in litres and sell them in millilitres?
Yes. You can configure suitable inventory units, including alternate units where supported, to handle different purchase and sales measurements.
Q4. Can TallyPrime automatically calculate the remaining liquid stock?
Yes. TallyPrime updates inventory based on recorded transactions and correctly configured units.
Q5. Which is better for liquid stock management: Composite Units or Alternate Units?
It depends on your requirements. Composite Units define measurement relationships, while Alternate Units are often more convenient for handling different transaction units for the same stock item.
COMMENTS