SnotraSheets 1.0.2 — Square changed-stock practice
Perunlight, 6 October 2026. Fictional Juniper & Wick shop. AI-assisted teaching material.

Free sample inputs, checked reports and screenshots. The paid app is separate.
Instructions: https://perunlight.com/guides/square-stock-count-items-sold-during-count/
Full manual: https://perunlight.com/guides/snotra-sheets/
App: https://perunlight.com/store/snotra-sheets/ ($9.99 once)

Use a new session with fictional files only:
1. Extract the paid SnotraSheets-1.0.2.zip and open SnotraSheets.html in desktop Chrome.
2. Load inputs/1-library-export-before-count.csv. Select Main Street.
3. Import front-shelves-usb-scanner.txt and back-room-phone-app.csv from inputs/2-counts.
4. Try the file marked (sent twice). Identical contents must be refused.
5. Add a list called Counter and scan JW-SNUF once.
6. Assign ambiguous barcode 851234004117 to Brass Wick Trimmer for this answer key.
   Ignore unknown code 036000291452 and damaged code 8.51234E+11 for the exercise.
   In a real count, identify/recount these items before relying on the result.
   Ignoring is not a repair.
7. Load inputs/4-library-export-after-count.csv as the fresh export.
8. Review three blocked rows and the disabled Square import button.
   Download Variance report and Exceptions; compare against checked-output.
   These reports concern Main Street even though the current variance CSV leaves
   its Location cells blank. Record the chosen location alongside shared reports.

Expected: 26 rows, 24 counted rows, 366 counted units; 11 rows with variance (+1 / -18).
Blocked: JW-CED-08 baseline 14, count 13, fresh 12;
JW-MUG-SAN baseline 6, count 6, fresh 5; 000451 baseline 48, count 46, fresh 45.
The UI shows 9 rows to write, but the entire store import remains blocked.
JW-WRAP has 40 counted units with tracking off and is not written.
JW-DIP is uncounted and left unchanged. Nothing has been sent to Square.

Quantity snapshots do not prove the cause or timing of a movement.
If exactly three cards sold with no other movement, a count of 46 before those sales
would become 43; a count of 46 after the sales would still be 46.
This hypothetical example is not transaction evidence.
Pause movement, take a new baseline and recount changed rows.
Keep movement paused through import. Do not remove the fresh export to enable download.

Checked using the unchanged paid 1.0.2 app, Chrome 152 on Linux, offline.
Independent source arithmetic was compared with all 26 exported report rows.
No merchant import or other browser was tested. Check Square's import preview.
No claim is made that these fictional tokens are accepted by a real Square store.
Do not import the example files into a real store.

Files only; one location per session. No direct Square connection, serial/lot tracking
or inventory valuation. Square .xls/.xlsm is unsupported.
Square documentation: https://squareup.com/help/us/en/article/5153-import-items-online
Perunlight is not affiliated with Square or Block, Inc.

You may copy, adapt and share the fictional practice files with attribution to Perunlight.
The paid app has its own separate license.
