Export 7% and 19% VAT as order column incl. shipping tax

Hi,

I asked this question before at Germanized forum, but seems more like this plugin is relevant (Here’s a translation: https://translate.google.de/translate?hl=&sl=de&tl=en&u=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fanteilige-besteuerung-fur-versandkosten-im-csv-export%2F)

we plan to buy the Pro version and do a monthly export for our tax consultant. Currently, we still test.

In Germany there’s a special thing that there is tax on the shipping. And also we have two tax rates, so a product can be either 19% or 7%. And the tax on the shipping is is calculated based on the relation of products with both tax rates within cart.

This works fine for everything in WooCommerce, also PDF, but if I add taxes in your plugin via via /wp-admin/admin.php?page=wc-order-export#segment=product_totals then “Set up fields to export” then on the right the field “Other items”, then “Add tax” and then both tax rates, see screenshot:

View post on imgur.com

then the taxes are given without the tax that should be done on the shipping as well.

For example on a PDF and in WooCommerce it is correctly printed as:

Shipping (gross): € 4.80
Total (gross): € 58.40

Total excluding VAT: € 50.48
VAT 19%: € 6.94
VAT 7%: € 0.98 

However, on csv export it is wrongly (only netto):

Gesamtsumme,"Gesamtsumme ohne MwSt.","MwSt. 19% (ohne Versandsteuern)","MwSt. 7% (ohne Versandsteuern)","Steuern gesamt (inkl. Versand-Steuern)","Shipping Method Title","Versand (brutto)","Versand (netto)"
58.40,50.48,6.37,0.9,7.92,Versandkostenpauschale,4.8,4.15

So the 19% VAT is 6.37 € instead of 6.94 €. Ditto for 7% VAT

I already had a look at https://algolplus.com/plugins/code-samples/#add_fields and the //add all taxes as columns code example and added this to our child theme.

However:

1. I was not able to export anything. Do I also have to add “custom meta key” and “Column name” in the export frontend? If so, what names do I have to add?

2. I am not sure this will really add the 7% and 19% VAT.

Kind regards,
Gerd

PS I want to thank you for the plugin. Other than this it seems to be working very nice!

• This topic was modified 4 years ago by gerd.neumann.
• This topic was modified 4 years ago by gerd.neumann.