e-junkie is setup to be an easy, do-it-yourself system that can be used by just about anyone, anywhere. That's what makes it a great tool, but of course there are some limitations (as there are with any system). 

We do not have a report to tell you what you how much VAT you owe to the different E.U. member states, but you can easily calculate this. In this blog post, we'll show you how. 

Note: You will need to use a spreadsheet program to complete these calculations. Bear in mind as you go through these step-by-step instructions, different spreadsheet programs might have slight differences.

Now, the first thing you will need to do is download your transaction log for the time period you need. In your e-junkie account, click on View/Download Transaction Log near the bottom right corner. Once the log opens set the date range you want. It will look like this...

Now the file has a lot of data, with 46 columns and you do not need all of them. I suggest deleting all of them except for Payment Date, Amount, Payment Acct Country, GeoIP, Digital VAT, Tangible VAT. Then your spreadsheet will look like this…

Next, delete the first row, you will not need that data. Now, sort the columns based on the GeoIP. The GeoIP would be the buyer’s location when they purchased the product, not the country their payment account is connected to. After you do that, the file will look like this...

You can then quickly add up the amounts if the file is small, or if it is large, you will want to use macros in the spreadsheet program to create a field with the amounts added up for you, for each country.  For this blog I’ve been using OpenOffice, and I used macros to add up the two VAT Column and then total the amounts for each GeoIP Country...

From there, you will just need to remit the appropriate amounts.

I hope that helps! If you have any questions, feel free to tweet us.