How a Procurement Desk Can Sort a Working Worksheet From the Supplier's Clean Copy

Why the two files look identical at first glance

A procurement desk receives a supplier pack for a semiconductor materials enquiry. The folder holds two spreadsheets with almost the same name: one ends in a version suffix, the other carries the supplier's own naming convention. Both open. Both show the same column headers. Both list the same line items. The temptation is to treat them as duplicates and keep whichever was modified last.

That shortcut is where filing problems begin. A working worksheet is the desk's own scratch copy: it may carry added columns, re-sorted rows, highlighted cells and comments written by the buyer. The supplier's clean copy is the document as issued by the supplier: it should be retained unaltered as the record of what was actually received. If the two get merged, the desk can no longer show which figures came from the supplier and which were added internally.

This guide uses a fictional Singapore purchase desk and two fictional supplier documents to walk through a sorting exercise. It is a filing and document-control routine, not legal advice, and it does not describe any real supplier, customer or transaction. The aim is simple: at the end of the exercise, the desk knows which file is the working draft, which is the supplier original, and how each is labelled.

Set up the fictional exercise

Create a folder called something like Supplier Pack Exercise and place two files inside it. Name the first Supplier_Clean_Copy.xlsx and the second Working_Worksheet_v3.xlsx. Populate both with the same five columns: item description, quantity, unit, lead time and remarks. Use invented line items only, such as a generic materials line, a sample line and a documentation line. Do not use real supplier names, real prices or real customer references.

Now make the two files genuinely different in the ways a real desk would see. In the working worksheet, add a column headed Internal check, insert three comments, and highlight two rows. In the clean copy, leave the structure exactly as issued and add nothing. Save both. The exercise now has the two ingredients the desk must learn to separate: an unaltered supplier issue and a desk-modified draft.

This mirrors the kind of pack a Singapore team might assemble when sourcing semiconductor materials or discussing silicon recovery options, where a supplier sends a specification sheet and the desk annotates its own copy for internal review. The exercise stays fictional, but the filing discipline is the same one the desk applies to real packs.

Clue one: the file-owner label

The fastest signal is often the file-owner label. On a shared drive or document system, each file usually records who created it and who last modified it. In the exercise, the clean copy should show the supplier's issuing contact as owner, while the working worksheet should show a member of the procurement desk.

When the owner label is ambiguous, look at the file properties rather than the filename. A file named with the supplier's convention but owned by the desk is almost certainly a desk copy that was renamed. A file owned by the supplier but sitting in a desk subfolder may be the original that was moved after receipt.

Record the owner label in the filing note. A short line such as "Owner: supplier issuing contact; received date; stored in Inbound folder" gives the next reader a clear trail. If the owner label is missing entirely, treat the file as unverified and do not assume it is the clean copy.

Clue two: comments and tracked changes

Comments are the clearest fingerprint of a working document. A clean copy issued by a supplier normally carries no reviewer comments from the buyer's side. A working worksheet often carries several: a question about a lead time, a note to confirm a quantity, a reminder to check a specification.

Open the review pane in both files. In the exercise, the working worksheet should show three comments and the clean copy none. If the clean copy shows comments, ask whether they were added before or after receipt. Comments added after receipt mean the file is no longer a clean copy in the filing sense, even if the supplier's original text is untouched.

Tracked changes work the same way. A file with visible insertions and deletions is a draft in progress. A file with no tracked changes and no comments is a candidate for the clean-copy label, subject to the owner check above. Neither clue is decisive alone; together they narrow the field quickly.

Clue three: structure and formatting drift

Compare the two files side by side. The clean copy should match the supplier's issued structure: same column order, same row order, same formatting. The working worksheet will usually show drift. Added columns, re-sorted rows, colour fills, frozen panes and hidden columns are all signs of desk editing.

In the exercise, the working worksheet has an extra Internal check column and two highlighted rows. The clean copy has neither. That difference alone is enough to separate them, provided the desk confirms which file was received first.

Formatting drift is not automatically a problem. It is a signal. The desk should note what changed and why, then keep the clean copy untouched so the record of the supplier's issue stays intact. If the desk needs to work on the figures, it works on the worksheet copy, never on the original.

A short sorting checklist with example scores

Use a simple checklist to decide which file is which. The scores below are an author heuristic for the exercise, not a validated method.

Owner label matches supplier: clean copy yes, worksheet no. Comments present: clean copy no, worksheet yes. Tracked changes present: clean copy no, worksheet yes. Structure matches issued format: clean copy yes, worksheet no. Received-date note attached: clean copy yes, worksheet no.

A file scoring four or five clean-copy signals is a strong candidate for the original. A file scoring four or five worksheet signals is a draft. Mixed scores mean the desk should pause and check the receipt trail before labelling either file.

The checklist is deliberately short. A longer list invites debate about edge cases; a short list keeps the decision quick and repeatable across a busy desk.

Mark the draft without touching the original

Once the two files are sorted, label them clearly. Rename the working worksheet with a prefix such as DRAFT_ and add the desk's initials and date. Leave the clean copy's filename as received, and store it in a read-only or Inbound folder so it cannot be edited by accident.

Add a one-line filing note to each file's record: what it is, who owns it, when it was received or created, and where it is stored. The note is the part that survives staff changes and folder reorganisations.

If the desk later needs to annotate the supplier's figures, it copies the clean file, renames the copy as a new draft, and works there. The original stays as issued. This is the same principle behind keeping a supplier's specification intact while the desk prepares its own review notes for a semiconductor materials or silicon recovery discussion.

Where this fits at San Techno

San Techno Pte Ltd is a Singapore-based company working in semiconductor and solar materials, silicon recovery, specialized power module development, and botanical extracts under the ST GREEN brand. For procurement teams handling packs that touch silicon recovery, the desk routine above is a useful habit: keep the supplier's clean copy as the record, and keep the desk's working worksheet clearly marked as a draft.

San Techno helps recover non-usable silicon from integrated-circuit fabs, silicon wafer manufacturers, solar cell companies and chip packaging facilities, and these materials can be processed into reusable raw materials for solar wafers and cells. When a pack relates to that kind of discussion, the clean copy is the document the desk should be able to point to later.

The exercise in this guide is fictional and is offered as a filing discipline, not as a description of any real transaction. The sorting clues, the checklist and the labelling routine are practical habits the desk can adapt to its own folder structure.