Field reporting for FMCG distributors: beats, orders, deliveries and collections

FMCG and distribution businesses need four facts from the field every day: which outlets on the beat were covered, what they ordered, what was delivered, and how much was collected. Outstanding follows from the last two. When these arrive late or in different shapes from every salesman, stock planning, credit control and salesman performance all become guesswork. This guide covers the reports distributors actually need and how to keep them flowing.

How a distributor's day works

A typical distributor of biscuits, soaps, packaged food or beverages runs a few order-booking salesmen and a few delivery vans. The pattern is familiar:

1. Morning: salesmen go out on their beat for the day, a fixed list of kirana stores, medical shops and general stores.
2. At each outlet: check stock, take an order, collect payment against earlier bills, note any complaint or scheme request.
3. Evening: orders come back to the office for billing and loading.
4. Next day: vans deliver the orders and often collect cash on delivery.

Every step produces information the owner needs, and every step is done by someone who is out of the office.

The daily problems

• Beats not fully covered. A salesman visits the easy outlets and skips the far ones. Without a visit record for every outlet, you find out only when that outlet's orders stop.
• Orders arrive late or unclear. Orders phoned in at 8 PM, or written in a notebook in shorthand, delay billing and loading for the next morning.
• Collections that do not match. Cash, UPI and cheques collected across twenty outlets are reported as one total at night. When it does not match what was handed in, nobody can say which outlet the gap is from.
• Outstanding nobody trusts. If collections are not recorded outlet by outlet, the outstanding list is always a few days behind. Credit gets extended to outlets that have not paid.
• Delivery problems heard late. Short supply, damaged cartons and refused deliveries come back as verbal complaints days later.
• No-orders go unrecorded. Salesmen report what they sold, not where they failed. You lose the reasons: stock still full, competitor scheme, shop closed.

The report formats a distributor needs

You do not need twenty reports. Four, filled in reliably, cover most of the business.

1. Beat report / daily sales report

One row per outlet visited, from each salesman. Columns: date, salesman, beat, outlet, outcome (order, no order, shop closed), products and quantity, order value, next visit. The daily sales report format has a free Excel template for exactly this.

2. Order booking sheet

One row per product per outlet, so the billing team can raise invoices and load vans without calling the salesman. Columns: date, salesman, outlet, product, quantity, unit (box, case, piece), delivery date, payment terms.

3. Delivery report

From each van or delivery person: outlet, invoice number, delivered in full or short, damages, cash collected on delivery, and a photo of the signed challan where needed. See the delivery report format for a full template.

4. Collection report and outstanding

One row per payment received: date, collected by, outlet, amount, mode (cash, UPI, cheque) and cheque number if any. Outstanding per outlet is then total invoices minus total collections, which any spreadsheet can calculate once both are recorded outlet by outlet.

Rules that make distributor reporting work

• Every outlet on the beat gets a row, including no-orders and closed shops. Coverage is measured by rows, not by sales.
• Record collections at the outlet, one entry per payment, with the mode. Never one total at night.
• Keep one outlet master list. "Jai Ambe Kirana" and "Jay Amba Stores" must not become two customers with two outstanding balances.
• Keep orders and collections separate. An order on credit is not money received.
• Review the same evening. A skipped outlet or a cash gap found the same day can be fixed the next morning. Found at month end, it becomes an argument.

vBol for distributors

Distribution salesmen are rarely short of information. They are short of time and patience for typing it. vBol lets them report each outlet as a WhatsApp voice note, in the language they already speak, straight after the visit:

vBol transcribes the note, fills in the fields of your record type (such as a sales visit with customer, outcome, quantity and amount collected, or an order with product, quantity, unit and delivery date), and reads it back on WhatsApp in the salesman's language. He taps to confirm or fix a field; nothing is written until he confirms. The confirmed record becomes a row in your Google Sheet, an Excel workbook on OneDrive or SharePoint, or the matching module in Ekatm ERP, with photos such as a signed challan and the GPS location attached.

At 7 PM you get one WhatsApp message listing what each salesman and delivery person filed today, and who sent nothing. Large expenses get their own flagged line. There is no app to install, no login and no training; Vritti sets up your record types and sheet with you. Salesmen can report in Hindi, Marathi, Gujarati, Tamil, Telugu, Kannada, Bangla, Punjabi, Malayalam, Odia, Urdu or English.

It is free for 30 days (up to 5 confirmed reports per person per day during the trial), then ₹199 per user per month for teams of up to 100 users; larger distribution teams get a custom plan. See pricing.