Year-End Stock Reconciliation: How to Match Your 3PL's Inventory Report to Your Accounts

To reconcile year-end stock held by a 3PL, take a dated inventory report as at your exact year-end, work out what you expect to hold from opening stock, receipts, sales and returns, explain each difference, apply consistent cut-off rules and value the result at the lower of cost and net realisable value. Agree the detail with your accountant.

When stock sits in someone else's warehouse, the closing figure in your accounts depends on a report you do not control. That works as long as the report is accurate, dated correctly and matches what your own records say should be there. When it does not, you get a stock figure nobody can explain, a difficult conversation with your accountant at the busiest time of year and sometimes a write-off nobody expected.

This guide explains how to prepare for year end with a third-party logistics provider, how to reconcile the report to your accounts, what auditors may ask your 3PL and what reporting to expect from your provider's warehouse management system. It is general information, not accounting advice, so agree the detail with your accountant.

Why Stock Held by a 3PL Needs Extra Care

Stock held by a 3PL is still your stock and belongs on your balance sheet, but you cannot count it yourself. You rely on the provider's records, so the quality of its report and audit trail becomes part of your year-end evidence.

If your accounts are audited, the auditor will want evidence too. Under the FRC's ISA (UK) 501, where stock held by a third party is material, the auditor must obtain evidence of its existence and condition, for example by asking the third party to confirm quantities and condition directly. Other procedures can include attending the third party's count. Tell your 3PL early if your auditor is likely to contact it or ask to attend.

Start With the Right Snapshot

Take the stock report as at your exact year-end date, not a few days either side. Stock moves daily, so a small drift in timing changes the figure.

Zmartly's guide to a year-end stock count for stock held by a third party, written for Amazon sellers, makes the same point and recommends keeping a dated copy of the report as evidence. Agree with your provider in advance how to produce a report as at a specific date and time, and what it will show.

Work Out What You Expect to Hold

Start from opening units, add everything received during the year and subtract units sold, then adjust for returns, write-offs and stock removed. The result is the quantity you expect the 3PL to hold.

Compare that expected figure with the report and investigate each gap. Allow for items you have claimed for as lost or damaged and stock already removed. Returns are a common source of gaps, because items may be refunded before they are physically back in stock. The aim is a closing figure you can explain, supported by a short note for each difference.

Get the Cut-Off Right

Stock in transit at year end is the hardest to get right. Goods leaving a supplier, arriving at the warehouse or awaiting putaway may be outside the system on one side and inside it on the other.

Decide where you draw the line, whether by date of receipt into the warehouse, by system booking or by ownership under your supplier terms, and apply it every year. The same applies to orders dispatched but not yet delivered and to returns in transit. Ask your 3PL to stop or flag receipts and dispatches around the cut-off time so the snapshot is clean.

How Is Stock Valued at Year End?

Under FRS 102 Section 13, stock is valued at the lower of cost and net realisable value. Net realisable value is the estimated selling price less the costs to complete and sell.

Cost usually includes the purchase price plus import duty and freight to get goods to the warehouse. Zmartly's guidance for Amazon sellers notes that warehouse storage and fulfilment fees are not part of stock cost; the same principle usually applies to 3PL fees, but confirm the treatment with your accountant. Slow-moving, damaged or out-of-date stock may need writing down. HMRC's Business Income Manual (BIM33145) notes that slow-moving stock does not by itself mean its value is below cost, and that formula-based provisions are acceptable if they reflect a realistic view of future sales. That judgement is for you and your accountant, but it depends on the warehouse report showing what is there, in what condition and from which batch.

Common Reasons for Differences

Most differences between a 3PL inventory report and your accounts have straightforward explanations. A detailed report should help identify the cause of each discrepancy, making it easier to reconcile stock records without relying on guesswork.

Timing differences are a common cause of discrepancies, particularly when orders have been dispatched but have not yet appeared in your sales records. To investigate these differences, request a dispatch report from your 3PL that covers the exact cut-off time used for your stock reconciliation.

Unprocessed returns can also create inconsistencies when customers have received refunds, but the returned products have not yet been added back into available stock. Ask your 3PL for a record of returns received but still awaiting processing at the reporting cut-off.

Damaged or quarantined stock may be excluded from available inventory figures, even though the products remain physically present in the warehouse. Requesting an inventory report broken down by stock status will help distinguish between available, damaged and quarantined items.

Kits and bundles can cause discrepancies when stock is counted both as individual components and as finished products. Confirm how your 3PL records kits and bundles within its inventory system to ensure quantities are not being counted twice.

Samples and marketing stock may have been removed from inventory without a corresponding sales transaction. Request an adjustments report organised by reason code to identify stock allocated to promotional activities, product samples or other non-sales purposes.

