Add a second bank account in Xero called WorkPaid, and once a month import WorkPaid's "WorkPaid account for Xero, QuickBooks or Sage" file into it. Your card and bank payments go in, our fees and each payout to your bank go out, and the account comes back to zero once everything has reached your bank. Nothing gets counted twice next to your bank feed.
Why a separate account
When a customer pays through WorkPaid, the money doesn't go straight to your bank. Stripe, our payments partner, takes the payment, our fee and the processing come off, and the rest is paid out to your bank, sometimes several payments in one go. Your bank feed in Xero only ever sees those payouts.
The WorkPaid account holds the full picture: what the customer paid, the fees, and the payout. Each payout then shows up twice, once leaving the WorkPaid account and once arriving in your main account, and you reconcile it as a transfer between your own accounts.
Cash and bank-transfer jobs aren't in the file. They're in your bank already, so you reconcile them there like any other payment.
1. Add the WorkPaid account in Xero
- In the Accounting menu, select Bank accounts, then Add bank account.
- WorkPaid isn't a bank with a feed, so click Add without bank feed at the top right, then Continue, then Add account details.
- Enter WorkPaid as the bank name and the account name, and choose Other as the account type.
- Xero asks for an account number. There isn't one, so type something you'll recognise, like WORKPAID. Leave the currency as British Pound.
- Click Add, then Finish adding accounts.
Xero's own help: Add a bank account or credit card account.
2. Download the file from WorkPaid
- In WorkPaid, open Earnings and choose Export CSV.
- Pick WorkPaid account for Xero, QuickBooks or Sage.
- Pick the dates. A whole month is easiest, say 1 to 31 October. Start each new file the day after the last one ended, so nothing is missed or imported twice.
- Choose Download CSV.
3. Import it into the WorkPaid account
- In the Accounting menu, select Bank accounts. On the WorkPaid account, click Import a bank statement (once it has transactions, it's in the account's menu as Import a Statement).
- Choose Select file, pick the file you downloaded, then Next.
- Xero matches the columns itself: Date to Transaction Date, Amount to Transaction Amount and Description to Description, and leaves out the heading line. Check them, then Next. If it asks for the date format, choose dd/mm/yyyy.
- Check the lines, then click Complete import.
Xero tells you how many lines it imported, and skips any it already has. The account's Statement Balance should then read 0.00 once everything's been paid out. Xero's help: Import a bank statement in CSV format.
4. Reconcile the lines
On the WorkPaid account, click Reconcile. Each line says what it is:
- "WorkPaid: Sarah Mitchell - Bathroom refit (Deposit)" and the like: a payment from your customer. If you also import WorkPaid's Xero invoices file, use Match to tie each payment to its invoice. If you don't, use Create to record it as money received into your sales account. Do one or the other, not both, or the sale is counted twice.
- "WorkPaid fee", "Card processing", "Pay by Bank processing" and "Instant Payout fee": our fee and the cost of taking the payment. Use Create to record each as money spent. They're business costs; check with your accountant which account they'd like, such as bank fees.
- "payout to your bank" or "Instant Payout to your bank": money we sent to your bank. Select the Transfer tab, choose your main bank account, then OK. When the same payout comes into your main account, reconcile that side too, against the transfer. Xero's help: Transfer money between your bank accounts.
- A refund or chargeback (money out, ending "(Refund)" or "(Chargeback)"): ask your accountant how they'd like it recorded.
If you're VAT registered, each payment line is the full amount the customer paid, VAT included. Our fees have no VAT on them, because WorkPaid isn't VAT registered.
Check it adds up
Once your payouts have reached your bank, the WorkPaid account's balance in Xero should match what WorkPaid's Payments page shows as still with Stripe or on its way to you. Most of the time, that's zero.
Rather not do it yourself?
Send your accountant the Full earnings ledger from the same Export CSV window, with a link to our tax guide. It has every payment and every fee in one file.
One file to avoid if Xero has your bank feed: Every payment, Xero, QuickBooks or Sage layout. It lists cash and bank-transfer jobs too, so they'd be counted twice.