vBol/ Guides/Retail store audit format
Free template

Retail store audit checklist format: free merchandising template

What a retail store audit should check, a filled-in example covering shelf, stock, display, pricing and photos, and a free Excel template. Written for field merchandisers and the managers who review their visits.

Updated 30 September 2026 · by the vBol team at Vritti
Also in: ಕನ್ನಡ

A retail store audit is a short visit in which a merchandiser checks how your products are actually shown in a shop: what is on the shelf, whether the display is up, whether the prices are right, and what the competition is doing. The checklist format below turns that visit into one row per store, with a photo for evidence.

What a store audit should check

Audits fail when they become long. A merchandiser with 15 stores to cover has a few minutes in each. Keep to checks that lead to an action, and prefer a yes/no or a number over a paragraph.

CheckWhy it mattersExample
Date, merchandiser, storeWho audited which store and when; needed to compare visits over time.30-09-2026, Meena Joshi, Sri Vinayaka Mart
Shelf facingsThe number of your product units visible at the front. A direct measure of shelf presence.6
Stock statusIn stock, low or out of stock. Empty shelves are lost sales.Low
Display in placeWhether the agreed display, stand or POSM is up and in good condition.Damaged
Price tag correctWrong or missing prices cause complaints and lost impulse purchases.Missing
Near-expiry stockOld stock left to expire is a loss and a quality risk for the brand.Yes
Competitor activityRival offers, displays and price changes, noted briefly.Rival combo offer
PhotoEvidence of the shelf on the day.Yes
Action neededThe next step and who owns it. Without this, an audit is only an observation.Replace display stand

A filled-in example

Three stores in one day, from a healthy shelf to an empty one.

StoreFacingsStockDisplayPrice tagExpiryAction
Sri Vinayaka Mart6In stockYesYesNoNone
Lakshmi Provision Stores3LowDamagedMissingYesNew stand, refill 2 SKUs
Fresh Basket Supermart0Out of stockNoNoNoUrgent supply, discuss end-cap

The first store needs nothing. The second has four small problems that can each be fixed on the spot or on the next visit. The third is the one that needs a manager: an empty shelf next to a rival's display is money being lost every day.

Six rules for useful audits

  1. Use the same checklist every time. Changing questions makes month-on-month comparison impossible.
  2. Fixed answers over free text. Yes / No / Damaged can be counted; "display looks a bit tired" cannot. The template uses dropdowns.
  3. Photo every audit. Take a wide shot of the whole shelf, then a close-up of any problem.
  4. Count facings, do not estimate. A number is comparable across stores and weeks; "good" is not.
  5. Record the action and the owner. "Raise urgent supply" should reach whoever handles supply, not stay in the sheet.
  6. Note competitors factually. "Rival combo offer, ₹10 off" helps; "they are doing better" does not.

Reading the results

Once a week, count instead of scrolling. For each check, divide the number of stores with a problem by the number audited: in the example, 1 of 3 stores is out of stock, 2 of 3 have no correct price tag, and 1 of 3 has near-expiry stock. Sort by area to see whether the problem is one distributor's supply or the whole city. Group the Action needed column by owner, supply, sales or the merchandiser, and send each list to that owner. Then re-audit the flagged stores first next week and note whether the problem is closed.

How often to audit

There is no single right frequency. Fast-moving products in busy stores change on the shelf within days, so many teams check them on every beat visit. Slower categories or small shops can be audited monthly. Start with a schedule you can actually keep, review the sheet after a month to see which stores change often, and visit those more. Auditing the same twenty stores well beats auditing two hundred badly.

Common mistakes

  • Building a 40-question audit that gets ticked without looking.
  • Filling the sheet from memory at the end of the day, when the shelf details are already blurred.
  • Photos taken but never linked to a store and date, so they cannot be found later.
  • Auditing stores but never reviewing the results.

Doing the audit in the aisle, not at night

The checklist is short, but a paper form or a shared spreadsheet means typing thirteen fields per store and looking for the photo afterwards. Merchandisers often skip the typing and the audit becomes a folder of unlabelled pictures.

vBol handles this over WhatsApp. At each store the merchandiser saves one number as a contact, then sends a voice note and a photo of the shelf, in their own language:

ಲಕ್ಷ್ಮಿ ಪ್ರೊವಿಷನ್ ಸ್ಟೋರ್ಸ್‌ನಲ್ಲಿ ಶೆಲ್ಫ್‌ನಲ್ಲಿ ಸ್ಟಾಕ್ ಕಡಿಮೆ ಇದೆ. ಡಿಸ್ಪ್ಲೇ ಸ್ಟ್ಯಾಂಡ್ ಒಡೆದಿದೆ, ಬೆಲೆ ಟ್ಯಾಗ್ ಇಲ್ಲ.

vBol transcribes it, extracts the fields, and reads the record back on WhatsApp in the same language with buttons to confirm or fix a field. Nothing is written until it is confirmed. The row lands in your Google Sheet, an Excel workbook on OneDrive or SharePoint, or Ekatm ERP, with the photo and GPS location attached to it. A store audit is not one of vBol's built-in record types (those are sales visit, order, service job, meter reading, expense, complaint and site report). Vritti sets up an audit record with the checks above along with you, together with the destination sheet.

At 7 PM each evening the manager receives one WhatsApp message: what was filed, by whom, and which merchandisers sent nothing. Merchandisers install no app, have no login and need no training, and it works for a team of five or five thousand. vBol is free for 30 days (up to 5 confirmed reports per person per day), then ₹199 per user per month for teams of up to 100 users, with a custom plan for larger ones. See pricing.

To start on a spreadsheet, download the free template on this page. It has the columns above, dropdowns for stock, display, price tag, expiry and photo, and example rows. For visits to markets and outlets that are not store audits, see the market visit report format.

Frequently asked questions

What is a retail store audit?

A retail store audit is a visit in which a merchandiser or field executive checks how a brand's products are shown in a shop: stock on the shelf, display, pricing, expiry dates and competitor activity, usually with a photo.

What should a retail audit checklist include?

Shelf facings, stock availability, display or POSM condition, price tag accuracy, near-expiry or damaged stock, competitor activity, a photo of the shelf and any action needed. Keep each item to a quick yes, no or count.

How often should a retail store audit be done?

It depends on the category and store importance. Fast-moving FMCG in busy stores is often checked on each beat visit; smaller stores may be audited monthly. Match the frequency to how quickly stock and display change.

Why take a photo during a store audit?

A photo shows the shelf as it actually was, settles disputes with the store or the distributor, and lets a manager review many stores without visiting each one.

Related guides