6 Steps to Building the Reports You Need in QuickBooks

If you are a seasoned QuickBooks® Desktop (Pro, Premier, Accountant or Enterprise) reports customizer, you know how great QuickBooks is actually for building custom reports regarding the fly. However, there are really important restrictions to learn about, including the things I think is most prevailing: QuickBooks can only build a written report using data from two types of tables. If You want to know about Reports In QuickBooks Desktop then Contact our Proadvisors.

The 2 tables include:

Transactions: These are the fields/data points that live inside each transaction, such as Invoices, Bills and Checks.

Names: These are the tables that store Customer, Vendor, Item and username and passwords.

So, the issue is that you cannot pull up a study, such as “Sales by Preferred Vendor,” using QuickBooks custom reporting functions. That’s because Preferred Vendor is a data field that lives within the Item List table and Sales will probably be an element of the Transactions Table (such as for instance invoices and sales receipts). Therefore, you would have to pull two different reports and then use some type of VLOOKUP formula to place it together … I know some of you Excel gurus have in all probability figured out how to try this. However, this is simply not a sustainable process given that it will probably require the usage of a consultant each and every time the report needs to be built.

Related Post: https://accountsbasics.sitey.me/blog/post/201364/reports-in-quickbooks 

If you have QuickBooks Enterprise 14 and above, along side a dynamic annual subscription, you should use the brand new Advanced Reporting add-on called QBAR (included with your subscription) to generate this report.

You can find a number of videos into the QuickBooks Enterprise Learning Center on QBAR. I interviewed Joseph Lasee, senior product manager for QBAR, asking him how to create a report such as this step by step, and also to shed some light into how this compared with QuickBooks’ standard reporting capabilities. Watch the video here, or click on the box below.

In conclusion, the ultimate way to build the report is to follow these six steps:

1. Go to your Reports menu and click on Advanced Reporting to run QBAR. You should be in multi-user mode and possess user permissions to perform QBAR if you are not the Admin.

2. Open a Starter Report, such as for instance Sales by Item Detail. It should appear to be this:

3. Right-click on the light gray bar along with the “chart” (in QBAR, any table with data, whether or not it’s graphical or not, is known as a Chart), and click on properties.

4. First, we are going to ADD the most well-liked vendor through the Item table by clicking on the Dimensions Tab. It should appear to be this:

Related Post: https://fixaccounting.my-free.website/blog/post/201365/reports-in-quickbooks 

The next phase let me reveal to take into consideration the Item table when you look at the drop-down, where it says Show Fields from Table. Then, when you look at the Available Fields/Groups above, look for Item.Preferred.Vendor.Full.Name and click on Add. After you notice it in the Used Dimensions box, click about it and promote all of it the best way to the most notable. This means that this will be the main row (or pivoting row) that may organize the information and knowledge – this is actually the “By Preferred Vendor” portion of the report that people are building. It must look like this now:

Optionally, you are able to click on Suppress When Value is Null if you do not would you like to see any numbers for things that do not have a preferred vendor.

5. Next, within the Expression tab, we are going to click for each expression and uncheck the Enable checkbox off to the right, except for Amount. We can not disable amount because we truly need a minumum of one expression of transaction data to exhibit from the report (needless to say, you are invited to keep QTY and SALES PRICE enabled, as they may be beneficial in this particular report.). Which should appear to be this:

6. And, the last setting is Presentation. We will tell QBAR that we don't want to see any detailed transaction information – just collapsed totals. To do that, we need to find the second dimension Item Type and uncheck Always Show Fully Expanded. It will seem like this:

As soon as we are done, we are able to click on Apply and OK, while the report will appear like this:

You may need to right click the title and then click on properties to change the title to the desired name, similar to this:

It is only one exemplory instance of the truly amazing potential that QBAR has for building those very specific reports your customers might need in order to make faster and better decisions. You can find currently a limited amount of learning resources on QBAR, but We have dedicated a page back at my site to aggregating most of the resources I know on Advanced Reporting for QuickBooks Enterprise.

I am going to also keep updating the page as more and more resources become available!

Now, although i will be writing this short article, i shall confess that I'm not a professional in this tool by any means. I experienced to spend a few hours to get familiar with it and my interview with Joseph was very useful. So, I managed to get my goal this season to become more and more confortable using this tool to make certain that I'm able to add a whole new dimension (no pun intended) of service to my current clients and potential new ones. The fact this isn't a straightforward tool to begin with with, and that there wasn’t a lot of consultants that have mastered this tool, presents a good opportunity for QuickBooks ProAdvisors!® Even though learning curve is long and there are numerous hours of trail-and-error experimentation until such time you build the coziness level to venture out and offer Advanced Reporting customization services, I guarantee the rewards will soon be worth every penny.