I charge a client £40 and then take a card payment, the £40 goes into izettle accounts and izettle will deduct their 2.75% fee & transfer the balance to my business current account, ie £38.90 in this case. How do I set this up.
I need to know the total cost of fees at the end of my business year and have this entered into the profit and loss.
I also need to show I've charged the client £40 but only received £38.90.
I would like to be able to enter in a % as a fee rather than calculating it and entering in the money received each time.
You would be best to record these transactions using the Undeposited Funds account to receive the full payment from the Customer to settle the invoice amount. Then when iZettle transfer the balance minus their fee to your bank, use a Bank Deposit to move the funds from Undeposited Funds to the bank account minus iZettle's fee.
The fee would have to be added as a minus figure ie -£2.75 rather than a percentage using the Add New Deposits line on the bank deposit screen and you can deposit this fee to an expense account for iZettle under the Account column on the deposit. You can set this expense account up within the Chart of Accounts if you haven't done so previously and run reports on this expense account to calculate the costing to your business.
Let me know if you have any queries. Or, if you'd like to go through this over the phone, you can call our dedicated team who will be happy to assist you. Our contact details can be found here along with our opening hours.
I would wait for the transaction to hit your main bank account and then just split the bank transactions, so gross up for the sales and use the VATapplicable VAT code and then put a -ve in for the card fees and again, use the relevant VAT code.
I would not mess about with creating bank accounts etc.
Actually, grouping multiple transactions into one bulk deposit is just what Undeposited Funds is for. All the payment processor related apps/plugins use it for just this to automate the process. Only I'm not aware there is one for iZettle. A bank account would only make sense if a) you can hold a balance and spend from iZettle and b) there was a bank feed integration.
We are completely new to Quickbooks - we use izettle for all sales but have just found out that it is not supported on Quickbooks! Please can I ask how you manage to record your izettle sales, is it done manually?
Welcome to the Intuit Community, @lskitchen.
Yes, you'll need to manually record your iZettle sales since the integration with QuickBooks Online (QBO) is currently unavailable.
@charlie5 is correct that you need to set up iZettle as a bank account in the program. Here's how:
Then, you can follow the steps provided by my pear above, @Anonymous, on how to record your iZettle sales.
If you have follow-up concerns about this or should you need anything else, please let me know. I'll be around to help, @lskitchen.
Hi there @clivetheplumber6,
Allow me to join in on this conversation to provide some insights on setting up iZettle as a bank account.
I'd suggest selecting Current as the detail type. Cash on hand is another name for petty cash, so I won't recommend it in this situation.
For the whole process of creating this bank account, you can refer to the steps provided by @RaymondJayO above.
In case you need to troubleshoot your Account Receivables balance not matching the report, refer to this article: AR balance on the Chart of Accounts does not match AR balance on reports.
Feel free to drop a comment below if you have any other questions.
I've been reading the thread about how to reconcile payments made via iZettle in QuickBooks Online. There seems to be some confusion about whether to record the income in the Undeposited Funds account or to set up iZettle as an account in its own right.
Can anyone clarify the best way to do this? I'm having trouble matching invoices to received amounts as the fees are taken by iZettle prior to depositing the amount in our back account.
I'd appreciate any advice on this.
If the fees are taken prior to the amount being deposited to the account. We would normally suggest using the undeposited funds.Do you create an invoice in QuickBooks for the full amount without the fee?If so it would be a case of going to receive payment on the invoice to the undeposited funds account.
Then going to bank deposit in the + symbol in the top right>selecting the bank account and date the money was paid in>ticking the transaction>then on the line add funds to this deposit entering the supplier name,expense account and amount for the fee,making sure to put a minus symbol before th amount.Then when you save it will deposit only the amount received into your bank.You can then match in the banking.
Currently at the moment Izettle is not an bank account you can add into QuickBooks though you could import a CSV if you wanted to bring through the full amount inclusive of fee.
Thanks for the quick response.
Yes, that's correct, fees are taken before being deposited to the account but we create an invoice in QuickBooks for the full amount without the fee.
So, as we understand, we open the invoice to receive payment, select online banking as the payment method and then select deposit to undeposited funds.
Where we're struggling with is that we can't find 'bank deposit' in the top right cog. Which screen do we need to be in to do this? The deposits from iZettle are currently sitting in the Banking screen but we can't see how to move them to match them to the invoices in the undeposited funds account, or where to add the fees.
I apologise the bank deposit section is in the + symbol in the top right.You should then be able to follow the other steps in the post above but if you have any questions let us know
Ah ha! That makes more sense. Thank you Emma.
However, all of the deposits that come into my bank account from iZettle are now showing the name of the customer to whom we matched the first payment. How do I stop this from happening? QBO keeps trying to match payments to an invoice that has already been paid.
Thanks for getting back to the Community, @louisestevens1.
Allow me to chime in and provide some additional information about matching transactions in QuickBooks Online (QBO).
Once the invoice transaction is already paid, and the Register status is not yet Cleared (C) or Reconciled (R), QBO will automatically match the bank transactions that correspond to any of these factors: the date, amount, and account.
You have an option to unmatch a bank transaction by following these steps:
For additional reference, you can check these articles to learn more on how to add, match/unmatch, and reconcile in QBO:
Please know that you're always welcome to post if you have any other questions about matching transaction in QBO. I'd be happy to answer them for you. Wishing you and your business continued success.
I would like to start using iZettle for my coffee shop. So I will have card and cash receipts, with a cash float sitting in my till at the end of the day; also some cash banked in same day.
I don't think I want iZettle connected to my QB.
What is the best way to record the daily transactions?
Hello there, @Adana20.
You create an expense transaction without a payee as long as you have selected an account. Let me guide you how.
Once done, you can check your report to see the expense transaction.
I've also added this handy article about income and expenses for additional resources.
Please click the Reply button anytime if you have other questions. We're always here to help.
Hi @GraceC ,
Thank you for your reply.
I think I did not explain very well.
I would like to add in QB daily transactions that go through iZettle at the till.
So I would like to know how do I post the "Invoice" in QB to match it to the payment received from iZettle. (Keeping in mind that the card fees will be deduct before and I will be also banking cash as the cash received from iZettle does not include the cash/any float in the till).
How would I post the Gross, the refund, the card fees etc?
I would like to help you with this, Adana20.
If the iZettle will only not generate invoices, we can use a transaction importer app to add the daily transactions (invoices) from iZettle to QuickBooks.
On the other hand, if the iZettle will only report invoices, we can use the import data using a CSV file to bring them in your book. I'll guide you step by step on how to do it:
Once they are in your book, let's match and categorise the downloaded transactions in the banking page.
Please get back here anytime if you have other questions. I'll be around to respond to you as soon as I can. Take care!
My accountant told me this method to match izettle fees: In principle you would “find Match” and use Resolve at the bottom to code the difference to Izettle Fees. Hope this helps but please let me know if not.
But when I have done that and entered it how they say, it then comes up with "the selected and downloaded transactions do not match. To continue, resolve the difference" As you put izettle fees as exempt from vat they said, but under purchases or sales exempt??
I am extremely confused. Can anyone help with pictures on what to do ? I don't understand the writing it out unfortunately
Welcome to this thread, MaiMurray.
Expenses from vendors are considered to be under purchases while purchases from customers are under sales. If you're not sure which one to use, I would recommend consulting with a certified accountant or bookkeeper on this, especially when it comes to managing fees.
Our Find-a-Pro-Advisor page will be able to assist in connecting you with a certified accountant or bookkeeper that also specializes in QuickBooks Online: https://quickbooks.intuit.com/au/find-a-proadvisor/.
I'm leaving you this article about matching and categorising transactions: Match and categorise the downloaded transactions.
Get back to me if you have additional queries while handling fees in QBO or any other questions. I'm always here to help, Have a great day ahead!