I have a single sheet per account (current accounts, share accounts etc). I download csvs and append to the relevant sheet - usually once per month.
In each sheet I've added a column called 'tag'. And I just tag anything that I want to keep track of - which is a small percentage of transactions. Then I can filter transactions by that tag.
Whilst it was a nice idea in theory to book every transaction to an account in a chart of accounts, I found that I very rarely looked at the PnL. And so it didn't justify the time involved in booking each transaction.
Comments
That's a nice idea. Thanks for sharing.
I have a single sheet per account (current accounts, share accounts etc). I download csvs and append to the relevant sheet - usually once per month.
In each sheet I've added a column called 'tag'. And I just tag anything that I want to keep track of - which is a small percentage of transactions. Then I can filter transactions by that tag.
Whilst it was a nice idea in theory to book every transaction to an account in a chart of accounts, I found that I very rarely looked at the PnL. And so it didn't justify the time involved in booking each transaction.