balance courses in a training center
Zhang Weiwu
zhangweiwu at realss.com
Tue Feb 16 22:07:16 EST 2010
Hello. I am advocating Gnu Cash for a training center.
The training center offer a few courses. Thanks to highly dynamic
business environment they had to evaluate a course and decide if they
improve or cancel the course. The evaluation is done in a simple way of:
payment received from students of the course - payment made to teachers
- room cost
If result is negative, either improvement or cancellation.
I have a rough feeling that if I help them set up accounting hierarchy
differently than traditionally is, I could make this calculation easier.
I would do it this way:
Income
- Main Sales (training)
- Course A
- Course B
- Course C
Expense
- Training
- Course A
- Course B
- Course C
Instead of the traditional way:
Income
- Main Sales (student payment)
Expense
- Room
- Payroll
The balance of the courses can be calculated by copying account balances
of a particular course from both income and expense accounts, and
manually make a spreadsheet like this:
Course Name Income Expense Balance
Course_A 3k 5k -2k
Course_B 5k 3k 2k
Course_C 6k 3k 3k
My questions are:
1. How do you think if my method?
2. Is there a way to automate the process, making use of an existing
gnu cash feature to generate this "balance by courses" sheet?
3. If I want to add automatic "balance by courses" report generation
to gnu cash, how difficult do you think it would be?
Thank you very much in advance!
Best.
Zhang Weiwu
More information about the gnucash-user
mailing list