Add a second bank account in Sage 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 Sage 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 mark both as a transfer so they don't count as income or costs.
Cash and bank-transfer jobs aren't in the file. They're in your bank already, so you sort them there like any other payment.
Before you start: stop Sage completing lines for you
Sage's Copilot guesses a category for each imported line and, by default, moves the ones it's confident about straight to Completed, where they count towards your Making Tax Digital totals. On our test it filed most of the lines that way, and got several wrong: customer payments as non-business money, and our fees as transfers. To check the lines before they count, go to Settings, then Transaction settings, and switch off Complete transactions when a category is predicted. Copilot still suggests categories; the lines just wait in Draft for you.
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 imported twice.
- Choose Download CSV.
2. Add the WorkPaid account in Sage
- Go to Banking and choose Add account.
- Choose Bank account as the account type. Not Cash: Sage can't import a statement into a cash account, and you can't change the type later.
- Call it WorkPaid. Leave the sort code, account number and bank name empty.
- Choose Save, not Save and connect to bank. When Sage offers an opening balance, choose Close. If you took payments through WorkPaid before you started with Sage, ask your accountant what opening balance to use.
The free Sage Sole Trader plan allows this: its one-account limit is for bank feeds, not accounts you import into.
3. Import the file
- In Banking, on the WorkPaid account, open Actions and choose Import from bank statement. Check the account says WorkPaid, then Next.
- Choose Select a file from your device, pick the file you downloaded, then Review transactions.
- Sage asks how the dates are written. Choose Day month year, then Continue.
- Check the list: payments to you are Money in, our fees and the payouts are Money out. Then Confirm import.
Sage reads the file's Date, Description and Amount columns by their headings, so there's nothing to match up. The Open file import guide button on the upload screen has Sage's rules for the file.
4. Check every line
Go to Transactions and look at Draft, and at Completed too if you left Sage completing lines for you. To change one, open it, pick the right category and save it. Each line says what it is:
- "WorkPaid: Sarah Mitchell - Bathroom refit (Deposit)" and the like: a payment from your customer. Category: Turnover. If Sage has put Non-business money in, change it, or the payment is left out of your income.
- "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, such as Bank, credit card and other finance costs; check with your accountant. If Sage has put one in Non-business money out, change it, or you miss the cost. If it has made one a transfer, Sage won't let you change the category: delete that line, then use Add a transaction, Money out, Expense to put it back on the WorkPaid account with the same date, description and amount.
- "payout to your bank" or "Instant Payout to your bank": money we sent to your bank. Category: Bank, credit card or cash transfer. When the same payout comes into your main bank account, give it that category there too. Transfers don't count as income or costs, so the money isn't counted twice.
- 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
Sage's account total only counts completed lines, so finish the Draft ones first. Then, once your payouts have reached your bank, the WorkPaid account's total in Sage 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 Sage Sole Trader's free plan. Sage Accounting (Start, Standard and Plus) also takes CSV statements, but its screens are 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 Sage 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.