JohnFiscal wrote: ↑
Mon Oct 08, 2018 5:24 pm
LiterallyIronic wrote: ↑
Mon Oct 08, 2018 5:14 pm
Excel. One spreadsheet in which I enter all of our account balances on the first of every month, and a different spreadsheet in which I enter all of our expenses. Which reminds me that I haven't updated that since the last week of September so that's going to be a big pain in the neck.
I'm intrigued but I'm not certain how/what you are doing. Do you maintain your own "ledgers" in Excel, where you enter each transaction (like an old fashion check book register)? that's exactly what I do...for each account: banking, credit cards, investments. I always know "where I stand" and I've been doing this in Excel since 1992. Now that we have "the web" most such accounts have this information on-line and available for downloading.
So the balances spreadsheet has a column for every month and a row for the various accounts.
One column, with fictitious numbers because I'm not at home, would look like this:
October 1, 2018
Roth IRA: $1,000
Roth IRA: $1,000
House Estimated Value: $1,000
Outstanding Mortgage: $1,000
Credit Card Debt: $1,000
Then I sum up the total (and subtotals) to get a net worth every month.
As for the expenses sheet, there are a bunch of columns. Called "Mortgage", "Utilities", "Groceries", "Stratus Gas", "Hobbies", etc. Then, every expense gets a simple row in the sheet. The row would have the date the expense occurred, the payee, and the method of payment, then it would simply have a number on the row in the correct column. Like "10th, Walmart, Debit" and then "$9.84" in the "Personal Care" column. For ones that are not obvious, like purchases at Walmart, we have a "Notes" column that explains it in more details.
I'm a 34-year-old software developer, but I'm pretty old-school.