Manufacturing Orders and Labor Hours in One Core Business System: A Practical Guide

At a die and mold maker in Gifu with about 60 staff, the shop floor ran on paper. Machinists scribbled their hours on slips beside each press and dropped them in a tray by the door, and someone in the back office typed the numbers into a spreadsheet at the end of the week. The numbers never made it back to the manufacturing order. A precision mold that should have shown a loss looked profitable, and the one that looked expensive was actually fine. The owner knew the figures were wrong, but he could not prove which ones.

This is a familiar story in Japanese small and medium manufacturing. Labor hours live in one system, materials in another, and the accounting books in a third. The result is a cost on the order that no one trusts. This guide walks through what changes when the manufacturing order (with its materials), the labor hours (captured in the timesheet), and the double-entry books all live inside one core business system, so the true cost of an order can finally be assembled in a single place.

The Problem: What It Costs Now

When labor hours and manufacturing orders sit in separate places, three costs pile up quietly.

First, the true cost of an order is invisible. Materials get booked to the order cleanly because the manufacturing order tracks the materials it consumes. Labor, the largest variable for a die and mold shop, is captured separately in the timesheet, by job or work category, and never lands on the same order. The cost figure on the order is therefore a partial cost. Decisions about pricing, about which customer is worth re-quoting, about which product line to grow, all get made on a number missing its biggest component.

Second, the monthly close drags. For many Japanese small and medium enterprises the monthly close still takes one to two weeks or more. A big share of that time is reconciliation. Someone walks the timesheets back to the jobs, the jobs back to the orders, the orders back to the invoices, and the invoices back to the journal. When the chain is manual and the data is scattered, every link is a place to disagree.

Third, quoting drifts from reality. A shop quotes the next job based on the last job, but the last job was costed wrong. Over a year, the gap between estimated hours and actual hours widens, and the margin quietly erodes. By the time anyone notices, the pattern is baked into the price list.

None of this is a technology problem in the dramatic sense. It is a data problem. The hours exist. The orders exist. The accounts exist. They are simply not in the same place.

What Changes

The shift is structural, not cosmetic. The manufacturing order, the timesheet, and the double-entry books stop being three islands and become parts of one core business system.

In a fit-to-standard core business system, this works through linked pieces that already exist in the master data. A multi-level bill of materials defines what a product is made of. A manufacturing order turns that bill into a real production run, with a product, a quantity, a status, and the materials it consumes. Parent and child orders can nest, so a complex mold breaks into sub-assemblies cleanly. A timesheet captures the hours a person works, and attendance records the time on site. All of this sits inside the same system as the general ledger.

What does not happen is automatic linking of labor to a manufacturing order. A timesheet entry is captured by job or work category, not pinned to an order. That connection, and any connection of labor or operational events to a general ledger account, is a manual journal entry, confirmed with your accountant. What you gain is not an automated accounting decision. What you gain is visibility. The materials on the order, the hours in the timesheet, and the books are no longer scattered across three tools. They live in one source of truth, where the true cost of an order can be assembled at month-end by combining the materials (auto-tracked by the order) with the labor hours (from the timesheet), and then posting one manual journal entry to record labor cost against the order.

A few things to be clear about, because overselling this is the fastest way to disappoint a shop floor. This is not a full manufacturing execution system. It does not schedule machines to the minute, and it does not do capacity planning or shop-floor sequencing. It does one thing cleanly: it brings the manufacturing order, the materials, the labor hours, and the double-entry books into one system, so the true cost of an order can be assembled in a single place rather than hunted across spreadsheets. For a die and mold maker, that one thing is usually the missing piece.

The grounding is deliberate. Materials are auto-tracked by the manufacturing order. Labor hours are captured in the timesheet by job or project. The double-entry books already run the rest of the business. The books and the shop floor share one source of truth. One honest boundary: the system does not auto-post labor, scrap, or material consumption to the general ledger. Journal entries auto-generate only from sales invoices, purchase bills, and expense reimbursements. Connecting labor hours to an order's cost, or to a general ledger account, is a manual journal entry, confirmed with your accountant. What you gain is visibility, not an automated accounting decision. Everything else stays where it belongs, with the production planner and the foreman.

A Real-World Scenario

Take the Gifu die and mold maker. Sixty staff. High-mix, low-volume work. Each mold is effectively a one-off project with its own bill of materials and its own manufacturing order.

Before, a senior mold could consume 280 hours of machining and finishing across five people, and the order would show only the steel and the consumables. The 280 hours lived on paper slips, logged against a job in a separate spreadsheet. When the owner asked why a particular customer always seemed to quote low, no one could answer with numbers, only with a feeling.

After moving onto one ERP, the picture changes in a single week. The team records labor in the timesheet by job. They track materials through the manufacturing order, which deducts the raw materials from inventory on completion. All of this lives in the same system as the double-entry books. At month-end, they combine the materials (auto-tracked by the order) with the labor hours (from the timesheet) and post a manual journal entry to record labor cost against the order, with their accountant. The president finally sees a true cost picture assembled in one place rather than hunted across spreadsheets.

Look at the before-and-after. An order that looked profitable at 1.8 million yen, costed on materials alone, now shows its true cost once the 280 hours of skilled labor from the timesheet are combined with it at month-end. Maybe it is still profitable. Maybe it is not. Either way, the owner finally knows, and can quote the next mold for that customer on a real number instead of a guess.

