Cost reconciliation

Know your scrap cost.
To the penny.

Scrap and rework tied to your general ledger, RMA-inclusive. The same number your accountant gets — without the week of digging.

Request a pilot Talk to sales

Workbooks / Scrap / Apr 1 – Apr 30 Reconciled to GL

$14,463.00

Scrap

38 NCs · opened basis

$5,766.00

Rework

21 NCs · opened basis

$2,180.50

RMA included

4 returns this period

$0.00

GL variance

Matches WIP Part Billings

NC	Part	Work center	Disposition	Cost	Status
NC-1042	TRA-N-K007224	Centerless grinding	Scrap	$2,450.50	Closed
NC-1038	SSD792500	CNC turning	Rework	$1,120.25	Open
NC-1036	T-M517	Heat treat	Scrap	$3,200.75	Closed
NC-1031	U-J-LY0890-1038	Assembly	RMA	$847.00	RMA
NC-1027	D-841	Surface grind	Scrap	$1,950.75	Closed
NC-1025	T-4566	CNC milling	Rework	$684.00	Review

Numbers your CFO can sign off on.

Every workbook ties to the general ledger — the same period, the same basis, the same total as your WIP Part Billings report. Opened vs. closed date basis toggles to match how accounting counts.

GL tie-out RMA-inclusive Date-basis toggle Excel export Per-record drill-down

How much did scrap cost us in April, and does it match the books?

Reconciliation — April 2026

Source

uniPoint NCs + Syspro WIP

Basis

Opened date · RMA included

Scrap — 38 nonconformances$14,463.00

Rework — 21 nonconformances$5,766.00

of which RMA returns$2,180.50

Workbook total$20,229.00

GL — WIP Part Billings$20,229.00

Variance$0.00

Every line traces to its NC record, work order, and journal entry. Export the block to Excel for your monthly review.

See what's driving the cost.

Root-cause aggregation across parts, work centers, and operators — so the monthly number comes with the why attached. Ask a follow-up in plain English and drill straight into the records.

Root-cause rollup Pareto by part Work-center trends Saved views

Scrap drivers / by part · April

TRA-N-K007224$4,891

T-M517$3,201

SSD792500$2,348

D-841$1,951

U-J-LY0890-1038$847

All others$1,225

Why is TRA-N-K007224 scrapping at centerless grinding?

Everything in the workbook.

Deterministic, YAML-defined blocks. The same answer every time you open it.

Cost summary

Scrap, rework, and RMA totals for any period.

GL tie-out

Variance against WIP Part Billings, to the penny.

Pareto charts

Top parts, work centers, and causes by cost.

Record tables

Every NC with disposition, cost, and status.

Excel export

Per-block export, formatted for the review deck.

Date-basis toggle

Opened vs. closed — match how accounting counts.

Source links

Every figure traces to its NC and journal entry.

Saved views

Scope filters per role — QA, ops, finance.

Less digging. More deciding.

Finding a number

20 sec

From a 20-minute QMS query to a 20-second answer — for anyone on the team, not just the QMS expert.

Trusting a number

$0.00

GL variance in the pilot month. The workbook total matched the customer's WIP Part Billings report exactly.

Getting started

Weeks

Remote deployment over a secure tunnel. No plant visit, no data migration, no 120-day implementation.

What disappears over time

Manually rebuilding the scrap number every month — pulling NC exports, matching them to work orders, and arguing about whose total is right.

4–6 hourssaved per monthly review

Ready for your monthly review, without the prep.

Open the workbook, set the period, and the numbers are already reconciled.

Scrap and rework totals match the GL on the same date basis as accounting
RMA returns are included — no more "wait, does that count returns?"
Every figure drills down to the NC, the work order, and the journal entry
Export any block to Excel, formatted for the review deck

Know your scrap cost.To the penny.