Do you create financial statements for your personal finances?

  • Creator
    Topic
  • #1426122
    Anonymous
    Inactive

    Do you create financial statements for your personal finances?

    Do you analyze/operate your personal finances as if you were a business?

    For example, do you use any software for this and do monthly reconciliations, etc?

Viewing 4 replies - 1 through 4 (of 4 total)
  • Author
    Replies
  • #1426308
    ng3926a
    Participant

    I don't, but I also use mint to keep track of everything (all my assets [just cash and investments] and liabilities [credit card and student loans]). I don't have much since I graduated from college 2.5 years ago and buying a home in my area would require a salary of 100k…for a 900sqf condo…

    I don't do a full monthly reconciliation, but I am constantly looking at my bank account to see that the charges make sense.

    #1426413
    Anonymous
    Inactive

    I don't make financial statements, perse, cause I don't really have profit margins and such to observe and maximize. I'm salaried, so I have the same income every month, and basically the same expenses.

    However, I do keep a budget, and track it faithfully. I have an Excel spreadsheet into which I enter every transaction that goes through my bank account. It's got a column for the transaction amount and the bank balance, and then the next several columns are for the different budget classifications, and the last column ensures that the amount allocated to the various budgets matches the amount entered against the bank account. This allows me to do things like save up for property taxes or auto insurance (which I pay twice a year) on a monthly basis, and not accidentally spend that money, since it's classified under “Auto Ins” or “Prop Tax” on the spreadsheet, and I can see at a glance that there's $15 left allocated to groceries or $30 left allocated to free/fun spending.

    When I had various liabilities, I tracked them closely, with anticipated payoffs, total interest spent, etc. Now that I'm debt-free, I track assets, but not as closely. My asset tracking spreadsheet links to my budget spreadsheet, with the budget items categorized into “required” and “extra” (like, utilities are required; free/fun spending isn't). This is used on the asset sheet to track how much I have in savings after subtracting 6 months' minimum living expenses, and how many months' minimum living expenses are held in savings. Right now, my MBA tuition etc. consumes most of my monthly savings, so there's little change in net assets, and because of that I haven't been tracking the assets as closely (maybe just updating every couple months). But, the budget is still tracked closely, and every month I know how well I did or didn't meet it. My budget rolls over, too, so if I overspend the food budget by $50, then the next month I've got $50 less to spend on food, so that over several months it averages out to meeting budget.

    If I worked hourly with overtime available, or if I had a source of self-employed income, then I think things like a modified income statement would be more practical, showing a different “profit” or “loss” for each month depending on how much overtime I worked etc.

    #1426541
    Skynet
    Participant

    You could, but you might not really like it when you are getting Audited by your wife or girlfriend.

    #1427454
    spsone07
    Participant

    Interesting topic. I used to keep track of my spending (120-135 transactions per month) but it became tedious and I was constantly transferring assets between bank accounts because my primary bank is 3,000 miles away and i had multiple accounts for different objectives. This was essentially an Income statement and I got lazy with inputting all the entries.

    I do keep track of balances, which was easier than analyzing single transactions from the aforementioned Income Statement. My balances I look at more of a net position or modified balance sheet. My finances became easier to track and more sophisticated once I started working in public accounting in the last couple of months.

    On my excel sheet, I also input my paycheck amounts in order to track my projected 2017 tax return. I currently get paid hourly, so I have to make a reasonable projection for the entite year. This will help me estimate how much money I should send to both state and fed every quarter. I usually put aside my 2017 tax balance duee April 2018 in another savings account that collects 1.05% interest. Its not much, but its better than getting a refund next year without any interest at all.

    FAR: passed
    REG: passed
    BEC: on deck
    AUD: crying

    "Everyone has a plan until they get punched in the face." - Mike Tyson

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Do you create financial statements for your personal finances?’ is closed to new replies.