Properly Adjusting QuickBooks Online Inventory
Learn how to properly adjust your inventory for failed returns or lost inventory in QuickBooks Online using the correct documents.
Tracking your inventory with the proper documents can give you more detail about your business. By using the right documents, your reporting will be more correct and you can make more informed decisions.
Failing to accurately track your documents can lead to issues with order fulfillment and unhappy customers, amongst other issues.
This article will go over ways sellers can properly adjust inventory using QuickBooks Online documents for $0. Some cases include damaged returns, lost inventory, or other shrinkage.
We won’t cover sales and refunds since those are straightforward.
Documents that affect inventory
Depending on how you manage your inventory in QuickBooks Online, there are going to be multiple ways you can handle your inventory adjustments.
How you manage adjustments will depend on what has happened.
Handling a return of a damaged product is going to be different from handling damaged inventory that your supplier refunded.
We’ll go through some different options, and you can decide what works best for your business. These options aren’t necessarily limited to the situations described.
Inventory quantity adjustment
You can create an inventory quantity adjustment document found under the Plus icon > Other.
Using inventory adjustments is a quick way to record changes in inventory.
When you create an inventory quantity adjustment document, QuickBooks Online will automatically post the loss (or gain) to a “Cost of Goods Sold – Inventory Shrinkage” account.
Make sure you enter a reason for the adjustment in the Memo field so that you can always refer back to it later.
Since QuickBooks Online uses FIFO accounting, the COGS is based on the date of the transaction and the last bill entered.
This will affect your profit and loss reports accordingly.
See below for a product report showing the inventory quantity adjustment and the changes to the accounts:
Creating a sales receipt for $0
When you create a refund in QuickBooks Online, inventory will increase by the quantity on the refund document.
Some sellers will just throw out or destroy damaged returns. Or they issue a free replacement to the customer.
One option to handle customer-related issues to reduce inventory is to create a sales receipt for $0. This will adjust the COGS and Inventory Asset accounts.
When you look at your balance sheet or run a profit and loss report, your accounts will be correct.
Here’s an example of a report on the product with a $0 sales receipt and the affected accounts.
Using credit memos for $0
Whereas the sales receipt will reduce the inventory accounts, a credit memo will increase your inventory quantity and accounts. Like sales receipts, credit memos are related to customer issues.
Amazon sellers are more likely to use this because of the delay between a refund and a return. For instance, if you sell through FBA, then it can sometimes take more than 60 days for a return to get back to you.
That’s because customers have 30 days to request a refund, another 30 days to return it, and then there’s the delay for removal orders. This process may take even longer during the holidays because of extended returns.
Meanwhile, you may have created an invoice for the sale, a refund, and a sales receipt for the loss of the item. On day 70, when you receive the item to inspect, it may still be sellable.
If that’s the case, you can use a credit memo for $0 to offset the sales receipt for $0 that you created previously to write off the item.
Credit memos will use the COGS from the last bill that you entered unless you enter a value.
Below, you can see the exact transaction described above. Note that since the item is sellable (returned in new condition), all the affected accounts are back to their original values.
Use vendor credits for $0 to remove inventory
As the name suggests, these documents are related to vendor issues.
Vendor credits will remove inventory. There are several reasons why you’d use this, but common reasons include lost, damaged, or defective inventory.
Vendor credits will also affect your inventory asset and cost of goods sold accounts. This is likely more common if you sell through Amazon FBA. If Amazon loses inventory, then you can account for it with a $0 vendor credit.
Vendor credits will use the values calculated from your last bill or expense.
If you were credited or refunded, you’ll have to deal with that transaction as well.
The behavior similar to a sales receipt for $0, except it’s through the vendor instead of the customer.
Use vendor expenses for $0 to increase inventory
When you create a vendor expense document, it will increase inventory. Item expenses are treated like bills and checks, so they’ll affect your inventory accounts in the same way.
You may sometimes receive extra inventory. You can account for the extras using $0 vendor expenses. Because the amount is $0, the Inventory Asset and COGS accounts won’t be affected, and a sale of the item will record properly. Essentially, you’ve received free items.
Since QuickBooks Online uses FIFO, that $0 vendor expense will be used for future COGS calculations unless you enter more recent bills or expenses.
You’ll want to be careful about this or you may end up with inflated numbers when you run profit and loss reports.
Here’s an example of a Vendor Expense for $0 and subsequent transactions with no other future bills or expenses. Note the inventory accounts for future transactions also show $0 since no other bills were entered after the $0 expense.
Adjusting starting inventory
Generally, you’ll want to avoid manually adjusting inventory start quantities.
Instead, use Purchase Orders and bills or expenses to receive inventory into QuickBooks Online. And use the proper documents for inventory (like invoices and refunds).
Starting inventory may be used if you’re starting a new company or book. Be sure to enter the starting value if you do this or your inventory asset and COGS accounts will show $0.
Without the proper documents or reasoning, making numerous adjustments to the inventory start quantity can be very confusing to other people unless they know to go through Advanced Search or Audit Log to track down each adjustment.
Even then, if there are no reasons written in the Memo field, reconciling inventory and accounts can be frustrating and problematic if you constantly change the starting quantity.
No matter how you handle adjustments to inventory, you’ll want to be as precise and consistent as possible. Whatever rationale you use for the documents, you should keep to it.
By recording the right transactions to adjust your inventory, you’ll have a better understanding of how and why your inventory is moving.
Like this article want to learn more about other QuickBooks Online topics?