Match the count sheet against the system on-hand by SKU and see every variance.
How it works
- Drop two files: Excel (.xlsx), CSV or a text PDF. Any pair works.
- The shared key (invoice number, ID, reference) and the matching columns are found automatically. Adjust them if needed.
- See what is clean, what is within your tolerance, what differs, and what exists on only one side.
- Export the result to Excel or CSV. The side you choose takes precedence.
Reading the result
- Amount differs on the quantity column: a count variance.
- Only in the count: counted but not in the system, often a receiving error or a new SKU.
- Only in the system: not found in the count, so missing or in another location.
Use a tolerance of 0 for serialized items and a small percentage for bulk goods.
Files are read inside your browser tab. Nothing is uploaded, no account is needed, and nothing is saved: closing the tab clears everything. The comparison code is open source.
Questions
Are my files uploaded anywhere?
No. The files are read and compared by code running in your browser tab. There is no server that receives them, no account and no storage; closing the tab clears them.
Is it free?
Yes. There is no sign-up. Files up to 50 MB and 150,000 rows each are supported.
What can I compare?
Excel (.xlsx), CSV and PDFs that contain selectable text with a table. Scanned PDFs (pictures of paper) are not supported.
How are rows matched?
On a key column both files share, such as an invoice number. The key is detected for you and can be changed. Rows are then compared column by column.
What is a tolerance?
How far two values may differ and still count as a match: for example 1, $1, 0.1%, "1 or 0.1%" for amounts, or 3 days for dates. Use ignore case for text.