Showing results for 
Search instead for 
Did you mean: 
Frequent Explorer *

QuickBooks Advanced Reporting (QBAR)

Is there anyone out there that has produced a report depicting direct labor, fringe benefits and general overhead for a state required report?  If so can you give me instructions on how you built it?? If possible is there anyone who has built any custom reports?  I find that tool impossible and the instructions very complicated.    


Re: QuickBooks Advanced Reporting (QBAR)

Hi there, @Caroleann.


Let me help route you to the right support that can assist in building custom reports.


Our QBAR specialists can help you further in creating custom reports since they are more familiar in these areas. If you are interested in finding someone to assist can help you locate a QBAR specialist.  Fees may apply.  


You can also try searching Youtube for Qlik View to provide you with many tips and tricks in creating custom reports. We also have training modules where we walk you through building reports from scratch.  The Resources tab contains the Advanced User Resource Guide (pdf) along with the data dictionary you can use to select the dimensions you want to have on your report. 


If you need more information about QBAR you can refer to this helpful article: QuickBooks Advanced Reporting (QBAR) FAQ's.


This should get you on the right track. Please let me know if you have other questions about Advanced Reporting. I'm here to help however I can.

Frequent Explorer *

Re: QuickBooks Advanced Reporting (QBAR)

I tried on of your QB specialists and he charges a whopping $160.00 per hour.  I was told the advanced reporting tool would allow me to create reports not in the database but that is a lie since even the specialists could only construct part of the report and the rest had to be put in excel outside of QB.  It was a lot easier for me to just construct the report in Excel and use totals from reports to fill in the amounts.  manual but done.  

QuickBooks Team

Re: QuickBooks Advanced Reporting (QBAR)

Hi @Caroleann,


Please know that we didn't intend to make you feel that way. While you're unable to create your report with QuickBooks Advanced Reporting (QBAR), what I can do is submit your feedback to our product developers.


This way, they'll be able to know of your sentiments and the importance of QBAR in creating a report that suits to your needs.


Please don't hesitate to tag me in your comment below. I'll be always around ready to help.

Frequent Explorer *

Re: QuickBooks Advanced Reporting (QBAR)

Thank you for responding to my frustration.  The report I was trying to create is one of four that is required by contractors working for the State of California and I feel should be in your database.  I wasted a week going from one place to another trying to get answers and wish the different departments would have just said they did not have that report and it can't be constructed.  It's always easier to be upfront and as you say, try to correct.

I don't mind doing the excel outside of QB but as you are aware, transcribing figures into a report leaves open the possibility of errors.  I love how reports just load right up when using a standard report in QB.  


Re: QuickBooks Advanced Reporting (QBAR)

I appreciate you sharing your thoughts in the Community, @Caroleann. I understand your frustration about this report not being available since this is something you need for your business.


Letting us know what works best for you will show our developers what they need to consider in future product updates.


That said, I'm here to help pass this along in my end.


Should you have other questions about advanced reporting, please don't hesitate to reach out again. I'm here to help.