June logo
JuneDocumentation
Recipes

Chase overdue invoices

June finds the overdue invoices in your sheet or mailbox, drafts a payment reminder mail for each, and brings the thread back on the day you set to check again.

You get the overdue invoices, a payment mail drafted for each in your mailbox, and the thread back on the day you want to check again.

What you need

  • Where your invoices are: an Excel sheet in OneDrive or SharePoint through Microsoft 365, a Notion database through Notion, or the invoice mails you sent, in your mailbox. For a Google Sheet, attach a CSV export to the chat.
  • A mailbox for the drafts: Gmail or IMAP on the Mailbox card, or Outlook through Microsoft 365. Without one, June writes the mails in the chat.

Set it up

In one of your own chats, tell June where the invoices are and what counts as overdue.
June names each overdue invoice with its customer, amount and days overdue, and saves one payment mail per customer as a draft. Check them in your mail app and send the ones you agree with.
Ask for a reminder on the day you want to check again. On that day, reply to the reminder, and June reads the list again and drafts a firmer mail for each invoice still open.
Read Invoices 2026.xlsx in my OneDrive. Which invoices are more than 14 days past due? Draft a friendly payment reminder to each customer and save them as drafts in Outlook
Remind me next Friday at 9:00 Berlin time to check whether Meyer GmbH and Kranz & Söhne have paid
Check the sheet again. For everyone still unpaid, draft a firmer second reminder that names the original due date

To have June check every week without you, use a schedule with the integrations toolset on, from the form or by asking June; see two ways June comes back.

What June does not do

  • It never sends a mail. Every payment reminder stays a draft until you send it.
  • It never changes the sheet or marks an invoice paid, and it does not watch for payments coming in.
  • It does not read Word and PDF files in OneDrive. Of a spreadsheet in OneDrive it reads files up to 8 MB, the first 2,000 rows of each sheet, and about 20,000 characters per read (50,000 at most); of a Google Sheet, up to 1,000 rows of one tab per read (200 unless you ask for more).