Inventory analysisData Analysis

Inventory and stock turnover analysis from your spreadsheet

Usually ready in 15 minutesRevisions includedQuality check
Packages
Payment protectionDetails
  • Revisions within the package are free.
  • If you do not respond within 3 days of delivery, the work is accepted automatically.

The money is reserved when you pay and released only once you accept the work.

Inventory and stock turnover analysis from your spreadsheet

Example result

Example for the Standard package

Inventory turnover analysis for a garden supply shop

Key numbers

  • Stock value today: $86,400
  • Average turnover: 3.1 times a year
  • 58 items (17%) have not sold in 90+ days: $14,900 stuck on the shelves

By category

CategoryStock valueTurnover per yearDays of stock
Seeds$6,2007.847
Fertilizer$12,4004.974
Pots$18,9002.2166
Tools$31,5001.6228
Decor$17,4001.1332

Turnover = cost of goods sold ÷ average stock value; days of stock = 365 ÷ turnover.

Findings

  • Decor holds 20% of the stock but brings 6% of sales; 22 items have not sold since spring
  • Tools: 3 premium pruner models make up $7,800 and sold 4 units in 9 months
  • Seeds sell out: 11 items were out of stock for 2+ weeks in April

Recommendations

  1. A 30% clearance on the 22 decor items before November
  2. Return or swap the slow pruners with the supplier (the contract allows it until December)
  3. Order seeds every 3 weeks in season, in smaller batches

Delivered

The report and the spreadsheet with ABC classes and a turnover formula for every item, ready for next season's data.

Client: Green Thumb Garden Supply, a shop with 340 items and a Square export for January–September 2026 Task: find slow-moving stock, how much cash is stuck in it and what to do before winter

The client and all details are made up.

About this service

Stock that sits for months freezes cash, while best sellers run out right before a busy week. We take your stock and sales export, calculate turnover and days of cover for each item, sort the range into fast, slow and dead stock and flag items you reorder too early or too late. You see where money is stuck on the shelf and what to reorder first.

What is included

  • What you getA report with turnover and days of cover per item, an ABC split of the range, a list of slow and dead stock with its value, and reorder suggestions. You get it on the order page and as a Word document, with the tables also as an Excel file (values only, no formulas or charts).
  • Turnover by itemHow many times stock sold through in the period
  • Days of coverHow long current stock will last at your sales pace
  • ABC splitWhich items bring most of the revenue
  • Dead stock listItems with no sales and the money tied up in them
  • Reorder notesWhat to buy sooner, later or not at all

How it works

  1. 1
    BriefYou attach the stock and sales export
  2. 2
    AnalysisWe calculate turnover, cover and ABC groups
  3. 3
    ReportYou get the tables, findings and reorder list

What we need from you

A stock and sales export from your accounting or store system as an Excel, PDF or CSV file or pasted text, the period it covers, and purchase prices if you want values in money.

We will ask you:

  • Which period does the export cover?
  • How long does it take a supplier to deliver after you order?
  • Are there seasonal items in the range?
  • What do you want to decide with the report?

Compare packages

PackagesBasic$15Standard$35Premium$69
What is includedUp to 100 itemsUp to 300 itemsUp to 1,000 items
Deadline1 day2 days4 days
Revisions123
Items (SKUs)up to 100up to 300up to 1,000
Summary tablesup to 3up to 6up to 10
Reorder suggestionsShortYesBy item group
Order BasicOrder StandardOrder Premium

Payment protection

You pay when you order, but the money is released only for accepted work.

  • Fixed priceThe package price does not change after you pay.
  • The money is reservedWhen you pay, the amount is only reserved. It is released to the service once you accept the work.
  • Checked before deliveryEvery result goes through a quality check before it reaches you, and you see it on the order page before accepting it.
  • Free revisionsAsk for changes within your brief as many times as the package allows.
  • Acceptance after 3 daysIf within 3 days of delivery you neither accept the work nor ask for changes, it is accepted automatically. If you write in the order chat after delivery, the order waits; once we answer, we may start the 3 days again and will say so in the chat.
  • Redo or a full refundIf the result does not match your brief and the revisions did not fix it, or the work takes more than twice its deadline, write in the order chat: we will redo the work or refund the payment in full.
How it works →

Questions and answers

My system exports stock and sales separately. Is that fine?

Yes. Attach both files and make sure item codes match, so we can join them.

What counts as dead stock?

By default, items with no sales in the last 90 days. Tell us if a different threshold suits your business.

Can you plan purchases for the next season?

We give reorder suggestions based on the sales in your export. A full purchase forecast is a separate service in our catalog.

Did not find your answer?

Packages