How to find realized margin exceptions in completed sales
Find realized margin exceptions in completed sales. Reconcile revenue and costs, flag low or negative gross margins, and assign each a next action.
Free app. Runs on your Mac with the Claude or Codex plan you already have.
What a realized margin exception is
To find realized margin exceptions, compare the net revenue and direct costs recorded for the same completed sale, product, customer, or job. An exception may be a loss, a miss against an approved margin threshold, or a low margin that warrants a closer look. A useful report tells you what the records show, how much of the selected sales population you can assess, and who can make the next price, scope, or cost decision.
Realized gross margin uses actual records under a stated reporting basis. If you review invoiced sales, identify the associated direct costs and any posted adjustments that belong with those sales. A quote, budget, or current supplier price cannot stand in for historical costs. This margin analysis addresses gross contribution before expenses outside the chosen direct-cost basis. Treat the findings and proposed actions as a draft for a qualified finance reviewer.
What it does for the business
- Price the next comparable jobA reconciled job history lets the pricing owner see which discounts or extra hours coincided with weak contribution. Use that evidence when quoting a similar job, with its own scope and current cost assumptions.
- Tighten the scope of repeat workWhen labor records show work beyond the agreed deliverables, the project owner can check how that work entered the job. That gives the team a concrete reason to clarify what's included or agree on how to approve additional work.
- Investigate a cost you can influenceAn order with a high recorded delivery cost gives operations a specific shipment to inspect. If the same pattern appears on comparable orders, the team can review the packaging or fulfillment decision with the source records in hand.
- Make the next review cover more salesA list of unresolved cost records shows finance exactly which units lack a defensible margin. Assign the largest evidence gaps first so the next review can bring more revenue into its reported coverage.
How to find realized margin exceptions, step by step
Define the sales population and the reporting basis
Every amount on a margin row must describe the same unit of work.
What to do
- Choose one reporting period and one sales population. Define what a row represents, such as an order line or completed job, and record the stable identifiers that connect sales, adjustments, and costs.
- Identify whether the amounts are posted or invoiced, recognized as revenue, or recorded on a cash basis. Keep these views separate and write down the date field that puts a sale in the period.
- Check the currency, tax treatment, decimal format, and transaction signs. Find out whether the sales export already reflects discounts and refunds, and document where to find any adjustments it leaves out.
- List which direct costs the basis includes. They might include materials, delivery, payment fees, or recorded labor. Ask what evidence confirms that cost capture is complete, especially for open jobs and rows showing a zero cost.
- Record any approved target and the units it governs. If you have prior-period data, check that the population, currency, and basis match before drawing a trend conclusion.
Why
Invoice, revenue recognition, and collection dates can put the same sale in different periods. Use a consistent basis for revenue and costs. Check cost completeness as well. An empty field may hide a bill that has yet to arrive.
Match the records and reconcile every amount
A total can balance even when a refund or cost is attached to the wrong sale.
What to do
- Check that sale and line identifiers are unique where you expect them to be. Collapse exact duplicates while keeping the original row references, and set conflicting duplicates aside for review.
- Join each adjustment and cost using the explicit sale or unit identifier and currency. Put unmatched records and ambiguous matches in an evidence-gap list so the reviewer can trace them back to the export.
- Apply the documented debit and credit signs once. If the export gives you net revenue, check whether the adjustment is already included. If it gives you gross revenue, combine it with the applicable signed adjustments.
- When a charge belongs to several units, use a supported cost allocation basis and keep a ledger showing how the shares tie back to the charge. Leave the affected margin unknown if the basis is missing.
- Reconcile source rows to included, duplicate, out-of-scope, and quarantined rows. Tie normalized sales, adjustments, and costs to source totals by currency and basis, then withhold affected aggregates until material differences are explained.
Why
Repeated order identifiers can multiply costs and refunds during a join. Use exact decimal arithmetic and document when you round. Reconciliation shows which export records the calculation carried through. Check source completeness against the expected transactions as a separate step.
Calculate contribution and rank the exceptions
An unknown cost leaves the final contribution unknown.
What to do
- Subtract attributable direct cost from net revenue for each reconciled unit with complete cost evidence. The result is gross contribution, the amount left after the recorded direct costs.
- For positive net revenue, divide contribution by net revenue and multiply by 100 to express gross margin as a percentage. For zero or negative net revenue, keep the known contribution and mark the percentage as having no meaningful value.
- Calculate a group margin from comparable summed contribution and revenue. State which units the result covers and how much revenue was omitted because the relevant costs or records were incomplete.
- Put verified negative contribution first, followed by misses against an approved target, other low margins worth reviewing, and consequential evidence gaps. Compare the size and recurrence of issues within the same currency and basis.
- Attach a source reference, likely decision owner, and next action to each priority row. Describe the mechanism shown by the records, such as a posted discount, and label a suspected explanation as a hypothesis.
Why
A small order can have a lower margin percentage than a high-value job with a larger loss. Review the amount alongside the percentage. Keep the full population behind an unprofitable orders report so reviewers can see which units had sound margins and which lack evidence.
Recheck the rows most likely to change a decision
A reviewer should be able to reproduce a priority row from its source records.
What to do
- Ask a separate finance reviewer to trace the largest exceptions from source records to output and recompute them. Include a case with a refund and a case with shared costs if those cases occur in the period.
- Check that a refund changes cost only when an actual cost reversal or other supported cost adjustment appears in the records. Confirm that the calculation uses historical actual costs and handles zero revenue and unknown costs as documented.
- Read the suggested action alongside the source evidence. For example, if the records show extra labor, ask the project owner to confirm the scope before recommending a change to the next quote.
- Resolve material defects before using affected figures. Record the issues you found, the corrections made, and any decisions that still depend on additional evidence.
Why
A repeat calculation can confirm the formula while a separate reviewer spots a wrong assumption, such as using a billable rate for labor cost. A posted discount can explain lower net revenue. Check approval records and sales context before changing the discount policy.
Give the owner a short decision queue
A margin exception is ready for handoff when the owner can see what to decide and why.
What to do
- Lead with the most consequential finding that the records support and state the next decision. Say which units, period, currency, and cost basis support the finding.
- For each priority row, show the unit, net revenue and direct cost, contribution and margin where known, the reason, the next action, the owner, and the source reference.
- Keep the supporting calculations and full population available so the owner can inspect a row without asking for a new report. If cost evidence is incomplete, make obtaining that evidence the action.
- Have a qualified finance person review the draft before using it in a pricing or operating decision. Give the decision owner the record of outstanding issues so unresolved figures stay out of the decision.
Why
Recorded losses describe what happened under the stated basis. Future improvement depends on what the business can change and how the next sale or job turns out. A clear handoff lets the owner review scope, price, or cost using the evidence that is available today.
Common mistakes
- Subtracting a discount twiceCheck whether the sales export already includes the discount before applying the adjustment record.
- Treating a blank cost as zeroA missing supplier invoice or incomplete labor record leaves final margin unknown.
- Using the latest cost as historical costUse the actual cost associated with the period and unit under review.
- Averaging row marginsCompute the group percentage from total comparable contribution and revenue so small and large sales carry their proper weight.
- Promising recovery from a recorded lossTie any future improvement estimate to a specific proposed change and an explicit basis for comparison.
What a good result looks like
- A fixed period, population, and reporting basis with separate currency groups.
- A full unit list that traces inputs and adjustments back to source rows.
- Reconciled counts and amounts, with exceptions or differences documented.
- An explicit cost-completeness state and scoped coverage for summary figures.
- Priority rows with an owner, supported reason, and one decision or follow-up.
And then what? Using the result
- Send repeated discount exceptions to the pricing owner to review against the current approval rules.
- Ask the project owner to confirm extra work and update the scope for the next comparable quote.
- Give operations the source records for recurring material or delivery cost issues.
- Assign missing costs and unmatched adjustments to the person who can locate the records, then recalculate the affected rows.
- Bring the reviewed decision queue to the next finance meeting and record which actions the owners accept.
When to run it
- After the period's direct costs are recordedUse the review to catch completed sales that missed your target or contributed a loss. Check which late costs still need to be posted.
- Before quoting similar work againReview completed jobs with comparable scope and actual cost capture. Use verified exceptions to identify which parts of the next quote need a closer look.
- After returns or fulfillment costs changeReview the affected orders and their posted adjustments to see where recorded contribution fell and which operational decision the evidence supports.
Questions people ask
How do you find realized margin exceptions?
Reconcile sales, adjustments, and direct costs for a defined population, then flag negative contribution and low margins using complete cost records. Attach the source evidence and a specific next decision to each priority row.
What is the formula for realized gross margin?
Divide net revenue minus attributable direct cost by net revenue and multiply by 100 when net revenue is positive and costs are complete. For zero or negative net revenue, show known contribution in money and leave the percentage unreported.
How do refunds affect realized gross margin?
A posted refund reduces net revenue once, and cost changes only when the records show a corresponding reversal or other cost adjustment. A returned item can leave the business with costs such as outbound delivery.
Can you calculate gross margin when costs are missing?
Leave final gross margin unknown until the attributable cost records are complete. You can show known costs separately and name the missing source, so finance has enough information to resolve the row.
How do you set a margin threshold?
Use the approved minimum for the sales population and cost basis being reviewed. If finance has set no target, flag verified negative contribution and rank observed low margins as candidates for review.
What is the difference between gross margin and markup?
Gross margin divides gross contribution by net revenue, while markup measures the amount above cost relative to cost. Use the denominator that matches the business question and label the result accordingly.
More jobs in Finance
Find realized margin exceptions, on your own Mac.Free app. Runs on your Mac with the Claude or Codex plan you already have. Your files stay on your computer.
Download for Mac