What is the Deferred Inventory Report?
The Deferred Inventory Report tracks inventory that has shipped but isn't recorded in QuickBooks yet, because of Amazon's new deferred order system. This report helps you match your inventory records to your accounting.
How to run it
Go to Reports, click Inventory, then click Deferred Inventory Report.
Pick a date in Select Date.
Click Run Report.
What data does the report show?
The report has 3 key columns:
On Hand: The total value of inventory after all orders have left the warehouses.
Deferred: The value of shipped orders not yet recorded in QuickBooks.
On Hand + Deferred: The value of on hand stock plus deferred inventory. This is the amount that should be in QuickBooks.
Why is this report needed?
ConnectBooks lowers inventory when an item ships, but Amazon records the sale only when the payment is posted, usually a few days later (deferred orders). This date difference can cause differences between our inventory and QuickBooks.
How does it help?
ConnectBooks has on hand asset value based on shipped orders, and QuickBooks has asset value based on posted sales, so the 2 don't match. You can see the asset value you should have in QuickBooks in the On Hand + Deferred column.
Frequently asked questions
Why doesn't my inventory value in QuickBooks match ConnectBooks?
ConnectBooks lowers inventory when an item ships. Amazon records the sale when the payment is posted, usually a few days later. Compare QuickBooks to the On Hand + Deferred column instead.
What does the Deferred column show?
The value of orders that have shipped but aren't recorded in QuickBooks yet.