Been struggling w/ my normal account balance spreadsheet which I’ve been keeping in Numbers for many years now. It has moved between spreadsheet apps many times. Every once in awhile I forget to update at EOM and this causes headaches. But yesterday I could not find the most recent copy of this spreadsheet and had to estimate the last 4-5 months! This involves:
- stock history, new purchases or dividend reinvestments each month across three brokerage accounts
- Checking balance (pretty easy)
- Shares owned and EOM closing price of two different stocks
- Cash on hand estimate
I think I got it fixed, but this morning it occurred to me that Tiller has all my transactions, so …
Sure enough, the Net Worth tab/template has totals pretty close to my spreadsheet! I am not sure if I should just stop the spreadsheet, or just use the totals in Tiller and copy/paste them over. However, I do notice that some numbers are off a bit, mainly because Tiller’s balance doesn’t include the last-minute addition of interest and ATM fee reimbursements from Schwab. But May’s checking account balance was almost $3,000 low! Haven’t found any obvious issue there yet.
One other issue is Cash. I created a Cash account but haven’t been inserting manual transactions. Really all I will be tracking is Rent and Other, since I am not going to keep all our receipts for cash purchases since there are about 150 of those each month (we live in Mexico). Which makes me wonder if I should just remove the Cash item from most everything? Can ATM withdrawals just be transferred to ‘null’ ???