Syncing Square with Quickbooks online problem with discounts

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:

• Once your customer has paid the invoice, create a payment receipt.
• Make a deposit and remember to include the processing fees.
• Verify the deposit against the Square transaction you downloaded from the Banking page.

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:

1. Go to + New > Receive Payment.
2. Choose the Customer's name.
3. Enter the Payment date, Payment method, and select Undeposited Funds account from the Deposit to drop-down list.
4. From the Outstanding Transactions section, put a check mark on the invoice you want to pay.
5. Click Save and close.

After that, we'll record a bank deposit that includes any processing fees:

1. Go to + New > Bank Deposit.
2. Select the bank account.
3. In the Select the payments included in this deposit section, put a check mark on the payment you want to deposit.
4. Under Add funds to this deposit, select the customer's name from the Received From column.
5. Select an expense account from the Account column, and enter the fee as a negative amount.
6. Click Save and close.

Finally, tie the deposit with the payment listed on the Banking page.

Follow the steps outlined below.

1. On the left panel, click Banking.
2. Go to the For Review.
3. Find the square payment, and click the Match.

For your convenience, I've included the following articles:

• Record invoice payments in QuickBooks Online.
• Record and make Bank Deposits in QuickBooks Online.
• Categorize and match online bank transactions in QuickBooks Online.

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.

Cathy Browning

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:

1. Navigate to Settings and click Account and Settings.
2. Go to Advanced, then choose the Categories section to correct.
3. Verify Track classes.
4. Check the box Warn me when a transaction isn't assigned a class. This is optional, but it's a good idea to enable it so that when you look at reports, you can see that everything has been classed.
5. From the Assign classes, choose One to whole transaction or One to each row in transaction.*
6. Save, once Done.

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:

• Sync with Square - Default Accounts and Names.
• Connect your QuickBooks Online to Square.

Post here anytime if you have other program concerns or additional questions about QuickBooks and Square. Stay cool!

I tried this, but my classes are still not importing into QBO from Square, even though the Products/Services in QBO that match the Square transactions have been assigned classes in QBO. Is there a way to fix this? 

Thanks for performing the steps provided, Lauren. Let's figure out how to import your classes from Square to QuickBooks Online (QBO).

Since you've already done the step to QBO, It's important to note that the information shown in QuickBooks will based on the Square app setup. Therefore, I suggest contacting their customer support team for further assistance in checking the setup for both applications.

Here's how:

1. Sign in to your QBO account.
2. Click Apps from the left panel.
3. Go to the Find Apps tab.
4. Search the square app you use.
5. Open the app and on the lower right corner check the contact support information.

I'm including this article if you need to generate a report specific to pull-up classes: Run report by class in QuickBooks Online.

If you have any additional questions regarding imports, please feel free to ask. We would be delighted to assist you further. Have a good day.