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.
I have the same issue. Can I ask, when setting up iZettle as a bank account what do I enter for detail type. Current or cash on hand?
Thanks in advance.
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.