Problem with Shipping

Excel Help for Problem With Shipping in Excel Invoice Template

Problem With Shipping

Rate this:

(3/5 from 1 vote)

I 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?

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".

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.

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.

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.