Excel / Email vs. Compliant IA

Time Savings Graph

Most customers come to Compliant IA with an existing retail audit workflow developed in house. It usually involves Excel™, email, phone calls and a large investment in human sweat equity to compile the data that was collected. Anyone who has ever experienced the pain of collecting, distributing and compiling data like this will invariably think…there has to be a better way!

Let us take your through the life cycle of the audit, with Excel/Email vs Compliant IA.

Step 1: Schedule the audit

Execute brand standards, programs and operations
Start a FREE trial of Compliant IA. Get professionally vetted checklists, commercial-grade workflows, time-saving automation and reporting.

Excel™ and Email

The auditor schedules the audit using the company’s group calendar application. But watch out! Some audits are unannounced and should not be disclosed to the store’s management ahead of time. So schedule and notify recipients carefully!

Compliant IA

Log-in to Compliant IA.  Schedule a audit with the built-in calendar. Check-off whether the audit is announced or not. Let Compliant IA do the rest: handle all the messaging, send reminders and control visibility by user role.

Step 2: Prepare for the audit

Excel™ and Email

Dig up these old reports! Check your emails and notes. Compare and analyze past audits.  Manually compile and look for trends, repeat unacceptables and location to district averages.  If you have any notes, prepare them ahead of time and save them to the Excel™ spreadsheet.

Compliant IA

Log-in to Compliant IA. Look up the store and past audits, pull ready-made reports and look at the trends, repeat unacceptables and location to district averages.  Add your notes to the scheduled audit (notes will be automatically rolled into the audit when it starts).

Step 3: Conduct the audit

Excel™ and Email

Using your laptop, open the Excel™ spreadsheet for the audit. Include the information about the store, information about you and the current date and time. Now fill-out the form. Be careful not to drop your laptop as you walk around and remember to click save often not to lose any data!

Compliant IA

Log-in to Compliant IA using a smartphone, tablet or laptop. Click “Start inspection”.  Geolocation selects the location you are in, all location details and dates are pre-set. Walk around the location and fill-out the form (one hand operation can be used on the mobile). Don’t worry if your device loses battery, or if you want to use a different device, you can switch device at any time and pick up where you left off!

District manager retail audit in a store with a tablet

Step 4: Action plan and follow-up

Excel™ and Email

Finalize the audit spreadsheet and create an action plan. Email this audit and action plan to the store and perhaps copy your director. Remember to follow up with the store in a week to make sure that deficiencies are being addressed. If you manage multiple stores, you will need a process to manage audits, follow-ups and reminders.

Compliant IA

Assign deficiencies to individuals using the built-in action plan. Let the system contact the individuals responsible and let the system indicate what has or hasn’t been done, by whom, where and when. You can get an up-to-the-minute report, for one store or all stores, at any time.

Step 5: Reporting

Excel™ and Email

Want to know your best/worst locations, items, regions and programs?  It’s data-crunching time with Excel™!  You will soon experience a syndrome known as “Excel Induced Headache”. Excel™ is a powerful business tool but it was never designed for complex data analytics (of course, you already know this, you have just spent 4 hours trying to compile data across a dozen spreadsheets).

Compliant IA

Log-in to Compliant IA. Chose one of the 27 canned reports. Best and worst locations, items, programs, etc… Look at trends, repeat unacceptables… No calculations, no formulas, no linked spreadsheets to deal with. Just “click” and have your data summarized and compiled.  And yes, you can still use Excel™!  All Compliant IA reports are exportable to Excel™ or PDF.

One More Thing...

Winning brands execute brand standards. This is why Compliant IA makes execution easy with checklists, tasks, action plans and corrective actions at every location.
Execute brand standards, programs and operations
Start a FREE trial of Compliant IA. Get professionally vetted checklists, commercial-grade workflows, time-saving automation and reporting.

Leave a Reply