For many handmade creators, tracking the financial side of a hobby or small business can be a significant challenge. A common issue is the “hidden loss”: a creator might estimate material costs roughly but forget to factor in labor time, packaging, or small hardware. Without a structured way to record these details, a sale that appears successful on the surface can quietly be unprofitable.
As developers of recording tools, we approach this problem from a management design perspective. The goal is to move from rough estimation to a reliable system of records that makes the true cost of creation visible.
The three pillars of handmade records
A robust management system is built on three interconnected pillars: Materials, Products, and Sales. By organizing data into these categories, you can ensure that every cost is accounted for and every profit is accurately calculated.
1. Material Records (The Foundation)
Every project begins with raw materials. Tracking these at the individual unit level is essential for accurate cost modeling.
| Field | Purpose |
|---|---|
| Material Name | The specific identifier for the item. |
| Unit Price | The cost paid per specific unit (e.g., per bead, per meter). |
| Unit | The measurement type (cm, gram, piece, etc.). |
| Stock Quantity | The amount currently on hand. |
| Tags & Photos | For easy searching and visual identification. |
| Memo | Notes on suppliers or specific quality details. |
2. Product Records (The Formula)
A product record combines materials with additional costs to determine the “Total Production Cost”.
| Field | Purpose |
|---|---|
| Product Name | The name of the finished work. |
| Materials Used | A list of specific materials and the exact quantity used for one item. |
| Labor Cost | The cost of time (often calculated as hourly rate × production time). |
| Other Costs | Fixed expenses like packaging, labels, or shop fees. |
| Finished Inventory (Pro) | The number of completed items ready for sale. |
3. Sales Records (The Result)
The sales record connects a specific product to a transaction, allowing for real-time profit tracking.
| Field | Purpose |
|---|---|
| Product Name | The item sold (linking back to the product record). |
| Sale Price | The actual price the item sold for. |
| Cost Snapshot | The production cost at the exact moment of sale. |
| Sale Date | When the transaction occurred. |
| Sales Platform | Where it was sold (e.g., Etsy, local market, personal site). |
Comparison: choosing your management tool
There is no single “correct” way to keep records; the best method is the one that fits your workflow. Each approach involves different tradeoffs in terms of effort and automation.
| Feature | Paper Notebook | Spreadsheet | Dedicated App (MakerNote) |
|---|---|---|---|
| Ease of Entry | High (just pick up a pen). | Medium (best on PC). | High (mobile-optimized). |
| Calculations | Fully manual. | Automatic (if formulas are set). | Fully automatic. |
| Searchability | Low. | High (on PC). | High (filters and tags). |
| Price Changes | Requires manual update of every related product. | Requires complex cell linking. | Automatic: Changing one material price updates all linked products. |
| Data History | Chronological but hard to aggregate. | Highly flexible for analysis. | Cost Snapshots: Sales records stay accurate even if material prices change later. |
What this management category is not
It is important to clarify the boundaries of cost recording. This category is focused on information design and data management.
- No Pricing Recommendations: We provide fields to record your “Sale Price” and tools to calculate margin-based targets, but we do not advise on what you should charge for your work.
- No Tax or Legal Advice: Recording sale dates and costs is part of bookkeeping, but this does not constitute professional advice on tax filing, business registration, or accounting regulations.
- Recording vs. Strategy: This is a system for logging what has happened, not a strategy for business growth.
Managing records with MakerNote
We designed MakerNote to streamline these three pillars into a single mobile workflow. By linking your materials directly to your products, the app handles the math for you.
- Automation: If the price of a specific thread or bead goes up, you only update it once in your Materials list. MakerNote automatically recalculates the cost for every product using that material.
- Integrity: When you log a sale, the app takes a “Cost Snapshot.” This ensures that your past profit records remain accurate, even if you change your material prices or labor rates in the future.
MakerNote is available with a Free Tier (allowing up to 50 materials and 20 products), which also includes a shopping memo for low-stock materials and free CSV/ZIP/PDF backup and import. For those requiring more, the Pro Tier is available as a one-time purchase, unlocking 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
Whether you prefer the tactile feel of a paper notebook or the automation of a dedicated app, the key to a sustainable handmade business is a consistent recording habit. By breaking your records down into Materials, Products, and Sales, you can ensure that your pricing is grounded in reality and your creative time is properly valued.
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
