Sign in

Used for the automatic Damage % row, the damage verification section and the report card columns.

Switching one off hides it and keeps everything already recorded — turn it back on and the history is there. It disappears from the PDF and the image export too, because those print what is on screen.

Use ▲ and ▼ to change the order the sections appear in. They are renumbered automatically, so the report is always 01, 02, 03 down the page.

The tables you paste from Excel move as one block and keep their own switches on the Extra table tab, because each one is switched on separately.

A site only answers the checks that apply to it, so a kitchen may have five applicable checks where an outlet has twelve. With pooled weights that makes the two percentages hard to compare: the same ten marks lost is a far bigger share of a small base. Balanced by severity scores each band on its own and then combines them, so the mix of checks at a site no longer decides how much a failure costs.

Add, rename, reorder or remove stores. Each store keeps a short code — historical data stays attached to that code, so avoid changing it once data exists.

The tick shows a field on the entry sheet. Switching one off hides it but keeps everything already recorded — turn it back on later and the history is still there. The letters set which kinds of site it applies to: Outlet, Kitchen, Both, Warehouse, Franchise. Fields in Calculated are worked out from other fields and cannot be typed into.

Rows of the Business Summary table. The key is what past data is stored under — leave it alone for existing rows.

Link a check to a figure and it marks itself as the Business Summary is filled in — useful for “Sales posted” or “No negative stock”, which simply restate what the numbers already show. Linked checks appear with a ⚙ and cannot be clicked.

Severity sets the weight — Critical 20, Major 10, Minor 5 — so nobody has to invent numbers. Choose Custom… to type your own weight for a check that matters more, or less, than the three standard levels. The letters set which kinds of site the check applies to; a kitchen never sees Counter closing and an outlet never sees Production.

Validations and their weights. A store's score = weight earned ÷ weight applicable (N/A rows excluded). Weights apply to past days too, so cumulative scores recalculate when you change them.

Severity controls the row colour: OK is plain, Review is amber, Investigate is red.

These settings only affect the management dashboard. The client report is untouched by anything on this tab.

Switching one off hides it and keeps everything behind it — turn it back on and the figures are there. Use ▲ and ▼ to change the order they appear in; the dashboard, the PDF and the image all follow it.

The dashboard counts negative-stock and late-submission incidents from these two validations.

Managers are assigned per store on the Stores tab — the dashboard rolls scores up by manager automatically.

Tables you fill by copying cells in Excel and pressing Ctrl+V — a stock count, a temperature log, a delivery list, anything already kept in a spreadsheet. They appear on the daily report under Audit Compliance as 02b, 02c and so on, are saved with the day like everything else, print with the report, and go out with the emailed one.

The limits, and why. Up to 8 columns and 500 rows per table, and the table says so when a paste was bigger — eight columns is as wide as a table can be and still be read on a phone. A paste carries the values only: bold, colours, merged cells and formulas do not come across, which is what keeps the report looking the same every day.

Name the columns here rather than pasting a heading row. People usually copy their figures without the headings — the header row is frozen at the top of their sheet — and then the first reading of the day silently becomes a heading.

Only a super admin sees this. Roles are enforced on the server, so a sign-in cannot give itself more rights by changing this page.

Signed in as —

Choose something only you know. Every other device signed in as you is signed out, so if somebody else has been using your sign-in they will stop.

Sends the report by email through your own Gmail account, so there is nothing to pay for. A Workspace account allows about 1,500 messages a day; a plain gmail account 100 — far more than a daily report needs. The Google Sheet connection must be working first.

Switching a block off does not delete anything — it stays on the report and in the attachment, it just stops taking up room in the email. What changed is the short list at the top: today's score against its 7-day average, the best and lowest site by name, any run of clear days, anything that has just changed for the worse, the most-missed check of the week and the state of the corrective actions. It is worked out fresh each day and leaves out whatever has nothing to say.

Whoever chases overdue actions is not always whoever reads the daily figures. These are separate messages with their own recipients, sent by their own buttons. Leave the address blank and the button stays off.

WhatsApp charges for automatic sending, so this stays free by preparing the message and picture for you to send. Add the numbers you use most — one per line, with the country code, and an optional name after a |.

Groups cannot be addressed directly by any app — use Choose a chat or group and pick it in WhatsApp.

Any day, not only the one on screen — if a client asks for last Tuesday, pick it here. The message is rebuilt from that day's saved figures.

A failed check becomes a task. Critical and major checks raise one automatically; minor ones can be raised by hand from the Actions panel. Each check's behaviour is set in Compliance rules.

Nothing closes itself. A check passing tomorrow does not close its action — one good day is not a fix. Done means the site says it is fixed; Verified means you confirmed it. Only the verified figure is reported as closed.

Failures before this day never become tasks — leave it empty to raise actions from every day you have. It is filled in with today the first time you switch corrective actions on, so turning the feature on does not hand you a month of tasks that were already late; a register that opens with forty overdue items teaches everybody that overdue means nothing.
Moving it earlier creates no old tasks on its own — an older day only raises one if you open and save it again — and anything already raised is never removed by it.

Tasks are the instructions you give somebody while you are checking their work — separate from corrective actions, which the system raises itself from a failed check. A task carries forward until it is closed, so a follow-up cannot be forgotten. Switch the section on in General to have them appear on the report as well as in the Tasks panel.

Help for the person filling the day in. Nothing here changes a figure or blocks a save.

A running count of what is still blank, and a quiet mark on any figure far from what that store usually does — while you still have the paperwork in front of you, rather than in tomorrow’s report. It compares each store against its own history, so a big outlet is not measured against a small one.

What can be attached as proof, and what is checked about it. Each of these is off until you switch it on.

A task can carry the screenshot of the problem, and its closing note the screenshot of the fix.

Fifteen seconds of speech where nobody would type four sentences — and it works in any language, today.

The report is generated fresh from the figures each time it is opened, so if a setting changes later, the report you open is not quite the one that was signed. This keeps the signed copy as a file — the one an auditor, a bank or an insurer will ask for. A correction adds a version; nothing is overwritten. Hosted accounts only.

Reads the date the camera recorded. A picture taken days before the day it is filed against is flagged — it is not refused, because there are honest reasons for it, but it is no longer invisible.

Counted from the day the check failed. Used to set the due date when an action is raised.

A new action is assigned to the site's accountant from the Stores tab, unless you type someone else on the action itself.

A checklist is a named selection from the library you already have — not a separate set of fields. That is deliberate: the field key is what every stored day, every archived summary and every corrective action is filed under, so keeping them means your whole history stays exactly where it is.

Leave a checklist with nothing ticked and it uses everything, which is what the daily audit wants. Switch checklists off and the app behaves exactly as it did before they existed.

One company, one Google Sheet. Each company keeps its own settings, its own saved days on this device and its own Apps Script link, so nothing can leak from one client's books into another's. Paste the Web App URL and token generated from that company's sheet, press Save companies, then pick the company from the selector at the top of the report.

·