Spreadsheet – (Google Sheets / Excel) Automate repetitive transactions

I use Google Sheets to record financial transactions, as shown in the image below.

I'm trying to find a way to automatically enter repetitive transactions. I started by adding a "repeat every day" column, as shown in the "Rent" line of my example.

Sheet showing the list of transactions

Ideally, I want to avoid writing a macro because I want to use the spreadsheet in the mobile application.

Is it possible to do this with built-in functions?

I think you could add a function to column A to check that the adjacent cell is empty, then look in column H for cells that are not empty, and then return those lines with an augmented date.

For example, I started trying something like = SI (H4 <> "", {"", B4 + H4, C4: H4}, "") in A6, but I'm not sure if there is a way to turn it into something that works.