Track Press-On Nail Decoration Supplies and Project Allocations

If your rhinestones, charms, foils and stickers are scattered across drawers and you keep promising the same pieces to two different sets, you need two simple records: an inventory of what you have, and a ledger of what each project has claimed. Both work in a free spreadsheet or a paper notebook. What matters is that every quantity comes from an actual count, every row uses one consistent unit, and reserved supplies are kept separate from supplies that are still free to use.

The short answer

• Give each distinct material its own row with an ID, the identifiers printed on its label and a single counting unit.
• Record only quantities you have checked against the actual package, and note when and how you checked.
• Log project reservations in a separate ledger instead of subtracting them from stock.
• Calculate the unallocated balance as verified on-hand quantity minus active reservations, in the same unit.
• Reduce on-hand stock only when material is actually used.

Set up the inventory worksheet

One row per material keeps counts clean. If two items differ in color, size, shape or finish, or are counted in different units, give them separate rows. Copy the manufacturer name and any product identifier exactly as printed on the label. If the label shows no product code, leave that field blank rather than inventing one; your own material ID is what keeps the row unique.

Column	What to enter
Material ID	Your own short code, such as RS-001
Description	Plain wording, such as flatback rhinestones
Manufacturer / product identifier	Copied exactly from the label; blank if none is printed
Variant	Color, size, shape or finish that distinguishes this row
Package reference	Which bag, jar or box the material is in
Counting unit	Pieces, packages, sheets or another single unit
Verified quantity on hand	The number you actually counted
Verification date / method	When you checked and how, such as hand count or unopened package
Project allocations	Total currently reserved, taken from the ledger
Unallocated balance	On hand minus active reservations

Verify quantities before you enter them

The number printed on a package tells you what it held when it was sealed, not what is left after you've been using it. Keep those two things apart.

• Inspect the actual package and its label before typing anything.
• For opened packages, count the remaining contents and record that count as on hand.
• For unopened packages you haven't counted, use packages as the unit, for example 3 packages, rather than multiplying out an assumed piece count.
• If you haven't checked a quantity yet, mark it as unverified. Don't enter zero, because zero means you checked and found none.
• Update the verification date and method each time you recount.

Track project reservations in a separate ledger

A reservation sets material aside for a planned set without removing it from your shelf. Keeping reservations in their own ledger shows you both what you physically have and what is already spoken for.

Column	What to enter
Material ID	Matches the inventory row
Project ID	Your name or code for the set, such as Spring-Floral-01
Reserved quantity	How much the project needs
Unit	Must match the inventory row's counting unit
Reservation date	When you set it aside
Status	Active, consumed or canceled

These rules keep the two records in agreement:

• Making a reservation leaves the on-hand count unchanged.
• Using reserved material reduces both the on-hand count and that reservation by the amount used.
• Canceling a reservation releases it and leaves the on-hand count unchanged.
• Only active reservations count against the unallocated balance.
• If an unallocated balance goes negative, you've promised more than you have. Recount the material and adjust or cancel a reservation before you start the project.

Worked example (invented numbers)

These figures are made up to show the bookkeeping. They are not a recommendation for how many decorations a set needs.

Verified count:            48 decorations on hand
Project A reserves:        12
Project B reserves:         8
Unallocated:               48 - 12 - 8 = 28

Project A uses its 12:
On hand:                   48 - 12 = 36
Active reservations:        8 (Project B)
Unallocated:               36 - 8 = 28

The unallocated balance stays at 28 because Project A used material that was already reserved. Only new reservations, cancellations, recounts or unplanned use change what's actually free.

Keep this sheet focused

This worksheet tracks raw decoration materials and who has claimed them. Keep finished press-on sets, physical storage layout and kit checklists in their own records so each list stays easy to update. The sheet also doesn't tell you which decorations work with which nail glue or top coat, how long a product lasts, or what a set requires. For those questions, check the directions for the specific product you're using.

Next step

Pick one container of decorations, inspect each package, and fill in the inventory rows using only what you can verify from the label and a count. Then add a ledger row for any set you're currently planning. Once the unallocated balances look right for that container, move on to the next one.