Working With Categories

[bookkeeper1]

How would I key in categories in an expense summary? (i.e.)
Cell d3 is category description such as rent, when I enter the amount
in d4 such as 750. I want it to go to a specific cell as ae4
I do i reference the cell so when I enter a category in d3 it knows
what cells to automatically fill in such as d3=rent.d4=amount and
ae4=amount again for double entry bookkeeping
Thanks for any help in advance.

 

[Bill Kuunders]

you need to start of with a payments list
use codes for your accounts
i.e. rent might be account # 23
the amount is 750 in column d
the code is in column e
next payment might be for food account # 27

somewhere else you create a trial balance sheet
this is a list of all your codes
it can be on a different sheet
next to each code you can use an array formula or the sumproduct formula
to ad only the amounts with code # 23 next to it.

an example of the array function..........
=SUM(IF(expense_code=B10,netexpenses,0))
to enter an array function you need to hold<cntr><shift> while pushing the
<enter> button.
I have used named ranges here.
expense code is the column in the payments list with the account codes
net expenses is the column in the payments list with the amounts(after gst)
B10 is the cell on the trial balance list with code # 23 for exampe.

of course this system can be extended with a cash receipts list as well as a
journal entries list.

Get back to me if you need more.............
Regards
Bill K

 

[bookkeeper1]

Thanks Bill I'll give it a try.
Thanks again !