Skip to content

Settings, Integrations5 min read

Bringing In Payments from Xero

Keep your books in Xero and only bring in the payments you match there: how a customer's bank payment reaches their account in Work Planner, and what happens when no customer matches.

If you keep your books in Xero, Work Planner can leave Xero alone and only bring in the payments you match to your customers there. Nothing goes to Xero, and your customers' balances in Work Planner stay right without typing their payments in twice. Here's the whole journey for one £10 window clean.

Work PlannerYour jobs and customer accounts
XeroYour books and bank reconciliation
Your bankWhere the customer’s money lands
Work PlannerMonday, 2:10pm
1You mark the job complete
A £10 charge goes on the customer’s account. Nothing is sent to Xero.
Window clean£10.00
Balance£10.00 owed
LaterThe customer pays
Your bankWednesday
2The customer pays you £10
By bank transfer, into an account you chose in Settings › Xero.
J TAYLORFaster Payment+£10.00
Xero’s bank feedbrings the £10 in
XeroWednesday, 9:05am
3You match it to Mrs Taylor
On Xero’s Reconcile screen: to an invoice you raised in Xero, or as money received, such as by a bank rule.
J TAYLORBank line£10.00
Matched toMrs Taylor
StatusReconciled
Within 15 minutesWork Planner brings the payment in
Work PlannerWednesday, by 9:20am
4It finds the customer
By the Xero contact’s email, then their account number against your customers’ references, then their exact name. It remembers the match.
Xero contactMrs Taylor
Matched byEmail
CustomerMrs J Taylor
Work PlannerStraight after
5Their account is settled
A “Payment from Xero” pays what they’ve owed longest first, recorded as the payment method you chose.
Window clean£10.00
Payment from Xero−£10.00
Balance£0.00
Work PlannerInstead of step 5
!If no customer matches
Such as a Xero contact with no email, or an email two customers share. It waits on the To match tab, and the bell says so. Choose who it’s from once, and their payments go to that customer from then on. Leave out anything that isn’t a customer paying, such as a card provider’s payout.
J HENDERSONTo match£22.50
Choose customerLeave out
Bell1 payment needs matching
Days and times are an example. Work Planner looks in Xero every 15 minutes, or straight away with Sync now, and only brings in payments into the bank accounts you chose.

Completing the Job

Marking the job complete, such as on the worksheet, records a £10 charge on the customer's account, and their balance shows they owe it. With Only bring in payments chosen, nothing goes to Xero: not the customer, the charge, an invoice or cash taken on the day.

The Customer Pays

The customer pays the £10 by bank transfer into one of the bank accounts you chose under Bank accounts on the Settings tab. Xero's bank feed brings the payment in, and it waits on Xero's Reconcile screen for you. Payments into other bank accounts don't come in, so card and Direct Debit payments you take in Work Planner aren't counted twice.

Matching It in Xero

On the Reconcile screen, match the £10 to the customer's contact in Xero. It can pay an invoice you raised in Xero, or go in as money received, such as with a bank rule that spots their reference. Either way, Work Planner only needs it to be against their contact.

Back in Work Planner

Work Planner looks in Xero every 15 minutes, or straight away when you click Sync now at the bottom of the Settings tab of Settings > Connections > Xero. For each new payment, it works out which customer the Xero contact is: by their email, then their account number against your customers' references, then their exact name, as long as only one customer has it. It remembers the match from then on.

It then records a Payment from Xero on the date it was paid in Xero, with Xero's reference and the payment method you chose in Record them as. It pays what the customer has owed longest first, with anything more as credit, and no fee is added. The customer's balance comes down to £0.00.

A payment changed in Xero is taken out of Work Planner and recorded again, and one deleted in Xero is taken out of Work Planner. Each one shows on the Logs tab, with who it went to and how they were matched, and Change customer moves one to someone else.

If No Customer Matches

Sometimes Work Planner can't tell who a payment is from, such as when the Xero contact has no email, or two customers share it. The payment waits on the To match tab, which shows how many are waiting, and the notifications bell says 1 payment needs matching to a customer. Match it in Settings › Xero › To match.

  • Choose customer: Records it against the customer you pick. Payments from that contact go to them from now on, without asking again.
  • Leave out: Leaves out a payment that isn't a customer paying, such as money back from a supplier.
  • Always leave out: Leaves out every payment from that contact, now and from now on, such as your card provider paying out.

If the customer it matches has no jobs yet, the payment waits on the To match tab, saying so, until they have one.

Turning It On

Open Settings > Connections > Xero and choose Only bring in payments under Integration Mode on the Details tab. On the Settings tab, choose the date to Bring in payments from, the Bank accounts your customers pay into and the payment method to Record them as, then click Start bringing in payments.

Related articles