Trading

Qty, Rate or Total: Faster Cash Sales for Retail Counters

· 4 min read

A customer at your counter says, "Give me five hundred rupees of sugar." Another says, "Ten pieces, and I will give you a thousand." A third says, "Two and a half kilos." Each wants a different calculation. A billing screen that only multiplies quantity by rate forces the cashier to reach for a calculator, and the queue grows. This guide explains the three-way calculation that retail counters need, and how to run cash sales faster and with fewer mistakes.

The three numbers on every sale line

Every line on a sale has three figures:

  • Quantity: how much the customer takes
  • Rate: the price of one unit
  • Total: what the customer pays for that line

They are linked: Total = Quantity × Rate. If you know any two, you can work out the third. Customers do not all start from the same one.

Three ways customers buy

Customer says Known To find
"Two and a half kilos of sugar" Quantity and rate Total
"Rs 500 of sugar" Total and rate Quantity
"Ten pieces for Rs 1,000" Total and quantity Rate

Examples with numbers:

  • Quantity and rate: 2.5 kg at Rs 175 gives a total of Rs 437.50.
  • Total and rate: Rs 500 at Rs 175 per kg gives 2.857 kg to weigh out.
  • Total and quantity: 10 pieces for Rs 1,000 gives a rate of Rs 100 each.

The second case is the one retailers meet most with loose goods such as sugar, rice, tea, spices, cloth and fuel. The third is common when a bargain has been struck for the whole lot.

Why this matters at the counter

  • Speed. No calculator, no second counting.
  • Accuracy. Division by hand is where cashiers make mistakes.
  • Honest bargaining. When the lot price is agreed, the rate is recorded as it really was, so your margin reports stay true.
  • Fewer disputes. What the customer pays matches the slip.

What to look for in billing software

  1. A choice of which figure is calculated. The cashier should be able to pick quantity, rate or total as the automatic one.
  2. A normal default. Most sales are quantity times rate, so that should be the starting point.
  3. Sensible rounding. Money should round to the paisa, and the printed total should match what is saved.
  4. The stock check still runs. A quantity calculated from a total must still be checked against stock on hand.
  5. The same behaviour on all sale screens. Cash sales, credit invoices and purchase bills should work the same way, so staff learn it once.

Common mistakes

  • Typing the total and also the rate and quantity by hand. The three then disagree.
  • Rounding the rate and leaving the total wrong. Keep the total as the customer paid it.
  • Ignoring stock. A customer asking for Rs 500 of an item that has only 1 kg left must be stopped.
  • Mixing weights and counts. Keep the product's unit clear on the slip.

How OneAccounts does it

On every line of a cash sale, there are three boxes: Quantity, Rate and Total. One of them is locked and calculated automatically, shown with a soft tint. By default, Total is the locked one, so entering quantity and rate gives the total.

To change what is calculated, click the small lock inside the box you want to be automatic. Lock Quantity, and entering the total and rate gives the quantity. Lock Rate, and entering total and quantity gives the rate. The box that becomes automatic is skipped when you press Tab, so the cashier moves straight through the boxes that need typing.

The calculated quantity shows to three decimals, and line totals are held to the paisa so the screen agrees with the saved sale. The stock check still applies, and the cash sale can be saved with full or part payment. The same Quantity, Rate and Total boxes work on credit sales invoices and purchase bills.

See cash sales vs credit sales and Trading ERP software.

Frequently asked questions

Can I sell by amount, for example Rs 500 of an item?

Yes. Lock the Quantity box, enter the rate and the total, and the quantity is worked out for you.

Can I agree a lot price and have the rate worked out?

Yes. Lock the Rate box, then enter the quantity and the total. The rate is calculated.

Does the stock check still apply when the quantity is calculated?

Yes. If the calculated quantity is more than the stock on hand, the sale is stopped.

Does it only work for cash sales?

No. The same three boxes are on credit sales invoices and purchase bills.

How many decimals are shown?

Quantity and rate are shown to three decimals when calculated, and totals are held to the paisa.

Start calm. Stay calm.

Free trial for new companies, no credit card required. We help you bring over your opening balances.

WhatsApp us