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

Quickbooks Online Report Of Sales By State By Vendor

I am trying to figure out how to run a report with total sales by vendor by state in Quickbooks online. It seems impossible. Has anyone run this report? Can you provide the setup you used?

5 Comments 5
MarsStephanieL
QuickBooks Team

Quickbooks Online Report Of Sales By State By Vendor

Hi there, @Aquaman1.

 

Currently, the report to filter it by state is unavailable. Although, the report by vendor in QuickBooks Online is available. I'd be glad to show you how to do that.

 

  1. Go to the Reports menu and enter "Transaction List by Vendor" in the text box.
  2. Select the date range of the transactions you want to show in the report.
  3. Click the Run report button.

 

You can also customize the report to show other fields such as the memo, shipment via freight or sea, or the account. For more details, you may check out this article: Customize reports in QuickBooks Online.

 

I've added an article for your future reference about saving your customized report: Memorize reports in QuickBooks Online. This will help you save your time doing customization again.

 

I'll be here if you have other questions or concerns. Just tag my name in the comment section below. Take care.

 

Aquaman1
Level 1

Quickbooks Online Report Of Sales By State By Vendor

Is there a way to have a report formatted to provide the state detail or is the online program just unable to do it. If so, what other QB versions would allow it?

MadelynC
Moderator

Quickbooks Online Report Of Sales By State By Vendor

I’ve come to show to you how to generate a report that contains state detail, @Aquaman1.


I appreciate your time getting in touch with us again. There are some features and functions in QuickBooks Online we can use to achieve this.


You can run Sales by Location Detail report. This report allows you to pull up the information you need. Before that, we’ll have to make sure the Location tracking feature is turned on. It enables you to categorize data from different locations, offices, regions, outlets, or departments every time you create a transaction like an invoice, sales receipt and etc.


Here’s how you do it:

 

  1. Select the Gear icon and choose Account and Settings.
  2. In the Advanced tab, go to Categories and select the edit (Pencil) icon.
  3. Mark the Track locations.
  4. Select Save, then Done.
    Capture.PNG


Then, you'll have to add a location you want to track and reflect in your report. Please follow these steps:

 

  1. Go back to the Gear icon and choose All Lists.
  2. Choose Locations.
  3. Click the New button.
  4. Enter the location, then choose and customize the following options, if needed.
    • Is sub-location
    • This location has a different title for sales forms.
    • This location has a different company name when communicating with customers.
    • This location has a different address where customers contact me or send payments.
    • This location has a different email address for communicating with customers.
    • This location has a different phone number where customers phone me.
  5. Press Save.


You can refer to this article to learn more about the process of tracking location in QBO. Once done, you're all set to running the Sales by Location Detail report. Here's how:

 

  1. Go to the Reports menu.
  2. Enter/select Sales by Location Detail in the search box.
  3. Click Customize to filter the necessary details and make sure Rows/Columns is set to Location.
  4. Hit Run report to display the desired information.


In case you want to create more personalized sales forms, refer to this article to customize them. It offers a unique method and showcases the value of your product to cater to your customer's desires.

Please let me know if there is anything else I can assist you with reports in QuickBooks. I'll be more than happy to help you anytime. Have a good day!

Aquaman1
Level 1

Quickbooks Online Report Of Sales By State By Vendor

I am not trying to track my own locations, but run a report based on sales to my customers for a specific product line for each state I sold products to. Anotherwords, I do not want to report each customer within a state or their actual purchases, just the total dollars I sold for a specific vendor in each state.

AileneA
QuickBooks Team

Quickbooks Online Report Of Sales By State By Vendor

Hello, Aquaman1. 

 

I am here to ensure that you're able to generate and view the accurate information that you need in your report in QuickBooks Online. You can run the Transaction Detail by Account report. From there we can customize the field to view the specific location of vendor you'd like to appear in your report. Though, the location will only show once the location apply to the vendor transactions.

 

Here's how:

 

  1. Click the Reports menu.
  2. Enter Transaction Detail by Account in the search box.
  3. Tap Customize. Then Under Group by choose Vendor.
  4. Hit the Filter and mark check the Location, Vendor, transaction Type and other details you'd like to appear in the report.
  5. Press Run report to display the desired information. 

 

 

new111111.PNG

You can also read this article for your reference: Customize reports in QuickBooks Online

 

Don't hesitate to leave a comment below if you have any other questions. Stay safe!

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us