Using the Square App in QuickBooks Online

[desertofmaine]

I have connected QuickBooks Online to Square using the Square "App" from QuickBooks "Apps" section. I have it configured it to import daily summaries of transactions from Square into QuickBooks Online. I imported all items from Square into QuickBooks Online so it would map the income to the appropriate accounts in QuickBooks. Unfortunately, when I go to review the imported transactions, every transaction shows the "Fees" to be equal to the Total Collected. So, for example, if the Total Collected = $70 the Fees are recorded as $-70 and the amount for the Deposit is $0. Obviously Square fees should be more like 3%, not 100%. I have disconnected and reconnected, checked to make sure the transactions are being deposited into a "Bank" account in QBO, and made sure the account for the Square Fees is mapped to the appropriate Expense account in QBO. See the link to the screenshots below for more information. Can someone help me troubleshoot this integration? According to Intuit, this integration is maintained by Square, not by Intuit.

Screenshots 

[frances_a]

Hello @desertofmaine 👋

Welcome to our Community! 

I'm sorry to hear you're experiencing issues with this integration. 

You can find some resources and troubleshooting steps in this article. 

If you continue to experience issues, it is best to contact our direct support team. 

Thank you. 

[Summer2024]

@Candlestore - I can't remember if you use QB or not? If not, disregard the ping! 😂 Always appreciate your insights for our fellow Sellers. 

[Candlestore]

@desertofmaine ;

I am not sure if I can help or not because I never used QBO, but used the Desktop Version.  I imported each transaction sepperately with all my Items and QBs also had all my Items in its inventory.  So my Sales Receipt would show each Item Sold based on GTIN or SKU, Sales Tax imported from Square to elimimnate rounding errors, and an Item called Merchant Account Fees.  The Item Merchant Account Fees was setup as an Expense account so would Show a Negative amount on the Sales receipt in Quick So my Sales Receipt would show a Deposit of the subtotal in QB Desktop of Item Totals + Sales Tax - Square Fees.  When I am looking at your Image I am thinking the Maping is off and Square fees is matching somehow to the Deposit.

This is what a Sales Receipt of Mine looked like when I used an Importing Progam for QB Desktop.

Then the $30.45 is the amount Square Would Deposit.  I have the Momo field as the Deposit ID so i can add all the same Memos to match my Bank Deposits.  The Big thing you would want to do is have the Merchant Account Fee (Square Fee) as an expense and a Negative in your Sales Receipt just like a Discount applied at the time of a Sale.  I imported each Transaction to a Individual Sales Receipt not as a Summary, and not sure if you do or not to QBO.  I did this Incase there were any questions on a Trasaction I could easily find it.  I am just trying to figure out why your getting $70 for the entire Fee and not for your Sales Total.   If you have any questions maybe I can help.

@Summer2024 ;

I used QuickBooks Desktop before but stopped using Quickbooks when Quickbooks was forcing everything online.  They kind of forced me out with their Pricing.  For what I had with Desktop ($700) a year to $2000 a year online.  So I switched Accounting to about $400 a year.