Not long ago, I showed you how I meticulously track dividend income in Excel. A financial modeling course during my junior year of college hooked me on Excel.
I’ve used Excel spreadsheet wizardry to track my entire financial life since I graduated college. More details on that process in the follow-up post.īut without that annual spending number, I couldn’t determine my FI number at all. I’m using more of a hybrid approach by subtracting my forward 12-month investment income (F12MII) from annual spending, then applying the 4% rule of thumb to my retirement savings accounts. This is the most basic way to determine if you are financially independent. This is based on the 4% safe withdrawal rate rule of thumb ( explained here). To get your FI number, simply multiply your annual spending by 25.įor example, if you spend $60,000 per year, your FI number is $1,500,000. All I want is a single annual spending number to determine my financial independence number. But its budget functionality also takes an effort to categorize spending.ĭetailed categorization is more than I need. Personal Capital is awesome for tracking net worth and investments. But I grew tired of the tool because it required so much work to get everything categorized correctly. But as your family grows and the types of transactions and accounts grow, it gets more complicated.įor years, I used for budgeting purposes. While writing about reaching financial independence before early retirement ( aka F.I.B.E.R) in 2017, I realized I didn’t know how much our family spends in a calendar year.įor single people with a few accounts, tracking spending is simple. Why I Started to Track Spending in an Excel Spreadsheet
IMPORT AMEX IN YNAB 4 REDDIT DOWNLOAD
Step 2: Download CSV File of Credit Card Statement.Step 1: Download CSV File of Checking Transactions.
IMPORT AMEX IN YNAB 4 REDDIT HOW TO
How to Track Spending Using Excel Pivot Tables (Step-by-Step).Why I Started to Track Spending in an Excel Spreadsheet.
0 kommentar(er)
