ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
InventAsset Stock In/Out
2
DEMO, view only. Get your own editable copy: https://cosminflare.gumroad.com/l/stock-in-out-inventory-tracker
3
4
Business name
Maple Lane Café Supplies (demo)
CurrencyUSD
5
6
Go
7
1. Categories & units (Master Data)
8
2. Add / edit items
9
3. Record Quick Entry
10
4. Review Stock Status
11
12
At a glance
13
Active items8
14
Units on hand334
15
Reorder now2
16
Out of stock1
17
Data to fix0
18
19
Formula healthOK
20
21
What can I edit?
22
Light gray = user input
Calculated / status = darker gray (the sheet fills it), white, green, yellow, red
23
Lock = System ID, Check, Item choice, Stock Status, 99_Lists. You may rename items; never change System ID — Stock Status keys on it.
24
25
Needs reorder
26
Paper Cups 8oz — 25 left, reorder at 30
Gift Bags Medium — 12 left, reorder at 20
27
28
29
30
If Check is not READY — next action
31
MISSING … → fill the named light gray field. FIX ITEM → pick Item from dropdown. FIX ACTION → pick a listed Action. FIX QTY → quantity must be > 0. DUPLICATE DOCUMENT LINE → change doc type, reference, item, or action. Only READY rows change Stock Status.
32
33
34
35
Edition
36
This is the Standard Edition (formulas only). No Apps Script and no authorization prompt. Never paste scripts into this copy.
37
38
39
40
Undo tip
41
Broken formula → File → Version history → restore. Clean-copy recovery: paste light gray inputs only; never paste System ID / Check / formulas.
42
43
44
Capacity: 200 items · 1000 Quick Entry lines · 100 Master Data rows per table.
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100