The last week of December 2021 we started syncing our Square transactions into QBO in "summary form". Suddenly, some of our deposits listed in banking do not have invoices that correlate. We suspect it is only transactions that had discounts on the invoice that are not syncing. I mapped the discount line from Square into QBO online prior to this problem. Please advise.
Thanks for taking the time to share your experience, @sandcbrow. I’ll make sure you’ll be able to record deposits from Square in QuickBooks Online.
It will go over the method and the solution in detail. Transactions are downloaded as invoices or payments when you sync your Square app with QuickBooks Online.
If you want to register an invoice in QuickBooks Online, go through the steps below:
Make sure to deposit the amount to the Undeposited Funds account when creating a receive payment for an invoice generated in QuickBooks. Here's how:
After that, we'll record a bank deposit that includes any processing fees:
Finally, tie the deposit with the payment listed on the Banking page.
Follow the steps outlined below.
For your convenience, I've included the following articles:
In addition, have this article for your reference in reconcile an account in QuickBooks Online.
I hope this helps to clarify things for you. Don't hesitate to reach back out if you need anything else.
Thanks for coming back, @sandcbrow.
As additional insights, our system will only depend on the downloaded items your bank sent to us, then match them to your Square transactions. It is also the same when you sync Square with Quickbooks.
You can only map transactions when you import them in QuickBooks. For more insights about this process, you can check out this article to learn more about formatting and mapping CSV files to get bank transactions into QuickBooks.
Here's another informative resource about connecting your Square account to QBO.
Visit and post again if you have additional concerns. I'm always around here to guide you more.
Thank you for your response but my question relates to custom mapping of fields to allow for class tracking. See screenshot attached. I cannot map a class from Square into QBO because there is no field assigned in the QBO mapping to "class". This has become a large problem for my client.
It’s nice to see you again, @sandcbrow. I can assure you’ll be able to map transactions from Square to QuickBooks Online.
To categorize transactions by class, you'll need to activate class tracking. Here’s how:
You can also utilize this link for more information about class tracking within QuickBooks Online.
To learn more about sync with Square, you can refer to these articles:
Post here anytime if you have other program concerns or additional questions about QuickBooks and Square. Stay cool!