Home > Forum Home > Excel Invoice Template > Problem with Shipping Share

Problem with Shipping

Excel Help for Problem With Shipping in Excel Invoice Template


Forum TopicPost Reply Login

Problem With Shipping

Rate this:
(3/5 from 1 vote)
ConfusedI just started using the trial version of the customer invoicing and even though I set the invoice to have N/A ($0) Shipping, when I run a sales report it shows shipping amount on it.  How do I fix this?
 Posted by on
 
Replies - Displaying 1 to 4 of 4Order Replies By: Most Recent | Chronological | Highest Rated
Oops
Rate this:
(3/5 from 1 vote)
The Shipping Cost line item in the top part of the sales reporting is actually the sum of shipping costs and tax.  It is a calculation of the difference between the total product revenue and the actual amount charged including shipping and sales tax.  In the case where there is no shipping costs, it represnts tax only.

The title is, therefore, incomplete and we will update it accordingly.  The title can be changed manually to "Shipping Costs and Tax".
 Excel Business Forums Administrator
 Posted by on
Confused
Rate this:
(3/5 from 1 vote)
Thank you for your prompt reply.  But my invoice has $0 tax & $0 shipping & sometimes I am coming up with a positive & sometimes a negative number under the shipping report.  We would like to purchase the spreadsheet, but would like to play around with it first to make sure it is what we are looking for.
 Posted by on
Surprised
Rate this:
(3/5 from 1 vote)
If there are no tax or shipping costs for any of the orders, then there should not be any total in this line item of the report.  please feel free to attach your template as a reply to the notification email of this post so that we can investigate this and respond with an appropriate solution.
 Excel Business Forums Administrator
 Posted by on
Applaud
Rate this:
(3/5 from 1 vote)
Thank you for sending through your template.  After some iterations we isolated and resolved this issue.  It was due to duplication of customer and product IDs caused when adding and updating customers and products through the control panel.

The customer invoicing template download has been updated with this fix.  If you have downloaded it before the date of this post, then you may download the updated version with this fix.  If not, the current version does not contain this issue.
 Excel Business Forums Administrator
 Posted by on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for Problem with Shipping in the