QuickBooks Integration and Bank Feeds

Created by Helen Robson, Modified on Thu, 19 Nov at 12:12 PM by Helen Robson

IMPORTANT: If you use the Pet Sitter Plus QuickBooks Online integration and also have a bank feed switched on in QuickBooks, the same client payment can be recorded twice. To stop this, record each payment only once: exclude the bank deposit in QuickBooks Online (recommended), or ignore the payment in Pet Sitter Plus.



TABLE OF CONTENTS


Why do duplicate payments happen?

The QuickBooks Online integration is a one-way sync. It sends your invoices (sales) and the payments you record against them from Pet Sitter Plus to QuickBooks Online, so your accountant can report on everything in QuickBooks.


A bank feed brings the same money into QuickBooks a second way. When a client's payment lands in your bank, the deposit downloads into QuickBooks Online. If that deposit is then added as income or matched to the client's invoice, QuickBooks records the payment itself. When Pet Sitter Plus syncs its own copy of the same payment, the client has paid twice in QuickBooks.


Example: Sam pays his 120.00 invoice by bank transfer. The deposit appears in your bank feed and is matched to his invoice, so QuickBooks records a 120.00 payment. You also record the payment on his Client Profile in Pet Sitter Plus, and it syncs. Sam now has two 120.00 payments in QuickBooks, and his balance there no longer matches Pet Sitter Plus.


Note: The integration doesn't read anything back from QuickBooks Online. Pet Sitter Plus can't see or undo entries made from your bank feed.



Which option should I use?

You can keep both the integration and your bank feed. Just choose one place where each payment is recorded:



Option 1: Exclude in QuickBooks Online (recommended)Option 2: Ignore in Pet Sitter Plus
Who records the payment in QuickBooksThe Pet Sitter Plus integrationYou or your accountant, from the bank feed
What you do with the bank feed depositExclude itRecord it as a payment from the right customer
What you do in Pet Sitter PlusRecord the payment as normal and let it syncRecord the payment, then set its transaction to "Ignored"
AutoSyncCan stay onTurn off (see below)
Best forMost businesses: less work, fewer mistakesAccountants who prefer to work from the bank feed


We recommend Option 1. Pet Sitter Plus already knows which invoice each payment is for, so letting the integration record it keeps your client balances in QuickBooks matching Pet Sitter Plus.



Option 1: How do I exclude a bank deposit in QuickBooks Online?

Excluding a bank feed transaction tells QuickBooks Online to skip it. The payment synced from Pet Sitter Plus is the one that counts.


In Pet Sitter Plus:

  1. Record the payment on the client's Client Profile as normal.
  2. Let the integration sync it: wait for AutoSync, or click "Sync Now" on the Settings & Sync page.


In QuickBooks Online:

Navigation: Accounting > Bank transactions


QuickBooks Online Accounting menu with Bank transactions highlighted.


  1. Select your bank account, then open the For review tab (called Pending in some layouts).
  2. Tick the checkbox next to the client's deposit. You can tick several at once.
  3. Click Exclude.

QuickBooks Online For review tab with a client deposit ticked and the Exclude button highlighted in the action bar.


The deposit moves to the Excluded tab and doesn't appear in your account histories or reports.


Note: Don't click Match or Add on a client deposit. Matching it to the client's invoice, or adding it as income (such as "Sales of Product Income"), makes QuickBooks record the payment itself. When Pet Sitter Plus syncs the same payment, it's recorded twice.


Tip: Exclude client deposits as part of your regular bank feed review, so none get added by mistake. If you exclude something in error, open the Excluded tab, tick it and click Undo.



Option 2: How do I ignore a payment in Pet Sitter Plus?

Use this option if your accountant would rather record client payments from the bank feed. The payment is still recorded in Pet Sitter Plus, so your client balances stay right, but the integration doesn't send it to QuickBooks Online.


In QuickBooks Online:

  1. In Bank transactions, record the bank feed deposit as a payment from the correct customer (client), against their invoice.


In Pet Sitter Plus:

  1. Record the payment on the client's Client Profile as normal.
  2. Open the Transaction List.


Navigation: Connect > Accounting Systems > Quickbooks Integration > Transaction List


Pet Sitter Plus Connect menu with Transaction List highlighted under Accounting Systems > Quickbooks Integration.


  1. Choose the dates, then click "Reload" to find the payment.
  2. Tick the checkbox next to the payment.
  3. Click "Edit".


Pet Sitter Plus Transaction List with a client payment ticked and the Edit button highlighted.


  1. In the Edit Transactions panel, change the State to "Ignored".
  2. Click "Update".


Pet Sitter Plus Edit Transactions panel with the State set to Ignored and the Update button highlighted.


Tip: You can also ignore a payment that's waiting to sync from the Settings & Sync page. Under Data In Next Sync, click "Ignore" next to the payment.


Pet Sitter Plus Data In Next Sync list with the Ignore button highlighted next to a payment waiting to sync.


Note: Ignore the payment before it syncs. Once a transaction is set to "Ignored", it won't sync to QuickBooks Online, even when AutoSync runs or you click Sync Now.



Should I turn off AutoSync?

If you use Option 2, yes. With AutoSync on, Pet Sitter Plus syncs new transactions every 5 hours. A payment could reach QuickBooks Online before you've had a chance to ignore it, creating the duplicate you're trying to avoid.


Navigation: Connect > Accounting Systems > Quickbooks Integration > Settings & Sync


Pet Sitter Plus Connect menu with Settings & Sync highlighted under Accounting Systems > Quickbooks Integration.


  1. Switch "AutoSync" off.
  2. Click "Update".
  3. After you've ignored any payments recorded from the bank feed, click "Sync Now" to send everything else (invoices and other payments) to QuickBooks Online.


Pet Sitter Plus Connect to Quickbooks page with the AutoSync toggle, the Update button and the Sync Now button highlighted.


If you use Option 1, you can leave AutoSync on.



Frequently asked questions


Can I use a bank feed and the Pet Sitter Plus integration together?

Yes. Just make sure each client payment is recorded in QuickBooks Online once: exclude the bank deposit (Option 1), or ignore the payment in Pet Sitter Plus (Option 2).


Why shouldn't I match the deposit to the client's invoice?

Matching a deposit to an invoice makes QuickBooks create its own payment for that invoice. When Pet Sitter Plus syncs the same payment, QuickBooks records it again as an unapplied payment, so the client's balance no longer matches Pet Sitter Plus. Excluding the deposit avoids this.


Will an excluded transaction affect my QuickBooks reports?

No. Excluded bank feed transactions don't appear in account histories or financial reports. The payment synced from Pet Sitter Plus is the one that counts.


Will an ignored transaction ever sync?

Not while its State is "Ignored". To sync it later, edit it in the Transaction List, change the State to "Queued", then click Sync Now.


I already have duplicate payments. What should I do?

Ask your accountant to undo the bank feed entry for each duplicated payment in QuickBooks Online (Bank transactions > Categorised tab > Undo), then exclude it, so only the payment synced from Pet Sitter Plus remains. Our Software Coaches can help you check your Transaction List.



Info: Related articles

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article