Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.

Reply to message

View discussion in a popup

Replying to:
s1b
Level 3

The problem is when I run a Balance Sheet Cash Basis All Dates report the INVENTORY ASSET value is not changing at all?

I am:
- Using QuickBooks Online
- Tracking Inventory quantities and values.
- Accounting method is set to Cash Basis
- Using Sales Receipts only


I started inventory on 12/01/23.  I entered each with a starting value and quantity. 

When I ran a CASH Balance Sheet dated for 12/1 it appears as:
ASSETS > CURRENT ASSETS > OTHER ASSETS > INVENTORY ASSET = $253,247.64

And it also appears on the Balance Sheet as:
EQUITY > OPENING BALANCE EQUITY INVENTORY TRANSFERRED = $253,247.64

My starting inventory value is correct.  I have been selling that inventory using Sales Receipts. And bringing inventory in using Purchase Orders and Bills. The Inventory Quantities are changing as they should.  When I view the Chart of Accounts list, the INVENTORY ASSET register is showing decreases and increases, the value is changing.    

The problem is when I run a Balance Sheet Cash Basis All Dates report the INVENTORY ASSET value is not changing at all.  It is still the original value from 12/1 of 253,247.64.  

Shouldn’t the Chart of Accounts > INVENTORY ASSET register value be = to the Balance Sheet Cash Basis All Dates for INVENTORY ASSET? 

Out of curiosity, I changed the Balance Sheet to Accrual, then the INVENTORY ASSET changes value and is correct.  The Accrual report value matches the Chart of Accounts list for INVENTORY ASSET.

Why is the Balance Sheet Cash Basis All Dates report not showing the value changes to INVENTORY ASSET?  It has not changed at all from the start.

Thank you!
Corina

Need to get in touch?

Contact us