Re: [SL] Indirect income and inventory managent

[Jeff V. <jv...@ch...>]

On Fri, 2006-11-10 at 13:39 +0200, Aschwin van der Woude wrote:
> 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,


I don't know if this is SL specific, but it seems that each card should
be a liability for the value put onto it.

Then when used it is a sale that is paid out of the liability.
Each of those sales consumes inventory.

If I read your process correctly it seems the product you are selling
(coffee) should be an assembly that uses coffee, creamer, flavorings,
sugar, etc so it ties back to the inventory and properly pulls inventory
into COGS for it. Maybe one assembly per way the product is prepared,
and input the sales from the machine into SL periodically -- daily or
otherwise.