Tax and GST

A small wholesaler's purchase bills and transport costs in one file

How a small wholesaler can keep each purchase lot's supplier bill, transport receipt and unloading cash together, with a worked landed-cost example.

Editorial illustration for A small wholesaler's purchase bills and transport costs in one file

Give every purchase lot its own file, and put three things in it: the supplier's bill, the transport receipt and a note of the cash paid at unloading. When all three sit together, you can see what a lot really cost you by the time it reached the godown, not just what the supplier charged.

Why one file per lot works better than one file per document

Most small wholesalers file by document type: all supplier bills in one bundle, all lorry receipts in another, cash chits in a drawer. It feels tidy, but when you want to know what a particular consignment cost, you are hunting through three places and guessing which freight slip belonged to which bill.

A lot file turns the question around. The lot is the unit, and everything that made it arrive is inside. It also gives your CA something easy to follow at year end: one bundle, one purchase, one total.

What goes into a lot file

  • The supplier's tax invoice or bill, with its number and date.
  • The transport receipt, often called the LR or bilty, plus the transporter's freight bill if it comes separately.
  • A small slip for unloading or hamali cash, signed or at least initialled by whoever paid it.
  • Any loading charge paid at the supplier's end, if you bear it.
  • A cover note with the lot number, supplier name, number of cartons or bags, and the date of receipt.
  • The proof of each payment: a bank transfer reference, a UPI screenshot or a cash voucher number.

Number your lots in the order they arrive, for example L-26-014 for the fourteenth lot of the financial year 2026-27. Write that number on every paper in the file and in the name of every photo.

A worked example with a general goods lot

Say Lot 14 is two hundred cartons of assorted packaged goods. The numbers below are made up to show the method, not typical prices.

ItemDocumentAmount in rupeesHow it was paid
Goods as per supplier billBill no. 44711,84,000Bank transfer
Freight from the supplier's townTransport receipt6,500UPI to transporter
Unloading at the godownCash slip, six labourers at 150900Cash
Landed cost of the lotCover note1,91,400Sum of the three

Landed cost per carton is 1,91,400 divided by 200, which is 957 rupees. The supplier's bill alone would have suggested 920 rupees a carton (1,84,000 divided by 200). That 37 rupee gap is easy to forget when you set a selling price, and it is exactly what a lot file keeps visible.

How do you record it in the bank sheet or tracker?

Record the three payments as three separate entries, because they went out through three different routes at different times. Give each the same lot number in its note. That way, when you filter your sheet or tracker for L-26-014, all three lines come up and add to the landed cost.

Keep the supplier payment and the freight payment apart even if the same person arranged both. Mixing them makes the bank line impossible to match to a bill later.

What if freight is billed separately, or for several lots at once?

Transporters often send one freight bill covering several consignments. Keep the original bill in the file of the first lot and put a photocopy or phone photo in the others, each marked with the lot numbers it covers. Then split the freight in your own sheet in proportion to something sensible, such as cartons or weight, and write down which method you used so the split is repeatable.

Where an expense tracker helps

If your payments run through a bank account or card, importing the statement into SpendixAI gives you every debit in one list, and you can review the rows before saving. Cash items such as unloading can be added by hand, several at once, and a receipt photo can stay with its transaction. It is a place to hold the records, not a stock or invoicing system, so keep the lot cover note as your link between paper and entries.

A short checklist for every new lot

  1. Assign the lot number the day the goods arrive.
  2. Check the carton count against the bill before the driver leaves, and note any shortage on the receipt.
  3. Put the bill, transport receipt and cash slip in one folder or envelope.
  4. Enter the three payments with the lot number in the note.
  5. At month end, add each lot's total and compare it with your bank sheet.

Rules on invoices, input credit and freight can be specific to your trade, so ask your CA which details they want on the paperwork and follow that.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports