How to Track Consumables by Quantity or Volume
Keep track of bulk consumables like paint, flakes, fabric, chemicals, or raw materials by the total amount on hand, so you don't have to count each individual unit. You set up one item in the unit you measure in, subtract what your team uses, and Sortly keeps the running total for you. This article walks you through creating the item, subtracting what you use, and monitoring and replenishing your stock.
In this article
When to use this method
Use this method when you don't need to track each individual unit, only an accurate running total. For example, you might want to know how many yards of fabric or gallons of paint you have left, not which roll or can was used.
Create the item
Subtract the quantity used
When your team uses material for a job, update the item's quantity so the total stays accurate.
The total quantity in stock goes down right away. To track usage by project, you can also move that amount into a job folder or location folder.
Monitor and replenish
- Update the total quantity whenever you receive new stock.
- Use reports to track consumption trends.
- Add custom fields if you want to record more detail, such as supplier, batch, or purchase date. You can create them with Add Custom Field on the Custom Fields page.
Tips and best practices
- Use the smallest unit of measure possible. For example, track individual straws instead of boxes of straws for more accurate stock counts. This gives you flexibility when subtracting smaller amounts.
- Set up low stock alerts so you're notified before you run out and can stay ahead of reordering.
- Move quantities into job or location folders whenever they're used. This makes reporting more accurate at the project level.