We're aware that some users are experiencing technical issues which the team are working to resolve. Thank you for your patience.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!

What do you include in your Finance Spreadsheet.

Options
2»

Comments

  • It would be interesting to see actual examples of peoples spreadsheets (obviously with sensitive figures changed to 0) and maybe create a super-spreadsheet
  • Idiophreak
    Idiophreak Posts: 12,024 Forumite
    10,000 Posts Combo Breaker
    It would be interesting to see actual examples of peoples spreadsheets (obviously with sensitive figures changed to 0) and maybe create a super-spreadsheet

    Sorry, I tried to sanitise mine so I could post it up..but by the time I'd taken out names, amounts etc it really just seemed completely meaningless - hopefully other people will have more success.
  • I use mine to manage our joint account as if were two virtual single accounts with the balances combined.

    i.e. against each transaction I put the initial of either me or Mrs DG according to who spent the money, and it then uses a whole set of nested IF= statements to update the balance of the appropriate individual. There's also an option for sharing a transaction between us, by putting an "X" in the initial column, then the individual shares of the transaction into two extra columns so it updates the balance accordingly.

    I also use conditional formatting to make the balances change colour if they go below certain thresholds.
  • Idiophreak
    Idiophreak Posts: 12,024 Forumite
    10,000 Posts Combo Breaker
    I use mine to manage our joint account as if were two virtual single accounts with the balances combined.

    Just out of interest...but why? I don't really see why you'd have a joint account but run it as two separate ones? Why not just have two separate accounts?
  • evenasus
    evenasus Posts: 11,866 Forumite
    Part of the Furniture 10,000 Posts Name Dropper
    edited 20 February 2013 at 11:38AM
    iclaudius wrote: »
    I've tried quicken and other fancy spending tracking software out there such as Mint etc. But to be honest, all that synching and labelling never works and is way too time consuming. I prefer the flexibility of my own spreadsheet.
    With Quicken, one update - be it a direct debit - the weekly shop etc - all the accounts update with one transaction input.

    Keeping track of numerous savings accounts/ISAs & bonds is made simple too.

    I've just had a quick count of savings accounts alive & dead that we have/have had since 1994 & there are 74.
    I can see when they matured - which accounts they were transferred to etc.

    If I want to know when we bought something - like a TV for instance, I can click search - enter Samsung TV or whatever and it takes me straight there.
    Shows when we bought it, which account we used for paying for it.
  • Idiophreak wrote: »
    Just out of interest...but why? I don't really see why you'd have a joint account but run it as two separate ones? Why not just have two separate accounts?

    A number of reasons - mainly joint bills. We split a lot of the bills (e.g. mortgage, power, etc) so it's a lot easier (IMHO!) to make the payments from a single bank account and do the "splitting" in the spreadsheet, rather than try do this from two individual accounts.

    Also, not so much now but in the past, there were times when one of us was "overdrawn" individually but as the other was in "credit" we didn't hit an actual overdraft. It gives us flexibility to avoid paying overdraft interest because typically if one of us has a heavy month the other doesn't and so that keeps us in the black.
  • Idiophreak
    Idiophreak Posts: 12,024 Forumite
    10,000 Posts Combo Breaker
    A number of reasons - mainly joint bills. We split a lot of the bills (e.g. mortgage, power, etc) so it's a lot easier (IMHO!) to make the payments from a single bank account and do the "splitting" in the spreadsheet, rather than try do this from two individual accounts.

    Also, not so much now but in the past, there were times when one of us was "overdrawn" individually but as the other was in "credit" we didn't hit an actual overdraft. It gives us flexibility to avoid paying overdraft interest because typically if one of us has a heavy month the other doesn't and so that keeps us in the black.

    Yeah, we always end up calculating the bottom line for each account then transferring an amount from one account to the other (normally from her to me as I pay more bills...) to keep both in the black. Don't think it makes much odds eitherway - just wanted to check I wasn't missing something obvious :)
This discussion has been closed.
Meet your Ambassadors

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

Categories

  • All Categories
  • 350.7K Banking & Borrowing
  • 253K Reduce Debt & Boost Income
  • 453.4K Spending & Discounts
  • 243.7K Work, Benefits & Business
  • 598.5K Mortgages, Homes & Bills
  • 176.8K Life & Family
  • 256.9K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16.1K Discuss & Feedback
  • 37.6K Read-Only Boards

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.