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
  • 11 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.

 

Level 8
March 2, 2021

Hi RenjolynC,

 

Excellent advice and thanks for the detailed explanation! I have a few questions that I hope you can address.

I am in the process of helping a client sort out square payment issues similar to what you previously advised. At this point, we haven't set-up the Square app yet.

 

The following article has prompted some questions and concerns on our end: https://quickbooks.intuit.com/learn-support/en-us/mobile-and-apps/sync-with-square-default-accounts-and-names/00/185452

 

Specifically, when it comes to the square payments automatically mapping to a "Square Customer". If Square payments from the app automatically sync to a Square Customer, what's the easiest way to apply the payment accordingly to the correct customer? 

 

Thank you very much for your insight. 


Good afternoon, @tiffpc1100

 

Thanks for joining in on this thread. I hope your day is going well so far. 

 

I appreciate you coming to the Community with your question. However, we aren't able to answer them due to them being associated more with Square. We only assist with information that's in your QuickBooks Online (QBO) account. 

 

I recommend contacting Square to see what steps need to be taken for this situation. You can also check out our tutorials page to view other available features in your account that may help your business. 

 

Let me know if you have any other questions. I want to make sure all of your concerns are addressed. I'm only a few clicks away if you need me. Have a wonderful day!