Add a second bank account in QuickBooks called WorkPaid, and once a month upload WorkPaid's "WorkPaid account for Xero, QuickBooks or Sage" file to 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 QuickBooks 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 post 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 post them there like any other payment.
1. 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 uploaded twice.
- Choose Download CSV.
2. Upload it to a WorkPaid account in QuickBooks
- In QuickBooks, go to Accounting, then Bank transactions. Click the arrow next to Link account and choose Upload from file. (If you haven't added any bank accounts yet, there's an Upload transactions button instead.)
- Under Select account, the first time, choose + Add new. Call it WorkPaid, choose Cash at bank and in hand as the account type and Current as the detail type, leave the opening balance empty, and choose Save. If you took payments through WorkPaid before you started with QuickBooks, ask your accountant what opening balance to use. Next month, just pick WorkPaid from the list.
- Choose Upload from this device and pick the file you downloaded. Check QuickBooks says the transactions are from the WorkPaid account, then Continue.
- QuickBooks fills in the file's layout itself: the first row is a header, amounts are in one column, the date format is dd/MM/yyyy, and Date, Description and Amount are matched to the right columns. Check them, then Continue.
- Leave Keep original values selected: payments in are positive and fees and payouts out are negative. Tick the box at the top of the list to select every line, choose Continue, then Yes, then Done.
Intuit's own help: Import bank transactions using Excel CSV files.
3. Post the lines
The lines wait under Pending on the WorkPaid account. QuickBooks suggests a category for each one. Don't post them as they are: check each suggestion first, because on our test it guessed some customer payments as costs. Click a line to open it, set it as below, then choose Post.
- "WorkPaid: Sarah Mitchell - Bathroom refit (Deposit)" and the like: a payment from your customer. Choose your sales account, such as Sales or Services. If QuickBooks has picked a cost, like Purchases or Office expenses, change it, or the payment comes off your profit instead of adding to it. If you also raised the invoice in QuickBooks, use Match to tie the payment to it instead, so the sale isn't counted twice.
- "WorkPaid fee", "Card processing", "Pay by Bank processing" and "Instant Payout fee": our fee and the cost of taking the payment. They're business costs. QuickBooks usually suggests Bank charges or Credit card charges; if it says Uncategorised Income, change it. Check with your accountant which account they'd like.
- "payout to your bank" or "Instant Payout to your bank": money we sent to your bank. Set the transaction type to Transfer and choose your main bank account, then Post. When the same payout comes into your main account through its feed, match it to that transfer rather than adding it again. Intuit's help: Transfer funds between accounts.
- A refund or chargeback (money out, ending "(Refund)" or "(Chargeback)"): ask your accountant how they'd like it recorded.
To save doing this every month, open a line and choose Create rule, and QuickBooks will set lines like it the same way next time. Intuit's help: Categorise and match online bank transactions.
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 every line is posted and your payouts have reached your bank, the WorkPaid account's balance in QuickBooks 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.
We checked these steps on QuickBooks Sole Trader Plus. The bigger plans, from Simple Start up, use the same upload, though some menu names can look a little different.
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 QuickBooks 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.