Shopify / Paypal / eBay / Stripe - How would you navigate Quickbooks for this setup

megan53 · ‎November 25, 2021

We have Quickbooks setup to automatically sync transactions from our bank account.

However this does not:

* track sales

* track receipts

* track fees per sale

We've tried the Shopify Quickbooks integration, but the act of syncing sales duplicates our turnover. The reason being, automatch doesn't work due to the 1-2 day delay in receiving the payment, plus the price mismatch due to the fees taken by shopify.

We've tried using the Paypal integration, however this again duplicates the turnover rather than matches it.

As far as we can see, the only way to get an accurate picture of our accounts, is to manually enter the sales and the fees. Is that correct?

GebelAlainaM · ‎November 25, 2021

I'm happy to see you here in the Community, @megan53. I'll make sure that this issue gets sorted out today.

I also agree with you. You'll need to manually record the sales and fees to avoid duplicate transactions from Paypal. To do that, you can follow the steps below:

Scroll down to the Add funds to this deposit section.
Enter the fee as a line item.
Select who the fee was from (ex: the bank charging you).
Select Bank Charges from the Account ▼ dropdown.
Enter the amount fee as a negative number. For example, if the fee was GBP £ 50, enter –50.
Review the deposit total with the bank fee.
Select Save and close or Save and new.

Right after, ensure that the amount matches your bank's net income.

For further understanding on how to record and make bank deposits in QuickBooks Online, you can visit this article.

You'll also need to contact the third party app support to review the setup. Here's how to contact the Developer Support:

Go to Apps.intuit.com.
Type in the Paypal app in the search bar.
Select the Contact tab or the Support tab.

Please keep me posted in comment section if you need further assistance. I will be happy to guide you. Have a wonderful weekend!

View solution in original post

GebelAlainaM · ‎November 25, 2021

I'm happy to see you here in the Community, @megan53. I'll make sure that this issue gets sorted out today.

I also agree with you. You'll need to manually record the sales and fees to avoid duplicate transactions from Paypal. To do that, you can follow the steps below:

Scroll down to the Add funds to this deposit section.
Enter the fee as a line item.
Select who the fee was from (ex: the bank charging you).
Select Bank Charges from the Account ▼ dropdown.
Enter the amount fee as a negative number. For example, if the fee was GBP £ 50, enter –50.
Review the deposit total with the bank fee.
Select Save and close or Save and new.

Right after, ensure that the amount matches your bank's net income.

For further understanding on how to record and make bank deposits in QuickBooks Online, you can visit this article.

You'll also need to contact the third party app support to review the setup. Here's how to contact the Developer Support:

Go to Apps.intuit.com.
Type in the Paypal app in the search bar.
Select the Contact tab or the Support tab.

Please keep me posted in comment section if you need further assistance. I will be happy to guide you. Have a wonderful weekend!

Fiat Lux - ASIA · ‎November 26, 2021

@megan53

Explore these apps to reconcile your transactions and avoid any duplications

https://synder.grsm.io/quickbooks

https://www.a2xaccounting.com/ ---> use promo code FL_10_6MON_2021

Topics

Training

Community

Resources

Shopify / Paypal / eBay / Stripe - How would you navigate Quickbooks for this setup