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.
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
- Xero Integration: Connecting Xero, the Integration Mode, and the To match and Logs tabs.
- From Job to Paid with Xero: Sending your jobs to Xero instead, with the payments you match there brought back.
- Transactions List: The charges and payments on a customer's account, payments from Xero among them.
- Payment Methods List: The payment method payments from Xero are recorded as.
- Notification Settings: Switching the Xero warnings off or on.