cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
SlabSentinel
Level 1

Woo Commerce Double Accounting Sales?

Hi!

New to this, so please be kind!

I am using Quickbooks for a small ltd company of E-commerce sales using WooCommerce (Wordpress) as the platform.

 

This allows for Debit/Credit Card Payments and I allow PayPal.

 

For that reason, I sync a Bank Account and PayPal account in Quickbooks.

It appears easy days I must have integrated the WooCommerce site too....

 

It appears to be essentially 'double accounting' the sales in that i have a huge backlog of 'debtors' with invoices to be paid if they paid via Card payment, however this revenue is also accounted for in the Company Bank Account (as it deposits weekly for example). 

 

This is essentially causing 2x revenue

 

I have clicked on 'receive payment' in the invoice section of quickbooks, and that reduces the 'Debtors' but also increases the 'bank account' on my balance sheet, and does not reduce my 'sales' on my P&L, thus it is still there twice?

In addition to that, the deposits from WooCommerce Sales to Bank Account already deduct the WooCommerce Fees so no 'expense' to record? 

 

Any advice on what to do?

Trying to get my first year of books in order before discussing with an accountant (i like to self serve as much as possible and this is a very simple business purely buying stock and selling, so i thought the book keeping i should learn!)

 

5 REPLIES 5
Jovychris_A
Moderator

Woo Commerce Double Accounting Sales?

Thank you for choosing QuickBooks for your accounting needs, @SlabSentinel.

 

Usually, if you have connected your bank account and PayPal to QuickBooks, you can match your bank feeds directly to invoices that you created in QuickBooks. This way, it will prevent double accounting for your sales. When you haven't paired the received payments or created invoices in the system to your bank feed deposits, this is the reason it will double account sales.

 

When receiving payments, this will reduce the debtor's account normally while it increases your bank account. If you're receiving payments in QuickBooks and directly deposit them to your bank or PayPal account and at the same time have not matched them to payment record, this will create a duplicate revenue. You can consider excluding the bank transaction.

 

In addition, when your bank receives weekly deposits, those deposits can match multiple invoices. From your Banking window's For review tab, I suggest clicking the deposit transaction and then choose Find match. From there, you can either pick the invoices/payments manually or enable the Suggested Matches to select groups of QuickBooks income transactions. To learn more, check this article: Categorise and match online bank transactions in QuickBooks Online.

Alternatively, you can utilize the receive payment feature and deposit them into the Undeposited Funds (clearing account) account to hold funds and in QuickBooks, then link them by creating a bank deposit. This way, matching the weekly bank feed deposit transactions to QuickBooks deposits will be easy. Take a peek at this article: Deposit payments into the Undeposited Funds account in QuickBooks Online.

 


On the other hand, so when your WooCommerce already deducted their fees before depositing to your bank, these fees can be added as a category when you create a bank deposit in QuickBooks. Please make sure to put a negative sign on the amount to deduct the total value of the payment received so it will match the bank feed deposit. Take a look at the payment total below and how it works when adding those WooCommerce fees as a category:

 

 

 

Moreover, once you're all good, you can refer to this article on how to show your targets and sources to reflect efficiently on a report: Customise reports in QuickBooks Online.

 

To summarize everything, your bank transactions should match any transactions you created in QuickBooks. If you recognize that those bank feeds entries can't be found in the system, you can add or categorize them to show them in your bank register. So technically, when you record a Receive payment, QuickBooks will eventually match a bank transaction.

 

 

I'm still here, and please let me know if you have other banking concerns. I'll be around to help. Have a great day!

Fiat Lux - ASIA
Level 15

Woo Commerce Double Accounting Sales?

@SlabSentinel 

Consider having a 3rd party connector to reconcile your WooCommerce transactions and avoid duplication from payment processors.

 

SlabSentinel
Level 1

Woo Commerce Double Accounting Sales?

Thank you for the comprehensive breakdown. 

 

I will look at this in detail soon and message if i require further assistance.

 

Thanks!

SlabSentinel
Level 1

Woo Commerce Double Accounting Sales?

Could i just do a yearly reconcile and state =0 at the end of the year for the Debtors Account? Or is this completely incorrect practice. 

The issue i see is the Woo Commerce Sales which become unpaid invoices, are the full value.

The Bank Deposit is the value less fees, and many sales aggregated into one deposit. So would be a nightmare trying to link each sale less fees to a certain bank deposit?

 

 

SlabSentinel
Level 1

Woo Commerce Double Accounting Sales?

Thank you for the comprehensive breakdown. 

 

I will look at this in detail soon and message if i require further assistance.

 

Thanks!

Need to get in touch?

Contact us