The inventory package your bank actually wants to see

Three weeks into a working-capital conversation, the lender's analyst replies with one line: "Please include a current inventory schedule with aging." You have a Shopify admin, a cost spreadsheet, and no idea what an "inventory schedule" looks like to a bank. Here's the good news: the package is six documents, every one of them buildable in a day from Shopify exports plus one spreadsheet pass. Their job is narrow — prove the stock will sell inside the loan window, and state honestly what it's worth at cost.

What the lender is actually pricing

A lender looking at your inventory is not admiring your taste in products. They're pricing it as collateral, which means three questions:

1. Will it sell? Stock that moves before the loan matures is security; stock that doesn't is a liability they'd inherit.
2. What is it worth if they have to realize it? Lenders apply their own discount to the stated value — the advance rate — and that rate varies by lender, category, and seasonality. You don't set it; ask what they apply.
3. Can the record be trusted? Counts that reconcile, adjustments with reasons, one consistent valuation method.

Everything in the package below maps to one of those three questions. Educational framing throughout — this is document assembly, not lending advice, and which financing type fits your situation is its own topic.

The six-document package

Document 1 is a table: SKU count, total units, total cost value, total retail value, and a category split (for a hiking-socks catalog: crew, ankle, wool, accessories). One page. The rest of the package earns its length.

Building the aging report lenders read

The aging report is the heart of the package, and it's also the document most small merchants don't have. The full build method lives in the inventory aging report guide, but here's the shape, with a worked example — a hiking-socks brand, illustrative numbers throughout:

9,800 units across 88 SKUs. Cost value $71,400. Bucket every SKU by the age of its oldest receipt and sum cost value per bucket:

The number the analyst underlines: older than 90 days is $6,700 + $3,700 = $10,400, which is $10,400 ÷ $71,400 = 14.6% of cost value.

What the lender reads from that 14.6% depends entirely on your annotation. If you write nothing, they assume the worst — structural dead stock. If you add one honest line — "the $3,700 in the 180+ bucket is last winter's wool blend; it re-orders every January and sold through by March last year" — the same number reads as seasonal carryover, which is normal. Attach last year's monthly sales for those SKUs if you have them. Annotation is free; hiding the bucket is what gets packages sent back.

Valuation honesty: cost, not retail

The summary schedule shows cost value and retail value, but lenders discount from cost. Padding the schedule with retail or "brand value" is the fastest way to lose credibility — the analyst will re-derive cost from your COGS anyway.

For the valuation basis memo, state three things plainly: the method (FIFO or weighted average — the tradeoffs between them are covered in inventory valuation methods); that the figures are at cost, net of any damaged or obsolete reserves; and that the numbers reconcile to your books. For context on the accounting side: business inventory is valued at the beginning and end of the year and flows through cost of goods sold — that's the IRS's own framing in Publication 334, Tax Guide for Small Business (educational reference, not tax advice). Your accountant confirms the treatment; your memo just states the method.

Turnover: the one-page narrative

Document 3 exists because aging alone can mislead — a catalog can be "young" and still slow. Compute your inventory turnover ratio from the trailing twelve months, then add months of cover for your three largest categories. One paragraph is enough: "Catalog turns 3.1× annually (illustrative); the wool category carries 5.2 months of cover heading into its peak season; the accessories category carries 8.9 months and is the source of the 180+ bucket above."

That last clause matters more than it looks. You've now connected your aging to your turnover and explained the outlier before the analyst finds it. Packages that answer questions in order get processed faster than packages that provoke them.

What sinks a package

Five failure modes, all common, all avoidable:

• Stale data. A snapshot older than about 60 days signals that you don't know your position either. Refresh it the week you send.
• Retail-value padding. Covered above — it reads as either naivety or inflation.
• The unexplained 90+ bucket. Old stock without annotation is read as dead stock.
• No count record. If you can't show when stock was last physically counted, the schedule is a self-reported number, and self-reported numbers get discounted hardest.
• Sloppy multi-location math. If you hold stock in two places, reconcile both to the same date before summing.

Where financing enters — and where it doesn't

This article is the document set, not the decision. Whether a supplier-terms stretch, a revenue-based advance, or an inventory-backed loan fits your situation — and how to think about the cost honestly — is covered in inventory financing for small brands. Build the package first regardless: every financing conversation, including the informal ones with your current supplier, goes better with these six documents ready.

One tooling honesty note: InventoryX computes in-stock-only velocity and estimated lost revenue per SKU from your Shopify data, which is useful raw material for the turnover narrative — but it doesn't produce lender documents, and V1 has no valuation or aging features. The aging build and the memo remain spreadsheet work, which is exactly why the method above is manual.

Common questions

What inventory reports do banks ask for with a loan application? Typically an inventory summary schedule at cost, an aging report bucketed by age, a turnover or sell-through summary, and evidence stock was recently counted. Some lenders add their own template — ask early. The six-document package above covers the standard asks; assembling it before the request makes you look prepared rather than prompted.

Do lenders value inventory at cost or retail? Cost. Retail value belongs in your summary for context, but lenders apply their own advance rate against cost because realizing stock in a distressed sale fetches a fraction of retail. Padding schedules with retail figures damages credibility, since analysts re-derive cost from your COGS history anyway.

How current should the inventory report be? Dated within the month you send it — ideally the week. A snapshot more than about 60 days old suggests you don't track your position closely, and every number in the package inherits that doubt. Refresh the export, re-run the aging, and re-date the memo each time the conversation advances.

What is inventory aging and why do lenders care? Aging buckets your stock by how long it has been held — commonly 0–60, 61–90, 91–180, and 180+ days — valued at cost. Lenders care because old stock sells slowly and discounts deeply, so the share of value past 90 days is a direct read on collateral quality. Annotate seasonal carryover honestly; unexplained old stock is assumed dead.

Can Shopify data work as a lender-ready inventory report? Yes, as the source layer. Export the inventory CSV with costs, reconcile counts and adjustments, and format the six documents above from it. Shopify won't produce a lender package directly — the aging buckets, turnover narrative, and valuation memo are yours — but the underlying quantities and sales history are all exportable.

Next step

Assemble the package in one working day: exports and the summary schedule in the morning, aging buckets and the turnover paragraph after lunch, the memo and count records last. While you build, keep one rule in mind — every number dated, every anomaly annotated. Then, if the conversation turns toward borrowing against stock, read the options and honest math of inventory financing before you're in the room.