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.
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
Total Quantities (of all items sold) and Amounts are then subtotaled by City and State.
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.
|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.