You need a Months table [id], [year], [month], [label]=CONCATENATE([year],“-”,[month])
Then Transactions table [id], [month_id], [date], [particulars], [ref], [credit], [debit]
The purpose of the months table is to group transactions by month and to have the transactions as children records.
Then you can run the bot on the months table.
If you want custom date range then I guess you could run them by year and then filter, but back to the actual template, with this structure:
The whole idea is that you transactions have to be children records of some record (month, year, bank, something) and run the bot on that parent table.