Skip to main content
K
kneill
December 30, 2020
Question

Wix sales sync in as deposits rather than sales receipts

  • December 30, 2020
  • 2 replies
  • 0 views

Our business does sales through Wix's webstore that allows customers to pay directly on Wix or to pay via PayPal. PayPal transactions come in individually and are automatically sorted as sales receipts that account for PayPal fees, so all is well there. For Wix, however, the import is different.

 

Wix gathers up the sales from a set period of time (every day, every week, etc.) and does a payout of the lump sum of payments. The Wix site provides an accounting of which sales are in the payout sum, but when the import happens to QBO, none of that info comes in. Nor do the payouts come in as sales receipts, they come in as a general deposit into the account. This is preventing Wix sales from appearing in the sales sections of reports, etc.

 

What is the appropriate way of handing the Wix sales/lump sum payouts? 

2 replies

Rustler
Rustler
December 30, 2020

The problem appears to be with the wix import, the assignment of the account.  Sales should post to income, talk to the wix support staff

K
kneillAuthor
December 30, 2020

I think I partially figured out the issue on my own. Wix itself doesn't transfer over sales receipts, just the lump sums. However, there is an add-on app that does. It is working smoothly now.

 

My only concern now is double-counting the sales in transactions on the banking section. The sales receipts are coming into QBO with deposit location set to the bank account. The bank account still does the aggregate-and-lump-sum payout thing from Wix. How do I ensure that these don't get double counted?

J
jamespaul
December 30, 2020

Hello, kneill.

 

You mentioned the transactions in the banking section. They don't actually post to your books until you've matched or added them. I have two options for you to handle your Wix and bank transactions. 

 

Since the bank account downloads a lump sum payout, all you have to do is to match it with the imported sales receipts (in the Banking page). This ensures your sales match exactly with the records in your bank account. Plus, these won't be double-counted. 

 

To match the lump sum amount: 

 

  1. Go to the Banking page.
  2. Find and select the downloaded lump sum transaction. 
  3. Click the Find match radio button.
  4. Check the sales receipts associated with the lump sum amount.
  5. Once done, click Save.

 

 

An alternative way is to just exclude the lump sum amount from the banking page. Then, manually clear the sales receipts from the Chart of Accounts. 

 

On the Banking page, check the lump sum transaction then click Exclude.

 

 

To clear the receipts: 

 

  1. Go to the Accounting, then click Chart of Accounts.
  2. Find the bank account, then click View register.
  3. Locate the sales receipt, then click the "check" column until a C appears. 
  4. Once done, click Save. 

 

 

You can take a look at this article for reference on handing bank transactions: Categorize and match online bank transactions in QuickBooks Online.

 

After dealing with the transactions, are you ready to reconcile your bank account? Read this article if you need help doing it: Reconcile an account in QuickBooks Online.

 

Ready to help you out again if you have more questions for QuickBooks Online. Just let me know the details in the comment section below. Take care out there. 

Terms & ConditionsAccessibility statement