Quickbooks and shopify

[Easthillsupply]

Quick question, i track my sales offline with quickbooks and i was wondering what i should do about my shopify store sales? I dont want to log a sale in quickbooks every time someone buys a 2$ product... but i would imagine this has to be done for taxes? How does this work?

or can i put shopify in as a one customer and put all those sales under that?

[AlanaBryantCPA]

A2X Accounting is a good solution. It posts summarized data

Thanks,
Alana Bryant, CPA

[Easthillsupply]

not sure i understand, im not looking for different software im just curious how people are keeping track of their sales and taxes to stay legit with their llc using shopify and quickbooks

[swheeler]

Hi EastHillSupply,  Check out the the CartSpan integration for Shopify and the Premium, Pro, and Enterprise versions of QuickBooks Desktop.  CartSpan allows you to direct all orders to a common customer if desired and will direct your taxes collected to an appropriate tax code based upon the ship-to state.  You can then use Shopify reports to manage the specific remittances.

[Petbizgirl]

I enter my monthly sales in Quickbooks. I run a sales report for the month and then enter the total sales under a line that says "Monthly Shopify Sales." Some of mine are subject to different tax rates based on delivery location, so I have to enter a separate line for each tax rate (usually just two). Keep in mind that you'll also need to run a monthly payout report and total up/add in the transaction fees.

It seems like you can also export your sales to a spreadsheet and then upload them to QB. I'm not advanced enough with QB to do that, though...