Zettle integration and quickbooks

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.

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!

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.

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!

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

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.

Thank you for your prompt reply.

Unfortunately, these are transactions that go back several months, therefore they do not appear in the "For Review" section of Bank Transactions.  How do I exclude them retrospectively?  Do I need to simply delete these entries?

Thanks for getting back to this thread, @Chris_Birchall.

It's possible that these downloaded transactions are already categorized. That's why they aren't posted in the For review tab. 

I'd recommend checking your Categorized section on the Banking page. Then, look for the duplicate transactions and can Undo them. This way, they will be posted back to the For review section. From there, you can now exclude them to avoid duplicates. 

Here's how:

1. Go to Bookkeeping and select Transactions. 
2. Click Banking.
3. Select the For Review tab.
4. Check the box of the transactions you want to exclude.
5. Click Exclude.

Once done, they'll be moved to the Excluded tab of the Banking page.

If you accidentally exclude the wrong transaction, that’s easy to fix. Just select the Excluded tab, select the checkbox for the transaction, then click Undo. The transaction goes back to the For Review tab so you can decide what to do with it again.

Whenever you're ready to reconcile your accounts, you can check out our complete reconciliation guide to understand the full workflow.

Feel free to get back to us here if you have other questions about managing your bank accounts. I'm always here to help.

Thank you so much for your help thus far.

The problem is that these duplicate entries do not appear in the Categorised section of the Banking page, only the actual deposits do (for the amount minus the Zettle fees). 

The duplicated (total amount) entries appear on the Bank Account History page, thereby artificially inflating the balance.  They also appear on the Invoices page (marked Deposited). It seems Zettle has been creating an invoice for these deposits (and immediately marking it as paid) in addition to (correctly) entering it on the banking page.
I suspect this may be due to incorrect field mapping in the Zettle Integration whereby we had allocated TSB Business Bank Account as the Zettle liquid account in the Zettle Payments section (see screenshot).

I am awaiting a reply from Zettle Support regarding the correct settings moving forward, but meanwhile, how can I remove the duplicated entries from the Bank Account History page? Can I simply delete them? Will deleting them from the Invoices page do the job?

Hello there, @Chris_Birchall. I appreciate you coming back to provide more details about the duplicate entries.

To remove the duplicate from the bank account history page, you can simply go to the chart of accounts.

Here's how:

1. Go to the Gear icon at the top.
2. Select Chart of accounts.
3. Locate and open the account.
4. Click the "View register" link under the Action column.
5. Find and open the duplicate entry.
6. Once the transaction is open, delete it from there.

But before deleting the duplicate, it'd be best to wait for the reply from Zettle Support. They may correct the duplicate entries from the past and now.

For more details on where to find your transactions in QuickBooks, see this article: Find, review, and edit transactions in the account history in QuickBooks Online.

For future tasks, here's a great resource about the best practices when reconciling: Reconcile an account in QuickBooks Online.

If you need additional help with your duplicate transactions, please let us know. We’ll be right here to further assist. Take care, and I wish you continued success.

Hello

This how to get the Zettle/QuickBooks interface to work automatically! 

In Zettle

Deposit Account is your Bank Account, the one that your Zettle payments are deposited into.

Zettle Payments Data should all be a Cash at Bank and in Hand account that your create in QuickBooks for Zettle transactions.

In QuickBooks

The Zettle interface will:

• Post the gross invoice amount to the Zettle Customer account.
• Create a payment to settle the invoice depositing the funds to the account created above.
• Post Fees expense to the Zettle Supplier account deducting the amount from the account created above.

When the payment is received into your bank account, in QuickBooks post it to the account created above. Better still once you’re happy it’s working set up a bank rule to automatically post it.

In the Zettle Cash at Bank and in Hand account in QuickBooks

Payment/Deposit                            £323.00

Fees                                £5.65

Bank                           £317.35

thanks for that info, is there any way of product reporting, for instance the deposit sum contains the days sales+ 3x separate Zettle card transations

then deposits 1 lump some, can you drill down to see products sold

That would be down to the information coming through from Zettle so not currently, they only send the totals each day. 

Thanks that explains it cheers 

Does this. Make sense. Is this how it works
Parent bank = current account

Zettle takings income = only see those 
Qb invoice >on own
Sales receipts income >on own
So you can have 3 sources of income and more it’s unlimited really
But all counted as income and dropped in to the current account 

Then expense’s are same as parent is current account
But you already categorise those in the same way as subaccounts like income I explained above
Fuel
Zettle fee
Bank charges
Advertising
Lights
And so on
So you break down how much you paid out.
When all totalled up you end up with total expense that is taken away from your income

So
QB invoice sent , when a payment comes in to its corresponding deposit account , it is matched by payment number.

Same with sales receipts and the type of payment you received eg cash , cheque or Bacs or card , you choose the deposit account for payment source .

Now Zettle the missing link
If you issued a sales receipt as above
You mark the sales receipt paid by card reader or Zettle card reader you name it ,, that payment is then dropped in to a deposit account of its own.
The items you sold are on the sales receipt, the money has been deposited to its own
This all goes to income under parent current account
In the same manner as if you received cash, only cash would go in undeposited