Skip to main content

Email a daily overdue report

Every morning, email the owner of each overdue invoice with the amount, the due date, and a link to the record. Nothing is sent when no invoice is overdue.

Written by Leo

A daily report keeps late payments from slipping. A schedule starts the automation every morning, a view lists the invoices that are overdue, and a loop sends one email per invoice to the person who owns it. The view does the filtering, so the report always reflects today's data.

Scrolling through the automation Daily overdue report: Every day at 8:00 AM in Invoices, Get records of a view in Invoices from Overdue invoices and limit results to 200, and Loop actions for each invoice with Send an email to the account manager's email, the subject Overdue: and the invoice title, and the amount, due date, and Record URL in the message

Note:

  • One email per overdue invoice. Emails sent with Tape's own email account count toward your organization's 24-hour sending quota. Emails sent through your own email account don't.

  • The loop does nothing for an empty list. When no invoice is overdue, no email goes out.

What you'll need

  • A database app Invoices with the fields Title, Amount (number), Due date (date), Status (category with the option Paid), and Account manager (person).

  • A view of Invoices named Overdue invoices with the conditions Due date Is before Current date and Status Is not Paid. To create it, open Invoices and select Filter in the toolbar. Without filters, it opens the field list right away. Choose the field and the condition, then select Add filter for the second one. Then select Save → Create new view.

Build the daily report

  1. Open the Invoices app and click the automations icon at the top right (Create and view automations).

  2. Select New automation, then select On a scheduled time or interval.

  3. In the trigger, select One time and choose Every day. Select 8:00 AM to change the time. The start time uses the automation's time zone. To see or change it, hover over the top of the editor and select Time zone, for example Time zone UTC+01:00.

  4. Select Add action → Get view. Select the app Invoices and the view Overdue invoices. Open the action's menu and turn on Limit results. The action now reads and limit results to 1. Select the number and enter 200.

  5. Select Add action → Loop actions. Set it to for each, and choose the records from Get view.

  6. Inside the loop, select Add action → Send email.

  7. In To, type @ and choose the Email of the invoice's Account manager field. The invoice's fields appear under Collected / Invoice. In Subject, enter "Overdue: " and insert the Title field.

  8. Write the message, for example "This invoice of " followed by Amount, " was due on " followed by Due date. Insert the invoice's Record URL so the recipient can open the invoice.

  9. Select Show preview to check the email, then select Create automation.

Below the trigger Every day at 8:00 AM in Invoices, selecting Add action and Get view, choosing the view Overdue invoices, turning on Limit results in the action menu, and changing 1 to 200, so the action reads Get records of a view in Invoices from Overdue invoices and limit results to 200

The result

At 8:00 AM, each account manager gets an email for every overdue invoice they own, with the amount, the due date, and a link. Paid invoices leave the view, so they stop appearing the day after payment is recorded.

Variations

  • Report to one person. Enter one address in To, for example [email protected]. The loop then sends that person one email per invoice. For a single email with a table of all invoices, see Build an HTML table from records →.

  • Skip the loop. Replace Loop actions and Send email with Send email to collected. It sends one email per collected record. Learn more about Send email to collected →

  • Weekdays only. Choose Every week, then select the weekday after on and pick Monday to Friday.

  • Another rhythm. You can also repeat every few hours, days, weeks, or months, and pick a day of the month, including Last day.

  • Escalate. Add a second view for invoices more than 30 days late, and a second loop that emails the finance lead.

Learn more

FAQs

Can I test the report without waiting for the morning?

Yes, select Manual run to run it once. A manual run sends real emails, so test with a view that only contains an invoice of yours.

Why did I not get an email today?

If no email arrived, it could be because:

  • No invoice is overdue, so the view is empty.

  • The sending quota for the last 24 hours was used up.

  • The automation is Paused.

How many invoices can the report cover?

A collection holds at most 1,000 records, and a run lasts three minutes at most. If your list is longer, work through it in batches. Learn more about batches →

Are you a developer using the Tape API for automations?

The automation API has its own documentation for developers. Full reference: for_loop in the developer docs →

Still have more questions? Find answers and get help from community experts in the Tape community →.

Did this answer your question?