Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
March 12, 2020
Question

Record square transaction with an invoice

  • March 12, 2020
  • 2 replies
  • 32 views

Hi, I know there is an addon for square, but I want to know how I can propertly record an square transaction with an invoice.

 

Let says the invoice is 200$ and square takes 2% for processing fee. In total I get 196$ in my bank account. How I can resolve the gap? How I can say the 4$ is a square expense. 

 

Thank you

2 replies

JessT
Moderator
March 12, 2020

Hi Mokadoka,

 

All your Square transactions will be downloaded in QBO, including the fees. Therefore, you won't need to creating anything in QBO. Just be sure that you have the correct mapping an account assignment, so the fees and the deposits will post correctly.

 

Your invoice will be paid in full, but you will have another transaction for the fee. Then, the net amount will be deposited into your bank account. All these transactions will be exported to QBO.

 

Please check out the article about syncing with Square. It explains about the setup, the things you need to do in QBO, and the mapping of transactions.

 

If you have additional questions, you can always go back to this thread.

April 2, 2021
JessT
  
QuickBooks Team
 
 
Reply to message

Hi Mokadoka,

 

All your Square transactions will be downloaded in QBO, including the fees. Therefore, you won't need to creating anything in QBO. Just be sure that you have the correct mapping an account assignment, so the fees and the deposits will post correctly.

 

Your invoice will be paid in full, but you will have another transaction for the fee. Then, the net amount will be deposited into your bank account. All these transactions will be exported to QBO.

 

Please check out the article about syncing with Square. It explains about the setup, the things you need to do in QBO, and the mapping of transactions.

 

If you have additional questions, you can always go back to this thread.

 

How does QBO know to make an invoice?  I am working on an issue for my client and i have never had to deal with Square APP.  

Sometime in January, this app stopped syncing with QBO.  Neither Square nor QBO will talk to me about it.  

All "invoices" have stopped being recorded.  No "payments" posted.

I truly am at a loss.

 

Any and all help is greatly appreciated.

 

Rustler
Level 15
March 12, 2020

@Mokadoka wrote:

Hi, I know there is an addon for square, but I want to know how I can propertly record an square transaction with an invoice.

 

Let says the invoice is 200$ and square takes 2% for processing fee. In total I get 196$ in my bank account. How I can resolve the gap? How I can say the 4$ is a square expense. 

 

Thank you


To answer your question directly

 

use a sales receipt, an invoice is used when the customer will pay later

 

create a non inventory item called sq fee and select the merchant fee expense account on the item

 

line one: list the sale and gross (full) amount

line two: list the sq fee item, qty is negative one, and the fee amount

save

September 7, 2020

This sounds great in theory - the way Square and Quickbooks deal with this is infuriating; it should just be an option in the reconcile window, where you select add/transfer etc.

 

Two things: one, if this is an immediate transaction, great, I will start recording them as sales receipts...however, I won't know the exact amount until I get my square payment, will I? What about rounding etc.

 

Two: can i go back and edit former transactions to turn them into sales receipts? I don't really want two forms of sales; I write invoices. Some may be paid immediately, some may not. I might email an invoice off to someone following, say, a remote transaction (remote computer support) and get a call back in 15 minutes for them to pay me. Or say they drop by with their card.

 

I may assume they're paying by cheque, then they produce a card. How do i convert an invoice previously written? 

The principle sounds good, but how will this work? This is a HORRIBLE SYSTEM. It should not be this hard.

 

DivinaMercy_N
Moderator
August 1, 2021

This is nice. But Square doesn't download invoices or synch to invoices.  It automatically downloads Sales Receipts, and I don't see an option of selecting sales receipts that are already in Qbooks for Square to match to.


Thanks for posting here, @tarabrown.

 

To help you match your downloaded sales receipt to an existing transaction in QuickBooks Online (QBO). Here are the steps you can perform:

 

  1. Navigate to the Banking/Transactions menu.
  2. Click the tile for the account you want to review.
  3. Select the For Review tab.
  4. Look for the sales receipt and click it to expand the view.
  5. Select the Find Match option.
  6. From the Match transactions page, review the records found in QuickBooks. This is the possible matching transaction you already entered in QuickBooks.
  7. Make sure this is the correct match. Check the Deposit toPayment method, and Bank account fields on forms for the existing transaction in QuickBooks.
  8. If this is the correct match, select Save.

 

For more info about this, please visit this article: Categorize and match online bank transactions in QuickBooks Online.

 

In case you're now ready to reconcile your transactions to guarantee that your bank balance and QBO are matched, check out this article for the detailed steps: Reconcile an account in QuickBooks Online

 

If you need more help about matching your sales receipt in QBO, you can always get back to this thread. Take care always.