My Super Personal Accounts Spreadsheet

Olipro

want something better than a mere spreadsheet?

I heartily recommend GnuCash - http://www.gnucash.org

open source and supports double entry accounting with report generation, can't beat that.

matt_n_mich

LucyTheDwarf wrote: »

I like problems too, but I think my employer will get a bit annoyed if I spend too long on this one. It's not an essential field, it's one I want

Fixed... Download the dateproblem spreadsheet again...

I needed to make it an array (need to press ctrl-shift-enter not just enter).. and it can be simplified to:
=MAX(IF(B:B=E5,A: A))


:T

matt_n_mich

Olipro wrote: »

want something better than a mere spreadsheet?

I heartily recommend GnuCash -

open source and supports double entry accounting with report generation, can't beat that.

Now this sounds like PROMOTION! :mad: - Troll...

No actually since although there are many very good accounts programs out there (and I have used a few) I personally prefer a spreadsheet for its flexability in that i can make it do what and only what i want... thanks!

dave4545454

i've donated:)

Olipro

matt_n_mich wrote: »

Now this sounds like PROMOTION! :mad: - Troll...

No actually since although there are many very good accounts programs out there (and I have used a few) I personally prefer a spreadsheet for its flexability in that i can make it do what and only what i want... thanks!

I never personally saw or understood what it is people think they can do with a spreadsheet that's more reliable than a piece of software that allows you to define all the accounts (assets, expenses) you want.

with a spreadsheet, if you make a mistake then your numbers won't balance and you'll have no idea which transaction it was that you didn't record.

on the other hand, if you use a double entry accounting software, you can never do that because if you have an imbalance between your assets and expenses you will see which transaction you've failed to record on one of the sides of the equation. I think the thing about this that puts most people off is grasping the concept that you treat money like energy rather than food - that is to say, money is only transferred, it is never destroyed.

matt_n_mich

Olipro wrote: »

I never personally saw or understood what it is people think they can do with a spreadsheet that's more reliable than a piece of software that allows you to define all the accounts (assets, expenses) you want.

with a spreadsheet, if you make a mistake then your numbers won't balance and you'll have no idea which transaction it was that you didn't record.

on the other hand, if you use a double entry accounting software, you can never do that because if you have an imbalance between your assets and expenses you will see which transaction you've failed to record on one of the sides of the equation. I think the thing about this that puts most people off is grasping the concept that you treat money like energy rather than food - that is to say, money is only transferred, it is never destroyed.

Fair enough, its you opinion and its valid...

I understand how accounts programs work, but then I suppose I just notice if there is a mistake and how much it was for when my real balance does not match my spreadsheet balance... thats easy enough to notice, I just check my statements to the spreadsheet every month... It is eaqually possible to miss inputting a transaction into an accounts program.

Olipro

matt_n_mich wrote: »

Fair enough, its you opinion and its valid...

I understand how accounts programs work, but then I suppose I just notice if there is a mistake and how much it was for when my real balance does not match my spreadsheet balance... thats easy enough to notice, I just check my statements to the spreadsheet every month... It is eaqually possible to miss inputting a transaction into an accounts program.

if you miss a transaction then your account balance will be wrong and you will notice.

My point was that if you enter the wrong amount for an expenditure but you're doing all the figures manually on a spreadsheet, you'll never know because you're just updating your account balance and then writing in the amount(s) you spent on X, Y and Z... with a double entry software it's impossible to do that.

benoit

dave4545454 wrote: »

i've donated:)

Donated what? :huh:

LucyTheDwarf

Olipro wrote: »

want something better than a mere spreadsheet?

I heartily recommend GnuCash - http://www.gnucash.org

open source and supports double entry accounting with report generation, can't beat that.

I love gnucash - I use an early version of it, it's always worked well for me.