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 1

What is easiest way to record an online sales transaction and also record the Square processing fee to match bank transaction that includes both

 
2 Comments
QuickBooks Team

What is easiest way to record an online sales transaction and also record the Square processing fee to match bank transaction that includes both

I'm here to walk you through the process of recording your sales transaction, info1372.

 

When you sync your Square app with QuickBooks Online, transactions are automatically downloaded as invoices or payments. If you want to record an invoice, then we'll have to do the following:

 

  • Create an invoice.
  • Make a receive payment once your customer paid the invoice. 
  • Deposit the payment and include the processing fees.
  • Match the deposit to the Square transaction downloaded on the Banking page.

 

Here's how to create an invoice:

  1. Go to the + New menu.
  2. Select Invoice.
  3. Choose the name of the customer in the drop-down list.
  4. Enter the other necessary details.
  5. Once done, click on Save and close.

 

After that, let's create a receive payment for the invoice. Make sure to deposit the amount to the Undeposited Funds account. I'll guide you how.

 

  1. From the + New icon, select Receive Payment.
  2.  Choose the customer's name from the Customer drop-down menu.
  3. Select the Payment Date and Payment method.
  4.  Under Deposit to, choose Undeposited Funds.
  5. Under the Outstanding Transactions section, put a checkmark on the invoice you want to pay.
  6. Click Save and close.

 

Then, let's record a bank deposit to include the processing fees by following these steps:

  1. From the + New icon, select Bank Deposit.
  2. Choose the bank account where you want to deposit the money.
  3. On the Select the payments included in this deposit section, put a checkmark 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 then enter the fee as a negative amount.
  6. Click Save and close.

 

Once done, we can now match the deposit to the payment posted on the Banking page. 

 

Here are the steps:

  1. Go to the Banking menu and then select Banking.
  2. Click the For Review tab.
  3. Find the square payment, then click the Match link. 

 

 For more information about managing Square transactions in QuickBooks Online, I suggest checking these articles:

 

 

Additionally, I've added an article that'll help you reconcile your accounts so they match your bank and credit card statements: Reconciliation Guide.

 

For more questions in recording transactions in QuickBooks Online, feel free to click the Reply button. This way, we'll be able to answer them for you.

Level 15

What is easiest way to record an online sales transaction and also record the Square processing fee to match bank transaction that includes both

@info1372 

Explore this connector to reconcile your Square data into QBO account.

https:// synder.grsm.io/quickbooks

 

If you are trading merchandises, you may have an inventory management app as the connector.

Need to get in touch?

Contact us