cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Visit this post for a list of recent banking issues in QuickBooks Online.
fcharlip
Level 1

QBO syncing with Bigcommerce, square and braintree

We use Bigcommerce, square and Braintree and have all synced to QBO.  Square works beautifully as it syncs the invoice, fees, tax and deposits correctly.  Bigcommerce brings in the sale and sales tax correctly but deposits the sale amount into QBO and Braintree also deposits the sale into QBO without the 2.9% and transaction fee and shows that amount as a sale.  So, I am getting double sales and double deposits.  Sale amount is correct from Bigcommerce and deposit amount is correct from BrainTree.  How do I make this all work?

7 REPLIES 7
kmwolter
Level 1

QBO syncing with Bigcommerce, square and braintree

I have the same issue.  Have you found a resolution yet?  This is very frustrating.

 

Thanks!

Anonymous
Not applicable

QBO syncing with Bigcommerce, square and braintree

Hi fcharlip and kmwolter,

 

Thank you for contacting the Community.

 

Can I ask which version of QuickBooks are you using please?

 

Thanks, Carly. :)

kmwolter
Level 1

QBO syncing with Bigcommerce, square and braintree

QBO.

Anonymous
Not applicable

QBO syncing with Bigcommerce, square and braintree

Hi kmwolter,

 

Thank you for getting back in touch.

Are you using the UK or US version of QuickBooks Online?
 

Thanks, Carly. :)

kmwolter
Level 1

QBO syncing with Bigcommerce, square and braintree

USA QBO

AshH
QuickBooks Team

QBO syncing with Bigcommerce, square and braintree

Thanks kmwolter.

 

I'm just going to transfer you to our US team. Someone will be with your soon :)

MichelleT
Moderator

QBO syncing with Bigcommerce, square and braintree

Hi there, @fcharlip and @kmwolter,


Welcome to the QuickBooks Community. I’m happy to help resolve the double sales and duplicate deposits when synching transactions from Bigcommerce and Braintree.


When merchant deposits are automatically imported from the bank, you’ll need to match them with the existing invoice/payments in the program. Only adding them will create new sales in QBO, which can cause discrepancies with income.


Here’s how:


1.    Go to the Banking tab.
2.    Pick the account from the Bank and Credit Cards drop-down option.
3.    Locate and click the downloaded transactions, one at a time.
4.    Hit Find match.
5.    Set Show to All and enter the From and To dates.
6.    Choose the invoice or payment to match.
7.    Click Save.


You can find more information about how QuickBooks Online handles and analyzes the data from the bank in the Add and match downloaded banking transactions article.


With regard to the Braintree deposits without the fees, we can add new deposits. Let me walk you through the steps:


1.    Click the Create (+) menu.
2.    Choose Bank Deposit.
3.    Pick the bank.
4.    In the Add funds to this deposit, select the expense account you use for tracking bank fees.
5.    Enter the fee as a negative amount.
6.    Hit Save and close.


To learn more about this process, you can check out the Enter a bank service fee while using a third –party merchant service article.


That’s it. You can run the Profit and Loss report to ensure your income and expenses are correct.


I’ll be here if you need help with anything concerning QuickBooks. Wishing you continued success.

 

Need to get in touch?

Contact us