There are libraries that you can use to extract the data from .xls files (e.g.this post on stack overflow if you’re in the ASP.NET world, I’ve used Apache Poi to do the same in Java). If there were sufficient demand for this then there are ways import from XLS could be implemented.
1 Like
Thanks Ian, I think that’s what we would do.
As you say, we’d probably want to see more demand before bringing in a new library, or at least somewhere else we could make good use of it.
Hi
Just gonna leave this here - got an email today from iZettle about xero integration.
http://help.izettle.com/customer/portal/articles/1904954-integrate-with-xero
Cheers
1 Like
I also got the same email from iZettle. Would be great if this could be mimicked in QuickFile too. 
@Sam_James @dagayveggi I would suspect iZettle carried out the work to integrate with Xero rather than the other way around. If you note my response from 3rd February I was advised at the time that no public API existed to extract this sort of statement information.
I have however emailed iZettle partnerships to discuss this further as it’s possible the individual I spoke with may not have been aware of the technical options in terms of integrations.
3 Likes
+1 from me also.
We have been using iZettle for our card payments over the last 6mths as it was effortless to set-up unlike PayPal Here…(I’m still waiting for my confirmation… 
)
The iZettle portal is fairly user friendly and once you get your head around their terminology (e.g. ‘Transactions = Sales’) it’s quite straight forward.
In the screen shot below you can see a mix of Cash & Card payments from our customers earlier this month, which can then be exported to Excel and uploaded/attached into QuickFile.
If anyone needs any basic help in getting set up or pointers on how to use the portal etc. Feel free to get in touch.
John Richardson
Scruffies Pet Groomers.
I use iZettle too, mainly for Craft & Design markets, and soon in my wee pottery shop in my new studio.
I have my ‘customers’ set up by type of sale, since I don’t have many recurring individual customers, so my client list is ‘craft markets’, ‘open studio sales’ ,‘gallery sales’, and then accounts for individual reseller outlets as needed (since they will have recurring).
I mostly use iZettle for the first two - markets and studio sales, recording every sale whether cash or card and using it as a type of cash register, then I raise invoices in QF by date or by event (so, a weekend two-day market will be one invoice), and will be ‘paid’ by my iZettle bank (merchant) account.
In this instance, being able to import my izettle transactions for a particular date range to make up an invoice would be fantastic, as it would save me having to enter line by line on the invoice, but still allowing me to see what sold at that particular market/event.
Anyway, when/if this gets developed, I’ll be very happy. If you want any help with reports or formats, etc, in the meantime, I’m happy to help. 
Kath
@MoKaPottery as per my reply further up, there’s not much we can do here until iZettle publish an open API. You’d need to ask iZettle to implement this, even better it may be worth suggesting they integrate with Zapier, this will then open up many opportunities with other 3rd party apps, not just QuickFile.
Glenn,
When I searched for iZettle integration this nearly 2 year old topic is the latest I could find. Maybe they have moved on some by now? Is this what is required? https://github.com/iZettle/api-documentation
I am just setting up my sisters business on QuickFile and she would like to take payments at events and we are going to give Stripe via the QuickFile take payment option a go for the first one but I think it may be a bit cumbersome for each sale. iZettle looks like a better option and it would be better if the sales can be pulled into QuickFile with the API rather than using an Excel import.
Not sure what is needed. Any thoughts?
1 Like
We have just started testing QuickFile to see if its suitable for us and we use iZettle so would love some form of integration making entering transactions quicker.
Kind regards
Hi - I’m also starting to use iZettle. Is there a way to add the company to the drop down list of choices when you set up a new bank account.
Also in future is you do offer API will I be able to link into the account I create now to pick up transactions?
Thanks
Hi @justbreve
We have just added iZettle to the list of banks and payment service providers.
Until recently iZettle didn’t have an API, it look like they have since published an API Spec. When the resources become available we’ll take a look at this in more detail.
1 Like
Hi, I also have started using Izettle. Is it integrated into QF yet? I’m not a very techie person 
Not yet I’m afraid, but we’ll be sure to let you know if this changes 
There are several threads requesting payment/merchant accounts integration, izettle, sumup, square.
I read in another thread here Izettle integration that Glenn wasn’t quite sure what sort of integration would be possible.
Are there still doubts over this? What are the intentions at quickfile?
As an aside, apparently Xero have izettle and sumup intergration already.
Hi @ScrumpyJack
We are still open to working on an integration with iZettle. At this time it’s not on our development planner but that may change.
If anyone did want to develop an app for the QuickFile marketplace for iZettle, we are certainly happy to work with the developers to make this work.
If this is still not done I would be tempted to look at app creation if you could point me in the right direction.
Until then how am I to upload statements to an Zettle merchant bank account as there is no feed.
I can download excel statements but the raw statement from Zettle does not break down the fees and the month option from Zettle is a summary of the entire month rather than per transaction.
We did reach out to iZettle but unfortunately, we’ve had no response. I would encourage anyone looking for this type of integration to contact iZettle and express their interest in this.
If you did want to explore creating your own integration, there are a few links that can help. If this is just for yourself, then the API is more than enough, or you may wish to look at posting it to the QuickFile App Marketplace for other users to use too.
I will reach out to them. But could you reply with how I get transactions into quickfile for the time being please.
Hi Parade_Stores,
I am not with zettle (izettle is now zettle) but had a quick look on their help page. There must be report (payment report) which gives you a breakdown of very transaction and the fee you have to pay to zettle - have a look here:
https://www.zettle.com/gb/help/articles/1318029-accounting
When you download this payment report to your laptop you should be able to upload it to your quickfile zettle account. In your zettle account, under option, there should be a line ‘upload statement’
click that and upload your file. You may have to change a few things in Excel or a similar app before you can upload it.
Hope this helps