Signed-in devices keep working for 7 days without internet.
Daily Audit Report
Open this in a browser to see the figures
Your phone is showing a quick preview, which is not allowed to run the code that fetches the figures. The file itself is fine — it needs a real browser.
On iPhone: tap the share icon (the square with an arrow) at the bottom, then choose Open in Safari or Open in Chrome. On Android: tap the ⋮ menu and choose Open in Chrome.
Saving the file to your phone first, then opening it from Files, also works.
Daily Audit Report
Retail Stores · Data cut-off
Prepared by
Auto-save on☁ Cloud off
View-only copy. Figures come from the audit team's shared sheet. Press 🔄 Refresh data for the latest, including any corrections made to earlier days.
Checklist
Score period
01Business Summary
02Audit ComplianceN/A rows are excluded from that store's score
03Cumulative Report Card—
Recurring Failuresmisses ÷ days the rule applied · in selected period
04Audit ObservationsPick a scenario, set the status, add detail
Observation
Status
Detail / stores
05Damage Verification
Store
Damage %
Evidence
Pictures
Status
06Corrective Actions
Action
Site
Severity
Owner
Raised
Due
Age
Status
07Sign-off
Audited by
Acknowledged by the client
Recorded when the manager or owner confirms they have seen the report.
It is a record of what was said, not a second signature.
🔒 This day is signed and locked. Nothing on it can be
changed until it is unlocked, and unlocking is recorded.
Clear this device and download again?
Set up this server
This creates the first administrator — you. It works once, and stops
working the moment your account exists.
Choose a new password
This link works once. Pick something you have not used elsewhere — at least
ten characters.
📷 Evidence picturesHeld on this device, and on the server when you are signed in
Pictures are shrunk on the device before they are
stored — a camera photo of several megabytes becomes about 120KB, which is plenty for an
audit and small enough to keep years of them. They are attached with the ＋ beside a damage
row or a corrective action.
⚑ Corrective actionsNothing closes itself — one good day is not a fix
Sync now?
Which sections to print?
The heading, score cards and footer are always included.
⚙ SettingsChanges apply to the report only after you press Save
File backup
Saves every stored day plus all settings into one JSON file you keep yourself. Use it before clearing browser data, when moving to another computer, or as a routine safety copy. Works with no internet. The cloud URL and token are left out of the file on purpose.
Companies
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.
Google Sheet sync
These two values belong to the company in use right now — editing them here also updates that company's entry in the list above. Backs the audit up to a Google Sheet through a Google Apps Script, so another computer can pick up the same data. The report keeps working with no internet — days are queued and go up on their own once the connection returns. Follow CLOUD-SETUP-GUIDE.md once to get the two values below.
You are signed in, so the
connection is handled for you. Your work goes to the audit server as you
make it, and this device keeps working without internet.
Leave on Automatic. Switch to Compatibility if uploads keep timing out.
Daily data
Sends only the days you have changed on this device, then brings back anything changed elsewhere. This is all you normally need.
Start fresh on this device
Wipes everything this browser has stored for the audit — days, archive and settings — then downloads it all again from the Google Sheet. Useful when you open a new version of the file in a browser that still holds older data. Anything not yet synced is lost, so sync or take a file backup first.
Occasional jobs
Use these on a new device, or if you suspect the sheet and this device have drifted apart.