Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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?
I have the same issue. Have you found a resolution yet? This is very frustrating.
Thanks!
Hi fcharlip and kmwolter,
Thank you for contacting the Community.
Can I ask which version of QuickBooks are you using please?
Thanks, Carly. :)
QBO.
Hi kmwolter,
Thank you for getting back in touch.
Are you using the UK or US version of QuickBooks Online?
Thanks, Carly. :)
USA QBO
Thanks kmwolter.
I'm just going to transfer you to our US team. Someone will be with your soon :)
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.
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.