Skip to main content

Approve expenses over a limit

Route every expense over $5,000 to a manager. Tape sets the status, creates a follow-up task, emails the approver, and approves smaller expenses on its own.

Written by Leo

This recipe sets up an approval flow for expenses. When someone submits an expense, Tape puts it in review. Expenses over the limit go to a manager, and everything else is approved right away. It's meant to save your finance team from checking every small expense by hand.

Scrolling through the Expense approval automation: the trigger and the Status filter, Update the current record, Conditional actions with Amount > 5000 and its steps for large expenses, and the else branch that sets Status to Approved

What you'll need

  • An Expenses database app with these fields:

  • Expense, a text field with the title

  • Amount, a number field

  • Status, a status field with the options Submitted, In review, and Approved

  • Processed on, a date field

  • Approver, a person field

  • Approval note, a text field

  • Follow-up task, a relation field to the Tasks database app

  • A Tasks database app with Title, Status (with To do), Due date, and Priority (with High).

Build the automation

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

  2. Select New automation, then select When a record is updated.

  3. In the trigger, select the field name and choose Status under FIELDS.

  4. Under And if the following conditions are met, select Add filter. Pick Status, then Has changed to, then Submitted.

  5. Select Add action → Update record. The action reads Update the current record. Select Add field for each of these, using Set option, Set date, and Set person: - Status: In review - Processed on: Current date - Approver: the manager who approves large expenses

  6. Select Add action → Conditional actions. Under If the following conditions are met, select Add filter, pick Amount, then > and enter 5000.

  7. Inside the condition, select Add action → Update record. Add the field Approval note, select Set value, and enter "Over limit: " followed by the Amount field and " needs approval".

  8. Select Add action → Create record. Choose the Tasks app and add these fields: - Title: "Approve expense: " followed by the Expense field - Status: To do - Due date: Set date → Current date, then + 2 Days. For 9:00 AM, select Add field again, choose Due date / Time, then Set time → Exact time - Priority: High

  9. Select Add action → Send email. In To, insert Approver and its email. In Subject, enter "Approval needed: " and insert Expense. Select Show more and write the message, for example "Hi " followed by the approver's name, then the expense and amount. Select Show preview to check it.

  10. Select Add action → Update record again. Add the field Follow-up task, select Set record (or Set records if the field allows several records), and choose Created record.

  11. Select Add action → Add comment. Enter "Over the $5,000 limit. ", mention the Approver, and add "please review and approve."

  12. Next to Else if conditions are not met, select Add action → Update record. Set Status to Approved and Approval note to "Within limit: auto-approved".

  13. Select Create automation.

The complete automation: the trigger, the filter Status Has changed to Submitted, Update the current record, and Conditional actions with the condition Amount > 5000 and the collapsed branches Actions and Else if conditions are not met

Note:

  • Order matters. Create the task before you link it. Created record only exists after the Create record action ran.

  • Emails are real. Send an email sends a real email on every matching run. Test with your own address as the approver.

The result

Set the Status of an expense to Submitted. If the amount is $5,000 or less, the status becomes Approved and the note says "Within limit: auto-approved". If it's more, the status is In review, the approver gets an email, a High priority task appears in Tasks with a due date two days out, the expense links to that task, and a comment mentions the approver.

Variations

  • Change the limit by editing the number in the condition.

  • Add a second Conditional actions step for travel expenses with a different approver.

  • Add a Send email step to the Else if conditions are not met branch to tell the submitter their expense is approved.

Learn more

FAQs

Can I use an automation to approve expenses in several steps?

Yes! Start a second automation from a status change, or use Call automation to hand the record to another one. Learn more about calling automations →

Why did the automation run but the task wasn't linked?

The link step uses Created record, which only exists after Create record ran in the same run. Check that the link step comes after the task step.

Are you a developer using the Tape API for automations?

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

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

Did this answer your question?