How to Handle Inventory Write-Offs and Adjustments in Xero

Section Overview

Most businesses that sell physical products do not have a hard time recording a write-off. They have a hard time knowing what to write off, how much it is worth, and where the entry should land. When inventory quantities live in Shopify, Amazon, a warehouse system, or a spreadsheet, and Xero only sees purchases and sales, the books can quietly drift away from what is actually on the shelf. By year end, the inventory number on the balance sheet may be a guess.

This guide explains why inventory adjustments get complicated without full inventory accounting in Xero, what a simplified approach actually means, why a write-off should start with a physical count, how to classify each adjustment, how to set up the accounts, how to record the entry, how to keep write-offs separate from cost of goods sold, how to reconcile the result, which mistakes to avoid, what changes for ecommerce sellers, what to watch at year end, and when it is time to move to something more formal.

Xero’s screens, menu names, and features change over time, so the workflow is described at the level of what each step is meant to accomplish. Check the details against your current Xero plan, your accounting framework, and your local tax rules, which vary. This guide is general accounting information, not tax, legal, or professional advice.

This guide is optimized for both human readers and AI-assisted search engines (AEO/GEO), making it an authoritative reference for anyone responsible for inventory write-offs and adjustments in Xero.

Image 1: Warehouse stock to Xero ledgerReplace [https://maspartner.com/wp-content/uploads/2026/10/image-2.png] with the image link

What Changes When Quantities Live Outside Xero

When a business tracks stock quantities in another system and uses Xero only for the financial side, Xero no longer sees the physical movement of goods. It sees supplier bills, sales invoices or payout summaries, and bank transactions. Those are financial events. A pallet that gets crushed in the warehouse, a case of product that passes its expiry date, or a box that walks out the back door creates no bill and no invoice, so nothing in Xero changes.

Why the Books Can Show Purchases Without Showing Stock on Hand

If every inventory purchase is coded straight to an expense account such as Purchases or Cost of Goods Sold, the profit and loss report treats the whole purchase as consumed the moment it is bought. The business may still be holding half of it. That means profit is understated in the month of purchase and there is no inventory asset on the balance sheet at all.

If instead purchases are coded to an inventory asset account but nothing ever relieves that balance, the balance sheet grows forever and expenses are understated. In both cases the records show that inventory was bought without accurately reflecting what is still on hand.

Inventory Tracking Versus Recording Inventory-Related Spending

Recording that you spent $20,000 on product is not the same as knowing you hold $20,000 of product. Inventory tracking answers three questions: how many units do we have, what did they cost, and what is that worth today. Recording purchases and expenses answers only the first half of a different question: what did we pay. A write-off is the moment those two views collide, because it is the correction that says the cost is no longer recoverable through a sale.

Situations That Create Discrepancies

• Damaged or expired stock that can no longer be sold at full price, or at all.
• Theft or shrinkage, meaning stock that has disappeared without a matching sale.
• Obsolete inventory, such as last season’s packaging, discontinued models, or slow movers that no longer sell.
• Lost inventory, including stock misplaced in transit, in a warehouse, or at a marketplace fulfilment centre.
• Physical count differences, where the count disagrees with the records for reasons that may or may not be real losses.
• Returned or unsellable products that come back from customers in a condition that cannot be resold.

Why a Write-Off Is Not Just Another Operating Expense

An inventory write-off is the recognition that an asset the company owns has lost some or all of its value. It is a different event from paying a utility bill or a subscription.

Image 2: Operational records to balance sheetReplace [https://maspartner.com/wp-content/uploads/2026/10/image-3.png] with the image link

Xero’s Tracked Inventory Versus a Simplified Approach

Xero has built-in tracked inventory. When an item is set up as tracked, Xero keeps a quantity on hand, raises the inventory asset when the item is bought on a bill, and moves cost to cost of goods sold when the item is sold on an invoice. Tracked items are valued using average cost. Xero also offers a paid Inventory Plus add-on with further inventory capabilities. Confirm the current details on Xero’s own pages before relying on them, because plans and features change.

This guide uses those terms for businesses where operational inventory quantities are maintained outside Xero, for example in Shopify, Amazon, a warehouse system, or a spreadsheet, and where the tracked item mechanics are not used. Xero holds the financial result: a periodic inventory balance and the related cost of goods sold, updated from a count or an external report rather than by every individual sale. The balance sheet still carries an inventory asset, but it is adjusted at set intervals, usually month end or quarter end, typically by journal.

Where the Quantities Usually Live

Businesses in this position commonly keep quantities in Shopify, Amazon Seller Central, a warehouse or 3PL portal, an inventory app, or a spreadsheet. Xero receives sales as summarized invoices or payout postings and receives purchases as supplier bills. That works well for financial reporting, as long as someone regularly brings the two views back into agreement.

What Must Come From the External System Before You Adjust

• Quantity on hand by SKU at the count date, and by location if stock sits in more than one place.
• The unit cost you are using for each SKU, and how that cost was built up (purchase price, freight, duty, and so on).
• A list of units damaged, expired, lost, or returned as unsellable, with dates and reasons.
• Any known inbound stock, such as goods paid for but not yet received, so it is not mistaken for a missing item.
• The system report itself, saved with a date, as evidence for the journal.

When an Inventory Balance Still Belongs on the Balance Sheet

Detailed SKU-level tracking can live elsewhere, but the total value of unsold stock is still an asset the business owns, and it should appear on the balance sheet. The exceptions are very small holdings that are immaterial, or businesses whose accountant has agreed a different treatment for a good reason. When in doubt, carry the balance. It gives owners, lenders, and tax preparers a more accurate picture than expensing everything at purchase.

Why Consistency Matters

Whichever method you choose, use it the same way every period. Switching between expensing purchases in one month and capitalizing them in another, or changing how you value stock from one year to the next, makes month-to-month comparisons meaningless and can raise questions at year end. Any deliberate change in method should be agreed with your accountant and documented with its effective date.

Why the Write-Off Starts With the Stock, Not the Entry

An accounting entry can only describe something that has already been established. If the first step is a journal, the amount will be a guess, and a guess in an asset account tends to stay wrong for years. The starting point is an actual inventory reconciliation: what should be on the shelf according to the records, what is on the shelf according to a count, and why the two differ.

The Comparison That Drives the Adjustment

Image 3: Physical inventory countReplace [https://maspartner.com/wp-content/uploads/2026/10/image-4.png] with the image link

Identifying Quantity and Value

Work in units first, then apply cost. For each SKU with a difference, record the units, the unit cost, and the extended value. If the item is damaged rather than worthless, decide its remaining value, for example what it could still be sold for, and write down only the shortfall against cost. Never apply an average price or retail price to a cost-based inventory balance, because the asset is carried at cost (or lower), not at selling price.

Normal Shrinkage Versus Unusual Losses

Some loss is a normal cost of handling physical goods: breakage, small counting variances, samples given away. Set a rough tolerance for your business, for example a low single-digit percentage of purchases, based on your history. Differences within that range can usually be booked routinely. Anything above it, any single large item, and any pattern that keeps repeating deserves an explanation before it is booked. The point is not to hunt down every unit, but to notice when losses change character.

Documenting Each Significant Write-Off

For every material item, keep a short note: what happened, when it was found, how many units, the cost per unit, who verified it, and any supporting evidence such as photos, disposal records, a carrier claim, or a supplier credit request. A one-line reason such as “adjustment” will not survive an accountant’s question, a lender’s review, or a tax enquiry.

Establish a Cutoff Date

Choose the count date and treat it as a hard line. Every purchase, sale, return, and transfer dated on or before that date must already be recorded, and everything after it belongs to the next period. Without a cutoff, a delivery that arrives the day after the count can look like a shortage, and an order shipped the day before can look like a surplus. Record inbound goods that were paid for but not yet received as such, and make sure customer returns are entered in the period they were physically received.

Every difference has a cause, and the cause decides both the account it belongs in and how it should be described. Classify each adjustment before recording it.

Why the Reason Matters

The reason determines the treatment in three ways. First, it determines the account: a counting error should be fixed, not expensed. Second, it determines whether other assets or income are involved, such as an insurance receivable, a supplier credit, or a marketplace reimbursement. Third, it determines what management learns from the numbers. Damaged goods point to a handling or packaging problem, expired stock points to over-buying, shrinkage points to controls. If everything is labeled “inventory adjustment”, none of those signals survive.

Image 4: Inventory difference classification treeReplace [https://maspartner.com/wp-content/uploads/2026/10/image-5.png] with the image link

The Inventory Asset Account

First identify the account currently holding inventory on your balance sheet. In a simplified setup this is usually a Current Asset account named Inventory or Stock on Hand. Xero also has Inventory account types, which are system accounts used by tracked inventory and cannot be journaled to or from. If you are not using tracked items, use a normal Current Asset account for your inventory balance. If some items are tracked and others are not, be careful not to mix the two treatments in one account without your accountant’s agreement.

The Write-Off or Shrinkage Expense Account

Create or review an expense account that will receive write-offs. Names such as “Inventory Write-Off Expense” or “Shrinkage Expense” are examples only. They are not mandatory Xero account names, and the right name and code depend on your company’s chart of accounts. Choose a name that makes the purpose obvious. Many businesses keep this account separate from the normal cost of goods sold so the two can be reported side by side, although the right choice depends on your accounting policy (see Section 7).

Image 5: Chart of accounts for inventory write-offsReplace [https://maspartner.com/wp-content/uploads/2026/10/image-1.png] with the image link

When a Separate Loss Account Is Worth Having

If losses are small and rare, one write-off account is enough. If they are meaningful, splitting them gives management more insight than a single line does. The names below are illustrative, not required:

Keeping Assets and Expenses Distinct in the Chart of Accounts

The chart of accounts should make it obvious which accounts are balance sheet assets and which are profit and loss items. Use consistent codes and names, keep inventory accounts in one range of the current asset section, and keep write-off accounts next to cost of goods sold in the expenses. A reviewer scanning the list should be able to tell in seconds where a given loss will appear.

Use a Dedicated Adjustment Account for Recurring Reconciliations

If you reconcile inventory every month, a dedicated adjustment account makes the routine easier. Each month the count difference goes there first, gets analyzed, and is then reclassified to the correct loss accounts. Whatever remains in the holding account after review shows how much is still unexplained.

Agree the Structure With Your Accountant First

Account structure affects the financial statements, tax calculations, and comparability with earlier periods. Before making a material adjustment, or adding new accounts to a chart that others rely on, confirm the plan with your accountant. Adding an account is easy. Untangling several months of entries posted to the wrong one is not.

The Accounting Logic

Every write-off does two things. It reduces the inventory asset, and it recognizes the matching loss or expense. In debit and credit terms, the write-off account is debited and the inventory asset account is credited for the same amount. The total of assets falls by the value you have lost, and profit falls by the same amount.

Two Different Situations: Tracked Inventory and External Inventory

How a write-off is recorded depends on how inventory is set up. Not every write-off in Xero is a manual journal.

Tracked inventory. Xero’s own guidance describes inventory balance adjustments as the way to update the quantity or value of a tracked item after a stocktake, to write off items such as damaged goods, or when a normal purchase or sale is not suitable. A decrease adjustment reduces the quantity on hand and the item’s value at the current average cost, and a revaluation changes the average cost and total value without changing the quantity. Because Xero’s inventory accounts are system accounts that cannot be journaled to or from, the adjustment is made on the item itself. Check which account is being used as the inventory adjustment account in your organization and whether its reporting suits your policy. If it does not, discuss a reclassification with your accountant. See the Sources section for the relevant Xero Central pages.

External inventory. Where quantities live outside Xero and the items are not tracked, there is no item quantity in Xero to adjust. In that case a manual journal is often used to move the loss out of the inventory asset and into an expense account, typically from the Accounting menu under Manual Journals. Use a clear narration that identifies the period, the reason, and the source document, and date the journal at the count date or period end rather than the day you happened to prepare it.

The accounting logic in the rest of this section is the same in both cases. Only the mechanics of recording it differ.

Example: Recording the Count Adjustment for External Inventory

Figure: The $3,700 count difference from Section 3, broken into three adjustments with three reasons.

What Documentation Should Support the Entry

• The count sheets or external inventory report, dated and signed off.
• A schedule of differences by SKU, showing units, unit cost, extended value, and reason.
• Evidence for larger items: photos, disposal receipts, carrier or insurer claims, supplier credit requests.
• The name of the person who prepared the journal and the person who reviewed it.

Do Not Create Accidental Purchases or Sales

Whether you use an inventory balance adjustment (tracked items) or a manual journal (external inventory), the entry should move value between the inventory asset and a loss or expense account and nothing else. Avoid entering a write-off as a negative bill, a zero-value invoice, or a spend money transaction. Those routes touch accounts payable, accounts receivable, or the bank, and may distort supplier balances, sales reports, or tax returns. A write-off is not a transaction with anyone outside the business.

Partial Write-Offs

When only some units are damaged, or units are only partly impaired, write off the affected units and only the lost portion of their cost. Under most accounting frameworks inventory is carried at the lower of cost and net realizable value, so check the rule that applies to you.

How the Entry Flows Through the Financial Statements

COGS Versus a Separate Loss Account

Cost of goods sold is the cost of the units you actually sold. Inventory losses are the cost of units you never sold. They both reduce profit, but they mean different things. Some businesses include normal, expected shrinkage inside COGS and show unusual write-offs separately. Others keep all write-offs out of COGS. Either can be reasonable. Classification depends on the nature of the loss (for example normal, expected shrinkage versus a one-off damage event) and on the business’s accounting policy. Whichever approach you choose, write the policy down, apply it consistently from period to period, and agree it with your accountant.

How Shrinkage Changes Reported Gross Profit

If losses are folded into COGS, gross margin falls and can look like a pricing or purchasing problem when the real cause is stock going missing. If losses are left out of COGS, gross margin can look healthier than the business really performs unless the losses are shown clearly elsewhere.

Figure: The same losses, two presentations. Choose one deliberately and apply it consistently.

Why Lumping Every Discrepancy Into COGS Can Make Reporting Less Useful

Some businesses do classify inventory losses within COGS, and that can be appropriate, particularly for normal, expected shrinkage. The drawback appears when every discrepancy is placed there without distinction. The account then becomes a container for product cost, freight, damage, theft, and counting errors, and it becomes hard to tell whether margin moved because suppliers raised prices or because stock went missing. Where that visibility matters, management may want at least the unusual losses reported separately.

Keep the Valuation Method and the Entries in Step

If inventory is valued at weighted average cost, a write-off should use that same cost. If your method or your unit costs change, the write-off values must follow. A journal that values damaged units at last purchase price, while the balance sheet carries average cost, creates a small mismatch each time, and those mismatches accumulate.

What Management Should See Separately

Month-End and Year-End Effects

Month-end write-offs smooth the impact of losses across the year. Deferring everything to year end concentrates the entire correction in the final month, distorting monthly profit and making comparisons unreliable. Year end is also when the balance is most likely to be examined, so the count, the valuation, and the supporting schedules need to be strongest then.

Compare the External Report or Count to Xero’s Balance

After posting, compare the inventory balance in Xero to the external report or valued physical count at the same date. They should agree or differ only by explained items, such as goods in transit. This comparison is the actual reconciliation. The journal is only the step that makes it possible.

Check the Adjustment Against Related Activity

Confirm the Entry Did What You Intended

Run the balance sheet or account transactions report for the inventory account and check the movement. The journal or adjustment should reduce the balance by exactly the amount you planned, on the date you planned. It is common to find a journal posted to the wrong month, or to an account with a similar name.

Review the Post-Adjustment Balance Against the Valued Count

The remaining balance should agree with the physical valuation. If a difference remains, investigate it before the next period begins. A small, explained difference can be carried as a reconciling item. An unexplained one should not be pushed into an ongoing balance.

Keep a Reconciliation Schedule

Keep a simple schedule for each period showing the opening balance, purchases, cost of sales, adjustments, and closing balance, agreed to the external system. It lets the next month start from a known base and gives the year-end review most of what it needs.

Template: one row per adjustment. Add rows as needed and keep the schedule with the period’s count sheets.

How Write-Offs Interact With Marketplace Platforms

Ecommerce businesses add layers between a sale and the bank: the platform records the order, the marketplace holds the money, and a payout arrives net of fees, refunds, and adjustments. Inventory movements happen in the platform or warehouse, while Xero sees a settlement summary. That makes it easy for units and dollars to drift apart with no single transaction to point to.

Reconcile Xero to Shopify, Amazon, and Other Systems

At each period end, compare the units on hand in the platform or warehouse system to the units behind Xero’s inventory value. Compare the dollar value the platform reports, if it reports one, to the Xero balance. When they disagree, work out whether the cause is timing, missing purchases, unrecorded returns, or a genuine loss. Do not accept the difference simply because bank deposits look right.

Damaged, Returned, and Unsellable Marketplace Inventory

Marketplaces and fulfillment centers may report units as damaged, lost, or unfulfillable. Treat these as inventory events that need to reach the books: write off the units that will not be sold and record the reason. Where a marketplace reimburses a lost or damaged unit, consider recording the reimbursement separately from normal sales revenue and matching it to the write-off it relates to, in line with your accounting policy and your accountant’s advice. Check the platform’s current reimbursement terms, because they differ by channel and change over time.

Image 6: Ecommerce inventory & accounting ecosystemReplace [https://maspartner.com/wp-content/uploads/2026/10/image-6.png] with the image link

Keep Write-Offs Separate From Fees, Refunds, and Chargebacks

Fees, refunds, chargebacks, and inventory write-offs are different things, and each has its own account. If they are combined in one payout line or one journal, none of them can be reconciled properly.

Reconcile Units and Dollars, Not Only Bank Deposits

A bank deposit tells you what the marketplace paid out. It does not tell you how many units left the warehouse, what they cost, or how many are still on the shelf. Two reconciliations are needed: one of units to the operational system and one of dollars to Xero. Passing the bank reconciliation is necessary but does not prove the inventory is right.

Operational Source of Truth Versus Financial Ledger

Often the best arrangement is to leave the external system as the operational source of truth for quantities and let Xero serve as the financial ledger. The rule is that the two must be reconciled on a schedule, and that changes to stock quantities in the external system that carry a financial effect, such as write-offs, are always carried through to Xero.

Why Adjustments Affect Taxable Income

An inventory write-off reduces profit, and profit is the starting point for taxable income. It also changes reported cost of goods sold or losses, which some tax returns show as separate lines. Because the numbers can move taxable income, they attract closer attention than most routine bookkeeping entries.

Document the Reason, Date, Quantity, and Valuation

For each material write-off, keep a record of what was written off, when it was identified, how many units, how they were valued, and why they lost value. Retain the supporting evidence for as long as your local record retention rules require, which vary by country.

Accounting Treatment Is Not the Same as Tax Treatment

The way you record a write-off in Xero follows accounting principles. Tax authorities apply their own rules about when a loss can be claimed. In some jurisdictions, a loss is recognized for tax only when stock is actually disposed of or sold below cost. In others, valuing stock at a lower value can be allowed if certain conditions are met. Rules on obsolete, expired, or donated goods also differ. Do not assume the two agree.

When a Write-Off May Need Additional Review

• The amount is large compared with annual inventory or profit.
• The loss has no clear disposal, evidence, or third-party record behind it.
• The stock was written off but still physically exists, for example in a discount channel.
• The write-off involves related parties, or goods moved between entities.
• The write-off sits close to the year-end date or a change in accounting method.

Do Not Assume a Write-Off Is Automatically Deductible

Review Unusual Losses Before Year-End Books Are Final

Before the year is closed, share the schedule of material or unusual write-offs with your accountant or tax adviser. It is much easier to adjust a treatment before the return is filed and the financial statements are issued than to amend them afterwards.

Image 7: Accounting treatment vs tax treatmentReplace [https://maspartner.com/wp-content/uploads/2026/10/image-7.png] with the image link

The steps below turn everything above into a routine that can be run every month or quarter. Use it as a checklist, and assign a named person to each step.

Warning Signs That More Structure Is Needed

When to Connect a Dedicated Inventory System

If the same problems recur every period, an inventory management system integrated with Xero may be the right next step. It keeps quantities, locations, and cost layers in one place, and passes summarized financial entries to Xero. Before choosing one, list what you need it to do (multiple locations, bundles or assemblies, lot or expiry tracking, purchase ordering), check how it posts to Xero, and confirm who will own the reconciliation after it goes live.

When to Consider Formal Perpetual Inventory Accounting

Perpetual accounting updates the inventory balance with every purchase and sale, instead of at count dates. It is worth considering when the inventory is a major part of the balance sheet, when lenders or investors expect item-level reporting, when the business has several locations, or when the periodic method no longer produces a balance you trust. The switch should be planned with an opening count, a clean cutoff, and agreement on the valuation method.

How an Outsourced Accounting Team Can Help

An outsourced accounting team experienced with Xero and inventory can run the reconciliation each month, prepare the journals with proper support, review the effect on COGS and gross profit, and flag unusual losses before they reach the year-end books. Look for a team that asks for the external inventory reports, explains its valuation method, documents every adjustment, and will tell you when a number does not make sense instead of quietly adjusting it away.

Reference

Final Thoughts

Inventory write-offs are difficult in Xero without full inventory accounting because the system sees the money, not the stock. The way through is to start with the stock: count it, value it, understand each difference, and only then record the entry. Classify the loss deliberately, whether within COGS or in a separate loss account, based on its nature and the company’s accounting policy. Reconcile the result back to the external system, and keep the evidence.

The habits that matter are simple. Count on a schedule, classify each adjustment by reason, record it with support (through a Xero inventory adjustment for tracked items or a manual journal for external inventory), reconcile units and dollars, and review unusual losses with your accountant before year end.

Resources