by Sunburst Software Solutions, Inc.
Archives by Month

QuickBooks 2011 – New Sales by Ship To Address Report

Print Friendly, PDF & Email

The Sales by Ship To Address report was first introduced in QuickBooks 2011, however, also available in QuickBooks 2012, 2013, and 2014.  As the name implies, this report will display Sales by Ship To Address.

This report lists detailed sales information by ship to address.   To find this report, from the Report menu in QuickBooks Pro and Premier 2011 and Enterprise 11.0  -> choose Sales -> Sales by Ship To Address.

Reports-Sales-Sales by Ship To Address

Right click on the image to enlarge it.

The report initially shows a detailed listing of all items shipped to specific locations and then it includes a total for each unique address/city you ship to. The report includes invoices, credit memos, and sales receipts. It doesn’t include statement charges, sales taxes, or reimbursed expenses.

Each unique ship-to location appears as a separate group. The report sorts the groups first by state and then by city. If you enter a sale without a ship to address, it appears at the end in the City (Other) group.

By default, the report displays:

  • the transaction Type (invoice, credit memos, or sales receipts)
  • the transaction Date, transaction Num(ber), Ship to Address 1 (the information contained in the first line of the Ship To Address block in the Customer or Job Record)
  • Ship to Address 2 (the information contained in the 2nd line of the Ship To Address block of the Customer or Job Record)
  • the Item sold
  • Qty (how many items were sold)
  • Sales Price, and
  • Amount

Total Quantities (of all items sold) and Amounts are then subtotaled by City and State.

sales by ship to address

Right click on the image to enlarge it.

While I’m not sure that this is a relevant report for contractors, I do see it as being a very useful report for Retailers.  Retailers could modify this report and filter it by specific item to see which item is popular in which Cities and States.  This information could then be used to determine which items they should discontinue or which items are the most popular so they could run a “sales promotion” on those items focused on specific cities and states.

how to complete a certified payroll reportRequest our FREE 142-page “What’s New in QuickBooks 2011? eBook, by completing a simple request form.

This eBook will provide you with with all the information I’ve posted here in our blog, plus MORE!

Once you’ve completed our simple request form, you’ll have instant access to this 142-page .pdf eBook, designed to be duplex printed and put in a binder for future reference.

2 Responses to QuickBooks 2011 – New Sales by Ship To Address Report

    About Your Host:

    Nancy Smyth, Certified QuickBooks ProAdvisor

    Nancy Smyth, Sunburst Software Solutions, Inc.
    QuickBooks Construction & Payroll Expert

    I've been using and supporting QuickBooks products since the early 1990's. I've worked with thousands of contractors, assisting them with QuickBooks setup, Certified Payroll Reporting requirements, AIA Billing and Weighted-Average Overtime.

    QuickBooks is a powerful product, but learning how to use it in your construction business can be difficult. I hope you find resources available here to be helpful.

    Top QuickBooks blogs to read in 2018
    We've been selected by TSheets as a Top QuickBooks blog to read in 2018!
    Stay updated!

    Sign up to receive our latest QuickBooks Tips, Tricks & News via email:

    Enter your email address:

    Delivered by FeedBurner

    We promise NOT to sell, rent, or otherwise distribute your name and email address!

    FREE 30-Day Trials

    Request FREE 30-day Trials of QuickBooks add-ons for Certified Payroll, AIA Billing & Payroll Wage Management. Save time and increase accuracy on time-consuming error prone tasks; so you get paid on time!

    Free 30 day trials of QuickBooks integrated add-ons for certified payroll, aia billing and weighted-average overtime

    Certified Payroll Training:
    Learn how to complete a Certified Payroll (Prevailing Wage) Report and fulfill your reporting requirements - 2 hour recorded webinar - $99.99. Click here for more info.

    certified payroll requirements webinar
    QuickBooks Training

    Frustrated with QuickBooks?

    QuickBooks Premier ContractorLearn how to get the MAXIMUM possible results from QuickBooks in your construction business! Visit our new QuickBooks training website, Learn to use QuickBooks in your construction business.

    QuickBooks Time Tracking

    Save 10%/FREE 14-day trial!

    QuickBooks Time Tracker