Glad to have you here in the Community, anna112. I understand the importance of having accurate data for your reports. In QuickBooks Online (QBO), COGS is realized upon invoice payment when using the cash basis, eliminating the need for an inventory asset. Also, there's no inventory asset on a cash basis since it'll be automatically recognized as expenses upon product purchase. With Accrual, COGS is realized regardless of invoice status, and the inventory asset account decreases accordingly. Additionally, the difference between cash and accrual reports lies in how transactions are recorded and reflected in financial reports. Cash basis reports reflect transactions based on when money is received or paid out. Here is the list of transactions to show in the cash basis report: Income is recorded upon receipt of payment.Record expenses when payment is made.Transactions involving cash payments or receipts. Accrual basis reports reflect transactions when earned or incurred, irrespective of cash timing. Here's the list of transactions shown in accrual basis reports: Income is recorded when it is earned, regardless of when payment is received.Record expenses when they are incurred, regardless of when payment is made.Transactions that are recognized before any cash exchange occurs, such as accounts receivable or accounts payable. If your data still appears incorrect, I suggest contacting our Customer Support Team for additional assistance in identifying and resolving the issue. Furthermore, you can run reports to give you a snapshot of your business. Then, personalize them to focus on the details that matter most to you. I'm always here if you need more help getting the balanced data your business needs. It's always a pleasure to help.

Question

Is anyone having issues with accurate inventory valuation reporting using the cash balance sheet? Is there a work around? Data is pulling correct on the accrual Bal sheet

Forum|Forum|2 years ago
March 21, 2024
3 replies
19 views

No text available

QuickBooks Online

M

Maybelle_S

QuickBooks Team

Glad to have you here in the Community, anna112.

I understand the importance of having accurate data for your reports.

In QuickBooks Online (QBO), COGS is realized upon invoice payment when using the cash basis, eliminating the need for an inventory asset. Also, there's no inventory asset on a cash basis since it'll be automatically recognized as expenses upon product purchase. With Accrual, COGS is realized regardless of invoice status, and the inventory asset account decreases accordingly.

Additionally, the difference between cash and accrual reports lies in how transactions are recorded and reflected in financial reports. Cash basis reports reflect transactions based on when money is received or paid out. Here is the list of transactions to show in the cash basis report:

Income is recorded upon receipt of payment.
Record expenses when payment is made.
Transactions involving cash payments or receipts.

Accrual basis reports reflect transactions when earned or incurred, irrespective of cash timing. Here's the list of transactions shown in accrual basis reports:

Income is recorded when it is earned, regardless of when payment is received.
Record expenses when they are incurred, regardless of when payment is made.
Transactions that are recognized before any cash exchange occurs, such as accounts receivable or accounts payable.

If your data still appears incorrect, I suggest contacting our Customer Support Team for additional assistance in identifying and resolving the issue.

Furthermore, you can run reports to give you a snapshot of your business. Then, personalize them to focus on the details that matter most to you.

I'm always here if you need more help getting the balanced data your business needs. It's always a pleasure to help.

A

anna112Author

I've checked all of your recommendations along with an online Quickbooks agent twice, they could not figure it out, and it's not working. As mentioned the accrual balance sheet inventory balances are correct and reflect all transactions. The cash balance sheet only reflects the opening inventory balance and doesn't list all of the transactions. It's believed to be a coding issue of some sort. Quickbooks notified me that it has been an issue for other clients as well and they were working on it, but that was a month ago....

I

Irene R

QuickBooks Team

Hi there, Anna112.

I appreciate you returning to the thread and giving us more information regarding the steps taken to solve the issue with the accurate inventory report of the cash balance sheet using your QuickBooks Online (QBO).

As you've mentioned above, you've had a conversation with two of our QuickBooks agents twice, and they've provided details regarding the matter. Furthermore, I recommend contacting our live support team again, they will provide you with updates and an adequate resolution to this matter.

To reach our support team, you can follow the steps below:

Log in to your QuickBooks Online company.
Click Help (?).
To get started, select one of the tabs:

Assistant: Get quick, personalized answers by selecting a suggestion or typing a question. Talk to a human for further help.
Search: Search the QuickBooks Online knowledge base directly, or select Contact Us and choose a way to connect with us:

Start a chat with a support expert.
Get a callback from the next available expert.

In addition, find out more about the frequent errors in the QBO account inventory by clicking on this article: Common QuickBooks inventory accounting mistakes.

Don't hesitate to ask if you have further regarding the inventory report in QBO. Leave a comment below, and I'll answer them in no time.

Rainflurry

Level 11

@anna112

Just to confirm, cash basis accounting does not have inventory, so the only accurate inventory valuation on cash basis should be QB showing $0 in inventory. Only accrual basis accounting has inventory.

The issue is that QB can only accurately switch between cash and accrual (as it relates to inventory) if all inventory entries are item-based. This is the same as QB Desktop. Any entries to inventory such as a journal entry or an entry on a bill, expense, etc. posted directly to your Inventory Asset account will bypass QBs ability to remove the inventory on cash basis reports. If you have a beginning balance entry, QB must have created an entry that bypasses the item/product. Are you able to locate the beginning balance entry that QB created? If so, can you run a Transaction Journal report on it? I'm curious to see what entry QB created and whether there's a workaround for it.

V

vishvajeet-smboo

Thank you for taking the time to discuss the intricacies of inventory calculation between accrual and cash basis methods. However, I am concerned about the discrepancy observed: while the cash basis method considers bill payments and updates inventory positively, the same trend is not reflected for invoices. Consequently, the inventory keeps increasing under the cash basis method.

I would greatly appreciate your insights on this matter when you have a moment.

Thank you again for your assistance.

Rainflurry

Level 11

@vishvajeet-smboo

"while the cash basis method considers bill payments and updates inventory positively, the same trend is not reflected for invoices. Consequently, the inventory keeps increasing under the cash basis method."

If your inventory is increasing on cash basis, then you must not be using items on your bills or your inventory asset account is being increased some other way that bypasses inventory items (expense/check entry, journal entry, etc. that posts directly to your inventory asset account). QBO disregards items on cash basis reports.

J

john675645

Yes, inventory valuation can appear inaccurate on a cash basis balance sheet because cash accounting doesn’t track inventory until it’s paid for. A workaround is to use an accrual-based balance sheet for inventory reporting, as it reflects actual quantities and costs.
At Ledger Labs, we guide businesses on using accrual reporting for accurate inventory valuation while understanding cash-based financials for day-to-day cash flow management.

Sign up

Login with SSO

Let's get you signed in

Login with SSO