Furniture
Inventory software for furniture manufacturers
Know how many cubic feet of seasoned white oak are left in the yard, which designs are standing finished in the warehouse, and what each is worth today.
In short
SimpleERP is inventory software for furniture manufacturers. It counts timber in cubic feet (cft), plywood in sheets and hinges in pieces, keeps finished furniture per warehouse and showroom, and values every item at weighted average cost.
Illustration of stock on hand by warehouse at average cost, with a low-stock row highlighted and a movement ledger.
An inventory day at Oak and Ash Works
The timber yard at Oak and Ash Works holds logs and sawn planks of white oak and walnut in the middle of seasoning, measured in cft by the yard supervisor with a tape and a chalk mark. Next to it the store keeps 18 mm plywood, PU polish in 20 litre drums, hinges, drawer channels and screws.
Finished pieces stand in a warehouse behind the workshop until a truck takes them, and a dozen display pieces sit in the showroom on the highway. When a buyer calls asking for six honey-finish bedside tables, the manager wants one answer for all three places, not a walk around the campus.
Can I count timber in cft and chairs in pieces in one system?
Every product has its own unit. Add cft as a unit for timber, keep sheets for plywood, litres for polish and pcs for finished pieces. Each warehouse holds its own quantity of each product.
- Four warehouses: timber yard, hardware store, finished warehouse and showroom.
- Transfers move a dining set from the warehouse to the showroom with a document for each move.
- Physical counts after the yard re-measures a stack, with a reason for the difference.
| Product family | Unit | Kept in | Reorder pattern |
|---|---|---|---|
| Seasoned white oak planks | cft | Timber yard | Reorder level 300 cft; bought from sawmills before winter |
| Mango wood planks | cft | Timber yard | Reorder level 150 cft; bought monthly |
| Plywood 18 mm and 12 mm | Sheets | Hardware store | Reorder level 40 sheets |
| Hinges, drawer channels, screws | pcs or boxes | Hardware store | Reorder level per size; bought every fortnight |
| PU polish, sealer, thinner | Litres | Hardware store | Reorder level 60 litres |
| Finished dining tables, beds, sofas | pcs | Finished warehouse and showroom | Made to stock for the best ten designs |
What is the timber in the yard worth after prices moved?
Each supplier bill brings timber in at its own price, and SimpleERP blends it into a weighted average. If the yard held 400 cft at $45 and a new lot of 200 cft arrives at $49, the average becomes $46.33 per cft and the yard is worth $27,800.
- Stock value per warehouse as of today, so the yard and the showroom are seen apart.
- Issues at average cost when timber goes into a work order or a piece is invoiced.
- Stock adjustments post to the books, so a short count shows up as a loss and not as a puzzle.
Illustration of stock on hand by warehouse at average cost, with a low-stock row highlighted and a movement ledger.
How do I know hinges and polish are running short?
Set a reorder level on each hardware item and on polish. The stock list shows every item at or below its level, and you pick which ones to put on a purchase order to your hardware supplier in Grand Rapids.
- Purchase orders grouped by supplier from the items you select.
- Supplier bills receive stock into the hardware store at the bill rate.
- Finished designs get a level too, so a fast-selling bed is made before the warehouse is empty.
One system
What it connects to
Stock rises on supplier bills and completed work orders, and falls on invoices, all posted to the inventory account.
Furniture
BOMs per design, work orders, workshop and showroom stock, and counter invoices paid on the spot.
See howInvoicing & tax
Tax invoices with VAT, GST or sales tax on every line, numbered by fiscal year and posted in one step.
See howAccounting for furniture makers
Showroom dues, buyer advances, timber depot bills and machinery depreciation in one double-entry ledger.
See howPayroll for furniture factories
Monthly pay for carpenters, polishers and upholsterers from attendance, with advances recovered and deductions on every payslip.
See howManufacturing for furniture makers
A bill of materials per design and a work order per batch that turns white oak, glue and polish into finished tables at real cost.
See howInventory
Stock on hand by warehouse at weighted average cost, with a movement ledger and a low-stock list.
See how
Honest limits
What SimpleERP does not do yet
- No batch, lot, serial or expiry tracking, and no barcode scanning
- Weighted average cost only; there is no FIFO
- No automatic reorder suggestions: the reorder level shows what is low, you decide what to buy
- No log-by-log or plank-by-plank tracking: white oak is one quantity in cft per warehouse
- No conversion from logs to sawn planks inside stock; record sawing as a work order or an adjustment
Getting started
Start with inventory
Sign up with your email
Name, email and a password. No card for the seven-day trial.
Tell us about the business
Pick your country and, if you are registered, type your tax number. Accounts, tax rates, units, roles and numbering are seeded for that country.
Add products and opening stock
Add white oak and walnut in cft, plywood in sheets and hardware in pcs, with opening stock in the yard, store, warehouse and showroom, or import them from a CSV file.
Post a bill and an invoice
Stock rises on the purchase bill and falls on the invoice, at weighted average cost, with nothing to count by hand.
FAQ
Questions, answered
Can I keep wet timber and seasoned timber apart?
Yes. Make two products, such as White oak planks wet and White oak planks seasoned, or keep a separate warehouse for the kiln. When a lot is ready, move it with a transfer or adjust one out and the other in, with a reason the yard supervisor can read later.
Our showroom pieces get scratched. How do I record a damaged table?
Post a stock adjustment in the showroom warehouse with the reason damaged in transit or damaged on display. The table leaves stock at its average cost and the loss posts to the books. If it is repaired and sold cheaper, keep it in stock and give a line discount on the invoice.
Will a plywood offcut count as stock?
Only if you want it to. Most units leave offcuts out and allow for them through the scrap percentage on the bill of materials. If you resell offcuts, make them a product and bring them in with an adjustment.
I buy timber from a small sawmill that charges no tax. Can I still add it?
Yes. Enter the purchase bill from that supplier with no tax on the line, and the timber comes into the yard at the bill price like any other lot. Your accountant will advise how that purchase is treated for tax.
Related
Keep reading
Furniture
BOMs per design, work orders, workshop and showroom stock, and counter invoices paid on the spot.
Read moreManufacturing for furniture makers
A bill of materials per design and a work order per batch that turns white oak, glue and polish into finished tables at real cost.
Read moreInvoicing & tax
Tax invoices with VAT, GST or sales tax on every line, numbered by fiscal year and posted in one step.
Read more
See how inventory works in SimpleERP for furniture
Seven days free. No card. Your first invoice in minutes.