How to filter a supplier inventory for an audit

A supplier inventory export can contain thousands of items, multiple suppliers, and records outside the audit period. Start with a copy of the file so you can narrow the records without changing the original evidence.

The CSV Editor can open a CSV in your browser, find values, sort columns, edit data, and remove duplicates. Use it to locate and review the records that meet your audit criteria. This workflow is manual, so verify each condition instead of assuming the file has been filtered automatically.

Filter the supplier inventory

1. Open the CSV Editor and open a working copy of the supplier inventory export. Keep the original file unchanged in case you need to check a value or restore a row.
2. Read the column headings and write down the audit scope. For example, you might need records for supplier ID SUP-204, received from February 1 to February 28, with a status of received. Include the fields that identify an item, such as SKU, lot number, warehouse, or purchase order.
3. Use the find function to locate the exact supplier ID or another reliable value. Prefer a supplier code over a company name if similar names appear. Check the neighboring columns to confirm that each match is the right record.
4. Sort by a scope column, such as supplier, date, warehouse, or status, to group similar records. Check each group against the audit conditions. A record belongs in the result only when it meets every required condition.
5. Create a reduced working copy with the matching records and their required columns. Use the editor's available editing controls, and keep identifiers such as SKU and lot number with each row. If you need a reusable, automatic rule across several columns, verify that your chosen workflow supports it before relying on the result.

Before changing or removing rows, note how many records matched and which conditions you used. If the export is very large, the CSV Editor can open files up to 10 million rows, but sorting and inspecting a large file can still take time.

Choose the right audit criteria

Filter by supplier and date

Use a supplier ID and a clearly defined date field, such as receipt date or inspection date. Do not treat order date, shipping date, and receipt date as interchangeable. If the audit covers the full month of February, confirm that the end date includes February 28, or February 29 in a leap year.

Filter by item, lot, or location

Use SKU for the product, lot number for a production batch, and warehouse or bin for the physical location. A matching SKU does not prove that two rows are the same inventory record. Keep separate lots or locations when the audit requires traceability.

Filter by status or quantity

Decide in advance whether the audit includes received, pending, returned, or quarantined items. For quantities, check that the column contains numbers rather than values mixed with labels such as 12 units. Include the unit of measure in your audit notes when items can be counted as pieces, cases, or pallets.

How to fix common filtering mistakes

1. Check the exact header. Similar columns may describe different events, such as order date and receipt date. Use the field named in the audit instructions, and record it in your notes.
2. Check IDs as text. Codes like 00127 and 127 may refer to different values in the source system. Do not remove leading zeros or treat similar supplier codes as interchangeable.
3. Review date formats. Dates such as 03/04/2025 can be read as March 4 or April 3, depending on the source format. Confirm the format before sorting or applying a date range.
4. Do not remove duplicates by SKU alone. The same SKU can appear in several valid lots, purchase orders, or locations. Compare the fields that define a unique inventory record before removing any duplicate rows.
5. Recheck the result against the source. Search for a few matching and nonmatching examples in the original file. Confirm that records outside the scope were excluded and that records meeting all conditions remain.

Keep an audit trail

Save the original export separately from the reduced working copy. Record the source file name, the date you prepared the copy, the criteria used, and the number of rows included. Preserve the supplier ID, SKU, lot number, and any other fields needed to trace each row back to its source.

For a broader review of the fields and structure in an inventory export, see how to review an inventory spreadsheet export. The CSV Editor opens and processes your file in the browser, so the file stays on your device.