How to Write Down Inventory in QuickBooks Online and Xero (and What FIFO Does to It)
An apparel owner who keeps her own books told me how her year end works in QuickBooks: “on QuickBooks I would just do like obsolete costs, lower my inventory in QuickBooks.” A journal, in other words. It’s what most small sellers do, and in QuickBooks Online it’s often the only option. Whether it’s the right one depends on a setting most people chose without knowing it: how your file costs inventory.
First, check how your QuickBooks file costs inventory
QuickBooks Online tracks inventory on the Plus and Advanced plans. Advanced lets you pick FIFO or moving average cost. If you created an inventory item before picking, Intuit’s help article says the file defaulted to FIFO, and the method can’t be changed afterwards. So a lot of files are FIFO because nobody ever chose.
Which one you’re on decides what a write-down can do.
On moving average cost: adjust the value
QuickBooks Online now lets a company on moving average cost adjust an item’s inventory value on its own, without changing the quantity and without a journal entry. Under moving average there are no layers. The item has one cost, and lowering it lowers every unit on hand. Units already sold were costed at the average when they sold, so their cost of goods sold doesn’t move.
Two things to settle before you do it. Which account takes the other side: a write-down belongs in its own expense account, not in the shrinkage account a quantity adjustment uses by default, or your losses and your write-downs end up in one number. And the date, which should be the last day of the year you’re closing.
On FIFO: there’s no value-only adjustment
A FIFO file can’t change an item’s value without changing its quantity. People get around it three ways.
Edit the original purchase bill. This is the answer QuickBooks Online’s support team gave a user in 2021. It changes the cost of every unit on that bill, including the ones you sold months ago. Their cost of goods sold drops, margins in closed months go up, and the bill no longer matches what the supplier charged you.
Post a journal. Debit a write-down expense, credit Inventory Asset. The balance sheet now shows the lower value, but the items still carry their old cost. When those units sell, QuickBooks posts their cost of goods sold at the old cost, so the loss gets counted twice unless someone reverses the journal as the stock goes. Until then, the Inventory Valuation report and the Inventory Asset balance disagree by the amount of the write-down. Plenty of accountants run it that way, with a schedule they reverse as the stock sells.
Adjust the quantity out and back in. A quantity adjustment posts to an inventory adjustment account, which Intuit’s own example calls Inventory Shrinkage. Taking the units out that way and buying them back in on a new purchase at the lower cost turns a write-down into a loss followed by a receipt, and if you age your stock anywhere by the date it came in, it now looks new. The two-year-old jackets show up as received on December 31.
The version of this I’ve heard from more than one seller goes one step further: a made-up sales order to clear the stock out of the FIFO queue, then a receipt at the new cost. Now there’s revenue and a customer that don’t exist, too.
Xero: average cost, so the sold units are safe
Xero’s tracked inventory uses average cost. Its own API describes an item’s value on hand as “calculated using average cost accounting,” and Xero users have been asking it for a FIFO option. So the FIFO problem above doesn’t happen in Xero: there are no layers, and lowering an item’s value can’t reach back into units already sold.
What Xero doesn’t give you is a write-down document: a preview of what it will post, or a second person’s approval before it does. Whoever lowers the value, and however your accountant prefers to post it, keep a note of which items, what price you used, and why.
When your accounting software isn’t enough
If you sell a few hundred SKUs on one channel and write down once a year, a journal your accountant schedules is fine, and Zoho Inventory or inFlow will hold the stock. The pain starts with FIFO, several channels, and a year end with dozens of products to write down. That’s the point where the write-down belongs in the inventory system, on the layers, with the journal following it into the ledger.
That’s how SKU.io does it. A write-down lowers only the units on hand at the date, keeps each layer’s date, and syncs its own journal to Xero or QuickBooks Online, so the stock value and the inventory account still agree afterwards. The steps are in write down inventory at year end. If your year end involves a spreadsheet and a plug, book a demo and bring it.
The rest of the year-end picture, from pricing the stock to what to disclose, is in inventory write-downs at year end.