Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowOur 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?
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
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?
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:
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:
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.
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.
Explore this connector for Wix to create the sales receipt on QBO.
https://www.integromat.com/?pc=quickbooks
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.