How to Structure Account Updates (Financial services - historical record of account balances)

Hi Monday Brains Trust,

We currently use excel to keep track of account summaries for clients (balances etc for home loan accounts). We keep a historical record by creating a new tab on the account summary, titled with the date we update the data. Example here: Example of Account Summary - Google Sheets (all tabs show the same data in this example but in reality they’d have differing loan balances/new loans added etc).

We want to move these onto Monday, but I can’t work out a way to keep track of things the same way. Ideally i’d like to add a date column ‘last updated’ to the main board, and then replicate all columns into the subitem field, with the addition of a ‘become out of date on’ date column.

Dream automation would work as; When ‘last updated’ column changes, duplicate items data from all columns and create a subitem with this data, set ‘became out of date’ column to today’s date.

Open to all suggestions! Please help :slight_smile:

Hi @Kerry - I think what you are looking to do is possible. We have worked with a number of financial industry clients that deal with regular recurring entries. Of course, each is different, so it may be ideal for use to setup a Discovery Session to dig in a little further.

Feel free to schedule a session that works for you.

Thanks!
Mark

Hello Kerry,
It looks like Smart Spreadsheet a perfect fit for your case. You can track data in monday and autoimport a board into a secure and standalone Smart Spreadsheet wih subiems. All the updates will be added to a spreadsheet automatically and back to the board.
I see it like this: each month is a group on a monday board, and each group is a separate tab in our spreadsheet. So every month when you create a new group (which can be done with automations) a new tab with appear in a spreadsheet which retains the same workflow as you currently have.
Please, let me know if you need more details.