Skip to main content
January 18, 2018
Solved

Credit Card payments from 3rd party(Square)

  • January 18, 2018
  • 1 reply
  • 0 views

How do I book my credit card transactions into QuickBooks from a 3rd party  - showing the customer paid invoice in full. Though 3% of sale is CC fee . So sale is actually minus 3% which needs to be expensed..

    Best answer by Dsimm54057

     Thank you for your response. Yes I understand that. That is why I don’t know what to do with the difference of what I originally invoice the customer versus what I actually collect on the invoice because this will be 3% or so less because of the Square fee. How do I in QuickBooks reflect that the invoice is paid in full even though it’s 3% short? I have to write this difference off somewhere  I assume. I just didn’t know how to do it it’s a quickbook/accounting question.

     

     

     

     

     

     


    I solved this by  not having Square do the automatic bank deposit. I turned this feature off. The money is then in my 'undeposited funds' account.  At the time of the credit card deposit to the bank, I simply choose the deposit(s )that are reflected in the deposit, then add another line to the deposit using 'square service charge ' (expense account) and a negative amount equal to the actual deposit dollar amount sent to my bank. 

     

    That way square will show the invoice as paid (example $100 charge and $100 square payment) and the bank deposit will also match (example $100 charge, $100 less $2.00 fee recorded on bank deposit  = $98.00 deposit which matches the bank deposit)

     

    There is no way to have this automatically happen. Either the invoice will show the fee as unpaid (in which case you can record an additional payment in the aomount of the fee for the invoice as  a 'square service charge expense 'account to clear it).  I tried this and it works and tracks but takes more time than just doing a manual deposit.  You would need to manually apply an additional payment for the fee to each invoice.  Every time. 

    1 reply

    January 18, 2018

    I'd love to know too. I use Square as my point of Sale for CC but would like to invoice etc. through Quickbooks. I set up the Square/Quickbooks Sync App and received my first payment last night. In Quickbooks, the payment shows up as a separate paid invoice and if I were to mark the Quickbooks invoice as paid, my account would register as if I had been paid twice for the same invoice. I would like to know how to take that payment in Square and apply it against an invoice in Quickbooks so that they are reconciled and the payment matched with the correct invoice. 

    January 18, 2018

    Hi Kallison and NorFrame,

     

    The QuickBooks Online Square app only gives you the option to have those sales come over as a new transaction, so you're not able to match it to an existing invoice. That app also does bring over refunds, taxes, tips, and discounts. You could manually export a CSV from Square and manually import it into QBO, or you could link the bank account that those deposits are sent to. I hope that gives you the info that you're looking for. Let me know if you have more questions. 

    January 18, 2018

    Thanks Dwayne, I only use Square for credit card processing. If I am invoicing through Quickbooks and managing the rest of our finances through there, is the only way to reconcile without having to manually monitor transactions to use Quickbooks for credit card processing. We have just invested in a number of pieces of Square hardware and am hoping not to have to switch CC processing. Thanks