ABCDEFGHIJKLMNOPQRST
1
Instructions
IMPORTANT: Every single item should have its own row. If you buy 10 of the same item, you should have 10 rows that are copies of each other.
2
Date you purchased the item
Location (store or website)
Price you paidRetail value
Can use something like "Sold," "Used," or "Gifted" to indicate that the item is no longer available. Can use "Expired" to indicate that an item had to be tossed. Make sure to update the Status filter in Summary tab to exclude whichever status values you are using to indicate that the item is no longer available. I generally also recommend indicating whether an item is BNIB, BNIP, swatched, etc.
Price you want to sell this item at (each item can have its own sell price)
Who you sold/gave it to, or "expired" if expired
Date it was sold/used/gifted/expired
Enter "Yes" if you used it for yourself or gave it away. Leave blank or enter "No" if you sold it or it expired.
3
Date of purchase
LocationCategoryProduct TypeProduct subtypeBrandItem nameIngredientsColorSizeRelative sizeExpiration dateNotesCostRetail valueStatusSell priceRecipientDepletion datePersonal use
4
3/23/2022SephoraSkincareCleanserSecond cleanseSunday RileyCeramic slip cleanser150mlFull size3/1/25$16.00$35.00Used$18.00Me3/23/2022Yes
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
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