GEMINI BUILDING MATERIALS v8.5Stock Audit
This app is for official audit use. All activity is recorded.
Total counted by everyone in your audit, and who counted where. Read only.
| Code | Product | System | Total |
|---|
One audit per store visit. Each audit has its own product list, auditors, dashboard and reports.
Live progress of every login assigned to this audit. Tap View to see one auditor's counts on the Dashboard.
| Login | Name | Entries | Products | Status | Edit past days | Actions |
|---|
Tip: in Excel press Ctrl+A to copy the whole sheet, so the column letters match Excel. Then click below and press Ctrl+V.
Audit Manager only. Applies to all audits.
Final submitted Still counting
Short Excess · only products with a store count
Choose the audit above, then download.
Asks where to save, then creates a folder with the Excel, PDF and a Photos folder. The Excel photo links open from that folder.
Or download one at a timeDeletes this whole audit from the online database: counts, photos, notes, auditor status, its product list and the audit itself. Its logins become Unassigned for the next audit. Other audits are not touched. It can't be undone.
For audits over several days. Each day's counts are shown side by side and added together (same as the Dashboard). In and Out (dump taken at 5:00 PM) are added only from the days after the day each product was last counted. Upload each day's In and Out dump on its card. Final count = Count + In − Out.
No counts yet. Day cards appear here automatically when products are counted, or tap Add day.
| Code | Product | Count | In | Out | Final (Count + In − Out) |
|---|
Choose the two Excel files. Rows are matched by code. Then add your calculations.
Tap a calculation to change it, 🗑 to remove it.
Every count is saved a second time in a protected backup at the same moment. Backups stay 10 days after an audit is cleared. Restoring creates a new audit, so nothing running is overwritten.
Restore from a backup ExcelUse a Backup Excel downloaded here. Admins can restore only their own store's backup.
Same product kept in another place?
The admin adds the store quantity later.
The Audit Manager paused the audit. Your counts are saved.
Please wait. It continues automatically.
Upload the store's Excel. Choose the code column and the count column. The count is matched to the master list by code.