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 report Request 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

  • Doug
    Thank you for posting this information – and I agree, for contractors who are interested – there are incredible opportunities available for working on government funded construction projects; as long as they are prepared.

  • We recommend and use QuickBooks for Contractors. For those contractors that are interested, there is an incredible opportunity for them in the federal sector.

    Here’s an overview: Our Government will continue to grow as the population grows. A review of the number of licensed contractors, more than 884,000 of them, compared to those that have registered and received federal construction qualification, only 20,049, is demonstrative of why there is 97.75% less competition for federal construction work even as the numbers of opportunities continue to increase.

    To close that gap, Government Construction Experts ( created a special website where contractors, builders and subcontractors can learn the exact process, step-by-step, on how to join the 20,049 contractors that are able to bid on Uncle Sam’s myriad of construction opportunities.

    And for the professional, BidTrakker ( was created. BidTrakker Market Reports are the fastest way for contractors to find federally funded projects to bid on.

    The few Pros that have access to this valuable tool, have already completed more than 280 contracts bringing them over $80 million in new revenue and profits. To learn the secrets of the pros, visit and sign up for one of the advanced federal construction business acceleration training workshops.

    Our Government continues to be, by far, the biggest spender for construction projects. Those contractors that have not taken the time to research this lucrative field are losing out even as those that are in the federal construction business continue to thrive and grow during these otherwise economically depressed times.

    Everyone needs to quit complaining and look at the bright side. When the economy gets depressed, our government spends more creating an unprecedented level of new construction opportunities.

    Those contractors that get registered and qualified will thrive!

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