How do I get a report that shows me gross sales by state?

How do I get a report that shows me gross sales by state?

There currently isn't a report that shows this by default. There is one in the works, but until that is finished you may modify the Sales by Customer report to get what you need. Follow the instructions below.
  1. Navigate to Reports → Sales by Customer Detail.
  2. Click on the Settings button.
  3. Click the Grouping tab.
  4. Click Add.
  5. Scroll down the field list until you see the first field called Document.
  6. Click the + sign that is next to the field name.
  7. Click the + sign next to the second "Ship To" in the List
  8. In the expanded list under Document, find and double click Region/State.
  9. Click Finish editing.
  10. Click Run Report.


The Sales by Customer Detail report

    • Related Articles

    • Sales Tax Features

      Sales Tax Keeping track of Sales Tax can be a difficult chore. AccountingSuite™ offers two ways to lighten the load and help you account for Sales Tax collection and payment. Our built in Sales Tax functionality is comprised of Sales Tax Agencies, ...

    • FAQ: AccountingSuite's Built In Sales Tax Module

      Which rate is used when calculating sales tax? The Sales Tax is calculated using the rate on the document (Sales Order, Sales Quote, Sales Invoice, Cash Sale). The rate is located on the last tab labeled "Taxes". Ok, then why is there a rate on the ...

    • Adding Sales Tax on Transactions

      Adding Sales Tax on Transactions To calculate Sales Tax on Sales Orders, Invoices and Credit Memos, follow these steps. Please note that this process will result in charges being assessed for sales tax calculation. ​ Create the Invoice or Credit ...

    • Open Sales Orders by Item Report

      How can I run a report that shows all of my open orders with back-ordered item information? Open Sales Orders by Item Report The Open Sales Order by Item report will list all Open Sales Orders, grouped by Item. There are columns that show shipped, ...

    • Editing Product to use AvaTax Sales Tax

      Editing Product to Use AvaTax Sales Tax In order to assign the appropriate tax rates, each product in your inventory must be assigned a tax code. Because some products are taxable and some are not, it is also necessary to indicate which products in ...