Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowI recently installed Bold Commerce for Shopify integration into my Quickbooks Online. What is the best way to reconcile the bank account and Shopify account when exporting the sales data?
In my checking account for review it shows Shopify Transfer of $1479.85 categorized as Uncategorized Asset. This amount is after the Shopify fees have been deducted.
The Gross sale was $1439.10 plus $104.33 for tax equaling $1543.43. This is currently in the Sales Receipt categorized as Shopify Holdings.
Any help would be appreciated! TIA.
Hello there, jaylor510,
You'll want to create a Bank Deposit so you can add the Shopify fees, here's how:
This will now match the amount on your sales receipt.
Let me know if there's anything else I can help you with.
Thanks for the response. Do I need to re-categorize any of them?
In my checking account for review it shows Shopify Transfer categorized as Uncategorized Asset. Does this need to be re-categorized?
The Gross Sale is currently in the Sales Receipt categorized as Shopify Holdings. Do I need to re-categorize it to Undeposited Funds? When categorized as Shopify Holdings no transactions are listed when making a bank deposit. However, when categorized as an Undeposited Fund then this specific transaction is listed.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.