Skip to main content
January 25, 2022
Question

Syncing Square with Quickbooks online problem with discounts

  • January 25, 2022
  • 1 reply
  • 0 views

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.

 

Cathy B.

1 reply

January 25, 2022

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 datePayment 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:

 

 

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.

sandcbrowAuthor
January 26, 2022
Thank you for your response but that is not the nature of my question/issue. Suddenly, certain invoices that have discounts applied to them in Square are not appearing in QBO after syncing. I susect this is because we have changed our syncing from Square to a summary format into QBO. Is there a way to correct this problem? I believe it's something on the QBO end that is not recognizing the discounts, but I am not certain. Cathy Browning