BLACK FRIDAY SALE 70% OFF QuickBooks for 3 months*   Ends 11/30

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:
KatnissBookkeeper
Level 4

Sales Tax Liability Report has a bug

Spent approx 5 hours on the phone today with 3 QB experts.  The first two I got cut off before getting a resolution.  The last one I was able to convince there's a bug in the report.  She told me she was going to email me a case number so I could track the problem investigation and resolution but that was approx an hour ago and I have had no such email.

 

So... in approximate terms my client's Q1 actual sales total gross was $67k but the STLR reported $50k as the gross sales.   There's a similar discrepancy between the actual "non-taxable" sales and the STLR reported non-taxable sales.   Can someone please get this bug fixed?

 

What I have come to understand is the Sales Tax Liability Report (STLR) only includes in "gross sales" sales receipts that included a taxable item and the "non-taxable" amount on the report is only the non-taxable components on the sales receipts that also contained a taxable amount.   Are you with me? or does this just sound like and Irish riddle? (it does to me)

 

In the end I was able to prove out my theory by exporting all sales to excel, grouping them by sales receipt number and deleting all the receipts that had a taxable component and then sum what was left (all receipts that did not include a taxable line item).  Really - QB should have been doing that work, instead I spent about 5 hours repeatedly looking at the same collection of reports with 3 different people (and at times on hold while they talked with a tier one expert on their line) to not get any help.  I offered a theory as to what could explain the difference and was left to work through that myself.

 

Lastly - the STLR NEEDS to include sales to exempt customers so that clients can report total gross sales, non-taxable sales, taxable sales and sales to exempt customers correctly.

 

 

Need to get in touch?

Contact us