Skip to main content
J
JvP79
November 4, 2019
Solved

How do I create a report showing shipping per invoice?

  • November 4, 2019
  • 1 reply
  • 0 views

I want/need a report which shows me the shipping costs per created invoice, I need this to be able to calculate the commission fee's for my sales reps. The only way I have found to display the actual shipping costs is to get a sales by customer detail report, which also shows the shipping costs. But this report is totally unsuited to be used for my goal (create commission rate for sales reps).

 

My ultimate report would just show the customer, invoice number, total, rep, shipping and sales tax. 

 

Is there anyone who can help me out with this? Perhaps it is impossible, but I'm unable to find any reports on shipping costs (per invoice/sales order).

 

We are using quickbooks 16.0 accountants edition.

Best answer by

@JvP79 ,

Consider using a sales commission app and integrate it to your QBD. I found about 5 apps in the market.

 

Just my 2 cents.

1 reply

Rustler
Rustler
November 4, 2019

I sort of understand what you are wanting, and why; but, QB does not associate shipping costs with sales.

 

I assume you are selling with shipping included in your price structure, Probably the best you could do is to "assume" a percentage rate for shipping and just deduct that from the total sales - sometimes you will win sometimes lose that way.

 

 

 

 

J
JvP79Author
November 4, 2019

Thanks for your reply.

 

Sadly that is not possible, as I have invoices ranging from 1 to 600+ products, this would be highly inaccurate.

 

A
Anonymous
Answer
November 4, 2019

@JvP79 ,

Consider using a sales commission app and integrate it to your QBD. I found about 5 apps in the market.

 

Just my 2 cents.

    Terms & ConditionsAccessibility statement