Klarna payments and Xero accounting

My Nop stores are backed by Klarna as a payment method. We also use Xero accounting for our financials.

Getting transactions form Klarna > to import a bank statement CSV in Xero has been a headache (manual process).

If anyone else has the same scenario, I have developed a .net core console app to convert the .CSV files from source > destination format, between a transaction date range.

Happy to share source code to public Git if anyone is interested or in need.

Jon

Hi Jon.

It sounds like you have created something to resolve my current hair loss problem.

Could you please share it with me.

Thanks
Shaun

Hi ShaunJUK,

I just need to tweak it a little as something changed on the klarna export which has broken it. I'll need a day or so, then I'll post it to github where you can grab it, and happy to discuss.

It's a bit rough around the edges, but it gets the data from A > B without manually preparing spreadsheets.

Jon

ShaunJUK wrote:

Thats great.

How do you get it to deal with VAT? I noticed the statement I download doesn't have vat per transaction just on the total fees.

Oh I also had problems with the fees showing as a positive figure.

Shaun

The Klarna transaction report  has amount (net) and tax_amount for each transaction - we add them together to put the gross amount into the Xero bank statement csv

Then when we manually reconcile the Klarna bank account in Xero, we post a new (tax inclusive) transaction against Klarna supplier with an expenses nominal code with default of 20% VAT

For the fees, we have logic that if its identified as a  klarna fee or sales refund , we multiply by -1 before output


ShaunJUK wrote:

Hi, Would it be possible to share this file with me please?