G
Guest24480
Guest
I like being able to customize things in Excel and try to avoid software that limits how I can manipulate my own financial data. I personally use this budget spreadsheet by Vertex42.
I create two copies of it in the same Excel workbook. The first one I use for a budget/projection of my annual financials and fill it out at the start of the year. The second is for recording my income/expenses on a monthly basis. I update the second one at the end of every month by going through my bank and credit card statements. Since the categories are the same between the two copies, I can see how accurate my budgeting forecasts were at the start of the year by comparing them.
As for net worth, I just update it every month in a basic Excel sheet I made for myself. No need to use software for a simple Assets - Liabilities calculation imo. I've used Personal Capital in the past but found their integrations with 3rd parties were lacking, and ended up having to maintain my own spreadsheet anyway. The only way I'd ever go back to net worth tracking software is if it updated in real time with your account balances without having to manually fix the integrations every 5 days.
I create two copies of it in the same Excel workbook. The first one I use for a budget/projection of my annual financials and fill it out at the start of the year. The second is for recording my income/expenses on a monthly basis. I update the second one at the end of every month by going through my bank and credit card statements. Since the categories are the same between the two copies, I can see how accurate my budgeting forecasts were at the start of the year by comparing them.
As for net worth, I just update it every month in a basic Excel sheet I made for myself. No need to use software for a simple Assets - Liabilities calculation imo. I've used Personal Capital in the past but found their integrations with 3rd parties were lacking, and ended up having to maintain my own spreadsheet anyway. The only way I'd ever go back to net worth tracking software is if it updated in real time with your account balances without having to manually fix the integrations every 5 days.