Skip to main content
A
AtoZ123
November 6, 2021
Question

Zettle integration and quickbooks

  • November 6, 2021
  • 2 replies
  • 0 views

I've taken a few card payments with Zettle and some payment links. I recorded the card payments as Sales Receipts and created Invoices for the payment link payments.

 

The payments received from Zettle are less fees, so the payments don't match up to the invoices or sales receipts. I then integrated Zettle and QBO to allow the fees to be recorded in 'Zettle fees' account I created.

 

The problem I now have is that Zettle have recorded these payments as separate invoices, so I now how duplicates of all of these payments recorded. What is the best solution here? Can I match/link the Zettle payments that have integrated with the Invoices and Sales Receipts I created originally?

2 replies

S
SarahannC
November 7, 2021

Hello there, @AtoZ123.

 

Yes, you can match them. However, we need to correct your existing transactions first.

 

We can only match bank transactions to existing ones in QuickBooks when they have the same total amount. In this case, we can edit the transactions you created within QuickBooks and enter the correct amount.

 

To edit the sales receipt and invoice, you can follow these steps:

 

  1. Select Sales from the sidebar menu.
  2. Go to the All Sales tab, then locate and open your invoice.
  3. Make the necessary changes, then select Save.
  4. Choose Yes to confirm the changes.
  5. Click Save. 

 

Then, you can exclude the duplicate transaction by following the steps below. They won’t be added to QuickBooks or downloaded again. This will keep your accounts accurate.

 

  1. Go to the For Review tab.
  2. Check the checkbox for each transaction you want to exclude.
  3. Select Exclude.

 

Once done, you can match them. Check this article to view the complete details: Matching and categorising your bank transactions.

 

Also, free to visit our Banking page for more insights about managing and reconciling your bank transactions. 

 

I want to make sure everything is taken care of for you, please let me know how it goes or if you have any other issues or concerns. Just leave a comment below and I'll get back to you. Have a good one, AtoZ123.

S
SarahannC
November 11, 2021

Hi AtoZ123,


Hope you’re doing great. I wanted to see how everything is going about matching the payments. Was it resolved? Do you need any additional help or clarification? If you do, just let me know. I’d be happy to help you at anytime.


Looking forward to your reply. Have a pleasant day ahead!

A
AtoZ123Author
November 11, 2021

No its not resolved.

 

Zettle charges fees for accepting payments. I need to record the payment received against an invoice (or create sales receipt) for the amount I charged less the Zettle fees, which I also need to add as an expense.

G
GebelAlainaM
November 11, 2021

Thank you for taking the time to post a reply here in the Community, @AtoZ123. I'm here to help you.
 

If you want to manually record the bank deposits in QuickBooks Online, you can follow the process below:
 

Step 1. Put transactions you need to combine into your Deposited or Undeposited Funds account. 
Step 2. Combine transactions in QuickBooks with a bank deposit.
Step 3. Include bank or processing fees.
Here's how:

  1. Scroll down to the Add funds to this deposit section.
  2. Enter the fee as a line item.
  3. Select who the fee was from (ex: the bank charging you).
  4. Select Bank Charges from the Account ▼ dropdown.
  5. Enter the amount fee as a negative number. For example, if the fee was GBP £ 50, enter –50.
  6. Review the deposit total with the bank fee.
  7. Select Save and close or Save and new.

For further reference, you can check this link: Record and make bank deposits in QuickBooks Online.
 

If you want to automatically pay the invoice to QuickBooks Online, I suggest calling the Zettle app support.
 

Here's how to contact the Developer Support:
 

  1. Go to Apps.intuit.com.
  2. Type in the Zettle app in the search bar.
  3. Select the Contact tab or the Support tab.

If you need further assistance, don't hesitate to post a reply. The Community and I are willing to assist you. Take care and have a wonderful day ahead!

C
Chris_Birchall
January 10, 2023

My similar issue is as follows...

When Zettle makes a deposit to my bank account it creates an entry in my QB "Card Payment via Zettle" account for the full amount, called "invoice" with a long number and annotated, "Zettle by PayPal".  Then a couple of days later, it creates a second entry called "deposit" for the full amount less the Zettle fees and at the same time adds the fees to the appropriate Expense account.

This results in the QB bank account showing two entries for the same transaction as you can see from the attached screenshot.

How do I prevent the "invoice" entry from appearing to allow my QB bank account to match my actual bank account?

 

Further info:

On Zettle's QB Integrations page, the accounts are matched as follows...

Zettle sales data = "Card Payments via Zettle";

Zettle fees data = "Zettle Fees";

and the Zettle liquid account =  "TSB Business Current Account"

 

Any advice would be very much appreciated.
Chris Birchall

M
Mark_R
January 10, 2023

Thank you for sharing a screenshot and detailed information on your issue, @Chris_Birchall.

 

Let me provide some information on how QuickBooks manage the integration with Zettle.

 

QuickBooks only depends on the data transferred from Zettle. Thus, the invoice and deposit entries showing your QuickBooks bank feeds are coming from Zettle. To avoid these duplicate entries, I suggest excluding the invoices in the For review tab. Here's how:

 

  1. Sign in to your QuickBooks Online (QBO) account.
  2. Click Banking/Transactions from the left menu.
  3. Go to the For review tab.
  4. Find the invoice that caused the duplicates. Then, put a checkmark on each of them.
  5. Click Exclude.

 

You may need more assistance categorising and matching transactions in QBO. This article will guide you through the steps: Categorise and match online bank transactions in QuickBooks Online.

 

Feel free to leave a comment below if you have follow-up questions about the integration. The Community team and I are always here to help.

Terms & ConditionsAccessibility statement