[1]- Setup

Step #1

Create a list of recurring monthly expenses

Recurring Expenses

Recurring Expenses

Button

Concept

Total

Add this expense

Expenses 1

$100.00

Add this expense

Expense 2

$200.00

Add this expense

Expense 3

$150.00

There are no rows in this table

⁠

The “Add this expense” button uses the following formula to add the data from .thisrow to the table in

[2]- Monthly Expenses⁠

Expenses.AddRow(Expenses.Concept, thisRow.Concept,Expenses.Total,thisRow.Total)

Select the periodicity to add the recurring expenses, in this case every first Monday of the month.

First Monday of Month:

[ ]

⁠

Create a button to push “All button” in Recurring Expenses table.

⁠

Add all recurring expenses

⁠

Create a time-based automation:

Step 1- Time based, every monday.

Step 2- If Step1.Result = First Monday of Month

Step 3 - Then push “Add all recurring expenses” button.

Every expenses in the “Recurring Expenses” Table will be added to

[2]- Monthly Expenses⁠

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.