Created with Sketch.Learn about PPP and Loan Forgiveness, stay informed with the latest changes.
Created with Sketch.Questions about how to close your books for 2020? Visit our Year End Resources page.
Created with Sketch.New to QuickBooks or using a new product? Visit our Get Started resource page to help you get going.
Created with Sketch.Need to make changes to your account? Visit the Account Manager Portal.
cancel
Showing results for 
Search instead for 
Did you mean: 
Level 2

Double entry of sales because of Square

Last month, I sync our QB with Square to easily match sales transaction but noticed this had caused our sales to be accounted for twice, resulting in overstated income.  Income by customer summary report shows a line for "Square Customer", I'm just thinking of deleting this but can't trace them in the bank register. I believe these were already matched and reconciled correctly. 

 

What to do? Please see the attached screenshot. 

7 Comments
Moderator

Double entry of sales because of Square

Let's modify the settings of your Sync with Square, RuzzetteAng.

 

The transactions' mapping was probably incorrect. This is why QBO created the Square Customer as a default account with duplicate entries.

 

To change the mapping settings:

  1. Click My Apps on the left panel.
  2. Select Settings under Sync with Square.
  3. Click Edit next to the Basic Settings to update the Bank account, Expense account, and Payment method.
  4. Click Edit beside the Defaults for Unmatched Items. This will update the defaults for income account and sales tax codes.
  5. Select Save changes.

Once done, the transactions that were imported will stay the same. You'll have to manually delete the duplicates. When you sync your transactions next time, the changes will take effect to match your new settings.

 

You can also refer to this article to learn more about Sync with Square.

 

Please let me know if you have more questions. Thanks.

Level 2

Double entry of sales because of Square

Thanks for your reply, Sophia Ann. I  already disconnected Square app to our account. We no longer find it helpful. What else can we do to fix this? @SophiaAnnL

 

Thanks,

Ruzzette 

Level 2

Double entry of sales because of Square

Tried deleting the transactions manually but they still appear, this time as Undeposit Funds. We are no longer in sync with the Square app as I disconnected a few days ago. How to permanently remove these double entries without affecting other accounts?

QuickBooks Team

Double entry of sales because of Square

Good day, @RuzzetteAng.

I'm grateful that you took the time to provide me with an update on the steps that you've tried, such as manually deleting the duplicate transactions. I'm here to point you out in the right direction to get past of this duplicate entries concern.

 

Since manually deleting the transactions did not work on your end, I'd suggest reaching out to our Customer Care Team. They are the best resource for such this type of issue, as they're able to request account information to pull up your company and share sensitive information, while this is a public forum. Once they have this information, they'll be able to further assist with determining the details of the transaction and why is it showing as a duplicate transaction on your account.

 

Also, you can visit this article about handling duplicate bank transactions in QuickBooks Online for your future reference: https://quickbooks.intuit.com/community/Banking-and-bank-feeds/Bank-transactions-are-duplicates-miss....

 

Please let me know how the call goes,@RuzzetteAng. I'll be around if you need further assistance. Have a great day!

Level 2

Double entry of sales because of Square

Hi @BettyJaneB

 

Thank you for your detailed reply. I'll try contacting customer service for this. Is it possible to just delete the "Square Income" account? I believe these are duplicates so I won't be needing it anymore. 

 

Thanks,

Ruzzette 

QuickBooks Team

Double entry of sales because of Square

Thank you for clarifying that to me, @RuzzetteAng.

Allow me to get this issue sorted out.

Yes, you can delete the account if you are no longer using it. This will not erase your data, your transactions and reports will remain in the file. You can also restore the deleted accounts any time.

 

Here's how:

  1. Select the Gear icon on the Toolbar.
  2. Under Your Company, choose Chart of Accounts.
  3. Find the account you wish to delete.
  4. In the Action column, select the drop-down, then Delete.
  5. When asked if you want to delete, select Yes.

For more information about deleting an account in QuickBooks Online, please refer to this article: How to delete an account and restore it.

 

There you go, @RuzzetteAng. Keep me posted if you need further assistance. Wishing you and your business continued success. 

Level 2

Double entry of sales because of Square

Hi @BettyJaneB

 

I already deleted the account but the transaction is still in the record. Because this is duplicate, I think this is resulting in an overstatement of Income. The amount still included in the total income. Any tips on how to fix/adjust this? 

 

 

Need to get in touch?

Contact us