BimpBlog

Payroll Software for Manufacturing: What It Must Be Able to Do

Payroll software for manufacturing: a requirements checklist, an output calculation for a sample shop, what Bimp does and what stays in accounting software.

DO
Dmytro ObukhovCo-Founder & CEO
Table of contents
In short
  • Payroll software for manufacturing must do three things: calculate piece rate from output recorded in production documents, combine it with salary and bonus, and pass the cost of labor into the cost of the product.
  • In the example, a hypothetical shop made 500 pedestal units in a month: €3,000 of piece rate (€6 per unit) and a €2,800 salary for the shop head. The fund is €5,800, and 51.7% of it goes into product cost.
  • Bimp calculates management pay: salary, piece rate, bonus, advances, debt per employee. Payroll taxes and contributions, statutory reporting and HR records are kept by the accounting software.
  • Choose software with a checklist of eleven requirements: nine are about linking payroll to production, two belong to the accounting software.

Payroll software for manufacturing must do three things: take output from production documents and calculate piece rate from it, combine piece rate with salary and bonus, and pass the cost of labor into the cost of the product. Payroll taxes and contributions and statutory reporting belong to the accounting software, and honest shop software does not promise them.

At month end a shop head collects output in a notebook, a timesheet and a messenger. The accountant copies the numbers into Excel, and a week later the owner asks how much payroll costs in one pedestal unit. There is no answer, because payroll lives apart from output. Below is a requirements checklist and a calculation for a hypothetical shop.

How does payroll software for manufacturing differ from accounting software?

Accounting software treats payroll as a tax and HR document: payroll taxes and contributions, timesheets, leave, sick leave, reports to the authorities. About production it knows only the total.

Production software treats payroll as a cost of a specific product. It needs operations, performers, quantities and rates. It answers the questions accounting software does not ask: who made how much, what labor costs in one pedestal unit, whether the plan matches the actual.

A shop usually needs both programs. The management part on one side, the tax part on the other, and a handover of totals between them.

What must payroll software for manufacturing be able to do?

Below is a checklist for selection. The right column shows which items Bimp covers.

No.RequirementWhyBimp
1Salary, rate and piece rate in the employee cardone person can have several pay schemesyes
2Piece rate from a production document without manual entryfewer errors, output comes from the release recordyes, from “Assembly”
3Crew: several performers in one accrualassembly and packing are rarely done aloneyes
4Payroll in product costcosting reflects the actual cost of laboryes
5Period expenses kept apart from costa foreman’s salary is not allocated to batchesyes
6Advances offset at accrualno double paymentsyes
7Payout and payment calendarcash outflow is visible in advanceyes
8Debt report per employeeaccrued, paid and balance are visibleyes
9Rates in a foreign currencyfor flexible arrangements with performersyes
10Payroll taxes and contributions, reportinglegal requirementno, accounting software
11Timesheet, leave, sick leave, HR ordersHR recordsno, HR or accounting software

For a shop with a dozen employees the first eight items in a basic form are enough. For a shop with several shifts and foreign-currency settlements the ninth is needed too. Items 10 and 11 are needed by everyone, only another program has to cover them.

The first nine rows are about linking payroll to production. If software does not cover at least items 2 and 4, output has to be carried over by hand and cost calculated in a separate spreadsheet.

How are output and piece rate calculated in a sample shop?

A hypothetical shop made 500 office pedestal units in October. The specification contains four operations with rates. The rates add up: 1.2 + 1 + 3 + 0.8 = €6 of piece rate per unit.

OperationPerformerDone, pcsRate, EURPiece rate, EUR
Board cuttingMelnyk5001.2600
Edge bandingBoiko5001500
Carcass assemblyShevchuk2603780
Carcass assemblyBondar2403720
PackingLytvyn5000.8400
Total3,000

Check: 600 + 500 + 780 + 720 + 400 = 3,000. The same another way: 500 units × €6 = €3,000. Two people split the assembly, so 260 + 240 = 500.

The salary of the production head, €2,800, is added to the piece rate. The total payroll fund of the shop for the month is 3,000 + 2,800 = €5,800. The piece-rate part is 3,000 / 5,800 = 51.7%.

PartAmount, EURWhere it goes
Piece rate for 500 units3,000cost of the units, €6 per product
Head’s salary2,800expenses of the period
Total5,800

The owner now sees that labor in one unit costs €6, and the salary of the shop administration does not enter the costing. To compare this with the plan, a planned cost is needed, and its breakdown is in the article about piece-rate pay calculation for 38 workstations.

How does this work in Bimp?

The path from output to payout has five steps.

  1. Rates. In the “Accrual types” catalog you create the salary and the piece rates, and in the employee card you set personal rates. If the card has no rate, the rate from the catalog is used.
  2. Operations. In the production order the “Operations” tab pulls the stages from the specification. There you check the performer, the operation, the quantity and the rate.
  3. Output. Create “Assembly” from the order and post it. Bimp creates and posts a Piecework pay document with the operation type “Production” by itself. The amount is calculated as quantity × rate and allocated to the product. If no product is specified in the accrual, posting is blocked.
  4. Salary and bonus. The Salary accrual document with the item “Production staff salary” accrues the salary, and it goes into the expenses of the period. Details are in the article Salary accrual.
  5. Payout and reports. The Salary payout document is created from the accrual, and the advance is offset with the “Offset advances” button. The “Salary accrued and paid” report shows debt per employee, and “Cost of produced goods” shows labor in the cost structure of the product.

