For example, anything housing related, from property taxes to insurance to utilities to trips to Home Depot is under the housing category. My categories are similar to yours, except I have fewer of them, and they’re related to function. I do exactly as you do, except I use Personal Capital as the aggregator, then export that to a spreadsheet once a month. Im curious if you dont use those apps how do you get all your transactions into the spreadsheet efficiently? Nice - yeah i like excel the best for the ability to customize however you want. I'm always back to the tried and tested excel sheet-I'm more comfortable tracking expenses manually that way. I used both Mint and YNAB before, but these apps really can't seem to work well for me. These are my categories that I can use in my cash flow tracking application.ĭeclare Income csi - child support incomeĭeclare Income dblTaxFreeDiv - double tax free dividendĭeclare Income inheritance - inheritance incomeĭeclare Income dividend - dividend incomeĭeclare Income interest - interest incomeĭeclare Income taxFreeDiv - tax free dividendĭeclare Income GiftIncome - gift receivedĭeclare Income ShortGains - short term capital gainsĭeclare Income LongGains - long term capital gainsĭeclare Expense alimony - alimony expenseĭeclare Expense car - car repair, car purchase, gas, parking, transportationĭeclare Expense child - child support expenseĭeclare Expense civic - donation to campaigns or electionsĭeclare Expense charity - non-profit donationĭeclare Expense church - religious organization donationĭeclare Expense debit - generic debit expenseĭeclare Expense dining - dining out expenses, restaurantĭeclare Expense education - school costs, tutor expenses, after-school programsĭeclare Expense event - movie or musical events, amusement parksĭeclare Expense fee - bank fees, credit card feesĭeclare Expense gift - gift expense, including birthdayĭeclare Expense food - food and grocery store expensesĭeclare Expense hobby - hobby related expenses, wine, tea, collectiblesĭeclare Expense housing - mortgage, rental, home repair, gardening, home owner associationĭeclare Expense insurance - car, house, or life insuranceĭeclare Expense legal - legal or lawyer expenseĭeclare Expense medical - dental and medical expenses, prescriptions, self paid premiumĭeclare Expense misc - miscellaneous expensesĭeclare Expense phone - phone, cable, internetĭeclare Expense tax - property tax, income taxĭeclare Expense utility - electricity, natural gas, water, garbageĭeclare Expense vacation - vacation related expenses what sort of metrics are others focused on when maintaining a spreadsheet to track personal finance? what other calculations/forecasts do you use in your own planning?ĥ. I was a bit surprised when calculating the number for food, leisure/entertainment (while taking into consideration that rent/housing is not my largest expense), but i can definitely cut back.Ĥ. I want to start conversation about savings needed for retirement - as a basic calc, ive taken the net worth, withdrawal rate, avg annual exp and calculated how much each expense category would need to be saved for FI. do you think there are too many categories here? should i make it a bit simpler and group a few of these together? (i have sub-categories in each)ģ. im curious how other bogleheads use similar things to track spending.Ģ. The reason that i chose to do it this way was so that i could parse out things like subscriptions from entertainment and see exactly what these are, or holidays/birthdays from leisure entertainment to see how much that one specific item was.ġ. Ive used some other calculations from other peoples sheets in further detail to see what would be required savings based on net worth and withdrawal rates with a few different scenarios. I have a tab with a P&L and BS and a summary tab that tracks the shows the main categories YTD, Projected for the year, and 3 year historical. Mint is used only to export transactions from all accounts into the sheet and then i categorize myself in excel. I made a spreadsheet that i use for myself in conjunction with Mint. Curious how other Bogleheads manage their own finance.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |