What accounting software syncs best with Square POS?

[scottlyttle530]

We currently use QBO for our accounting, but the sync with Square is a pain. I'm looking for a straightforward accounting software that will provide P&L, balance sheet, and cash flow. Any suggestions?

[AshleyK]

Hi, there! Thanks for starting this thread. I personally see a lot of sellers use Quickbooks to integrate with Square, but we have a lot of accounting and tax app partners that you can look at to see what is the best fit for your business. Check it out in our app marketplace when you have a chance.

I'm also going to tag a few of our Super Sellers to see what programs they have used and loved. 🙂

@bagelboss @Donnie-M @HC_Charlie @homeprogreen @GourmetOnWheels @jjgard @MAXSDELI @pieous @ryanwanner @sugarlab

[LillyFace]

Hi. I am wondering how everyone does their accounting for the fees.  The sale is recorded as NET on the bank statement.  Historically, the gross amount appeared on the statement, and a separate expense would be classified as "Bank Service Charges".  This created a means for the expense to be deducted from earnings to depict the cost of doing business.  

With the income (amount on statement) shown as NET, how does everyone show the COST of doing business vis-a-vis the expense incurred but invisible on the bank statement?

[homeprogreen]

The best option I have found is using QuickBooks online and commercesync from the Square App Store. CommerceSync runs 19 a month but it automatically does a sync between Square & QuickBooks every day that puts all of your sales, fees and any Sales Taxes in the proper spots in QuickBooks so you have a very accurate report. Saves me hours every week in accounting work. The reason that I use QuickBooks Online with this combination instead of the desktop version is that I was able to set it so that it automatically downloads & imports the bank transactions and marks each day’s Square sales as paid

[James_Grubuzzer]

We use Quick Books pro with commerce sync to move the data from Square. Has been working well for us.

[HC_Charlie · Accepted solution]

I use Quickbooks 2019 for Mac on my laptop. In the past I've used Quickbooks online, but tired of the subscription model and then my Accountant advise using the desktop version instead of online to better give them reports. I thought about using an integration App but worried about messing up my books in the sync. I finally figured out the last thing I needed to do thanks to the great Community Members on here! 

I take my reports from Square that tell me daily sales information, and use that to fill out a Daily sales receipt in Quickbooks. If you need to track specific categories (rather than a bulk daily figure) it might get tricky, but not impossible. Good luck to you!

[LL_Wondrous]

Hey there!

I've been doing a lot of digging into this matter as well and was really excited to find your work around with creating a daily sales receipt in Quickbooks. Did you follow these instructions to set that all up on the Quickbooks side? I'm trying to get everything set up as much as possible before we start taking payments and would like to avoid the sync with Square app if I am able. Would love to hear back from you if you did a different sort of work around! Cheers!

[homeprogreen]

Personally I have found that using QuickBooks for accounting is best solution. Little overkill for most small businesses but the bank feed alone is worth the cost. The QuickBooks/ Square integration really isn’t very good but I have found that using Commercesnyc from the Square App Store really makes it simple and accurate. It creates sales invoice and then once a day imports all the sales, fees, sales taxes, etc and enters the information into the correct journal lines in QuickBooks. Saves me probably a full day every week on bookkeeping chores