QuickBooks 2011 – New Sales by Ship To Address Report

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 thoughts on “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 (www.GCExperts.com) 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 (www.BidTrakker.com) 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 http://www.governmentconstructionsecrets.com 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!

Comments are closed.