Skip to tool
Skip to tool
🛒 E-commerce & Pricing
ECECH AppPrecision calculator

Inventory Aging Report Analyzer

Paste or upload receipt-level CSV data to group remaining stock by age and cost value, review row errors, and export a report.
Stockroom shelves and a laptop showing inventory age buckets beside a barcode scanner and receipt paperwork.

Start with receipt-level inventory data

Use a CSV header row with sku, received_date, quantity, and unit_cost. Quantity must be the units still on hand from that receipt cohort at the report date. Dates must be YYYY-MM-DD; quantity and unit cost must be zero or greater.

Up to 5,000 data rows or 2 MB. Processed locally in this browser.

One receipt cohort per row, with its remaining on-hand quantity. Quoted CSV cells are supported. The first row must contain all four required column names; extra columns are ignored.

Or choose a CSV file

No file selected

The selected file replaces the pasted CSV. Its contents and filename never leave this browser.

Enter the report date in YYYY-MM-DD format. Inventory age is measured through this date. Use a date that matches the on-hand quantities in your receipt rows.

Comma-separated, increasing whole days.

Advertisement

How the calculation works

Local inputboundedPer-item ruledeterministicArtifactcopy / download

How to Use This Tool

Use this inventory aging report analyzer when you have receipt-level inventory rows and need to review remaining stock by age and cost value. Paste CSV or select one local CSV file; the browser groups receipt cohorts into editable age buckets, flags invalid rows, and creates a downloadable report.

How to use

  1. Prepare one header row containing sku, received_date, quantity, and unit_cost.
  2. Paste the CSV, choose a local file, or select Load sample to see the complete workflow immediately.
  3. Set the report date and increasing age cutoffs. The default cutoffs create 0–30, 31–60, 61–90, 91–180, and over-180-day buckets.
  4. Select Analyze inventory. Review the summary first, then inspect any row marked “Needs review.”
  5. Export only after the reported row count and total value reconcile with the source.

Required columns

sku identifies the item. received_date must be an ISO date such as 2026-08-20. quantity is the number of units from that receipt cohort still on hand at the report date, and unit_cost is its per-unit cost on one consistent valuation basis and currency. This input is important: the analyzer does not subtract later sales or transfers for you. Column order may vary and extra columns are ignored, but all four required names must appear in the first row.

Inventory aging formula and example

For each valid row, age in whole days is the selected report date minus received_date. Row value is remaining quantity multiplied by unit cost; the report sums those values into your chosen age buckets. With the sample report date of November 10, 2026, a receipt dated September 15 is 56 days old and belongs in the 31–60 day bucket. The sample has four cohorts: three valid rows total 130.00 in value, and 60.00 (46.2%) is more than 90 days old. One deliberately invalid date is kept as a review row rather than silently included.

0–30 days50.0031–60 days20.0091–180 days60.00
The sample summary surfaces the oldest bucket and its value before the detailed rows.

How to read the aging report

The oldest-bucket card shows where the maximum valid age falls. “Value over 90 days” is the sum of quantity multiplied by unit cost for valid cohorts older than 90 days, divided by total valid value for the percentage. Rows processed includes valid and rejected data rows, while the detailed table preserves source-row numbers so a correction can be made in the original CSV.

Common mistakes

  • Uploading a current SKU total without separate receipt cohorts: one aggregate row cannot reveal when its units arrived.
  • Using a date after the report date: future receipts are rejected instead of being assigned a negative age.
  • Mixing currencies or valuation bases in unit_cost: the displayed total is only meaningful when costs are comparable.
  • Entering unordered or duplicate cutoff days: bucket limits must increase from left to right.

Limitations

Age is an investigation signal, not proof that inventory is obsolete or should be discounted. This page does not forecast demand, consume sales history, allocate outbound orders, choose an accounting method, or recommend write-downs. It also does not join lots or warehouses unless those distinctions already appear as separate receipt rows. Preserve the source file and reconcile the exported totals before making operational or accounting decisions.

Privacy and local processing

The CSV is read and calculated in this browser tab. The tool does not send file contents, filenames, SKU values, dates, quantities, costs, or results to an ecech calculation service. The 2 MB and 5,000-row limits keep the interaction bounded on phones and ordinary laptops.

Sources & assumptions

Formula and interface checked 2026-11-10. The page uses a transparent receipt-cohort calculation; it does not claim to reproduce a platform’s native report.

Official references

Model assumptions

  • Dates are ISO calendar dates without time zones.
  • Quantity and unit cost share one valuation basis and currency.
  • Each row is a receipt cohort and its remaining on-hand quantity, not a current SKU aggregate.
  • The report date minus receipt date gives age; quantity multiplied by unit cost gives row value. All rows must use comparable costs in the same currency.
  • There is no direct Shopify, D365, SAP, or Oracle Fusion connector or vendor-specific column mapping. Reshape an export to the four documented columns and check that its quantities represent remaining units by receipt cohort.
  • It does not forecast sales, value inventory under an accounting policy, merge outbound allocations, identify lots or recommend write-downs.
Advertisement

Frequently Asked Questions

Which CSV columns are required?
The header row must include sku, received_date, quantity and unit_cost. Their order may vary, and extra columns are ignored.
Why is a row marked Needs review?
The row-level status explains whether its column count, SKU, date, quantity or unit cost could not be used. Valid rows remain available.
What counts as inventory over 90 days old?
A valid receipt cohort is included when its age on the selected report date is greater than 90 whole days.
Does this upload my inventory data?
No. Pasted and selected CSV content is processed locally in the current browser tab and is not sent to an ecech calculation API.
Can this decide which stock to discount?
No. Age can prioritize review, but sales velocity, seasonality, condition, obligations and accounting policy remain outside this report.
What does an inventory aging report show?
It groups the stock quantity and value represented by the input into age ranges. This analyzer dates each receipt cohort from received_date through the report date; it does not infer receipt dates from an aggregate SKU balance.
How do I calculate inventory age and value?
Age is the whole-day difference between the report date and received_date. Row value is remaining quantity multiplied by unit_cost. The analyzer sums row values in the age buckets you set; it does not calculate FIFO or weighted-average cost.
Can I use a D365, SAP, or Oracle Fusion report?
There is no direct ERP connection or built-in vendor column mapping. You can reshape an export into sku, received_date, quantity, and unit_cost columns if it contains one row per receipt cohort and remaining on-hand quantity. A grouped snapshot without receipt dates is not enough to calculate age.
Can I open or download the report in Excel?
Yes. Export report CSV creates a .csv file that Excel can open. This tool does not create an .xlsx workbook. Check the imported date and number formats in Excel before reconciling or sharing the report.
Which reference supports the report terminology?
Shopify’s documentation describes its own inventory snapshots and on-hand value reports. This page uses that documentation only as a terminology reference; the receipt-date and value formulas above are the explicitly stated rules of this independent calculator.

Related tools in E-commerce & Pricing

Browse all E-commerce & Pricing tools
A handwritten note reading ecech.com resting on the keyboard used to build the site.

Made by one person

ecech. is not a content farm. Every tool here is written and checked by hand, one at a time, by someone who wanted the tool to exist and could not find a version that showed its working.

No accounts and no sign-in, and nothing you type reaches a server — every calculation on this page runs inside your browser. The ads are served by Google and do set their own cookies, which is set out in full on the privacy page. More about the site.