Savings/Current account spreadsheet

monkeemadness wrote: »

I'm planning over opening as many current account and regular savers as I can. Many of these require minimum transfers per month and direct debits. Are they any known spreadsheets online to manage this cashflow?

Firstly, try to automate as many of the transfers as you can using standing orders.

I use a simple spreadsheet - the first column lists the accounts, the second column lists the day of the month a transfer needs to be made (if not the 1st), the third column lists the maturity date of the account. In the next column (headed with the month/year) I record (on each row, as the transfers are done) the date the payment into each account has been made.

Any gaps in this fifth column means a payment hasn't been made yet. At the end of the month I check to make sure all the rows in the fifth column have been filled. At the start of the next month I add a new column between columns 4 and 5, which adds a new 'column 5' - data for all previous months is still there, it just moves to the right by one column each time a new month is added.