Customer payments matched to open invoices and the right payer.
What it solves: Customer payments are applied, researched and re-checked in one Kylon room. Agents match each payment to open invoices from Stripe charges and Outlook remittances, and the AR manager approves every application before it is written.
How it runs
- Application Each payment is matched to open invoices from its Stripe charge or Outlook remittance, then applied, split or left unapplied Who decides: The AR manager approves before Airtable is written
- Payer research Payments nobody can place get a research call on the Outlook calendar Who decides: The collections lead accepts each call
- Export review A colleague’s summary export is checked against the payments, and every candidate gets a review flag, including any the export misses Who decides: The AR manager approves the flags
- Late remittances and credit memo The named payments are re-checked, and a credit memo can turn a short payment into an exact one Who decides: Billing confirms the memo; the AR manager approves
- Payer identification A memo names the customer behind a third-party payment, and the customer field is corrected before the payment is applied Who decides: The AR manager approves the change
- Duplicate refund and closeout A refunded duplicate is recorded without creating a match, and the day’s totals are closed Who decides: The AR manager signs the closeout
Tools it connects
- Airtable: Holds the payments, the open invoices and each application.
- Google Drive: Keeps the application policy, the call rules and the summary exports.
- Outlook: Carries the AR mailbox where remittances arrive, and the calendar for payer-research calls.
- Stripe: Holds charges and refunds, read as evidence for each payment.
- Gmail (optional): Carries billing and treasury threads, with replies drafted for a person to send.
- Slack (optional): Is where collections and billing flag customer news during the day.
Set-up prompt
Paste this into Kylon, or start it in one click below.
Set up our cash application desk in this Room. Take it one step at a time and wait for my OK before you move on.
1. Connect Airtable, Google Drive, Outlook and Stripe first, since the first run needs them. Tell me which ones still need connecting. Gmail and Slack can wait until a step uses them.
2. Ask me who works this desk: the cash application specialist, the AR manager, the collections lead and billing. Help me invite them to this Room.
3. Build a Cash Application App with Payment, Customer, Applied to and Status columns, one record per payment. Pull open payments and invoices from Airtable and remittances from the AR mailbox in Outlook.
4. Match each payment to its open invoices using the Stripe charge and the Outlook remittance. Flag unplaced payments, short payments a credit memo could make exact, payer-research calls still booked for applied payments, and payments recorded under a finance provider instead of the customer they pay for.
5. Propose each application and customer correction in the thread and show before and after for any customer change. Draft customer replies in Gmail or Outlook for the collections lead to send. Write nothing to Airtable and send nothing until the AR manager approves each application and every customer change. The collections lead accepts or cancels each payer-research call.
6. Write our rules, our call policy and who approves what into this Room's guideline so every payment follows the same order.
7. After one clean day, offer to turn the daily payment queue into an Automation.
Start with step 1. Once the tools are connected, or I say the rest can wait, ask me for our rules one at a time.