Shopify & Quickbooks Keeping track of transactions

I can share some information about connecting Webgility to QuickBooks Online, @loyaltco.
 
The way transactions import into the system will depend on the setup of your third-party app. If there are configurations that you need to make on how it syncs, I suggest contacting the Webgility Support Team. Other applications that integrate with QuickBooks is set up to import transactions or finding a match with QuickBooks records.

Since the data is coming from them, it's best to configure the app with their help. You can visit this link: https://help.webgility.com/s/. Also, you can check its Overview to see the full contact details. This way, we can make each account register balanced.

In case there are transactions you need to enter manually, visit the following articles for your reference:

• Create and send a sales receipt.
• Should I use an invoice or a sales receipt?.

If you have additional questions, feel free to swing by and place a comment. I'm always here to help. Have a safe day ahead, loyaltco.

Thanks for the reply! Its not getting the transactions over, I already did that. Its making sure my accounting matches with the transactions from my bank as I mentioned in my post.

Example: Sale in shopify, webgility syncs single sale and imports transaction into Quickbooks. Transaction is added to my "Shopify Balance" register as In Quickbooks.

The money from the sale is then deposited into my business checking register as "Shopify"

Do I want to record these as transfers from shopify balance register to business checking? I cannot match since they are on 2 different registers. OR should I be importing the transaction into my business checking and matching that transaction to the shopify deposit?

I'm here to help ensure you're able to match your Shopify transactions in QuickBooks Online, loyaltco.

Since the statements are on different registers, you can record the transactions as transfers from Shopify balance to business checking, or you can exclude them and import them to your checking account.

Here's how to exclude the transactions:

1. Click Transactions in the left panel and choose Banking.
   
2. In the For Review tab, select the imported transactions.
3. Tap on the Exclude button.
   
4. Go to the Excluded tab, select the transactions.
5. Hit the Delete button.
   

After that, you can follow the steps in this article to re-import the transactions into your checking account: Manually upload transactions into QuickBooks Online.

Once imported, I recommend editing, assigning, and categorizing your transactions. Also, you can match them to the existing entries in the software. Just go to the For Review tab from the Banking menu. Doing so will help you ensure the accuracy of your financial records.

Kindly update me on how things go by adding another comment here. I want to make sure you're all able to match your transactions, and I'm here if you need further guidance. Have a great day!

@loyaltco 

Explore this connector to reconcile your Shopify transactions. Did you encounter the same issue with WG?

https:// synder.grsm.io/quickbooks