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?
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.
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...