1 Load the two files
Both files are read inside your browser. Nothing is uploaded anywhere.
2 Check how it read your file
Read as — . Look down the Rate column below: if the wrong column is named, nothing else will be right.
| Sheet | Headings | Code col | Rate col | Qty col | Lines | Total |
|---|
Point at the right columns
Pick any one sheet. Whatever you choose is matched by heading text, so it carries across every sheet in the workbook that uses the same headings — and every future workbook that does too.
Saved mappings live in this browser only. Each person who uses the portal saves their own the first time.
3 Settings
These come out of your workbook. Change one only if this month genuinely differs — a change moves only the lines currently at the old value, so any line deliberately set to something else stays put.
Used only if the summary tab above applies.
The receipt window is measured back from this date.
- A manual override wins outright.
- Each vendor's rate is the price-list rate where there is one, otherwise the GRPO rate.
- Only vendors with a receipt inside the window count. If none has one, the newest record is used and the line is flagged stale.
- Vendors carrying a price-list rate are preferred. Where none does, a GRPO-only figure below the floor or above the ceiling is thrown out as a pack-size or currency artefact.
- A single vendor above the outlier trigger is discarded — unless two or more are tied there, which makes it real.
- The highest survivor wins.
4 Review, then download
| Sheet | Item code | Description | Qty | Old rate | New rate | Δ rate | Δ line | Status | How the rate was picked |
|---|
| Sheet | Row | Item code | Description | Old | New | What to look at |
|---|
The workbook keeps every tab, formula and format it came with. Only the rate cells change, and every total is recalculated so the file reads correctly the moment you open it.