Book WooCommerce card payments to a clearing account
Your card gateway, such as Yoco or Stripe, pays out once a day in one deposit that covers several WooCommerce orders, less its fees. In Xero or QuickBooks, each of those orders is its own invoice, so one deposit never matches one invoice. A clearing account fixes this: order payments land there, and each payout moves from it to your bank as one transfer.
How it works
- SKU.io imports each WooCommerce order as a sales order and sends its invoice to Xero or QuickBooks.
- Once the order is paid, SKU.io records one payment on it for the order total, under the WooCommerce Payment payment type. The payment is dated on the order date and carries the sales order number as its reference.
- SKU.io sends that payment to your accounting provider against the order's invoice. The payment goes to the bank account that WooCommerce Payment is mapped to, which here is your clearing account.
- When the gateway pays out, the deposit arrives in your real bank account. You reconcile it as a transfer from the clearing account, and book the gateway's fees from the clearing account to a fees account.
After each payout is booked, the clearing account goes back to the payments still waiting for a payout.
Before you begin
- Your WooCommerce store is connected. See Connect WooCommerce.
- Xero or QuickBooks Online is connected, and your WooCommerce invoices sync to it. A payment only reaches your provider once its invoice is there. See Connect Xero.
- You need the Payment Types Edit permission (
payment_types.update) to save the mapping. To load bank accounts from your provider, you need the permission to sync integrations. - At least one WooCommerce order has imported. SKU.io adds the WooCommerce Payment type to your payment types the first time it imports WooCommerce orders.
Steps
Create the clearing account in your accounting provider
- In Xero, add a new bank account for the gateway, named for it, such as Yoco Clearing. In QuickBooks, add an account of the Bank type instead.
- Give the account an account code. SKU.io lists only bank accounts that have a code.
The clearing account has no bank feed. Only the payments SKU.io sends, the transfers and the fees move through it.
Map the WooCommerce Payment type to it
- In SKU.io, go to Apps & Integrations → Xero.
- Open the Payment Methods tab. The Payment Method Mappings card lists each payment type with a bank account picker.
- Click Load Bank Accounts to fetch your new clearing account from Xero.
- In the row for WooCommerce Payment, pick the clearing account, such as Yoco Clearing.
- Click Save. SKU.io confirms Payment method mappings saved.
In QuickBooks, open your QuickBooks connection and choose Mappings → Payment Methods, then follow the same steps. The button there is Save Changes. You can also set the account on Settings → General → Payment Types: click Set bank account on the WooCommerce Payment row. See Manage payment types.
Map the type before your next orders arrive. A payment whose type has no bank account doesn't sync to your provider, and its invoice stays unpaid there.
Reconcile each payout
- In your provider, open the bank account the gateway pays into, and find the payout's deposit line.
- Reconcile it as a transfer from the clearing account, for the amount deposited. In Xero, use the Transfer tab on the bank reconciliation line.
- In the clearing account, record the gateway's fees for that payout as money spent, to your bank fees or merchant fees expense account.
The gateway's payout report lists the orders and fees in each payout. After the transfer and the fees, the clearing account balance equals the payments the gateway hasn't paid out yet.
Things to know
- SKU.io doesn't read your gateway's payouts. It has no Yoco connection, and it doesn't import payouts from a WooCommerce card gateway. You book each payout and its fees yourself, as above. SKU.io creates payout deposits for you only for channels it gets a payout feed from, such as Shopify, Amazon and eBay.
- Every WooCommerce payment uses one payment type. SKU.io records WooCommerce Payment whichever gateway the shopper used. If your store takes cards through more than one gateway, their payments share one clearing account, and you reconcile each gateway's payouts from it.
- PayPal works the same way. A WooCommerce order paid with PayPal is also recorded under WooCommerce Payment, not PayPal Payment. If you connect PayPal to SKU.io, its nightly import lists these sales as Unmatched, and records refunds you make on paypal.com on the WooCommerce order. See How PayPal payments reach SKU.io.
- Orders before the sync start date stay in SKU.io. Payments dated before your provider connection's sync start date aren't sent.
- Unpaid orders get no payment. An order gets its payment once WooCommerce reports it paid. An order that already has a payment, such as one you recorded by hand, doesn't get a second one.
Next steps
- Sync payments with your accounting provider: check each payment's sync status on Accounting → Payments.
- Manage payment types
- How WooCommerce orders import