Sort the AP inbox: invoices, queries and payment changes
Each AP email gets what it sends or asks, with flags for a supply stop, a legal threat, a resent invoice and a bank change. The queues are an example.
Try it on this example
Sender name and address: Gail Pemberton <g.pemberton@ridgewaypackaging.example>
Subject: RE: Overdue - INV-20931 and INV-21007
Attachment file names (empty if none): statement_September.pdf; new_bank_details.pdf
Email body, with the signature
- What is this email to accounts payable mainly sending or asking for?Payment detail change100%
- Does the message ask, even indirectly, to send payments to a different bank account, card or payee?Yes99%
- Does the email ask accounts payable to make a payment outside the normal invoice process?No84%
- Does the sender say supply, service or delivery will stop or is on hold because of non-payment?Yes98%
- Does the sender mention a collection agency, legal action, late payment interest or statutory compensation?Yes99%
- Does the email say the invoice it sends is a copy, a resend or a corrected version of one sent before?No88%
- Is there enough in the email for accounts payable to act without asking the sender for more?Yes65%
These are real answers stored from one run on this example.
The prism behind it
Sort the AP inbox: invoices, queries and payment changes
Fields
- Sender name and address
- Subject
- Email body, with the signature
- Attachment file names (empty if none)
Context
We are Brightwater Components, a UK manufacturer. Suppliers, their credit controllers and our own staff write to one accounts payable mailbox. Each email is read on arrival, before a person opens it, and code sends it to a queue by its type: - Invoice capture: new invoices and credit notes, and internal approvals or coding of an invoice. - Supplier desk: statements, questions about when an invoice will be paid, payment reminders and remittances. - Invoice queries: disputes about an amount, a price or a line on an invoice. - Vendor master: new supplier forms and changes to a supplier's address, tax or contact details. - Payment change hold: any request to pay a different bank account, card or payee. Nothing is changed or paid on the strength of the email; the change is confirmed by a call to a number we already hold. - No action: newsletters, sales pitches and anything not about a payable. One email, one type. When an email asks, anywhere in it, to pay a different account or payee, its type is a payment detail change, whatever else it says, because that queue must see it first. Invoice numbers, amounts, due dates and days overdue are read by the capture tool and the ERP, not here. Whether an invoice was already paid, whether it is a duplicate, and whether the sender's domain matches the supplier record are checked by code. These answers route email and raise flags for a person; they never pay, approve or change anything.
Questions
What is this email to accounts payable mainly sending or asking for? Choice
Choose the one type that best fits the whole email, using the rules in the context. When the email asks anywhere to pay a different bank account, card or payee, choose Payment detail change.
Does the message ask, even indirectly, to send payments to a different bank account, card or payee? Yes / No
Count "our bank details have changed", "please remit to the account below", "use the new details on the attached letter", a request to pay a different company or person, an employee asking for their pay to go to a new account, and saying the old account should no longer be used. Count account details given for payment in place of the usual ones even when the word "change" is never used. Do not count bank details printed as usual in an invoice or statement footer with no request to use them instead. Yes: The message asks, however briefly or politely, for payment to go somewhere other than before. No: The message asks for no change to where payment goes.
Does the email ask accounts payable to make a payment outside the normal invoice process? Yes / No
Count an urgent one-off transfer, a payment with no invoice, gift cards, or a senior person asking for a payment to be made quickly or quietly. Paying an overdue invoice, even to new details, belongs to the payment detail change question, not this one. Yes: The email asks for a payment outside the normal invoice process. No: The email asks for no payment of this kind.
Does the sender say supply, service or delivery will stop or is on hold because of non-payment? Yes / No
Count an account on stop, a delivery or service held, suspended or cancelled until payment arrives. Yes: The sender says supply, service or delivery has stopped or will stop because of payment. No: No such stop or hold is mentioned.
Does the sender mention a collection agency, legal action, late payment interest or statutory compensation? Yes / No
Count a debt collection agency, solicitors, court or legal action, interest added for late payment, and fixed compensation charges for late payment. Yes: The sender mentions at least one of these. No: The sender mentions none of these.
Does the email say the invoice it sends is a copy, a resend or a corrected version of one sent before? Yes / No
Count "copy invoice", "resending", "duplicate", "as sent on", "revised" or "corrected invoice". Code checks whether the invoice is already in the system. Yes: The email says an invoice it sends was sent before in some form. No: The email does not say this, or sends no invoice.
Is there enough in the email for accounts payable to act without asking the sender for more? Yes / No
Read the sender, subject, body and attachment names together. Enough means the supplier can be identified and the request or document is clear, for example an invoice attached or referred to, or a clear question about named invoices. Yes: Accounts payable can act on the email as it stands. No: The supplier, the invoice or the request is unclear, or an attachment the email refers to is missing from the attachment names.
Lens columns
email_type, email_type_probability, payment_details_change, payment_details_change_probability, unusual_payment_request, unusual_payment_request_probability, threatens_supply_stop, threatens_supply_stop_probability, legal_or_collection_threat, legal_or_collection_threat_probability, resent_or_copy, resent_or_copy_probability, enough_to_act, enough_to_act_probability
Run it on your own text
Add this prism in the app, change any question, and test it on a file of your own.