Corrections to shared materials can affect several customer orders at once. A mistaken issue quantity may overstate one job, understate stock and distort the next purchase estimate. Replacing the old number without explanation makes later reviews harder, even if the new arithmetic is right. Preserve a clear trail from the original entry to the evidence and the corrected allocation, while distinguishing internal reallocations from changes in supplier charges or cash payments.
Identify the kind of correction
First ask what is wrong: payment amount, invoice component, received quantity, job issue or allocation formula. Each has a different consequence. A correction to which job used a sheet does not necessarily change the supplier’s bill. A supplier credit may change the amount owed without changing an earlier bank payment already completed.
Write a short description of the error before making changes. Include the purchase reference and affected jobs. This prevents a narrow quantity correction from becoming an undocumented rewrite of the whole transaction and helps a reviewer check exactly what changed.
Keep the original evidence intact
Retain the first invoice, delivery note and issue records. If a supplier replaces a document, keep both versions with dates and an explanation of which is current. Do not edit a saved statement or supplier document to match your corrected worksheet. The worksheet is your interpretation; the source remains evidence of what was originally recorded.
Save a dated adjustment note that names the prior entry, revised value and reason. Include the supporting reference, such as a returned-material slip or confirmed duplicate issue note. Where the reason is still uncertain, record the proposed correction as a question rather than presenting it as resolved.
Work through a reallocation
All figures in this hypothetical example are unspecified currency units. A batch of 60 identical pieces costs 300, or 5 each. The first worksheet allocates 20 pieces to Job Pine, 25 to Job Ash and 15 to stock. A later verified note shows that five pieces issued to Ash were returned unused to storage.
Correct Ash from 25 pieces to 20, reducing its allocation from 125 to 100. Increase stock from 15 pieces to 20, raising its allocation from 75 to 100. Pine remains 100. The combined allocation stays 300: no new supplier expense, refund or cash receipt has occurred.
Check the linked consequences
After changing quantities, inspect shared delivery allocations if their basis depends on those quantities or values. State whether the shared charge follows the corrected material allocation or remains assigned under an earlier documented method. Do not recalculate unrelated components automatically without considering the basis used.
Review any job summary, stock note and next purchase estimate that relied on the old figure. Mark which records were updated and which still need attention. A correct purchase worksheet can coexist with a stale job report unless the affected records are identified explicitly.
Separate supplier adjustments from internal fixes
If the supplier issues a credit for returned goods, record its reference and the goods it covers. A credit may reduce an outstanding balance, create an account credit or later lead to a payment back. Keep those events separate and rely on the actual documents rather than assuming they happen together.
When a cash refund is received, link it to the credit and original purchase so it does not appear as a new customer receipt. If the supplier has only acknowledged a request, keep it in the open-items list. Do not reduce confirmed cash outflow based solely on an expected outcome.
Leave a reviewable final position
At completion, show the original total, adjustments and revised allocations with a date. Reconcile quantities across jobs, stock and returns, then reconcile allocated values to the supported purchase cost. A reviewer should be able to reproduce the change without guessing which version of a worksheet they are reading.
Keep the explanation proportionate: a small correction can need only a short note and linked evidence. The essential elements are what changed, why, when and where its consequences were checked. With those elements visible, future reviews can use the corrected record confidently while still understanding the history that produced it.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


