From: Aschwin v. d. W. <asc...@bt...> - 2006-11-10 11:39:25
|
Hi, Here at work I am taking care of a fancy coffee-machine that uses a cash-card system for payments, and I decided to use sql-ledger to keep track of inventory and transactions. The idea is not to make profit on coffee-sales, but to charge people only the costs involved. But I have a problem accounting properly for my used inventory. The sales process is as follows: * Cash cards are refilled once in a while and I receive money for this. These transaction are nicely recorded in sql-ledger. * People use their cash cards to pay for coffee-drinks and the machine keeps track of how many times each coffee option is used. These transaction aren't recorded in sql-ledger even though inventory is used, but no money is received. The inventory process is as follows * Inventory is received from vendors and payments are recorded in sql-ledger * I do inventory checks monthly to keep track of use of inventory My questions is: how do I account properly for the use of inventory? The only way I found was to create a virtual customer and sell the used inventory to them after which I rebalance the income account with towards an expense account. I asked an account about this, and she said it was a strange construction. Besides this, I don't seem to be able to get the numbers right for inventory use. What is the proper sql-ledger way of doing this? Thanks for any help, -Aschwin |