Stock transfers between warehouse locations or sales channels can also affect reported inventory balances. Reviewing the transfer log for the relevant accounting period will help identify stock movements that may not yet be reflected in your financial records.

Finally, stock losses may result in unexplained shortfalls between the quantities recorded in your accounts and those reported by the warehouse. In these cases, ask your 3PL for the inventory variance history, including details of any adjustments made and who authorised them. This provides a clearer audit trail and helps identify discrepancies that require further investigation.

Questions to Ask a 3PL Before Year End

Ask these early in your financial year, not in the final week:

• Can you run a report as at a specific date and time, and how far back can it go?
• What does it show: available, allocated, damaged, quarantined and in transit?
• Does it include batch and expiry data?
• How are cycle counts and full stock takes carried out, and how often?
• How are variances recorded, and who approves adjustments?
• How do returns and kits appear in the numbers?
• Will you confirm quantities directly to our auditor, and can the auditor attend a count?
• Who helps us when our accountant has questions?

Where Fulfil with Synergy Fits

Fulfil with Synergy, the Northampton-based third-party logistics provider, tracks stock to unit, SKU, batch and location level in its RedPrairie Dispatcher system, with a full stock movement audit trail that is time-stamped, user-tagged and fully categorised. Visibility covers every connected sales channel, which matters for brands selling through multi-channel and retail routes.

Its client portal lets brands monitor inventory, stock movements and allocations, track returns in real time and download custom-built reports, and reporting is shaped around each brand's priorities, from merchandising to finance. Rather than only sending reports, the team helps businesses understand what the reports mean and how to use them, and each brand has dedicated account management to answer questions quickly. Our article on what good inventory reporting should look like from a UK 3PL sets out what to expect, and the guide to ERP connected fulfilment covers linking your accounting system. Speak to the team early in your financial year about the reports and dates you will need.

A Year-End Timeline

1. Eight weeks before: agree report dates, format and any auditor confirmation with your provider.
2. Four weeks before: review current variances and clear open items, such as unprocessed returns and aged stock.
3. Final week: confirm cut-off rules and brief your accountant.
4. Year-end date: take the snapshot and save a dated copy.
5. Following days: reconcile to your records and write a note for each difference.
6. Close: agree adjustments and keep the documents in your year-end file.

Aged stock is easier to deal with before year end than after; our guide to storage fees and aged inventory charges explains the costs of leaving it.

FAQ

Why do 3PL stock reports differ from my accounts?

Usually because of timing, returns not yet processed, damaged or quarantined stock, kits and bundles, samples, transfers or stock in transit at the cut-off date. Genuine loss is less common than these ordinary causes. A good 3PL report separates stock by status and records adjustments with reason codes, so each difference can be explained. Work out what you expect to hold from opening stock, receipts, sales and returns, compare it with the report, and write a short note for each gap, so you and your accountant can agree any adjustment.

What date should the stock report be as at?

Your exact year-end date, and ideally the time your trading day closes. Stock moves every day, so a report taken a few days either side can change the figure and make reconciliation harder. Agree in advance with your provider how to produce a report as at a specific date and time, and ask it to flag receipts and dispatches around the cut-off. Save a dated copy of the report with your year-end file, because it is your evidence if the figure is questioned later.

How is stock valued at year end in the UK?

Under FRS 102 Section 13, stock is valued at the lower of cost and net realisable value, which is the estimated selling price less costs to complete and sell. Cost usually includes purchase price, import duty and freight to the warehouse, while 3PL storage and fulfilment fees are generally treated as running costs rather than stock cost. Slow-moving or damaged stock may need writing down, but HMRC guidance notes slow movement alone does not prove value is below cost. Your accountant applies these rules to your circumstances.

Will my auditor contact my 3PL?

Possibly. Under ISA (UK) 501, if stock held by a third party is material to your accounts, the auditor must obtain evidence of its existence and condition. That often means asking the 3PL to confirm quantities and condition directly, and it can also mean attending the provider's stock count or reviewing its controls. Tell your 3PL early in your financial year if an audit is likely, agree who will respond to the confirmation request and check that the provider can produce a report as at your year-end date.

Does Fulfil with Synergy provide an audit trail of stock movements?

Yes. Fulfil with Synergy's RedPrairie Dispatcher system tracks stock to unit, SKU, batch and location level, with a full stock movement audit trail that is time-stamped, user-tagged and fully categorised. Brands can monitor inventory, movements and allocations in the client portal and download custom-built reports, including reports shaped around finance needs. Dedicated account management helps you understand what the reports show, so you can plan year-end dates and formats with the team well before the year closes.

If you want your stock report to reconcile cleanly at year end, talk to Fulfil with Synergy about the reports and dates you will need.

‍