Why the SRP rejected your upload
Nearly all rejections come down to one of a handful of causes. Each one is checkable before you open the portal.
Blank mandatory column
One row out of six hundred is missing a Unit Measure, or a SIN, or an order date. The template forbids leaving a mandatory column blank, and the file is judged as a whole. Check every mandatory column across every row, not the rows you happened to look at.
Total price mismatch
Total Price has to equal quantity times price per unit. It breaks when a discount is
applied to the line total but not the unit price, when a credit line carries a negative, or when
rounding is done at a different stage than the export expects. Recompute the total from the two
columns rather than trusting what the export carried over.
Invalid SIN
The SIN on the line has to be one your contract actually holds. Common causes: a SIN that was renumbered, a product moved to a different category since last year, or a typo that is a valid SIN just not one of yours. Keeping your own SIN list to hand and checking each line against it catches this before the portal does.
Formulas in the template
The template forbids formulas and macros. A cell that shows 1,201.50 but contains
=B2*C2 is a formula. Paste as values, or produce the file from something that only ever
writes values.
Extra tabs, renamed columns, reordered columns
All three are explicitly disallowed. The usual cause is a workbook rebuilt from scratch to look like the template rather than the actual template filled in. Column names have to match exactly, including their inconsistent spacing around the asterisks.
Dates the portal will not read
Every cell in the template is formatted as text, so what matters is the literal string in the cell.
A date exported as 14.07.2026 or as an Excel serial number is not the same thing as
07/14/2026. Normalise dates to one US-format string before writing them.
Wrong reporting period
This one is not rejected — it is accepted and wrong. Check that the month you selected in the portal matches the month the lines belong to.
Check all of it in one pass. The free validator reads your file and lists every blank mandatory column, every total that does not match, every unreadable date and every SIN that is not on your list — with the row number. Then it gives you the finished file.
Open the free validator