Shopify Payout Reconciliation in Webgility Desktop

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. The orders that appear as paid in the payout will also be marked as paid in QuickBooks. This allows you to find outstanding orders that have not yet received a payment from Shopify.

Navigate to Integrations> Accounting POS/ERP> Posting Settings> Orders. Make sure the transaction type is set to Invoice. Select Create Payment when posting payouts with payment data as payout date and select Credit Memo.

Click Setup next to the Invoice dropdown. Choose the correct option for each of the required fields. In the deposit field, you can select the Shopify Clearing account if you have created one for Shopify sales, then click Save to close the screen. Make sure to select Mark Invoice as Paid and that it selects from the same account that you pay expenses and fees.

Under Credit Memo settings, be sure to select Create Refund Payment when Payout is posted with the payment date as Payout Date.

Make sure both the payment processor fees and payout adjustments are fully configured. This allows you to download and post your Shopify Payouts.

Make sure to record Shopify payment processor fees as a Check. You should use the same account you deposit payments into so it can make the invoice paid.

In the example below, under the Check details, the account is Shopify Clearing and the Check Date is the Payout Date.

Inside the Download Payout setup, download the Shopify payout and record it as a Check/deposit. Use the same account that is used in depositing payments, to make the invoice paid.

In the below example under the Check/deposit details, the Account is Shopify Clearing and the Check date is the Payout Date. Use an Expense for the type of account in QuickBooks to record the fees.

Note: Shopify Payouts data includes all of the fees, revenue, and 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.

If fees have a positive amount, Webgility will create an expense transaction as these fees are an expense to the business. If fees have a negative amount, Webgility will treat it as income and create a bill credit/deposit.

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.

Navigate to Orders> Shopify> Payouts to download the Shopify Payouts in Webgility.

When you click on the Shopify Payout page, it will show you all the downloaded payouts. If you don't see any, you can still download them.

Click on the Get Payouts dropdown and select By Range to download the payout in Webgility.

Click on the Get Payouts dropdown and select By ID to download the payout by Payout ID. To find the Payout ID, open that payout in Shopify and copy the ID from the URL.

You can post by selecting Payout and clicking Post to QuickBooks. Once the posting pop-up is opened, it will check all missing and conflicting data, download missing data, resolve any conflicts, and post transactions in payouts.

Payouts will then move to Posted, and you can mark them as settled.

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 the Shopify payout deposited into the bank account.

To see details of the payout, you will need to click on the details view icon in that particular row.

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 the archive. If you want to see archived payouts you need to click on View Repository.

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.