Month-end shortens too, even though the labor-to-cost connection is a manual entry. The reconciliation walk shrinks, because the hours are already in the timesheet, the materials are already on the order, and the order already lives in the same system as the books. There is no need to hunt labor across spreadsheets and back. What used to take 10 days starts moving toward days. The single-system visibility is what saves the time, not an automatic link between labor and the order.

Audit trails are automatic for the data the system does track, important for a shop that increasingly faces J-SOX internal controls and customer audits. Every timesheet hour and every material movement records who entered it and when. When the next generation takes over the company, the cost history transfers with the order history. The knowledge is no longer locked in the foreman's head or a tray of paper slips.

Why This Matters for Japan

Japanese manufacturing carries a particular set of pressures right now, and a single core business system speaks to several of them at once.

The labor shortage is acute. When skilled machinists are scarce, every hour matters more, and every hour miscosted is a larger share of a shrinking pool. Knowing the true labor content of each order is no longer a nice-to-have. It is how a shop decides what to keep building in-house and what to decline. When the hours live in the timesheet inside the same system as the order and the books, that labor content can finally be assembled per order instead of guessed at.

The 2025 legacy cliff adds urgency. Windows Server 2012 R2, SQL Server 2014, and many on-premise ERP platforms have reached the end of security support. Shops running isolated timesheet spreadsheets on aging servers face a forced renewal decision. Replacing a fragile paper-and-spreadsheet chain with one core business system turns that forced decision into an upgrade that pays back in visibility, not just in security patches. METI has framed the broader 2025 legacy problem around a widely cited figure of roughly 12 trillion yen of potential economic impact, which is why renewal is a board-level topic, not just an IT one.

The succession problem raises the stakes further. When a founder sells or hands down the company, auditable and transferable systems carry real value. A buyer can see the true cost of every order, the real margin by customer, the history of every hour logged in the timesheet, and the history of every material movement on the order. Paper slips carry none of that. One core business system turns tacit shop-floor knowledge into documented, transferable data.

The bilingual reality of Japanese manufacturing also matters. Shops that serve global customers, or that employ technical staff from overseas, benefit when the system is authored natively in both Japanese and English across the backend, the interface, and the self-service portal. This is one system, feature by feature, in both languages, not a language toggle on top of a Japanese tool.

Is This Right for Your Business?

One core business system for orders, labor, and books is not for every manufacturer. A pure trading company that buys and ships finished goods has little labor to capture. A high-volume, repetitive line may already have shop-floor systems that handle this well.

But for high-mix, low-volume manufacturers, it is usually the missing piece. Die and mold makers, machine shops, fabricators, small assembly houses, and any shop where skilled labor is the dominant cost will feel the gap immediately. If your machinists track hours on paper, if your monthly close spends days reconciling labor across spreadsheets, or if you cannot answer the question "what did that order really cost us" without a week of digging, this is your problem to solve.

The test is simple. Pull your most recent manufacturing order. Can you assemble the materials (from the order) and the labor hours (from the timesheet) for that order in one place, without a week of hunting across tools? If the answer is no, or if the answer is "sort of, after we adjust at month-end," then your order cost is a fiction. You are running the business on a number missing its largest input.

Frequently Asked Questions

Does this replace our shop-floor scheduling system?

No, and it should not try. Bringing orders, materials, labor hours, and the books into one system gives you a true cost picture you can assemble per order. It does not sequence machines, balance loads across work centers, or do capacity planning. Think of it as the costing and accounting layer that your planning tools feed into, not a replacement for them.

How does this affect the monthly close?

It shortens it, often noticeably. Because the hours are in the timesheet, the materials are on the order, and the order lives in the same system as the books, the end-of-month hunt across spreadsheets disappears. The labor-to-cost connection is still a manual journal entry, confirmed with your accountant, but the data you need to make it is already in one place. What used to take one to two weeks moves toward days.

Do we need to restructure our bill of materials first?

Usually not. A multi-level bill of materials already defines your product structure. The manufacturing order built from that bill tracks its own materials and can nest parent and child orders. The change is that the materials, the timesheet hours, and the books all live in the same system, so the order's true cost can be assembled at month-end instead of reconstructed from paper.

Does the system automatically post labor to the general ledger?

No. Journal entries auto-generate only from sales invoices, purchase bills, and expense reimbursements. Labor, scrap, and material consumption do not auto-post to the general ledger. Recording labor cost against an order, or against a GL account, is a manual journal entry you confirm with your accountant. What the system gives you is all the pieces in one place, so that manual entry is fast and grounded.

Key Takeaway

The true cost of a manufacturing order is not a mystery. It is an assembly job that most Japanese small manufacturers never finish, because the hours lived on paper, the materials lived in a second tool, and the books lived in a third. Bring all three into one core business system, and pricing, monthly close, quoting, and succession planning all stand on real numbers instead of feelings. The labor-to-cost connection stays a manual journal entry, but the hunting across spreadsheets is gone.

See How One Core Business System Works

If your shop is costing orders with the labor hours trapped in a separate spreadsheet, you are quoting in the dark. Kikan System is a modular core business system that brings manufacturing orders (with materials), multi-level bills of materials, labor hours through the timesheet, inventory, lot tracking, approval workflows, and the double-entry books together in one system, with configurable tax for the qualified-invoice system. The true cost of an order finally has a single home. Start free with up to 2 users and no credit card required.

(-> Start free)(/#get-started)

For broader context on choosing and renewing a core business system, see our guides on core business system selection and the 2025 legacy cliff.