We'd like to remind Forumites to please avoid political debate on the Forum... Read More »
Trying to be more organised - how do you track your accounts?



Hi
My finances have become a bit more complex recently as I'm now required to complete a Self Assessment return, and I'm earning more interest than I used to due to the rate increases.
I've set up a monthly routine but wondered if I'm approaching this in the best way.
I've set up a spreadsheet that lists all my accounts (including credit cards), and each month I update the balance so I can see whether my net position has improved or not. Within the spreadsheet I also record:
- Details of all taxable interest received that month
- Details of any Gift Aid charity donations made that month (for my SA return)
- Details of any Dividends received (although these are negligible as most of my investments are in an ISA)
- From my payslip, my YTD taxable earnings and tax paid
While I am logged into my accounts filling in the spreadsheet, I also sweep any surplus cash into savings, claim any cashback/rewards due etc and download monthly statements. I also check the rates on my savings accounts and move funds if necessary to maximise interest.
I also have a 'key dates' tab in my spreadsheet which notes things like when fixed rates are due to end, when 0% credit card offers end, and when car insurance/broadband contracts end. I check this and take any action needed e.g. get quotes for next year's insurance.
I probably spend about an hour a month on these tasks (longer if a new account is needed or something needs renewing).
Is this the best way to track things? Am I missing anything?
Comments
-
It's AceMoney for me, all the way. I update it throughout the month, as and when/if required.
Others use MS Money, or one of the Open Banking ones, such as Emma. A home-made spreadsheet works for many people, too.
There are various threads about this on this board. If you search for MS Money, you probably find most of them.0 -
I use a good old fashioned spreadsheet, and also an app called spending tracker by MH Riley. You can categorise transactions so I do that for interest and cash back/switching/rewards etc.
If you want me to definitely see your reply, please tag me @forumuser7 Thank you.
N.B. (Amended from Forum Rules): You must investigate, and check several times, before you make any decisions or take any action based on any information you glean from any of my content, as nothing I post is advice, rather it is personal opinion and is solely for discussion purposes. I research before my posts, and I never intend to share anything that is misleading, misinforming, or out of date, but don't rely on everything you read. Some of the information changes quickly, is my own opinion or may be incorrect. Verify anything you read before acting on it to protect yourself because you are responsible for any action you consequently make... DYOR, YMMV etc.1 -
I have 15 savings accounts, plus 7 bank accounts.
I just have a spreadsheet and add interest to it each month.
Next year when I need to fill out a self assessment form, it’s should only take me 20 minutes.
Although mine is a bit simpler than yours.1 -
Bigwheels1111 said:I have 15 savings accounts, plus 7 bank accounts.
I just have a spreadsheet and add interest to it each month.
Next year when I need to fill out a self assessment form, it’s should only take me 20 minutes.
Although mine is a bit simpler than yours.0
Confirm your email address to Create Threads and Reply

Categories
- All Categories
- 350.8K Banking & Borrowing
- 253K Reduce Debt & Boost Income
- 453.5K Spending & Discounts
- 243.8K Work, Benefits & Business
- 598.6K Mortgages, Homes & Bills
- 176.8K Life & Family
- 257K Travel & Transport
- 1.5M Hobbies & Leisure
- 16.1K Discuss & Feedback
- 37.6K Read-Only Boards