Not sure if you can write a bit of code but my setup works this way:
- I have a truelayer test account that is linked to my Amex account
- a script runs a cronjob every hour on my PC
- said script checks all transactions on my amex from the last 7 days and writes all transaction IDs to a file
- if the transaction ID is not in the file, the amount is sent to a google sheet
- from the google sheet, IFTTT moves every new transaction amount from my main account into my Amex pot
- refunds are just transactions with a - sign in front of them, so the amount gets moved back to the main Monzo balance