cancel
Showing results for 
Search instead for 
Did you mean: 
lea019
Level 1

incorrect cash results for zero bill/expense (used to allocate internal expenses across classes) qb desktop 2020

 

Issue     expense bill with net zero, shows paid, use to allocate expenses across classes. I have been using the zero bill to allocate for more than a decade without issue.

 

Accrual results are correct. But on the cash results, appears an allocation is applied that makes no sense as the expense is paid with transaction date and pay date the same.  For this type of use and zero bill the cash results and the accrual results should always be equal. UI on the individual expense bill she paid with total zero.

 

I use the quickbooks accountant desktop 2020.

 

I think this behavior was introduced as part of an update / code release pushed out by QB (seems like a bug to me) in March or April of 2021. I was able to back into this date retroactively by looking at all of these type of transactions across time. For those created prior to this date and not touched since then as those transactions individually have same results for both accrual and cash.  But if you change the amount on such bill say to update the allocated amount, then the cash results no longer equal the accrual results. For all new bills created after this date the cash results do not equal the accrual results. 

 

I showed this to my quickbooks pro advisor and they reproduced on their systems in several different versions of QB.  They concluded this is a bug but do not know a work around

 

This behavior presents in all my different company files in the same way.

 

I also created a new test company and reproduced the problem. This only takes a 5 minutes to setup and input a simple zero bill example and to show in sample report. On tip put a unique number in the num field on the expense then run a profile loss report with this num in the filter and then toggle between cash and accrual.

 

I did attempt to reach out to QB support on multiple occasions with each attempt ending with the agent saying they will escalate and then the next call completely started over and issue a new support case #. I did save all this case number detritus but now shifting to forum in the hope there is a fix in the expert community.

 

 

This problem is now front and center with Tax filings. Turbotax for business pulls cash results per the quickbooks reports which are incorrect.  I need to get the underlying expense transactions to regenerate the case results correctly without this allocation. 

8 Comments 8
GlinetteC
Moderator

incorrect cash results for zero bill/expense (used to allocate internal expenses across classes) qb desktop 2020

Hi there, lea019.

 

The Accrual and Cash accounting method doesn't always give the same result. Their difference lies in the timing of when income and expenses are recognized. You can learn more about this by checking out our cash vs. accrual accounting: What’s best for your business?

 

I understand that you've called us about this already. But I'd like to ensure that your case# gets reviewed, so I suggest you call in again. One of our phone representatives can do this for us.

 

Here's how:

 

  1. Go to Help, then select QuickBooks Desktop Help.
  2. Select Contact Us.
  3. Enter a short description of your issue, select Let's talk and then choose a way to connect.

 

Also, you can check our support hours to reach them during your convenient time: Contact QuickBooks products and services Support.

 

Don't hesitate to drop a comment below if you have other questions about the accounting method. I'm happy to support you. Take care.

lea019
Level 1

incorrect cash results for zero bill/expense (used to allocate internal expenses across classes) qb desktop 2020

“doesn't always give the same result. Their difference lies in the timing of when income and expenses are recognized.”

 

My comment applies to only the zero bill situation. And for this yes there is NO timing difference as the payment date is equal to the date on the expense bill. Accrual and Cash will always be exactly the same

lea019
Level 1

incorrect cash results for zero bill/expense (used to allocate internal expenses across classes) qb desktop 2020

On calling support, i poured more than 10 hours (lots of hold time), more than 5 separate calls and i have all the case numbers documenting these calls recorded in my notes.

 

I have a quickbook pro advisor, that i have been working with for the past 15 years (well known within the quickbooks side), that assisted me with this problem and engaging qb support. But at the end of the day I had to stay infront of the qb phone support and it turned into an abusive waste of time. That is why i am posting in the community forum.

 

If you want to PM me i will give you case numbers and you can track it down. The story from my side has been consistent from the first call. 

 

This problem is very easy to reproduce and basically will affect any user

 

 

 

RenjolynC
QuickBooks Team

incorrect cash results for zero bill/expense (used to allocate internal expenses across classes) qb desktop 2020

I appreciate your time in getting back here, lea019.

 

It's important we're able to resolve this issue as soon as possible. You mentioned that you've already called and I know it's not something you're looking to do again. However, we don't have the necessary tools to review your account and investigate the issue further in the Community.

 

You can try the troubleshooting steps shared in this article: Fix data damage on your QuickBooks Desktop company file. Otherwise, follow these steps to contact Customer Care Team. Please take note that our support hours for QuickBooks Desktop Pro, Premier, and Plus is available from M-F 6 AM to 6 PM PT. For the Enterprise version, we're available any time, any day.

 

Here are the steps:

 

  1. In your QuickBooks Desktop program, go to Help QuickBooks Desktop Help.
  2. In the Have a Question window, click the Contact Us link at the bottom.
  3. From the Contact Us page, select any topics.
  4. Under Here's how to connect with a QuickBooks expert section, click the Start a Message or Get Phone Number button.

You can also get our direct phone number in this article: Contact QuickBooks Desktop support.

 

You're always welcome to reply on this thread if you have more questions or other concerns. We're available to help. Take care and stay safe.

lea019
Level 1

incorrect cash results for zero bill/expense (used to allocate internal expenses across classes) qb desktop 2020

On each of the 5+ phone support encounters (each time QB generates new case# despite my request that for continuity to use the original case#) , they had me do the same verify/rebuild steps. So this has been repeated on each of these calls. Repeating these same steps over an over does not make any sense to me. Further as I demonstrated to the QB support agent the issue can be easily replicated with simple example.  Using the same version fully updated, desktop 2020 just input a zero bill

Date can be today or any day you choose with the transaction date and the due date equal.

 

2+ rows each with same account, different class, and amounts that sum to zero.

Eg for a 3 class allocation date = today

-200  class1

+100 class2

+100 class3

Sum to zero. The UI on the bill will show “Paid”.

 

Run report isolate to ONLY this transaction. Toggle between cash and accrual. The results should be equal but they are not.

 

Prior to the introduction of this bug per my prior summary, this was always the case.  If you look at a transaction captured prior to the bug and has NOT been resaved then this is still the case. Obviousl,y any new transactions will present with the incorrect information. If you alter / resave a transaction last saved PRIOR to the bug and before saved the cash and accrual were equal after the save the results will no longer be equal.

 

Again easy to replicate even if you create a new company file using an existing QB provided same company. Take only a couple minutes. I explained this to each QB support agent. I even prepared an example using this approach and forwarded to QB via my QB pro advisor. Seemed to be pushing on the common sense string.  Why this seems important is it eliminate any damage as the root cause. Separately the QB pro advisor replicated on their own installs (completely separate environment). An on the very first QB support (yes I have the case #) they also indicated on the case they were able to replicate on the QB systems.

So all things considered, I think this should be sufficient for QB/Intuit to take the ball from here. If QB came back and 1) acknowledge the bug and gave a timeline for a fix to be rolled out I would have a favorable view of that outcome. 

lea019
Level 1

incorrect cash results for zero bill/expense (used to allocate internal expenses across classes) qb desktop 2020

 
lea019
Level 1

incorrect cash results for zero bill/expense (used to allocate internal expenses across classes) qb desktop 2020

 
lea019
Level 1

incorrect cash results for zero bill/expense (used to allocate internal expenses across classes) qb desktop 2020

Did you try to reproduce the issue on your system using the simple example i provided?

Need to get in touch?

Contact us