Most wine-shop owners keep three kinds of stock records for the excise side of the business: a daily register, a period register every fifteen days, and a monthly return. They all describe the same bottles, so when they are written by hand from different notebooks, they rarely agree.

The daily register (FL-3A)

For each brand and bottle size, the daily register shows the opening stock, what was received, what was sold and the closing stock. Tomorrow's opening is today's closing.

The Chatai (FL-3 period register)

The Chatai covers a fifteen-day period — the 1st to the 15th, and the 16th to the end of the month — with the same brand-and-size rows totalled for the period.

The monthly return (FLR-4)

The FLR-4 groups stock by class and size — spirits and wines (Indian made and imported), fermented and mild liquors, bitters — on the April–March excise year.

An illustrative day

Illustrative numbers, not a real shop: a whisky in 750 ml opens the day at 30 bottles. A TP brings in 24. The counter sells 12. The closing is 30 + 24 − 12 = 42 bottles, and 42 becomes tomorrow's opening. The Chatai adds up fifteen such days; the FLR-4 adds up the month by class and size.

The rule that keeps all three in agreement: every bottle in or out is recorded once, as a stock movement — receipt, sale, breakage or adjustment — and every register is calculated from those movements.

How HotelBarDost Wine builds them

  • Daily Stock Register (FL-3A), Chatai — 15-day period register (FL-3), Monthly Return — Form F.L.R. 4, Month-wise statement, Litre-wise summary — all from one stock ledger.
  • Sections by class: spirits and wines (Indian and imported), fermented, mild, Maharashtra-made and bitters.
  • Breakage recorded separately from sales; snacks kept out of the registers.
  • PDF export for every register; CSV for the daily register and month-wise statement.
  • Register titles available in Marathi as well as English.

HotelBarDost Wine prints these registers in the layout used by our wine-shop clients. It is not a government-approved form and it submits nothing to the excise department. Check the format your licence needs with the Maharashtra State Excise department (stateexcise.maharashtra.gov.in) or your excise consultant.