How To Review Our Overdue Debtors

Each day the Office Administrator reviews our overdue debtors lists in Xero and Airtable, checking to see if anyone has paid or if a client needs to be moved to the next step in the Overdue Debtors Process.

Important Reminder:  Before sending any reminders always make sure that Xero has been reconciled, and check to see if there are any notes in Airtable or in Xero about payment/comms with the client or if any of the GoCardless payments have been cancelled or defaulted due to insufficient funds.

Review Xero & Airtable

1. Log into Xero

2. From the Dashboard click on Invoices owed to you

3. In the Sales overview go to Customers owing the most and click on All to the right of the page. This will then give you a list of all invoices starting with the largest amount owed (totals in red on the right-hand side)

4. Open each of the overdue clients in a separate tab by holding Ctrl and clicking on each client name line by line

5. In a second window open Airtable > Accounts > Overdue Debtors

6. Compare the debtors list in Xero to those listed in Airtable, adding any new ones they may have come into arrears since Airtable was last updated, and removing ones that have been paid

7. Once reviewed, take the next steps in the Overdue Debtor Process for each invoice, and action as required

Pics for steps 2 to 5 below: