cancel
Showing results for 
Search instead for 
Did you mean: 
jaylor510
Level 1

Reconciling Bank Account After Shopify and Bold Commerce Integration

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

 

 

 

 

 

2 Comments 2
MaryLurleenM
Moderator

Reconciling Bank Account After Shopify and Bold Commerce Integration

Hello there, jaylor510,

 

You'll want to create a Bank Deposit so you can add the Shopify fees, here's how:

  1. Click + New on the left pane.
  2. Select Bank Deposit.
  3. From the Account drop-down menu, choose the account you want to deposit the money into.
  4. Select the box for each payment you want to combine.
  5. Select Save and close or Save and new.
  6. Scroll down to the “Add funds to this deposit” section.
  7. Enter the fee as a line item.
  8. Select who the fee was from. Then select Bank Charges from the Account drop-down menu.
  9. Enter the Shopify fee as a negative number. 
  10. Review the deposit total with the bank fee.
  11. Select Save and close or Save and new.

This will now match the amount on your sales receipt.

 

Let me know if there's anything else I can help you with.

jaylor510
Level 1

Reconciling Bank Account After Shopify and Bold Commerce Integration

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.

 

 

Need to get in touch?

Contact us