QuickBooks Online Custom Reporting with Locations, Classes, and Tags

[@HectorGarciaCPA]

If you want to learn more about QBO Reports, take my "Masterclass" on reports on 11/11/2021 for $150: learn.royalwise.com/visitor_catalog_class/show/678805/Mastering-Custom-and-Advanced-Reports-in-QuickBooks-Online

[@cynthiahartley7277]

Hi Hector, You have the BEST QBO videos ever. You give so much detail and while some of it could be minor, as they say, "The devil is in the details." I have been trying for hours, so many that I could probably count the hours in days, trying to get my balance sheet to balance by Class. Yours is the ONLY video to say that this is incredibly difficult to do, and one should only do it by Business. I was wracking my brain until I found your video. Thank you for all of your GREAT content.

[@HectorGarciaCPA]

Balance Sheet by Location is better

[@valerieherman]

Hector, this is brilliant. I've been wishing for this exact Custom Summary report forever. AND I figured out how why it doesn't show up in all accounts. You have to sign in as an accountant. It's only available when you see "Accountant Tools" at the top. So I invited myself to be my own official "accountant" and now I can see it (as long as I'm signed in as the accountant, not the regular user). Thanks so much!

[@HectorGarciaCPA]

Nice find

[@mikecabonse5995]

Thank you Hector. You are an excellent QB teacher!

[@HectorGarciaCPA]

Thanks, glad you enjoyed it

[@LizHawkins91]

This is sooooooooooo helpful. Thank you!!!!!

[@HectorGarciaCPA]

Great. thanks!

[@SteveChase1]

Thank you for showing us the "Custom Summary" report. I love you can use display rows and columns for locations which is a great way for me to Show my locations in the columns while keeping the services in the rows = Income Statement.

[@HectorGarciaCPA]

Yeap!!

[@BenjaminManning-x9e]

Tags may be less rigorous than say, location tracking,. because it does not have a "Not Assigned" catch-basin to add rigor to the tagging process; its more "directional" like for a Marketing Promotions, allowing tags attached to invoices for example

[@HectorGarciaCPA]

Tags are more flexible, but no balance sheet by tag

[@chucktrotter9699]

11.14.20 Nice video. Thanks for taking the time. Now I will have to experiment with this Custom Summary report. Thanks again.

[@terrikrause4772]

Really appreciated this video, and your way of presenting. Thank you so much!

[@HectorGarciaCPA]

Glad you liked it

[@teramaughan2099]

Thank you for explaining so well. This was very helpful!

[@HectorGarciaCPA]

Awesome

[@magdakoz3336]

Hi Hector! Thank you for your great work👏🏼! I watch your videos and use tips a lot ☺️ I have a quick question: is it possible to import data from excel into qbo categorized into classes, tags and localizations?

[@CraftedSounds]

you da man. this is just what i needed.

[@shameerav2075]

Hi ... very useful information ... one quick questian ... i can't find the 'tag" in online plus ?, did quick book removed it ?

[@HectorGarciaCPA]

If you are in the US; you are supposed to have that feature. Outside US i don’t think

[@dv.morris]

Thanks for the AWESOME content! Question - a twist on the example you gave at approximately 32:50 in the video. What if there is one owner with 2 LLCs and he wants to track the P&L for each company but the finances (bank accounts, etc) ARE separate. Will this mess up the year end data when it's time to do taxes?

[@SanchosBro]

Super helpful! Thank you!

[@deannegosse1053]

Can you have multiple classes on each item on an invoice? For example Department, attorney and office?

[@HectorGarciaCPA]

One per line item

[@robmayerMBA]

Thank you for your great work

[@HectorGarciaCPA]

You are welcome

[@BenjaminManning-x9e]

When is Intuit going to add a label for "Fund" in QBO Location tracking?

[@HectorGarciaCPA]

No idea if thats even in the plans

[@remcat3572]

What slides are you referring to for getting the Custom Summary Report? Thanks

[@HectorGarciaCPA]

Link on Description

[@jackierockwell365]

It looks like locations are now able to be used on line item entry. Did this feature get added after this video was recorded?

[@calicowest]

Reclassify balance sheet location

[@HectorGarciaCPA]

You need to change all the transactions’ locations for that

[@BLMJ7777]

This is great, thank you! Is there a way to run reports by Zip Code? Thank you again!

[@HectorGarciaCPA]

Not currently with PLUS, maybe in QBO advanced

