Billing Software for Hardware Shop and Auto Parts Store: Thousands of SKUs, Dual Units and Credit Khata

By BillAmico Tax & Compliance Desk | | 11 min read

Billing software for a hardware shop or auto parts store must handle thousands of items, sell the same product in different units, and track credit for regular buyers. It should also issue delivery challans and print barcode labels for loose goods that arrive without any.

1. Billing software for hardware shop: what the counter really needs

A hardware shop looks simple from outside and is complicated inside. One counter may sell pipes by the metre, cement by the bag, nuts and bolts by the piece, wire by the coil and paint by the litre. A contractor buys fifty items on credit, a plumber wants a cheaper rate, and a neighbour buys one tap and pays cash. Auto parts stores add part numbers, brands and fitment queries on top.

Software built only for neat packaged goods struggles here. The table shows the pressure points and what to ask for.

Pressure pointWhat goes wrong without supportWhat to look for
Thousands of itemsSlow search, duplicate items, wrong ratesFast search by two letters, bulk import from Excel
Mixed unitsWrong stock after selling a roll or a metrePrimary and secondary units with a conversion factor
Different customers, different ratesStaff quote from memoryA selling rate in the item that can be typed over on any bill line
Regular credit buyersLost track of duesCustomer khata with a running balance, payment allocation
Material sent to siteNo record until the final billDelivery challan that converts to an invoice
Loose or unbranded goodsNo barcode, slow billingLabel printing from the item master

2. Handling thousands of SKUs without chaos

Entering a few thousand items by hand is the main reason shopkeepers give up on software. BillAmico lets you upload products from an Excel template. The importer maps columns such as name, HSN, tax rate and rates, and brings in thousands of items in one go. You can also bring data from a supported earlier app using the Bahi Khata data importer.

At the counter, you find an item by typing two letters of its name or by scanning its barcode. Keep item names consistent, for example always writing size and material in the same order, because consistent naming is what makes a two-letter search return the right item first.

For auto parts and similar goods, the item master supports variants such as size, colour and brand, each with its own barcode. That lets you keep one parent item for a part family and sell the exact variant without cluttering the catalogue.

tip: Before importing, clean your Excel sheet: one row per item, one HSN per item, and tax rates verified against the official GST rate list. A clean import saves weeks of correction later.

3. Dual units: sell by roll, stock by metre

Many hardware goods are bought in one unit and sold in another. BillAmico supports a primary unit, a secondary unit and a conversion factor. For example, set the primary unit to metre, the secondary unit to roll, and the conversion to 1 roll = 100 metres. Billing then lets you type either unit, while stock is always kept in the base unit.

ItemPrimary unitSecondary unitConversion
Electrical wireMetreCoil1 coil = 90 metres (set to your actual pack)
FastenersPieceBox1 box = 10 pieces
Adhesive tubesPieceCarton1 carton = 24 pieces (set to your actual pack)

Worked example: you buy 4 rolls of 100 metres, so stock shows 400 metres. A customer takes 250 metres. Stock falls to 150 metres. A second customer asks for 1 roll, and stock falls to 50 metres. You never convert by hand, so the closing balance stays accurate.

4. Negotiated rates: change the rate on the bill

The same item is often sold at different rates to different buyers. The item master holds the selling rate, and the rate can be typed over on any bill line.

For a contractor or a one-off negotiation, you can override the rate on a single line during billing. The override affects only that bill and does not change the catalogue price. You can also give a line discount in percent, or a flat bill discount in the summary bar, for example reducing ₹1,045 to ₹1,000.

5. Credit khata and payment allocation for contractors

Hardware is a credit business. Contractors and regular customers buy through the month and pay later, often in lump sums. A good system must show who owes how much and apply payments to the right bills.

In BillAmico each customer has a ledger with a running balance, and the receivables ageing report shows how old each due is. When a payment arrives, use Payment In and the system allocates it to the oldest bills first.

Worked example: a contractor has three unpaid bills of ₹3,000, ₹4,500 and ₹2,500, a total of ₹10,000. He pays ₹8,000. The first bill is cleared, the second is cleared, and ₹500 is applied to the third, leaving ₹2,000 due. A receipt that lists the cleared bills and the remaining balance can be sent to the customer on WhatsApp.

6. Estimates, delivery challans and large orders

Large jobs usually start as a quotation. Create an estimate with the agreed rates. When the customer confirms, convert it to an invoice in one click and every line, rate and tax carries over without retyping.

When material goes to a site before the final bill, or goes out for approval, a delivery challan moves the stock without creating a tax invoice. When the customer accepts, convert the challan to an invoice. Items that come back can be deleted from the conversion draft so that only kept items are billed.

For large consignments, BillAmico shows an e-way bill prompt at ₹50,000. Treat it as a reminder to check the e-way bill rules for the movement involved, and confirm the details with your CA.

7. Barcode labels for loose and unbranded goods

Nuts, bolts, fittings and spare parts often arrive in a bag with no barcode. Create the item once, then use the Barcode Sticker Designer to print labels on a thermal label roll. The label can show the item name, price and barcode. After that, billing is a scan instead of a search.

If you must create an item at the counter during a busy hour, you can do it from the billing screen without leaving the cart. Enter the price and tax rate and the item is added to the bill and saved to inventory.

8. Buyer checklist for a hardware or auto parts shop

RequirementTest it withPass if
Bulk item importYour real Excel price listNames, HSN and rates load without manual repair
Dual unitsA roll sold in metresStock reduces correctly in the base unit
Customer khataA customer with unpaid billsLedger shows the running balance and the ageing of dues
Payment allocationA lump-sum paymentOldest bills clear first and receipt shows balance
Estimate and challanA large site orderConverts to an invoice without retyping
Offline operationSwitch off the routerBilling and printing continue

BillAmico runs offline on an embedded SQLite database, and the Multi-User LAN Edition lets several counters share stock over the store Wi-Fi. Try your own price list in the 14-day free trial.

Frequently asked questions

Which billing software is best for a hardware shop?

Choose software that handles thousands of items with bulk import, supports units like metre and roll with conversion, lets you change the rate on a bill line, tracks credit for contractors and works offline. Test it with your own price list in a free trial.

How can I bill in metres and rolls in the same software?

Use dual units. Set one primary unit and one secondary unit with a conversion factor, for example 1 roll = 100 metres. You can bill in either unit while the stock is kept in the base unit, so the balance is always correct.

Can billing software give different rates to contractors and customers?

In BillAmico each item has a selling rate, and you can type over the rate on any bill line for a contractor or a negotiated deal. The change affects only that bill.

How do I manage udhaar for regular hardware customers?

Keep a customer ledger with a running balance, and record payments through Payment In so they clear the oldest bills first. The receivables ageing report shows which dues are oldest.

Can I print barcode labels for loose nuts, bolts and spare parts?

Yes. Create the item once, then print a label from the Barcode Sticker Designer on a thermal label roll. After labelling, every sale is a scan, which is much faster than searching for the item by name.

Official sources

Related guides