LocalizeBook tracks your stock through the whole production cycle: you buy raw materials, turn them into finished goods with a Stock Assembly, and sell the finished goods. Stock quantities and costs update automatically at every step.
This guide follows one example from start to finish. ABC Furniture makes wooden tables. It buys enough materials for 10 tables ($800), produces 10 tables at a material cost of $80 each, sells 3 tables at $120 each, and keeps 7 tables in stock.
Use this guide if your business makes products from parts or ingredients. This is also called manufacturing, production, kitting or working with a bill of materials (BOM). For every field on the Stock Assembly screen, see the Stock Assembly article.
The workflow at a glance
The full stock cycle in LocalizeBook has five steps:
- Create inventory items. Set up the raw materials as Stock Part items and the finished product as a Stock Assemble item with its Item Recipes.
- Purchase raw materials. Record a Purchase (Bill). The materials go into stock at their purchase cost.
- Produce finished goods. Create a Stock Assembly. LocalizeBook deducts the raw materials and adds the finished goods to stock.
- Sell finished goods. Create an Invoice. The finished goods leave stock and their cost is recorded.
- Monitor inventory. Use the Stock, Purchase and Sale reports to check quantities, values and records.
Key terms
Term | Meaning in LocalizeBook |
|---|---|
Stock Part | An item type for items you buy, store and sell as inventory. Raw materials use this type. |
Stock Assemble | An item type for items you produce by assembling other stock items. The finished product uses this type. |
Item Recipes | The tab on a Stock Assemble item that lists the components, and the quantity of each, needed to make one finished item. This is the item's bill of materials. |
Stock Assembly | The transaction that records production. It uses up the components and adds the finished item to stock. |
Raw materials | The components you buy and use in production. In this example: wood, table legs, screws and paint. |
Finished goods | The products you make and sell. In this example: the wooden table. |
Before you start
Check these three things before you follow the steps:
- Stock Assembly is turned on. Click the Settings icon in the top-right corner, then click Preference > Item. Under Transaction, check Active Stock Assembly and click Save. Without this, Stock Assembly does not appear in the Item menu.
- Your accounts are ready. Each item needs an Asset (inventory), COGS (cost of goods sold) and Income account on its General Info tab.
- You know which warehouse you will use. A Stock Assembly takes the materials from one warehouse and adds the finished goods to the same warehouse. Buy the materials into that warehouse, or move them there with a Stock Transfer.
Step 1: Create the inventory items
Create each raw material as a Stock Part, then create the finished product as a Stock Assemble item and list its materials on the Item Recipes tab.
Create the raw materials (Stock Part)
- Go to Item > Item and click +Add.
- Enter the Code and Name (English), and select the Item Group.
- In Item Type, keep Stock Part.
- On the General Info tab, select the Unit Set Name and the Asset, COGS and Income accounts.
- Click Save & New and repeat for each material.
ABC Furniture creates four raw materials:
Code | Name | Item Type | Unit |
|---|---|---|---|
WD-001 | Wood | Stock Part | Piece |
TL-001 | Table Legs | Stock Part | Piece |
SC-001 | Screws | Stock Part | Piece |
PT-001 | Paint | Stock Part | Litre |
Create the finished product (Stock Assemble)
- Go to Item > Item and click +Add.
- Enter the Code WT-001 and the Name Wooden Table.
- In Item Type, select Stock Assemble. The Item Recipes tab appears.
- Fill in the General Info tab: the unit set, the Base Price ($120 in this example) and the accounts.
Add the Item Recipes (bill of materials)
- Click the Item Recipes tab.
- For each material, select the Name, select the Unit, and enter the Qty needed to make one table.
- Click the save line icon after each line.
- Click Save & Close.
The recipe for one Wooden Table:
Material | Qty for 1 table | Unit |
|---|---|---|
Wood | 5 | Piece |
Table Legs | 4 | Piece |
Screws | 20 | Piece |
Paint | 1 | Litre |
Tip: Always enter recipe quantities for one finished item. LocalizeBook multiplies them by the quantity you produce.
Step 2: Purchase the raw materials
Record the materials you buy with a Purchase (Bill). When you save it, the materials are added to stock in the selected warehouse at their purchase cost.
- Go to Vendor > Vendor Transaction, click Add and choose Purchase (Bill). You can also press Alt + P.
- Select the Vendor, the Warehouse and the Date.
- On the Item ($) tab, add one line per material: select the Item Name, then enter the Qty and Cost($). The Amount($) is calculated for you.
- Check the Grand Total and click Save & Close.
ABC Furniture buys enough materials to make 10 tables:
Material | Qty | Unit cost | Amount |
|---|---|---|---|
Wood | 50 pieces | $10.00 | $500.00 |
Table Legs | 40 pieces | $5.00 | $200.00 |
Screws | 200 pieces | $0.10 | $20.00 |
Paint | 10 litres | $8.00 | $80.00 |
Total | $800.00 |
After saving, ABC Furniture has 50 wood, 40 table legs, 200 screws and 10 litres of paint in stock, worth $800 in total.
Step 3: Produce finished goods with Stock Assembly
A Stock Assembly records production. When you save it, LocalizeBook deducts the raw materials from stock, adds the finished goods to the same warehouse, and sets the cost of the finished goods from the materials used.
- Go to Item > Stock Assembly and click +Add. You can also press Alt + Y.
- In Item Name, select Wooden Table. The Item Code, Unit Name and the Item Recipes lines fill in automatically.
- Check the Date and select the Warehouse.
- In Produce, enter 10.
- Check the Item Recipes table: Qty Available must be at least Qty Need on every line.
- Click Save & Close.
Qty Assemble shows the most you can make with the materials in that warehouse. Qty Need = Qty per Item × Produce.
Material | Qty per Item | Qty Available | Qty Need | Stock after saving |
|---|---|---|---|---|
Wood | 5 | 50 | 50 | 0 |
Table Legs | 4 | 40 | 40 | 0 |
Screws | 20 | 200 | 200 | 0 |
Paint | 1 | 10 | 10 | 0 |
After saving, the raw materials are used up and 10 Wooden Tables are added to stock.
How the cost of each table is calculated
The cost of the materials used becomes the cost of the finished item. One table uses:
Material | Qty × Unit cost | Cost per table |
|---|---|---|
Wood | 5 × $10.00 | $50.00 |
Table Legs | 4 × $5.00 | $20.00 |
Screws | 20 × $0.10 | $2.00 |
Paint | 1 × $8.00 | $8.00 |
Total | $80.00 |
The 10 tables are worth 10 × $80.00 = $800.00, the same as the materials used. Production moves the value from raw materials to finished goods; it does not create or lose value.
Step 4: Sell the finished goods
Sell finished goods the same way as any other stock item, with an Invoice (or a Sale Receipt for a cash sale). The tables leave stock and their $80 cost is recorded as cost of goods sold.
- Go to Customer > Customer Transaction, click Add and choose Invoice. You can also press Alt + I.
- Select the Customer and the Warehouse the goods come from.
- In Invoice Detail, select Wooden Table in Item Name and enter the Qty. The Price($) comes from the Price Level, and you can change it.
- Check the Grand Total and click Save & Close.
ABC Furniture sells 3 tables at $120 each:
Result | Calculation | Amount |
|---|---|---|
Sales revenue | 3 × $120.00 | $360.00 |
Cost of goods sold (material cost) | 3 × $80.00 | $240.00 |
Gross profit | $360.00 − $240.00 | $120.00 |
Tables left in stock | 10 − 3 | 7 tables |
Note: If you deliver the goods first with a Sale Delivery (GDN), the stock leaves at the delivery. You then pull the delivery into the invoice to bill the customer.
Step 5: Monitor inventory with reports
Use these reports and lists to check your stock balance, its value and every transaction behind it. Go to Report > All Reports and choose a category on the left, or open the list shown.
What you want to check | Where to find it |
|---|---|
Inventory balance and value of each item | Report > All Reports > Stock > Stock Value Summary |
Stock movements item by item | Report > All Reports > Stock > Stock Value Detail |
Physical stock count | Report > All Reports > Stock > Stock Work Sheet |
Items running low | Report > All Reports > Stock > Reorder List |
Stock assembly records | Item > Stock Assembly (the list of saved assemblies) |
Purchase records | Report > All Reports > Purchase & Payables > Purchase by Item Summary or Purchase by Item Detail |
Sales records | Report > All Reports > Sales & Receivables > Sale by Item Summary or Sale by Item Detail |
After the five steps, ABC Furniture's stock is:
Item | Qty on hand | Cost per unit | Stock value |
|---|---|---|---|
Wood | 0 | $10.00 | $0.00 |
Table Legs | 0 | $5.00 | $0.00 |
Screws | 0 | $0.10 | $0.00 |
Paint | 0 | $8.00 | $0.00 |
Wooden Table | 7 | $80.00 | $560.00 |
Total | $560.00 |
How stock and cost change at each step
The stock value only goes down when finished goods are sold. Production moves the value from raw materials to finished goods.
After this step | Raw materials in stock | Finished tables in stock | Total stock value |
|---|---|---|---|
Purchase (Bill) | 50 wood, 40 legs, 200 screws, 10 L paint: $800 | 0 | $800 |
Stock Assembly (produce 10) | None: $0 | 10 tables at $80: $800 | $800 |
Invoice (sell 3) | None: $0 | 7 tables at $80: $560 | $560 |
The $240 that left stock is the cost of goods sold for the 3 tables.
Frequently asked questions
How do I track raw materials and finished goods in LocalizeBook?
Create the raw materials as Stock Part items and the finished product as a Stock Assemble item with Item Recipes. Buy the materials with a Purchase (Bill), produce the product with a Stock Assembly, and sell it with an Invoice. LocalizeBook updates the quantities and costs at each step.
How do I record manufacturing or production in LocalizeBook?
Use a Stock Assembly: go to Item > Stock Assembly, click +Add, select the finished item, enter the quantity in Produce and save. The materials are deducted and the finished items are added to the same warehouse.
What is the difference between Stock Part and Stock Assemble?
A Stock Part is an item you buy, store and sell, such as a raw material. A Stock Assemble item is made from other stock items and has an Item Recipes tab that lists its materials.
Where do I enter the bill of materials (BOM) for a product?
On the Item Recipes tab of the finished item. Set the Item Type to Stock Assemble to show this tab, then enter each material and the quantity needed for one finished item.
How is the cost of a finished product calculated?
The cost of the materials used becomes the cost of the finished item. In the example, one table uses $50 of wood, $20 of legs, $2 of screws and $8 of paint, so each table costs $80.
What if the purchase price of my materials changes?
With Weighted Average costing, each new purchase updates the material's average cost. A stock assembly uses the materials' average cost at the time you save it.
Does producing goods change my total stock value?
No. A stock assembly moves value from raw materials to finished goods. The total stock value goes down only when you sell the finished goods.
What happens to stock when I sell a finished product?
The sold quantity leaves stock and its cost is recorded as cost of goods sold. In the example, selling 3 tables at $120 brings in $360 of revenue, records $240 of cost and leaves 7 tables in stock.
Why don't I see Stock Assembly in the Item menu?
Turn it on first: click the Settings icon, go to Preference > Item, check Active Stock Assembly under Transaction and click Save.
Why can't I select my product in Stock Assembly?
Only items with the Item Type Stock Assemble appear in Item Name. Change the item's type to Stock Assemble and add its Item Recipes.
What if I don't have enough raw materials?
Qty Assemble shows the most you can produce with the materials in the selected warehouse. Buy the missing materials, or move them into that warehouse with a Stock Transfer, before you save the assembly.
Can I use materials from another warehouse?
No. A stock assembly takes materials from, and adds finished goods to, the warehouse selected on it. Move the materials there first with a Stock Transfer.
Can I undo a stock assembly?
Yes. In Item > Stock Assembly, select the record and click Edit, Void or Delete. The stock of the finished item and its materials changes to match.
Which report shows how much stock I have and what it is worth?
Stock Value Summary, under Report > All Reports > Stock. Use Stock Value Detail to see the movements behind each item.
Related articles
- Stock Assembly: every field on the Add Stock Assembly screen, number format and managing records
- Item: creating items, item types, accounts and settings
- Vendors: purchases and paying vendors
- Invoice: billing customers for finished goods
- Sale Delivery: delivering goods before you invoice
- Report: the full list of reports
- Stock Transfer and Weighted Average Cost (WAC) vs. FIFO Costing, in the Item section