For people using GnuCash, you can define these in GnuCash rather than separate spreadsheets/files (menu "Actions > Scheduled Transations").
Then, whenever the scheduled time occurs, GnuCash will add the right double-entry accounting entries, and notify you the next time you start an interactive session.
Like any transactions added manually in GnuCash, these will be matched up with imported data (and any transactions in imported data that are not already entered manually or by schedule will be highlighted as new). The scheduled transactions also show up like any other when you reconcile a GnuCash account with a statement from the bank/CC.
Then, whenever the scheduled time occurs, GnuCash will add the right double-entry accounting entries, and notify you the next time you start an interactive session.
Like any transactions added manually in GnuCash, these will be matched up with imported data (and any transactions in imported data that are not already entered manually or by schedule will be highlighted as new). The scheduled transactions also show up like any other when you reconcile a GnuCash account with a statement from the bank/CC.