cancel
Showing results for 
Search instead for 
Did you mean: 
kneill
Level 1

Wix sales sync in as deposits rather than sales receipts

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? 

5 Comments 5
Rustler
Level 15

Wix sales sync in as deposits rather than sales receipts

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

kneill
Level 1

Wix sales sync in as deposits rather than sales receipts

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?

jamespaul
Moderator

Wix sales sync in as deposits rather than sales receipts

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.

 

lumpsum1.PNG

lumpsum2.PNG

 

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.

 

lumpsum3.PNG

 

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

 

lumpsum4.PNG

 

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. 

murraylamb
Level 1

Wix sales sync in as deposits rather than sales receipts

i am experiencing the same issue. what is the app and how did you end up reconciling the double issue? thanks so much for your help.

 

Fiat Lux - ASIA
Level 15

Wix sales sync in as deposits rather than sales receipts

@murraylamb 

Explore this connector for Wix to create the sales receipt on QBO.

https://www.integromat.com/?pc=quickbooks

 

Need to get in touch?

Contact us