MSE-ers really do love a good spreadsheet!

backinbusiness

Probably the most important tool in my debt-free quest was my completely honest spreadsheet. I detailed account balances, monthly income and expenditure (including direct debits) and a bank rec. (A proper, accurate budget in effect!)

I obsessed about it - tweaked it this way and that for hours at a time - and still update it at least twice a week.

DFW or debt free - do you love your spreadsheet(s)?

BiB

rising_from_the_ashes

Ohhhhh yeeeesssssss!:D

I have a couple:

The budget planner one which I check/revise regularly;

I also have another that records all my expenditure (got it from the Frugal Living Challenge thread) - it's split into months by different elements such as "regular payments" (household expenditure), "groceries" etc and I had a "pets" on added. I LOVE IT:o.

I've had a "technical hitch" with it when my pc was "unwell" and lost my most up to date version (hadn't backed it up for ages) so am currently trying to rebuild it for the past few months....:eek:

I seriously wonder how I can have gone from not having a clue what I spent to being able to track everything I've bought for the entire year:)

Westminster

Mine has 12 different pages in it - love it!!

freebyfifty

Yes, yes and yes. I love my spreadsheet and can sit and gaze at it for hours tweaking and changing and projecting then changing it back again - lol. :j

I have three pages. A bank account with EVERYTHING in and out, a debt one with all my debts listed and how much to pay and when and a spending one where I list every mortal thing I spend my money on.

My spreadsheet helped me change my life around and if my computer were to go bang pop I'd be in serious withdrawal
**dashes off to get memory stick**

pugzy

For my debts and their repayments I use What'sTheCost.

For my personal account bills and direct debits I use a spreadsheet.

For our house bills and joint account we use a spreadsheet.

They are an MSE-er's best friend!

Tink_04

I have one that lists all the dd's but not anything else id love a proper one but don't know how to make them

NicChanna

I have serious "spreadsheet-lust" issues and have all my spending tracked in various ways in a workbook.

I have month by month projections, a graph which shows the projection against what actually turns out to happen, and it's conditionally formatted to show if I should expect to be in the red in my current account.

It also calculates the split required for my end of the month money with half going to my debt and the rest split between things I have to put money aside for i.e. car insurance, car tax, parking permit.

I do love a good ol' spreadsheet!

Bored

Ohhhh I'm obsessed with my spreadsheet. I spent about 6 hours making it last week after months and months of searching for software online and realising there was nothing out there that was exactly perfect. It has a summary sheet with self updating totals for all my different accounts, then another individual sheet for each account where I record and categorise each and every transaction. The budget page shows me how much I am allowed to spend in each category, with the actual amount spent in each category per month. Then finally I have a page that tracks total monthly expenditure with a graph, and a page for total monthly saving contributions with a graph.

Oh, and I keep it on google docs so I don't have to worry about losing it and I can access it from any computer, anywhere I am.

backinbusiness

NicChanna wrote: »

I have serious "spreadsheet-lust" issues

Oh this made me laugh!!

MrsTinks

I used to fill my spreadsheet in religiously - I've actually now got to a stage where I don't need it! I know I know... But i know exactly what is coming in, going out and frankly I still scare everyone when they ask me about household finances... "oh yes we spend £x on electricity, but it's reducing to £x because we've been overpaying... and water works out at £x twice a year so we save just over 1/6th of that each month etc etc"... they all tend to glaze over when I get started... I guess you could say the spreadsheet is now in my head

lvm

I love my "Finance" spreasheet to bits!!! I don't go a day without updating it and pretty much start hyperventillating if I haven't updated all my payments and savings info within 12 hours of being paid!

I have everything I need on in including a 4 year budget with every DD and credit card payment, a Debt tab with details of all debts and payments, a Savings tab with my monthly saving payment and forecast to 2015, a Mortgage tab with future overpayment and expected balances, a monthly and annual statement of affairs and an Asset and Liability tab. A little tab with some graphs showing movement in debt, savings and mortgage movements on there as well.

I Excel! xxx