The Shopify Payouts Reconciliation feature allows Webgility Desktop users to simplify the Shopify payout reconciliation process. You can post your Shopify orders as unpaid invoices.
When the payout is downloaded, a deposit for the total is placed and the orders that appear as paid in the payout, will also be marked as paid in QuickBooks. This allows you to easily find outstanding orders which have not yet received a payment from Shopify.
In order to use this feature, you must meet the following requirements:
Be a user of QuickBooks Pro, Premier, or Enterprise
Have payment processor fees and payout adjustment configured
Ensure that orders posted into QuickBooks are marked as paid invoices
Confirm the option Do not download refund is not selected.
Ensure the option to post refund settings are done correctly.
Ensure record shipping and discount options are set.
Set Up Instructions
1. Make sure both payment processor fees and payout adjustment are fully configured. This allows you to download and post your Shopify Payouts.
2. Make sure under Record Shopify payment processor fees in Bill (Paid) you use the same account that you deposit payments to, to make the invoice paid. In the below example under the Bill details, the Account is Shopify Clearing and the Payment date is Payout Date.
3. Shopify Payouts data includes all of the fees and revenue transactions related to orders. But there are a few fees and expenses, such as subscription fees, that are at the account level. Webgility also handles these fees.
5. If fees have a positive amount, Webgility will create the expense transaction as these fees are an expense to the business. If fees have a negative amount, Webgility will treat it as income and will create a bill credit/deposit.
6. Navigate to the Orders configuration section. Make sure the transaction type is set to Invoice, then click Setup. Also, select Create payment when posting payouts with payment data as payout date and Credit Memo. Then click Save & Continue.
7. Choose the correct option for each of the required fields. Then click Save to close the screen. Make sure to select Mark Invoice as Paid and and that it selects from the same account that you pay expenses and fees.
8. Under Credit Memo settings, be sure to select Create refund payment when Payout posted with payment date as Payout Date.
9. Once you setup the Shopify payout setup, you will be able navigate to Shopify > Payouts and see the option under the Orders menu.
10. There is one more option which needs to be enabled under store settings. In the instance that an item is damaged or unsellable you only pay a refund to the customer.
Navigate to Integration > Store > Settings and enable the option Get refund and record in.
11. Now that you have set up Shopify payout, you will be able to access it by navigating to Orders > Shopify > Payouts.
12. When you click on the Shopify Payout page, it will show you all downloaded payouts. If you don't see any, you can still download them.
13. If you want to download payouts, you can either download by date range or by payout ID. To find the payout ID, open that payout in Shopify and copy the ID from the URL.
14. To see details of the payout, you will need to click on the details view icon in that particular row.
15. In the details view, you can see how many charges, refunds, and fees are available under that payout in Shopify, Webgility, and your accounting system. If there are any mismatches, it will show in red. You can resolve them by clicking Resolve Mismatch. Once clicked, Webgility will allow you to download missing and partially downloaded orders and refunds.
16. Once you resolve any conflicts and download missing data, Webgility will show all amounts in black. This means that payouts are ready to post. You can post by selecting the payout and clicking Post to QuickBooks. Once that pop-up is opened, it will check all missing and conflicting data, download missing data, resolve any conflicts, and post transactions in payouts.
17. Payouts will then move to Posted and you can mark them as settled.
18. Now that this feature is set up, you can post your orders as you normally would. When you download payouts and post them to QuickBooks, all orders that are paid on the payout deposit will show as paid on the invoice, and the deposit will show in the account register. The total should match what Shopify payout deposited into the bank account.
Archive all Settled Payout's
1. To archive settled payouts you will need to click on the archive icon for that particular payout row. Once you click on it, the payout will move to archive. If you want to see archived payouts you need to click on the View Repository.
2. Once you open the repository it will open all of your archived payouts. If you don't have any archived payouts, then this will not be visible to you. You can also unarchive your archived payouts from this page by clicking Move to Payouts.