The document fields, operation types and cost allocation are described in the article Piecework pay.

What share of cost does payroll make up?

When payroll is in cost, its share is visible in numbers. Suppose materials for one pedestal unit cost €64.

ItemPer unit, EURPer 500 units, EUR
Materials6432,000
Piece-rate pay63,000
Total direct costs7035,000

The share of piece rate in direct costs: 6 / 70 = 8.6%. Check by batch: 32,000 + 3,000 = 35,000, and 35,000 / 500 = €70. If the rates go up by 10%, a unit becomes €0.60 more expensive and the batch €300. The owner does this arithmetic before raising the rates, while no payments at the new rates exist yet.

What mistakes appear when payroll is calculated in Excel?

A spreadsheet looks convenient while the shop has five people. When there are twenty people and several dozen products, typical failures accumulate, and the accountant finds them only on payday.

  • Output is entered twice. Once in the work order, once in the spreadsheet. A difference of a few units is found on payday.
  • The rate changed, the formula did not. The old rate stays in the file, and some people are paid at an outdated rate.
  • The advance is not counted. The amount already given out is not subtracted, and the person receives more than they earned.
  • Cost is calculated separately. Payroll reaches the costing as an average, without actual data per product, so the actual margin of an order stays unknown.

Software removes these failures when output enters the system once from a production document, and accrual, debt and cost are taken from it automatically.

What should be passed to the accountant, and what should not be carried over?

Bimp gives the total of accruals per employee for the month. It is the starting figure for the accounting software. In the example it is a €5,800 fund split by person: five performers on piece rate and the head on salary.

In its own software the accountant adds what Bimp does not do: calculates payroll taxes and contributions, prepares reports, keeps timesheets and leave. Then the data is not duplicated across two systems: the production system holds the piece rate and salary figures, the accounting system holds taxes and HR. The owner should agree on a single handover point, for example a summary statement at month end.

Why should shop payroll be visible per order?

A monthly payroll total says how much money went out, but not what it went on. An order for 500 pedestal units and an order for 40 custom wardrobes can give the same piece rate in money, while the hours and complexity differ. When piece rate is allocated to products, the cost of each order and its margin are visible.

The monthly total is still needed for the payout, and the breakdown by product is needed for pricing decisions. It helps in two situations. First: a manager asks for a discount, and the owner knows how much payroll sits in the price and whether margin will remain. Second: the shop asks to raise the rate for a complex operation, and the owner can calculate how much cost will grow before agreeing.

What questions should you ask at a software demo?

Before choosing, ask to see on your data:

  • how an employee receives salary and piece rate at once, in one view of the debt;
  • where the number of operations comes from: a production document or manual entry;
  • where the report shows payroll inside the cost of a specific product;
  • what happens if two performers share one operation, as in the assembly example;
  • which functions are missing, and whose they are: your accounting software or a separate record.

Mixed pay schemes are covered in detail in the article about salary plus piece rate for one employee.

What Bimp does and does not do

Bimp is a Ukrainian cloud ERP for manufacturers. For payroll it provides an employee card with rates, a catalog of accrual types, the Salary accrual document for salaries and bonuses, the Piecework pay document created automatically from “Assembly”, crew accrual, advances, payout, a payment calendar and reports on debt and cost. All of this is management accounting: it shows how much payroll costs the shop and the product.

Bimp does not calculate payroll taxes and contributions, does not prepare tax reporting and does not keep HR records: timesheets, leave, sick leave and orders. These stay in the accounting software. The bonus amount and the rules of mixed pay are defined by the owner, and the system does not suggest them. Piece-rate pay in Bimp in general is covered on the Bimp site, and the formula and a sample work order in the article about piece-rate pay.

FAQ

Does Bimp calculate payroll taxes?

No. Bimp accrues management pay: salary, piece rate, bonus. Payroll taxes and contributions and statutory reporting are handled by the accounting software.

How does Bimp calculate an employee's output?

Performers, operations, quantities and rates are entered on the "Operations" tab of the production order. After "Assembly" is posted, Bimp creates a Piecework pay document in which the amount equals quantity times rate.

Does piece-rate pay go into the cost of a product?

Yes. A Piecework pay document with the operation type "Production" allocates the amount to the finished product, and it shows in the "Cost of produced goods" report.

Can pay be set in a foreign currency?

A rate can be set in UAH, USD or EUR. If the rate is in a foreign currency and the accrual is in the base currency, Bimp converts the amount at the rate on the document date.

Can piece rate be accrued to a crew?

Yes. In the Piecework pay document you turn on the "Employee in table" switch and add all performers with quantity and rate.

We will show shop payroll in Bimp

In a Bimp ERP demo, a specialist shows the path from operations in a production order to piece-rate pay, debt per employee and the cost of a product.

Book a demo
DODmytro ObukhovCo-Founder & CEO