Shopify Payout Reconciliation in Webgility Desktop
Shopify Payouts:
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.
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 adjustments 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 is set up correctly.
Ensure record shipping and discount options are set.
Setup Instructions:
1. Configure order posting rule:
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.
2. Setup Invoice and 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.
3. Configure Expenses & Fees:
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.
4. Enable Partial Refund download:
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.
Download Shopify Payout:
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.
Two ways to download payouts on Webgility:
By Date Range.
By Payout ID.
1. Download Shopify Payout by Date Range:
Click on the Get Payouts dropdown and select By Range to download the payout in Webgility.
2. Download Shopify Payout by Payout ID:
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.
Post Shopify Payouts to QuickBooks:
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.
Shopify Payout Detail View in Webgility:
To see details of the payout, you will need to click on the details view icon in that particular row.
Archive all Settled Payout:
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.
Still facing issues and need help?