[@atif7358]

That is a very helpful video. I am still trying figure out if Classes wise Trial Balance Report can be developed as custom report?

[@HectorGarciaCPA]

No Trial Balance by class

[@atif7358]

@@HectorGarciaCPA Thanks for clarifying

[@hollybrunner7595]

Hi Hector - love your videos! I'm having an issue with inventory with respect to classes. Client has one common inventory. THey track sales by register and have created two classes for that. However, on the P&L, it does not show the sold inventory by any class (other than the class initially assigned to that inventory item). What is the best way to get a P&L by class (or location) if using a common inventory?

[@HectorGarciaCPA]

The classes need to be in the invoices where the inventory items where sold. If you dont use inventory items, it wont work.

[@hollybrunner7595]

@@HectorGarciaCPA Thanks so much Hector.

[@arleenvalente7402]

Hi Hector! Thank you so much for your helpful videos. I am in the process of figuring out if moving to the online version is the way to go for our firm (after being on desktop for 15 years. We have 100's of reports built and I'm wondering if the reporting feature is as robust in QBOAdvanced. Can you import these reports or do I have to start from scratch to build new reports?

[@HectorGarciaCPA]

No.. custom reports do not transfer over. There is a reporting tool that is pretty powerful, its similar (and in some slim cases better than Desktop) but not as “robust” as Desktop

[@ccafKhmer]

Great!

[@HectorGarciaCPA]

:)

[@user-jv2bw9tc2l]

Can you use tags, classes and locations in the budget?

[@HectorGarciaCPA]

Budgets by class yes. Not by tag

[@messybunbookkeeper6210]

Great video. Thank you! Would I be able to get QBO Plus, but then if it turns out I need more than the 40 combined classes/locations, I can upgrade to QBO Advanced without losing any data? That is, will everything transfer over properly? Thank you.

[@HectorGarciaCPA]

Yes, seamlessly

[@CamBeckConsultingGroup]

Excellent video! Can you run a balance sheet by class...or only by location?

[@kyleomac8551]

as it's said in the video, yes you can, but it's not recommendable due to unbalance report

[@orangzebkhan7153]

I don’t have tags in qbo plus version! Where can look for it?

[@HectorGarciaCPA]

Are you in USA?

[@funcity3998]

@@HectorGarciaCPA UAE

[@HectorGarciaCPA]

@@funcity3998 I think this is a US only feature

[@mattgraves1765]

Hey Hector - the custom summary link for non-accountants to use no longer works (it just continously shows a QB loading screen). Are you aware if there is a new link that works?

[@HectorGarciaCPA]

Is the same link.. they just removed access in some accounts :(

[@HectorGarciaCPA]

Links not working with some files still!

[@Andrew-yw1zy]

I am having issues keeping my inventory accurate because we get large orders from our factory, and those orders will have stock, as well as items for multiple customers, some of which are invoiced before we actually get them because they are going through a finance company. I ask here because I thought adding locations to the purchase orders might help keep things separate in our system?

[@HectorGarciaCPA]

I am not sure how to answer this…

[@HectorGarciaCPA]

Locations is not for separating inventory

[@KeterBcMay-iv4ku]

I can filter by class. can i then print out all attachments uploaded to QBO associated with the class? ( I can individually go in and do this, but would like to do it quicker)

[@HectorGarciaCPA]

I don’t think that’s possible

[@nickstraccini9139]

Do you have a link for Canadians? looks like this is for American (US)

[@HectorGarciaCPA]

Sorry.. only US :(

[@HaroldBuco]

Hi @Hector. May I know how I can generate Sales by States?

[@HectorGarciaCPA]

That report doesn’t exisit

[@haru_1997]

@@HectorGarciaCPA Thank you Hector. My client is asking for it and I've been searching on how to do it but can't find one. Do you think using the Location feature can help?

[@gopaldangar1050]

@@haru_1997 location feature can help but you need to set it up and reclassify all the historical transactions to get the report you want.

[@carolecantrell5486]

How can I tell how many sales I made in Florida this year

[@HectorGarciaCPA]

If Florida is a Location, Class, or Tag… then you use the instructions in this video. If its just the state in the address, there is no good report for that now

[@noahbronner7951]

Hi! Does QBO still support divisions?

[@HectorGarciaCPA]

“locations” is the feature for Divisions

[@noahbronner7951]

Outstanding. Even the QBO customer service line couldn’t tell me that.