In the world of handmade production, material prices are rarely static. When the cost of a specific gemstone, a yard of organic linen, or a spool of specialized thread rises, every product in your catalog that uses that material technically has a new production cost.
From a management perspective, this creates a significant hurdle. As your product catalog grows, manually hunting down every affected item to update its cost becomes tedious and increasingly prone to error. It is easy to miss a few products, leading to outdated records and a skewed understanding of your actual profit margins.
The principle: “link, don’t hard-code”
The most effective way to handle these fluctuations is to move away from “hard-coding” numbers—that is, typing a static cost figure into a record—and instead use a linked system.
In a spreadsheet-based workflow, this is achieved through cell formulas. Rather than typing the material price directly into a product row, you reference a specific cell on a dedicated “Materials” sheet. By linking these cells, updating the price in one single location automatically ripples the change through every product formula that references it. This “link, don’t hard-code” approach ensures that your data remains consistent across your entire management system without the need for manual searching.
Current cost vs. historical records
When designing a recording system, it is important to distinguish between two types of data:
- Current Product Cost: This should reflect today’s market prices for materials so you can make informed decisions about your current catalog.
- Past Sales Records: These should remain “frozen” at the cost that existed at the exact moment of the sale.
Maintaining this distinction ensures that if you change a material price today, it does not retroactively change the profit figures of an item you sold six months ago. While the sales-side logic of “cost snapshots” is a deeper topic covered in another article, keeping these two values separate is vital for accurate long-term bookkeeping.
Automatic recalculation in MakerNote
We built MakerNote to implement the “link, don’t hard-code” principle automatically, removing the need for manual formula-writing.
The app utilizes a relational structure where product costs are not stored as fixed numbers. Instead, a product’s cost is calculated live using the current unit prices of its linked materials. The calculation follows a strict formula: Σ(Material Unit Price × Quantity Used) + Labor Cost + Other Cost.
When you update a material’s unit price within the app, the system instantly recalculates the cost for every product tied to that material. To prevent accidental data changes, the app provides a confirmation prompt whenever you edit a material that is already linked to existing products, ensuring you are aware of how the change will impact your catalog.
Streamlining your workflow
Spreadsheets and dedicated apps both rely on the same fundamental logic: centralizing material data so that updates are efficient and reliable. While a spreadsheet offers high flexibility for those comfortable with formulas, a dedicated tool like MakerNote provides the same relational benefits in a mobile-optimized interface without the setup overhead.
MakerNote is available with a Free Tier (allowing up to 50 materials and 20 products) for those just starting their recording habit. For larger catalogs, the Pro Tier is available as a one-time purchase, offering unlimited registrations, a comprehensive profit dashboard, and finished-goods inventory tracking.
Download MakerNote on the App Store: https://apps.apple.com/us/app/makernote/id6762747060
Summary
Relying on manual updates for every material price change is a significant drain on a creator’s time and risks the accuracy of financial records. By adopting a “link, don’t hard-code” approach—whether through spreadsheet formulas or the automated relational structure of an app—you ensure that your production costs are always reflected accurately in real-time. This structural discipline is what allows a handmade business to scale without losing sight of its true margins.
For the material fields this calculation depends on, see our guide: Beyond the Price Tag: The Material Fields Worth Recording
For a broader look at how these records fit into a full recording system, see our hub article: Notebook, Spreadsheet, or App? Making Your Craft Costs Actually Add Up
This article’s sources: Reconstructed by the editorial team from official sites, public information, and specialist media, from a recording and organizing perspective. Numeric, spec, and safety-related statements prioritize primary sources.
For decisions about pricing or financial management, please consult a tax or accounting professional.
This article organizes information from a recording and organizing perspective. If you notice an error or outdated information, please contact us. Last verified: August 2026
