[Excel]College Personal Accounting questions

Ryodlog
09-24-2005, 01:59 AM
Anybody know where i can find resources to learn how to use Excel to set up some accounting spreadsheets with t-accounts/journal etc, balancing my budget every sunday etc..

I'm a college student and would like to keep track of my funds, look at some charts/graphs etc how i distribute my spending. I'm living at home so I don't need to pay for rent/utilities, thinking of just putting a rent expense anyway and putting it into a "subsidized by parents" account.

If it's not TOOO complicated i want to do it myself just to learn how to use Excel and employ my n00b accounting skills i picked up a semester ago :D

What would be the best place to start?

liggyman
09-24-2005, 01:18 PM
google I guess... I have not been able to find one site that is the ulimate source for Excel stuff.

I do have one tip that will keep you from loosing pennies.

=round(your operation,2)

it rounds to 2 decimal places.

as an example calculating intrest or tax

=round(A1*0.045,2)

this takes the value in cell A1 and calculates 4.5% intrest on it then rounds it to 2 decimal places.

I wasted a ton of time on my taxes one year because I forgot to do rounding (I just changed formating to display 2 decimal places).

Ryodlog
09-24-2005, 04:34 PM
sweet, thx for the tip

I-C-E
09-24-2005, 06:37 PM
Balancing check book formula is pretty easy

Say:
Deposit in A
Expense in B
Balance in C

so Starting balance in C1,A1

Then next line in C2 is =IF(AND(A2="",B2=""),"",C1+A2-B2)
And so on and so forth..

Here's how I set mine up

Date -> A
Check # -> B
Debtor/Credit -> C
Purchase Information -> D
Budget Code -> E (Used to make graphs on where my $$ goes)
Depost -> F
Expense -> G
Balance -> E

So the first line of my balance code would be :
=IF(AND(F3="",G3=""),"",H2+F3-G3)

Ryodlog
09-26-2005, 01:42 AM
Sweet, thx for the formulas.. gonna go pick myself "excel for dummies" or something.